// 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()
{
	m_DeptId = 0;
	m_DeptName = "";
}

CDepartments::~CDepartments()
{

}

void CDepartments::SetDeptId(int iDeptId)
{
	m_DeptId = iDeptId;
}

int CDepartments::GetDeptId()
{
	return m_DeptId;
}

void CDepartments::SetDeptName(CString cDeptName)
{
	m_DeptName = cDeptName;
}

CString CDepartments::GetDeptName()
{
	return m_DeptName;
}

// ******插入部門信息*******//
void CDepartments::Insert()
{
	try
	{
		//連接數據庫
		ADOConn adoConn;
		_bstr_t bSQL;
		bSQL = "Insert Into Departments (DeptName) Values('" 
			+ m_DeptName + "')";
		adoConn.ExecuteSQL(bSQL);
		//斷開與數據庫的連接
		adoConn.ExitConnect();
	}
	// 捕捉異常
	catch(_com_error e)
	{
		// 顯示錯誤信息
		AfxMessageBox(e.Description());
	}
}

// ******更新部門信息*******//
void CDepartments::Update(CString cDeptId)
{
	try
	{
		//連接數據庫
		ADOConn adoConn;
		_bstr_t bSQL;
		bSQL = "Update Departments Set DeptName='" + 
			m_DeptName + "' Where DeptId=" + cDeptId;
		adoConn.ExecuteSQL(bSQL);
		//斷開與數據庫的連接
		adoConn.ExitConnect();
	}
	// 捕捉異常
	catch(_com_error e)
	{
		// 顯示錯誤信息
		AfxMessageBox(e.Description());
	}
}

// ******刪除部門信息*******//
void CDepartments::Delete(CString cDeptId)
{
	try
	{
		//連接數據庫
		ADOConn adoConn;
		_bstr_t bSQL;
		bSQL = "Delete From Departments Where DeptId=" + cDeptId;
		adoConn.ExecuteSQL(bSQL);
		//斷開與數據庫的連接
		adoConn.ExitConnect();
	}
	// 捕捉異常
	catch(_com_error e)
	{
		// 顯示錯誤信息
		AfxMessageBox(e.Description());
	}
}

// ******判斷是否存在指定的部門名稱*******//
int CDepartments::HaveName(CString cDeptName)
{
	int iRet = -1;
	try
	{
		_RecordsetPtr pRecordset;
		// 連接數據庫
		ADOConn adoConn;
		_bstr_t bSQL;
		bSQL = "Select * From Departments Where DeptName='" + cDeptName + "'";
		// 執行SELETE語句
		pRecordset = adoConn.GetRecordSet(bSQL);
		// 如果adoEOF屬性為真，表示存在相同名稱的部門信息，返回1，否則返回-1
		if (pRecordset->adoEOF)
			iRet = -1;
		else
			iRet = 1;
		//斷開與數據庫的連接
		adoConn.ExitConnect();
	}
	// 捕捉異常
	catch(_com_error e)
	{
		iRet = -1;
		// 顯示錯誤信息
		AfxMessageBox(e.Description());
	}
	return iRet;
}