C# Class CSDataBase.cDataBase

Afficher le fichier Open project: javiercrowsoft/CSReports.net Class Usage Examples

Méthodes publiques

Méthode	Description
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

Private Methods

Méthode	Description
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

Method Details

addNew() public méthode

public addNew ( DataTable dt, DataRow &dr ) : bool
dt	System.Data.DataTable
dr	System.Data.DataRow
Résultat	bool

asyncOpenRsEx() public méthode

public asyncOpenRsEx ( string sqlstmt ) : System.Data.Common.DbDataReader
sqlstmt	string
Résultat	System.Data.Common.DbDataReader

beginTransaction() public méthode

public beginTransaction ( ) : bool
Résultat	bool

cDataBase() public méthode

public cDataBase ( csDatabaseEngine databaseEngine ) : System
databaseEngine	csDatabaseEngine
Résultat	System

closeDb() public méthode

public closeDb ( ) : void
Résultat	void

commitTransaction() public méthode

public commitTransaction ( ) : bool
Résultat	bool

delete() public méthode

public delete ( DataRow dr, DataTable dt, DbDataAdapter da ) : bool
dr	System.Data.DataRow
dt	System.Data.DataTable
da	System.Data.Common.DbDataAdapter
Résultat	bool

disconnectRecordset() public méthode

public disconnectRecordset ( string sqlstmt, DataTable &dt ) : bool
sqlstmt	string
dt	System.Data.DataTable
Résultat	bool

execute() public méthode

public execute ( string sqlstmt ) : bool
sqlstmt	string
Résultat	bool

execute() public méthode

public execute ( string sqlstmt, string function, string module, string title, eErrorLevel level ) : bool
sqlstmt	string
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

existsInRecord() public méthode

public existsInRecord ( DataRow dr, DataColumn columns, string val, bool &founded ) : bool
dr	System.Data.DataRow
columns	System.Data.DataColumn
val	string
founded	bool
Résultat	bool

existsInRecord() public méthode

public existsInRecord ( DataRow dr, DataColumn columns, string val, bool &founded, string function, string module, string title, eErrorLevel level ) : bool
dr	System.Data.DataRow
columns	System.Data.DataColumn
val	string
founded	bool
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

existsInRecordEx() public méthode

public existsInRecordEx ( DataRow dr, DataColumn columns, string val, bool &founded, bool like, string function, string module, string title, eErrorLevel level ) : bool
dr	System.Data.DataRow
columns	System.Data.DataColumn
val	string
founded	bool
like	bool
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

existsInRecordset() public méthode

public existsInRecordset ( DataTable dt, string field, string val, bool &founded ) : bool
dt	System.Data.DataTable
field	string
val	string
founded	bool
Résultat	bool

existsInRecordset() public méthode

public existsInRecordset ( DataTable dt, string field, string val, bool &founded, string function, string module, string title, eErrorLevel level ) : bool
dt	System.Data.DataTable
field	string
val	string
founded	bool
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, System.DateTime &data ) : bool
table	string
fieldId	string
id	string
field	string
data	System.DateTime
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, System.DateTime &data, string function, string module, string title, eErrorLevel level ) : bool
table	string
fieldId	string
id	string
field	string
data	System.DateTime
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, double &data ) : bool
table	string
fieldId	string
id	string
field	string
data	double
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, double &data, string function, string module, string title, eErrorLevel level ) : bool
table	string
fieldId	string
id	string
field	string
data	double
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, int &data ) : bool
table	string
fieldId	string
id	string
field	string
data	int
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, int &data, string function, string module, string title, eErrorLevel level ) : bool
table	string
fieldId	string
id	string
field	string
data	int
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, string &data ) : bool
table	string
fieldId	string
id	string
field	string
data	string
Résultat	bool

getData() public méthode

public getData ( string table, string fieldId, string id, string field, string &data, string function, string module, string title, eErrorLevel level ) : bool
table	string
fieldId	string
id	string
field	string
data	string
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

getFrom() public méthode

public getFrom ( string sqlstmt ) : string
sqlstmt	string
Résultat	string

getGroup() public méthode

public getGroup ( string sqlstmt ) : string
sqlstmt	string
Résultat	string

getNewId() public méthode

public getNewId ( string table, string fieldId, int &id, string function, string module, string title, eErrorLevel level ) : bool
table	string
fieldId	string
id	int
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

getOrder() public méthode

public getOrder ( string sqlstmt ) : string
sqlstmt	string
Résultat	string

getSearchSqlstmt() public méthode

