cangekeydlg.cpp

使用vc进行数据库编程的好例子

// CangeKeyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ManageSystem.h"
#include "CangeKeyDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCangeKeyDlg dialog


CCangeKeyDlg::CCangeKeyDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCangeKeyDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCangeKeyDlg)
	m_NewKey = _T("");
	m_NewKeyAgain = _T("");
	m_OldKey = _T("");
	//}}AFX_DATA_INIT
}


void CCangeKeyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCangeKeyDlg)
	DDX_Control(pDX, IDC_OLDKEY, m_ctrOldKey);
	DDX_Control(pDX, IDOK, m_btnOK);
	DDX_Control(pDX, IDCANCEL, m_btnCancel);
	DDX_Text(pDX, IDC_NEWKEY, m_NewKey);
	DDV_MaxChars(pDX, m_NewKey, 20);
	DDX_Text(pDX, IDC_NEWKEYAGAN, m_NewKeyAgain);
	DDX_Text(pDX, IDC_OLDKEY, m_OldKey);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CCangeKeyDlg message handlers

BOOL CCangeKeyDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_NewKey="";
	m_NewKeyAgain="";
	m_OldKey="";

	try
	{
		m_AdmiSet=new CAdmiSet();
		CString strSQL("SELECT * from administrator where admi_id = '");
		CString strID;
		strID.Format("%d",m_userID);
		strSQL+=strID;
		strSQL+="'";
		m_AdmiSet->Open(CRecordset::snapshot,strSQL);

		if(m_AdmiSet->IsEOF())
		{
			AfxMessageBox("Error");
		}
		else
		{
			m_Key=m_AdmiSet->m_admi_password;
			m_Key.TrimRight();
		}

	}
	catch(CDBException* pe)
	{
		AfxMessageBox(pe->m_strError);
		pe->Delete();
		if(m_AdmiSet)
		{
			if(m_AdmiSet->IsOpen())
				m_AdmiSet->Close();
			delete m_AdmiSet;
		}
	}

	m_btnCancel.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	m_btnCancel.DrawFlatFocus(TRUE);
	m_btnOK.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	m_btnOK.DrawFlatFocus(TRUE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCangeKeyDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();

	if(m_OldKey!=m_Key)
	{
		AfxMessageBox("输入旧密码错误!");
		m_OldKey="";
		m_NewKey="";
		m_NewKeyAgain="";
		m_ctrOldKey.SetFocus();
		return;
	}
	if(m_NewKey!=m_NewKeyAgain)
	{
		AfxMessageBox("输入新密码不一致!");
		m_OldKey="";
		m_NewKey="";
		m_NewKeyAgain="";
		m_ctrOldKey.SetFocus();
		return;
	}
	
	m_AdmiSet->Edit();
	m_AdmiSet->m_admi_password=m_NewKey;
	m_AdmiSet->Update();
	AfxMessageBox("密码更改成功!");
	
	CDialog::OnOK();
}