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

admin

Technique  
3 V$ z* q/ D" L" o( z0 K% kCreate an Item Object but use the  Item.loadAML()  method to populate the Item.
8 e3 \8 U  h. V6 B6 B& d

* J( O' |2 v4 g8 Z: C" f; qJavaScript
* y/ U: Y  U& N4 K; ]7 e* u& ]) Svar innovator = new Innovator();
var qryItem = innovator.newItem();
qryItem.loadAML(
  "<Item type='Part' action='get' select='item_number,description,cost'>" +
) G- \, b' y6 U8 K6 O3 I    "<item_number condition='like'>1%</item_number>" +
    "<Relationships>" +
      "<Item type='Part BOM' action='get' select='quantity'>" +
4 f! H) x8 Q- W0 K8 _9 s$ \/ u        "<quantity condition='gt'>1</quantity>" +
) {5 d+ L5 K, }8 s8 ^      "</Item>" +
( W* b( A  g% d" y- }    "</Relationships>" +
. N% R" _. s7 {6 d& X' T8 |  "</Item>"
4 a2 ~- W0 Y4 ^4 H3 M5 l);
9 }# t1 ~. F- Z- V- c4 @
( Z% i, p6 b8 t& b% H: Mvar resultItem = qryItem.apply();
if (resultItem.isError()) {
, s7 p) K1 T0 f- Y  P  top.aras.AlertError("Item not found: " + resultItem.getErrorDetail());
  return;
}
1 H5 `9 _) ?  j2 [% r! Y) I
& [& T" {% u" ~$ ^1 d5 F0 [var count = resultItem.getItemCount();
for (i=0; i<count; ++i) {
  var item = resultItem.getItemByIndex(i);
}   
5 K- B( X9 K5 J8 [) W. b* D; S: w' h
2 X& _6 C. T' |% P2 F- z6 T