adodemoview.h

ADO&VC&SQL的例子

// ADODemoView.h : interface of the CADODemoView class
//
/////////////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADODEMOVIEW_H__E61CF8BF_8C41_46A7_B234_8DA683A9D86F__INCLUDED_)
#define AFX_ADODEMOVIEW_H__E61CF8BF_8C41_46A7_B234_8DA683A9D86F__INCLUDED_

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


class CADODemoView : public CListView
{
protected: // create from serialization only
	CADODemoView();
	DECLARE_DYNCREATE(CADODemoView)

// Attributes
public:
	CADODemoDoc* GetDocument();
	void EraseList();

public:
	_ConnectionPtr m_connection;
	_RecordsetPtr m_recordset;
	_CommandPtr m_command;

// Operations
public:

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CADODemoView)
	public:
	virtual void OnDraw(CDC* pDC);  // overridden to draw this view
	virtual BOOL PreCreateWindow(CREATESTRUCT& cs);
	protected:
	virtual void OnInitialUpdate(); // called first time after construct
	virtual BOOL OnPreparePrinting(CPrintInfo* pInfo);
	virtual void OnBeginPrinting(CDC* pDC, CPrintInfo* pInfo);
	virtual void OnEndPrinting(CDC* pDC, CPrintInfo* pInfo);
	//}}AFX_VIRTUAL

// Implementation
public:
	CString m_strCurTableName;
	virtual ~CADODemoView();
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif

protected:

// Generated message map functions
protected:
	//{{AFX_MSG(CADODemoView)
	afx_msg void OnMemberInput();
	afx_msg void OnMemberExit();
	afx_msg void OnSocietyDelete();
	afx_msg void OnSocietyRegister();
	afx_msg void OnExpenseRegister();
	afx_msg void OnMemberQuery();
	afx_msg void OnSocietyQuery();
	afx_msg void OnExpenseStatics();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
private:
	CString m_strSource;
	BOOL m_fConnected;

	BOOL ConstructVar(CString strValue, int type, VARIANT *var);
	BOOL InsertRow(CString strTableName, CStringArray &saValues);
	BOOL DeleteRow(CString strTableName, CString strColName, CString strValue);
	CString VariantToCtring(VARIANT var);


	BOOL OpenCurRecordset(CString strTableName);
	BOOL RefreshColumn(ULONG *pulColCount);
	BOOL RefreshData(ULONG ulColCount);
	BOOL GetInfoArray(CString strTableName, CUIntArray &uaID, CStringArray &saArray);
};

#ifndef _DEBUG  // debug version in ADODemoView.cpp
inline CADODemoDoc* CADODemoView::GetDocument()
   { return (CADODemoDoc*)m_pDocument; }
#endif

/////////////////////////////////////////////////////////////////////////////

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_ADODEMOVIEW_H__E61CF8BF_8C41_46A7_B234_8DA683A9D86F__INCLUDED_)