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

admin

1 ?5 u) }- u, L# L) L( [

Technique  
& H, n9 v* y# ~( U$ `6 KUse the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
! U9 B1 F/ U2 |1 [1 P8 yrecipe returns the XML from the  applySQL()  method and forms HTML for a table to
display the data.
+ U+ r8 r1 V1 T7 C% K* f+ P

C#  
6 F5 |6 Z# b/ jInnovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
  "select login_name,first_name,last_name,email " +
' P6 d$ r1 Z/ h4 r* D  "from [user] " +
  "order by last_name,first_name");

string content = "" +
' j" ^2 \, b" W3 H8 `  "<style type='text/css'>" +
    "table {background:#000000;}" +
) m3 M3 f9 T; t4 S/ x1 d7 M    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
' H4 D+ c$ H/ S% R6 }0 |' @% z    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
- g" H! I- }( k, B1 h' M, F4 N    "caption {font:bold 14pt Verdana; text-align:left;}" +
  "</style>" +
, M; l0 @" l  R* L3 A* \    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
    "<thead>" +
      "<tr>" +
        "<th>Login Name</th>" +
1 D/ u8 Q0 L5 r$ ?8 T/ m/ f9 v        "<th>First Name</th>" +
, p7 f2 z2 K1 Y% {        "<th>Last Name</th>" +
0 }' f1 z$ y) W) r6 t        "<th>EMail</th>" +
: F% Y9 m" g5 \* y- I      "</tr>" +
$ l, ?4 J4 I- D4 a+ L" `' c/ S; W' j    "</thead>" +
+ T4 y  ^- l9 R! I- B3 h    "<tbody>";
6 }3 K5 K: L3 U; ]5 B" c; e' r* u) V8 o     
6 ]' [2 P4 v$ ~+ e* y$ E9 ]XmlNodeList users = results.dom.SelectNodes("//recordset/row");
for (int i=0; i<users.Count; i++) {
content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
% q! s  G+ y* v+ u2 C' @( C content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
7 Q+ E8 U$ D. B1 y3 ~' A                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
   
7 N$ }) Y, k2 S% A2 c" C4 ]- l content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
( E: h: r+ [' [! V3 x# Q2 r         
3 m+ T1 P1 l1 G* v" G4 c0 T content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
}
  F& C+ f, p( l, Y9 o% f# Z
content += "" +
    "</tbody>" +
+ W0 u' t% Y7 w" h/ T  "</table>";

return myInnovator.newResult(content);
8 k% f) P6 C, t' R7 K