items.cpp

VC++做的汽车维修管理系统,很有参考价值的,附上源码与说明文档.

// Items.cpp: implementation of the CItems class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "CarService.h"
#include "Items.h"
#include "ADOConn.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
// 1 IteItemId int 项目编号 自动增一
// 2 IteItemName varchar(50) 项目名称
// 3 ItemType varchar(50) 项目工种
// 4 IteItemType char(10)  计量单位
// 5 CarType varchar(50) 适用的汽车型号
// 6 ItemCost float  费用金额
// 7 ItemLimited  char(10) 保修期限
// 8 Memo varchar(400)  备注
CItems::CItems()
{
	ItemId = 0;
	ItemName = "";
	ItemType = "";
	ItemUnit = "";
	CarType = "";
	ItemCost = 0.0;
	ItemLimited = "";
	Memo = "";
}

CItems::~CItems()
{

}

// 判断指定的项目名称是否存在
int CItems::HaveName(CString paraName)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Items WHERE ItemName = '" + paraName + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

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

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

	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CItems();
	else
	{
		ItemId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemId"));
		ItemName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemName");
		ItemType = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemType");
		ItemUnit = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemUnit");
		CarType = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("CarType");
		ItemCost = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemCost"));
		ItemLimited = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemLimited");
		Memo = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Memo");
	}

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

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

	//设置INSERT语句
	CString fCost;
	fCost.Format("%lf", ItemCost);
	_bstr_t vSQL;
	vSQL = "INSERT INTO Items VALUES('" + ItemName + "','" + ItemType + "','" 
		+ ItemUnit + "','" + CarType + "'," + fCost + ",'" + ItemLimited + "','"
		+ Memo + "')";

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

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

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

	//设置UPDATE语句
	CString fCost;
	fCost.Format("%lf", ItemCost);
	
	_bstr_t vSQL;
	vSQL = "UPDATE Items SET ItemName='" + ItemName + "', ItemType='" + ItemType
		+ "', ItemUnit='" + ItemUnit + "', CarType='" + CarType
		+ "', ItemLimited='" + ItemLimited + "', ItemCost=" + fCost
		+ ",Memo='" + Memo + "' WHERE ItemId = " + paraId;

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

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

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

	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Items WHERE ItemId = " + paraId;

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

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