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

admin

- J$ u# U1 z2 u: h7 m; X. U3 U
$ o5 a/ r0 a0 |: }; m, i  w' H  t
Technique  
There is no difference in setting up a query for a single Item or for many.  Only the
) W6 U3 k1 B6 Q4 |+ pcriteria 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
<TABLE>  fragment.

1 w. R# `$ N% b
5 j, ^4 |# G* |" n5 u& H# z% Q/ AJavaScript  
0 b4 |5 P" t& w- Uvar qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
0 [. {1 d; z5 b5 A8 C: [! kqryItem.setProperty("cost", "100", "gt");
8 E) n( R- X: fvar results = qryItem.apply();
- W' m0 D) O/ x- [  yvar count = results.getItemCount();
" y3 v+ X3 [) G) K8 L% Hvar content = "<table>";
6 T; S4 s" A7 v# t8 c2 Ofor (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
7 N! Y7 H* N: B3 G. ]  content += "" +
$ U, \3 i3 p& e9 {; q. f) d3 K    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
8 E$ {) R# c' L1 d( h: C) ]+ N      "<td>" + item.getProperty("description") + "</td>" +
  ~" O% M- z6 |: A" i/ v) B$ D' R      "<td>" + item.getProperty("cost") + "</td>" +
2 Q5 b6 b5 z5 E+ C0 B    "</tr>";
}
content += "</table>";
: X: y6 ~. ?1 X$ b) i7 Kreturn content;
+ z, n$ m8 D# Q* B$ W! }
. L2 f: ~( h* ?! K) F3 p+ w6 n' ~C#  
Item qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
; v% m' Q8 p" Vint count = results.getItemCount();
8 v' w! V/ S% u4 lint i;
string content = "<table>";
2 Y( _. f5 ?6 @6 x: r$ q5 xfor (i=0; i<count; ++i)
{
  Item item = results.getItemByIndex(i);
  v: o( e) E( E. S$ [' B; G+ ?9 f  content += "" +
& O! h) q* @( r$ l: i    "<tr>" +
5 _# h, H2 c" F# t) }      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
6 z. k: x4 c) I9 |}
1 W: [! W) I- ]7 R* i' \content += "</table>";
Innovator innovator = this.newInnovator();
, m4 C1 T  B0 f# e( qreturn innovator.newResult(content);
( S- v% Y* {( ]* t5 ]
8 {  r, r' D. h+ C$ H; K) \# MVB.Net  
7 u7 i5 D; k8 `/ ^: E4 [7 J8 r/ fDim qryItem As Item = Me.NewItem("Part","get")
8 n( Q5 X8 r+ ~+ U" tqryItem.SetAttribute("select","item_number,description,cost")
7 R4 o# G9 `- N" v5 [qryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
Dim i As Integer
Dim content As String = "<table>"
For i=0 to count - 1
. F2 o! @: L% q  Dim item As Item = results.GetItemByIndex(i)
9 }. U- i5 F# W. }7 w3 a/ o# j  content += "" + _
    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
2 t7 B- v4 Z0 `; X6 w2 d5 V      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
8 ~3 @1 z+ G5 K7 G" M2 C1 p0 DNext
content += "</table>"

6 Y  Z! y) C6 K: [$ Z6 pDim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
8 n+ i+ i: m7 Q8 a6 f- m+ A