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

admin

6 q9 ^9 j: A' l: ]* S4 v1 j

# B) p6 h0 K6 a8 |
% e! R3 R3 x: `8 d+ u3 {- A4 JTechnique  
There 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
the query criteria, apply it, and iterating over the Items returned producing a HTML
6 }3 A2 B+ g9 q! ]$ x' l0 k/ Z+ s) }! u- ~<TABLE>  fragment.
& E& x: |4 H" _( }* o$ y- Y& t2 ^
/ D# W9 d; c$ ]
/ K3 X" ~  m5 M& g! }* L* VJavaScript  
var qryItem = this.newItem("Part","get");
. p$ c( D1 ]1 {) B( sqryItem.setAttribute("select","item_number,description,cost");
6 \1 x& c4 Z% y0 F1 C1 g8 F6 sqryItem.setProperty("cost", "100", "gt");
var results = qryItem.apply();
var count = results.getItemCount();
) J2 J3 @5 N0 g7 {  hvar content = "<table>";
8 g6 k: }- [4 ?0 d2 I7 Lfor (var i=0; i<count; ++i)
6 L7 N) C9 u7 C+ }{
  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
/ r* t$ y3 d6 q( B; {1 w      "<td>" + item.getProperty("description") + "</td>" +
1 b; A, c3 L. }/ d/ d# S  a      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
5 s' i0 X, |* E# ]: D' p1 q}
content += "</table>";
; r. |0 L! Y  kreturn content;

0 {) O! C) Y1 u8 y- RC#  
  _" X; ^- r4 \( z2 NItem qryItem = this.newItem("Part","get");
. F, K" }+ z' S- e. n4 o2 dqryItem.setAttribute("select","item_number,description,cost");
1 S: O; A! K  y, g4 B- |( \# wqryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
int count = results.getItemCount();
int i;
string content = "<table>";
% b$ G2 q/ y$ `for (i=0; i<count; ++i)
{
+ B1 @& F, Q% d0 @" `  Item item = results.getItemByIndex(i);
  content += "" +
1 E8 z& B( h& P# \* a  v    "<tr>" +
+ |9 U0 ]0 G+ Y# j      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
7 @( Q$ f+ w# z# G      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
- x+ r6 X/ y; U1 r  |& Q}
content += "</table>";
; m3 f+ r& G7 ~( T6 w, G6 IInnovator innovator = this.newInnovator();
! N7 `5 u' W8 P' @  ureturn innovator.newResult(content);
; n: d8 V  [, y9 j% t( F
- F: S1 m% q! sVB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
0 J6 a- D1 u4 J" SqryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
  k7 Z& W6 W' s% BDim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
Dim i As Integer
" ~: q6 w: n9 s! t. }( aDim content As String = "<table>"
For i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
3 y- @- Y) o! X1 m5 H4 D2 }" O  content += "" + _
! f  r: ?9 j, n: i% {" a3 p  y# h    "<tr>" + _
+ m, t$ X4 \6 b3 h$ M9 Z; N- e      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
  k( q, d" _# l# Z# }7 a    "</tr>"
4 j4 I' Q; `. w# a" f9 G! S' D& t/ D' vNext
content += "</table>"

Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
& P) s; o4 R$ h! k: Q