|
|
请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！
您需要 登录 才可以下载或查看，没有账号？注册
×
" j% @" ?5 D1 j+ O
4 P, N- t% L7 X; t8 t( q) e
1 k& Z- J8 @* ]+ j5 H2 @2 {
. o. d) m( S) l- q/ \# ?Technique * b" F) }. o& E9 o
There is no difference in setting up a query for a single Item or for many. Only the : ^& N' w- ?/ I4 w+ O4 z8 z
criteria define the set size returned. In this recipe you create an Item and populate
% z( H. K1 O* d: d1 vthe query criteria, apply it, and iterating over the Items returned producing a HTML
. `* r2 E/ g, f<TABLE> fragment. . K! k$ o5 [- t5 L8 c
& S3 Y) l6 i4 R' `& y
P7 x; \, O) i5 O) d5 D: q8 {1 bJavaScript
6 [- n. H& r4 ]2 b0 H7 Svar qryItem = this.newItem("Part","get");
+ g) F* t# {2 L& b4 B$ e" IqryItem.setAttribute("select","item_number,description,cost");
# X& h' ~) e# D) RqryItem.setProperty("cost", "100", "gt"); 6 `, i! O( h$ m* ?. N' Y, z
var results = qryItem.apply();
7 m: c9 @/ |. P2 |var count = results.getItemCount();
0 C3 {. {0 ~6 W2 s* `var content = "<table>"; / m0 G, `8 H' L8 ?: j; |
for (var i=0; i<count; ++i) 5 m1 P$ f2 _8 h; @) I8 X
{
1 `7 A1 X3 d/ _+ p# p var item = results.getItemByIndex(i);
6 D, O/ C, ]2 U: b& j: ^ content += "" + `2 e7 x _+ X
"<tr>" +
9 p- h& E' n) d+ K+ E( ` "<td>" + item.getProperty("item_number") + "</td>" +
K5 X3 \& j) C) J% A) d2 ^ "<td>" + item.getProperty("description") + "</td>" +
. i# J- ?! I: `# S' u: G* r "<td>" + item.getProperty("cost") + "</td>" +
9 G( n+ Q' e, I! ]( d. C "</tr>"; 1 v/ z/ u+ {- \9 O2 ^# _
}
( w1 y3 F( a( q7 W6 V0 ycontent += "</table>";
! s& L, }$ I% y9 {- d) qreturn content;
% I3 Q( p+ A6 h T5 V4 { : h3 P4 M% A* Q; v+ o
C#
5 o0 m G4 t( J* H3 l ]6 fItem qryItem = this.newItem("Part","get");
5 E: w$ G/ \/ i$ w9 rqryItem.setAttribute("select","item_number,description,cost");
, w+ ?. u4 J- ~2 UqryItem.setProperty("cost", "100", "gt"); 6 `" T4 y% b6 z6 J) x* i
Item results = qryItem.apply(); ; K* _" j" J/ A- t8 O$ ~: i4 T
int count = results.getItemCount();
( e& K' m3 {; g" Tint i;
5 c! w6 U% y4 u/ hstring content = "<table>"; 0 U+ Z9 t" w/ `, c
for (i=0; i<count; ++i)
' y# X% b# k9 e, |{ 8 ^5 X8 A0 Z! u; h
Item item = results.getItemByIndex(i); + T0 T6 B6 }& o6 _1 n3 D( `
content += "" +
$ ^$ R* w3 H+ X. w, L; V; O5 H "<tr>" + - J4 m6 h1 l# g1 s+ u+ A- @
"<td>" + item.getProperty("item_number") + "</td>" + 2 x3 X9 \+ F `' H
"<td>" + item.getProperty("description") + "</td>" + ) |# j( P! V- I8 J4 }+ V
"<td>" + item.getProperty("cost") + "</td>" + % }( S5 X' T9 ^, s- p
"</tr>"; 0 i8 y' g" U: ^6 U
} 3 U% d9 Y* }# v X* Q0 w
content += "</table>";
4 k4 D! @8 F1 U+ V4 c" v) `Innovator innovator = this.newInnovator();
, j3 [7 o# p& L( G ~7 F9 U# t6 j: zreturn innovator.newResult(content); ! i F8 I1 z5 Y' O
. H3 F- C$ |% n3 w7 @VB.Net
( Y- a3 i1 z8 `+ A) m# D+ nDim qryItem As Item = Me.NewItem("Part","get")
3 T/ T5 u1 d: E1 i/ KqryItem.SetAttribute("select","item_number,description,cost") 3 N3 S1 Y; H6 ?8 ?, a! s! `. ]! J$ L
qryItem.SetProperty("cost", "100", "gt") ' g. ~9 b# a0 S# q8 B8 P
Dim results As Item = qryItem.Apply()
* @6 L" O1 r8 x$ } }Dim count As Integer = results.GetItemCount() 9 c" Z5 C! N- Y% b
Dim i As Integer - a6 b' R. E5 m
Dim content As String = "<table>"
# J2 E) @! k9 T! ~+ pFor i=0 to count - 1
7 n( V) ?. C* P1 I5 \ Dim item As Item = results.GetItemByIndex(i)
, R9 n' j& E4 B) S6 }5 c content += "" + _
' ]# X1 }' |6 b3 @9 L "<tr>" + _ 2 ~8 e9 ]8 z+ J3 F; `# D8 H1 T, J
"<td>" + item.GetProperty("item_number") + "</td>" + _ ' K& D8 y [# d+ ]0 Q
"<td>" + item.GetProperty("description") + "</td>" + _ 0 _" V4 R# s U! M8 M3 `
"<td>" + item.GetProperty("cost") + "</td>" + _ 8 {1 g0 u' h. w: W6 _. j/ g% ^" A# [
"</tr>" , N4 A& n, C" w+ H. v9 \/ Z+ V; _
Next 1 Y, C. r; Y( r0 C# q' n
content += "</table>" 2 y" P& j$ N! T
# P7 @6 l% t# t8 i4 C0 H+ vDim innovator As Innovator = Me.NewInnovator() : [, `$ m* c6 n8 t# ^ q
return innovator.NewResult(content)
) L7 [& n2 [5 A* x' _; K
/ e7 \0 @3 g6 ^) x* |/ @9 G+ N) W$ Y# f6 X4 L& m! e
|
|
发表于 2018-8-1 13:37:47
