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

admin

3 m: E3 Y8 }; \5 ?& g9 n& x

! G9 `. O& _! P+ D
Technique  
" H" T* y, c6 BThere 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
3 f7 i+ z7 F1 t! T, l<TABLE>  fragment.
$ |, r3 r. v" G9 m9 A4 H2 i

7 g: V- x0 i' u# cJavaScript  
var qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
. N$ ?( {; ?% y2 dvar results = qryItem.apply();
var count = results.getItemCount();
var content = "<table>";
for (var i=0; i<count; ++i)
{
( i* K( b7 F) k9 u  var item = results.getItemByIndex(i);
  content += "" +
; A- G! j" Y" F7 G    "<tr>" +
: d+ {/ B& t+ Q1 k. l& `      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
1 q, a& G1 M5 x  |8 ]6 @      "<td>" + item.getProperty("cost") + "</td>" +
% x- S0 {- X+ U/ Z) {    "</tr>";
}
content += "</table>";
& D; b; h9 }# g( H5 }4 Rreturn content;

+ O% [3 i/ W  e8 J$ BC#  
" I, B% _$ n3 e/ M/ Z  KItem qryItem = this.newItem("Part","get");
/ @" S/ |2 T9 M' y9 ^: ~qryItem.setAttribute("select","item_number,description,cost");
- E8 D! ^* N4 j1 a/ M8 `  Y( P+ XqryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
int count = results.getItemCount();
7 n! u5 n, ^- kint i;
* |7 F# p# o6 W4 Xstring content = "<table>";
for (i=0; i<count; ++i)
/ Y4 s/ G* P& m2 L5 x3 Z0 p{
  Item item = results.getItemByIndex(i);
+ J1 K7 D2 d0 d9 a3 u1 J  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
7 v5 L: R  I9 R! u( ?      "<td>" + item.getProperty("description") + "</td>" +
" S+ R: q# h$ \3 I2 j9 K      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
2 \0 o( `" f+ ]' W0 qcontent += "</table>";
: Z* \% g8 a5 ^3 S3 BInnovator innovator = this.newInnovator();
return innovator.newResult(content);

" E& t7 N; }2 MVB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
: N* U$ Q- J4 ~4 i) @Dim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
$ S9 d: {2 ~+ r% H8 LDim i As Integer
Dim content As String = "<table>"
For i=0 to count - 1
6 {3 E$ {3 @$ Z  Dim item As Item = results.GetItemByIndex(i)
5 X1 }! Y1 U+ N  content += "" + _
; A- B; R9 N( `9 m    "<tr>" + _
- N  ?; e+ d3 C* O9 {! }      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
8 E( M: I, d& D' |* H      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
8 i2 a7 f# y9 j: b8 l& ^Next
6 _# w* |/ L( Q: j" k$ scontent += "</table>"

Dim innovator As Innovator = Me.NewInnovator()
  |; z9 z; q; f9 Z* }7 J0 Greturn innovator.NewResult(content)
& z* Q5 |. r6 J