users.h

This a integrated human resource manage system ,developed with vc++ and sql2000 Server

// Users.h: interface for the CUsers class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_USERS_H__451F3215_5B38_48AF_8D6D_A4361016F23E__INCLUDED_)
#define AFX_USERS_H__451F3215_5B38_48AF_8D6D_A4361016F23E__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CUsers  
{
public:	
	CString UserName; //用户名
	long EmpId;  //员工编号
	CString UserPwd;	//密码
	CString UserType;//用户类型
	//用户类型为：系统管理员、普通用户
public:
	CUsers();
	virtual ~CUsers();

public:	
	//数据库操作
	void sql_insert();  
	void sql_update(CString cUserName);
	void sql_delete(CString cUserName);
	void sql_updatePassword(CString cUserName);
	//读取所有字段值
	void GetData(CString cUserName);
	//判断指定用户名是否存在
	bool HaveRecord(CString cUserName);
	//判断指定员工是否存在用户名
	bool EmpIn_DB(CString cEmpId);
	//将用户密码初始化为111111
	void ResetPassword(CString cUserName);
	//根据用户名取得此员工的姓名
	CString GetEmpName(CString cUserName);
	//根据用户名取得此员工的部门名称
	CString GetDepName(CString cUserName);
};

#endif // !defined(AFX_USERS_H__451F3215_5B38_48AF_8D6D_A4361016F23E__INCLUDED_)