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

admin

# |* W, ^1 R. c$ K  k/ lTechnique  
+ |6 F6 ]+ ]  ~; ~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
display the data.
  D0 n7 J% p4 S* j# t( v+ E

! i) }4 I3 c* m2 v! J! `C#  
Innovator myInnovator = this.newInnovator();
  j- n* p& c: U! eItem results = myInnovator.applySQL(
1 C1 t% r" b. [  i& A  "select login_name,first_name,last_name,email " +
  "from [user] " +
- W- i9 B) s, N0 l+ N$ g  "order by last_name,first_name");

string content = "" +
# {5 C  U' Z9 p1 Y# M9 F  "<style type='text/css'>" +
! \0 m4 }; k  }# P    "table {background:#000000;}" +
    "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>" +
    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
    "<thead>" +
! A/ |4 D( u; W7 p: j( D      "<tr>" +
        "<th>Login Name</th>" +
$ i  D7 @$ s' a6 ~( U        "<th>First Name</th>" +
) w# O$ ^3 l0 |$ Y; |, t! e1 z        "<th>Last Name</th>" +
! c: M; G8 k1 O        "<th>EMail</th>" +
9 z* e& [: T- H5 K  R; v0 U& K, H      "</tr>" +
/ g" T% c5 H  H& ^4 R2 ?* m    "</thead>" +
    "<tbody>";
     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
' `- m6 s3 M  Sfor (int i=0; i<users.Count; i++) {
5 t2 `% M! }1 ~9 F content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
2 x" v# g  ^$ y# W0 |. k                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
1 ~4 h  {1 g. T# C content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
   
; N$ r: i7 K' J9 k# m$ t& H content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
1 i0 B0 G" N/ U3 U1 _7 ^                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
# D- P  n6 v9 @" C4 u   
+ ?" {' X  G( H: q}

content += "" +
    "</tbody>" +
1 h3 w$ _8 N/ f) Y, P  "</table>";

3 B+ w1 g7 b/ b) Q2 dreturn myInnovator.newResult(content);

2 D; x: ^2 y8 W3 f* h