privilege.cpp

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

// Privilege.cpp: implementation of the Privilege class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CPrivilege::CPrivilege()
{
	UserName = "";
	privBackup = 0;
	privCheckMan = 0;
	privClient = 0;
	privProduct = 0;
	privProType = 0;
	privRestore = 0;
	privStock = 0;
	privStockIn = 0;
	privStockOut = 0;
}

CPrivilege::~CPrivilege()
{

}

CString CPrivilege::GetUserName()
{
	return UserName;
}

void CPrivilege::SetUserName(CString cUserName)
{
	UserName = cUserName;
}

int CPrivilege::GetprivClient()
{
	return privClient;
}

void CPrivilege::SetprivClient(int iprivClient)
{
	privClient = iprivClient;
}

int CPrivilege::GetprivStock()
{
	return privStock;
}

void CPrivilege::SetprivStock(int iprivStock)
{
	privStock = iprivStock;
}

int CPrivilege::GetprivProType()
{
	return privProType;
}

void CPrivilege::SetprivProType(int iprivProType)
{
	privProType = iprivProType;
}

int CPrivilege::GetprivProduct()
{
	return privProduct;
}

void CPrivilege::SetprivProduct(int iprivProduct)
{
	privProduct = iprivProduct;
}

int CPrivilege::GetprivStockIn()
{
	return privStockIn;
}

void CPrivilege::SetprivStockIn(int iprivStockIn)
{
	privStockIn = iprivStockIn;
}

int CPrivilege::GetprivStockOut()
{
	return privStockOut;
}

void CPrivilege::SetprivStockOut(int iprivStockOut)
{
	privStockOut = iprivStockOut;
}

int CPrivilege::GetprivCheckMan()
{
	return privCheckMan;
}

void CPrivilege::SetprivCheckMan(int iprivCheckMan)
{
	privCheckMan = iprivCheckMan;
}

int CPrivilege::GetprivBackup()
{
	return privBackup;
}

void CPrivilege::SetprivBackup(int iprivBackup)
{
	privBackup = iprivBackup;
}

int CPrivilege::GetprivRestore()
{
	return privRestore;
}

void CPrivilege::SetprivRestore(int iprivRestore)
{
	privRestore = iprivRestore;
}

//数据库操作
void CPrivilege::sql_insert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strClient, \
		    strStock, \
			strProType, \
			strProduct, \
			strStockIn, \
			strStockOut, \
			strCheckMan, \
			strBackup, \
			strRestore;
	strClient.Format("%d", privClient);
	strStock.Format("%d", privStock);
	strProType.Format("%d", privProType);
	strProduct.Format("%d", privProduct);
	strStockIn.Format("%d", privStockIn);
	strStockOut.Format("%d", privStockOut);
	strCheckMan.Format("%d", privCheckMan);
	strBackup.Format("%d", privBackup);
	strRestore.Format("%d", privRestore);

	_bstr_t vSQL;
	vSQL = "INSERT INTO Privilege VALUES('" + UserName + "',\
		                                 " + strClient + ",\
										 " + strStock + ",\
										 " + strProType + ",\
										 " + strProduct + ",\
										 " + strStockIn + ",\
										 " + strStockOut + ",\
										 " + strCheckMan + ",\
										 " + strBackup + ",\
										 " + strRestore + ")";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

	// 保存日志
	CSysLog log;
	log.SetLogType(5);
	log.SetTitle("修改用户权限");
	log.SetBody("用户名称：" + UserName);
	log.sql_insert();
}

void  CPrivilege::sql_delete(CString cUserName)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Privilege WHERE UserName='" + cUserName + "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

	// 保存日志
	CSysLog log;
	log.SetLogType(5);
	log.SetTitle("删除用户权限");
	log.SetBody("用户名称：" + UserName);
	log.sql_insert();
}

void  CPrivilege::GetData(CString cUserName)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Privilege WHERE UserName='" + cUserName + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CPrivilege();
	else
	{
		UserName = cUserName;
		privClient = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privClient"));
		privStock = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privStock"));
		privProType = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privProType"));
		privProduct = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privProduct"));
		privStockIn = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privStockIn"));
		privStockOut = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privStockOut"));
		privCheckMan = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privCheckMan"));
		privBackup = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privBackup"));
		privRestore = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("privRestore"));
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}