dpurview.cpp

商品销售管理系统：随着信息技术的快速进步

// DPurView.cpp : implementation file
//

#include "stdafx.h"
#include "商品销售管理系统.h"
#include "DPurView.h"
#include "ExternDllHeader.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDPurView dialog


CDPurView::CDPurView(CWnd* pParent /*=NULL*/)
	: CDialog(CDPurView::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDPurView)
	//}}AFX_DATA_INIT
}


void CDPurView::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDPurView)
	DDX_Control(pDX, IDC_CHKPerson, m_CHKPerson);
	DDX_Control(pDX, IDC_BUTUndo, m_ButUndo);
	DDX_Control(pDX, IDC_BUTExit1, m_ButExit);
	DDX_Control(pDX, IDC_BUTSave, m_ButSave);
	DDX_Control(pDX, IDC_BUTChange, m_ButChange);
	DDX_Control(pDX, IDC_CHKWare, m_CHKWare);
	DDX_Control(pDX, IDC_CHKSystem, m_CHKSystem);
	DDX_Control(pDX, IDC_CHKSellQuery, m_CHKSellQuery);
	DDX_Control(pDX, IDC_CHKSellManage, m_CHKSellManage);
	DDX_Control(pDX, IDC_CHKSellBackQuery, m_CHKSellBackQuery);
	DDX_Control(pDX, IDC_CHKSellBackManage, m_CHKSellBackManage);
	DDX_Control(pDX, IDC_CHKResume, m_CHKResume);
	DDX_Control(pDX, IDC_CHKReserveQuery, m_CHKReserveQuery);
	DDX_Control(pDX, IDC_CHKReserveManage, m_CHKReserveManage);
	DDX_Control(pDX, IDC_CHKPurView, m_CHKPurView);
	DDX_Control(pDX, IDC_CHKOP, m_CHKOP);
	DDX_Control(pDX, IDC_CHKClient, m_CHKClient);
	DDX_Control(pDX, IDC_CHKBAK, m_CHKBAK);
	DDX_Control(pDX, IDC_List, m_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDPurView, CDialog)
	//{{AFX_MSG_MAP(CDPurView)
	ON_BN_CLICKED(IDC_BUTChange, OnBUTChange)
	ON_NOTIFY(LVN_ITEMCHANGING, IDC_List, OnItemchangingList)
	ON_NOTIFY(NM_CLICK, IDC_List, OnClickList)
	ON_BN_CLICKED(IDC_BUTSave, OnBUTSave)
	ON_BN_CLICKED(IDC_BUTUndo, OnBUTUndo)
	ON_BN_CLICKED(IDC_BUTExit1, OnBUTExit1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDPurView message handlers

void CDPurView::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDPurView::OnBUTChange() 
{
	this->Enabled(false);
}

BOOL CDPurView::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//将图标添加到ImageList中
	CString cName,cImage;
	m_ImageList.Create(32,32,ILC_COLOR32|ILC_MASK,0,0);
	for(int i=IDI_ICON8;i<=IDI_ICON13;i++)
	{
		m_ImageList.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(i)));
	}
	m_List.ImageList(&m_ImageList);
	m_List.SetTextField("名称");
	m_List.SetImageField("头像");
	m_List.SetDataBase("操作员信息表");
	rst.Open("权限视图");
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDPurView::Display()
{
	this->m_CHKBAK.SetCheck(atoi(rst.GetFieldValue("数据备份")));
	this->m_CHKClient.SetCheck(atoi(rst.GetFieldValue("客户信息")));
	this->m_CHKOP.SetCheck(atoi(rst.GetFieldValue("用户管理")));
	this->m_CHKPurView.SetCheck(atoi(rst.GetFieldValue("权限管理")));
	this->m_CHKReserveManage.SetCheck(atoi(rst.GetFieldValue("订货管理")));
	this->m_CHKReserveQuery.SetCheck(atoi(rst.GetFieldValue("订货查询")));
	this->m_CHKResume.SetCheck(atoi(rst.GetFieldValue("数据恢复")));
	this->m_CHKSellBackManage.SetCheck(atoi(rst.GetFieldValue("退货管理")));
	this->m_CHKSellBackQuery.SetCheck(atoi(rst.GetFieldValue("退货查询")));
	this->m_CHKSellManage.SetCheck(atoi(rst.GetFieldValue("销售管理")));
	this->m_CHKSellQuery.SetCheck(atoi(rst.GetFieldValue("销售查询")));
	this->m_CHKSystem.SetCheck(atoi(rst.GetFieldValue("系统管理")));
	this->m_CHKWare.SetCheck(atoi(rst.GetFieldValue("商品信息")));
	this->m_CHKPerson.SetCheck(atoi(rst.GetFieldValue("员工信息")));
}

