book.cpp

图书馆借阅管理系统

#include <stdafx.h>
#include "Book.h"
#include "Library.h"
//在此引用应用类中的theApp来获取库连接指针
extern CLibraryApp theApp;       

CBook::CBook()
{}

CBook::~CBook()
{}

//新书入库
int CBook::PushToLibrary(void)
{
	return 1;
}

//该书是否可以借出
int CBook::IsValidBook(void)
{ 
	int i=0;

	if(Borrowed)
		i=1;
	if(Bespeaked)
		i=2;

	return i;
}
		
//删除
int CBook::Delete(int DeletedBookID)
{
	CString SQLText;
	SQLText.Format("Update TB_BookInfo set Borrowed=1 where SysID=%d",DeletedBookID);


	return 1;
}

//是否已借出,返回预约读者的帐号
CString CBook::IsBorrowed(void)
{
	if(Borrowed)
		return BookID;
	else
		return "";
}

//是否已预约,返回预约读者的帐号
CString CBook::IsBespeaked(void)
{
	if(Bespeaked)
		return BookID;
	else
		return "";
}

//读取图书信息
int CBook::ReadBookInfo(CString strBookID)
{
	CString SQLText;

	_RecordsetPtr pRst(__uuidof(Recordset));

	SQLText.Format("select * from TB_BookInfo where Deleted=0 and BookID='%s'",strBookID);

	try
	{
		//SQL Server数据库
		pRst=theApp.pConn->Execute(_bstr_t(SQLText),NULL,adCmdText);

		if(!pRst->BOF)
		{
			CString BorrowedID,BespeakedID;

			_variant_t vBookID		= pRst->GetCollect("BookID");
			_variant_t vBookName	= pRst->GetCollect("BookName");
			_variant_t vAuthor		= pRst->GetCollect("Author");
			_variant_t vCHNum		= pRst->GetCollect("CHNum");
			_variant_t vBrwStatus	= pRst->GetCollect("Borrowed");
			_variant_t vBskStatus	= pRst->GetCollect("Bespeaked");

			BookID		=	vBookID.bstrVal;
			BookName	=	vBookName.bstrVal;
			Author		=	vAuthor.bstrVal;
			CHNum		=	vCHNum.bstrVal;
			if(vBrwStatus.vt!=VT_NULL)
				BorrowedID	=	vBrwStatus.bstrVal;
			if(vBskStatus.vt!=VT_NULL)
				BespeakedID	=	vBskStatus.bstrVal;

			if(strcmp(BorrowedID,"")==0)
				Borrowed=0;
			else
				Borrowed=1;
			if(strcmp(BespeakedID,"")==0)
				Bespeaked=0;
			else
				Bespeaked=1;

			return 1;
		}
		else
		{
			::MessageBox(NULL,"没有相关记录","提示",MB_OK);
			return 0;
		}
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
		return 0;
	}
	
	pRst->Close();
	pRst.Release();
}