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

admin

6 R9 w; W* t( R/ [- ]; N4 k3 E

. {- G0 }3 e3 z/ F9 kTechnique  
# _$ U6 Q# y: R6 kThere 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
, h. H8 V' G0 \1 u' Qthe query criteria, apply it, and iterating over the Items returned producing a HTML
# I$ w- Q- N4 Z2 {  W<TABLE>  fragment.


  @" F/ w. m" F" LJavaScript  
var qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
4 ^/ D! i1 M( O6 Y4 fqryItem.setProperty("cost", "100", "gt");
9 i: j4 U/ V1 E6 c: d- p" w+ |; Kvar results = qryItem.apply();
5 ?" b" t$ w, v5 t0 T$ ]var count = results.getItemCount();
0 a, D( d( o# N0 S" u& F7 n. |var content = "<table>";
8 O0 @: p, o/ ~7 u: c5 Hfor (var i=0; i<count; ++i)
* A$ s" R" K" k$ O- p/ ^3 c  u7 U{
/ F, Q% H% a3 d( l  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
" c# i. m9 c7 L( n; @' A      "<td>" + item.getProperty("description") + "</td>" +
1 S4 G$ j) Z6 D- n      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
- Z# e4 ?$ i1 v8 _) A0 V}
content += "</table>";
return content;

6 `- E; q& g; J8 p' u9 xC#  
Item qryItem = this.newItem("Part","get");
6 O' P% ~4 D7 Z6 ]. sqryItem.setAttribute("select","item_number,description,cost");
" {4 N$ L6 \6 rqryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
, l4 l4 h0 @7 f1 a0 f) R0 N1 w- x$ `int count = results.getItemCount();
* G5 _6 G5 \2 a( Pint i;
% n8 I' M" e3 M' }' d; Bstring content = "<table>";
5 S: w3 Y6 f8 _for (i=0; i<count; ++i)
% J! F3 g7 Z6 Q9 @4 G{
' s/ k- Z) n; f. g1 ~8 Y  Item item = results.getItemByIndex(i);
  content += "" +
/ v) B' p# H% ?2 ~, ~5 Q" J    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
9 x5 @8 M% ?) }7 d5 h' @. L      "<td>" + item.getProperty("description") + "</td>" +
  V8 C: k  b) ?- {      "<td>" + item.getProperty("cost") + "</td>" +
3 @: r) a2 J! |+ _2 _  A5 n" m/ t6 y    "</tr>";
}
content += "</table>";
8 n3 }! H& \4 \; h1 K" G- W- [Innovator innovator = this.newInnovator();
3 @7 A6 `2 D" P  A# preturn innovator.newResult(content);

VB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
4 F, }0 g% j' ~0 V4 F/ i5 ]qryItem.SetAttribute("select","item_number,description,cost")
# W! q, p1 m! H5 k: z7 f( Q8 N! {qryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
) {$ |# _. {) v: CDim count As Integer = results.GetItemCount()
6 W( o3 T" a% j. O: T* UDim i As Integer
$ [* W' l. |' a( f) kDim content As String = "<table>"
& A3 `$ C. [) |! p: }5 }For i=0 to count - 1
+ e1 r% A3 p' ]( @# `- N1 k  Dim item As Item = results.GetItemByIndex(i)
+ [& E. P# X0 q& B  content += "" + _
6 T; I: O  V! Z# K" `/ V    "<tr>" + _
7 t$ @: W$ w7 {, x/ G, h9 p      "<td>" + item.GetProperty("item_number") + "</td>" + _
: w/ u+ S9 i, y) ~4 P7 ^: |: C6 |# J      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
. y* d2 P# ~2 N) z2 z7 M; ANext
content += "</table>"
8 M5 q9 m; l. F' C6 F& }
Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
5 h1 ]# O3 ~- s" j, Z3 w

# l4 C, D+ _1 k