public accselect(string strsql, int total) {
3 W2 I: Y) \, ^& z$ h sql = strsql;6 b& t+ U( \/ ]5 x! X0 x
t = total;) p* l& q3 J7 F- F h9 R3 ]
}
. `/ q" X/ y& R" N3 w! R /// , s* O4 R+ Y1 x2 l; b$ q/ {
/// 构造函数
, }% c1 c# v6 c& Q: W" }) Y" C# i1 h ///
" U: i6 I& @0 b! o0 i/ q* Y6 ]$ M
) y. l) P5 M. F/ @$ s /// 参数查询语句
$ k1 z# E: j) ?! F) Q2 O4 U. G& Y5 H7 `
/// 字节数
5 n! S, ~5 V& y( W2 r2 W$ u2 ]+ }- q- `0 {1 n% r4 }! C6 D
/// OBJECT值
0 x" L8 d3 [( ~. g1 k" m- o public accselect(string strsql, int total, object value)
# {% W4 R% S0 A$ n2 q* ]9 ^ {8 \# F* O& |" u! m7 P
sql = strsql;) {: \* @# y2 T# d1 P
t = total;
. Y: N6 T' B- v/ V v = value;7 K, V1 L0 ~: k
}5 W [( G2 J4 H4 S3 V3 a0 `
/// $ |: ^% B, X1 @& D$ K
/// getOdd方法返回OleDbDataReader
3 X1 Y7 V+ V3 W8 f2 T% ?1 } ///
0 Q- k$ ?8 t# A( o1 t' D6 `: Q" g# g5 X5 X1 \
/// 定义OleDbType类型1 {. H9 W/ Q" P1 R8 X/ I
/// 1 W0 V q% Y8 t$ D4 J& T) r
public OleDbDataReader getOdd(OleDbType odt)' ?' {& C% F8 O0 B0 l+ |
{
8 z$ G' A/ h3 w4 a( m' v OleDbConnection conns = new OleDbConnection(this.conn);
: T! Q# a( G d4 B; s+ c+ t OleDbCommand cmd = new OleDbCommand(this.sql, conns);
3 u; f; p4 { ]! }0 { OleDbParameter parm = new OleDbParameter("temp", odt, this.t);
- z" M+ M T6 G4 z' @. Z parm.Direction = ParameterDirection.Input;
, m# [3 |" ^) r3 u z9 ` cmd.Parameters.Add(parm);
" \# ~1 l3 J8 \ @9 _7 r3 P( z cmd.Parameters[0].Value = this.v;
7 l! o) U5 V. O conns.Open();$ s7 f6 b! v% [3 ?* x0 z- |
OleDbDataReader oda = cmd.ExecuteReader();$ T# |+ q% |0 M& X- f9 ^7 Y8 H
cmd.Dispose();+ k+ i' h! P# V3 Y
return oda;6 L" ~" U% M v- O3 l9 d+ @
} |