【Aras二次开发源码】使用ApplySQL进行快速查询

admin

5 h( n$ K8 u2 E

Technique  
) Y3 }4 S) i9 l; d6 |Use the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
  ]4 ^- C9 H8 ~1 b9 }recipe returns the XML from the  applySQL()  method and forms HTML for a table to
display the data.


: O; ~" g; i3 O7 [5 H3 @- }C#  
Innovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
5 [; i: v( E. C& E- y  "select login_name,first_name,last_name,email " +
0 v8 e. B/ z6 {- q  "from [user] " +
) m5 K( h- i6 a7 A- p. T  "order by last_name,first_name");

+ s3 ]4 h5 f! L0 y0 F( q& R. Tstring content = "" +
& l  \6 q# @' L' y  "<style type='text/css'>" +
    "table {background:#000000;}" +
    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
    "caption {font:bold 14pt Verdana; text-align:left;}" +
+ f. l, d) j8 ?+ n# H  "</style>" +
    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
' E5 K# [9 l$ e! ~7 @5 l4 Q    "<thead>" +
0 K% z! C2 L( }) w4 ?3 N      "<tr>" +
2 B8 ]' X/ d( s        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
( m( ^! Z1 P( E        "<th>EMail</th>" +
+ [: Y! l; H2 G; h) w# d$ j      "</tr>" +
0 j, g  u+ p9 r    "</thead>" +
    "<tbody>";
, Y" h! m8 \; b     
; j& p* l# @% a% F! CXmlNodeList users = results.dom.SelectNodes("//recordset/row");
- k" b6 t3 D' G0 Gfor (int i=0; i<users.Count; i++) {
content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
$ \" E3 O: T7 L/ h) @1 k                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
2 c, l* L1 G4 @7 B content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
   
3 B# }/ R$ a9 o5 g- m1 z content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
+ O- h7 S2 P$ X0 N/ j, r# ]7 _                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
, ^( ?* Z8 R: y8 v7 ^         
& _! a; h  t; _" ] content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
$ X& v2 S; S0 r: F+ i! j' P7 {   
}
0 q6 l, f2 q# f! k# n' \
content += "" +
0 y3 }" f, i5 `% N/ }    "</tbody>" +
  "</table>";

return myInnovator.newResult(content);

' m* n1 h. h& x3 [6 W3 L: D, J% ?