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

admin

Technique  
2 h* y4 v$ p9 c' J' G, UUse the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
3 G8 B3 ^  z* J% Arecipe returns the XML from the  applySQL()  method and forms HTML for a table to
display the data.

1 B5 L& u4 i/ w9 c7 E- r' h  h
C#  
+ L5 g$ D% z% \Innovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
+ q- Z# N) T. h2 D% K  "select login_name,first_name,last_name,email " +
8 e) A; [& o8 n* a9 K1 L/ X; b$ ~( D  "from [user] " +
  "order by last_name,first_name");

string content = "" +
  "<style type='text/css'>" +
8 ^) h1 K! D' i8 a3 Q    "table {background:#000000;}" +
, e; f  {* \& x) h0 {' m    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
% z$ \" A9 @& F$ h! Z    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
8 A! B. S: g7 _$ m  S+ s0 z7 ?) n    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
4 u% P" o: w4 M    "<caption>User Directory</caption>" +
    "<thead>" +
      "<tr>" +
: A" [' Y7 z3 R0 {. s/ l        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
        "<th>EMail</th>" +
      "</tr>" +
! C& c" b2 J' U6 G, v0 N: C    "</thead>" +
    "<tbody>";
     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
1 A; D- g$ A. D  jfor (int i=0; i<users.Count; i++) {
& k8 w6 ^7 V, w8 D: z$ Y3 B, { content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
6 I" k' C+ \5 M1 h content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
% M" E3 E( j; [9 N" f6 L' _1 M% k- v                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
. ~# l! }4 N. c: Z" F& P; j0 o   
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
. h3 q# b. R: m5 b! G0 Y# L                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
+ L, q; H( _6 {9 O4 b- P' a& X content += "<td>" + ((users.SelectSingleNode("email") != null) ?
1 `6 {8 B% _. z! T                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
1 E% h- \, @) G   
* p; J/ b$ p  p4 O2 k, g; m}
8 @; x$ @/ `2 D  ]0 ?- a. U
1 y" B( o2 M; u. L9 hcontent += "" +
( G/ m  U2 \7 f    "</tbody>" +
" I% m8 r' V% W; p  "</table>";
( K  H. Y" B/ e
return myInnovator.newResult(content);