C# Class SagaDB.MSSQLOperator

Show file Open project: Willyham/SagaRO2 Class Usage Examples

Public Methods

Method	Description
BeginTrans ( ) : void	��ʼһ��SQL Server��
Close ( ) : void	�ر�SQL Server��
CommitTrans ( ) : void	�ύһ��SQL Server��
ExeProcedure ( string p_ProcedureName, SqlParameter p_SqlParameterArray, int p_TableIndex ) : DataSet	ִ�д洢��
ExeProcedure ( string p_ProcedureName, SqlParameter p_SqlParameterArray ) : void	ִ�д洢��
ExeSql ( string sql, int a ) : int	ִ��һ��SQL��(INSERT)��ص�ǰID
ExeSql ( string sql ) : void	ִ��һ��SQL��(UPDATE,INSERT)
ExeSqlRows ( string sql ) : int	ִ��SQL��䷵��Ӱ��
ExeSqlScalar ( string sql ) : string	ִ��SQL��䷵�ص�һ�е�һ�е�ֵ
GetDataSet ( string sql ) : DataSet	��ȡDataSet
GetDataTable ( string sql ) : DataTable	��ȡDataTable
MSSQLOperator ( string strConnection ) : System
Open ( ) : void	��SQL Server��
RollbackTrans ( ) : void	�ع�һ��SQL Server��

Method Details

BeginTrans() public method

��ʼһ��SQL Server��

public BeginTrans ( ) : void
return	void

Close() public method

�ر�SQL Server��

public Close ( ) : void
return	void

CommitTrans() public method

�ύһ��SQL Server��

public CommitTrans ( ) : void
return	void

ExeProcedure() public method

ִ�д洢��

public ExeProcedure ( string p_ProcedureName, SqlParameter p_SqlParameterArray, int p_TableIndex ) : DataSet
p_ProcedureName	string	�洢��
p_SqlParameterArray	System.Data.SqlClient.SqlParameter	�洢��̲��
p_TableIndex	int	��ʱ��
return	System.Data.DataSet

ExeProcedure() public method

ִ�д洢��

public ExeProcedure ( string p_ProcedureName, SqlParameter p_SqlParameterArray ) : void
p_ProcedureName	string	�洢��
p_SqlParameterArray	System.Data.SqlClient.SqlParameter	�洢��̲��
return	void

ExeSql() public method

ִ��һ��SQL��(INSERT)��ص�ǰID

public ExeSql ( string sql, int a ) : int
sql	string	SQL��
a	int	��ʱ��
return	int

ExeSql() public method

ִ��һ��SQL��(UPDATE,INSERT)

public ExeSql ( string sql ) : void
sql	string	SQL��
return	void

ExeSqlRows() public method

ִ��SQL��䷵��Ӱ��

public ExeSqlRows ( string sql ) : int
sql	string	SQL��
return	int

ExeSqlScalar() public method

ִ��SQL��䷵�ص�һ�е�һ�е�ֵ

public ExeSqlScalar ( string sql ) : string
sql	string	SQL��
return	string

GetDataSet() public method

��ȡDataSet

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

GetDataTable() public method

��ȡDataTable

public GetDataTable ( string sql ) : DataTable
sql	string	SQL��
return	System.Data.DataTable

MSSQLOperator() public method

public MSSQLOperator ( string strConnection ) : System
strConnection	string
return	System

Open() public method

��SQL Server��

public Open ( ) : void
return	void

RollbackTrans() public method

�ع�һ��SQL Server��

public RollbackTrans ( ) : void
return	void