|
|
请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！
您需要 登录 才可以下载或查看，没有账号？注册
×
! j( z8 l0 o- a# N3 E8 h7 z; T
& [/ M+ _+ J. I/ R7 T
- Z4 {5 u0 B; }/ A, u8 ?
0 U2 o+ m7 k7 X+ ~7 e, q/ W: _Technique
/ b. L3 a8 o! R: }! @5 v: UThere is no difference in setting up a query for a single Item or for many. Only the " _- E2 M- `- m6 A! b( W$ S+ |
criteria define the set size returned. In this recipe you create an Item and populate
6 z2 W O- x$ O+ M/ g* G& ~8 Y4 J' [the query criteria, apply it, and iterating over the Items returned producing a HTML
% W7 o, ]& t3 g* O<TABLE> fragment. 1 ?( g- w: d7 y" q* @, A8 F
% p, D& l5 e& K$ {, {9 Y7 k; L! I/ |
9 }6 X. w( M9 L+ o$ |JavaScript % A9 v0 @, S' S/ V
var qryItem = this.newItem("Part","get"); # K5 `. h$ g/ N8 r
qryItem.setAttribute("select","item_number,description,cost");
8 Y+ v X8 A, C$ D7 q& \2 t+ e, d% jqryItem.setProperty("cost", "100", "gt");
; K% _4 @7 L; S( X1 y, qvar results = qryItem.apply();
2 X) x! _9 W' S- {8 Hvar count = results.getItemCount(); 6 [% m9 ?% r) j3 _% C$ G7 y. N
var content = "<table>"; 9 I" |; A! T4 H: ~. v5 R
for (var i=0; i<count; ++i)
/ X$ @1 E* e. D# i{
" c1 `8 U6 {6 k @ var item = results.getItemByIndex(i);
3 }3 x' ?$ J; h4 m content += "" +
% ?! ?9 t. y+ Z) w4 i$ I "<tr>" + $ Y7 S( Y9 e; s5 n( q- R! G6 ]
"<td>" + item.getProperty("item_number") + "</td>" + 6 g. p( c% o. S5 L# f3 z, \
"<td>" + item.getProperty("description") + "</td>" + 5 Y8 h" j, G1 v1 q0 |% `
"<td>" + item.getProperty("cost") + "</td>" +
* Y# s$ k( z5 j "</tr>";
* V3 S) @5 ]" K* g}
' }2 O9 n- d8 z3 s9 f- X ccontent += "</table>"; * V* v8 K+ C! t0 Z4 N6 C( l% q a1 z
return content; 4 r) i4 j2 e$ U# M
5 S; d c9 b4 E2 P6 G2 y; RC#
0 R; q) b# @) v% t9 ]2 MItem qryItem = this.newItem("Part","get"); 7 r: g I- a# v0 T8 L: H3 X
qryItem.setAttribute("select","item_number,description,cost"); 8 `( x) a, ]: d" b) I2 w. P
qryItem.setProperty("cost", "100", "gt"); 3 r1 H) H/ N2 B% x ]. |' }
Item results = qryItem.apply(); - G J+ {, W) u& F
int count = results.getItemCount(); $ i7 j6 D' m4 d8 b1 |8 X
int i; % }1 i: A. j: J( ]. F% C
string content = "<table>";
' j* | s1 n# Sfor (i=0; i<count; ++i)
; Y0 ?, _0 V% {9 Y6 e5 Y{
0 ~4 t& x9 Q. B$ G( O Item item = results.getItemByIndex(i); z/ @* N( N) ^4 U4 e$ Z* L
content += "" + $ t3 N$ {% L4 w# i
"<tr>" + 0 I" a& ~3 B6 T& v' ]
"<td>" + item.getProperty("item_number") + "</td>" +
# X0 i) W& d3 q: W p$ l7 ~+ ? "<td>" + item.getProperty("description") + "</td>" + 9 {& E& d* Z6 c# K
"<td>" + item.getProperty("cost") + "</td>" +
5 {' a4 P4 i/ F1 t+ C9 F7 B "</tr>"; - N9 a) K+ U6 ]
} 6 F$ c1 Q* [# c" _# @7 V; f
content += "</table>";
: {3 S! c0 m4 l$ N9 b3 VInnovator innovator = this.newInnovator();
& ~$ z" m& |; e/ u+ Creturn innovator.newResult(content);
* d4 |) B/ p* r5 N6 o1 s5 r0 A ! d: H* A9 S- A' B, v) x
VB.Net # W. U' h$ D W* d8 ^
Dim qryItem As Item = Me.NewItem("Part","get")
. c6 W2 m3 k! t8 M; _' EqryItem.SetAttribute("select","item_number,description,cost") 8 p" ?8 c0 w8 _' u
qryItem.SetProperty("cost", "100", "gt")
* v6 P' N% s+ a+ O, z |7 ?Dim results As Item = qryItem.Apply() $ D5 x9 v2 s! ?% `) @
Dim count As Integer = results.GetItemCount() 5 w6 L7 b+ ~2 o) y: m0 c
Dim i As Integer
# s0 s K8 p% }/ CDim content As String = "<table>"
0 p7 x. I7 H. `! m" i' d/ c# {- \; \For i=0 to count - 1 m. G I3 {' _. i/ l. r/ S* ]
Dim item As Item = results.GetItemByIndex(i) ; D: E) T& f; \) \& Q4 l
content += "" + _ 5 O9 m2 ~, ^6 K9 ?, n4 C3 x
"<tr>" + _
% Z0 J' O3 G1 |# S "<td>" + item.GetProperty("item_number") + "</td>" + _ 3 x; \, ?$ g+ ]0 p; _# x. b
"<td>" + item.GetProperty("description") + "</td>" + _ ; s; c& P# f4 d p1 ^5 F
"<td>" + item.GetProperty("cost") + "</td>" + _
* ^, i3 Q: U* J9 z "</tr>" 0 o) H# ^* F% o3 c" v8 s! ^' r a0 I( }
Next
4 L" B% K" a, N, x [- x# Mcontent += "</table>" 7 H9 R& _2 U, d$ S
7 O x/ o8 y, G* \4 z
Dim innovator As Innovator = Me.NewInnovator() ! `$ F) v% W5 l
return innovator.NewResult(content)
# w: N; g1 r& O) c) U5 H- Y& r& p0 ^6 f
' { s$ y8 h- m
|
|
发表于 2018-8-1 13:37:47
