• Главная
• CSDataBase
• cDataBase

C# Класс CSDataBase.cDataBase

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
addNew ( DataTable dt, DataRow &dr ) : bool
asyncOpenRsEx ( string sqlstmt ) : System.Data.Common.DbDataReader
beginTransaction ( ) : bool
cDataBase ( csDatabaseEngine databaseEngine ) : System
closeDb ( ) : void
commitTransaction ( ) : bool
delete ( DataRow dr, DataTable dt, DbDataAdapter da ) : bool
disconnectRecordset ( string sqlstmt, DataTable &dt ) : bool
execute ( string sqlstmt ) : bool
execute ( string sqlstmt, string function, string module, string title, eErrorLevel level ) : bool
existsInRecord ( DataRow dr, DataColumn columns, string val, bool &founded ) : bool
existsInRecord ( DataRow dr, DataColumn columns, string val, bool &founded, string function, string module, string title, eErrorLevel level ) : bool
existsInRecordEx ( DataRow dr, DataColumn columns, string val, bool &founded, bool like, string function, string module, string title, eErrorLevel level ) : bool
existsInRecordset ( DataTable dt, string field, string val, bool &founded ) : bool
existsInRecordset ( DataTable dt, string field, string val, bool &founded, string function, string module, string title, eErrorLevel level ) : bool
getData ( string table, string fieldId, string id, string field, System.DateTime &data ) : bool
getData ( string table, string fieldId, string id, string field, System.DateTime &data, string function, string module, string title, eErrorLevel level ) : bool
getData ( string table, string fieldId, string id, string field, double &data ) : bool
getData ( string table, string fieldId, string id, string field, double &data, string function, string module, string title, eErrorLevel level ) : bool
getData ( string table, string fieldId, string id, string field, int &data ) : bool
getData ( string table, string fieldId, string id, string field, int &data, string function, string module, string title, eErrorLevel level ) : bool
getData ( string table, string fieldId, string id, string field, string &data ) : bool
getData ( string table, string fieldId, string id, string field, string &data, string function, string module, string title, eErrorLevel level ) : bool
getFrom ( string sqlstmt ) : string
getGroup ( string sqlstmt ) : string
getNewId ( string table, string fieldId, int &id, string function, string module, string title, eErrorLevel level ) : bool
getOrder ( string sqlstmt ) : string
getSearchSqlstmt ( string sqlstmt, string toSearch ) : string
getSelect ( string sqlstmt ) : string
getWhere ( string sqlstmt ) : string
initDb ( string connect ) : bool
initDb ( string nameDb, string server, string user, string password, string connect ) : bool
initDbEx ( string nameDb, string server, string user, string password, string connect, bool useOleDb ) : bool
loadDataTable ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, DataTable &dt, System.Data.Common.DbDataReader &dr, string function, string module, string title ) : bool
loadDataTables ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, List &dt, string function, string module, string title ) : bool
openRs ( string sqlstmt, System.Data.Common.DbDataReader &ors, string function, string module, string title, eErrorLevel level ) : bool
openRsEx ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, System.Data.Common.DbDataReader &ors ) : bool
openRsEx ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, System.Data.Common.DbDataReader &ors, string function, string module, string title ) : bool
openSchema ( ) : DataTable
openSchema ( string collectionName ) : DataTable
openSchema ( string collectionName, string restrinctionValues ) : DataTable
rollbackTransaction ( ) : void
saveSp ( string sqlstmt, System.Data.Common.DbDataReader &ors ) : bool
saveSp ( string sqlstmt, System.Data.Common.DbDataReader &ors, int timeout, string function, string module, string title, eErrorLevel level ) : bool
setCommandTimeout ( int rhs ) : void
setConnectionTimeout ( int rhs ) : void
setOpenRsExDescript ( String rhs ) : void
setSilent ( System.Boolean rhs ) : void
sqlDate ( string val ) : string
sqlNumber ( string number ) : string
sqlString ( string val ) : string
update ( DataRow dr, DataTable dt, DbDataAdapter da ) : bool

Приватные методы

Метод	Описание
createCommand ( string sqlstmt ) : DbCommand
createConnection ( ) : DbConnection
pConnect ( ) : void
pExecute ( string sqlstmt, string function, string module, string title, eErrorLevel level, bool showError ) : bool
pExistsInRecord ( DataRow dr, DataColumn columns, string val, bool &founded, bool like, string function, string module, string title, eErrorLevel level ) : bool
pGetColNameFromColExpression ( string column, string sqlstmt ) : string
pGetColumnFromStatement ( string sqlstmt, int i ) : string
pGetData ( string table, string fieldId, string id, string field, System.Data.Common.DbDataReader &ors, string function, string module, string title, eErrorLevel level ) : bool
pGetNewId ( string table, string fieldId, int &id, bool showError, string function, string module, string title, eErrorLevel level ) : bool
pGetStmtForColumn ( string column, string toSearch, string sqlstmt ) : string
pOpenRs ( string sqlstmt, System.Data.Common.DbDataReader &ors, string function, string module, string title, eErrorLevel level, bool showError ) : bool
pReconnect ( ) : void
pReconnectTry ( ) : bool
translateFromAdoIfNeeded ( string strConnect ) : string

Описание методов