bookreturndlg.cpp

连接SQL Server的图书管理系统

// BookReturnDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MyLibrary.h"
#include "BookReturnDlg.h"
#include "BookRS.h"
#include "BorrowRS.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookReturnDlg dialog


CBookReturnDlg::CBookReturnDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBookReturnDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBookReturnDlg)
	m_strBookNum = _T("");
	m_cardNum = _T("");
	//}}AFX_DATA_INIT
}


void CBookReturnDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookReturnDlg)
	DDX_Text(pDX, IDC_BOOK_NUM, m_strBookNum);
	DDX_Text(pDX, IDC_CARD_NUM, m_cardNum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBookReturnDlg, CDialog)
	//{{AFX_MSG_MAP(CBookReturnDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBookReturnDlg message handlers

void CBookReturnDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	if(!m_borrowSet.IsOpen())
		m_borrowSet.Open();

	m_borrowSet.m_strFilter.Format("ISBN='%s' and card_num='%s'", m_strBookNum, m_cardNum);
	m_borrowSet.Requery();

	if(m_borrowSet.IsEOF())
	{
		AfxMessageBox("此书不存在");
		CDialog::OnOK();
		return;
	}
	CTimeSpan diffDays=m_borrowSet.m_return_date-m_borrowSet.m_borrow_date;
	if(diffDays.GetDays()!=30)
	{
		AfxMessageBox("此书已归还");
		CDialog::OnOK();
		return;

	}
   
	CTime today=CTime::GetCurrentTime();//当前日期
	diffDays=today-m_borrowSet.m_return_date;
	// 超过30天则报错
	if (diffDays.GetDays()>0)
	{
 		AfxMessageBox("该书过期了");
		CDialog::OnOK();
		return ;
	}
	//将还书日期改成今天
	m_borrowSet.Edit();
	m_borrowSet.m_return_date=today;
	m_borrowSet.Update();


	if(!m_bookSet.IsOpen())
		m_bookSet.Open();
	m_bookSet.m_strFilter.Format("ISBN='%s'",m_strBookNum );
	m_bookSet.Requery();
		
	m_bookSet.Edit();
	m_bookSet.m_present_num+=1;
	m_bookSet.Update();
	AfxMessageBox("还书成功");
	
	CDialog::OnOK();
}