returndlg.cpp

图书管理系统,相对全面,ODBC学习的好材料,仅攻学习,谢绝抄袭

// ReturnDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MyLib.h"
#include "ReturnDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReturnDlg dialog


CReturnDlg::CReturnDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReturnDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReturnDlg)
	m_BOOKID = _T("");
	m_NOTE = _T("");
	//}}AFX_DATA_INIT
}


void CReturnDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReturnDlg)
	DDX_Text(pDX, IDC_BOOKID, m_BOOKID);
	DDV_MaxChars(pDX, m_BOOKID, 20);
	DDX_Text(pDX, IDC_NOTE, m_NOTE);
	DDV_MaxChars(pDX, m_NOTE, 100);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReturnDlg, CDialog)
	//{{AFX_MSG_MAP(CReturnDlg)
	ON_BN_CLICKED(IDC_EXIT, OnExit)
	ON_BN_CLICKED(IDC_RETURN, OnReturn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReturnDlg message handlers

void CReturnDlg::OnExit() 
{
	if (bfileset.IsOpen())
	{
		bfileset.Close();
	}
	if (rfileset.IsOpen())
	{
		rfileset.Close();
	}
	if (borrowset.IsOpen())
	{
		borrowset.Close();
	}
	CDialog::OnCancel();
}

void CReturnDlg::OnReturn() 
{
	UpdateData(TRUE);
	CString sqlstr;
	sqlstr = "SELECT * FROM BORROW WHERE BOOKID='";
	sqlstr += m_BOOKID;
	sqlstr += "'";
	if (borrowset.IsOpen())
	{
		borrowset.Close();
	}
	if (!borrowset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr))
	{
		MessageBox("借阅表打开失败!");
		return;
	}
	if (borrowset.IsEOF())
	{
		MessageBox("该图书没借出!");
		borrowset.Close();
		return;
	}
	SetDlgItemText(IDC_NOTE,"");
	CTime t = CTime::GetCurrentTime();
	if((t - borrowset.m_DATET)>=CTimeSpan(1,0,0,0))
	{
		sqlstr = "SELECT * FROM FINE WHERE BOOKID='";
		sqlstr += m_BOOKID;
		sqlstr += "' AND DEAL=FALSE";
		if (fineset.IsOpen())
		{
			fineset.Close();
		}
		if (!fineset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr))
		{
			MessageBox("罚金表打开失败!");
			borrowset.Close();
			return;
		}
		if (fineset.IsEOF())
		{
			fineset.Close();
			sqlstr = "SELECT * FROM FINE";
			if (!fineset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr))
			{
				MessageBox("罚金表打开失败!");
				borrowset.Close();
				return;
			}
			fineset.AddNew();
			fineset.m_BOOKID = m_BOOKID;
			fineset.m_READERID = borrowset.m_READERID;
			fineset.m_DATE = borrowset.m_DATET;
			fineset.Update();
			fineset.Requery();
		}
		fineset.Close();
		SetDlgItemText(IDC_NOTE,"该用户已欠费!");
	}
	
	sqlstr = "SELECT * FROM BOOKINFM WHERE BOOKID='";
	sqlstr += m_BOOKID;
	sqlstr += "'";
	if (bfileset.IsOpen())
	{
		bfileset.Close();
	}
	if (!bfileset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr))
	{
		MessageBox("图书表打开失败!");
		borrowset.Close();
		return;
	}
	bfileset.Edit();
	bfileset.m_IO = FALSE;
	bfileset.Update();
	bfileset.Requery();
	bfileset.Close();

	sqlstr = "SELECT * FROM READERINFM WHERE ID='";
	sqlstr += borrowset.m_READERID;
	sqlstr += "'";
	if (rfileset.IsOpen())
	{
		rfileset.Close();
	}
	if (!rfileset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr))
	{
		MessageBox("图书表打开失败!");
		borrowset.Close();
		return;
	}
	rfileset.Edit();
	rfileset.m_COUNT = rfileset.m_COUNT-1;
	rfileset.Update();
	rfileset.Requery();
	rfileset.Close();

	borrowset.Delete();
	borrowset.Requery();
	MessageBox("还书成功!");
}