usermgrdlg.cpp

自己编写的迷你图书馆的完整程序.VC6MFC编写的,Windows界面.数据采用了Sqlserver2000.压缩包中已包括了数据库.先附加数据库再运行.

// UserMgrDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "UserMgrDlg.h"
#include "UserAddDlg.h"
#include "columns.h"
#include "column.h"
#include "UserModiDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUserMgrDlg dialog


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


void CUserMgrDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUserMgrDlg)
	DDX_Control(pDX, IDC_ADODC1, m_ad);
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUserMgrDlg, CDialog)
	//{{AFX_MSG_MAP(CUserMgrDlg)
	ON_BN_CLICKED(IDC_BTN_USER_ADD, OnBtnUserAdd)
	ON_BN_CLICKED(IDC_BTN_USER_DEL, OnBtnUserDel)
	ON_BN_CLICKED(IDC_BTN_USER_MODI, OnBtnUserModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUserMgrDlg message handlers

void CUserMgrDlg::OnBtnUserAdd() 
{
	CUserAddDlg dlg;
	dlg.DoModal();
	m_ad.Refresh();
}

void CUserMgrDlg::OnBtnUserDel() 
{
	CColumns columns;
	columns=m_dg.GetColumns();

	VARIANT index;
	index.vt=VT_INT;
	index.lVal=0;
	CColumn column;
	column=columns.GetItem(index);
	
	CString strUser;
	strUser=column.GetText();
	
	if(strUser=="admin" || strUser=="operator" || strUser=="guest")
	{
		MessageBox("系统内置用户不能删除!","错误");
		return;
	}

	CString prompt;
	prompt.Format("确定要删除用户: %s 吗?",strUser);
	if(MessageBox(prompt,"提示",MB_OKCANCEL)==IDOK)
	{
		CString sql;
		sql.Format("delete from 用户表 where userId='%s'",strUser);
		g_adoDB.Execute(sql);

		m_ad.Refresh();
	}
}

void CUserMgrDlg::OnBtnUserModi() 
{
	CUserModiDlg dlg;

	CColumns columns;
	columns=m_dg.GetColumns();

	VARIANT index;
	CColumn column;
	index.vt=VT_INT;
	index.lVal=0;
	column=columns.GetItem(index);
	dlg.m_user=column.GetText();//用户名
	index.lVal=1;
	column=columns.GetItem(index);
	dlg.m_pwd=column.GetText();//密码
	index.lVal=2;
	column=columns.GetItem(index);
	CString type=column.GetText();
	dlg.m_type=type;

	dlg.DoModal();
	m_ad.Refresh();
}