C# Class com.Sconit.Persistence.SqlHelperDao

Inheritance: ISqlHelperDao

Mostra file Open project: Novthirteen/yfkey-scms Class Usage Examples

Public Methods

Method	Description
Create ( string sqlString, SqlParameter commandParameters ) : int
Delete ( string sqlString, SqlParameter commandParameters ) : int
ExecuteSql ( string commandText, SqlParameter commandParameters ) : int
ExecuteStoredProcedure ( string commandText, SqlParameter commandParameters ) : int
GetDatasetBySql ( string commandText, SqlParameter commandParameters ) : DataSet
GetDatasetByStoredProcedure ( string commandText, SqlParameter commandParameters ) : DataSet
SearchCount ( string sqlString, SqlParameter commandParameters ) : int
Update ( string sqlString, SqlParameter commandParameters ) : int

Private Methods

Method	Description
ExecuteNonQuery ( CommandType commandType, string commandText, SqlParameter commandParameters ) : int
GetDataset ( CommandType commandType, string commandText, SqlParameter commandParameters ) : DataSet

Method Details

Create() public method

public Create ( string sqlString, SqlParameter commandParameters ) : int
sqlString	string
commandParameters	System.Data.SqlClient.SqlParameter
return	int

Delete() public method

public Delete ( string sqlString, SqlParameter commandParameters ) : int
sqlString	string
commandParameters	System.Data.SqlClient.SqlParameter
return	int

ExecuteSql() public method

public ExecuteSql ( string commandText, SqlParameter commandParameters ) : int
commandText	string
commandParameters	System.Data.SqlClient.SqlParameter
return	int

ExecuteStoredProcedure() public method

public ExecuteStoredProcedure ( string commandText, SqlParameter commandParameters ) : int
commandText	string
commandParameters	System.Data.SqlClient.SqlParameter
return	int

GetDatasetBySql() public method

public GetDatasetBySql ( string commandText, SqlParameter commandParameters ) : DataSet
commandText	string
commandParameters	System.Data.SqlClient.SqlParameter
return	System.Data.DataSet

GetDatasetByStoredProcedure() public method

public GetDatasetByStoredProcedure ( string commandText, SqlParameter commandParameters ) : DataSet
commandText	string
commandParameters	System.Data.SqlClient.SqlParameter
return	System.Data.DataSet

SearchCount() public method

public SearchCount ( string sqlString, SqlParameter commandParameters ) : int
sqlString	string
commandParameters	System.Data.SqlClient.SqlParameter
return	int

Update() public method

public Update ( string sqlString, SqlParameter commandParameters ) : int
sqlString	string
commandParameters	System.Data.SqlClient.SqlParameter
return	int