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

admin

6 w" S0 H- l% {+ o4 e
2 H7 F/ {" j7 {, x$ n7 M/ |
Technique  
Use the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
recipe returns the XML from the  applySQL()  method and forms HTML for a table to
& a5 p- e" d! A" ^( tdisplay the data.
9 B: P4 Y3 @% x" t
4 m' {6 ?! ~( `2 S* ^0 z0 p# O& ^1 E
C#  
Innovator myInnovator = this.newInnovator();
7 k) n8 d% j' h. G% h/ bItem results = myInnovator.applySQL(
/ i) |( Y* e, @8 Q  "select login_name,first_name,last_name,email " +
  "from [user] " +
  "order by last_name,first_name");

5 n% r! ~5 o' Ystring content = "" +
  "<style type='text/css'>" +
    "table {background:#000000;}" +
4 ~" _! M% p9 l" w! \* h8 y; U2 _! F    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
1 ]% R" |4 I6 Q4 V2 Q    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
- C) w9 M+ i6 I8 y/ @" \    "caption {font:bold 14pt Verdana; text-align:left;}" +
( g$ p7 B8 ?. a8 g0 _% h. g  "</style>" +
3 [0 B1 z5 i1 \; k. X  k& a5 ]+ e    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
    "<thead>" +
0 k$ o$ o5 w. a1 u+ F7 d      "<tr>" +
        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
        "<th>EMail</th>" +
      "</tr>" +
. c, n+ `+ D  [; K' p    "</thead>" +
    "<tbody>";
     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
, O% |1 q9 ^& @7 h4 o  d7 R3 w+ jfor (int i=0; i<users.Count; i++) {
3 Z: e0 P4 X/ l& R* K content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
( @. Z- A. p* A# F                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
4 }" O" V7 b/ n  s6 d4 m   
* e" K. u, k3 j' D+ h content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
, n' ?( H2 b1 N2 g   
$ x0 A* V" C  f! ]. I: z7 T content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
content += "<td>" + ((users.SelectSingleNode("email") != null) ?
$ a) f% ]0 j7 |  a! r, O                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
+ d! r0 F8 _6 }2 O' a( S: m: Z}

5 I3 u7 [; ^- E; s$ acontent += "" +
    "</tbody>" +
  "</table>";

return myInnovator.newResult(content);
2 k  {2 _  |, H1 t" w* `! i( V) W
/ U; W& [  Y3 n& S' u