querydlg.h

LibraryManageDM.rar 数据库设计图书馆管理系统

#pragma once
#include "afxcmn.h"
#include "LibraryManage.h"
#include "ReaderInfoSet.h"
#include "BookTypeSet.h"
#include "ReaderTypeSet.h"
#include "BookSet.h"
#include "BorrowInfoSet.h"
#include "afxwin.h"

// CQueryDlg dialog

class CQueryDlg : public CDialog
{
	DECLARE_DYNAMIC(CQueryDlg)

public:
	CQueryDlg(CWnd* pParent = NULL);   // standard constructor
	virtual ~CQueryDlg();

    void SetQueryType(QTYPE qType)
    {
        qType_ = qType;
    }
    CListCtrl ctrlResultList;
// Dialog Data
	//{{AFX_DATA(CQueryDlg)
	enum { IDD = IDD_QUERYDIALOG };
	CString strID_;
    CEdit ctrlReaderID_;
    CEdit ctrlBookID_;
    CString strReaderID_;
    CString strBookID_;
	CString strName_;
    CString strType_;
    CString strSQL_;
    CString strSID_;
    CString strSType_;
    CString strSName_;
    BOOL bSQL_;
    CComboBox ctrlType_;
    CStatic ctrlReader_;
    CStatic ctrlBook_;
    //}}AFX_DATA

protected:
	//{{AFX_VIRTUAL(CQueryDlg)
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL
	//{{AFX_MSG(CQueryDlg)
    virtual BOOL OnInitDialog();
	afx_msg void OnDblclkResultlist(NMHDR* pNMHDR, LRESULT* pResult);
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
    afx_msg void OnBnClickedOk();
    afx_msg void OnBnClickedCheckSql();
    afx_msg void OnBnClickedModify();
    afx_msg void OnBnClickedDelete();
    afx_msg void OnNMClickResultlist(NMHDR *pNMHDR, LRESULT *pResult);

private:    
    CString strColumns_[12];
    CString strDatas_[12];
    UINT    nCount_;
    QTYPE qType_; 
    BOOL bSelected_;
    BOOL CanModify_;
    CBookTypeSet bktRS;
    CReaderTypeSet rdtRS;
    CBookSet bkRS;
    CReaderInfoSet rdRS;
    CBorrowInfoSet biRS;

    CString strRSName;
    BOOL bRefresh_;
    
    void InsertText(int nItem);
    void GenerateSQL(const CString& strKey0, const CString& strField0, BOOL IsStr0, 
        const CString& strKey1, const CString& strField1, BOOL IsStr1, 
        const CString& strKey2, const CString& strField2, BOOL IsStr2, 
        const CString& strRSName, CString& strSQL);    
};