C# Class DBH.Helper.DBHelper

显示文件 Open project: bluedusk/DBHelper

Public Properties

Property	Type	Description
DBPrefix	string

Public Methods

Method	Description
DataTableDelete ( DataTable _dt ) : int
DataTableInsert ( DataTable _dt ) : int
DataTableUpdate ( DataTable _dt ) : int
ExecuteNoQuery ( StringBuilder sbsql ) : int	非查询操作
ExecuteNoQuery ( string sql ) : int	非查询操作
ExecuteNoQuery ( string sql, DBHelperParmCollection parameters ) : int	非查询操作
ExecuteProcedureNoQuery ( string procedureName, DBHelperParmCollection parameters ) : int
ExecuteProcedureQuery ( string procedureName, DBHelperParmCollection parameters ) : DataTable
ExecuteQuery ( string sql ) : DataTable	查询操作
ExecuteQuery ( string sql, DBHelperParmCollection parms ) : DataTable	查询操作
ExecuteQuery ( string sql, string tableName ) : DataTable
ExecuteReader ( string sql ) : IDataReader	查询数据库，返回DataReader
ExecuteScalar ( string sql ) : object	非查询操作
ExecuteTransaction ( string sqls ) : int	执行Transaction，完成后关闭连接
GetDataSet ( string sql ) : DataSet	查询操作返回DataSet
SetDBConfig ( string dataSourceName ) : void	设置dbhelper数据源
SetDBConfig ( string DBType, string ConnStr, string DBEncoding ) : void	初始化数据库连接(使用字符串)
SetDBPrefix ( string _DBPrefix ) : void	设置数据库前缀

Private Methods

Method	Description
CreateHelper ( ) : DBHelperBase

Method Details

DataTableDelete() public static method

public static DataTableDelete ( DataTable _dt ) : int
_dt	System.Data.DataTable
return	int

DataTableInsert() public static method

public static DataTableInsert ( DataTable _dt ) : int
_dt	System.Data.DataTable
return	int

DataTableUpdate() public static method

public static DataTableUpdate ( DataTable _dt ) : int
_dt	System.Data.DataTable
return	int

ExecuteNoQuery() public static method

非查询操作

public static ExecuteNoQuery ( StringBuilder sbsql ) : int
sbsql	StringBuilder
return	int

ExecuteNoQuery() public static method

非查询操作

public static ExecuteNoQuery ( string sql ) : int
sql	string
return	int

ExecuteNoQuery() public static method

非查询操作

public static ExecuteNoQuery ( string sql, DBHelperParmCollection parameters ) : int
sql	string	sql字符串
parameters	DBHelperParmCollection	参数集合
return	int

ExecuteProcedureNoQuery() public static method

public static ExecuteProcedureNoQuery ( string procedureName, DBHelperParmCollection parameters ) : int
procedureName	string
parameters	DBHelperParmCollection
return	int

ExecuteProcedureQuery() public static method

public static ExecuteProcedureQuery ( string procedureName, DBHelperParmCollection parameters ) : DataTable
procedureName	string
parameters	DBHelperParmCollection
return	System.Data.DataTable

ExecuteQuery() public static method

查询操作

public static ExecuteQuery ( string sql ) : DataTable
sql	string
return	System.Data.DataTable

ExecuteQuery() public static method

查询操作

public static ExecuteQuery ( string sql, DBHelperParmCollection parms ) : DataTable
sql	string	sql字符串
parms	DBHelperParmCollection	参数列表
return	System.Data.DataTable

ExecuteQuery() public static method

public static ExecuteQuery ( string sql, string tableName ) : DataTable
sql	string
tableName	string
return	System.Data.DataTable

ExecuteReader() public static method

查询数据库，返回DataReader

public static ExecuteReader ( string sql ) : IDataReader
sql	string
return	IDataReader

ExecuteScalar() public static method

非查询操作

public static ExecuteScalar ( string sql ) : object
sql	string	sql字符串
return	object

ExecuteTransaction() public static method

执行Transaction，完成后关闭连接

public static ExecuteTransaction ( string sqls ) : int
sqls	string	sql数组
return	int

GetDataSet() public static method

查询操作返回DataSet

public static GetDataSet ( string sql ) : DataSet
sql	string
return	System.Data.DataSet

SetDBConfig() public static method

设置dbhelper数据源

public static SetDBConfig ( string dataSourceName ) : void
dataSourceName	string
return	void

SetDBConfig() public static method

初始化数据库连接(使用字符串)

public static SetDBConfig ( string DBType, string ConnStr, string DBEncoding ) : void
DBType	string	数据库类型
ConnStr	string	数据库连接字符串
DBEncoding	string	数据库编码(仅对Sybase)
return	void

SetDBPrefix() public static method

设置数据库前缀

public static SetDBPrefix ( string _DBPrefix ) : void
_DBPrefix	string
return	void

Property Details

DBPrefix public_oe static_oe property

public static string DBPrefix
return	string