changpassdlg.cpp

用Visual c++.net开发的图书管理系统

// ChangPassDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "myBook.h"
#include "ChangPassDlg.h"
#include ".\changpassdlg.h"


// CChangPassDlg 对话框

IMPLEMENT_DYNAMIC(CChangPassDlg, CDialog)
CChangPassDlg::CChangPassDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CChangPassDlg::IDD, pParent)
	, m_strOldPass(_T(""))
	, m_strNewPass(_T(""))
	, m_strConfirmPass(_T(""))
{
}

CChangPassDlg::~CChangPassDlg()
{
}

void CChangPassDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_OLD_PASS, m_strOldPass);
	DDX_Text(pDX, IDC_EDIT_NEW_PASS, m_strNewPass);
	DDX_Text(pDX, IDC_EDIT_CONFIRM_PASS, m_strConfirmPass);
}


BEGIN_MESSAGE_MAP(CChangPassDlg, CDialog)
END_MESSAGE_MAP()


// CChangPassDlg 消息处理程序

void CChangPassDlg::OnOK()
{
	UpdateData( TRUE );
	if ( m_strNewPass != m_strConfirmPass )
	{
		AfxMessageBox( _T("新密码与确认密码不一致") );
		return;
	}
	CString strSQL;
	strSQL.Format( _T("UPDATE my_Administer SET [Password]='%s' WHERE Account='%s' AND [Password]='%s'"),
		(LPCTSTR)m_strNewPass,
		(LPCTSTR)theApp.strMasterID,
		(LPCTSTR)m_strOldPass
		);
	try
	{
		CDatabase db;
		db.OpenEx(_T("DSN=myLib;UID=sa;PWD='';"), CDatabase::noOdbcDialog);
		db.ExecuteSQL( strSQL );
		db.Close();
	}
	catch ( CDBException *e )
	{
		e->ReportError();
		e->Delete();
		return;
	}
	MessageBox( _T("修改成功"), 0, MB_OK | MB_ICONINFORMATION );
	CDialog::OnOK();
}