changepassworddlg.cpp

本售货管理系统用vc和sql开发

// ChangePasswordDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "ChangePasswordDlg.h"

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

extern CDatabase m_database;
extern CString username;
/////////////////////////////////////////////////////////////////////////////
// CChangePasswordDlg dialog


CChangePasswordDlg::CChangePasswordDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CChangePasswordDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChangePasswordDlg)
	m_confirm = _T("");
	m_new = _T("");
	m_old = _T("");
	//}}AFX_DATA_INIT
}


void CChangePasswordDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangePasswordDlg)
	DDX_Text(pDX, IDC_CONFORMPASSWORD, m_confirm);
	DDX_Text(pDX, IDC_NEWPASSWORD, m_new);
	DDX_Text(pDX, IDC_OLDPASSWORD, m_old);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChangePasswordDlg, CDialog)
	//{{AFX_MSG_MAP(CChangePasswordDlg)
	ON_BN_CLICKED(IDCHANGEPASSWORD, OnChangepassword)
	ON_BN_CLICKED(IDCHANGECANCEL, OnChangecancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChangePasswordDlg message handlers

void CChangePasswordDlg::OnChangepassword() 
{
	UpdateData(TRUE);
	CUserSet m_userset;
	m_userset.m_pDatabase=&m_database;
	CString sql;
	sql.Format("select * from 用户密码表 where 用户名='%s'",username);
	m_userset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	CString m_password=m_userset.m_column2;
	m_password.TrimLeft();
	m_password.TrimRight();
	if(strcmp(m_password,m_old)!=0){
		MessageBox("原密码不正确，请重新输入");
		m_old="";
		UpdateData(FALSE);
	}else{
		if(strcmp(m_new,m_confirm)!=0){
			MessageBox("两次密码输入不一致，请重新输入");
			m_new="";
			m_confirm="";
			UpdateData(FALSE);
		}else{
			sql.Format("update 用户密码表 set 用户密码='%s' where 用户名='%s'",m_new,username);
			try{
				m_database.ExecuteSQL(sql);
			}catch(CDBException e1){
				AfxMessageBox("数据库操作失败");
			}
			catch(CMemoryException e2){
				AfxMessageBox("数据库操作失败");
			}
		}
	}
	CDialog::OnOK();
}

void CChangePasswordDlg::OnChangecancel() 
{
	CDialog::OnCancel();
}