DataDef.h 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. #ifndef __DATADEF_H_
  2. #define __DATADEF_H_
  3. #include "..\..\..\AdoImpl\AdoDef.h"
  4. //--------------------------------------------------------
  5. /*
  6. 数据定义块
  7. */
  8. //--------------------------------------------------------
  9. class AdoImpl;
  10. class CDataBase
  11. {
  12. public:
  13. CDataBase(){}
  14. virtual ~CDataBase(){}
  15. virtual int Handle() = 0;
  16. virtual void GetInsertSql(TCHAR* strInsert){}
  17. 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;}
  18. 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;}
  19. };
  20. /*-----------------------__Tbl_2015__ define begin--------------------------------*/
  21. ///////////////////////////////////////////////////////////////////////////
  22. // 生成表对应的Insert宏;
  23. #define INSERT_2015 _T("INSERT INTO [%s](Account,UserName,LogDate,OptType,SNNo,LogDesc)VALUES('%s','%s','%s','%s','%s','%s')")
  24. // 生成表对应的结构体;
  25. class Tbl2015 : public CDataBase
  26. {
  27. public:
  28. TString _logid;
  29. TString _account;
  30. TString _username;
  31. TString _logdate;
  32. TString _opttype;
  33. TString _snno;
  34. TString _desc;
  35. Tbl2015(){}
  36. virtual ~Tbl2015(){}
  37. virtual int Handle();
  38. virtual void GetInsertSql(TCHAR* strInsert);
  39. virtual INT GetRecordSet(IN AdoImpl* pAdoImpl, IN CONST TCHAR *pTableName, IN CONST TCHAR *pFilters, IN CString& strSQL, INT &nFieldCount, OUT CArray<CStringArray, CStringArray>& arr);
  40. virtual INT GetRecordSet(IN AdoImpl* pAdoImpl, IN CONST TCHAR *pTableName, IN CONST TCHAR *pFilters, CStringArray& fieldArr, INT &nFieldCount, OUT CArray<CStringArray, CStringArray>& arr);
  41. };
  42. /*-----------------------__Tbl_2015__ define end--------------------------------*/
  43. #endif