furbrdlg.cpp

这是一个实验室的图书管理系统

// FurbrDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Lab.h"
#include "FurbrDlg.h"
#include "FurCheckDlg.h"
#include "FurHaveDlg.h"
#include "ProofSet.h"
#include "FurSet.h"
#include "FurBowSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CFurbrDlg dialog


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


void CFurbrDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFurbrDlg)
	DDX_Control(pDX, IDC_LIST, m_ctrList);
	DDX_Text(pDX, IDC_EDIT_FURID, m_strFurID);
	DDX_Text(pDX, IDC_EDIT_BOWID, m_strProofID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFurbrDlg, CDialog)
	//{{AFX_MSG_MAP(CFurbrDlg)
	ON_BN_CLICKED(IDC_BTN_EXIT, OnBtnExit)
	ON_BN_CLICKED(IDC_BTN_CHECK, OnBtnCheck)
	ON_BN_CLICKED(IDC_BTN_HB, OnBtnHb)
	ON_BN_CLICKED(IDC_BTN_BORROW, OnBtnBorrow)
	ON_BN_CLICKED(IDC_BTN_RETURN, OnBtnReturn)
	ON_BN_CLICKED(IDC_BTN_RESET, OnBtnReset)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFurbrDlg message handlers

void CFurbrDlg::OnBtnExit() 
{
	// TODO: Add your control notification handler code here
	if(m_database.IsOpen())
	   m_database.Close();
	OnOK();
}

void CFurbrDlg::OnBtnCheck() 
{
	// TODO: Add your control notification handler code here
	CFurCheckDlg dlg;
	dlg.DoModal();
}

//DEL BOOL CFurbrDlg::OnInitDialog()
//DEL {
//DEL 
//DEL }

BOOL CFurbrDlg::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,"借出日期");
	//m_ctrList.InsertColumn(6,"应还日期");

	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.SetColumnWidth(6,Width/7);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	return TRUE;
}

void CFurbrDlg::OnBtnHb() 
{
	// TODO: Add your control notification handler code here
	CFurHaveDlg dlg;
	dlg.DoModal();
}

void CFurbrDlg::OnBtnBorrow() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strProofID==""||m_strFurID=="")
	{
		MessageBox("输入的域不完整，请重新输入！","借家具管理",MB_ICONERROR);
		m_strProofID.Empty();
		m_strFurID.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Lab")))
		{
			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("数据库中没有这个人的信息","借家具/还家具",MB_ICONINFORMATION);
		m_pProof->Close();
		m_database.Close();
		return;
	}
	CDBVariant varValue;
	m_pProof->GetFieldValue(7,varValue);
	if(varValue.m_iVal==4)
	{
		//如果不满足条件
		MessageBox("你不能借家具超过4件!","借家具/还家具",MB_OK|MB_ICONINFORMATION);
		m_pProof->Close();
		m_database.Close();
		return;
	}
	
	
	strSQL.Format("select * from fur_info where Fur_Id='%s'",m_strFurID);
	CFurSet *m_pFur=new CFurSet(&m_database);
	m_pFur->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);

	if(m_pFur->m_NowCount==0)
	{
		//如果不满足条件
		MessageBox("图书馆现在没有这件家具!","借家具/还家具",MB_OK|MB_ICONINFORMATION);
		m_pFur->Close();
		m_database.Close();
		return;
	}
	if(m_pFur->GetRecordCount()==0  )
	{
		MessageBox("对不起，图书馆现在没有这件家具!","借家具/还家具",MB_ICONINFORMATION);
		m_pFur->Close();
		m_database.Close();

		return;
	}
	
	//满足条件
	//借书量加一
	m_pProof->Edit();
	m_pProof->m_Now_Borrow_Amount++;
	m_pProof->Update();
	m_pProof->Requery();
	m_pProof->Close();
	//Fur_Info表中，现存数量减一
	m_pFur->Edit();
	m_pFur->m_NowCount--;
	m_pFur->Update();
	m_pFur->Requery();
	m_pFur->Close();
	//将借书信息存入借书信息表中
	strSQL.Format("select * from borrowfur_info");
	CFurBowSet *m_pBorrow=new CFurBowSet(&m_database);
	m_pBorrow->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pBorrow->GetRecordCount()==0)
	{
		MessageBox("数据库中没有借家具信息!","借家具/还家具",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_Fur_Id),FALSE);
	m_pBorrow->m_Fur_Id=m_strFurID;

	CTime curTime=CTime::GetCurrentTime();
	m_pBorrow->SetFieldNull(&(m_pBorrow->m_BorrowDate),FALSE);
	m_pBorrow->m_BorrowDate=curTime;

	//m_pBorrow->m_BorrowID=m_pBorrow->GetRecordCount();
	
	m_pBorrow->Update();
	m_pBorrow->Requery();
	m_pBorrow->Close();
	m_database.Close();

	MessageBox("借家具成功!","借家具/还家具",MB_OK|MB_ICONINFORMATION);
	RefreshData();
}

