modifypsw.cpp

赛克思书店销售管理系统.可用于二次开发,以C++与sql 写.

// ModifyPsw.cpp : implementation file
//

#include "stdafx.h"
#include "Project.h"
#include "ModifyPsw.h"

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

/////////////////////////////////////////////////////////////////////////////
// CModifyPsw dialog


CModifyPsw::CModifyPsw(CWnd* pParent /*=NULL*/)
	: CDialog(CModifyPsw::IDD, pParent)
{
	//{{AFX_DATA_INIT(CModifyPsw)
	m_User = _T("");
	m_Initpsw = _T("");
	m_Newpsw = _T("");
	m_Conpsw = _T("");
	//}}AFX_DATA_INIT
}


void CModifyPsw::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModifyPsw)
	DDX_Text(pDX, IDC_USER, m_User);
	DDX_Text(pDX, IDC_INITPSW, m_Initpsw);
	DDX_Text(pDX, IDC_NEWPSW, m_Newpsw);
	DDX_Text(pDX, IDC_CONPSW, m_Conpsw);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CModifyPsw, CDialog)
	//{{AFX_MSG_MAP(CModifyPsw)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModifyPsw message handlers

void CModifyPsw::OnOK() 
{
	this->UpdateData(true);
	try
	{
		CString sql_;
		sql_.Format("SELECT NAME FROM PASSWORD WHERE NAME='%s' AND PSW='%s'",
			m_User, m_Initpsw);
		_bstr_t sql = sql_;
		_RecordsetPtr pRst;
		pRst = pConn->Execute(sql, NULL, adCmdText);
		if (pRst->End)
		{
			pRst = pRst;
			AfxMessageBox("用户名或原来密码错误!");
			m_User = "";
			m_Initpsw = "";
			m_Newpsw = "";
			m_Conpsw = "";
			this->UpdateData(false);
		}
		else
		{
			if(m_Newpsw == m_Conpsw)
			{
				pConn->BeginTrans();
				sql_.Format("UPDATE PASSWORD SET PSW=\'%s\' WHERE NAME=\'%s\'",m_Newpsw,m_User);
				sql = sql_;
				pConn->Execute(sql, NULL, adCmdText);
				pConn->CommitTrans();
				AfxMessageBox("密码修改成功，请重新登陆确认!");
				CDialog::OnOK();
			}
			else
				AfxMessageBox("两次输入密码不一致,请重新输入!");
		}
		pRst->Close();
		pRst.Release();
	} 
	catch(_com_error& e)
	{
		AfxMessageBox(e.ErrorMessage());
	}
}