public accselect(string strsql, int total) {6 x9 s" }8 P' H
sql = strsql;
( b, C9 c1 ]# L2 ^4 G3 Z8 N% i$ J t = total;9 ~1 U3 f: E) d! x
}
; T3 I$ L, U8 T" L/ j: L7 b. }! A; f ///
# g: L; }( d, p1 T /// 构造函数; r* y5 L; B& H9 e7 P
///
* p" j8 o) {& ~9 ]* A6 G( L. u$ k) ?. k& J1 X8 ~
/// 参数查询语句" x! U8 I+ w' p- }% H. z- j% ~* P
# f% u. K1 B+ O2 s0 L! u
/// 字节数1 B. |. P! X1 h% Z
0 T0 @* ^5 e8 ^9 ^
/// OBJECT值9 A- J) U( Q% X7 Y
public accselect(string strsql, int total, object value)
, R7 U0 Z: a9 D' u+ L$ R2 ? {# h- K" u6 m) G5 _9 F
sql = strsql;; R/ v& |& l. M; M* p( G1 l9 w
t = total;/ [+ l) K, D# i! t* I
v = value;
' h9 E( l+ P! \; ~% d8 s }
) l( J6 j9 {) I9 u6 T3 V /// 8 a6 Q* Q, i* [( ^1 l
/// getOdd方法返回OleDbDataReader
' Q5 @% H5 E2 p( |" a7 U: a ///
/ x# f" s# [2 {7 @
. ~: W) b1 i+ I; w% r d U& Q' O$ W /// 定义OleDbType类型$ ?" R) r; | G' ~2 K/ a
/// " V; T7 Y2 R$ X: n% o
public OleDbDataReader getOdd(OleDbType odt)
0 I" k7 A4 i( A1 ?- E" f; @ {$ a! z {! t! g: h
OleDbConnection conns = new OleDbConnection(this.conn);+ m6 f( F& {9 j! x
OleDbCommand cmd = new OleDbCommand(this.sql, conns);
! o( c7 O$ ^" D' f+ U6 d* P% Q OleDbParameter parm = new OleDbParameter("temp", odt, this.t);3 i6 B- k. j1 a! \
parm.Direction = ParameterDirection.Input;
% v! l% @! |% S cmd.Parameters.Add(parm);
# Z/ _8 @$ V; `# p6 Y: N cmd.Parameters[0].Value = this.v;& x& |* z# J# {' W% p. G; e" ]
conns.Open();8 ]# q4 Y R8 t9 R1 s2 c5 w
OleDbDataReader oda = cmd.ExecuteReader();
" ~4 p E6 [& a cmd.Dispose();
$ X; c' V7 O' h! N6 c0 L return oda;
3 ]+ H5 Q$ k; ]3 ~1 H } |