users.cpp

本网站是一个库存管理系统

// Users.cpp: implementation of the CUsers class.

#include "stdafx.h"
#include "Stock.h"
#include "Users.h"
#include "ADOConn.h"
#include "SysLog.h"

CUsers::CUsers() // Construction
{
	UserName = "";
	Pwd = "";
	User_type = 0;
}

CUsers::~CUsers() // Destruction
{

}

/**********************************************************************/
/*****************************成员变量操作*****************************/
/**********************************************************************/

CString CUsers::GetUserName()  // 返回用户名
{
	return UserName;
}

void CUsers::SetUserName(CString cUserName) // 设置用户名
{
	UserName = cUserName;
}

CString CUsers::GetPwd() // 返回密码
{
	return Pwd;
}

void CUsers::SetPwd(CString cPwd) // 设置密码
{
	Pwd = cPwd;
}

int CUsers::GetUser_type() // 返回用户类型
{
	return User_type;
}

void CUsers::SetUser_type(int iUser_type) // 设置用户类型
{
	User_type = iUser_type;
}

/**********************************************************************/
/*******************************数据库操作*****************************/
/**********************************************************************/

int CUsers::HaveName(CString cUserName) // 判断指定用户名是否存在
{	
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Users WHERE UserName collate Chinese_PRC_CS_AI_WS ='" + cUserName + "'";
	
	// 执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	m_AdoConn.ExitConnect(); // 断开与数据库的连接
}

	
void CUsers::sql_insert() // 插入新的用户记录
{	
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置INSERT语句
	CString strType;
	strType.Format("%d", User_type);

	_bstr_t vSQL;
	vSQL = "INSERT INTO Users VALUES('" + UserName + "','" + Pwd + "'," 
		+ strType + ")";	
	m_AdoConn.ExecuteSQL(vSQL);	// 执行INSERT语句
	m_AdoConn.ExitConnect(); // 断开与数据库的连接

	//保存日志
	CSysLog log;
	log.SetLogType(2);
	log.SetTitle("添加用户信息");
	log.SetBody("用户名称: "+UserName);
	log.sql_insert();
}

void CUsers::sql_updatePwd(CString cUserName) // 修改指定的用户记录
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置UPDATE语句
	CString strType;
	strType.Format("%d", User_type);

	_bstr_t vSQL;
	vSQL = "UPDATE Users SET Pwd='" + Pwd + "' WHERE UserName collate Chinese_PRC_CS_AI_WS ='" + cUserName + "'";
	m_AdoConn.ExecuteSQL(vSQL);	// 执行UPDATE语句
	m_AdoConn.ExitConnect(); // 断开与数据库的连接

	//保存日志
	CSysLog log;
	log.SetLogType(2);
	log.SetTitle("修改用户密码");
	log.SetBody("用户名称:" + cUserName);
	log.sql_insert();
}

void CUsers::sql_delete(CString cUserName) // 删除指定的用户记录
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Users WHERE UserName collate Chinese_PRC_CS_AI_WS ='" + cUserName	+ "'";
	m_AdoConn.ExecuteSQL(vSQL);	// 执行DELETE语句
	m_AdoConn.ExitConnect(); // 断开与数据库的连接

	//保存日志
	CSysLog log;
	log.SetLogType(2);
	log.SetTitle("删除用户信息");
	log.SetBody("用户名称:" + cUserName);
	log.sql_insert();
}

void CUsers::GetData(CString cUserName) // 根据员工编号读取所有字段值
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Users WHERE UserName collate Chinese_PRC_CS_AI_WS ='" + cUserName + "'";
	// 执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	// 返回各列的值
	if (m_pRecordset->adoEOF)
		CUsers();
	else
	{
		UserName = cUserName;
		Pwd = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pwd");
		User_type = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("User_type"));
	}
	m_AdoConn.ExitConnect(); // 断开与数据库的连接
}