addnewbookedit.cpp

来自「实现基本的图书馆管理系统」· C++ 代码 · 共 241 行

// AddNewBookEdit.cpp: implementation of the CAddNewBookEdit class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CAddNewBookEdit::CAddNewBookEdit()
{

}

CAddNewBookEdit::~CAddNewBookEdit()
{
	BookID="";
	BookName="";
	Writer="";
	Press="";
	Price=0.0;
	InlibraryTime="";
	Total_Amount=0;
	Now_Amount=0;
}

CString CAddNewBookEdit::GetBookName()
{
	return BookName;
}

void CAddNewBookEdit::SetBookName(CString cBookName)
{
	BookName = cBookName;
}

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

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

CString CAddNewBookEdit::GetInlibraryTime()
{
	return InlibraryTime;
}

void CAddNewBookEdit::SetInlibraryTime(CString cInlibraryTime)
{
	InlibraryTime = cInlibraryTime;
}


void CAddNewBookEdit::SetWriter(CString cWriter)
{
	Writer = cWriter;
}

CString CAddNewBookEdit::GetPress()
{
	return Press;
}

void CAddNewBookEdit::SetPress(CString cPress)
{
	Press = cPress;
}

float CAddNewBookEdit::GetPrice()
{
	return Price;
}

void CAddNewBookEdit::SetPrice(float fPrice)
{
	Price = fPrice;
}

int CAddNewBookEdit::GetTotal_Amount()
{
	return Total_Amount;
}

void CAddNewBookEdit::SetTotal_Amount(int iTotal_Amount)
{
	Total_Amount = iTotal_Amount;
}

int CAddNewBookEdit::GetNow_Amount()
{
	return Now_Amount;
}

void CAddNewBookEdit::SetNow_Amount(int iNow_Amount)
{
	Now_Amount = iNow_Amount;
}



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


void CAddNewBookEdit::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strPrice;
	strPrice.Format("%f", Price);

	CString strTotal_Amount;
	strTotal_Amount.Format("%d", Total_Amount);

	CString strNow_Amount;
	strNow_Amount.Format("%d", Now_Amount);

	_bstr_t vSQL;

	vSQL = "INSERT INTO Book_Info (BookName,BookID, Writer,Press,Price,InlibraryTime,Total_Amount,Now_Amount) VALUES ('"+BookName+"','"+BookID+"','"+Writer+"','"+Press+"','"+InlibraryTime+"','"+strPrice+"','"+strTotal_Amount+"','"+strNow_Amount+"')";

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

void CAddNewBookEdit::sql_update()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strNow_Amount;
	strNow_Amount.Format("%d", Now_Amount);

	CString strTotal_Amount;
	strTotal_Amount.Format("%d", Total_Amount);

	_bstr_t vSQL;

	vSQL = "update Book_Info set Now_Amount = Now_Amount + "
		+strNow_Amount+",Total_Amount = Total_Amount+"
		+strTotal_Amount+" where BookName='"+BookName+"'";
	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CAddNewBookEdit::sql_update_DecNow_Amount()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	_bstr_t vSQL;

	vSQL = "update Book_Info set Now_Amount = Now_Amount-1  where BookID='"+BookID+"'";

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


void CAddNewBookEdit::sql_update_AddNow_Amount()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	_bstr_t vSQL;

	vSQL = "update Book_Info set Now_Amount = Now_Amount+1  where BookID='"+BookID+"'";

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



void CAddNewBookEdit::GetData(CString cBookID)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Book_Info WHERE BookID=" + cBookID;
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CAddNewBookEdit();

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}