providerinfo.cpp

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

// ProviderInfo.cpp: implementation of the CProviderInfo class.
//
// 1 ProviderId int 供应商编号 Identity = Yes Allow Null = False 主键
// 2 Name varchar(50) 供应商名称 Allow Null = False
// 3 Address varchar(500) 联系地址 Allow Null = True
// 4 Tel varchar(500) 联系电话 Allow Null = True
// 5 Email varchar(50) E-mail Allow Null = True
// 6 Site varchar(50) 网站 Allow Null = True
// 7 Linkman varchar(50) 联系人 Allow Null = True
// 8 Memo varchar(500) 备注 Allow Null = True
//////////////////////////////////////////////////////////////////////

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

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

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

CProviderInfo::CProviderInfo()
{
	ProviderId = 0;
	Name = "";
	Address = "";
	Tel = "";
	Email = "";
	Site = "";
	Linkman = "";
	Memo = "";
}

CProviderInfo::~CProviderInfo()
{

}
// 根据供应商编号得到其他信息
void CProviderInfo::GetInfo(CString paraId)
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	// 设置Select语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM ProviderInfo WHERE ProviderId = " + paraId;

	// 执行SQL语句
	_RecordsetPtr m_pRecordSet;
	m_pRecordSet = m_AdoConn.GetRecordSet(vSQL);

	// 返回各列的值
	if(m_pRecordSet->adoEOF)
	{
		CProviderInfo();
	}
	else
	{
		ProviderId = atoi(paraId);
		Name = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Name");
		Address = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Address");
		Tel = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Tel");
		Email = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Email");
		Site = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Site");
		Linkman = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Linkman");
		Memo = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Memo");
	}

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

// 插入操作
void CProviderInfo::SqlInsert()
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	// 设置Insert语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO ProviderInfo(Name, Address, Tel, Email, Site, Linkman, Memo)"
		" VALUES ('" + Name + "', '" + Address + "', '" + Tel + "', '" + Email
		+ "', '" + Site + "', '" + Linkman + "', '" + Memo + "')";

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

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

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

	// 设置Update语句
	_bstr_t vSQL;
	vSQL = "UPDATE ProviderInfo SET Name = '" + Name + "', Address = '" + Address
		+ "', Tel = '" + Tel + "', Email = '" + Email + "', Site = '"
		+ Site + "', Linkman = '" + Linkman + "', Memo = '" + Memo
		+ "' WHERE ProviderId = " + paraId;

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

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

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

	// 设置Delete语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM ProviderInfo WHERE ProviderId = " + paraId;

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

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