departments.cpp

这是一个功能相对完善的固定资产管理系统的例子

// Departments.cpp: implementation of the CDepartmentss class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "AssetsMan.h"
#include "Departments.h"
#include "ADOConn.h"

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

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

CDepartments::CDepartments()
{
	DepId = 0;
	DepName = "";
}

CDepartments::~CDepartments()
{

}
// ******插入部门信息*******//
void CDepartments::sql_Insert()
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		bSQL = "Insert Into Departments (DepName) Values('" + DepName + "')";
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}
// ******更新部门信息*******//
void CDepartments::sql_Update(CString cDepId)
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		bSQL = "Update Departments Set DepName='" + DepName + "' Where DepId=" + cDepId;
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}
// ******删除部门信息*******//
void CDepartments::sql_Delete(CString cDepId)
{
	try
	{
		//连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		bSQL = "Delete From Departments Where DepId=" + cDepId;
		m_AdoConn.ExecuteSQL(bSQL);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}

// ******判断是否存在指定的部门名称*******//
int CDepartments::HaveName(CString cDepName)
{
	try
	{
		long lRscnt = 0;
		_RecordsetPtr m_pRecordset;
		// 连接数据库
		ADOConn m_AdoConn;
		_bstr_t bSQL;
		bSQL = "Select * From Departments Where DepName='" + cDepName + "'";
		// 执行SELETE语句
		m_pRecordset = m_AdoConn.GetRecordSet(bSQL);
		// 如果adoEOF属性为真，表示存在相同名称的部门信息，返回1，否则返回-1
		if (m_pRecordset->adoEOF)
			return -1;
		else
			return 1;
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
	return -1;
}