powerdlg.cpp

改程序实现了登陆管理。用户设置有ADMIN和普通用户两种。是用户管理很使用的程序。

// PowerDlg.cpp : implementation file
//

#include "stdafx.h"
#include "PowerSet.h"
#include "PowerDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPowerDlg dialog
extern CPowerSetApp theApp;

CPowerDlg::CPowerDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPowerDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPowerDlg)
	m_power = _T("");
	m_pwd = _T("");
	m_repwd = _T("");
	m_user = _T("");
	//}}AFX_DATA_INIT
}


void CPowerDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPowerDlg)
	DDX_Control(pDX, IDC_PWD, m_ctrpwd);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_USER, m_ctruser);
	DDX_Control(pDX, IDC_COMBO1, m_ctrpower);
	DDX_Control(pDX, ID_USER_SAVE, m_btnSave);
	DDX_Control(pDX, ID_USER_EXIT, m_btnExit);
	DDX_Control(pDX, ID_USER_DEL, m_btnDel);
	DDX_Control(pDX, ID_USER_CANCEL, m_btnCancel);
	DDX_Control(pDX, ID_USER_ADD, m_btnAdd);
	DDX_CBString(pDX, IDC_COMBO1, m_power);
	DDX_Text(pDX, IDC_PWD, m_pwd);
	DDX_Text(pDX, IDC_REPWD, m_repwd);
	DDX_Text(pDX, IDC_USER, m_user);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPowerDlg, CDialog)
	//{{AFX_MSG_MAP(CPowerDlg)
	ON_BN_CLICKED(ID_USER_ADD, OnUserAdd)
	ON_BN_CLICKED(ID_USER_DEL, OnUserDel)
	ON_BN_CLICKED(ID_USER_SAVE, OnUserSave)
	ON_BN_CLICKED(ID_USER_CANCEL, OnUserCancel)
	ON_BN_CLICKED(ID_USER_EXIT, OnUserExit)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPowerDlg message handlers
/////////////////////////////////////////////////////////
//对话框初始化，用户信息列表显示
//作者：武
//////////////////////////////////////////////////////////
BOOL CPowerDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_list.SetHeadings(_T("用户名称,100; 管理权限,100"));

	UpdateList();	
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

