departmentcommand.cpp

人事管理系统 帮助人力资源部对公司员工的级别信息进行维护及员工在各部门的调度

// DepartmentCommand.cpp: implementation of the CDepartmentCommand class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ERSDemo.h"
#include "DepartmentCommand.h"

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

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

CDepartmentCommand::CDepartmentCommand()
{

}

CDepartmentCommand::~CDepartmentCommand()
{

}

void CDepartmentCommand::InsertDepartment(CString DepartmentName)
{
	CString SQL;
	SQL = "Insert Into Department(Name) Values(\"" + DepartmentName + "\")";
	ExecuteSQL(SQL);
}

void CDepartmentCommand::RenameDepartment(CString NewName, int ID)
{
	CString SQL;
	SQL.Format("Update Department Set Name = \"" + NewName + "\" Where ID = %d", ID);
	ExecuteSQL(SQL);	
}