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

admin

* R4 E7 l/ G. [0 V. e2 i
/ t! y, y, p1 w  s: J9 e
; E& ^8 y) K# W3 y" iTechnique  
There is no difference in setting up a query for a single Item or for many.  Only the
3 ~/ M) h% f' jcriteria define the set size returned.  In this recipe you create an Item and populate
the query criteria, apply it, and iterating over the Items returned producing a HTML
; T& t3 ^* J* h* B) Y4 O( d$ S<TABLE>  fragment.

$ Z! L5 O) I4 |. z2 }' y1 f7 j
JavaScript  
$ Y, `9 r) l  z8 X& H1 n  Vvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
6 z+ s3 Y" C& n  ?qryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
var count = results.getItemCount();
! ~/ q# Z+ R$ R. j# I  |var content = "<table>";
4 N' N! a8 k4 l( T. \* ofor (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
! Q: V$ z5 v: k9 L8 [( f+ X6 u/ F+ I  content += "" +
    "<tr>" +
9 ~& q$ O% `7 p( ~      "<td>" + item.getProperty("item_number") + "</td>" +
4 X+ W2 _8 \+ L% L0 ^& @) q      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
8 A' L, I5 o7 K9 u. Q1 Q    "</tr>";
}
* c; _' [# b* L; ]2 ?* ?) zcontent += "</table>";
return content;
' g* Z0 w9 S2 t6 v/ i
, [, P  Q2 R5 d( cC#  
Item qryItem = this.newItem("Part","get");
2 B/ d" A7 U  @. m# I; Q' \qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
" m: A$ W' A  }6 {( iItem results = qryItem.apply();
& X7 @" P; W2 r# Q( N. q+ B8 d) ^int count = results.getItemCount();
int i;
. M; r: ^' K; k# N( ~# tstring content = "<table>";
3 e7 \+ S. h" d  @. pfor (i=0; i<count; ++i)
6 R% f) }% |8 c( e" c  \7 j{
+ U/ C' V4 f3 x' s  Item item = results.getItemByIndex(i);
/ r4 p9 Q$ Y1 j" p$ ^  content += "" +
% w3 G' ^  n' B9 s    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
" v6 `! f- y& D6 P; Y& ^6 j3 f      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
5 e+ O6 ]. y( y" q4 \& z8 Dcontent += "</table>";
Innovator innovator = this.newInnovator();
return innovator.newResult(content);

% M) a$ i1 f5 e0 Y$ m# |! x+ j! h2 AVB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
0 E7 U6 C' V! K/ z3 N2 H; M3 CqryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
5 j- o. _6 o- p! DDim count As Integer = results.GetItemCount()
+ A0 y, C3 N4 R3 p- I* H; W8 G: _Dim i As Integer
0 A9 S1 m1 c/ Q. Y6 LDim content As String = "<table>"
0 q3 k3 F  x) ~3 Q  W, c8 r9 b( CFor i=0 to count - 1
/ u  S. }6 G% a" Q' A$ p  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
6 U* x9 ?  d0 d" `! ^$ }7 ?    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
* p0 B; W, ?3 L% V3 Y1 d5 I    "</tr>"
Next
content += "</table>"

4 O/ ?9 K1 n5 E1 t: m: C# e3 B% }Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
; M8 v/ T: n( j# a2 s" N9 v! P

3 d- H' b  l  d8 O' u