C# Class SagaDB.MSSQLOperator

显示文件 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