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

admin

' I$ d; p: M' T7 A. f

# @9 y7 o: {/ g1 qTechnique  
There is no difference in setting up a query for a single Item or for many.  Only the
! `. D8 K0 V8 ^+ [- H, scriteria 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
3 T! u" H6 o$ ~<TABLE>  fragment.
" ?1 I5 N1 K! i

JavaScript  
, m+ n6 {: b* vvar qryItem = this.newItem("Part","get");
8 `; Z8 v1 c1 v; N9 z1 [qryItem.setAttribute("select","item_number,description,cost");
+ C: K! @' k5 }8 j! [7 P! }* Q* CqryItem.setProperty("cost", "100", "gt");
' C4 ^2 @8 W  T$ Q( F4 Gvar results = qryItem.apply();
var count = results.getItemCount();
' n' I  t7 }7 `8 Tvar content = "<table>";
for (var i=0; i<count; ++i)
. b6 t, q8 t6 i% f: I{
  var item = results.getItemByIndex(i);
+ H  |7 H9 L8 e4 E5 R% c4 T) j  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
9 S" j5 I6 g! V- b4 l& ~}
" C& i9 E8 F7 {4 w( kcontent += "</table>";
* M- U/ {- Q& y7 z" I- T9 S! Oreturn content;

2 \. V3 Z6 i: c$ k* ]. FC#  
Item qryItem = this.newItem("Part","get");
# i/ h* t9 s% x2 VqryItem.setAttribute("select","item_number,description,cost");
, x/ k7 x* N5 P  q. E3 q, [  x7 LqryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
int count = results.getItemCount();
# A- ~! q$ ^0 z0 Yint i;
' A: s. D% m) o, D7 o3 ?string content = "<table>";
, N; L4 Z3 O' {/ g5 J4 {) r7 rfor (i=0; i<count; ++i)
{
  Item item = results.getItemByIndex(i);
* d, M9 K9 r: [( q  content += "" +
9 {) j: k( o" A% C1 S$ U; p# H8 t    "<tr>" +
8 A9 S; T% e' C! B$ k+ |4 n      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
' x/ x) E4 u# C" M9 |      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
$ J7 h$ X6 z, }! E' H}
content += "</table>";
" c6 C" D2 i$ e- ^% v0 Z1 {: E" ?Innovator innovator = this.newInnovator();
  L/ J6 L% a3 ]/ Sreturn innovator.newResult(content);
" l. B7 d& ~% `2 B2 e0 Y
+ _1 L& E2 e, x8 O+ ^" {5 y6 z# WVB.Net  
+ i5 I0 R! v$ m- P2 B6 w' }1 }& D" rDim qryItem As Item = Me.NewItem("Part","get")
! ~. w, @5 t* ]+ D  C5 hqryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
. a' X7 _5 }% v1 G, W2 U* [Dim results As Item = qryItem.Apply()
3 D. u" V3 u$ C  `" }6 U$ \+ [Dim count As Integer = results.GetItemCount()
) v3 f2 ^: k9 O5 e; I; j# RDim i As Integer
Dim content As String = "<table>"
$ W2 P% W: n. d7 H( O$ T! m: OFor i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
: [" r4 @( {+ p% A( h  content += "" + _
$ ~( z( P: p3 e4 N, Y    "<tr>" + _
$ c& b( e6 G- H6 K      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
+ {5 ^% v  p- F, ]( Y* a    "</tr>"
Next
content += "</table>"
! s, @! o7 @  j8 }2 H, a
Dim innovator As Innovator = Me.NewInnovator()
4 ^7 {5 g5 E& ~& u4 e0 ]return innovator.NewResult(content)