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

admin

% {8 b* f* ?) \8 a3 r8 \: q* n

Technique  
! V, a' G' E4 N7 ]  ~# hUse 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
display the data.
. O' Q! D$ C1 f2 ]0 C3 ]5 d- Y
" X7 i! O0 A2 ~' b* {
C#  
9 B* S6 O- ~  F5 m3 YInnovator myInnovator = this.newInnovator();
5 K1 B6 j! g% y( R( C0 u5 Q5 RItem results = myInnovator.applySQL(
  "select login_name,first_name,last_name,email " +
  "from [user] " +
  "order by last_name,first_name");
" s9 E$ W. R  B
string content = "" +
  "<style type='text/css'>" +
& D7 B5 i( E9 ]& e    "table {background:#000000;}" +
    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
* O( ?& @( j, z) o3 N/ k    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
3 E, I. v& f% \" f) k7 m    "<caption>User Directory</caption>" +
/ l( n3 e, x' |  ]' d2 j    "<thead>" +
" w. G; z" E) ~9 c2 h) Y      "<tr>" +
/ M0 P. k! c6 V& s        "<th>Login Name</th>" +
        "<th>First Name</th>" +
% s8 o7 N: n+ c8 H$ ]        "<th>Last Name</th>" +
8 C( k% D1 c$ N$ Z1 D        "<th>EMail</th>" +
! c4 }9 G7 K6 J      "</tr>" +
    "</thead>" +
    "<tbody>";
% D/ ~( Z) {" T* a     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
for (int i=0; i<users.Count; i++) {
; p- t( @1 d3 b: { content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
' v2 b: h" L2 t5 b5 ^; ]                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
4 S+ O+ h; i; f content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
" ]5 E3 ~7 _2 {                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
   
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
! Q0 @1 U) H( N* ?7 @ content += "<td>" + ((users.SelectSingleNode("email") != null) ?
+ v, m7 R( C( f$ x                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
}

9 K' i2 s! A7 V) d& m8 jcontent += "" +
2 @9 U7 J1 H! X6 L+ R( A- V    "</tbody>" +
, C+ O7 S4 Q% ^3 s1 u1 l6 l' o  "</table>";

+ Q! H) f9 n& N( `return myInnovator.newResult(content);