// MyRecordSet.h: interface for the MyRecordSet class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYRECORDSET_H__E50043C5_60AA_4B77_A6B2_5EA15F204419__INCLUDED_)
#define AFX_MYRECORDSET_H__E50043C5_60AA_4B77_A6B2_5EA15F204419__INCLUDED_

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

class MyRecordSet  
{
public:
	CString GetFieldName(int nCol);
	bool ADOEOF();
	void ADOConnectionClose();
	//數(shù)據(jù)集的列數(shù)
	int nFieldCols;
	//數(shù)據(jù)集的行數(shù)
	int nFieldRows;

	CString GetFieldString(int nCol);				//以字符串形式返回值
	CString GetFieldString(CString strFieldName);	//以字符串形式返回值
	int GetFieldNumber(int nCol);				//以整型返回值
	int GetFieldNumber(CString strFieldName);	//1次重載
	float GetFieldFloat(int nCol);				//以浮點(diǎn)返回值
	float GetFieldFloat(CString strField);
	CString VariantToCString(VARIANT var);		//類型轉(zhuǎn)換
	//類型轉(zhuǎn)換
	CString TimeToString(CTime time);
	CTime	StringToTime(CString s);

	HRESULT MoveNext();
	HRESULT MovePrev();
	HRESULT MoveLast();
	HRESULT MoveFirst();
	MyRecordSet();

	bool ADOOpen(CString strDataType);
	bool ADOOpen();
	bool ADOExcute();				//執(zhí)行SQL語句:不帶參數(shù)
	bool ADOExcute(CString strSQL);	//執(zhí)行SQL語句:帶參數(shù)
	//執(zhí)行SQL語句,返回受影響的行數(shù),主要針對增刪改
	int	 ADOExcuteNoQuery(CString strSQL);

	void ADOClose();

	_ConnectionPtr m_pConn;		//定義一個(gè)連接對象
	_RecordsetPtr m_pRst;		//定義一個(gè)數(shù)據(jù)集

	CString		m_strSQL;				//查詢語句
	CString		m_strDBType;			//數(shù)據(jù)庫類型
	bool		isConn;					//是否已經(jīng)打開連接；
	bool		isOpen;					//是否已經(jīng)打開數(shù)據(jù)集

	//MyRecordSet();
	virtual ~MyRecordSet();

private:
	//連接字符串
};

#endif // !defined(AFX_MYRECORDSET_H__E50043C5_60AA_4B77_A6B2_5EA15F204419__INCLUDED_)