// ADOConn.h: interface for the CADOConn class.
//
//////////////////////////////////////////////////////////////////////
//#import "c:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF") rename("BOF","adoBOF")
#pragma  warning(disable:4146)  
#import  "C:\Program Files\Common Files\System\ADO\msado15.dll"  named_guids  rename("EOF","adoEOF"),  rename("BOF","adoBOF")  
#pragma  warning(default:4146)  
using  namespace  ADODB; 

#if !defined(AFX_ADOCONN_H__2B491720_FA04_4800_B616_219E55ABEA46__INCLUDED_)
#define AFX_ADOCONN_H__2B491720_FA04_4800_B616_219E55ABEA46__INCLUDED_

#if _MSC_VER > 1000

#pragma once
#endif // _MSC_VER > 1000

#include <Vector>
using namespace std;

class ADOConn : public CObject 
{
private:
	//添加一個指向Connection對象的指針:
	_ConnectionPtr m_pConnection;
	//添加一個指向Recordset對象的指針:
	_RecordsetPtr m_pRecordset;
	char error[1024];
public:
	_ConnectionPtr& GetConnPtr()    {return m_pConnection;}
	_RecordsetPtr& GetRecoPtr()     {return m_pRecordset;}
public:
	BOOL ExecuteProc(LPCTSTR lpszSQL);

	BOOL ExecuteProc(LPCTSTR lpszSQL,const vector<CString> &key,const vector<CString> &value);

	void ExitConnect();
	//事務回滾
	BOOL RollbackTrans();
	//遞交 事務
	BOOL CommitTrans();
	//事務開始
	BOOL BeginTrans();
	BOOL adoBOF();//頭
	BOOL adoEOF();//尾
	BOOL MoveNext();//下一個
	BOOL CloseTable();//關閉表
	BOOL CloseADOConnection();//關閉連接
	VARIANT GetCollect(LPCTSTR Name);
	BOOL GetCollect(LPCTSTR Name,char *lpDest);//獲取某個字段的值
	//執行SQL語句 包含update delete insert
	BOOL ExecuteSQL(LPCTSTR lpszSQL);
	//初始化連接數據庫
	BOOL OnInitADOConn(LPCTSTR ConnStr);
	// 執行select語句 獲取記錄集 
	_RecordsetPtr& GetRecordSet(LPCTSTR lpszSQL);
	ADOConn();
	virtual ~ADOConn();

};

#endif // !defined(AFX_ADOCONN_H__2B491720_FA04_4800_B616_219E55ABEA46__INCLUDED_)

class CADOException : public CException  
{
public:
	// Constructor
	CADOException(char* pchMessage);
	
public:
	~CADOException() {}
	CString m_strMessage;
	virtual BOOL GetErrorMessage(LPTSTR lpstrError, UINT nMaxError,
		PUINT pnHelpContext = NULL);
private:
	int m_nError;
	
};