123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- #ifndef __DATADEF_H_
- #define __DATADEF_H_
- #include "..\..\..\AdoImpl\AdoDef.h"
- class AdoImpl;
- class CDataBase
- {
- public:
- CDataBase(){}
- virtual ~CDataBase(){}
- virtual int Handle() = 0;
- virtual void GetInsertSql(TCHAR* strInsert){}
- virtual INT GetRecordSet(IN AdoImpl* pAdoImpl, IN CONST TCHAR *pTableName, IN CONST TCHAR *pFilters, IN CString& strSQL, INT &nFieldCount, OUT CArray<CStringArray, CStringArray>& arr){return 1;}
- virtual INT GetRecordSet(IN AdoImpl* pAdoImpl, IN CONST TCHAR *pTableName, IN CONST TCHAR *pFilters, CStringArray& fieldArr, INT &nFieldCount, OUT CArray<CStringArray, CStringArray>& arr){return 1;}
- };
- #define INSERT_2015 _T("INSERT INTO [%s](Account,UserName,LogDate,OptType,SNNo,LogDesc)VALUES('%s','%s','%s','%s','%s','%s')")
- class Tbl2015 : public CDataBase
- {
- public:
- TString _logid;
- TString _account;
- TString _username;
- TString _logdate;
- TString _opttype;
- TString _snno;
- TString _desc;
- Tbl2015(){}
- virtual ~Tbl2015(){}
- virtual int Handle();
- virtual void GetInsertSql(TCHAR* strInsert);
- virtual INT GetRecordSet(IN AdoImpl* pAdoImpl, IN CONST TCHAR *pTableName, IN CONST TCHAR *pFilters, IN CString& strSQL, INT &nFieldCount, OUT CArray<CStringArray, CStringArray>& arr);
- virtual INT GetRecordSet(IN AdoImpl* pAdoImpl, IN CONST TCHAR *pTableName, IN CONST TCHAR *pFilters, CStringArray& fieldArr, INT &nFieldCount, OUT CArray<CStringArray, CStringArray>& arr);
- };
- #endif
|