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

admin

; m! G, M4 w& U; e+ e7 cTechnique  
There is no difference in setting up a query for a single Item or for many.  Only the
$ {+ [5 a7 {9 R; Q- k- Ecriteria 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
0 V2 D' E6 v4 I  d, v. t  ?( r<TABLE>  fragment.


JavaScript  
. Z$ C  T  ]) b: q1 D+ W) Gvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
5 V; h8 e7 g: c" R0 zqryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
var count = results.getItemCount();
- c1 C3 O/ v; k- y" ?# Wvar content = "<table>";
. p) y# q) y5 E! g' Q: j7 c" b) z$ rfor (var i=0; i<count; ++i)
, `9 N: D0 p* Q1 Y. _3 G{
  var item = results.getItemByIndex(i);
  content += "" +
; T- j. \) _- {6 D    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
/ j* M& k5 H, A& u      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
4 D3 b; ]7 m6 i: ~8 p4 i    "</tr>";
) @" L0 T1 `& u+ e& ?3 Q}
content += "</table>";
return content;
7 }- m0 u  F9 T& R$ E8 H0 E: `: F
) s! L) b. s4 R5 ~$ K' X+ |1 ZC#  
2 B7 v& X, d% ?; U' TItem qryItem = this.newItem("Part","get");
: V1 `. ?) _. I. z/ N9 P  w1 t1 ~6 nqryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
6 h4 Q9 n; c& B9 rint count = results.getItemCount();
1 Z' a8 O+ s( @- F+ d/ Y' ~int i;
! @$ d4 F; y( h. C6 o' a: ^string content = "<table>";
for (i=0; i<count; ++i)
/ I; G( e$ A* ?{
  Item item = results.getItemByIndex(i);
; F7 K# j& b/ n  content += "" +
% P+ u- v/ _% T4 _) C6 u    "<tr>" +
7 z$ V( A) ]" q8 S5 n( Z0 g- d/ z% o      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
9 J0 z  N" |# {2 Y3 V}
content += "</table>";
( \: q( e2 Q5 ]Innovator innovator = this.newInnovator();
- j: l3 P2 L! G5 f; o' q& ureturn innovator.newResult(content);

VB.Net  
" I5 `! K* O$ TDim qryItem As Item = Me.NewItem("Part","get")
6 I% l' w4 p6 U" ^qryItem.SetAttribute("select","item_number,description,cost")
' t8 k2 d9 R# L/ g) CqryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
; S) U$ _9 r, @' }! U& WDim count As Integer = results.GetItemCount()
" c* q5 ^3 N+ M- \6 N5 C8 XDim i As Integer
- D7 d8 B: V. y6 h$ IDim content As String = "<table>"
For i=0 to count - 1
% t# l1 u' }# Q  J  Dim item As Item = results.GetItemByIndex(i)
, z* F6 y( R6 _4 Q  content += "" + _
    "<tr>" + _
: ~: a. {' m; q3 K/ O1 S      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
- @1 c0 U" r  d- |  W* E0 W      "<td>" + item.GetProperty("cost") + "</td>" + _
# \% I& R  C! c8 ~* z    "</tr>"
Next
content += "</table>"
) X8 ^; d7 }$ g
Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
7 |' b6 [- x: T1 n( g1 K2 q4 E