/////////////////////////////////////////////////////////
//用户信息添加
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::OnUserAdd() 
{
	m_user = " ";
	m_pwd = " ";
	m_repwd = " ";
	m_power = " ";

    //设置用户名编辑框为可用
	m_ctruser.EnableWindow(TRUE);
	m_ctruser.SetFocus();

    //更新数据到界面
	this->UpdateData(FALSE);
	
}
/////////////////////////////////////////////////////////
//用户信息删除
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::OnUserDel() 
{
	this->UpdateData(TRUE);
	//判断是否指定用户
	if(m_user=="")
	{
		MessageBox("请选择一个你想要删除的用户!");
		return;
	}	
	if(this->MessageBox("你真的要删除所选择用户吗?",
		"",MB_YESNO)==IDNO)
		return;
	
	CString strSql;
	_variant_t fieldCount;

	strSql= "DELETE FROM users WHERE username = '"+m_user+"'" ;

	theApp.m_pConnection->Execute((_bstr_t)strSql,&fieldCount,adCmdText);

	VariantClear (&fieldCount);

    //更新列表框
	this->UpdateList();

	//更新界面元素
	m_user = " ";
	m_pwd = " ";
	m_repwd = " ";
	m_power = " ";

	this->UpdateData(FALSE);
	
}
/////////////////////////////////////////////////////////
//用户信息保存
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::OnUserSave() 
{
	this->UpdateData();
	if(m_ctruser.IsWindowEnabled())
	{//增加新用户的输入检查
		if(m_user=="")
		{
			MessageBox("请填写用户名!");
			m_ctruser.SetFocus();
			return;
		}

	}
	else
	{//修改用户信息输入检查
		if(m_user=="")
		{
			MessageBox("请选择一个用户!");
			return;
		}

	}
	//限制用户密码不能为空
	if(m_pwd=="")
	{
		MessageBox("用户密码不能为空，请输入密码!");
		m_ctrpwd.SetFocus();
		return;
	}
	//验证密码与确认密码是否一致
	if(m_pwd!=m_repwd)
	{
		MessageBox("再次输入密码不一致，请重新输入密码!");
		m_ctrpwd.SetFocus();
		m_pwd = "";
		m_repwd = "";
		this->UpdateData(FALSE);
		return;
	}
	
	CString Sql, strSql;
	_variant_t fieldCount;
	//判断用户是否重复
	m_pCon=theApp.m_pConnection;//给连接对象赋值
	m_pset.CreateInstance("ADODB.Recordset");//创建记录集实例对象

	Sql.Format("select * from users where username = '%s'", m_user);

	try
	{
	m_pset->Open((_bstr_t)Sql,&(*m_pCon),adOpenForwardOnly,adLockOptimistic,adCmdText);
	}
    catch(_com_error *e)
	{
	AfxMessageBox("数据记录打开失败!");
	}

	//打开记录集，进行用户信息增加或修改
	if(m_ctruser.IsWindowEnabled())
	{//增加新用户的输入检查
		if(!m_pset->adoEOF)
		{
			MessageBox("该用户已经存在!");
			m_pset->Close();
			return;
		}
		else
		{
		strSql="insert into users (username, passwd, power) values ('" +m_user+ "', '" +m_pwd+ "', '" +m_power+ "') " ;
	   
		theApp.m_pConnection->Execute((_bstr_t)strSql,&fieldCount,adCmdText);
	    VariantClear (&fieldCount);
        //更新用户列表
		this->UpdateList();
		}
	}
	else
	{//修改用户信息
		if(m_pset->adoEOF)
		{
			MessageBox("该用户不存在!无法进行修改");
			m_pset->Close();
			return;
		}
		else
		{
		strSql = "update users set username ='" + m_user + "', passwd ='" + m_pwd + "', power ='" + m_power + "'where username ='" + m_user + "' "; 

		theApp.m_pConnection->Execute((_bstr_t)strSql,&fieldCount,adCmdText);
	    VariantClear (&fieldCount);
        //更新用户列表
		this->UpdateList();
		}
	}
	m_ctruser.EnableWindow(FALSE);

	
}
/////////////////////////////////////////////////////////
//对话框信息置空
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::OnUserCancel() 
{
	m_user = " ";
	m_pwd = " ";
	m_repwd = " ";
	m_power = " ";

    //更新数据到界面
	this->UpdateData(FALSE);
	
}
/////////////////////////////////////////////////////////
//对话框退出
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::OnUserExit() 
{
	CDialog::OnCancel();
	
}

/////////////////////////////////////////////////////////
//更新显示对话框
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::UpdateList()
{
	CString strSql;
	
	//取数据库中得所有记录
	m_pCon=theApp.m_pConnection;//给连接对象赋值
	m_pset.CreateInstance("ADODB.Recordset");//创建记录集实例对象

	strSql.Format("select * from users" );

	m_list.DeleteAllItems();
	try
	{
	m_pset->Open((_bstr_t)strSql,&(*m_pCon),adOpenForwardOnly,adLockOptimistic,adCmdText);
	}
    catch(_com_error *e)
	{
	AfxMessageBox("数据记录打开失败!");
	}

	CString user,power;
	_bstr_t bstrVal;

	while(!m_pset->adoEOF)
	{ 
		user = m_pset->GetCollect("username").bstrVal;
		power = m_pset->GetCollect("power").bstrVal;

		m_list.AddItem(_T(user),_T(power));
	
		m_pset->MoveNext();
	}
	m_pset->Close();

}

/////////////////////////////////////////////////////////
//点击用户列表时更新显示
//作者：武
//////////////////////////////////////////////////////////
void CPowerDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int nSelRows = m_list.GetSelectedCount();
	if(!nSelRows) //-- If there are no rows selected,jump out here
		return;

	//-- Get the position of the first selected row
	POSITION pos =m_list.GetFirstSelectedItemPosition();

	//-- Get the index of next selected row
	int i = m_list.GetNextSelectedItem(pos);

	TRACE("First Item %d\n",i);

	CString qx;

	if (i != -1) //-- Execute this loop as long as GetNextSelectedItem() returns -1
	{			
	m_user = m_list.GetItemText(i, 0);
	m_power = m_list.GetItemText(i, 1);
	}

	UpdateData(FALSE);	
	return;	
	*pResult = 0;
}