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

admin

8 i, [+ s6 U% F6 v5 oTechnique  
Use the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
2 {5 ]  z% I& O8 rrecipe returns the XML from the  applySQL()  method and forms HTML for a table to
display the data.
7 W5 Q/ x' v, h/ S

8 J& }2 [% S/ t) F# l1 w5 lC#  
" [+ f' @% ?. }# R  A  \( {Innovator myInnovator = this.newInnovator();
, l3 N9 y* K; V! Y- E! xItem results = myInnovator.applySQL(
  "select login_name,first_name,last_name,email " +
  "from [user] " +
  "order by last_name,first_name");

string content = "" +
  "<style type='text/css'>" +
    "table {background:#000000;}" +
4 G- l6 d% U, R. M    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
" U  ^$ p% F$ R2 ?, B    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
    "<thead>" +
) j) i# t; ~0 Q7 G1 a' g. x2 Q      "<tr>" +
        "<th>Login Name</th>" +
        "<th>First Name</th>" +
& ]6 C: p0 ~0 T3 q  y' ?; U0 R        "<th>Last Name</th>" +
        "<th>EMail</th>" +
. N! O# O. Z& `, ]) X      "</tr>" +
    "</thead>" +
5 [9 [% p# D8 \$ F! r* x) Q$ N, s5 R    "<tbody>";
3 j3 d% j/ P; m( O0 V7 u) O" A     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
. Q: K  l0 `  X2 L2 Cfor (int i=0; i<users.Count; i++) {
; P! V3 K, l) d content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
) ^! ~3 ]( H( e' n                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
  B6 E6 \$ ^  H1 t- P; @ content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
( Q/ x; C* T4 A- l0 H                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
4 r; I) T$ {6 U) f   
* e# D/ V& b8 i0 }7 I content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
1 _: {$ f% i7 W         
' ^3 k) r1 B5 o' M% m+ o7 L content += "<td>" + ((users.SelectSingleNode("email") != null) ?
. j# `! C4 y( r; j8 D/ Y6 R                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
) G6 Z5 w) m# w+ [: c; \, O3 C}
: Q5 N3 @# E5 d$ G- o
0 Y2 f! e1 V$ a* Pcontent += "" +
    "</tbody>" +
  "</table>";
# p: Y4 T; V: \: t! |2 A
return myInnovator.newResult(content);

. r& ^; ~$ _& t+ z- H