proofguashidlg.cpp

实现基本的图书馆管理系统

// ProofGuashiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "图书馆管理系统.h"
#include "ProofGuashiDlg.h"
#include "BookBorrowEdit.h"
#include "Proof_Info.h"
#include "column.h"
#include "columns.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProofGuashiDlg dialog


CProofGuashiDlg::CProofGuashiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CProofGuashiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CProofGuashiDlg)
	m_BorrowID = _T("");
	//}}AFX_DATA_INIT
}


void CProofGuashiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProofGuashiDlg)
	DDX_Text(pDX, IDC_BORROWID_EDIT, m_BorrowID);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID3, m_dataGridEm);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProofGuashiDlg, CDialog)
	//{{AFX_MSG_MAP(CProofGuashiDlg)
	ON_BN_CLICKED(IDC_SHOWPROOF_BUTTON, OnShowproofButton)
	ON_BN_CLICKED(IDC_PROOFGUASHI, OnProofguashi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProofGuashiDlg message handlers

void CProofGuashiDlg::OnShowproofButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CBookBorrowEdit bookborrowedit;

	if(m_BorrowID=="")
	{
		MessageBox("请输入借阅证号！");
		return;
	}

	bookborrowedit.SetBorrowID(m_BorrowID);

	if (bookborrowedit.HaveBorrowID(m_BorrowID) == 1)
	{
		//更新数据
		CString  cSource="select BookID,BookName,Writer,Press,Price from Book_Info where "
			             "BookID in(select BookID from Borrow_Info where BorrowID in(select"
						 " BorrowID from Proof_Info where BorrowID='"+m_BorrowID+"'))";

		m_Adodc.SetRecordSource(cSource);
		m_Adodc.Refresh();
		////////////////////////////
		//设置列的宽度
		CColumns allCols;
		CColumn  onecol;
		//获得dataGrid控件的列集对象
		allCols=m_dataGridEm.GetColumns();

		//以序号为参数获得某列对象
		onecol=allCols.GetItem(COleVariant(long(0)));
		//设置属性
		onecol.SetCaption(" 图书号");
	    //设置列宽
	    onecol.SetWidth (50);

	    onecol=allCols.GetItem(COleVariant(long(1)));
		onecol.SetCaption(" 图书名称");
		onecol.SetWidth (100);
		

		onecol=allCols.GetItem(COleVariant(long(2)));
		onecol.SetCaption(" 作者");
		onecol.SetWidth (70);


		onecol=allCols.GetItem(COleVariant(long(3)));
		onecol.SetCaption(" 出版社");
		onecol.SetWidth (100);

	    onecol=allCols.GetItem(COleVariant(long(4)));
		onecol.SetCaption(" 价格");
		onecol.SetWidth (40);


	}
	else
	{
		MessageBox("借阅证不存在，请重新输入！");
       	return;
	}

	
}

void CProofGuashiDlg::OnProofguashi() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CBookBorrowEdit bookborrowedit;
	CProof_Info proof_info;

	if(m_BorrowID=="")
	{
		MessageBox("请输入借阅证号！");
		return;
	}
	
	bookborrowedit.SetBorrowID(m_BorrowID);
	proof_info.SetBorrowID(m_BorrowID);
	bookborrowedit.GetData(m_BorrowID);

	if (bookborrowedit.HaveBorrowID(m_BorrowID) == 1)
	{
		if(bookborrowedit.GetData(m_BorrowID))
		{
			MessageBox("你还有其他书籍未还，请及时归还！归还后方可挂失！");
			return;
		}
		else
		{
			///删除借阅表中的学生信息
			proof_info.sql_delete();
		//	bookborrowedit.sql_delete();
			MessageBox("挂失成功！");
		}
	}
	else
	{
		MessageBox("不存在该借阅号，请重新输入！");
		return;
	}
}