adooperation.h

VC++和ACCESS使用ADO连接

// ADOOperation.h: interface for the CADOOperation class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADOOPERATION_H__921739AB_56DE_41B2_8A10_CCD70B289FB0__INCLUDED_)
#define AFX_ADOOPERATION_H__921739AB_56DE_41B2_8A10_CCD70B289FB0__INCLUDED_

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

#include	"ADOView.h"

class CADOOperation  
{
public:
	static const DWORD ADO_TYPE_BITMAP_HANDLE;
	static const DWORD ADO_TYPE_INT;
	static const DWORD ADO_TYPE_FLOAT;
	static const DWORD ADO_TYPE_DATE;
	static const DWORD ADO_TYPE_BITMAP_FILE;
	static const DWORD ADO_TYPE_STRING;
	static const DWORD ADO_TYPE_TEXT;

public:
	void GetFieldsToShow(CString strFields[], int nLen, CListCtrl* CListShow);
	void GetFieldsValue(CString strFields[], int nLen, CString strRetValue[], BOOL bGetAll);
	int GetMaxID(void);
	CString GetProgramPath(void);
	HRESULT MoveLast();
	void SetClientDC(HDC hDC);
	BOOL MoveTo(DWORD dwIndex);
	HRESULT MoveNext();
	HRESULT MoveFirst();
	DWORD GetRecordCount();
	DWORD GetCurrentRecordIndex(int nID, CString strIDCard);

	BOOL ExportToWord(CString &strFile);
	BOOL IsLastRow();
	HRESULT AddNew();

	BOOL UpdateData();

	BOOL GetItemContentStr(CString strField, DWORD dwType, void *Variable);
	BOOL GetItemContentDw(DWORD dwField, DWORD dwType, void *Variable);

	_variant_t GetSubItemField(CString strField);
	_variant_t GetSubItemIndex(DWORD dwIndex);

	BOOL ShowADOView(CString strFields[], int nLen, CADOView *view);
	BOOL DeleteItem(DWORD dwIndex);
	BOOL ChangeTypeTo(_variant_t From, DWORD Type, void *pTo, long Add);

	BOOL SetItemContent(CString strField, DWORD dwTpye, const void *Variable);
	BOOL CloseTable();
	BOOL OpenRecordset(CString strSQL);
	
	void ShowError(_bstr_t error);
	void CloseRecorset();

	BOOL OpenTable(CString strName);

	CADOOperation();
	virtual ~CADOOperation();

private:
	_RecordsetPtr m_pRecordset;
	_ConnectionPtr m_pConnection;
	DWORD m_CurrentRecord;
	HDC m_hDC;

};

#endif // !defined(AFX_ADOOPERATION_H__921739AB_56DE_41B2_8A10_CCD70B289FB0__INCLUDED_)