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

admin

$ ?, Y6 S+ P  t3 e! f! t+ Y

Technique  
7 J8 E& L, ~0 m! J: X6 s5 LUse the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
3 L7 }2 o( u$ c4 W8 J' J. A& trecipe returns the XML from the  applySQL()  method and forms HTML for a table to
% ]! E- e3 G7 H: g/ ndisplay the data.

6 O# d( J9 y* X: Y0 K
3 e' d  L& D. u. fC#  
Innovator myInnovator = this.newInnovator();
4 }$ n$ S" P0 D: \1 U  }Item results = myInnovator.applySQL(
2 m) ~. ^- J+ t  "select login_name,first_name,last_name,email " +
  "from [user] " +
  "order by last_name,first_name");

string content = "" +
9 i- E5 o% L2 C* G3 O+ e  "<style type='text/css'>" +
    "table {background:#000000;}" +
    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
. _# Q  s. ^5 V7 o2 M    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
% c* s: E9 a- h    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
0 Y) d' ?: ~/ e/ I7 ^1 e' l    "<caption>User Directory</caption>" +
( V$ u4 d$ R* C+ W    "<thead>" +
7 }# e0 M9 M' `2 N1 S) V) \      "<tr>" +
        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
        "<th>EMail</th>" +
3 z6 y* O9 [6 \- f6 g      "</tr>" +
    "</thead>" +
    "<tbody>";
     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
for (int i=0; i<users.Count; i++) {
7 I/ @3 i/ w9 _2 g* j  I) M# u content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
9 E! E1 |7 k+ L% I6 p0 \: c0 v   
content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
& M9 C5 G- e2 G8 y, V: X                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
+ H6 F4 z7 f3 O8 _5 j7 A! P- @% E  P   
8 k: {  g# ]; k; { content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
! f$ B* }" v1 R, Y9 ? content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
  l) o8 q- P  b7 n+ }/ Z& b: U9 ]! r   
}

content += "" +
1 f: ]2 w! h& k$ d: V6 ?    "</tbody>" +
  J$ W4 s: B' i. c  "</table>";

# _# }: E" C' [* k7 O; ureturn myInnovator.newResult(content);