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

admin

* s5 r) j2 e8 O3 L8 v( T* l
4 ]& `: Y) G) |9 T+ ~2 a% v* T
8 e# j: ^' b7 a) W
+ v. C/ p, ]* F: }, x7 M3 p0 i) W0 ATechnique  
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
0 s9 k" a. B& s9 z3 r' `the query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.


8 u( b# V- D; ^. B) }- ~2 J: QJavaScript  
' u" [6 a. z7 }8 q  t3 G6 tvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
& [8 b7 Y; \" v" M  z9 ?qryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
, @6 R+ C# x5 jvar count = results.getItemCount();
var content = "<table>";
3 p6 O- ^6 Z9 qfor (var i=0; i<count; ++i)
{
# E7 E) ?: L, ?6 J" A5 d! {  var item = results.getItemByIndex(i);
+ U% O* e1 O5 I+ a  content += "" +
# g! q- M: Q; H: W! {; m    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
0 ]5 E7 t2 ^) [& k. v      "<td>" + item.getProperty("description") + "</td>" +
1 Y9 X7 R% V* O' x      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
- o; g3 M. Y* Ccontent += "</table>";
return content;

C#  
  q. [( v' o; x8 n; B' iItem qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
/ ~( A! q+ k. U2 k5 s. _. ?, ?qryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
int count = results.getItemCount();
int i;
string content = "<table>";
for (i=0; i<count; ++i)
, s) P5 @! n* E7 H& s- q{
  Item item = results.getItemByIndex(i);
; L( K, p& a. r+ o% P" [5 e  e" O  content += "" +
4 Q) B4 k7 l$ |' T+ [    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
; w7 l5 x- J3 Y$ c8 Y7 H3 }      "<td>" + item.getProperty("description") + "</td>" +
! K1 A: [: i8 X8 H" }, @  h8 T7 `' |      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
& R, p4 Q5 M9 S) l0 |0 Q' x+ V, Icontent += "</table>";
" E1 n* i4 f$ B! Z# BInnovator innovator = this.newInnovator();
$ g( `, l" e) Y- ~4 O# }4 qreturn innovator.newResult(content);

/ r2 U* S$ ~  D( n) qVB.Net  
0 e* z0 d& \6 P+ Y4 Z/ tDim qryItem As Item = Me.NewItem("Part","get")
- \( ^% o- W/ nqryItem.SetAttribute("select","item_number,description,cost")
) {. M. q# T0 `, ~" m+ x" p/ UqryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
Dim i As Integer
Dim content As String = "<table>"
  g1 a# _. H& a, d1 b3 rFor i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
3 N& p" x4 V. p      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
  k, Y/ H: i9 g: zNext
( C. t3 j" ~6 x+ l/ U0 U: Ccontent += "</table>"
3 F- r5 O& `7 w5 q" k& Y
6 m8 H  C' V$ s1 J& N8 Q" F% PDim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
& H" p7 u4 v3 Y( L3 n