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

admin

* G. W- e' v% n$ T! ~$ D) ^* d
6 q5 d* B. w2 m
, y" e, y  g, c1 k7 g* G/ F  Y2 W
Technique  
4 g* p  ?( ^1 q( Z' PThere is no difference in setting up a query for a single Item or for many.  Only the
# X& S1 f. ?$ ^- fcriteria 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.


JavaScript  
  U, `7 _) e* x0 @7 ?1 dvar qryItem = this.newItem("Part","get");
* d: ^$ l& W/ B3 V6 v) a& LqryItem.setAttribute("select","item_number,description,cost");
7 V" G$ c  m! t# b  cqryItem.setProperty("cost", "100", "gt");
8 `8 Z# e, t0 y7 Y3 Avar results = qryItem.apply();
' v: R, G) s! P* v" mvar count = results.getItemCount();
var content = "<table>";
for (var i=0; i<count; ++i)
{
  var item = results.getItemByIndex(i);
& J9 A& c' Y7 c6 I- _$ J  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
, }3 b* Z/ T7 ~% s6 U    "</tr>";
}
content += "</table>";
return content;

C#  
Item qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
qryItem.setProperty("cost", "100", "gt");
Item results = qryItem.apply();
int count = results.getItemCount();
0 m" k  i8 ^- C! Y$ o, t, z% Y; kint i;
string content = "<table>";
0 I% I6 q2 @+ Hfor (i=0; i<count; ++i)
6 X# s. z; @& A{
0 N/ i& R/ q! O" T, p  Item item = results.getItemByIndex(i);
3 @" d! S4 ~6 M, n; N. u+ |  content += "" +
7 C8 m) s5 O& a% W4 ^# @    "<tr>" +
6 Z3 L7 v* k+ u6 K3 Q      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
+ X$ {( P8 }4 N5 }' ^4 C( T}
content += "</table>";
Innovator innovator = this.newInnovator();
, Q$ `, h; ~* G% T- Ereturn innovator.newResult(content);
7 L" [1 |/ z" D
4 B+ P$ \# ~9 m  `6 J9 u' G& I9 lVB.Net  
5 x2 k8 ~2 t9 _# pDim qryItem As Item = Me.NewItem("Part","get")
! u/ V0 i% p( K$ ^4 r! v! f7 i' }9 o8 FqryItem.SetAttribute("select","item_number,description,cost")
qryItem.SetProperty("cost", "100", "gt")
3 p- b* N& ]  \* P' y5 uDim results As Item = qryItem.Apply()
( g! w5 I5 t& o+ ^! v1 zDim count As Integer = results.GetItemCount()
Dim i As Integer
  F* K& i  q0 m- `Dim content As String = "<table>"
For i=0 to count - 1
  Dim item As Item = results.GetItemByIndex(i)
  content += "" + _
    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
( G" j( e/ ~8 }( X; L      "<td>" + item.GetProperty("description") + "</td>" + _
      "<td>" + item.GetProperty("cost") + "</td>" + _
( \, N- i  J( t( H    "</tr>"
0 o# b$ O& R: T9 b: v1 SNext
content += "</table>"
; g! u" f+ s. ?- v( T( u: y: e
Dim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)
+ p2 R, i+ F2 S$ x; C5 Z  P

1 Z; P% ^' y/ j. m" K' \