fittinginfo.cpp

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

// FittingInfo.cpp: implementation of the CFittingInfo class.
//
// 1 FittingId int 配件序号 Identity = Yes Allow Null = False 主键
// 2 TypeId int 类型编号 Allow Null = False
// 3 MarkId int 品牌编号 Allow Null = False
// 4 Std varchar(200) 型号规格 Allow Null = False
// 5 Productor varchar(200) 厂商 Allow Null = False
// 6 UnitPrice float 单价 Allow Null = False
// 7 InPrice float 进价 Allow Null = False
// 8 Maintain varchar(50) 保修期 Allow Null = False
// 9 ProviderId int 供应商编号 Allow Null = True
//////////////////////////////////////////////////////////////////////

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

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

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

CFittingInfo::CFittingInfo()
{
	FittingId = 0;
	TypeId = 0;
	MarkId = 0;
	Std = "";
	Productor = "";
	UnitPrice = 0;
	InPrice = 0;
	Maintain = "";
	ProviderId = 0;
}

CFittingInfo::~CFittingInfo()
{

}

// 判断在推荐表中是否存在某配件编号
int CFittingInfo::HaveRecFit(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM RecommendInfo WHERE FittingId = " + paraId;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 判断在详单表中是否存在某配件编号
int CFittingInfo::HaveDetFit(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM DetailQuote WHERE FittingId = " + paraId;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
// 判断是否存在供应商编号
int CFittingInfo::HaveProvider(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM FittingInfo WHERE ProviderId = " + paraId;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
// 判断是否存在类型（品牌）编号
int CFittingInfo::HaveTypeId(CString paraTId,int iFlag)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置SELECT语句
	_bstr_t vSQL;
	if (iFlag == 0)
		vSQL = "SELECT * FROM FittingInfo WHERE TypeId = " + paraTId;
	else
		vSQL = "SELECT * FROM FittingInfo WHERE MarkId = " + paraTId;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 根据配件序号得到其他信息
void CFittingInfo::GetInfo(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

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

	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	
	//返回各列的值
	if (m_pRecordset->adoEOF)
		CFittingInfo();
	else
	{
		FittingId = atol(paraId);
		TypeId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TypeId"));
		MarkId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MarkId"));
		Std = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Std");
		Productor = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Productor");
		UnitPrice = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UnitPrice"));
		InPrice = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("InPrice"));
		Maintain = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Maintain");
		ProviderId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ProviderId"));
	}

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

	//设置INSERT语句
	CString strTypeId;
	strTypeId.Format("%ld", TypeId);
	CString strMarkId;
	strMarkId.Format("%ld", MarkId);
	CString strUnitPrice;
	strUnitPrice.Format("%f", UnitPrice);
	CString strInPrice;
	strInPrice.Format("%f", InPrice);
	CString strProviderId;
	strProviderId.Format("%ld", ProviderId);

	_bstr_t vSQL;
	vSQL = "INSERT INTO FittingInfo (TypeId, MarkId, Std,"
		" Productor, UnitPrice, InPrice, Maintain, ProviderId) VALUES ("
		+ strTypeId + "," + strMarkId + ", '" + Std + "', '" 
		+ Productor + "', " + strUnitPrice + ", " + strInPrice 
		+ ", '" + Maintain + "', " + strProviderId + ")";

	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

// 修改操作
void CFittingInfo::SqlUpdate(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置UPDATE语句
	CString strTypeId;
	strTypeId.Format("%ld", TypeId);
	CString strMarkId;
	strMarkId.Format("%ld", MarkId);
	CString strUnitPrice;
	strUnitPrice.Format("%f", UnitPrice);
	CString strInPrice;
	strInPrice.Format("%f", InPrice);
	CString strProviderId;
	strProviderId.Format("%ld", ProviderId);
	
	_bstr_t vSQL;
	vSQL = "UPDATE FittingInfo SET TypeId = " + strTypeId + ",MarkId = " + strMarkId
		+ ", Std = '" + Std + "', Productor = '" + Productor
		+ "', UnitPrice = " + strUnitPrice + ", InPrice = " + strInPrice
		+ ", Maintain = '" + Maintain + "', ProviderId = " + strProviderId
		+ " WHERE FittingId = " + paraId;

	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

// 删除操作
void CFittingInfo::SqlDelete(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM FittingInfo WHERE FittingId = " + paraId;

	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	

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