proof_info.cpp

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

// Proof_Info.cpp: implementation of the CProof_Info class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CProof_Info::CProof_Info()
{

}

CProof_Info::~CProof_Info()
{
	BorrowID="";
	Stu_Name="";
	Class="";
	Sex="";
	Sex1="";
	ID_Number="";
	Tel_Number="";
	Borrow_Amount="";
}

CString CProof_Info::GetSex()
{
	return Sex;
}

void CProof_Info::SetSex(CString cSex)
{
	Sex = cSex;
}

CString CProof_Info::GetBorrowID()
{
	return BorrowID;
}
void CProof_Info::SetBorrowID(CString cBorrowID)
{
	BorrowID = cBorrowID;
}


CString CProof_Info::GetStu_Name()
{
	return Stu_Name;
}

void CProof_Info::SetStu_Name(CString cStu_Name)
{
	Stu_Name = cStu_Name;
}

CString CProof_Info::GetClass()
{
	return Class;
}

void CProof_Info::SetClass(CString cClass)
{
	Class = cClass;
}

CString CProof_Info::GetID_Number()
{
	return ID_Number;
}

void CProof_Info::SetID_Number(CString cID_Number)
{
	ID_Number = cID_Number;
}


CString CProof_Info::GetTel_Number()
{
	return Tel_Number;
}

void CProof_Info::SetTel_Number(CString cTel_Number)
{
	Tel_Number = cTel_Number;
}

CString CProof_Info::GetBorrow_Amount()
{
	return Borrow_Amount;
}

void CProof_Info::SetBorrow_Amount(CString cBorrow_Amount)
{
	Borrow_Amount = cBorrow_Amount;
}




//////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////
int CProof_Info::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();
}


void CProof_Info::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strBorrow_Amount;
	strBorrow_Amount.Format("%d", Borrow_Amount);
	_bstr_t vSQL;

	vSQL = "INSERT INTO Proof_Info (BorrowID,Stu_Name,Class,Sex,ID_Number,Tel_Number,Borrow_Amount)"
		   " VALUES ('"+BorrowID+"','"+Stu_Name+"','"+Class+"','"+Sex+"','"+ID_Number+"','"+Tel_Number+"',0)";

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


void CProof_Info::sql_update_AddBorrowAmount()
{	
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	_bstr_t vSQL;
	vSQL="update Proof_Info Set Borrow_Amount = Borrow_Amount+1 where BorrowID='"+BorrowID+"'";
	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

void CProof_Info::sql_update_DecBorrowAmount()
{	
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	_bstr_t vSQL;
	vSQL="update Proof_Info Set Borrow_Amount = Borrow_Amount-1 where BorrowID='"+BorrowID+"'";
	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

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

	_bstr_t vSQL;

	vSQL = "delete Proof_Info where BorrowID = "+BorrowID+" ";

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


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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CProof_Info();
	else
	{
		
		Borrow_Amount = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Borrow_Amount"));
	}

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