borrow.cpp

图书管理系统可进行查询,添加,修改,等操作 用树行结构为图书馆进行图书分类

// borrow.cpp: implementation of the Cborrow class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "图书管理.h"
#include "borrow.h"
#include "ADOConn.h"
	

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

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

Cborrow::Cborrow()
{
 bookno="";
 readno="";
 btime=0;
 htime="";
 money=0;

}

Cborrow::~Cborrow()
{

}

int Cborrow::Havename(CString str,CString str2)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL,vSQL2;
	vSQL = "SELECT * FROM book WHERE bookno='" + str+"' ";
	vSQL2 = "SELECT * FROM reader WHERE readno='"+str2+"'";
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
    _RecordsetPtr m_pRecordset2;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
    m_pRecordset2 = m_AdoConn.GetRecordSet(vSQL2);
	if (m_pRecordset->adoEOF||m_pRecordset2->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Cborrow::sql_insert()
{	
	//连接数据库
	CString string,string3;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
//	CString strUpperId;
//	strUpperId.Format("%d", UpperId);
     string.Format("%d",btime);
	 string3.Format("%d",money);
	_bstr_t vSQL;
	vSQL = "INSERT INTO borrow (bookno ,readno, btime, htime,money) VALUES('"+ bookno + "','" + readno + "','" + string + "','" +htime+"','"+ string3+"')";	
	//执行INSERT语句
     m_AdoConn.ExecuteSQL(vSQL);	

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

//	return lDepId;
}

void Cborrow::sql_update(CString bookno,CString readno)
{
	//连接数据库
	CString string,string3,string2;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语
     string.Format("%d",btime);
	 string3.Format("%d",money);

	_bstr_t vSQL;
	
	vSQL = "UPDATE borrow SET btime='" +string+"',htime='" +htime+ "',money='" +string3+"'WHERE bookno='" + bookno+"'AND readno='"+readno+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void Cborrow::sql_delete(CString cDepId,CString str)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	if(str=="")
    vSQL = "DELETE FROM borrow WHERE bookno='" + cDepId+"'";
	else
	 if(cDepId=="")
      vSQL = "DELETE FROM borrow WHERE readno='" + str+"'";
	else
      vSQL = "DELETE FROM borrow WHERE bookno='" + cDepId+"'AND readno='"+str+"' ";
	//执行DELETE语句

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

//根据员工编号读取所有字段值
void Cborrow::GetData(CString cDepId,CString str)
{
	//连接数据库
	CString string,string3,string2;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM borrow WHERE bookno='" + cDepId+"'AND readno='"+str+"' ";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		Cborrow();
	else
	{
		bookno = cDepId;
        readno=str;
		string = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("btime");
		htime = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("htime");
		string3 = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("money");
		btime=atoi(string);
		money=atoi(string3);
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}