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

admin

! J  Y9 A$ U& i' @5 z0 \, vTechnique  
# U" A) I0 f; |1 Z2 }There is no difference in setting up a query for a single Item or for many.  Only the
criteria define the set size returned.  In this recipe you create an Item and populate
1 D, H/ S: [: c! E, Ethe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.
; R$ R8 S- p3 h
/ X' E$ h! t0 K3 Q) b, B7 D. q
5 b7 R( E- [8 o4 _. |* rJavaScript  
- o! w, A- U, A- u5 s7 \: Hvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
" k: @# ?- h6 p4 Q1 O+ aqryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
# i7 D+ }( m; l2 O  ]$ zvar count = results.getItemCount();
var content = "<table>";
for (var i=0; i<count; ++i)
{
+ l4 N* u4 c" v2 B- t  var item = results.getItemByIndex(i);
0 T2 d2 s9 g+ {! P& o7 y  content += "" +
% Y) `7 `. A& W+ w( u3 q    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
, \% Y. g7 N) u: K$ g( _    "</tr>";
}
content += "</table>";
+ z6 {9 Q' A  @6 m5 \3 V/ Q7 {) vreturn content;
+ g# \6 {& W* M3 o4 c
C#  
Item qryItem = this.newItem("Part","get");
2 o5 c6 T' ~! x% K3 Q) t; jqryItem.setAttribute("select","item_number,description,cost");
' y4 x/ x5 h7 B  x- l9 HqryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
int count = results.getItemCount();
# G$ u  q- r7 m0 z+ V# ~) p, [int i;
/ D+ ~0 |* C0 a, i+ w: u! rstring content = "<table>";
7 _6 E* y. q8 r# r4 q0 h+ G1 O4 G8 Z) cfor (i=0; i<count; ++i)
+ W8 O' a8 r: w& j1 u9 I{
+ k. W% S3 ?' C; N8 @" e% l/ a: s% w  Item item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
* l" H6 P  A+ ?' r# j* g+ D- L      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
3 T( Y: T' m7 o& a4 ~" h/ ^2 X+ U}
content += "</table>";
Innovator innovator = this.newInnovator();
5 a2 j; y, u2 dreturn innovator.newResult(content);

VB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
  |. W' R' P  x3 J6 i8 }' uqryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
0 c2 |9 A! F+ T6 `, n$ R0 w7 hDim i As Integer
  `# s5 [$ _8 [% ^% M  ~: QDim content As String = "<table>"
For i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
6 P/ H. K6 G6 `5 c% r0 {# ^. V  content += "" + _
    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
2 |* B1 S6 E/ M0 |" {      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
4 j# C3 n1 ?" P# L& M- S' ]8 fNext
- m7 H/ B( c1 _1 E7 ycontent += "</table>"

Dim innovator As Innovator = Me.NewInnovator()
" x! H1 Y" U3 I2 Y: Oreturn innovator.NewResult(content)

7 Q- J0 ]( T% ?) s8 D