// ADO.h: interface for the CADO class.
//
//	Author: XuJL
//		2002.10.18
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADO_H__838CA9EB_83AA_4536_934C_3EE76E929B14__INCLUDED_)
#define AFX_ADO_H__838CA9EB_83AA_4536_934C_3EE76E929B14__INCLUDED_

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

class CADO  
{
private:
	CString m_szConnectionString;
	CString m_szUdlFileName;
	CString m_szSQL;

	_ConnectionPtr	m_pConnection;
	_RecordsetPtr	m_pRecordset;
private:
	int m_nRecordCount;
	BOOL m_bCmd;	//是否是執行如Delete的命令
public:
	CString GetSQLString(void);
	CString GetConnectionString(void);
	CString GetUdlFileName(void);
	BOOL SetSQLString(CString szSQL);
	BOOL SetConnectionString(CString szConnectionString);
	BOOL SetUdlFileName(CString szUdlFileName);
	BOOL AdoBof(void);
	BOOL AdoEof();
	BOOL AddNew(void);
	BOOL Delete(void);
	BOOL Update(void);
	BOOL ExeSQL(CString szSQL, BOOL bCmd=FALSE);
	BOOL Move(int nNumRecords);
	BOOL MovePrevious(void);
	BOOL MoveNext(void);
	BOOL MoveFirst(void);
	BOOL MoveLast(void);
	BOOL SetFieldValue(CString szField, CString szValue);
	BOOL GetFieldValue(CString szField, CString &szValue);
	BOOL GetBitmapValue(CString szField, HBITMAP &hBitmap);
	char* GetImageValue(CString szField, int &nSize, int &nImageType);
	BOOL SetImageValue(CString szField, char *pImageBuff, const int nSize);
	BOOL GetFieldsName(CStringArray &saFieldsName);
	BOOL InitDatabaseConnection(void);
	BOOL CloseDatabaseConnection(void);
	int  GetFieldsCount(void);
	int  GetRecordCount(void);
	CADO();
	virtual ~CADO();
private:
	HBITMAP BufferToHBITMAP(char *pBmpBuff);
};

#endif // !defined(AFX_ADO_H__838CA9EB_83AA_4536_934C_3EE76E929B14__INCLUDED_)