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

admin

Technique  
4 a3 z3 X3 H+ p# W6 ^' dUse 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
% b" }- C# P( bdisplay the data.
: R% C3 ?) u2 S+ z, f. v1 y3 Z: f

C#  
# t  \' M6 S/ f9 a9 gInnovator myInnovator = this.newInnovator();
" {4 f* G, Z* y. B/ a9 z5 v$ ?Item results = myInnovator.applySQL(
* Z' i% f. }" ]: U. ~% N0 |# Q5 g  "select login_name,first_name,last_name,email " +
  "from [user] " +
3 ~3 Z2 G+ J6 |5 V% o' t0 V  "order by last_name,first_name");

) g) A9 |6 }7 A% ^' a, sstring content = "" +
  "<style type='text/css'>" +
( R' \, u' K; h- ^* e# |. L    "table {background:#000000;}" +
" B7 H) Y7 v8 d1 \' s8 I. Q2 \    "th {font:bold 10pt Verdana; background:#0000FF; color:#FFFFFF;}" +
7 N0 K# Q! b0 ?9 D    "td {font:normal 10pt Verdana; background:#FFFFFF;}" +
    "caption {font:bold 14pt Verdana; text-align:left;}" +
0 D6 [8 x+ P1 _/ ^6 ^  "</style>" +
" O0 m& ]( p0 u% ^    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
    "<caption>User Directory</caption>" +
    "<thead>" +
      "<tr>" +
        "<th>Login Name</th>" +
        "<th>First Name</th>" +
- e! n7 @! \( O& S$ g2 F3 [9 r; k2 T        "<th>Last Name</th>" +
        "<th>EMail</th>" +
. ^+ r0 D. m/ _7 \      "</tr>" +
    "</thead>" +
1 \  ]' `' x/ j! }8 e& d; f6 F    "<tbody>";
     
XmlNodeList users = results.dom.SelectNodes("//recordset/row");
/ u# t6 ]: W+ v- }! [for (int i=0; i<users.Count; i++) {
content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
& k3 t8 F2 U( W. t   
2 i* G, i4 @3 K7 ^7 Q0 E$ D4 G content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
# j9 ?3 i1 D( ~/ Y3 z) u' x8 x                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
   
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
% V5 E0 v: t# j4 Q; q                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
7 K* {3 W9 ~6 Z. Q# D. D. M: L( N         
8 K& ]  m5 p# R: N) n content += "<td>" + ((users.SelectSingleNode("email") != null) ?
                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
* b5 D2 c/ z5 A$ p% P7 k, A) Z}

  ^* p" m1 s7 a+ rcontent += "" +
    "</tbody>" +
) H  B! V7 a; c  "</table>";

4 [1 \. N" m! Z! @1 p* ?; rreturn myInnovator.newResult(content);

' e8 u$ e9 Z' w6 F3 O6 }7 F