stuffmanage.cpp

员工信息管理系统VC++源代码,可实现对实体对象的添加、修改、删除、查询等操作

// StuffManage.cpp: implementation of the CStuffManage class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "StuffSys.h"
#include "StuffManage.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
extern CDataManage m_DataManage;
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CStuffManage::CStuffManage()
{

}

CStuffManage::~CStuffManage()
{

}

//合法性检查
BOOL CStuffManage::ValidCheck(CStuff &stuff)
{
	if (stuff.GetKnowledge().IsEmpty() || stuff.GetSex().IsEmpty()
		|| stuff.GetName().IsEmpty()||stuff.GetWage()<0)
		return FALSE;
	else
		return TRUE;
}

//添加员工信息
BOOL CStuffManage::AddStuff(CStuff &stuff)
{
	CString sql;
	sql.Format("insert into tb_StuffInfo values (%i, '%s','%s','%s',%f)",stuff.GetID(),stuff.GetName(),
		stuff.GetSex(),stuff.GetKnowledge(),stuff.GetWage());
	try
	{
		m_DataManage.ExecOpt(sql);
		return TRUE;	
	}
	catch(...)
	{
		return FALSE;
	}
}
//初始化员工信息
void CStuffManage::IniStuff(CStuff &stuff)
{
	stuff.SetID(0);
	stuff.SetName("");
	stuff.SetKnowledge("");
	stuff.SetSex("");
	stuff.SetWage(0.0);
}

//修改员工信息
BOOL CStuffManage::UpdateStuff(CStuff &stuff,CStuff &oldstuff)
{
	CString sql;
	sql.Format("update tb_StuffInfo set id = %i, name = '%s',sex = '%s', knowledge = '%s',wage = %f where id = '%s'",stuff.GetID(),stuff.GetName(),
		stuff.GetSex(),stuff.GetKnowledge(),stuff.GetWage(),oldstuff.GetID());
	try
	{
		m_DataManage.ExecOpt(sql);
		return TRUE;	
	}
	catch(...)
	{
		return FALSE;
	}
}

//删除员工信息
BOOL CStuffManage::DeleteStuff(CStuff &stuff)
{
	CString sql;
	sql.Format("delete  tb_StuffInfo  where id = '%s'",stuff.GetID());
	try
	{
		m_DataManage.ExecOpt(sql);
		return TRUE;	
	}
	catch(...)
	{
		return FALSE;
	}
}

//查询员工信息
void CStuffManage::SelectStuff(_RecordsetPtr pRecord)
{
	pRecord = m_DataManage.ExecSelect("select * from tb_StuffInfo");
}