| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- #ifndef __ODBC_CONNECT_20151016__
- #define __ODBC_CONNECT_20151016__
- #pragma once
- #include <list>
- #include "TblDef.h"
- #include "Tblversion.h"
- #include "TblNetShareInfo.h"
- #include "Tbldindan.h"
- #include "Tblclientip.h"
- class CODBCConnect
- {
- public:
- INT m_nObjId;
- CODBCConnect(IN LPCTSTR lpDBSource, IN CONST DWORD &dwDBPort, IN LPCTSTR lpDBAccount, IN LPCTSTR lpPassWord, IN LPCTSTR lpDBName, BOOL &bResult);
- ~CODBCConnect(void);
- public:
- BOOL m_busing;
- BOOL IsOpen() const { return m_bOpen; };
- INT Open( IN LPCTSTR lpDBSource = NULL, IN CONST DWORD &dwDBPort = 0, IN LPCTSTR lpDBAccount = NULL, IN LPCTSTR lpPassWord = NULL, IN LPCTSTR lpDBName = NULL);
- void Close();
- void SetObjId(IN CONST INT& nObjId){ m_nObjId = nObjId;}
- INT GetObjId()const{return m_nObjId;}
- protected:
- BOOL m_bOpen;
- TCHAR m_szConnectString[MAX_PATH];
- CDatabase *m_pdbInstance;
- void SolveDBError(IN CONST DWORD &dwError, IN LPCTSTR lpErrorString = NULL);
- public:
- BOOL GetSelectby(IN LPCTSTR lpTblName, IN LPCTSTR lpColumn, IN LPCTSTR lpFilters, OUT LPTSTR lpResult, IN CONST INT& nBufLen );
- BOOL ExecuteSQL( IN LPCTSTR lpSQL );
- INT GetTblRecordCount(IN LPCTSTR lpTblName, IN LPCTSTR lpFilters);
- BOOL GetVersionInfo( OUT LPVOID lpVerInfo );
- BOOL GetNetShareInfo( OUT LPVOID lpNetShareInfo );
- BOOL GetOrderInfo( OUT LPVOID lpOrderInfo );
- //////////////////////////////////////////////////////////////////////////
- // ¹«Ë¾ÓòÃû½ÓÊÕºǫ́¹ÜÀí;
- BOOL GetunauthInfo( IN LPCTSTR lpSQLFilters, OUT LPTSTR lpUnauthInfo );
- BOOL GetunauthInfo( IN LPCTSTR lpSQLFilters, OUT TString &strUnauthInfo ) ;
- INT GetClientEnterpriseName( IN LPCTSTR lpSQLFilters, OUT LPVOID lpClientIPInfo );
- INT GetEnterprisInfo(IN LPCTSTR lpEnterpriseName, OUT CArray<CStringArray, CStringArray>& AryEnterpriseInfo);
- BOOL GetDBCFileInfo(IN LPCTSTR lpSQL, OUT TString& strResult );
- BOOL GetTookOrderInfo( OUT LPVOID lpTookOrderInfo );
- };
- typedef std::list<CODBCConnect*> ODBCConnectList;
- #endif
|
