borrowdlg.cpp

提供图书查询。借阅图书管理进货等的图书管理系统

// BorrowDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "BorrowDlg.h"
#include "ProofSet.h"
#include "BookSet.h"
#include "BorrowSet.h"
#include "CheckBorrowDlg.h"
#include "CheckBooksDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBorrowDlg dialog


CBorrowDlg::CBorrowDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBorrowDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBorrowDlg)
	m_strBookID = _T("");
	m_strProofID = _T("");
	//}}AFX_DATA_INIT
}


void CBorrowDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBorrowDlg)
	DDX_Control(pDX, IDC_LIST_SHOW, m_ctrList);
	DDX_Text(pDX, IDC_EDIT_BOOK, m_strBookID);
	DDX_Text(pDX, IDC_EDIT_PROOF, m_strProofID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBorrowDlg, CDialog)
	//{{AFX_MSG_MAP(CBorrowDlg)
	ON_BN_CLICKED(IDC_BUTTON_RESET, OnButtonReset)
	ON_BN_CLICKED(IDC_BUTTON_OK, OnButtonOk)
	ON_BN_CLICKED(IDC_BUTTON_BACK, OnButtonBack)
	ON_WM_CLOSE()
	ON_BN_CLICKED(IDC_BUTTON_CHECK_BORROW, OnButtonCheckBorrow)
	ON_BN_CLICKED(IDC_BUTTON_RETURN, OnButtonReturn)
	ON_BN_CLICKED(IDC_BUTTON_CHECK_BOOKS, OnButtonCheckBooks)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBorrowDlg message handlers

void CBorrowDlg::OnButtonReset() 
{
	m_strProofID.Empty();
	m_strBookID.Empty();
	UpdateData(FALSE);
}

void CBorrowDlg::OnButtonOk() 
{
	UpdateData();
	if(m_strProofID==""||m_strBookID=="")
	{
		MessageBox("输入的域不完整，请重新输入！","借书管理",MB_ICONERROR);
		m_strProofID.Empty();
		m_strBookID.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("Cannot access the database!","借书管理");
			return;
		}
	}
	
	CString strSQL;
	//判断借书人是否有资格
	strSQL.Format("select * from Proof_Info where Proof_ID='%s'", m_strProofID);
	CProofSet *m_pProof=new CProofSet(&m_database);
	m_pProof->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pProof->GetRecordCount()==0)
	{
		MessageBox("There is no information for this person","借书/还书",MB_ICONINFORMATION);
		m_pProof->Close();
		m_database.Close();
		return;
	}
	CDBVariant varValue;
	m_pProof->GetFieldValue(7,varValue);
	if(varValue.m_iVal==4)
	{
		//如果不满足条件
		MessageBox("You cannot borrow more than 4 books!","借书/还书",MB_OK|MB_ICONINFORMATION);
		m_pProof->Close();
		m_database.Close();
		return;
	}
	
	//满足条件
	//借书量加一
	m_pProof->Edit();
	m_pProof->m_Now_Borrow_Amount++;
	m_pProof->Update();
	m_pProof->Requery();
	m_pProof->Close();
	//Book_Info表中，现存数量减一
	strSQL.Format("select * from Book_Info where Book_ID='%s'",m_strBookID);
	CBookSet *m_pBook=new CBookSet(&m_database);
	m_pBook->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pBook->GetRecordCount()==0)
	{
		MessageBox("Sorry, there is no this book in this library!","借书/还书",MB_ICONINFORMATION);
		m_pBook->Close();
		m_database.Close();
		return;
	}
	m_pBook->Edit();
	m_pBook->m_Now_Amount--;
	m_pBook->Update();
	m_pBook->Requery();
	m_pBook->Close();
	//将借书信息存入借书信息表中
	strSQL.Format("select * from Borrow_Info");
	CBorrowSet *m_pBorrow=new CBorrowSet(&m_database);
	m_pBorrow->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pBorrow->GetRecordCount()==0)
	{
		MessageBox("There are no any borrowing information!","借书/还书",MB_OK|MB_ICONINFORMATION);
	}
	
	m_pBorrow->AddNew();
	
	m_pBorrow->SetFieldNull(&(m_pBorrow->m_Proof_ID),FALSE);
	m_pBorrow->m_Proof_ID=m_strProofID;

	m_pBorrow->SetFieldNull(&(m_pBorrow->m_Book_ID),FALSE);
	m_pBorrow->m_Book_ID=m_strBookID;

	CTime curTime=CTime::GetCurrentTime();
	m_pBorrow->SetFieldNull(&(m_pBorrow->m_Borrow_Date),FALSE);
	m_pBorrow->m_Borrow_Date=curTime;
	
	m_pBorrow->Update();
	m_pBorrow->Requery();
	m_pBorrow->Close();
	m_database.Close();

	MessageBox("Borrowing Successfully!","借书/还书",MB_OK|MB_ICONINFORMATION);
	RefreshData();
	
}

