customerinfo.cpp

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

// CustomerInfo.cpp: implementation of the CCustomerInfo class.
//
// 1 CustomerId int 客户编号 Identity = Yes Allow Null = False 主键
// 2 Name varchar(50) 客户姓名 Allow Null = False
// 3 Sex varchar(4) 性别 Allow Null = True
// 4 Company varchar(200) 所在单位 Allow Null = True
// 5 Mobile varchar(50) 手机 Allow Null = False
// 6 Home varchar(50) 家庭电话 Allow Null = True
// 7 Memo varchar(500) 备注 Allow Null = True
//////////////////////////////////////////////////////////////////////

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

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

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

CCustomerInfo::CCustomerInfo()
{
	CustomerId = 0;
	Name = "";
	Sex = "";
	Company = "";
	Mobile = "";
	Home = "";
	Memo = "";
}

CCustomerInfo::~CCustomerInfo()
{

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

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

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

	// 返回各列的值
	if(m_pRecordSet->adoEOF)
	{
		CCustomerInfo();
	}
	else
	{
		CustomerId = atoi(paraId);
		Name = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Name");
		Sex = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Sex");
		Company = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Company");
		Mobile = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Mobile");
		Home = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Home");
		Memo = (LPCTSTR)(_bstr_t)m_pRecordSet->GetCollect("Memo");
	}

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

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

	// 设置Insert语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO CustomerInfo(Name, Sex, Company, Mobile, Home, Memo)"
		" VALUES ('" + Name + "', '" + Sex + "', '" + Company + "', '" + Mobile
		+ "', '" + Home + "', '" + Memo + "')";

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

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

// 更新操作
void CCustomerInfo::SqlUpdate(CString paraId)
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	// 设置Update语句
	_bstr_t vSQL;
	vSQL = "UPDATE CustomerInfo SET Name = '" + Name + "', Sex = '" + Sex
		+ "', Company = '" + Company + "', Mobile = '" + Mobile + "', Home = '"
		+ Home + "', Memo = '" + Memo
		+ "' WHERE CustomerId = " + paraId;

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

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

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

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

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

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