client.cpp

本网站是一个库存管理系统

// Client.cpp: implementation of the CClient class.

#include "stdafx.h"
#include "Stock.h"
#include "Client.h"
#include "ADOConn.h"
#include "SysLog.h"

CClient::CClient() // Construction
{
	Cid = 0;
	Cname = "";
	Ctype = 0;
	Contact = "";
	Address = "";
	Postcode = "";
	Phone = "";
	Fax = "";
	Memo = "";
}

CClient::~CClient() // Destruction
{

}

/******************************************************************/
/*****************************变量操作*****************************/
/******************************************************************/

int CClient::GetCid() // 返回客户编号 
{
	return Cid;
}

void CClient::SetCid(int iCid) // 设置客户编号	
{
	Cid = iCid;
}

CString CClient::GetCname() // 返回客户名称
{
	return Cname;
}

void CClient::SetCname(CString cCname) // 设置客户名称 
{
	Cname = cCname;
}

int CClient::GetCtype() // 返回客户类型, 1-供应商、2-购货商
{
	return Ctype;
}

void CClient::SetCtype(int iCtype) // 设置客户类型, 1-供应商、2-购货商
{
	Ctype = iCtype;
}

CString CClient::GetContact() // 返回联系人
{
	return Contact;
}

void CClient::SetContact(CString cContact) // 设置联系人
{
	Contact = cContact;
}

CString CClient::GetAddress() // 返回通信地址
{
	return Address;
}

void CClient::SetAddress(CString cAddress) // 设置通信地址
{
	Address = cAddress;
}

CString CClient::GetPostcode() // 返回邮政编码
{
	return Postcode;
}

void CClient::SetPostcode(CString cPostcode) // 设置邮政编码
{
	Postcode = cPostcode;
}

CString CClient::GetPhone() // 返回联系电话
{
	return Phone;
}

void CClient::SetPhone(CString cPhone) // 设置联系电话
{
	Phone = cPhone;
}

CString CClient::GetFax() // 返回传真电话
{
	return Fax;
}

void CClient::SetFax(CString cFax) // 设置传真电话
{
	Fax = cFax;
}

CString CClient::GetMemo() // 返回备注信息
{
	return Memo;
}

void CClient::SetMemo(CString cMemo) // 设置备注信息
{
	Memo = cMemo;
}

/******************************************************************/
/****************************数据库操作****************************/
/******************************************************************/

int CClient::HaveName(CString cCname) // 判断指定的客户名是否在数据库中
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Client WHERE Cname='" + cCname + "'";
	// 执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	// 返回各列的值
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;	
	m_AdoConn.ExitConnect(); // 断开与数据库的连接
}

void CClient::sql_insert() // 插入新的客户记录 
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置INSERT语句
	CString strType;
	strType.Format("%d", Ctype);
	_bstr_t vSQL;
	vSQL = "INSERT INTO Client (Cname, Ctype, Contact, Address, Postcode, Phone, Fax, Memo) VALUES('"
		+ Cname + "'," + strType + ",'" + Contact + "','" + Address + "','" + Postcode + "','"
		+ Phone + "','" + Fax + "','" + Memo + "')";

	m_AdoConn.ExecuteSQL(vSQL);	// 执行INSERT语句	
	m_AdoConn.ExitConnect(); // 断开与数据库的连接

    // 保存日志
	CSysLog log;
	log.SetLogType(3);
	log.SetTitle("添加客户信息");
	log.SetBody("客户名称：" + Cname);
	log.sql_insert();
}	
	
void CClient::sql_update(CString cCid) // 修改指定的客户记录
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置INSERT语句
	CString strType;
	strType.Format("%d", Ctype);
	_bstr_t vSQL;
	vSQL = "UPDATE Client SET Cname='" + Cname + "', Ctype=" + strType + ", Contact='" 
		+ Contact + "', Address='" + Address + "', Postcode='" + Postcode + "', Phone='" 
		+ Phone + "', Fax='" + Fax + "', Memo='" + Memo + "' WHERE Cid=" + cCid;
	
	m_AdoConn.ExecuteSQL(vSQL);	// 执行INSERT语句	
	m_AdoConn.ExitConnect(); // 断开与数据库的连接

    // 保存日志
	CSysLog log;
	log.SetLogType(3);
	log.SetTitle("修改客户信息");
	log.SetBody("客户名称：" + Cname);
	log.sql_insert();

}	

void CClient::sql_delete(CString cCid) // 删除指定的客户记录
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Client WHERE Cid=" + cCid;	
	m_AdoConn.ExecuteSQL(vSQL);	// 执行DELETE语句
	m_AdoConn.ExitConnect(); // 断开与数据库的连接

    // 保存日志
	CSysLog log;
	log.SetLogType(3);
	log.SetTitle("删除客户信息");
	log.SetBody("客户名称：" + Cname);
	log.sql_insert();
}

void CClient::GetData(CString cCid) // 根据客户编号读取所有字段值
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Client WHERE Cid=" + cCid;
	// 执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	// 返回各列的值
	if (m_pRecordset->adoEOF)
		CClient();
	else
	{
		Cid = atoi(cCid);
		Cname = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Cname");
		Ctype = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Ctype"));
		Contact = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Contact");
		Address = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Address");
		Postcode = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Postcode");
		Phone = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Phone");
		Fax = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fax");
		Memo = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Memo");
	}
	m_AdoConn.ExitConnect(); // 断开与数据库的连接
}