bumen.cpp

企业之间的竞争主要体现在三个方面：产品市场的竞争、资金市场的竞争和人才市场的竞争。在网络经济的环境下

/*********************************************************************/

#include "stdafx.h"
#include "../Renshi.h"
#include "Bumen.h"

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



/*********************************************************************/
extern CRenshiApp theApp;
/*********************************************************************/

CBumen::CBumen()
{
	m_BumenID = 0;
	m_BumenName = "";
	m_Describe = "";
	m_UpperID = 0;
}

CBumen::~CBumen()
{

}

//读取和设置成员变量
int CBumen::GetBumenID()
{
	return m_BumenID;
}

void CBumen::SetBumenID(int im_BumenID)
{
	m_BumenID = im_BumenID;
}

CString CBumen::GetBumenName()
{
	return m_BumenName;
}

void CBumen::SetBumenName(CString cBumenName)
{
	m_BumenName = cBumenName;
}

CString CBumen::GetDescribe()
{
	return m_Describe;
}

void CBumen::SetDescribe(CString cDescribe)
{
	m_Describe = cDescribe;
}

int CBumen::GetUpperID()
{
	return m_UpperID;
}

void CBumen::SetUpperID(int iUpperID)
{
	m_UpperID = iUpperID;
}



/*********************************************************************/
//判断指定名称的部门是否存在(用于插入模块中)
BOOL CBumen::HaveName(CString cBumenName)
{	
	_RecordsetPtr pRS = theApp.m_ado.GetRS("SELECT * FROM Bumen WHERE BumenName='" + cBumenName + "'");

	if (pRS->adoEOF)
		return false;
	else
		return true;
}


//根据部门ID判断该部门下是否有子部门(用于删除模块中)
BOOL CBumen::HaveSon(CString cBumenID)
{
	_RecordsetPtr pRS = theApp.m_ado.GetRS("SELECT * FROM Bumen WHERE UpperID=" + cBumenID);

	if (pRS->adoEOF)
		return false;
	else
		return true;

}

//判断指定的部门下是否有员工
BOOL CBumen::HaveYg(CString cBumenID)
{
	_RecordsetPtr pRS = theApp.m_ado.GetRS("SELECT * FROM Yuangong WHERE BumenID=" + cBumenID);
	
	if (pRS->adoEOF)
		return false;
	else
		return true;
}


//加载部门信息到字符串数组中
void CBumen::LoadBumenInfo()
{	
	_RecordsetPtr pRS = theApp.m_ado.GetRS("SELECT * FROM Bumen ORDER BY UpperID");

	//初始化数组
	a_BumenName.RemoveAll();
	a_BumenID.RemoveAll();
	a_UpperID.RemoveAll();

	//执行SELECT语句
	while (pRS->adoEOF == 0)
	{
		a_BumenID.Add(  (LPCTSTR)(_bstr_t)pRS->GetCollect("BumenID"));
		a_BumenName.Add((LPCTSTR)(_bstr_t)pRS->GetCollect("BumenName"));
		a_UpperID.Add(  (LPCTSTR)(_bstr_t)pRS->GetCollect("UpperID"));
		
		pRS->MoveNext();
	}
}


long CBumen::sql_insert()
{	
	CString strUpperID;
	strUpperID.Format("%d", m_UpperID);

	theApp.m_ado.Execute("INSERT INTO Bumen (BumenName, Describe, UpperID) VALUES('" + m_BumenName + "','" + m_Describe + "'," + strUpperID + ")");	

	//获取刚才插入的部门信息中的BumenID值(数据库中BumenID字段是自动增加的)
	long lBumenID;
	_RecordsetPtr pRS = theApp.m_ado.GetRS("SELECT MAX(BumenID) AS MaxID FROM Bumen");

	if (pRS->adoEOF)
		lBumenID = 0;
	else 
		lBumenID = atol((LPCTSTR)(_bstr_t)pRS->GetCollect("MaxID"));

	return lBumenID;
}

void CBumen::sql_update(CString cBumenID)
{
	theApp.m_ado.Execute("UPDATE Bumen SET BumenName='" + m_BumenName + "', Describe='" + m_Describe +"' WHERE BumenID=" + cBumenID);	
}

void CBumen::sql_delete(CString cBumenID)
{
	theApp.m_ado.Execute("DELETE FROM Bumen WHERE BumenID=" + cBumenID);	
}

//根据员工编号读取所有字段值
void CBumen::GetData(CString cBumenID)
{
	_RecordsetPtr pRS = theApp.m_ado.GetRS("SELECT * FROM Bumen WHERE BumenID=" + cBumenID);

	//返回各列的值
	if (pRS->adoEOF)
	{
		CBumen();
	}
	else
	{
		m_BumenID = atoi(cBumenID);
		m_BumenName =		(LPCTSTR)(_bstr_t)pRS->GetCollect("BumenName");
		m_Describe =		(LPCTSTR)(_bstr_t)pRS->GetCollect("Describe");
		m_UpperID = atoi( (LPCTSTR)(_bstr_t)pRS->GetCollect("UpperID"));
	}
}