rent.cpp

影碟租赁系统

// rent.cpp: implementation of the Crent class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "课程设计.h"
#include "rent.h"
#include "ADOConn.h"

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

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

Crent::Crent()
{

}

Crent::~Crent()
{

}

void Crent::sql_delete(CString Id)
{
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM BORROW WHERE ID=" + Id;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Crent::sql_insert()
{
     //连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	CString strid;
	strid.Format("%d",id);
	_bstr_t vSQL;
	vSQL = "INSERT INTO BORROW values('" + time + "'," + strid + ")";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
int Crent::sql_gettime(CString Id)
{
   ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置察看日期语句
	_bstr_t vSQL;
	vSQL = "select DATEDIFF(day, LEND_TIME, getdate()) as Time from BORROW  where ID=" + Id; 
    _RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
    return atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Time"));
}