// PassModifyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Sjsys.h"
#include "MyCrypt.h"
#include "PassModifyDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPassModifyDlg dialog


CPassModifyDlg::CPassModifyDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPassModifyDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPassModifyDlg)
	m_OldPassword = _T("");
	m_NewPassword = _T("");
	m_NewAffirmPassword = _T("");
	//}}AFX_DATA_INIT
}


void CPassModifyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPassModifyDlg)
	DDX_Control(pDX, IDCANCEL, m_cancel);
	DDX_Control(pDX, ID_OK, m_OK);
	DDX_Text(pDX, IDC_EDIT1, m_OldPassword);
	DDX_Text(pDX, IDC_EDIT2, m_NewPassword);
	DDX_Text(pDX, IDC_EDIT3, m_NewAffirmPassword);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPassModifyDlg, CDialog)
	//{{AFX_MSG_MAP(CPassModifyDlg)
	ON_WM_CANCELMODE()
	ON_BN_CLICKED(ID_OK, OnAffirm)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPassModifyDlg message handlers

BOOL CPassModifyDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_OK.SetShade(CShadeButtonST::SHS_HBUMP);
	m_cancel.SetShade(CShadeButtonST::SHS_HBUMP);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CPassModifyDlg::OnCancelMode() 
{
	CDialog::OnCancelMode();
	
	// TODO: Add your message handler code here
	
}

void CPassModifyDlg::OnAffirm() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
    //從數(shù)據(jù)庫中尋找用戶名密碼
    CString SQLStr;
	m_OldPassword=CMyCrypt::MyEncrypt(m_OldPassword,123);  //對舊密碼解密

	SQLStr.Format("select * from user1 where Password='%s'and ID='%d'",m_OldPassword,((CSjsysApp*)AfxGetApp())->m_UserID);
	_RecordsetPtr m_pRecordset;  
	HRESULT hTRes;
	try
	 {
		hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))
			{   
				hTRes = m_pRecordset->Open((LPTSTR)SQLStr.GetBuffer(130),
				    	((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
				    	adOpenDynamic,adLockPessimistic,adCmdText);//打開查詢結(jié)果記錄集				
			}
			

			if (!m_pRecordset->adoEOF) 	
			{
				if(m_NewPassword==m_NewAffirmPassword)
				{
					m_NewPassword=CMyCrypt::MyEncrypt(m_NewPassword,123);  //對新密碼進(jìn)行加密操作
					m_pRecordset->PutCollect("Password",_variant_t(m_NewPassword)); //規(guī)格
					m_pRecordset->Update(); //更新數(shù)據(jù)庫
					AfxMessageBox("密碼修改成功！");  //提示信息
				}
				else
				{
                   	AfxMessageBox("密碼修改失敗！");  //提示信息
					return;
				}
			}
           else
		   {
			   AfxMessageBox("舊密碼錯誤!");
			   return;
		   }
     m_pRecordset->Close();
	}
	catch(_com_error *e)
	{
	   CString  errormessage;
	   errormessage.Format("打開記錄集失敗！\r\n錯誤信息：%s",e->ErrorMessage());
	   AfxMessageBox(errormessage);
	}
	CDialog::OnOK();
}