void CBorrowDlg::OnButtonBack() 
{
	if(m_database.IsOpen())
		m_database.Close();
	OnOK();
}

void CBorrowDlg::OnClose() 
{
	OnButtonBack();
}

BOOL CBorrowDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
		
	m_ctrList.InsertColumn(0,"借阅证号");
	m_ctrList.InsertColumn(1,"姓名");
	m_ctrList.InsertColumn(2,"性别");
	m_ctrList.InsertColumn(3,"书号");
	m_ctrList.InsertColumn(4,"书籍名称");
	m_ctrList.InsertColumn(5,"借书日期");

	RECT rect;
	m_ctrList.GetWindowRect(&rect);
	int Width=rect.right-rect.left;
	m_ctrList.SetColumnWidth(0,Width/6);
	m_ctrList.SetColumnWidth(1,Width/6);
	m_ctrList.SetColumnWidth(2,Width/6);
	m_ctrList.SetColumnWidth(3,Width/6);
	m_ctrList.SetColumnWidth(4,Width/6);
	m_ctrList.SetColumnWidth(5,Width/6);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBorrowDlg::RefreshData()
{
	//刷新显示
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("Cannot open database!","借书/还书");
			return;
		}
	}
	CString strSQL,m_strName,m_strBName,m_strBookNo,m_strSex;
	char buf[50];
	CDBVariant varValue;
	//处理借阅证信息
	CProofSet *m_pProof=new CProofSet(&m_database);
	strSQL.Format("select * from Proof_Info where Proof_ID='%s'",m_strProofID);
	m_pProof->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pProof->GetRecordCount()==0)
	{
		MessageBox("Cannot read table Proof_Info","借书/还书");
		m_pProof->Close();
		m_database.Close();
		return;
	}
	m_pProof->GetFieldValue(1,varValue);
	m_strName=varValue.m_pstring->GetBuffer(1);
	m_pProof->GetFieldValue(2,varValue);
	m_strSex=varValue.m_pstring->GetBuffer(1);
	m_pProof->Close();

	//处理表格
	strSQL.Format("select * from Borrow_Info where Proof_ID='%s'",m_strProofID);
	CBorrowSet *m_pBorrow=new CBorrowSet(&m_database);
	m_pBorrow->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pBorrow->GetRecordCount()==0)
	{
		MessageBox("Cannot get borrowing information!","借书/还书",MB_OK|MB_ICONINFORMATION);
		m_pBorrow->Close();
		m_database.Close();
		return;
	}
	m_ctrList.DeleteAllItems();
	m_pBorrow->MoveFirst();
	int i=0;
	CBookSet *m_pBook=new CBookSet(&m_database);

	while(!m_pBorrow->IsEOF())
	{
		m_ctrList.InsertItem(i,buf);
		m_ctrList.SetItemText(i,0,m_strProofID);
		
		m_ctrList.SetItemText(i,1,m_strName);
		m_ctrList.SetItemText(i,2,m_strSex);
		m_pBorrow->GetFieldValue(2,varValue);
		m_strBookNo=varValue.m_pstring->GetBuffer(1);
		m_ctrList.SetItemText(i,3,m_strBookNo);
		m_pBorrow->GetFieldValue(3,varValue);
		sprintf(buf,"%d-%d-%d %d:%d:%d",varValue.m_pdate->year,
			varValue.m_pdate->month,varValue.m_pdate->day,
			varValue.m_pdate->hour,varValue.m_pdate->minute,
			varValue.m_pdate->second);
		m_ctrList.SetItemText(i,5,buf);
		
		strSQL.Format("select * from Book_Info where Book_ID='%s'",m_strBookNo);
		m_pBook->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		m_pBook->GetFieldValue(1,varValue);
		m_ctrList.SetItemText(i,4,varValue.m_pstring->GetBuffer(1));
		m_pBook->Close();
		i++;
		m_pBorrow->MoveNext();
	}
	m_pBorrow->Close();
	m_database.Close();
}

