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

admin

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


JavaScript
; Z" H& @) S3 k3 U8 _" vvar innovator = new Innovator();
0 |9 j# `! S0 P) \8 rvar qryItem = innovator.newItem();
; E4 |& O! v) p: cqryItem.loadAML(
0 t5 E  R  ]+ U# l$ T" U  "<Item type='Part' action='get' select='item_number,description,cost'>" +
    "<item_number condition='like'>1%</item_number>" +
* C$ _8 b8 K+ N( q3 q( r2 L# f    "<Relationships>" +
2 b! D$ @' p8 N* h1 e      "<Item type='Part BOM' action='get' select='quantity'>" +
        "<quantity condition='gt'>1</quantity>" +
      "</Item>" +
4 A4 l2 t: w% B: B0 w1 [# Y    "</Relationships>" +
4 s* E* [( a# J8 `# [  "</Item>"
);
* c- T7 Y3 T6 s2 m, \
var resultItem = qryItem.apply();
if (resultItem.isError()) {
  top.aras.AlertError("Item not found: " + resultItem.getErrorDetail());
  return;
1 d  Z, k& G3 p: m0 R4 ?}

) ~0 {7 S. t/ J  n  E% Tvar count = resultItem.getItemCount();
2 P0 N( D- F4 E" i; X, }  [for (i=0; i<count; ++i) {
3 ^& n) r/ C8 r: p/ h& D4 R2 L  var item = resultItem.getItemByIndex(i);
/ |7 W' x& B! h4 r# K/ T: e}   
' y7 X5 i2 s. O) b
( n6 t) ~( J, u7 p" l/ b% r