updatepsddlg.cpp

VC下基于SQL的图书管理系统源代码

// UpdatePsdDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookAdmi.h"
#include "UpdatePsdDlg.h"
#include "Password.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// UpdatePsdDlg dialog


UpdatePsdDlg::UpdatePsdDlg(CWnd* pParent /*=NULL*/)
	: CDialog(UpdatePsdDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(UpdatePsdDlg)
	m_psdOld = _T("");
	m_psdNew1 = _T("");
	m_psdNew2 = _T("");
	m_psd1Old = _T("");
	m_psd1New1 = _T("");
	m_psd1New2 = _T("");
	//}}AFX_DATA_INIT
}


void UpdatePsdDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(UpdatePsdDlg)
	DDX_Control(pDX, IDOK2, m_ok);
	DDX_Text(pDX, IDC_EDIT1, m_psdOld);
	DDX_Text(pDX, IDC_EDIT2, m_psdNew1);
	DDX_Text(pDX, IDC_EDIT3, m_psdNew2);
	DDX_Text(pDX, IDC_EDIT4, m_psd1Old);
	DDX_Text(pDX, IDC_EDIT5, m_psd1New1);
	DDX_Text(pDX, IDC_EDIT6, m_psd1New2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(UpdatePsdDlg, CDialog)
	//{{AFX_MSG_MAP(UpdatePsdDlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_EN_SETFOCUS(IDC_EDIT4, OnSetfocusEdit4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// UpdatePsdDlg message handlers

void UpdatePsdDlg::OnOK() 
{
	Password psd;
	psd.GetData("1");
	//m_psdNew2=psd.m_Password;
	UpdateData(true);
	if(psd.m_Password==m_psdOld&&m_psdNew1!=""&&m_psdNew1==m_psdNew2)
	{
		_bstr_t sql,sql1;	
		sql="delete from t_password where Id='1'";
		ADOConn m_adoconn;
		m_adoconn.ExecuteSQL(sql);
		m_adoconn.OnInitADOConn();
		_bstr_t vSQL;
		vSQL="insert into t_password(Id,Password) values('1','"+m_psdNew2+"')";
		m_adoconn.ExecuteSQL(vSQL);
		m_adoconn.ExitConnect();
		MessageBox("密码修改成功");
	}
	else
		MessageBox("旧密码错误或新密码两次输入不一致");
}

void UpdatePsdDlg::OnButton1() 
{
	Password psd;
	psd.GetData("2");
	//m_psdNew2=psd.m_Password;
	UpdateData(true);
	if(psd.m_Password==m_psd1Old&&m_psd1New1!=""&&m_psd1New1==m_psd1New2)
	{
		_bstr_t sql,sql1;	
		sql="delete from t_password where Id='2'";
		ADOConn m_adoconn;
		m_adoconn.ExecuteSQL(sql);
		m_adoconn.OnInitADOConn();
		_bstr_t vSQL;
		vSQL="insert into t_password(Id,Password) values('2','"+m_psd1New2+"')";
		m_adoconn.ExecuteSQL(vSQL);
		m_adoconn.ExitConnect();
		MessageBox("密码修改成功");
	}
	else
		MessageBox("旧密码错误或新密码两次输入不一致");
}

void UpdatePsdDlg::OnSetfocusEdit4() 
{
	
}

//DEL void UpdatePsdDlg::OnOk2() 
//DEL {
//DEL 	
//DEL }