reader.cpp

图书管理系统 带源码 文档

// Reader.cpp: implementation of the CReader class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Library.h"
#include "Reader.h"
#include "ADOConn.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

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

CReader::CReader()
{
	Rd_No = "";
	Rd_PW = "";
	Rd_Name = "";
	Rd_Type = "";
	Rd_Address = "";
	Rd_Tel = "";
	Rd_Pay = 0.00;
	Rd_BrNum = 0;
	Rd_TotalNum = 0;
}

CReader::~CReader()
{

}

CString CReader::GetNo()
{
	return Rd_No;
}

CString CReader::GetName()
{
	return Rd_Name;
}

CString CReader::GetAddress()
{
	return Rd_Address;
}

CString CReader::GetPW()
{
	return Rd_PW;
}

CString CReader::GetSex()
{
	return Rd_Sex;
}

CString CReader::GetTel()
{
	return Rd_Tel;
}

CString CReader::GetType()
{
	return Rd_Type;
}

float CReader::GetPay()
{
	return Rd_Pay;
}

int CReader::GetBrNum()
{
	return Rd_BrNum;
}

int CReader::GetTotalNum()
{
	return Rd_TotalNum;
}

void CReader::SetAddress(CString vAddress)
{
	Rd_Address = vAddress;
}

void CReader::SetName(CString vName)
{
	Rd_Name = vName;
}

void CReader::SetNo(CString vNo)
{
	Rd_No = vNo;
}

void CReader::SetPW(CString vPW)
{
	Rd_PW = vPW;
}

void CReader::SetSex(CString vSex)
{
	Rd_Sex = vSex;
}

void CReader::SetTel(CString vTel)
{
	Rd_Tel = vTel;
}

void CReader::SetType(CString vType)
{
	Rd_Type = vType;
}

void CReader::SetPay(float vPay)
{
	Rd_Pay = vPay;
}

void CReader::SetBrNum(int vBrNum)
{
	Rd_BrNum = vBrNum;
}

void CReader::SetTotalNum(int vTotalNum)
{
	Rd_TotalNum = vTotalNum;
}

void CReader::GetData(CString vNo)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	vSQL = "SELECT * FROM Reader WHERE RNo='" + vNo+"'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	if (m_pRecordset->adoEOF)
		CReader();
	else
	{
		Rd_No = vNo;
		Rd_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("RName");
		Rd_PW = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PW");
		Rd_Type = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Type");
		Rd_Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		Rd_Address = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Address");
		Rd_Tel = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Tel");
		Rd_Pay = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pay"));
		Rd_BrNum = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BrNum"));
		Rd_TotalNum = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TotalNum"));

		m_AdoConn.ExitConnect();
	}
}


void CReader::SQL_Insert()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	CString strPay,strBrNum,strTNum;
	strPay.Format("%f", Rd_Pay);
	strBrNum.Format("%d",Rd_BrNum);
	strTNum.Format("%d",Rd_TotalNum);

	_bstr_t vSQL;
	vSQL = "INSERT INTO Reader VALUES('"+Rd_No+"','"+Rd_PW+"','"+Rd_Name+"','"+Rd_Type+"','"+Rd_Sex
		+"','"+Rd_Address+"','"+Rd_Tel+"',"+strPay+","+strBrNum+","+strTNum+")";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CReader::SQL_Update(CString vNo)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	CString strPay,strBrNum,strTNum;
	strPay.Format("%f", Rd_Pay);
	strBrNum.Format("%d",Rd_BrNum);
	strTNum.Format("%d",Rd_TotalNum);

	_bstr_t vSQL;
	vSQL = "UPDATE Reader SET PW='"+Rd_PW+"',RName='"+Rd_Name+"',Type='"+Rd_Type+"',Sex='"+Rd_Sex
		+"',Address='"+Rd_Address+"',Tel='"+Rd_Tel+"',Pay="+strPay+",BrNum="+strBrNum
		+",TotalNum="+strTNum+" WHERE RNo='"+vNo+"'";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CReader::SQL_Delete(CString vNo)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Reader WHERE RNo='" + vNo +"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}