addpowerdlg.cpp

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

// AddpowerDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "AddpowerDlg.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;
/////////////////////////////////////////////////////////////////////////////
// CAddpowerDlg dialog


CAddpowerDlg::CAddpowerDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddpowerDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddpowerDlg)
	m_powertype = _T("");
	//}}AFX_DATA_INIT
}


void CAddpowerDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddpowerDlg)
	DDX_Control(pDX, IDC_CHECK9, m_datamanage);
	DDX_Control(pDX, IDC_CHECK10, m_log);
	DDX_Control(pDX, IDC_CHECK8, m_countrecord);
	DDX_Control(pDX, IDC_CHECK7, m_delrecord);
	DDX_Control(pDX, IDC_CHECK6, m_sale);
	DDX_Control(pDX, IDC_CHECK5, m_goodmess);
	DDX_Control(pDX, IDC_CHECK4, m_goodtype);
	DDX_Control(pDX, IDC_CHECK3, m_userpower);
	DDX_Control(pDX, IDC_CHECK2, m_userpassword);
	DDX_Control(pDX, IDC_CHECK1, m_usermess);
	DDX_Text(pDX, IDC_ADDPOWER, m_powertype);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddpowerDlg, CDialog)
	//{{AFX_MSG_MAP(CAddpowerDlg)
	ON_BN_CLICKED(IDADDPOWER, OnAddpower)
	ON_BN_CLICKED(IDAPCANCEL, OnApcancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddpowerDlg message handlers

void CAddpowerDlg::OnAddpower() 
{
	UpdateData(TRUE);
	CString sql;
	sql.Format("insert into 用户权限表 values ('%s' ",m_powertype);
	if(m_usermess.GetCheck()){
		sql=sql+", '1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_userpassword.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_userpower.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_goodtype.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_goodmess.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_sale.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_delrecord.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_countrecord.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_datamanage.GetCheck()){
		sql=sql+",'1'";
	}else{
		sql=sql+",'0'";
	}
	if(m_log.GetCheck()){
		sql=sql+",'1')";
	}else{
		sql=sql+",'0')";
	}
	try{
		m_database.ExecuteSQL(sql);
	}catch(CDBException e1){
		AfxMessageBox("数据库操作失败");
	}
	catch(CMemoryException e2){
		AfxMessageBox("数据库操作失败");
	}
	CDialog::OnOK();
}

void CAddpowerDlg::OnApcancel() 
{	
	CDialog::OnCancel();
}

BOOL CAddpowerDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	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_powerset.IsEOF()){
		if(m_powerset.m_column2!=1){
			m_usermess.EnableWindow(FALSE);
		}
		if(m_powerset.m_column3!=1){
			m_userpassword.EnableWindow(FALSE);
		}
		if(m_powerset.m_column4!=1){
			m_userpower.EnableWindow(FALSE);
		}
		if(m_powerset.m_column10!=1){
			m_goodtype.EnableWindow(FALSE);
		}
		if(m_powerset.m_column11!=1){
			m_goodmess.EnableWindow(FALSE);
		}
		if(m_powerset.m_column5!=1){
			m_sale.EnableWindow(FALSE);
		}
		if(m_powerset.m_column6!=1){
			m_delrecord.EnableWindow(FALSE);
		}
		if(m_powerset.m_column7!=1){
			m_countrecord.EnableWindow(FALSE);
		}
		if(m_powerset.m_column8!=1){
			m_datamanage.EnableWindow(FALSE);
		}
		if(m_powerset.m_column9!=1){
			m_log.EnableWindow(FALSE);
		}
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}