#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