【Aras二次开发】查询和迭代查找item集

admin

0 r! H" c0 D* v. W% f/ i


: G( W. S/ K% X/ e% H3 J" Q$ w- O3 kTechnique  
There is no difference in setting up a query for a single Item or for many.  Only the
! c& @2 ~( c* N, P2 R6 xcriteria define the set size returned.  In this recipe you create an Item and populate
3 u4 T0 z; B' Qthe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.
  Y" A9 R  w- h" V7 z5 W

JavaScript  
' B" r; |7 ~9 ], ^2 v9 gvar qryItem = this.newItem("Part","get");
6 E* P. |9 ]! l2 L/ C$ XqryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
4 N. w1 f; C# t2 t' Ovar results = qryItem.apply();
" o  R# L1 o- a5 z$ yvar count = results.getItemCount();
' s7 R  T& p& E$ f$ Svar content = "<table>";
# E! [/ w6 o& N- L/ ifor (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
9 A" J4 |. l/ l      "<td>" + item.getProperty("item_number") + "</td>" +
2 a2 b$ K4 j* ?) a      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
  t4 A9 \  d$ [2 E" @! v}
content += "</table>";
return content;
" ^! ~0 j2 g3 \- p7 s
C#  
Item qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
# z# J- T1 u  yqryItem.setProperty("cost", "100", "gt");
. f" ^* h, P8 C- t- n& YItem results = qryItem.apply();
# c, J$ c$ l6 I% ?6 A+ X4 _int count = results.getItemCount();
int i;
9 ^7 Z; T7 U+ _2 h0 E( Q' Cstring content = "<table>";
for (i=0; i<count; ++i)
+ ~& F0 N! e5 v; Z& W% F8 e, y; i: S{
7 v: ?1 u/ M+ W  Item item = results.getItemByIndex(i);
2 V% W) }3 c' z1 p6 r# k0 C& T( H  content += "" +
    "<tr>" +
2 ~' Q( ^& n" \7 A3 U0 j      "<td>" + item.getProperty("item_number") + "</td>" +
+ I7 r- Y7 z4 ]1 V8 d1 z      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
( `# d6 L" Z  q0 C. _1 ^    "</tr>";
, V( Z' w# u3 t" O6 l  U  p, P}
content += "</table>";
Innovator innovator = this.newInnovator();
return innovator.newResult(content);
8 P4 m& T* h' c: A
VB.Net  
1 N8 W4 Y+ }  HDim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
- o/ V; _; B$ }+ \# r2 _$ J" ADim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
7 o$ M. h* ^/ o' V* A: f; dDim i As Integer
Dim content As String = "<table>"
8 S! A$ Z, |$ WFor i=0 to count - 1
7 p$ @: U! c0 f& o  }: {  Dim item As Item = results.GetItemByIndex(i)
! {: w( a9 r, y8 B% v  y$ K7 ?7 K6 b  content += "" + _
" D- `- A7 e1 {3 i& e" p    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
( I, e3 l: g2 m* P      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
0 S8 f" a; G1 D/ h7 g$ J/ s6 oNext
content += "</table>"

  d0 E/ I) M3 zDim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)

, ~  G" H4 S' a