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

admin

1 }# f# b* h$ P& q; l, i
4 a' K8 h% G, v7 \
9 [3 Y! F$ v7 D1 g* ^
Technique  
! p" Y3 F: c9 P3 l" L/ b" dThere 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
# x) k5 K: q# I* [, P2 nthe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.
) G/ i2 H9 n4 L9 k4 I" |

JavaScript  
var qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
4 ]  {% U3 B) O5 O0 h' k' kvar results = qryItem.apply();
var count = results.getItemCount();
* R2 v+ r7 x3 {+ w1 K$ p9 tvar content = "<table>";
for (var i=0; i<count; ++i)
2 e# Z8 G* A* i' f  ]! J4 n( l: [{
  var item = results.getItemByIndex(i);
( }  y/ ]3 y; u1 f+ a4 S. Y7 Q  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
4 p) w; D' F( q, t. E' Z}
9 t" Q1 Y/ L) U4 q! g1 c7 ~7 Gcontent += "</table>";
" B/ a" }7 f3 Z; yreturn content;
3 F: R7 [* N  |! {
+ V$ [4 y' A) s! M; F3 BC#  
) M( _$ f. a* s4 yItem qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
9 ]! S, s# q5 _" s" ~8 E9 XqryItem.setProperty("cost", "100", "gt");
9 c; M- \4 |! D  P, a- \( G- xItem results = qryItem.apply();
int count = results.getItemCount();
: O( ?9 i4 h, i5 q3 hint i;
6 `; M8 e/ r* istring content = "<table>";
- A6 m! r1 o; o% y# R$ Nfor (i=0; i<count; ++i)
{
: |; g7 |3 {7 Z  Item item = results.getItemByIndex(i);
' k5 r$ J: ]* X4 N1 R' Z  Q$ J9 A( j  content += "" +
$ d! f3 _; `$ T7 E& l# [9 `# ~$ G    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
  q9 U7 K' m4 e/ P  S$ S! }0 G/ q      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
, N& i/ L+ X& d! {}
content += "</table>";
Innovator innovator = this.newInnovator();
# z2 K& p$ N" b# u- y3 W% Zreturn innovator.newResult(content);
* w0 d( M/ }3 K% I7 Y. w
1 D- g. H9 u3 z# @3 H( _2 PVB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
3 k, d/ |% G2 I7 g: J- MqryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
6 w, J3 y+ f) w3 v+ NDim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
$ i" B% u) J/ }! P$ EDim i As Integer
1 k. ?- d$ J4 M1 {$ UDim content As String = "<table>"
2 @% V7 C! B6 }% A1 v5 vFor i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
    "<tr>" + _
* a! f) j% U" H      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
# F: ?( |# R2 Z5 s  T    "</tr>"
  p  F, ]1 {( @5 R/ w4 e6 q% gNext
2 [: K! w- r( q7 R$ Pcontent += "</table>"
4 G& ^) ?; {5 G, x' f' \' ^3 R
Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
, \$ H) A3 f  Y7 N, G! f. \
- G5 t% ^! h: s9 c# V" ^