users.h

一个电视台专用的信息管理软件源代码

// Users.h: interface for the CUsers class.
//
//////////////////////////////////////////////////////////////////////
#include "ADOConn.h"
#if !defined(AFX_USERS_H__F5408496_F549_4538_A286_6B28D536A25E__INCLUDED_)
#define AFX_USERS_H__F5408496_F549_4538_A286_6B28D536A25E__INCLUDED_

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


class CUsers :public ADOConn 
{
private:
	long UID;
	CString LoginName;
	CString Pwd;
	CString Name;
	CString Sex;
	int RoleID;
	int ChannelID;
	int ColumnID;
public:
	CUsers();
	virtual ~CUsers();
	
	CString GetLoginName();
	CString GetPwd();	
	CString GetName();	
	CString GetSex();
	int GetRoleID();

	int GetChannelID();
	int GetColumnID();

	void SetUID(int iUID);
	int GetUID();
	void SetPwd(CString cPwd);
	void SetRoleID(int iRoleID);
	void SetLoginName(CString cUserName);
	void SetName(CString cName);
	void SetSex(CString cSex);

	void SetChannelID(int iChannelID);
	void SetColumnID(int iColumnID);

	//数据库操作
	void LogIn(long iUID,long& iFlg,CString& cMessage);
	void LogOut(long iUID,long& iFlg,CString& cMessage);
	void GetNames(CStringArray& allNames,CString strSQL="");
	void ShowList(CListCtrl& listctrl,CString strSQL="");
	int HaveLoginName(CString cUserName); //判断指定用户名是否存在
	void sql_insert(CString cLoginName,CString cPwd,CString cName,CString cSex,int iRoleID);  
	void sql_update(int iUID,CString cLoginName,CString cPwd,CString cName,CString cSex,int iRoleID);
	void sql_delete(long iUID,long& iFlg,CString& cMessage);
	void sql_query(CString cWhere);
	int getUIDByLoginName(CString loginName);
	int getIDByName(CString cName);
	//读取所有字段值
	void GetData(int iUID);
	void insert(CString cLoginName,CString cPwd,CString cName,CString cSex,long iRoleID,long iChannelID,long iColumnID,long& iFlg,CString& cMessage); 
	void update(long iUID,CString cLoginName,CString cPwd,CString cName,CString cSex,long iRoleID,long iChannelID,long iColumnID,long& iFlg,CString& cMessage); 
	void GetUsersInf(CStringArray& UsersInf);

};

#endif // !defined(AFX_USERS_H__F5408496_F549_4538_A286_6B28D536A25E__INCLUDED_)