bookborrowedit.cpp

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

// BookBorrowEdit.cpp: implementation of the CBookBorrowEdit class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "图书馆管理系统.h"
#include "BookBorrowEdit.h"
#include "ADOConn.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CBookBorrowEdit::CBookBorrowEdit()
{

}

CBookBorrowEdit::~CBookBorrowEdit()
{
	BorrowID="";
	BookID="";
	BorrowTime="";
}

CString CBookBorrowEdit::GetBorrowID()
{
	return BorrowID;
}

void CBookBorrowEdit::SetBorrowID(CString cBorrowID)
{
	BorrowID = cBorrowID;
}

CString CBookBorrowEdit::GetBookID()
{
	return BookID;
}

void CBookBorrowEdit::SetBookID(CString cBookID)
{
	BookID = cBookID;
}

CString CBookBorrowEdit::GetBorrowTime()
{
	return BorrowTime;
}

void CBookBorrowEdit::SetBorrowTime(CString cBorrowTime)
{
	BorrowTime = cBorrowTime;
}

int CBookBorrowEdit::HaveBorrowID(CString cBorrowID)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Proof_Info WHERE BorrowID='" + cBorrowID + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

int CBookBorrowEdit::HaveBookID(CString cBookID)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Book_Info WHERE BookID='" + cBookID + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CBookBorrowEdit::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句

	_bstr_t vSQL;

	vSQL = "INSERT INTO Borrow_Info (BorrowID,BookID,BorrowTime) VALUES ('"+BorrowID+"','"+BookID+"',getdate())";

	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CBookBorrowEdit::sql_delete()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句

	_bstr_t vSQL;

	vSQL = "delete Borrow_Info where BorrowID in (select BorrowID from Borrow_Info where"
		   " BorrowID="+BorrowID+") and  BookID in (select BookID from Borrow_Info where BookID="+BookID+") ";

	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

int CBookBorrowEdit::GetData(CString cBorrowID)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Borrow_Info WHERE BorrowID='" + cBorrowID + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
	{
		return 0;
	}
	else
	{
		return 1;
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}