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

admin

" k- T3 K4 r/ k% S0 ?
9 C4 P% f$ d; t% J" @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
& r+ A0 s( u; p0 m3 Ydisplay the data.
2 H' V% b) ^3 `. L( n- H) k. o

C#  
' u# r$ }& j9 eInnovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
  "select login_name,first_name,last_name,email " +
  "from [user] " +
  "order by last_name,first_name");
5 L4 x$ l# P4 b) p9 m
string content = "" +
  "<style type='text/css'>" +
& T3 Z( s6 V) a/ Q- V    "table {background:#000000;}" +
5 R2 x+ u  a$ R    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
  Q8 Q. ^1 L3 C' Q5 n: g    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
* C5 N% |* s# \; O0 x% Q( A  c  D    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
) P8 C2 {: d. g& E$ l* j2 N! F    "<caption>User Directory</caption>" +
/ S  E( z/ D7 r3 e3 k7 |    "<thead>" +
      "<tr>" +
; m8 f; o# W, `# Q        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
        "<th>EMail</th>" +
9 y$ V0 W+ L) }8 ?% h1 B: J9 r$ E      "</tr>" +
: J" @: t7 d9 a5 v7 h" ]& u9 [    "</thead>" +
    "<tbody>";
5 D6 i$ K. \$ r- v+ E: }1 e     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
for (int i=0; i<users.Count; i++) {
' ?( Q, z1 j; ? content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
! x' _1 J7 P! B( V: l& K                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
: S# D$ ]+ j4 n" e6 o! ]   
content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
  T) v  N# @) V$ {6 l3 |. D   
$ `- m8 a7 N$ g7 C) C content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
& {$ `8 \9 |* M! P: u content += "<td>" + ((users.SelectSingleNode("email") != null) ?
2 ^' _( x2 T+ \                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
}

1 u* d8 D8 `- f3 J" ~* e. P1 {content += "" +
    "</tbody>" +
  "</table>";
& v$ x5 m/ R) Q4 a
+ L) M0 P. j7 X8 u$ \. h8 creturn myInnovator.newResult(content);