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

admin

. \( W( Z7 Q2 w& Q- D5 Z
( q1 y. f- Y4 i& y  B7 l6 STechnique  
( t1 b. U$ r  z# ]4 F7 rUse the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
$ H; m8 u  _7 v: Z" d* _9 grecipe returns the XML from the  applySQL()  method and forms HTML for a table to
8 V" u+ c0 x! [7 _" o" m0 D( P* G" Adisplay the data.


C#  
Innovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
6 C! z" L/ R5 F  o' [1 R5 R6 c  "select login_name,first_name,last_name,email " +
, e6 @5 o) w6 }$ q7 s/ C  "from [user] " +
  "order by last_name,first_name");
& G1 ^8 F: f: Q
5 J2 |; |; F5 v' q( v' r/ lstring content = "" +
  "<style type='text/css'>" +
* {" _5 o: d/ Q( L. u+ j& V, b0 j    "table {background:#000000;}" +
    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
. C! @# c; p( z5 x) w1 a; t    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
8 b6 _: R5 [0 ]0 s$ W& h    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
# B; f3 p9 N5 q3 e) \& O- h! k    "<thead>" +
* |# P1 }2 c; u      "<tr>" +
3 s  S4 ^+ g7 Q, u9 ?( B7 S        "<th>Login Name</th>" +
0 D6 a* O. l1 ~        "<th>First Name</th>" +
        "<th>Last Name</th>" +
1 E( a, T  V7 F) d        "<th>EMail</th>" +
" @3 q" u; z) J. u2 k$ j8 g      "</tr>" +
    "</thead>" +
- c; x' b* F: x    "<tbody>";
8 K7 [- I6 e& d. Z% _1 s     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
for (int i=0; i<users.Count; i++) {
- G2 A9 C: b2 ^3 n0 _ content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
: F! G6 i& W: \5 }   
2 n: n/ H5 z' n0 u, q content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
5 [: J" O/ ?  X% _& Y$ \                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
) w1 ]( t2 F: x# f% y! f   
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
}

content += "" +
    "</tbody>" +
  "</table>";
- v. B0 X/ Q/ {* C
return myInnovator.newResult(content);
( E4 z( U; e! i! U8 Y" R( A% W