// ADODatabase.h: interface for the CADOConnection class and the CADORecordset class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADOCONNECTION_H__B447B981_25C2_4530_839F_80170E09A0F4__INCLUDED_)
#define AFX_ADOCONNECTION_H__B447B981_25C2_4530_839F_80170E09A0F4__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#pragma warning(disable:4146)  //禁止4146警告
//引入ADO對象動態鏈接庫
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace \
	rename("EOF", "adoEOF") \
	rename("LockTypeEnum", "adoLockTypeEnum") \
	rename("DataTypeEnum", "adoDataTypeEnum") \
	rename("FieldAttributeEnum", "adoFieldAttributeEnum") \
	rename("EditModeEnum", "adoEditModeEnum") \
	rename("RecordStatusEnum", "adoRecordStatusEnum") \
	rename("ParameterDirectionEnum", "adoParameterDirectionEnum") 

#pragma warning(default:4146) //恢復4146警告
//#include <icrsint.h>

class CADORecordset;

//數據庫連接類
class CADOConnection  
{
public:
	CADOConnection();
	virtual ~CADOConnection();

public:
	_ConnectionPtr GetConnection();             
	void RollbackTrans();                       //回滾事務處理
	void CommitTrans();                         //提交事務處理
	void BeginTrans();                          //開始事務處理
	CADORecordset* Excute(_bstr_t CommandText); //執行SQL命令
	void Close();                               //關閉連接                             
	BOOL Open(_bstr_t ConnectionString);        //打開連接
	
private:
	_ConnectionPtr m_pConn;                     //連接對象指針
	_bstr_t m_sConnString;		                //連接串
};

//數據庫記錄集類
class CADORecordset  
{
public:
	CADORecordset();
	virtual ~CADORecordset();

	void Close();             //關閉記錄集
	BOOL Open(CString sCommandString, CADOConnection *adoConn); //打開記錄集

	//增加、刪除、更新記錄
	void AddNew();
	void Delete();
	void Update();
	void UpdateBatch();

	//讀取或設置字段的值
	_variant_t operator()(_variant_t FieldName);
	void operator()(_variant_t FieldName, _variant_t Val);

	long GetRecordNo();
	long GetRecordCount();

	//記錄指針的移動
	void MoveLast();
	void MoveNext();
	void MovePrev();
	void MoveFirst();

public:
	_RecordsetPtr m_pRs;      //記錄集對象指針
	_variant_t *FiledValue;
};

#endif // !defined(AFX_ADOCONNECTION_H__B447B981_25C2_4530_839F_80170E09A0F4__INCLUDED_)