【Aras二次开发】通过AML进行Item对象查询

admin

Technique  
Create an Item Object but use the  Item.loadAML()  method to populate the Item.

' x" k' h; c8 ]
JavaScript
+ N& s* J! _- `* |var innovator = new Innovator();
: u  h2 J; _5 Dvar qryItem = innovator.newItem();
qryItem.loadAML(
4 d7 L' r3 \: o2 N  s8 _9 b  "<Item type='Part' action='get' select='item_number,description,cost'>" +
& G/ X5 v8 X4 Q! Z    "<item_number condition='like'>1%</item_number>" +
+ r- A- r. Q% I9 n5 F3 o    "<Relationships>" +
8 K4 A) G; e, E& |; {      "<Item type='Part BOM' action='get' select='quantity'>" +
        "<quantity condition='gt'>1</quantity>" +
      "</Item>" +
    "</Relationships>" +
; q7 s8 `) ?- X  "</Item>"
( Q  J/ U+ z% n8 j, ]) y);
! s6 x  b+ I7 f! J
; B9 t& _9 K7 l. I. lvar resultItem = qryItem.apply();
  m3 U0 C) D1 w* j* J6 d% @0 R8 M3 yif (resultItem.isError()) {
0 i( i; X( D# |7 ^7 k  top.aras.AlertError("Item not found: " + resultItem.getErrorDetail());
  return;
. E/ g; ^! m" Z# O7 g4 N}
9 C0 y+ r- W- ]/ s- b  t& ^
) @1 k7 p5 R4 q" p3 n2 vvar count = resultItem.getItemCount();
for (i=0; i<count; ++i) {
  var item = resultItem.getItemByIndex(i);
}   
! E) R1 c% a( y
0 u9 L3 [: q; Z* v3 B; q/ G