当前文件路径：JohnTree/JohnTree.Library/DbHelpers.cs

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.SqlClient;
 6
 7namespace JohnTree.Library
 8...{
 9    public class DbHelpers : DBConfig
10    ...{
11        Helpers#region Helpers
12
13        public IDataReader GetReader( CommandType commandType, string sql )
14        ...{
15            return SqlHelper.ExecuteReader(ConnectionString, commandType, sql);
16        }
17
18        public IDataReader GetReader( CommandType commandType, string sql, SqlParameter[] p )
19        ...{
20            return SqlHelper.ExecuteReader(ConnectionString, commandType, sql, p);
21        }
22
23        public DataSet GetDataset( CommandType commandType, string sql )
24        ...{
25            return SqlHelper.ExecuteDataset(ConnectionString, commandType, sql);
26        }
27
28        public DataSet GetDataset( CommandType commandType, string sql, SqlParameter[] p )
29        ...{
30            return SqlHelper.ExecuteDataset(ConnectionString, commandType, sql, p);
31        }
32
33        public int NonQueryInt( CommandType commandType, string sql )
34        ...{
35            return SqlHelper.ExecuteNonQuery(ConnectionString, commandType, sql);
36        }
37
38        public int NonQueryInt( CommandType commandType, string sql, SqlParameter[] p )
39        ...{
40            return SqlHelper.ExecuteNonQuery(ConnectionString, commandType, sql, p);
41        }
42
43        public bool NonQueryBool( CommandType commandType, string sql )
44        ...{
45            return NonQueryInt(commandType, sql) > 0;
46        }
47
48        public bool NonQueryBool( CommandType commandType, string sql, SqlParameter[] p )
49        ...{
50            return NonQueryInt(commandType, sql, p) > 0;
51        }
52
53        public object NonQueryScalar( CommandType commandType, string sql )
54        ...{
55            return SqlHelper.ExecuteScalar(ConnectionString, commandType, sql);
56        }
57
58        public object NonQueryScalar( CommandType commandType, string sql, SqlParameter[] p )
59        ...{
60            return SqlHelper.ExecuteScalar(ConnectionString, commandType, sql, p);
61        }
62
63        #endregion
64    }
65}
66