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

admin

! M8 z  ?$ u* v! d
+ h  _3 B% ~3 `9 D* E
/ A( v0 d0 w* \' d) C. s7 j
3 a* _5 t% j+ R! d4 y  ~$ {6 Z* tTechnique  
2 ?! }# _3 G3 z3 pThere is no difference in setting up a query for a single Item or for many.  Only the
0 K+ w! Z1 X: j( N" |criteria define the set size returned.  In this recipe you create an Item and populate
2 }+ L5 ?1 {6 f  {the query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.


# s' I! P+ O% \. B/ w) u& xJavaScript  
var qryItem = this.newItem("Part","get");
4 n. m( g8 ^5 }8 T1 kqryItem.setAttribute("select","item_number,description,cost");
5 J2 p7 K5 i' T) n/ L  C7 U' r$ W) xqryItem.setProperty("cost", "100", "gt");
5 l& `( I7 M) n5 F& yvar results = qryItem.apply();
: p  P/ F3 ^  ]4 t8 ^, m0 hvar count = results.getItemCount();
9 S# j& P  ^0 ?' evar content = "<table>";
. c: }1 Q9 ]; m9 A% T- Q" S4 ^* J- D6 pfor (var i=0; i<count; ++i)
{
7 O1 n+ m) o5 b' l' ?# b  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
6 e+ I& g3 U' `3 B. }+ o; h1 w6 w  }      "<td>" + item.getProperty("item_number") + "</td>" +
8 L- W7 O0 s: p. z# c# l5 _1 Z/ I      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
8 O9 u0 K% d" a; ^    "</tr>";
}
# ~; p- |/ H: h" Y0 F& A" icontent += "</table>";
return content;
, m3 N8 ?2 ?% g% t8 L0 W/ u9 ^0 u
* b$ Q# s" Z5 ]% C' s5 g9 JC#  
Item qryItem = this.newItem("Part","get");
) h8 f$ `7 a/ m/ N) o! s- u% e( z3 CqryItem.setAttribute("select","item_number,description,cost");
8 q5 s; v, i* pqryItem.setProperty("cost", "100", "gt");
( _& \7 i& d, R7 v3 sItem results = qryItem.apply();
0 F3 {" C8 j7 O* E9 K+ mint count = results.getItemCount();
int i;
& x$ K' i  H+ @1 Q+ V( wstring content = "<table>";
+ N+ S* P- H. Q; n8 x$ h% M7 Rfor (i=0; i<count; ++i)
. ?" m+ W5 \3 `{
- n3 A) Z! X( `0 Q6 H# g8 p  Item item = results.getItemByIndex(i);
3 }: ?: f1 {7 H  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
0 Y0 E" c/ {* A+ K$ R2 m3 U* M! T      "<td>" + item.getProperty("cost") + "</td>" +
/ n9 a' Y" Q' Q- b  |    "</tr>";
}
' u0 _+ h) n) B) Z* I1 kcontent += "</table>";
Innovator innovator = this.newInnovator();
/ D$ p/ `$ q% M* Nreturn innovator.newResult(content);
  p/ b" c/ ?/ Q# F0 v
) c$ N7 m- v) }: q) g; t1 j8 J9 iVB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
% H! `! P: r2 [8 {+ v& F, M. H3 W% UqryItem.SetAttribute("select","item_number,description,cost")
- T: Q3 k4 V& D/ eqryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
3 t1 y4 Z7 S- HDim count As Integer = results.GetItemCount()
2 p9 R# x) i3 g5 C! D, mDim i As Integer
Dim content As String = "<table>"
For i=0 to count - 1
$ t7 d: a7 k% m' R, ~" V, D  Dim item As Item = results.GetItemByIndex(i)
: o5 T6 ~: ]& r% q7 \  content += "" + _
" @( m2 Y* E/ x( K+ [3 b9 J1 p    "<tr>" + _
; D$ Z- `/ h! h  f. P( s6 \      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
( {5 J0 l* T+ u3 _+ M0 h$ ]    "</tr>"
Next
5 B* M/ r+ J& Z- J$ e# e3 }content += "</table>"

Dim innovator As Innovator = Me.NewInnovator()
! v! E  l+ o  P, h( a4 ireturn innovator.NewResult(content)
' X- T" g" y3 R1 w
9 J& O8 q; C$ E' T) K% O9 I
" R9 H+ a9 |& o; e, [1 _