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

admin

7 D* c$ B2 K0 v$ P- O, C# q7 Y" q
6 J( n0 p$ }3 Z! X/ T9 z0 b6 q4 z
Technique  
8 B# q  r! f# S5 s0 F3 Q5 eThere is no difference in setting up a query for a single Item or for many.  Only the
/ n- k8 x! ]: _1 Zcriteria define the set size returned.  In this recipe you create an Item and populate
3 ?& y. Y) |/ s) N, Z& pthe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.
" ?3 ~* W7 E9 X+ n

JavaScript  
5 l+ Z$ P. R/ Y3 ]$ k  gvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
1 U- N# F( Z" L' }var count = results.getItemCount();
$ E/ W) {+ f+ P5 ?. ?var content = "<table>";
/ G5 N" m; m" C( @8 G  K# w; C3 ^1 Ffor (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
. z) v  b7 }  S' p$ `0 v  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
* J" a, [( L; ?' w: y}
content += "</table>";
return content;
+ c: e2 q( b% ~0 T* ]
C#  
Item qryItem = this.newItem("Part","get");
" M! D4 j* G9 E7 I$ IqryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
6 G2 H- N" s+ W1 s5 d  x6 SItem results = qryItem.apply();
9 D2 F$ F  V  d0 U, Jint count = results.getItemCount();
6 ^3 y' D5 J4 N1 M- Mint i;
: h2 t3 W- C; W# l: [  c' [string content = "<table>";
for (i=0; i<count; ++i)
{
" ~% F. }; V/ H# j5 ~+ S+ R! n  Item item = results.getItemByIndex(i);
: @; Q/ O0 i. O! W  content += "" +
+ W! n: s9 _' k/ x# c5 q    "<tr>" +
7 W4 \3 w) \& Z' {2 U      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
5 F& t$ V+ {; u& H    "</tr>";
}
content += "</table>";
Innovator innovator = this.newInnovator();
return innovator.newResult(content);
0 U) B6 u# I3 p% Z' e" r* m
' X  V& {) w6 e1 G/ `4 OVB.Net  
9 f) F  q3 G& m& UDim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
' c# L, U$ u6 \% wqryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
1 ]+ E2 j+ ~; ~' r6 F: hDim count As Integer = results.GetItemCount()
2 ?" Q- J4 Z6 s, K  ?8 Y/ bDim i As Integer
9 f) H1 b1 w3 b' _Dim content As String = "<table>"
For i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
1 i: A  U/ G& L& n' @; `0 [: L    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
8 H. r$ V% d5 S! \# }      "<td>" + item.GetProperty("description") + "</td>" + _
: h+ Z7 A; H# b' F) H$ A      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
Next
content += "</table>"
* d" s1 `  C* ?
% k, v2 I2 G' ^" A" E4 _" aDim innovator As Innovator = Me.NewInnovator()
3 j) R0 E" q& p( b6 Freturn innovator.NewResult(content)
* j* M+ U2 t9 K) f6 M# X" S

3 f3 G& q8 k2 }) z$ v- A