public getSearchSqlstmt ( string sqlstmt, string toSearch ) : string
sqlstmt	string
toSearch	string
Résultat	string

getSelect() public méthode

public getSelect ( string sqlstmt ) : string
sqlstmt	string
Résultat	string

getWhere() public méthode

public getWhere ( string sqlstmt ) : string
sqlstmt	string
Résultat	string

initDb() public méthode

public initDb ( string connect ) : bool
connect	string
Résultat	bool

initDb() public méthode

public initDb ( string nameDb, string server, string user, string password, string connect ) : bool
nameDb	string
server	string
user	string
password	string
connect	string
Résultat	bool

initDbEx() public méthode

public initDbEx ( string nameDb, string server, string user, string password, string connect, bool useOleDb ) : bool
nameDb	string
server	string
user	string
password	string
connect	string
useOleDb	bool
Résultat	bool

loadDataTable() public méthode

public loadDataTable ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, DataTable &dt, System.Data.Common.DbDataReader &dr, string function, string module, string title ) : bool
showWindowCancel	bool
raiseProgressEvent	bool
showModal	bool
sqlstmt	string
dt	System.Data.DataTable
dr	System.Data.Common.DbDataReader
function	string
module	string
title	string
Résultat	bool

loadDataTables() public méthode

public loadDataTables ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, List &dt, string function, string module, string title ) : bool
showWindowCancel	bool
raiseProgressEvent	bool
showModal	bool
sqlstmt	string
dt	List
function	string
module	string
title	string
Résultat	bool

openRs() public méthode

public openRs ( string sqlstmt, System.Data.Common.DbDataReader &ors, string function, string module, string title, eErrorLevel level ) : bool
sqlstmt	string
ors	System.Data.Common.DbDataReader
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

openRsEx() public méthode

public openRsEx ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, System.Data.Common.DbDataReader &ors ) : bool
showWindowCancel	bool
raiseProgressEvent	bool
showModal	bool
sqlstmt	string
ors	System.Data.Common.DbDataReader
Résultat	bool

openRsEx() public méthode

public openRsEx ( bool showWindowCancel, bool raiseProgressEvent, bool showModal, string sqlstmt, System.Data.Common.DbDataReader &ors, string function, string module, string title ) : bool
showWindowCancel	bool
raiseProgressEvent	bool
showModal	bool
sqlstmt	string
ors	System.Data.Common.DbDataReader
function	string
module	string
title	string
Résultat	bool

openSchema() public méthode

public openSchema ( ) : DataTable
Résultat	System.Data.DataTable

openSchema() public méthode

public openSchema ( string collectionName ) : DataTable
collectionName	string
Résultat	System.Data.DataTable

openSchema() public méthode

public openSchema ( string collectionName, string restrinctionValues ) : DataTable
collectionName	string
restrinctionValues	string
Résultat	System.Data.DataTable

rollbackTransaction() public méthode

public rollbackTransaction ( ) : void
Résultat	void

saveSp() public méthode

public saveSp ( string sqlstmt, System.Data.Common.DbDataReader &ors ) : bool
sqlstmt	string
ors	System.Data.Common.DbDataReader
Résultat	bool

saveSp() public méthode

public saveSp ( string sqlstmt, System.Data.Common.DbDataReader &ors, int timeout, string function, string module, string title, eErrorLevel level ) : bool
sqlstmt	string
ors	System.Data.Common.DbDataReader
timeout	int
function	string
module	string
title	string
level	eErrorLevel
Résultat	bool

setCommandTimeout() public méthode

public setCommandTimeout ( int rhs ) : void
rhs	int
Résultat	void

setConnectionTimeout() public méthode

public setConnectionTimeout ( int rhs ) : void
rhs	int
Résultat	void

setOpenRsExDescript() public méthode

public setOpenRsExDescript ( String rhs ) : void
rhs	String
Résultat	void

setSilent() public méthode

public setSilent ( System.Boolean rhs ) : void
rhs	System.Boolean
Résultat	void

sqlDate() public static méthode

public static sqlDate ( string val ) : string
val	string
Résultat	string

sqlNumber() public static méthode

public static sqlNumber ( string number ) : string
number	string
Résultat	string

sqlString() public static méthode

public static sqlString ( string val ) : string
val	string
Résultat	string

update() public méthode

public update ( DataRow dr, DataTable dt, DbDataAdapter da ) : bool
dr	System.Data.DataRow
dt	System.Data.DataTable
da	System.Data.Common.DbDataAdapter
Résultat	bool