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

admin

Technique  
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
the query criteria, apply it, and iterating over the Items returned producing a HTML
( d6 ^4 T' v! Z$ W0 M4 ^0 V<TABLE>  fragment.


& i9 M3 N; g  V9 @5 O0 A" k5 s4 }+ EJavaScript  
% L5 M- }' _/ j- |* D" j2 wvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
4 _9 f# v8 U( z! N6 j+ k2 w3 NqryItem.setProperty("cost", "100", "gt");
3 w; [) p& D& Svar results = qryItem.apply();
4 N1 G! y' r1 k, F! U1 E( R$ Gvar count = results.getItemCount();
2 M* W7 N. l" R  P. R( yvar content = "<table>";
for (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
8 k- Y  _) [! K  content += "" +
2 z- b* k- n+ K$ }# t    "<tr>" +
. q9 \1 }6 `& H( Z9 K      "<td>" + item.getProperty("item_number") + "</td>" +
/ o" f5 A, g+ s+ p2 N6 ^      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
/ L- ~& e( q1 i) b% A# U' ]0 P& g}
& X; \* [; h5 Y6 r/ K$ E  ?- J* Zcontent += "</table>";
return content;

C#  
Item qryItem = this.newItem("Part","get");
2 Y5 L  z+ \4 P: ]" ^qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
, d5 N1 ]# K! \2 e; K# IItem results = qryItem.apply();
+ h' c  Q7 }3 k- f% F3 `* fint count = results.getItemCount();
0 F: }0 m0 k$ U6 @! B: Aint i;
* J0 K3 A* M) i& nstring content = "<table>";
for (i=0; i<count; ++i)
{
9 q6 N5 c( K( l4 m4 T  Item item = results.getItemByIndex(i);
3 H7 c2 ?- Q; e! K. B  {2 Q0 ^  content += "" +
3 A' I! r" ]) g% ?. Z% H    "<tr>" +
4 i, o! d+ ~# @# f      "<td>" + item.getProperty("item_number") + "</td>" +
: @8 k' o$ S+ V. l" w  h      "<td>" + item.getProperty("description") + "</td>" +
2 V) Y2 ]* Q& B2 H! B# G+ W) B7 T      "<td>" + item.getProperty("cost") + "</td>" +
3 u& S: f8 b1 Y+ _: U& Z- X  b    "</tr>";
1 o2 A( z7 c# h( ?% z; N}
content += "</table>";
9 |5 o4 P) d- B1 a6 qInnovator innovator = this.newInnovator();
return innovator.newResult(content);
$ x  S' Z0 h8 y( K6 J$ c
# h+ Z  r2 f# o  G$ jVB.Net  
9 A5 [/ Z5 E# f$ lDim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
6 F0 _( Y5 E2 P7 v1 I+ T* iqryItem.SetProperty("cost", "100", "gt")
7 t9 W" p3 k& K# s6 m2 V- v. GDim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
Dim i As Integer
* D6 F& a, W( |Dim content As String = "<table>"
7 z- W4 ^" Z8 j" j2 e, pFor i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
! t( G* S! t# f/ a2 S. y6 i    "<tr>" + _
5 e( |  Q. p* l6 ]      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
2 B: s% j7 D4 z! ~      "<td>" + item.GetProperty("cost") + "</td>" + _
3 H7 z% O/ s8 Q7 }9 z5 K* ~: G9 W    "</tr>"
Next
- T1 d$ M% @8 x" ncontent += "</table>"

: w( y, k4 r& a: T* dDim innovator As Innovator = Me.NewInnovator()
% p6 U9 K% |' t1 \* z) h* Jreturn innovator.NewResult(content)
( X; ?& M- S4 L3 p4 v! }- v) R
/ s' j. T+ R0 |