payout.cpp

家庭财务管理系统

// PayOut.cpp: implementation of the CPayOut class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Money.h"
#include "PayOut.h"
#include "ADOConn.h"


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

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

CPayOut::CPayOut()
{
	UserName="";
	DateTime="";
	UserMoney=0;
	MoneyType="";

}

CPayOut::~CPayOut()
{

}

void CPayOut::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	
	CString strUserMoney;
	strUserMoney.Format("%d", UserMoney);

	_bstr_t vSQL;
	vSQL = "INSERT INTO PayOut VALUES('" + UserName + "','"+DateTime+"',"+ strUserMoney + ",'" + MoneyType + "')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CPayOut::sql_update(CString vPayIndex)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	CString strUserMoney;
	strUserMoney.Format("%d", UserMoney);
	_bstr_t vSQL;
	vSQL = "UPDATE PayOut SET UserName='"+UserName+"',DateTime='"+DateTime+"',UserMoney=" + strUserMoney + ",MoneyType='" + MoneyType + "' WHERE PayIndex='" + vPayIndex + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
//删除用户信息
void CPayOut::sql_delete(CString vPayIndex)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	CString strPayIndex;
	strPayIndex.Format("%d",PayIndex);
	_bstr_t vSQL;
	vSQL = "DELETE FROM PayOut WHERE PayIndex='"+ vPayIndex+"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//根据用户名读取所有字段值
void CPayOut::GetData(CString cUserName)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM PayOut WHERE UserName='" + cUserName + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CUsers();
	else
	{
		UserName = cUserName;
		UserMoney = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserMoney"));
		DateTime = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DateTime");
		MoneyType = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MoneyType");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//判断指定用户名是否存在
bool CPayOut::HaveRecord(CString cUserName)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM PayOut WHERE UserName='" + cUserName + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return false;
	else
		return true;

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