|
|
请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！
您需要 登录 才可以下载或查看，没有账号？注册
x
, V! U( \1 p3 @8 x% |
" z I$ V' l* f7 j
" B( G* u. }, m! f) oTechnique 8 x } M, A8 r* S4 J& B3 V2 A/ L; J
Use the Innovator.applySQL( … ) method to submit SQL direct to the database. This
& g* `9 Q) u) a# g N% g4 S- n# lrecipe returns the XML from the applySQL() method and forms HTML for a table to 3 [$ [* ~/ r; p% A5 o5 H6 B8 }, A
display the data.
) G( P% l' s1 ?0 d4 ?& s; g. w0 I5 j$ ]: u- r
0 x1 E, j) }, i K; a5 N4 |
C#
! g* f" ] ` t XInnovator myInnovator = this.newInnovator(); % R$ ^9 B0 u% F7 X$ O" z
Item results = myInnovator.applySQL(
9 D2 w) O& a/ N8 o* e "select login_name,first_name,last_name,email " + 4 e/ H1 M3 \! @9 A$ P
"from [user] " + ! \ f: u2 ~0 e* w
"order by last_name,first_name");
B! K4 ~8 q. @4 A# W" j 6 a6 @4 }9 A, m
string content = "" +
+ B2 G5 j- K" U "<style type='text/css'>" + ' b1 [: \5 U. f' H
"table {background:#000000;}" + % a8 y0 z$ }, D- @$ x
"th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" + 6 g' M( V M( x6 Y2 V6 y
"td {font:normal 10pt Verdana; background:#FFFFFF;}" + * E5 f1 k! h# |. A, ]
"caption {font:bold 14pt Verdana; text-align:left;}" + ' h6 @1 }' n0 O% |* I. t1 l
"</style>" + & z$ C2 m% S5 p! E/ g$ G% K
"<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
2 M/ }( @ ^- b! [ "<caption>User Directory</caption>" +
z2 v7 {) B- T, O1 y "<thead>" + " u y* [. Y! V, F/ l0 {7 n' y
"<tr>" + 1 \9 V2 s' O: K+ f
"<th>Login Name</th>" + % z! ~: j6 v, J! J. V
"<th>First Name</th>" +
4 Q0 _; y" B4 U' f0 e' ?* `* X "<th>Last Name</th>" + G2 z% r) a5 J8 N4 f# v/ [
"<th>EMail</th>" + : D6 X' W: X7 m
"</tr>" +
& ^) D0 W7 |, e8 @3 H, E "</thead>" +
4 z2 Q- b5 p; F "<tbody>";
1 C/ M9 i" Y8 _9 k4 K0 Z ) ^3 c5 t5 S* _- t
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
/ l8 f) U% C' v! D- hfor (int i=0; i<users.Count; i++) {
8 F8 P7 B6 u% F9 Z' b( T content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?
1 m8 V/ z- _9 b U' F' m users.SelectSingleNode("login_name").InnerText : "") + "</td>"; % h1 O# S! [7 o3 ~. N% D) `
: J6 |) Y* u; _* J7 t
content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
! _1 E2 u9 ^8 i4 m users.SelectSingleNode("first_name").InnerText : "") + "</td>"; 9 p( a! ~3 F) y+ p
! D# l5 d7 Y, F7 }" _" j& o
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ? 1 D0 ^) K) B1 u+ N6 j
users.SelectSingleNode("last_name").InnerText : "") + "</td>"; ! R0 c2 l q$ ]# w$ z# H0 l
0 `. }# w: N9 _4 `7 u7 n
content += "<td>" + ((users.SelectSingleNode("email") != null) ? . @4 ?, F$ W. x0 f. d. Y% i' {( _
users.SelectSingleNode("email").InnerText : "") + "</td></tr>";
$ c: W9 R! l. o% `" I- v
, ?7 |# Q! u# A}
2 {0 k' w. L. {6 p ' {1 ~" b& ~1 o( l1 C, y1 W
content += "" + : j8 y$ b% Y( R- u" G S! L
"</tbody>" +
+ n! f2 q1 Q4 C3 [) J1 { "</table>"; & l+ o; `% I+ R) \2 ^/ @
; ~8 L+ @9 {% }5 d, R; J
return myInnovator.newResult(content); 0 Y+ k& _' Z, J) @0 m n; O
4 X3 @+ j! y& Q- o5 Z$ V |
|
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
