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

admin

$ m' U+ P( P$ f: z/ {; C* P
7 k  |$ y6 n) u0 \) i* x8 s  u/ \

+ C" ]7 j  P% wTechnique  
1 Z  Q5 z5 W" u/ KThere is no difference in setting up a query for a single Item or for many.  Only the
# A+ M- }/ l2 scriteria define the set size returned.  In this recipe you create an Item and populate
4 Y; j9 H8 P3 Z; L- E% Y" K; Dthe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.

9 p) U* C4 M1 m5 p% S" j
JavaScript  
' _- A0 @  ?( fvar qryItem = this.newItem("Part","get");
5 F4 _; T$ |& Y3 K( v& L  x2 c2 xqryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
- Y9 W3 ^! D, e$ l: d5 bvar results = qryItem.apply();
) C7 I1 \3 v% K9 `+ jvar count = results.getItemCount();
9 n: P3 Q( J6 c- |var content = "<table>";
( F! D" z( I# ?* Rfor (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
  content += "" +
4 d" J0 H% b2 J( L/ Z' B9 R    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
content += "</table>";
( x9 }5 N* C9 s' S8 Kreturn content;

C#  
+ A, P: E$ d9 T3 e. lItem qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
( x. Q8 b9 [6 BqryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
3 q% o* \8 [8 L4 V/ pint count = results.getItemCount();
* H% `+ Y; [5 E( Rint i;
$ K$ d3 L0 A5 q, Dstring content = "<table>";
for (i=0; i<count; ++i)
{
! I- l0 p3 K/ O$ e5 k  Item item = results.getItemByIndex(i);
  content += "" +
( W9 Q& C9 Y$ e+ `    "<tr>" +
. ], O" m: z! k2 n' m) q      "<td>" + item.getProperty("item_number") + "</td>" +
7 Y1 ~) [0 v  H" x0 @      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
& p" r* Z! h- J4 S1 K$ t5 t    "</tr>";
}
* J/ T5 a( J6 e8 R6 ^& \content += "</table>";
Innovator innovator = this.newInnovator();
return innovator.newResult(content);

VB.Net  
' p2 |' p5 e" g6 BDim qryItem As Item = Me.NewItem("Part","get")
) ]& R6 {6 }/ i8 UqryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
' s$ q& {. ^. F3 `- g* j: _3 sDim results As Item = qryItem.Apply()
* u& a. M, E5 a! vDim count As Integer = results.GetItemCount()
8 U  i1 y/ r7 [2 N5 R/ y# EDim i As Integer
9 Z4 w1 A* |* QDim content As String = "<table>"
For i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
2 g  x4 m4 a1 v! |  content += "" + _
( J9 B" I9 ~9 b( F- z, `( X4 d8 L    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
+ w4 K8 \# o4 X; q7 s: a: i, x- lNext
2 J2 @/ ?; o' w9 x6 ?content += "</table>"

4 h& ^0 r  `, K& ]Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)

% ]; P1 Q* [( _; m0 P/ P) M* B- }