borrowdlg.cpp

应用于现代图书馆的管理系统的源码程序

// BorrowDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "BorrowDlg.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_ReaderId = _T("");
	m_BookId = _T("");
	//}}AFX_DATA_INIT
}


void CBorrowDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBorrowDlg)
	DDX_Text(pDX, IDC_EDIT1, m_ReaderId);
	DDX_Text(pDX, IDC_EDIT2, m_BookId);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBorrowDlg, CDialog)
	//{{AFX_MSG_MAP(CBorrowDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

BOOL CBorrowDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_bBorrow=false;
	m_bLend=false;
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBorrowDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
    CString sqlStr;
	sqlStr="SELECT * FROM READER WHERE READER_ID='";
	sqlStr+=m_ReaderId;
	sqlStr+="'";
	if(!rdSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("reader表打开失败!");
		rdSet.Close();
		return;
	}
	if(rdSet.IsEOF()&&rdSet.IsBOF())
	{
		AfxMessageBox("读者id不存在!");
		
	}
	else 
	{
		if(rdSet.m_FLAG_BORROW!="Y")
		{
			AfxMessageBox("此读者不能借书!");
		}
		else
		{
			m_bBorrow=true;
		}
	}
	rdSet.Close();

	CString sqlStr1;
	sqlStr1="SELECT * FROM BOOK WHERE BOOK_ID='";
	sqlStr1+=m_BookId;
	sqlStr1+="'";
	if(!bkSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr1))
	{
		AfxMessageBox("book表打开失败!");
		bkSet.Close();
		return;
	}
	if(bkSet.IsBOF()&&bkSet.IsEOF())
	{
		AfxMessageBox("不存在此书!");
	}
	else
	{
		if(bkSet.m_FLAG_BORROW!="Y")
		{
			AfxMessageBox("该书不能借!");
		}
		else
		{
			m_bLend=true;
		}
		
	}
	CString str;
	str="nallg";
	bkSet.Close();
	CTime curtime;
	curtime=CTime::GetCurrentTime();
	if(m_bBorrow&&m_bLend)
	{
	sqlStr="INSERT INTO BORROW(READER_ID,BOOK_ID,B_CLERK_ID) VALUES('";
	sqlStr+=m_ReaderId;
	sqlStr+="','";
	sqlStr+=m_BookId;
	sqlStr+="','";
//	sqlStr+=curtime;
//	sqlStr+="','";
	sqlStr+=str;
	sqlStr+="')";
	MessageBox(sqlStr);
	CDatabase mDB;
	if(!mDB.Open(_T("Library")))
	{
		AfxMessageBox("数据库打开失败!");
		return;
	}
	try
	{
		mDB.ExecuteSQL(sqlStr);
	}
	catch(CDBException e)
	{
		AfxMessageBox("error");
		return;
	}
	mDB.Close();
	sqlStr="SELECT * FROM BORROW WHERE READER_ID='";
	sqlStr+=m_ReaderId;
	sqlStr+="'AND BOOK_ID='";
	sqlStr+=m_BookId;
	sqlStr+="'";
	if(!brwSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("borrow表打开失败!");
	}
	if(!brwSet.IsBOF())
	{
		brwSet.MoveLast();
		brwSet.Edit();
		brwSet.m_BORROW_DATE=curtime;
		brwSet.Update();
		brwSet.Requery();
	}
	brwSet.Close();
	MessageBox("操作成功!");
	}
	//设置时间




	

}