recommendinfo.cpp

这是一个功能相对完善的电脑报价管理系统 的一个例子

// RecommendInfo.cpp: implementation of the CRecommendInfo class.
//
// 1 RecommendId int 装机编号 Identity = Yes Allow Null = False
// 2 Flag int 推荐类型（0-家庭型、1-豪华型、2-经济型） Allow Null = False
// 3 FittingId int 配件序号 Allow Null = False
// 4 Num int 数量 Allow Null = False 默认值：1
// 5 SubTotal float 小计 Allow Null = True
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "QuoteManage.h"
#include "RecommendInfo.h"
#include "ADOConn.h"

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

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

CRecommendInfo::CRecommendInfo()
{
	RecommendId = 0;
	Flag = 0;
	FittingId = 0;
	Num = 0;
	SubTotal = 0;
}

CRecommendInfo::~CRecommendInfo()
{

}
// 载入推荐配置信息
void CRecommendInfo::LoadRecommend(CString paraFlag)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM RecommendInfo WHERE Flag = " + paraFlag;
	
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//初始化数组
	a_RecommendId.RemoveAll();
	a_FittingId.RemoveAll();
	a_Num.RemoveAll();
	a_SubTotal.RemoveAll();
	
	//执行SELECT语句
	while (m_pRecordset->adoEOF == 0)
	{
		a_RecommendId.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("RecommendId"));
		a_FittingId.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("FittingId"));
		a_Num.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Num"));
		a_SubTotal.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("SubTotal"));
		
		m_pRecordset->MoveNext();
	}
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 判断是否存在相同的配置
int CRecommendInfo::HaveFitting(CString paraFlag, CString paraFId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM RecommendInfo WHERE Flag = "
		+ paraFlag + " AND FittingId = " + paraFId;
	
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return 0;
	else
		return 1;

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
int CRecommendInfo::HaveRecommend(CString cFlag)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM RecommendInfo WHERE Flag = " + cFlag ;
	
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return 0;
	else
		return 1;

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
// 读取推荐配置信息
void CRecommendInfo::GetInfo(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM RecommendInfo WHERE RecommendId = " + paraId;

	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	
	//返回各列的值
	if (m_pRecordset->adoEOF)
		CRecommendInfo();
	else
	{
		RecommendId = atol(paraId);
		Flag = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Flag"));
		FittingId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("FittingId"));
		Num = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Num"));
		SubTotal = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("SubTotal"));
	}

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
// 插入操作
void CRecommendInfo::SqlInsert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置INSERT语句
	CString cFlag;
	cFlag.Format("%d", Flag);
	CString strFittingId;
	strFittingId.Format("%ld", FittingId);
	CString strNum;
	strNum.Format("%ld", Num);
	CString strSubTotal;
	strSubTotal.Format("%lf", SubTotal);

	_bstr_t vSQL;
	vSQL = "INSERT INTO RecommendInfo(Flag, FittingId, Num, SubTotal) VALUES ('"
		+ cFlag + "', " + strFittingId + ", " + strNum + ", " + strSubTotal + ")";
	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

// 修改操作
void CRecommendInfo::SqlUpdate(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置UPDATE语句
	CString strNum;
	strNum.Format("%ld", Num);
	CString strSubTotal;
	strSubTotal.Format("%lf", SubTotal);
	
	_bstr_t vSQL;
	vSQL = "UPDATE RecommendInfo SET Num = " + strNum + ", SubTotal = " + strSubTotal
		+ " WHERE RecommendId = " + paraId;
	
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 删除操作
void CRecommendInfo::SqlDelete(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM RecommendInfo WHERE RecommendId = " + paraId;
	
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}