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

admin

- ^9 S$ W. T( [Technique  
Use the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
5 `) |( s% ?# J7 W9 U" h) ]6 drecipe returns the XML from the  applySQL()  method and forms HTML for a table to
display the data.


C#  
1 r! W" j; Y$ DInnovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
  "select login_name,first_name,last_name,email " +
$ D" S0 A% P, w- {. |3 e5 L) D9 _  "from [user] " +
9 @" D$ r8 F1 y$ n0 Q9 v% X  "order by last_name,first_name");
. u2 F6 W! h5 g) D$ L
4 Q! n" S. H+ j+ dstring content = "" +
  "<style type='text/css'>" +
  X8 @5 S4 Z$ ~    "table {background:#000000;}" +
6 J/ {( s+ N$ N    "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>" +
0 N% K9 f  f9 C5 I% v6 d    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
& A, t+ S5 C8 i  _    "<thead>" +
      "<tr>" +
. E, O; H$ \: F  ~        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
: x; q* L* h3 ^; \        "<th>EMail</th>" +
      "</tr>" +
    "</thead>" +
    "<tbody>";
5 k( `* K. M) G3 E* H  Y( e     
* W# r/ _; Z, uXmlNodeList users = results.dom.SelectNodes("//recordset/row");
8 k' O$ W; U2 k4 g/ m  v, n. Jfor (int i=0; i<users.Count; i++) {
) }# ?" a$ O' F! ^( @8 s: V6 B4 j content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
( H/ U( y$ b9 z( j% Z   
content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
  f, o  B# B4 G                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
   
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
' I7 s) I2 E6 P1 B                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
}
* ~" @$ H  E5 }& X
content += "" +
5 G" {' D8 Z4 y- a' [4 J    "</tbody>" +
' h; X( a# I+ l" R% x  "</table>";
% C! _! I% _1 X/ K2 U, U( E8 \( e" l
8 P- Q: B4 ?9 W& a4 M& kreturn myInnovator.newResult(content);
- l. w. l* {2 f# l3 @1 |) b8 Q
, h0 G% d$ J( |3 Z