C# Class DBH.Helper.Impl.DBHelperImpl

Inheritance: IDBHelper

Datei anzeigen Open project: bluedusk/DBHelper

Private Properties

Property	Type	Description
BuildSqlCommand	IDbCommand
BuildSqlCommand	IDbCommand
Close	void
CreateCommand	IDbCommand
CreateDbConnection	IDbConnection
CreateDbDataAdapter	DbDataAdapter
CreateDbParameter	IDbDataParameter
DeriveParameters	void
isPk	bool

Public Methods

Method	Description
AbortTransaction ( ) : void
BeginTransaction ( ) : void
CommitTransaction ( ) : void
DBHelperImpl ( string dsName ) : System
Delete ( DataRow obj ) : int
Dispose ( ) : void
ExecuteQuery ( IDbDataAdapter &da, string sql ) : DataTable
ExecuteQuery ( string sql ) : DataTable
ExecuteQuery ( string sql, int pageId, int pageSize ) : DataTable
ExecuteUpdate ( string sql ) : int
ExecuteUpdate ( string sql, Hashtable parameters ) : int
Insert ( DataRow obj ) : int
NewDataRow ( string tableName ) : DataRow
Save ( DataRow obj ) : int
Update ( DataRow obj ) : int

Private Methods

Method	Description
BuildSqlCommand ( string sql ) : IDbCommand
BuildSqlCommand ( string sql, Hashtable parameters ) : IDbCommand
Close ( ) : void
CreateCommand ( ) : IDbCommand
CreateDbConnection ( string dsName ) : IDbConnection
CreateDbDataAdapter ( IDbCommand dbCommand ) : DbDataAdapter
CreateDbParameter ( string parameterName, object value ) : IDbDataParameter
DeriveParameters ( IDbCommand spCommand ) : void
isPk ( DataTable dt, DataColumn dc ) : bool

Method Details

AbortTransaction() public method

public AbortTransaction ( ) : void
return	void

BeginTransaction() public method

public BeginTransaction ( ) : void
return	void

CommitTransaction() public method

public CommitTransaction ( ) : void
return	void

DBHelperImpl() public method

public DBHelperImpl ( string dsName ) : System
dsName	string
return	System

Delete() public method

public Delete ( DataRow obj ) : int
obj	DataRow
return	int

Dispose() public method

public Dispose ( ) : void
return	void

ExecuteQuery() public method

public ExecuteQuery ( IDbDataAdapter &da, string sql ) : DataTable
da	IDbDataAdapter
sql	string
return	DataTable

ExecuteQuery() public method

public ExecuteQuery ( string sql ) : DataTable
sql	string
return	DataTable

ExecuteQuery() public method

public ExecuteQuery ( string sql, int pageId, int pageSize ) : DataTable
sql	string
pageId	int
pageSize	int
return	DataTable

ExecuteUpdate() public method

public ExecuteUpdate ( string sql ) : int
sql	string
return	int

ExecuteUpdate() public method

public ExecuteUpdate ( string sql, Hashtable parameters ) : int
sql	string
parameters	Hashtable
return	int

Insert() public method

public Insert ( DataRow obj ) : int
obj	DataRow
return	int

NewDataRow() public method

public NewDataRow ( string tableName ) : DataRow
tableName	string
return	DataRow

Save() public method

public Save ( DataRow obj ) : int
obj	DataRow
return	int

Update() public method

public Update ( DataRow obj ) : int
obj	DataRow
return	int