borrowmanagedlg.h

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

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

// CBorrowManageDlg dialog

class CBorrowManageDlg : public CDialog
{
	DECLARE_DYNAMIC(CBorrowManageDlg)

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

    void SetBWType(BWTYPE type){ eType_ = type;}
    void SetOff(BOOL bOff){bOff_ = bOff;}
    void SetReaderID(CString strReaderID){strReaderID_ = strReaderID;}
    void SetBookID(CString strBookID)
    {
        strBookID_ = strBookID;
        szBookID_  = strBookID;
    }
private:
// Dialog Data
	//{{AFX_DATA(CBorrowManageDlg)
	enum { IDD = IDD_BORROWMANDIALOG };
	CEdit ctrlReaderID_;
    CEdit ctrlBookID_;
    CComboBox ctrlComBorrowed_;
    CEdit ctrlPunish_;
    CString strReaderID_;
    CString strBookID_;
    CString szBookID_;
    CString strReaderName_;
    CString strBookName_;
    CString strReaderType_;
    CString strBookType_;
    UINT nOutNumLimit_;
    UINT nOutDayLimit_;
    UINT nAlOutNum_;
    UINT nDamReate_;
    double dPunish_;
	CString strOperatorName_;
    UINT nBorOutNumLimit_;
    CTime oleDeadLineDT_;
    CTime oleBorrwDT_;
    BOOL bRenewed_;
    //}}AFX_DATA


	//{{AFX_VIRTUAL(CBorrowManageDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL
	//{{AFX_MSG(CBorrowManageDlg)
    virtual BOOL OnInitDialog();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
    afx_msg void OnBnClickedOk();
    afx_msg void OnEnChangeEditBreaderid();
    afx_msg void OnEnChangeEditBbookid();
    afx_msg void OnCbnSelchangeComboBorrowed();

private:    
    BWTYPE eType_;
    CString strSQL_;
    double dPrice_;
    CBookSet bkRS_;
    CBookTypeSet bktRS_;
    CReaderInfoSet rdRS_;
    CReaderTypeSet rdtRS_;
    CBorrowInfoSet biRS_;
    BOOL bOff_;

    BOOL QueryReader();      //! 根据读者ID查询读者基本信息表
    BOOL QueryReaderType();  //! 根据读者ID查询读者可借书册书
    BOOL QueryBook();        //! 根据图书ID查询图书基本信息表
    BOOL QueryBookType();    //! 根据图书ID查询图书类型信息表
    BOOL QueryType();        //! 根据图书ID查询可借出天数
    //! 根据读者ID或图书ID查询借阅信息
    BOOL QueryBorrowInfo(CString strReaderID, CString strBookID = _T(""));
    BOOL BorrowBook();
    BOOL RenewBook();
    BOOL ReturnBook();
    BOOL UpdateReader();
    BOOL UpdateBook();

    void ClearDatas();
};