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

admin

" U' N; @5 P2 f! F5 ~5 [


Technique  
* w; M! o$ B- t1 ?: m% XThere 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
! X' _, t0 w, J. _/ e9 zthe query criteria, apply it, and iterating over the Items returned producing a HTML
<TABLE>  fragment.

) R  |, J. E7 C$ n
JavaScript  
var qryItem = this.newItem("Part","get");
qryItem.setAttribute("select","item_number,description,cost");
, l, n! w0 W- S7 E1 wqryItem.setProperty("cost", "100", "gt");
8 {- @. R) ?+ `! G4 `var results = qryItem.apply();
/ |$ }: h* q/ h" \: k: j5 \1 ]0 L. ^var count = results.getItemCount();
9 ^6 ]+ p8 H, E' [- d! D2 Cvar content = "<table>";
for (var i=0; i<count; ++i)
' _) u+ Z3 c8 F4 z1 x& I& w{
8 p: d. T0 A% y6 V  var item = results.getItemByIndex(i);
  content += "" +
    "<tr>" +
      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
5 @7 ]3 ^9 F  C8 ?6 ~      "<td>" + item.getProperty("cost") + "</td>" +
    "</tr>";
}
content += "</table>";
4 N4 H- {$ E& g1 e. oreturn content;

C#  
( G( Z- ?* L# Z8 S" M" H; s) ^) aItem qryItem = this.newItem("Part","get");
% _2 g  {+ I9 a' kqryItem.setAttribute("select","item_number,description,cost");
& c1 y, N$ w6 t& K( MqryItem.setProperty("cost", "100", "gt");
: `% ^( M" p, n& P- WItem results = qryItem.apply();
' C5 @, _, L; {1 dint count = results.getItemCount();
- m/ a6 Q* Z5 B6 F+ \2 sint i;
string content = "<table>";
5 `) h; a3 j* t- g" S1 r& Vfor (i=0; i<count; ++i)
{
' s  g" l# J9 g; D2 x# v, w) k( \  Item item = results.getItemByIndex(i);
  content += "" +
2 q* g, }2 m' P( J& b    "<tr>" +
( p; o" r# J$ _9 `      "<td>" + item.getProperty("item_number") + "</td>" +
      "<td>" + item.getProperty("description") + "</td>" +
/ }( T( _3 F& J9 j9 c' O      "<td>" + item.getProperty("cost") + "</td>" +
) x- p# }, x9 ^7 I/ \# G    "</tr>";
5 i2 U& Z: @+ u# q}
content += "</table>";
+ B2 Q  Q8 r# t' E5 BInnovator innovator = this.newInnovator();
return innovator.newResult(content);
9 K) @& p% N9 N" l
VB.Net  
Dim qryItem As Item = Me.NewItem("Part","get")
qryItem.SetAttribute("select","item_number,description,cost")
7 @7 f. g; h" g' ~8 o" gqryItem.SetProperty("cost", "100", "gt")
2 e& i! ^; ^, D4 L6 S6 WDim results As Item = qryItem.Apply()
+ ?" D8 q, v6 e3 O# o1 W) FDim count As Integer = results.GetItemCount()
Dim i As Integer
/ @# B# B& H  R6 G5 W7 NDim content As String = "<table>"
8 j) b* j3 G! rFor i=0 to count - 1
8 I% d4 Z& V8 o$ s& A5 ]' n* q  Dim item As Item = results.GetItemByIndex(i)
  K  _9 L. R3 t6 l- s8 l  content += "" + _
' X$ ~0 O! U  k% m. f1 ?$ p6 x    "<tr>" + _
      "<td>" + item.GetProperty("item_number") + "</td>" + _
7 r  T/ i% b  u7 r* e8 j" ~      "<td>" + item.GetProperty("description") + "</td>" + _
' `! E( D8 `; P      "<td>" + item.GetProperty("cost") + "</td>" + _
    "</tr>"
Next
content += "</table>"

: X. R+ m, [  A, l& gDim innovator As Innovator = Me.NewInnovator()
return innovator.NewResult(content)