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

admin

9 B+ g: b8 t7 i( {5 f* {

: L( P& f2 \  ?7 g( C% a- [
Technique  
9 J$ W. e( C" HThere 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
, U' R6 b3 l9 _the query criteria, apply it, and iterating over the Items returned producing a HTML
+ }* o' {0 R0 |4 I& @<TABLE>  fragment.


JavaScript  
var qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
. N" S1 W- ]2 o) F2 s2 W) Yvar results = qryItem.apply();
var count = results.getItemCount();
var content = "<table>";
! I4 E6 s) n8 p' A4 \. d/ efor (var i=0; i<count; ++i)
9 [8 j1 ^; I$ Z: K- P2 `( l{
" `* c, `" u0 E, G  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
8 U. y0 m1 l. y9 o, A+ o) v1 C    "</tr>";
5 b! A% w" J/ Y" C: j6 O# D}
: ?. o7 ~7 |- Q- f; X2 r2 Tcontent += "</table>";
return content;
5 p$ z: E& y9 r! S
C#  
& \. `6 c. x+ s% ?. B5 ~Item qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
3 l( Q9 {. i& ?7 G) iItem results = qryItem.apply();
& C& T% s0 Y' U* |int count = results.getItemCount();
int i;
string content = "<table>";
for (i=0; i<count; ++i)
* L; A$ \. U& Y& o( s{
9 L+ X  O- O" q: F( C* B4 @: k0 C  Item item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
4 M! d2 {0 d9 f* h      "<td>" + item.getProperty("item_number") + "</td>" +
  Y$ g. |! Q7 O, Q2 W      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
- g- R9 R- |5 ]; Z0 \) w    "</tr>";
}
8 @* ^: O3 q  g9 h$ ^3 P0 q6 Wcontent += "</table>";
Innovator innovator = this.newInnovator();
# t7 N/ V: i. Q* V: Ereturn innovator.newResult(content);

VB.Net  
0 }& u9 v( B# aDim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
  f+ m! x# z1 _/ L: ~Dim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
1 z2 d7 v& r% C( _* eDim i As Integer
; C9 X+ C- K- [& ?5 mDim content As String = "<table>"
For i=0 to count - 1
8 S* G3 W! m$ |( a$ R: t  Dim item As Item = results.GetItemByIndex(i)
% j) m  Y" Q9 Q3 e  content += "" + _
    "<tr>" + _
  B6 T5 b- |9 {% k      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
5 O. R; _- C6 R* wNext
. c  g/ K6 R5 F! K3 rcontent += "</table>"
. M0 k" h1 N, C" H
3 R8 R0 P1 T8 p* d: E' l, w8 gDim innovator As Innovator = Me.NewInnovator()
, D1 Z* J9 y- _6 C$ C% `9 u8 F/ [* \return innovator.NewResult(content)
, |6 ~4 H( v' Y+ f3 y1 o

! V) G  j9 \1 h2 u( _" k