bookreturndlg.cpp

一个图书管理程序 其中数据库部分需要自己设置 具体设置请参看源码

// BookReturnDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "library.h"
#include "book.h"
#include "borrow.h"
#include "BookReturnDlg.h"
#include "card.h"
#include "afxwin.h"
#include "atltime.h"

// CBookReturnDlg 对话框

IMPLEMENT_DYNAMIC(CBookReturnDlg, CDialog)

CBookReturnDlg::CBookReturnDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBookReturnDlg::IDD, pParent)
	, m_strBookNum(_T(""))
	, m_strCardNum(_T(""))
{

}

CBookReturnDlg::~CBookReturnDlg()
{
}

void CBookReturnDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_Book_Num, m_strBookNum);
	DDX_Text(pDX, IDC_Card_Num, m_strCardNum);
	DDX_Control(pDX, IDC_LIST1, m_borrowed);
}


BEGIN_MESSAGE_MAP(CBookReturnDlg, CDialog)
	ON_BN_CLICKED(IDOK, &CBookReturnDlg::OnBnClickedOk)
	ON_BN_CLICKED(IDC_BUTTON1, &CBookReturnDlg::OnBnClickedButton1)
END_MESSAGE_MAP()


// CBookReturnDlg 消息处理程序



void CBookReturnDlg::OnBnClickedOk()
{

	UpdateData();

	if(!m_borrowSet.IsOpen())
		m_borrowSet.Open();
	
	m_borrowSet.m_strFilter=(CString)"cno like '"+(CString)m_strCardNum+(CString)"' ";
	m_borrowSet.Requery();
	if(m_borrowSet.IsEOF())
	{
		AfxMessageBox(_T("错误的卡号"));
		CDialog::OnOK();
		return ;
	}


	CTime today= CTime::GetCurrentTime();
	if(m_borrowSet.m_return_date<today)
	{
		AfxMessageBox(_T("借书超期，请交罚款"));
		CDialog::OnOK();
		return;
	}
	
	m_borrowSet.m_strFilter=(CString)"bno like '"+(CString)m_strBookNum+(CString)"'and cno like  '"+(CString)m_strCardNum+(CString)"'";
	m_borrowSet.Requery();
	if(m_borrowSet.IsEOF())
		AfxMessageBox(_T("没有该记录"));
	else
	{
		m_borrowSet.Delete();
		if(!m_bookSet.IsOpen())
			m_bookSet.Open();
		m_bookSet.m_strFilter=(CString)"bno like '"+(CString)m_strBookNum+(CString)"'";
		m_bookSet.Requery();
		m_bookSet.Edit();
		m_bookSet.m_stock+=1;
		m_bookSet.Update();
		AfxMessageBox(_T("还书成功") );
	}
	CDialog::OnOK();
}


void CBookReturnDlg::OnBnClickedButton1()
{
	// TODO: 在此添加控件通知处理程序代码
	m_cardSet.Open();
	UpdateData();
	m_borrowed.ResetContent();

	m_cardSet.m_strFilter=(CString)"cno like '"+(CString)m_strCardNum+(CString)"' ";
	m_cardSet.Requery();

	if(m_cardSet.IsEOF())
	{
		AfxMessageBox(_T("没有该借书证!"));
		m_cardSet.Close();
		return;
	}

	m_borrowSet.Open();
	m_borrowSet.m_strFilter=(CString)"cno like '"+(CString)m_strCardNum+(CString)"' ";
	m_borrowSet.Requery();

	m_bookSet.Open();
	
	if(m_borrowSet.IsEOF())
	{
		m_borrowed.AddString(_T("没有借书记录"));
		AfxMessageBox(_T("没有借书记录"));
	}
	else
	{
		while(!m_borrowSet.IsEOF())
		{
			m_bookSet.m_strFilter=(CString)"bno like '"+(CString)m_borrowSet.m_bno+(CString)"' ";
			m_bookSet.Requery();

		
			CString   stryear,strprice,strtotal,strstock;  
			stryear.Format((CString)"%d",m_bookSet.m_year);
			strprice.Format((CString)"%.2f",m_bookSet.m_price);
			strtotal.Format((CString)"%d",m_bookSet.m_total);
			strstock.Format((CString)"%d",m_bookSet.m_stock);
	
			CString a[9],str;
			str.Empty();
			a[0]=(CString)"书号："+(CString)m_bookSet.m_bno+(CString)" ";
			a[1]=(CString)"类别："+(CString)m_bookSet.m_category+(CString)" ";
			a[2]=(CString)"书名："+(CString)m_bookSet.m_title+(CString)"  ";
			a[3]=(CString)"出版社："+(CString)m_bookSet.m_press+(CString)" ";
			a[4]=(CString)"年份："+stryear+(CString)" ";
			a[5]=(CString)"作者："+(CString)m_bookSet.m_author+(CString)" ";
			a[6]=(CString)"价格："+strprice+(CString)" ";
			a[7]=(CString)"总藏书量："+strtotal+(CString)" ";
			a[8]=(CString)"库存："+strstock+(CString)" ";
			for(int i=0;i<9;i++)
				str+=a[i];
			m_borrowed.AddString(str);
			m_borrowSet.MoveNext();
		}
	}
	
	m_cardSet.Close();
	m_bookSet.Close();
	m_borrowSet.Close();
}