public accselect(string strsql, int total) {
* j5 l& q( N7 H2 _5 B sql = strsql;8 y# f# I) L n
t = total;
4 b$ d: g- {( h6 Q6 | }8 k: v: J$ y8 Z6 L! ]
///
* j5 ?* _6 @ o /// 构造函数
' ^5 \% o! C5 J! h- M ///
, Q6 u3 z0 w# n" h
' H8 v* N3 K' g /// 参数查询语句
# N/ n& e; q4 v5 h1 z
. v7 v! `1 x7 R; j /// 字节数
6 t3 p- w: {% j8 ^+ @; E8 D0 q$ f" g8 Q6 H9 B. L- T/ Z
/// OBJECT值( G' B: {! m" K' n4 v
public accselect(string strsql, int total, object value)0 @; T5 f3 W' [% D, o$ o
{8 z# c7 Q% [ [' K+ {3 L+ e L
sql = strsql;. S" F+ E- V' h2 C6 H {$ s9 j1 S* M
t = total;/ Q+ S, D% L m* B
v = value;' A" a! g1 ~8 \6 Y, b" D& ]' B
}
' d2 ~! k6 L1 F* A /// : n. O5 g# ?) |* T% a+ q8 V
/// getOdd方法返回OleDbDataReader
; b: F. R% U$ G" B) L /// 9 e% X# |7 n5 S! q$ C
/ N; Y' \9 @; M v. B /// 定义OleDbType类型
/ A# Z& t2 u6 G1 u0 B. q7 b6 ~! d3 N /// ( N% y0 t5 h3 x& x
public OleDbDataReader getOdd(OleDbType odt), Z; w: q& w0 J8 U
{
0 |1 {' y" n4 ?! E8 U: R OleDbConnection conns = new OleDbConnection(this.conn);
% _ T$ A8 |; h/ B OleDbCommand cmd = new OleDbCommand(this.sql, conns);& g* X! w& d- |6 B* Z8 ?
OleDbParameter parm = new OleDbParameter("temp", odt, this.t);) {- z) q" A0 m7 s, _8 h+ i
parm.Direction = ParameterDirection.Input;) C X B2 u7 q+ f% M. C, ]
cmd.Parameters.Add(parm);7 F$ j4 d/ n+ e
cmd.Parameters[0].Value = this.v;
# q' N: `+ A. w5 O8 K- F) \* l conns.Open();- B: x( F7 D1 y1 g5 }/ P6 l) M
OleDbDataReader oda = cmd.ExecuteReader();
1 h' G+ h9 V+ B9 U* W3 f8 ?" B cmd.Dispose();
+ W' L9 n; H5 F! N return oda;% G: V4 e( l$ u6 G; x; l: ]7 V
} |