adminreturn.cpp

图书管理系统 带源码 文档

// AdminReturn.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "AdminReturn.h"
#include "Borrow.h"
#include "Book.h"
#include "Reader.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

///////////////////////////////////////////////////////////////////////////
// CAdminReturn dialog


CAdminReturn::CAdminReturn(CWnd* pParent /*=NULL*/)
	: CDialog(CAdminReturn::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAdminReturn)
	m_EditReturn = _T("");
	//}}AFX_DATA_INIT
}


void CAdminReturn::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAdminReturn)
	DDX_Text(pDX, IDC_EDIT_RETURN, m_EditReturn);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAdminReturn, CDialog)
	//{{AFX_MSG_MAP(CAdminReturn)
	ON_BN_CLICKED(IDC_BTN_RETURN, OnBtnReturn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdminReturn message handlers

void CAdminReturn::OnBtnReturn() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if (m_EditReturn=="")
	{
		MessageBox("请输入要还图书的ID号","还书", MB_OK|MB_ICONEXCLAMATION);
		return;
	}
	CBorrow Return;
	Return.GetData(m_EditReturn);
	if (Return.GetBookNo()=="")
	{
		MessageBox("此书没有被借出或者本馆没有这本书,请确认! ","请确认", MB_OK|MB_ICONQUESTION);
		return;
	}
	CReader borrower;
	borrower.GetData(Return.GetReaderNo());
	CString strPay,strBro,strHis;
	strPay.Format("%g",borrower.GetPay());
	strBro.Format("%d",borrower.GetBrNum());
	strHis.Format("%d",borrower.GetTotalNum());

	GetDlgItem(IDC_RNO)->SetWindowText(borrower.GetNo());
	GetDlgItem(IDC_NAME)->SetWindowText(borrower.GetName());
	GetDlgItem(IDC_TYPE)->SetWindowText(borrower.GetType());
	GetDlgItem(IDC_SEX)->SetWindowText(borrower.GetSex());
	GetDlgItem(IDC_ADD)->SetWindowText(borrower.GetAddress());
	GetDlgItem(IDC_TEL)->SetWindowText(borrower.GetTel());
	GetDlgItem(IDC_PAY)->SetWindowText(strPay);
	GetDlgItem(IDC_BORROW)->SetWindowText(strBro);
	GetDlgItem(IDC_HISTORY)->SetWindowText(strHis);

	CBook   book;
	book.GetData(m_EditReturn);
	book.SetStatus("可借");
	book.SQL_UpdateStatus("可借");
	borrower.SetBrNum(borrower.GetBrNum()-1);
	borrower.SQL_Update(borrower.GetNo());

	CTime time;
	time = CTime::GetCurrentTime();
	CString rt;
	rt.Format("%d-%02d-%02d",time.GetYear(), time.GetMonth(), time.GetDay());
	Return.SetReturnTime(rt);
	Return.SQL_Update(m_EditReturn,borrower.GetNo());
	CString vSQL;
	vSQL = "select Book.BNo As 书号, Book.BName As 书名, Author As 作者, BrTime As 借出时间,MsTime AS 该还时间 ";
	vSQL += "From Book,Borrow ";
	vSQL += "where Book.BNo=Borrow.BNo and Borrow.RNo='";
	vSQL = vSQL + borrower.GetNo() + "' AND RtTime=''";

	m_Adodc.SetRecordSource(vSQL);
	m_Adodc.Refresh();

	GetDlgItem(IDC_HAVE)->SetWindowText("已还 《"+book.GetName() + "》");
	CString num;
	num.Format("%d 本",borrower.GetBrNum());
	GetDlgItem(IDC_NUM)->SetWindowText(num);
	
}

BOOL CAdminReturn::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//m_DataGrid.SetRefDataSource(NULL);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}