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

admin

( \- S6 Z1 q) D- [% a8 e0 G
" x9 R5 C7 \5 `% D2 L4 u* v6 KTechnique  
) M& w: M4 ]8 o1 |; V# O" E/ \There is no difference in setting up a query for a single Item or for many.  Only the
" d) G1 ]2 ]0 J6 u; ~criteria define the set size returned.  In this recipe you create an Item and populate
/ C8 l  y, ~% F# D4 pthe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.
  ?! T# Y3 V; r+ N
8 Q  Y5 ]7 P  G7 o% x
JavaScript  
var qryItem = this.newItem("Part","get");
% H' U! D7 U' H+ B% I! qqryItem.setAttribute("select","item_number,description,cost");
% z' ^+ V/ w; t/ \qryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
var count = results.getItemCount();
& x8 r/ w8 K' b$ t% P, \6 {var content = "<table>";
for (var i=0; i<count; ++i)
! C# i6 W! H8 Z" C0 \* g* u{
  V6 m- ~% d6 L- o$ U# l! t6 O  var item = results.getItemByIndex(i);
7 p7 g. Q& S4 D8 k/ c. s7 W$ J. A4 h  content += "" +
7 k% x& S! I5 d! @; _    "<tr>" +
  P$ O+ u) d( c2 G# n: A6 q# I      "<td>" + item.getProperty("item_number") + "</td>" +
" n) s7 C- G+ w% k+ a4 \) j. I4 s      "<td>" + item.getProperty("description") + "</td>" +
* |5 I) _- c  i: `8 w! Z      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
2 x+ k  E$ d! j7 q$ X" s  C}
content += "</table>";
/ v# z" [! l  g/ j: j3 @8 g9 kreturn content;
3 l  ^4 G1 s8 F8 u  o& _
C#  
9 o3 H3 O4 E% I& WItem qryItem = this.newItem("Part","get");
) G" ^) {6 H" I7 e  w: cqryItem.setAttribute("select","item_number,description,cost");
' X1 D6 a9 s; X& {( g, @# IqryItem.setProperty("cost", "100", "gt");
$ O5 o1 x9 c' S+ N% V# oItem results = qryItem.apply();
int count = results.getItemCount();
int i;
3 S' c0 ^" w9 |* P" o- O+ c# ~6 lstring content = "<table>";
( L0 P. j& l( [$ @for (i=0; i<count; ++i)
{
- K2 Z+ n, E% F& L& s  Item item = results.getItemByIndex(i);
  content += "" +
  Z" Y. k) Q/ u8 Q3 ]9 I  ^2 a    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
; F, d, n; n& G, T! A9 G% B, D& X      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
5 g9 N# D- o* _( c/ |content += "</table>";
; U. v' e% K, \# gInnovator innovator = this.newInnovator();
return innovator.newResult(content);
, E: G0 P5 r8 I5 T, |, Y1 R
- f# d; _! n# g& S1 f+ O* `VB.Net  
% P: L) C+ w7 z0 I3 L) JDim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
: ~7 {: X9 F4 bDim results As Item = qryItem.Apply()
" n  _0 c: R7 N0 Z' T( r: wDim count As Integer = results.GetItemCount()
Dim i As Integer
Dim content As String = "<table>"
For i=0 to count - 1
  s. i' s; u% v' C  F1 y  Dim item As Item = results.GetItemByIndex(i)
8 j1 J1 c4 U4 t  content += "" + _
# c, C6 l. h0 Q. ~; G* v$ x! ^    "<tr>" + _
/ v1 S- k& v+ G9 z      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
7 i: A  |' [, V) q0 ^7 [( q& b    "</tr>"
! X* A! \/ r- G4 b& R6 DNext
content += "</table>"
3 z, F+ b( y0 Q* u
( t& t7 d2 J* R7 I  W4 A& T& mDim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)

* T- U2 u) @% ~' O
$ I! M- n& i9 l  @