// Version:		2019.4.4  10:22:45

// File: T_EQP_RULEDBAX.h

#ifndef _T_EQP_RULE_DBAXH
#define _T_EQP_RULE_DBAXH

#include <iDA/iDA.h>

using namespace std;
using namespace iPlature;
using namespace iDA;

class T_EQP_RULE;
class T_EQP_RULEDBAX
{

private:
	iDA::Command cmd;
	iDA::Command readcmd;
	iDA::Command insertcmd;
	iDA::Command updatecmd;
	string m_sql;

public:
	int dbSqlCode; // sqlcode of last operation
	int dbRowsProcessed; // number of executed rows

//
//      constructor
//
public:
T_EQP_RULEDBAX();

//
//      destructor
//
public:
virtual ~T_EQP_RULEDBAX();

//
//      methods
//
public:
//
//	public methode readDB
//
char* readDB( T_EQP_RULE &dbObj );

public:
//
//	public methode updateDB
//
char* updateDB( T_EQP_RULE &dbObj );

public:
//
//	public methode insertDB
//
char* insertDB( T_EQP_RULE &dbObj );

public:
//
//	public methode deleteDB
//
char* deleteDB( T_EQP_RULE &dbObj );

public:
//
//	public methode deleteDB
//
char* deleteDB(const  char* where , long* count );

public:
//
//	public methode openSetDB
//
char* openSetDB(const  char* where ,const  char* order );

public:
//
//	public methode getSetDB
//
char* getSetDB( T_EQP_RULE &dbObj );

public:
//
//	public methode closeSetDB
//
char* closeSetDB();

public:
//
//	public methode countDB
//
char* countDB(const  char* where , long* count );

char* execute(const char* sql , long* count);

char* dbCommit();

char* dbRollback();

private:
//
//	private methode copyDB2Attribute
//
void copyDB2Attribute( T_EQP_RULE &dbObj );

private:
//
//	private methode copyAttribute2DB
//
void copyAttribute2DB( T_EQP_RULE &dbObj );

private:
//
//	private methode copyKey2Host
//
void copyKey2Host( T_EQP_RULE &dbObj );

private:
//
//	private methode copyHost2Key
//
void copyHost2Key( T_EQP_RULE &dbObj );

}; // end of class 
#endif