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

admin

+ s& s/ U) i- ]8 I+ T

' H' \" f/ y$ c7 B0 v
' r( I$ w) F$ p; H$ ]# a- P! b- HTechnique  
( C% p1 w- y: z9 b# |- dThere is no difference in setting up a query for a single Item or for many.  Only the
9 a3 ]. w" _; o* bcriteria 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.
- D, `* p5 d- P! x! I% f
) ?! _' w: k- X$ Q
JavaScript  
. L3 I8 {( B1 |" M* J& z: Y; Yvar qryItem = this.newItem("Part","get");
  c+ }" F" S6 K- {4 ^0 y. j# JqryItem.setAttribute("select","item_number,description,cost");
: Z; T2 I  U) XqryItem.setProperty("cost", "100", "gt");
9 U1 P2 H7 f+ E7 ]. I/ Zvar results = qryItem.apply();
var count = results.getItemCount();
# X$ m6 C% d& V& w  ?% V* H& qvar content = "<table>";
for (var i=0; i<count; ++i)
{
9 r" H0 H& n" K- U' K( Z; N9 J  f  var item = results.getItemByIndex(i);
. y- N6 B+ z! [2 ]" y- [* N  content += "" +
    "<tr>" +
+ u: C  C' |$ u      "<td>" + item.getProperty("item_number") + "</td>" +
! W% L% Q1 S* R6 D8 P      "<td>" + item.getProperty("description") + "</td>" +
$ q0 P1 U) u, F1 r      "<td>" + item.getProperty("cost") + "</td>" +
7 l. d$ H4 p2 f0 p& S. ^" W. h- I3 G    "</tr>";
}
- t: }; T2 n7 D  Wcontent += "</table>";
4 O( x7 f- z# x, k0 Z, ~return content;

# E" E0 N  c: p5 t" dC#  
2 R7 j+ T  N! m& P1 }+ qItem qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
  W  P5 Y5 V( ^/ ^- d! Z- TItem results = qryItem.apply();
( L* ~( F" I2 U2 h4 i5 L# nint count = results.getItemCount();
int i;
string content = "<table>";
for (i=0; i<count; ++i)
{
7 B0 j+ _  b" Q  A, K6 t1 y6 u  Item item = results.getItemByIndex(i);
, h/ v4 d. D6 M, i  r) G: q% B  content += "" +
; C  b9 E; d  H    "<tr>" +
( r$ O& m* Q6 W+ b" a, z      "<td>" + item.getProperty("item_number") + "</td>" +
& M. p$ q! `6 w7 q      "<td>" + item.getProperty("description") + "</td>" +
' ~( K, n2 v! F+ q1 W) M: G+ E      "<td>" + item.getProperty("cost") + "</td>" +
0 u& s9 ^! F3 Z    "</tr>";
}
content += "</table>";
4 Q9 V+ N! E+ G; AInnovator innovator = this.newInnovator();
+ N7 Z0 _; o9 Z( N9 t9 U& Mreturn innovator.newResult(content);
) j8 R) |8 x' R* _& X$ l
8 Z' S! [" U9 b  R& H3 [VB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
# y; R9 e0 q) F/ TqryItem.SetAttribute("select","item_number,description,cost")
) u+ h3 l& `9 R9 p& u# v9 b3 DqryItem.SetProperty("cost", "100", "gt")
Dim results As Item = qryItem.Apply()
  |* C+ q0 T' `Dim count As Integer = results.GetItemCount()
Dim i As Integer
) K8 m4 v1 Q' Q0 L5 VDim content As String = "<table>"
$ H7 k2 v8 h9 _9 @0 g3 D7 w8 r7 _For i=0 to count - 1
2 B$ Z) z/ p+ Z. s5 A  Dim item As Item = results.GetItemByIndex(i)
: x. V0 n- X+ y4 J" T  content += "" + _
) B+ f9 @% b! o# d% u    "<tr>" + _
  _( @! ?7 T+ N6 L% C4 n, G0 g. K. t2 O      "<td>" + item.GetProperty("item_number") + "</td>" + _
8 @" L! w3 M% B' K( D8 W* ~      "<td>" + item.GetProperty("description") + "</td>" + _
& y+ J" Y1 T2 m. }# R      "<td>" + item.GetProperty("cost") + "</td>" + _
( [! P# _) V6 _' _8 U$ G    "</tr>"
Next
content += "</table>"
, q- x! ]; D& d
Dim innovator As Innovator = Me.NewInnovator()
3 C. v6 ~# q# p& g9 `! P; G3 J# \return innovator.NewResult(content)

0 J6 M; E+ w, v
& C6 L  r0 a" y- _