C# Class CSDataBase.cDataBase

Show file Open project: javiercrowsoft/CSReports.net Class Usage Examples

Public Methods

Method	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

Method	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 method

public addNew ( DataTable dt, DataRow &dr ) : bool
dt	System.Data.DataTable
dr	System.Data.DataRow
return	bool

asyncOpenRsEx() public method

public asyncOpenRsEx ( string sqlstmt ) : System.Data.Common.DbDataReader
sqlstmt	string
return	System.Data.Common.DbDataReader

beginTransaction() public method

public beginTransaction ( ) : bool
return	bool

cDataBase() public method

public cDataBase ( csDatabaseEngine databaseEngine ) : System
databaseEngine	csDatabaseEngine
return	System

closeDb() public method

public closeDb ( ) : void
return	void

commitTransaction() public method

public commitTransaction ( ) : bool
return	bool

delete() public method

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

disconnectRecordset() public method

public disconnectRecordset ( string sqlstmt, DataTable &dt ) : bool
sqlstmt	string
dt	System.Data.DataTable
return	bool

execute() public method

public execute ( string sqlstmt ) : bool
sqlstmt	string
return	bool

execute() public method

public execute ( string sqlstmt, string function, string module, string title, eErrorLevel level ) : bool
sqlstmt	string
function	string
module	string
title	string
level	eErrorLevel
return	bool

existsInRecord() public method

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

existsInRecord() public method

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
return	bool

existsInRecordEx() public method

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
return	bool

existsInRecordset() public method

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

existsInRecordset() public method

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
return	bool

getData() public method

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
return	bool

getData() public method

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
return	bool

getData() public method

public getData ( string table, string fieldId, string id, string field, double &data ) : bool
table	string
fieldId	string
id	string
field	string
data	double
return	bool

getData() public method

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
return	bool

getData() public method

public getData ( string table, string fieldId, string id, string field, int &data ) : bool
table	string
fieldId	string
id	string
field	string
data	int
return	bool

getData() public method

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
return	bool

getData() public method

public getData ( string table, string fieldId, string id, string field, string &data ) : bool
table	string
fieldId	string
id	string
field	string
data	string
return	bool

getData() public method

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
return	bool

getFrom() public method

public getFrom ( string sqlstmt ) : string
sqlstmt	string
return	string

getGroup() public method

public getGroup ( string sqlstmt ) : string
sqlstmt	string
return	string

getNewId() public method

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
return	bool

getOrder() public method

public getOrder ( string sqlstmt ) : string
sqlstmt	string
return	string

getSearchSqlstmt() public method

public getSearchSqlstmt ( string sqlstmt, string toSearch ) : string
sqlstmt	string
toSearch	string
return	string

getSelect() public method

public getSelect ( string sqlstmt ) : string
sqlstmt	string
return	string

getWhere() public method

public getWhere ( string sqlstmt ) : string
sqlstmt	string
return	string

initDb() public method

public initDb ( string connect ) : bool
connect	string
return	bool

initDb() public method

public initDb ( string nameDb, string server, string user, string password, string connect ) : bool
nameDb	string
server	string
user	string
password	string
connect	string
return	bool

initDbEx() public method

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
return	bool

loadDataTable() public method

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
return	bool

loadDataTables() public method

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
return	bool

openRs() public method

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
return	bool

openRsEx() public method

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
return	bool

openRsEx() public method

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
return	bool

openSchema() public method

public openSchema ( ) : DataTable
return	System.Data.DataTable

openSchema() public method

public openSchema ( string collectionName ) : DataTable
collectionName	string
return	System.Data.DataTable

openSchema() public method

public openSchema ( string collectionName, string restrinctionValues ) : DataTable
collectionName	string
restrinctionValues	string
return	System.Data.DataTable

rollbackTransaction() public method

public rollbackTransaction ( ) : void
return	void

saveSp() public method

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

saveSp() public method

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
return	bool

setCommandTimeout() public method

public setCommandTimeout ( int rhs ) : void
rhs	int
return	void

setConnectionTimeout() public method

public setConnectionTimeout ( int rhs ) : void
rhs	int
return	void

setOpenRsExDescript() public method

public setOpenRsExDescript ( String rhs ) : void
rhs	String
return	void

setSilent() public method

public setSilent ( System.Boolean rhs ) : void
rhs	System.Boolean
return	void

sqlDate() public static method

public static sqlDate ( string val ) : string
val	string
return	string

sqlNumber() public static method

public static sqlNumber ( string number ) : string
number	string
return	string

sqlString() public static method

public static sqlString ( string val ) : string
val	string
return	string

update() public method

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