powerdlg.cpp

< SQL SERVER 2000 案例教程>>,冶金工业出版社,这本书的代码

// PowerDlg.cpp : implementation file
//

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

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

extern CDatabase m_database;
extern CString username;
/////////////////////////////////////////////////////////////////////////////
// CPowerDlg dialog


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


void CPowerDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPowerDlg)
	DDX_Control(pDX, IDC_POWERTREE, m_powertree);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPowerDlg, CDialog)
	//{{AFX_MSG_MAP(CPowerDlg)
	ON_BN_CLICKED(IDC_ADDPOWER, OnAddpower)
	ON_NOTIFY(TVN_SELCHANGED, IDC_POWERTREE, OnSelchangedPowertree)
	ON_BN_CLICKED(IDC_DELPOWER, OnDelpower)
	ON_BN_CLICKED(IDC_CHANGEPOWER, OnChangepower)
	ON_BN_CLICKED(IDPOWERCANCEL, OnPowercancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPowerDlg message handlers

void CPowerDlg::OnAddpower() 
{
	CAddpowerDlg powerdlg;
	powerdlg.DoModal();
	CString sql;
	sql.Format("select * from 用户权限表");
	OnRefreshData(sql);
}

BOOL CPowerDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString sql;
	sql.Format("select * from 用户权限表");
	OnRefreshData(sql);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CPowerDlg::OnRefreshData(CString sql)
{
	m_powertree.DeleteAllItems();//先清除树形控件中的内容
	CPowerSet m_powerset;
	m_powerset.m_pDatabase=&m_database;
	CString str;
	//查询以获取要显示的数据
	m_powerset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	HTREEITEM hParent;
 	HTREEITEM hCurrent;
	//设置显示字体的顔色
	m_powertree.SetTextColor(RGB(7,1145,67));
	//插入根结点，同时记下它的句柄hParent
	hParent = m_powertree.InsertItem("权限类型");
	if(!m_powerset.IsEOF())
		m_powerset.MoveFirst();
	while(!m_powerset.IsEOF()){
		while(m_powerset.IsDeleted())
			m_powerset.MoveNext();
		//获取权限名
		str=m_powerset.m_column1;
		str.TrimRight();
		str.TrimLeft();
		//插入子结点，在hParent对应的结点下插入新的结点
		hCurrent=m_powertree.InsertItem(str,hParent,NULL);
		//插入各权限类型所具有的权限
		if(m_powerset.m_column2==1){
			m_powertree.InsertItem("更新用户资料",hCurrent,NULL);
		}
		if(m_powerset.m_column3==1){
			m_powertree.InsertItem("修改用户密码",hCurrent,NULL);
		}
		if(m_powerset.m_column4==1){
			m_powertree.InsertItem("更新权限资料",hCurrent,NULL);
		}
		if(m_powerset.m_column10==1){
			m_powertree.InsertItem("更新商品类型",hCurrent,NULL);
		}
		if(m_powerset.m_column11==1){
			m_powertree.InsertItem("更新商品资料",hCurrent,NULL);
		}
		if(m_powerset.m_column5==1){
			m_powertree.InsertItem("售货操作",hCurrent,NULL);
		}
		if(m_powerset.m_column6==1){
			m_powertree.InsertItem("删除售货记录",hCurrent,NULL);
		}
		if(m_powerset.m_column7==1){
			m_powertree.InsertItem("统计售货记录",hCurrent,NULL);
		}
		if(m_powerset.m_column8==1){
			m_powertree.InsertItem("数据库管理",hCurrent,NULL);
		}
		if(m_powerset.m_column9==1){
			m_powertree.InsertItem("日志删除",hCurrent,NULL);
		}
		
		m_powerset.MoveNext();
	}
	m_powertree.Expand(hParent,TVE_EXPAND);//展开根结点
}

void CPowerDlg::OnSelchangedPowertree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	CString item;
	item=m_powertree.GetItemText(m_powertree.GetSelectedItem());
	*pResult = 0;
}

void CPowerDlg::OnDelpower() 
{	
}

void CPowerDlg::OnChangepower() 
{
	CChangePowerDlg changepowerdlg;
	changepowerdlg.DoModal();
	CString sql;
	sql.Format("select * from 用户权限表");
	OnRefreshData(sql);
}

void CPowerDlg::OnPowercancel() 
{
	if(MessageBox("确定退出系统1?","提醒",MB_YESNO|MB_DEFBUTTON2|MB_ICONQUESTION)!=IDNO){
		exit(0);
	}
}