dlgmdpassword.cpp

书库管理 使用时要输入密码

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

#include "stdafx.h"
#include "BookManage.h"
#include "DlgMdPassWord.h"
#include ".\dlgmdpassword.h"


// CDlgMdPassWord 对话框

IMPLEMENT_DYNAMIC(CDlgMdPassWord, CDialog)
CDlgMdPassWord::CDlgMdPassWord(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgMdPassWord::IDD, pParent)
	, m_OldPassWord(_T(""))
	, m_NewPassWord(_T(""))
{

}

CDlgMdPassWord::~CDlgMdPassWord()
{
}

void CDlgMdPassWord::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_OLDPASSWORD, m_OldPassWord);
	DDX_Text(pDX, IDC_EDIT_NEWPASSWORD, m_NewPassWord);
}


BEGIN_MESSAGE_MAP(CDlgMdPassWord, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
END_MESSAGE_MAP()


// CDlgMdPassWord 消息处理程序

void CDlgMdPassWord::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码

	//连接数据库文件
	UpdateData();
	_RecordsetPtr m_pRecordset;
	if(!m_NewPassWord.IsEmpty()&&!m_OldPassWord.IsEmpty())
	{
//		CString m_pwd=theApp.addpwd(m_pwd,true);
		CString sql="SELECT * FROM Pass";// where UserName='"+m_user+"' and PassWord='"+m_pwd+"'";
		try
		{
			m_pRecordset.CreateInstance("ADODB.Recordset");
			m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
			CString pwd = theApp.addpwd(m_pRecordset->GetCollect("PassWord"),false);
			if(m_OldPassWord==pwd)
			{
				CString newpwd = theApp.addpwd(m_NewPassWord,true);
				m_pRecordset->PutCollect("PassWord",(_bstr_t)newpwd);
				m_pRecordset->Update();

				AfxMessageBox("成功修改密码!");
				OnOK();
				return;
			}
			else
			{
				AfxMessageBox("旧密码错误!");
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString temp;
			temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
			AfxMessageBox(temp);
			OnOK();
			return;
		}



	
}
}