void CDPurView::OnItemchangingList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	CString sName,sSQL;
	sName=m_List.GetItemText(m_List.GetSelectionMark(),0);
	sSQL.Format("SELECT * FROM 权限视图 WHERE 名称='%s'",sName);
	rst.Open(sSQL,adCmdText);
	this->Display();
	*pResult = 0;
}

void CDPurView::Enabled(bool bEnabled)
{
	m_ButUndo.EnableWindow(!bEnabled);
	m_ButExit.EnableWindow(bEnabled);
	m_ButSave.EnableWindow(!bEnabled);
	m_ButChange.EnableWindow(bEnabled);
	m_CHKWare.EnableWindow(!bEnabled);
	m_CHKSystem.EnableWindow(!bEnabled);
	m_CHKSellQuery.EnableWindow(!bEnabled);
	m_CHKSellManage.EnableWindow(!bEnabled);
	m_CHKSellBackQuery.EnableWindow(!bEnabled);
	m_CHKSellBackManage.EnableWindow(!bEnabled);
	m_CHKResume.EnableWindow(!bEnabled);
	m_CHKReserveQuery.EnableWindow(!bEnabled);
	m_CHKReserveManage.EnableWindow(!bEnabled);
	m_CHKPurView.EnableWindow(!bEnabled);
	m_CHKOP.EnableWindow(!bEnabled);
	m_CHKClient.EnableWindow(!bEnabled);
	m_CHKBAK.EnableWindow(!bEnabled);
	m_CHKPerson.EnableWindow(!bEnabled);
	m_List.EnableWindow(bEnabled);

}

void CDPurView::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	if(m_List.GetFirstSelectedItemPosition())
	{
		CString sName,sSQL;
		sName=m_List.GetItemText(m_List.GetSelectionMark(),0);
		sSQL.Format("SELECT * FROM 权限视图 WHERE 名称='%s'",sName);
		rst.Open(sSQL,adCmdText);
		this->Display();
	}
	*pResult = 0;
}

void CDPurView::OnBUTSave() 
{
	int a=MessageBox("确定要更改此操作员的权限吗？","系统提示",MB_OKCANCEL|MB_ICONQUESTION);
	if(a==1)
	{
		CString sSQL,sName,sID;
		sName=m_List.GetItemText(m_List.GetSelectionMark(),0);
		sID=ado.FieldToOtherField("操作员信息表","名称",sName,"编号",1);
		sSQL.Format("UPDATE 权限表 SET 用户管理=%d,权限管理=%d,系统管理=%d,订货管理=%d,销售管理=%d,退货管理=%d,\
			订货查询=%d,销售查询=%d,退货查询=%d,数据备份=%d,数据恢复=%d,\
			商品信息=%d,客户信息=%d,员工信息=%d WHERE 编号=%s",m_CHKOP.GetCheck(),m_CHKPurView.GetCheck(),m_CHKSystem.GetCheck(),\
			m_CHKReserveManage.GetCheck(),m_CHKSellManage.GetCheck(),m_CHKSellBackManage.GetCheck(),\
			m_CHKReserveQuery.GetCheck(),m_CHKSellQuery.GetCheck(),m_CHKSellBackQuery.GetCheck(),\
			m_CHKBAK.GetCheck(),m_CHKResume.GetCheck(),m_CHKWare.GetCheck(),m_CHKClient.GetCheck(),m_CHKPerson.GetCheck(),sID);
		rst.Open(sSQL,adCmdText);
		this->Enabled(true);
		MessageBox("对操作员[ "+sName+" ]的权限设置工作完成，新权限在下次启动时生效！","系统提示",MB_OK|MB_ICONEXCLAMATION);

		m_List.SetFocus();
	}

}

BOOL CDPurView::PreTranslateMessage(MSG* pMsg) 
{
	if(pMsg->hwnd==m_List.GetSafeHwnd()&&pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
	{
		this->OnBUTChange();	
	}
	return CDialog::PreTranslateMessage(pMsg);
}

void CDPurView::OnBUTUndo() 
{
	int a=MessageBox("确定要取消修改吗？","系统提示",MB_OKCANCEL|MB_ICONQUESTION);
	if(a==1)
	{
		this->Enabled(true);
		m_List.SetFocus();
		this->Display();
	}
}

void CDPurView::OnBUTExit1() 
{
	this->OnCancel();	
}