void CFurbrDlg::RefreshData()
{
	//刷新显示
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Lab")))
		{
			MessageBox("打开数据库失败!","借家具/还家具");
			return;
		}
	}
	CString strSQL,m_strName,m_strFName,m_strFurID,m_strSex;
	char buf[100];
	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;
	}
	CString strTemp;
	m_pProof->GetFieldValue(1,strTemp);
	m_strName=strTemp;
	m_pProof->GetFieldValue(2,strTemp);
	m_strSex=strTemp;
	m_pProof->Close();

	//处理表格
	strSQL.Format("select * from borrowfur_info where Proof_ID='%s'",m_strProofID);
	CFurBowSet *m_pBorrow=new CFurBowSet(&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_ctrList.DeleteAllItems();
	m_pBorrow->MoveFirst();
	int i=0;
	CFurSet *m_pFur=new CFurSet(&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(3,strTemp);
		m_strFurID=strTemp;
		m_ctrList.SetItemText(i,3,m_strFurID);

		m_ctrList.SetItemText(i,4,m_strFName);


		m_pBorrow->GetFieldValue(5,varValue);
		sprintf(buf,"%d-%d-%d %d:%d:%d",varValue.m_pdate->year,
			varValue.m_pdate->month,varValue.m_pdate->day);
		m_ctrList.SetItemText(i,5,buf);
		
		strSQL.Format("select * from fur_info where Fur_Id='%s'",m_strFurID);
		m_pFur->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		m_pFur->GetFieldValue(1,strTemp);
		m_ctrList.SetItemText(i,4,strTemp);
		m_pFur->Close();
		i++;
		m_pBorrow->MoveNext();
	}
	m_pBorrow->Close();
	m_database.Close();
}

void CFurbrDlg::OnBtnReturn() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strProofID==""||m_strFurID=="")
	{
		MessageBox("输入的域不完整，请重新输入！","借家具管理",MB_ICONERROR);
		m_strProofID.Empty();
		m_strFurID.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Lab")))
		{
			MessageBox("Cannot access the database!","借家具管理");
			return;
		}
	}

	CString strSQL;
	//借家具信息表中是否有此人的信息
	strSQL.Format("select * from borrowfur_info where Proof_ID='%s' AND Fur_Id='%s'",m_strProofID,m_strFurID);
	CFurBowSet *m_pBorrow=new CFurBowSet(&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 fur_info where Fur_Id='%s'",m_strFurID);
	CFurSet *m_pFur=new CFurSet(&m_database);
	m_pFur->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pFur->GetRecordCount()==0)
	{
		MessageBox("对不起，本馆没有这件家具!","借家具/还家具",MB_ICONINFORMATION);
		m_pFur->Close();
		m_database.Close();
		return;
	}
	m_pFur->Edit();
	m_pFur->m_NowCount++;
	m_pFur->Update();
	m_pFur->Requery();
	m_pFur->Close();
	
	m_database.Close();

	MessageBox("还家具成功!","借家具/还家具",MB_OK|MB_ICONINFORMATION);
	RefreshData();
	
}

void CFurbrDlg::OnBtnReset() 
{
	// TODO: Add your control notification handler code here
	m_strProofID.Empty();
	m_strFurID.Empty();
	UpdateData(FALSE);
}