dialog_amend_users.cpp

学校人事管理系统。ADO＋SQL2000实现。功能全面。

//
/****************************************/
/*		SchoolManageSystem			    */
/*设计者：全佳营						*/
/*时间：2004.5.9-2004-5.18				*/
/*Email:[e-mail]				*/
/****************************************/
// Dialog_Amend_users.cpp : 实现文件
//

#include "stdafx.h"
#include "SchoolManageSys_2.h"
#include "Dialog_Amend_users.h"
#include ".\dialog_amend_users.h"


// CDialog_Amend_users 对话框

IMPLEMENT_DYNAMIC(CDialog_Amend_users, CDialog)
CDialog_Amend_users::CDialog_Amend_users(CWnd* pParent /*=NULL*/)
	: CDialog(CDialog_Amend_users::IDD, pParent)
	, m_userpwd(_T(""))
	, m_amendpwd(_T(""))
{
}

CDialog_Amend_users::CDialog_Amend_users(CWnd* pParent /*=NULL*/,
										 CAdoConnection* m_adoc)
	: CDialog(CDialog_Amend_users::IDD, pParent)
{
	m_AdoConnection=m_adoc;
}

CDialog_Amend_users::~CDialog_Amend_users()
{
}

void CDialog_Amend_users::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_PWD, m_userpwd);
	DDX_Text(pDX, IDC_EDIT2, m_amendpwd);
	DDX_Control(pDX, IDC_USR, m_user);
}


BEGIN_MESSAGE_MAP(CDialog_Amend_users, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_CBN_SELCHANGE(IDC_USR, OnCbnSelchangeUsr)
END_MESSAGE_MAP()


// CDialog_Amend_users 消息处理程序

BOOL CDialog_Amend_users::OnInitDialog(void)
{
	CDialog::OnInitDialog();
	theApp.m_pSkin->ApplySkin((long)m_hWnd);
	int count(0);
	if(m_AdoConnection->IsOpen()){
		m_AdoRecordSet.SetAdoConnection(m_AdoConnection);
		m_AdoRecordSet.SetCursorLocation();
		m_AdoRecordSet.Open("users",adCmdTable);
		CString usernametmp;

		while(!m_AdoRecordSet.IsEOF()){
			m_AdoRecordSet.GetCollect("username",usernametmp);
			m_user.AddString(usernametmp);
			count++;
			m_AdoRecordSet.MoveNext();
		}
		m_user.SetCurSel(count);
	}
	return TRUE;
}

void CDialog_Amend_users::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData();
	CString tmp;
	tmp.Format("username=\'%s\'",m_selection);
	if(MessageBox("确定修改?","确定修改",MB_OKCANCEL|MB_ICONQUESTION)==IDOK){
		if(!m_AdoRecordSet.IsBOF())
			m_AdoRecordSet.MoveFirst();
		
		m_AdoRecordSet.Find(tmp);
		m_AdoRecordSet.PutCollect("passwd",m_amendpwd);
		m_AdoRecordSet.Update();
		m_AdoRecordSet.UpdateBatch();
		m_AdoRecordSet.Requery();
		m_AdoConnection->CommitTrans();
	}
	UpdateData(FALSE);
	OnOK();
}

void CDialog_Amend_users::OnCbnSelchangeUsr()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData();
	m_user.GetLBText(m_user.GetCurSel(),m_selection);
	CString tmp;
	tmp.Format("username=\'%s\'",m_selection);
	if(m_selection=="用户名")
		AfxMessageBox("请选择一个用户");
	else {
		if(!m_AdoRecordSet.IsBOF())
			m_AdoRecordSet.MoveFirst();
		m_AdoRecordSet.Find(tmp);
		CString tmppwd;
		m_AdoRecordSet.GetCollect("passwd",tmppwd);
		m_userpwd=tmppwd;
		UpdateData(FALSE);
	}
}