changepassdialog.cpp

VC+SQL SERVER 2000环境下开发的商品销售管理系统

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

#include "stdafx.h"
#include "SaleManager.h"
#include "ChangePassDialog.h"
#include ".\changepassdialog.h"

#define WM_REALNAME  WM_USER+0x100



// CChangePassDialog 对话框

IMPLEMENT_DYNAMIC(CChangePassDialog, CDialog)
CChangePassDialog::CChangePassDialog(CWnd* pParent /*=NULL*/)
	: CDialog(CChangePassDialog::IDD, pParent)
{
}

CChangePassDialog::~CChangePassDialog()
{
}

void CChangePassDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_ACCOUNT, m_AccountName);
	DDX_Text(pDX, IDC_EDIT_NAME, m_RealName);
	DDX_Text(pDX, IDC_EDIT_PASSF, m_PassWordF);
	DDX_Text(pDX, IDC_EDIT_PASSL, m_PassWordA);
}


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


// CChangePassDialog 消息处理程序

BOOL CChangePassDialog::OnInitDialog()
{
	CDialog::OnInitDialog();

	HRESULT hr;
	try
	{
		hr = m_pConnection.CreateInstance(__uuidof(Connection));

		if(SUCCEEDED(hr))
		{
			m_pConnection->ConnectionString = "File Name=SaleManagerdata.udl";
			m_pConnection->ConnectionTimeout = 20;

			hr = m_pConnection->Open("","","",adConnectUnspecified);

			if(FAILED(hr))
			{
				AfxMessageBox("打开失败");
				return TRUE;
			}
		}
		else
		{
			AfxMessageBox("创建连接实例失败!");
			return TRUE;
		}

		m_RealName = m_tempRealName;
		m_AccountName = m_tempAccountName;

		CEdit *pEdit = (CEdit*)GetDlgItem(IDC_EDIT_PASSF);
		pEdit->SetFocus();
		UpdateData(FALSE);

	}
	catch(_com_error e)
	{
		AfxMessageBox(e.ErrorMessage());
		return TRUE;
	}

	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

void CChangePassDialog::OnBnClickedOk()
{
	_RecordsetPtr m_pRecordset;
	HRESULT       hr;
    hr = m_pRecordset.CreateInstance(__uuidof(Recordset));
    
	if(FAILED(hr))
	{
		AfxMessageBox("创建实例失败!");
		PostMessage(WM_QUIT);
	}

	CString strSQL ;
	strSQL.Format("select * from LoginTable where AccountName = '%s'",m_AccountName);
	try
	{
		hr = m_pRecordset->Open (_bstr_t(strSQL),
			                     m_pConnection.GetInterfacePtr(),
			                     adOpenDynamic,
			                     adLockOptimistic,
			                     adCmdText);
		UpdateData(TRUE);

        if( m_PassWordF == m_PassWordA)
            m_pRecordset->PutCollect("Pass", _variant_t(m_PassWordF));
		else
		{
			AfxMessageBox(_T("两次输入密码不相同!"));
			m_PassWordF = "";
			m_PassWordA = "";
			CEdit *pEdit = (CEdit*)GetDlgItem(IDC_EDIT_PASSF);
			pEdit->SetFocus();
			UpdateData(FALSE);
			return;
		}
		m_pRecordset->Update();
		m_pRecordset->Close();
		m_pRecordset = NULL;
		m_pConnection->Close();
		m_pConnection = NULL;

		AfxMessageBox(_T("修改密码成功!"));
		OnOK();

	}
	catch(_com_error &e)
	{
		AfxMessageBox(e.ErrorMessage());
		return;
	}
}