material.cpp

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

// Material.cpp: implementation of the CMaterial class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CMaterial::CMaterial()
{
	MId = 0;
	MName = "";
	MUnit = "";
	MStyle = "";
	MQuality = "";
	MCarType = "";
	MPrice = 0.0;
}

CMaterial::~CMaterial()
{

}

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

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

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

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CMaterial();
	else
	{
		MId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MId"));
		MName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MName");
		MUnit = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MUnit");
		MStyle = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MStyle");
		MQuality = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MQuality");
		MCarType = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MCarType");
		MPrice = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MPrice"));
	}

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

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

	//设置INSERT语句
	CString fPrice;
	fPrice.Format("%f", MPrice);
	_bstr_t vSQL;
	vSQL = "INSERT INTO Material VALUES('" + MName + "','" + MUnit + "','" 
		+ MStyle + "','" + MQuality + "','" + MCarType + "'," + fPrice + ")";

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

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

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

	//设置UPDATE语句
	CString fPrice;
	fPrice.Format("%f", MPrice);
	
	_bstr_t vSQL;
	vSQL = "UPDATE Material SET MName='" + MName + "', MUnit='" + MUnit
		+ "', MStyle='" + MStyle + "', MQuality='" + MQuality
		+ "', MCarType='" + MCarType + "', MPrice=" + fPrice
		+ " WHERE MId = " + paraId;

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

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

// 删除指定材料信息
void CMaterial::SqlDelete(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Material WHERE MId = " + paraId;

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

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