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

admin

6 h; k7 b. f) B# _
4 F6 Z0 }! V# n! C2 BTechnique  
5 Z, y: C3 ]4 m( }) kUse the  Innovator.applySQL( … )  method to submit SQL direct to the database.  This
6 d, C' {8 v' J" k5 i. O* M! |recipe returns the XML from the  applySQL()  method and forms HTML for a table to
display the data.

2 _! E! ^; c5 S
C#  
3 a; t( M7 N1 \9 pInnovator myInnovator = this.newInnovator();
Item results = myInnovator.applySQL(
8 N" c( E7 j9 C. ^2 r" ]) l  "select login_name,first_name,last_name,email " +
  "from [user] " +
! A) D/ {- v  r0 }9 l  m# _  "order by last_name,first_name");

string content = "" +
( |% ]2 U9 I  e$ C4 }% e  "<style type='text/css'>" +
+ v9 R. x' M: u3 z, x    "table {background:#000000;}" +
    "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>" +
2 c) s1 ^3 J, ~: G% T7 f    "<table id='tbl' border='0' cellspacing='1' cellpadding='2' datasrc='#itemData'>" +
0 \: V/ d, `( w. D+ m: H    "<caption>User Directory</caption>" +
% g& B! |! \0 T* a6 ~    "<thead>" +
      "<tr>" +
- V" p6 L0 b9 a6 Q( X- V/ z/ d, f        "<th>Login Name</th>" +
        "<th>First Name</th>" +
        "<th>Last Name</th>" +
4 f7 a1 P' h$ G9 ?        "<th>EMail</th>" +
      "</tr>" +
3 z# a9 m- K2 K" P: H  i    "</thead>" +
. V. f" `% o+ ?% M5 c) B    "<tbody>";
     
0 {: J: z4 D  P: p& QXmlNodeList users = results.dom.SelectNodes("//recordset/row");
; _) N" l/ W- D+ Gfor (int i=0; i<users.Count; i++) {
6 s3 U% m9 S& Z2 x! X content += "<tr><td>" + ((users.SelectSingleNode("login_name") != null) ?  
$ s! p4 [& `+ l8 R                       users.SelectSingleNode("login_name").InnerText : "") + "</td>";   
   
, s9 H( j4 n$ ^% \) B, m5 h& V6 i content += "<td>" + ((users.SelectSingleNode("first_name") != null) ?
6 u4 q' O4 e) }: ]1 V+ F# j) g                       users.SelectSingleNode("first_name").InnerText : "") + "</td>";   
; q  ^: m4 }% c! ~& a   
content += "<td>" + ((users.SelectSingleNode("last_name") != null) ?
0 ~" c' Z" e! H0 u! S7 _. _6 x& w                       users.SelectSingleNode("last_name").InnerText : "") + "</td>";   
         
! f1 N0 f- D0 a% q8 K* k content += "<td>" + ((users.SelectSingleNode("email") != null) ?
) y  S; v8 I) f$ |6 s3 ?# b                       users.SelectSingleNode("email").InnerText : "") + "</td></tr>";   
   
}
8 K# @7 X0 C" k" n1 I
content += "" +
5 W, ?5 }# X& c" u! V. l: g    "</tbody>" +
& n' m/ I! c: H! G4 q& U* T  "</table>";
9 Z: _5 Z6 @2 F% S5 p  a4 {1 q6 }
return myInnovator.newResult(content);