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

admin

, ~/ T) A; ^; _% u+ ?5 `
& {/ c1 n1 Y( i. |. |+ t. R

: c, b" G  c2 W7 x0 _, ^2 DTechnique  
& F7 G2 {+ d3 B7 f  h2 U: |There is no difference in setting up a query for a single Item or for many.  Only the
/ w9 R) ^- m  ~" Qcriteria define the set size returned.  In this recipe you create an Item and populate
3 T/ I" |0 V, z& mthe query criteria, apply it, and iterating over the Items returned producing a HTML
( ?% F( I/ m3 w) V. ?% e+ I/ k<TABLE>  fragment.


JavaScript  
var qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
: }+ W" J( C: {  r- Y6 {9 Svar results = qryItem.apply();
' i/ {+ @+ C( G7 u. k+ P0 w# R) K9 Wvar count = results.getItemCount();
0 m7 }( K/ U- }+ {) T* F0 t, ?) Cvar content = "<table>";
: T; }1 z3 s" }# _9 ^: E- nfor (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
* W1 v( ^& {  x9 [9 {' ]. J, |      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
& ]' {! j% o) f2 M9 w& W* z      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
# C% b6 z3 C  b# J+ i}
. q7 N4 X; m9 scontent += "</table>";
! {- U  X1 ^5 P& x5 zreturn content;
% i: ~6 Q4 s/ ?* ?
C#  
Item qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
, L: j" W. M& q3 d- j; ]0 \int count = results.getItemCount();
int i;
string content = "<table>";
for (i=0; i<count; ++i)
; J9 b5 k6 s+ B4 g/ e: n9 ~{
/ n& f' x5 v, h* B5 K9 ^7 m7 Z: X/ C: e  Item item = results.getItemByIndex(i);
- P- C. [" Q" P, V  content += "" +
7 j' V4 j% ?- K& J& w( M7 i0 @$ Q    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
6 [- T# U& |6 L      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
  G: Z8 d; E2 }5 b, h& V( ccontent += "</table>";
& m  m8 ?* E5 [3 x! b9 vInnovator innovator = this.newInnovator();
return innovator.newResult(content);

VB.Net  
& I: T# ?6 [! x" TDim qryItem As Item = Me.NewItem("Part","get")
; X: Q% I! Y; t$ P$ uqryItem.SetAttribute("select","item_number,description,cost")
+ c2 F1 ?( }$ T/ F4 P& }qryItem.SetProperty("cost", "100", "gt")
/ N0 D$ {7 D4 {* o1 sDim results As Item = qryItem.Apply()
Dim count As Integer = results.GetItemCount()
. ?8 S+ @. N! gDim i As Integer
Dim content As String = "<table>"
8 d3 I/ u" h$ H+ n) ]For i=0 to count - 1
0 O4 x3 T7 S- C! C+ u$ o* K  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
+ g. A. M! U. P5 l! c/ D1 a* N    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
Next
content += "</table>"
+ t8 ~1 g- n9 |6 f1 P
Dim innovator As Innovator = Me.NewInnovator()
0 t; r8 W0 X. ?1 g2 L) W( Lreturn innovator.NewResult(content)

! x1 C+ E) f- g) a/ ?# n" g