ODBCInterface.h 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. ///************************************************************************/
  2. /* Copyright (C), 2016-2020, [IT], 保留所有权利;
  3. /* 模 块 名:;
  4. /* 描 述:;
  5. /*
  6. /* 版 本:[V];
  7. /* 作 者:[IT];
  8. /* 日 期:[2/23/2016];
  9. /*
  10. /*
  11. /* 注 意:;
  12. /*
  13. /* 修改记录:[IT];
  14. /* 修改日期:;
  15. /* 修改版本:;
  16. /* 修改内容:;
  17. /************************************************************************/
  18. #ifndef __DBINTREFACE_20150930__
  19. #define __DBINTREFACE_20150930__
  20. #include "basetype.h"
  21. // {2B544EFB-4E47-4081-A1BE-C312EBE760A7}
  22. static const GUID IID_ODBCPoolInterface =
  23. { 0x2b544efb, 0x4e47, 0x4081, { 0xa1, 0xbe, 0xc3, 0x12, 0xeb, 0xe7, 0x60, 0xa7 } };
  24. interface IODBCPoolInterface:public IUnknown
  25. {
  26. public:
  27. virtual DWORD InitializePool(
  28. IN LPCTSTR lpDBSource,
  29. IN CONST DWORD &dwDBPort,
  30. IN LPCTSTR lpDBAccount,
  31. IN LPCTSTR lpPassWord,
  32. IN LPCTSTR lpDBName,
  33. IN CONST INT &nMinConn = 1,
  34. IN CONST INT &nMaxConn = 5) = 0;
  35. virtual void ReleasePool() = 0;
  36. public:
  37. // 一张表,一个条件,查询一个字段。
  38. virtual BOOL GetSelectby(IN LPCTSTR lpTblName, IN LPCTSTR lpColumn, IN LPCTSTR lpFilters, OUT LPTSTR lpResult, IN CONST INT& nBufLen, IN CONST DWORD &dwTimeOut = 3000) = 0;
  39. //////////////////////////////////////////////////////////////////////////
  40. // 项目接口;
  41. virtual BOOL ExecuteSQL( IN LPCTSTR lpExcuteSQL, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  42. virtual INT GetTblRecordCount( IN LPCTSTR lpTblName, IN LPCTSTR lpFilters, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  43. //////////////////////////////////////////////////////////////////////////
  44. // 公司域名后台管理使用;
  45. virtual BOOL GetunauthInfo( IN LPCTSTR lpSQLFilters, OUT LPTSTR lpUnauthInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  46. virtual BOOL GetunauthInfo( IN LPCTSTR lpSQLFilters, OUT TString &strUnauthInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  47. virtual INT GetClientEnterpriseName( IN LPCTSTR lpSQLFilters, OUT LPVOID lpClientIPInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  48. virtual INT GetEnterprisInfo(IN LPCTSTR lpEnterpriseName, OUT CArray<CStringArray, CStringArray>& AryEnterpriseInfo, IN CONST DWORD &dwTimeOut = 30000) = 0;
  49. virtual BOOL GetDBCFileInfo(IN LPCTSTR lpSQL, OUT TString& strResult, IN CONST DWORD &dwTimeOut = 3000) = 0;
  50. //////////////////////////////////////////////////////////////////////////
  51. // DBServer使用;
  52. //////////////////////////////////////////////////////////////////////////
  53. // 其他使用;
  54. virtual BOOL GetVersionInfo( OUT LPVOID lpVerInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0 ;
  55. virtual BOOL GetCloudSelectionVersionInfo( OUT LPVOID lpVerInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0 ;
  56. virtual BOOL GetNetShareInfo( OUT LPVOID lpNetShareInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  57. virtual BOOL GetOrderInfo( OUT LPVOID lpOrderInfo, IN CONST DWORD &dwTimeOut = 30000 ) = 0;
  58. // 获取取件ok的订单表信息;
  59. virtual BOOL GetTookOrderInfo( OUT LPVOID lpTookOrderInfo, IN CONST DWORD &dwTimeOut = 3000 ) = 0;
  60. virtual BOOL GetOrderGoodsInfo( IN LPCTSTR lpOrderNum, OUT LPVOID lpGoodsInfo, IN CONST DWORD &dwTimeOut = 3000 ) = 0;
  61. };
  62. #endif