|
|
请使用QQ关联注册PLM之家，学习更多关于内容，更多精彩原创视频供你学习！
您需要 登录 才可以下载或查看，没有账号？注册
x
. V e; A5 j3 N
; w. t' t A e& }/ N, I
& c, d" i# i K: \* C% n) ` t, w
Technique
" g; ]) P, ^) t* N. k1 YUse the Innovator.applySQL( … ) method to submit SQL direct to the database. This ) b, }6 |$ I& l/ L0 U7 ?, Y- Z
recipe returns the XML from the applySQL() method and forms HTML for a table to 9 G# l% T1 T0 v3 x
display the data. 2 u' h, @+ Q, w: n8 H) n' Q1 n; J
! Z4 U+ o4 B3 C7 @/ U# m
6 x p P8 Y6 M# }C#
5 q+ g, ^7 W. lInnovator myInnovator = this.newInnovator();
1 O8 D- C3 e3 c. e/ M/ E, K. ]Item results = myInnovator.applySQL(
) R$ f4 r4 ?" p5 F "select login_name,first_name,last_name,email " +
8 m/ ~4 g. k- ]- G6 e4 r7 r "from [user] " +
% w8 d% }) z4 V) J "order by last_name,first_name"); ) ?8 ^: q: _& p1 k" n! `
n4 H6 i) Z: |, K; A
string content = "" + Y# H7 E$ }$ \% E" M1 E
"<style type='text/css'>" + % Q) v2 X: o1 x6 R: e. J
"table {background:#000000;}" + 9 N! a, r) R$ p# v# p
"th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
8 w7 i0 |; }0 Q# ?, C) g "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
* m9 x% U, s O. s. P" m "caption {font:bold 14pt Verdana; text-align:left;}" + ! W& D" }# V3 X4 X: X3 ~
"</style>" +
# D1 l. D5 v* Y+ p w0 r "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" + . c) U- |+ l- w5 i/ Q- X2 h
"<caption>User Directory</caption>" + / r; q* e* J: H, L; V! v
"<thead>" + 4 R; z% n8 W7 l) f0 {" O: T
"<tr>" +
- ?2 T7 R7 L4 Q9 |( a) V. Z6 @ "<th>Login Name</th>" + 7 v9 [6 W! f0 Z
"<th>First Name</th>" + : {3 T/ d; Y+ O2 f
"<th>Last Name</th>" +
5 \" e, X& n/ H- ^+ @; @ "<th>EMail</th>" +
$ V/ x j, n5 d5 Q2 B2 U "</tr>" +
( ^( z. o/ p* N: W( s5 M "</thead>" +
. r* K9 Z3 x3 H4 W# ?, @7 C "<tbody>"; + x4 A) a8 ^0 y+ `( Z- n0 i: c$ {
4 U& D$ O6 I8 X* W9 ]7 wXmlNodeList users = results.dom.SelectNodes("//recordset/row");
! ?% d' [3 z! @# J; nfor (int i=0; i<users.Count; i++) { & Z+ v1 j( m8 _/ v9 P$ [
content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?
4 t# z0 l2 r( G1 P7 j' P# P0 v users.SelectSingleNode("login_name").InnerText : "") + "</td>"; $ T2 m/ k( F5 x/ e. P2 C
$ j" r: S8 L: R8 f! G content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
6 g" w, V6 f$ p% a users.SelectSingleNode("first_name").InnerText : "") + "</td>";
8 x2 A. o! Y. W" j# i! G
0 H, P- Y: B7 F6 S, i content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
; p: n$ h* A e: u users.SelectSingleNode("last_name").InnerText : "") + "</td>";
2 ]1 ^0 c* }% X7 z
5 V! G$ s' B3 C0 b* Y ~7 Z' w content += "<td>" + ((users.SelectSingleNode("email") != null) ?
" C* \0 x1 ]0 Q3 V+ X x users.SelectSingleNode("email").InnerText : "") + "</td></tr>";
- Q" j+ }+ q, J/ c% I; @ ( Q. w5 @4 O3 F% r: e8 a
} ' K6 i, f# }7 }: u/ H
1 [% E( o5 s5 y4 A5 ^content += "" + 8 y- U+ m X/ a( }+ f& {; q9 g6 ]
"</tbody>" + - [8 l! o1 B# W1 o
"</table>"; + P' U+ F `# Y% c- P9 h4 f
) K# \! Z1 y+ c" H
return myInnovator.newResult(content); 4 y: m2 K4 N" \$ Z
% m+ U( g @% C' s1 ` |
|
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