void CBorrowDlg::OnButtonCheckBorrow() 
{
	CCheckBorrowDlg dlg;
	dlg.m_strProofID=m_strProofID;
	dlg.DoModal();
}

void CBorrowDlg::OnButtonReturn() 
{
	UpdateData();
	if(m_strProofID==""||m_strBookID=="")
	{
		MessageBox("输入的域不完整，请重新输入！","借书管理",MB_ICONERROR);
		m_strProofID.Empty();
		m_strBookID.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("Cannot access the database!","借书管理");
			return;
		}
	}
	
	CString strSQL;
	//借书信息表中是否有借书人的信息
	strSQL.Format("select * from Borrow_Info where Proof_ID='%s' AND Book_ID='%s'",m_strProofID,m_strBookID);
	CBorrowSet *m_pBorrow=new CBorrowSet(&m_database);
	m_pBorrow->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pBorrow->GetRecordCount()==0)
	{
		MessageBox("你并没有借这本书!","借书/还书",MB_OK|MB_ICONINFORMATION);
		m_pBorrow->Close();
		m_database.Close();
		return;
	}
	//借有这本书，删除这条记录信息。
	m_pBorrow->Delete();
	m_pBorrow->Close();
	//将借书人借书的总数减一
	strSQL.Format("select * from Proof_Info where Proof_ID='%s'", m_strProofID);
	CProofSet *m_pProof=new CProofSet(&m_database);
	m_pProof->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pProof->GetRecordCount()==0)
	{
		MessageBox("数据库中没有这个人！","借书/还书",MB_ICONINFORMATION);
		m_pProof->Close();
		m_database.Close();
		return;
	}
	CDBVariant varValue;
	//借书量加一
	m_pProof->Edit();
	m_pProof->m_Now_Borrow_Amount--;
	m_pProof->Update();
	m_pProof->Requery();
	m_pProof->Close();
	//Book_Info表中，现存数量加一
	strSQL.Format("select * from Book_Info where Book_ID='%s'",m_strBookID);
	CBookSet *m_pBook=new CBookSet(&m_database);
	m_pBook->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pBook->GetRecordCount()==0)
	{
		MessageBox("对不起，本馆没有这本书!","借书/还书",MB_ICONINFORMATION);
		m_pBook->Close();
		m_database.Close();
		return;
	}
	m_pBook->Edit();
	m_pBook->m_Now_Amount++;
	m_pBook->Update();
	m_pBook->Requery();
	m_pBook->Close();
	
	m_database.Close();

	MessageBox("Return Successfully!","借书/还书",MB_OK|MB_ICONINFORMATION);
	RefreshData();		
}

void CBorrowDlg::OnButtonCheckBooks() 
{
	CCheckBooksDlg m_dlg;
	m_dlg.DoModal();
}