123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270 |
- using System;
- using System.Data;
- namespace ETD.Data
- {
-
-
-
- public interface IDBHandlerble : IDisposable
- {
-
-
-
-
-
-
-
- void AddParameter(string paramName, DbType paramType, ParameterDirection p_objDirection);
-
-
-
-
-
-
-
-
- void AddParameter(string paramName, DbType paramType, ParameterDirection p_objDirection, object pValue);
-
-
-
-
-
-
-
-
- void AddParameter(string paramName, DbType paramType, int paramSize, ParameterDirection p_objDirection);
-
-
-
-
-
-
-
-
-
- void AddParameter(string paramName, DbType paramType, int paramSize, ParameterDirection p_objDirection, object pValue);
-
-
-
- void BeginTransaction();
-
-
-
- void CommitTransaction();
-
-
-
-
- void ConnectionClose();
-
-
-
-
- void ConnectionOpen();
-
-
-
-
-
- IDbDataAdapter ExecuteAdapter(string commandText);
-
-
-
-
-
-
- IDbDataAdapter ExecuteAdapter(string commandText, CommandType commandType);
-
-
-
-
-
- DataSet ExecuteDataSet(string commandText);
-
-
-
-
-
-
- DataSet ExecuteDataSet(string commandText, CommandType commandType);
-
-
-
-
-
-
-
- DataSet ExecuteDataSet(string commandText, CommandType commandType, string tableName);
-
-
-
-
-
-
-
-
- DataSet ExecuteDataSet(string dataSetName, string commandText, CommandType commandType, string tableName);
-
-
-
-
-
- DataTable ExecuteDataTable(string commandText);
-
-
-
-
-
-
- DataTable ExecuteDataTable(string commandText, bool isCloseConnection);
-
-
-
-
-
-
- DataTable ExecuteDataTable(string commandText, CommandType commandType);
-
-
-
-
-
-
-
- DataTable ExecuteDataTable(string commandText, CommandType commandType, string tableName);
-
-
-
-
-
-
-
-
- DataTable ExecuteDataTable(string commandText, CommandType commandType, string tableName, bool isCloseConnection);
-
-
-
-
-
-
-
-
-
-
- DataTable ExecuteDataTable(int page, int pageSize, ref int recordCount, string strFields, string strOrderBy, string strTableName);
-
-
-
-
-
- int ExecuteNonQuery(string commandText);
-
-
-
-
-
-
- int ExecuteNonQuery(string commandText, bool isCloseConnection);
-
-
-
-
-
-
- int ExecuteNonQuery(string commandText, CommandType commandType);
-
-
-
-
-
-
-
- int ExecuteNonQuery(string commandText, CommandType commandType, bool isCloseConnection);
-
-
-
-
-
- IDataReader ExecuteReader(string commandText);
-
-
-
-
-
-
- IDataReader ExecuteReader(string commandText, CommandType commandType);
-
-
-
-
-
-
-
- IDataReader ExecuteReader(string commandText, CommandType commandType, CommandBehavior p_objBehaviour);
-
-
-
-
-
- object ExecuteScalar(string commandText);
-
-
-
-
-
-
- object ExecuteScalar(string commandText, bool isCloseConnection);
-
-
-
-
-
-
-
- object ExecuteScalar(string commandText, CommandType commandType, bool isCloseConnection);
-
-
-
-
-
- string GetDataLink(string ModuleName);
-
-
-
-
-
- object GetParameter(string paramName);
-
-
-
-
-
- void LoadDataSet(DataSet dataSet, string[] tableNames);
-
-
-
-
-
- void LoadDataSet(DataSet dataSet, string tableName);
-
-
-
-
-
- void ModifyParameter(string paramName, object pValue);
-
-
-
- void RemoveAllParameters();
-
-
-
-
- void RemoveParameter(string paramName);
-
-
-
- void RollbackTransaction();
- }
- }
|