changepowerdlg.cpp

本售货管理系统用vc和sql开发

// ChangePowerDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "ChangePowerDlg.h"

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

extern CDatabase m_database;
extern CString username;
extern CString userpower;
CString m_type;

/////////////////////////////////////////////////////////////////////////////
// CChangePowerDlg dialog


CChangePowerDlg::CChangePowerDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CChangePowerDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChangePowerDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CChangePowerDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangePowerDlg)
	DDX_Control(pDX, IDC_CCHECK10, m_log);
	DDX_Control(pDX, IDC_CCHECK9, m_datamanage);
	DDX_Control(pDX, IDC_CCHECK8, m_statrecord);
	DDX_Control(pDX, IDC_CCHECK7, m_delrecord);
	DDX_Control(pDX, IDC_CCHECK6, m_sell);
	DDX_Control(pDX, IDC_CCHECK5, m_changegoodmess);
	DDX_Control(pDX, IDC_CCHECK4, m_changegoodtype);
	DDX_Control(pDX, IDC_CCHECK3, m_changepower);
	DDX_Control(pDX, IDC_CCHECK2, m_changepassword);
	DDX_Control(pDX, IDC_CCHECK1, m_changeuser);
	DDX_Control(pDX, IDC_POWERCOMBO, m_powercombo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChangePowerDlg, CDialog)
	//{{AFX_MSG_MAP(CChangePowerDlg)
	ON_BN_CLICKED(IDCHANGEPOWER, OnChangepower)
	ON_CBN_SELCHANGE(IDC_POWERCOMBO, OnSelchangePowercombo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChangePowerDlg message handlers

BOOL CChangePowerDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CPowerSet m_powerset;
	m_powerset.m_pDatabase=&m_database;
	CString sql;	
	sql.Format("select * from 用户权限表");
	m_powerset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(m_powerset.IsEOF()){
		MessageBox("没有权限可修改");
		CDialog::OnOK();
	}else{
		int i=0;
		while(!m_powerset.IsEOF()){
			CString str;
			str=m_powerset.m_column1;
			str.TrimRight();
			str.TrimLeft();
			m_powercombo.InsertString(i,str);
			i++;
			m_powerset.MoveNext();
		}
		m_powercombo.SetCurSel(0);
		m_powercombo.GetLBText(0,m_type);
	}

	m_powerset.Close();
	sql.Format("select * from 用户权限表 where 权限名='%s'",userpower);
	m_powerset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(!m_powerset.IsEOF()){
		if(m_powerset.m_column2!=1){
			m_changeuser.EnableWindow(FALSE);
		}
		if(m_powerset.m_column3!=1){
			m_changepassword.EnableWindow(FALSE);
		}
		if(m_powerset.m_column4!=1){
			m_changepower.EnableWindow(FALSE);
		}
		if(m_powerset.m_column10!=1){
			m_changegoodtype.EnableWindow(FALSE);
		}
		if(m_powerset.m_column11!=1){
			m_changegoodmess.EnableWindow(FALSE);
		}
		if(m_powerset.m_column5!=1){
			m_sell.EnableWindow(FALSE);
		}
		if(m_powerset.m_column6!=1){
			m_delrecord.EnableWindow(FALSE);
		}
		if(m_powerset.m_column7!=1){
			m_statrecord.EnableWindow(FALSE);
		}
		if(m_powerset.m_column8!=1){
			m_datamanage.EnableWindow(FALSE);
		}
		if(m_powerset.m_column9!=1){
			m_log.EnableWindow(FALSE);
		}
	//	m_powerset.MoveNext();
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CChangePowerDlg::OnChangepower() 
{
	CPowerSet m_powerset;
	m_powerset.m_pDatabase=&m_database;
	CString sql;
	sql.Format("select * from 用户权限表 where 权限名='%s'",userpower);
	m_powerset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(m_type==userpower){
		MessageBox("不能修改自身权限");
	}else{	
		sql.Format("update 用户权限表 set ");
		if(m_powerset.m_column2==1){
			if(m_changeuser.GetCheck())
				sql=sql+"更新用户资料='1',";
			else
				sql=sql+"更新用户资料='0',";
		}
		if(m_powerset.m_column3==1){
			if(m_changepassword.GetCheck())
				sql=sql+"修改用户密码='1',";
			else
				sql=sql+"修改用户密码='0',";
		}
		if(m_powerset.m_column4==1){
			if(m_changepower.GetCheck())
				sql=sql+"更新权限资料='1',";
			else
				sql=sql+"更新权限资料='0',";
		}
		if(m_powerset.m_column5==1){
			if(m_sell.GetCheck())
				sql=sql+"售货操作='1',";
			else
				sql=sql+"售货操作='0',";
		}
		if(m_powerset.m_column6==1){
			if(m_delrecord.GetCheck())
				sql=sql+"删除售货记录='1',";
			else
				sql=sql+"删除售货记录='0',";
		}
		if(m_powerset.m_column7==1){
			if(m_statrecord.GetCheck())
				sql=sql+"统计售货记录='1',";
			else
				sql=sql+"统计售货记录='0',";
		}
		if(m_powerset.m_column8==1){
			if(m_delrecord.GetCheck())
				sql=sql+"数据库管理='1',";
			else
				sql=sql+"数据库管理='0',";
		}
		if(m_powerset.m_column9==1){
			if(m_datamanage.GetCheck())
				sql=sql+"日志删除='1',";
			else
				sql=sql+"日志删除='0',";
		}
		if(m_powerset.m_column10==1){
			if(m_changegoodtype.GetCheck())
				sql=sql+"更新商品类型='1',";
			else
				sql=sql+"更新商品类型='0',";
		}
		if(m_powerset.m_column11==1){
			if(m_changegoodmess.GetCheck())
				sql=sql+"更新商品资料='1',";
			else
				sql=sql+"更新商品资料='0',";
		}
		char temp[200];
		strcpy(temp,sql);
		temp[strlen(temp)-1]='\0';
		sql.Format("%s  where 权限名='%s'",temp,m_type);
 		AfxMessageBox(sql);
		try{
			m_database.ExecuteSQL(sql);
		}catch(CDBException e1){
			AfxMessageBox("数据库操作失败");
		}
		catch(CMemoryException e2){
			AfxMessageBox("数据库操作失败");
		}
		m_powerset.Close();
	}
}

void CChangePowerDlg::OnSelchangePowercombo() 
{
	CString sql;
	CPowerSet m_powerset;
	m_powerset.m_pDatabase=&m_database;
	m_powercombo.GetLBText(m_powercombo.GetCurSel(),m_type);
	m_powerset.Close();
	sql.Format("select * from 用户权限表 where 权限名='%s'",m_type);
	m_powerset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(!m_powerset.IsEOF()){
		if(m_powerset.m_column2!=1){
			m_changeuser.SetCheck(FALSE);
		}else{
			m_changeuser.SetCheck(TRUE);
		}
		if(m_powerset.m_column3!=1){
			m_changepassword.SetCheck(FALSE);
		}else{
			m_changepassword.SetCheck(TRUE);
		}
		if(m_powerset.m_column4!=1){
			m_changepower.SetCheck(FALSE);
		}else{
			m_changepower.SetCheck(TRUE);
		}
		if(m_powerset.m_column10!=1){
			m_changegoodtype.SetCheck(FALSE);
		}else{
			m_changegoodtype.SetCheck(TRUE);
		}
		if(m_powerset.m_column11!=1){
			m_changegoodmess.SetCheck(FALSE);
		}else{
			m_changegoodmess.SetCheck(TRUE);
		}
		if(m_powerset.m_column5!=1){
			m_sell.SetCheck(FALSE);
		}else{
			m_sell.SetCheck(TRUE);
		}
		if(m_powerset.m_column6!=1){
			m_delrecord.SetCheck(FALSE);
		}else{
			m_delrecord.SetCheck(TRUE);
		}
		if(m_powerset.m_column7!=1){
			m_statrecord.SetCheck(FALSE);
		}else{
			m_statrecord.SetCheck(TRUE);
		}
		if(m_powerset.m_column8!=1){
			m_datamanage.SetCheck(FALSE);
		}else{
			m_datamanage.SetCheck(TRUE);
		}
		if(m_powerset.m_column9!=1){
			m_log.SetCheck(FALSE);
		}else{
			m_log.SetCheck(TRUE);
		}
	//	m_powerset.MoveNext();
	}
}