memoquerydlg.h

VC6.0编写的SQL Server2000应用的企业备忘录

#if !defined(AFX_MEMOQUERYDLG_H__530AE095_DF6F_4BCD_9A48_62E1F276F8AC__INCLUDED_)
#define AFX_MEMOQUERYDLG_H__530AE095_DF6F_4BCD_9A48_62E1F276F8AC__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// MemoQueryDlg.h : header file
//

/////////////////////////////////////////////////////////////////////////////
// CMemoQueryDlg dialog

class CMemoQueryDlg : public CDialog
{
// Construction
public:
	CMemoQueryDlg(CWnd* pParent = NULL);   // standard constructor

// Dialog Data
	//{{AFX_DATA(CMemoQueryDlg)
	enum { IDD = IDD_DIALOG_MEMO_QUERY };
	CListCtrl	m_listMemoInfo;
	COleDateTime	m_oleDate;
	int		m_nDays;
	//}}AFX_DATA
    CDatabase *m_pDB;

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CMemoQueryDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:

	// Generated message map functions
	//{{AFX_MSG(CMemoQueryDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnBtnQuery();
	afx_msg void OnBtnQueryBydays();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
private:
	//根据SQL获取数据,并显示在界面中.
	void GetQueryData(CString sql);
	//向列表控件中添加备忘录信息.
	void InsertMemoInfoItem(int id, CString name, CString operDate, CString happenDate, int isEvent, CString cost,CString type, CString memoTxt);
};

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

#endif // !defined(AFX_MEMOQUERYDLG_H__530AE095_DF6F_4BCD_9A48_62E1F276F8AC__INCLUDED_)