// OldPass.cpp : implementation file
//

#include "stdafx.h"
#include "Student.h"
#include "OldPass.h"
#include "setpassword.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CStudentApp theApp;
/////////////////////////////////////////////////////////////////////////////
// COldPass dialog


COldPass::COldPass(CWnd* pParent /*=NULL*/)
	: CDialog(COldPass::IDD, pParent)
{
	//{{AFX_DATA_INIT(COldPass)
	m_sOldPass = _T("");
	//}}AFX_DATA_INIT
}


void COldPass::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(COldPass)
	DDX_Text(pDX, IDC_OldPass, m_sOldPass);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(COldPass, CDialog)
	//{{AFX_MSG_MAP(COldPass)
	ON_BN_CLICKED(IDC_TRUE, OnTrue)
	ON_BN_CLICKED(IDC_CANCEL, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// COldPass message handlers

void COldPass::OnTrue() 
{
	_RecordsetPtr m_pRec;
	char buf[100];
	_variant_t RecordsAffected;
	UpdateData(TRUE);
	sprintf(buf,"select username from users where password=%s",m_sOldPass);
	m_pRec.CreateInstance("ADODB.Recordset");
	m_pRec=theApp.m_pConnect->Execute(buf,&RecordsAffected,adCmdText);
	if(m_pRec->adoEOF)
	{
		AfxMessageBox("密碼不對！");
		CDialog::OnOK();
		return;
	}
	m_pRec->Close();
	CDialog::OnOK();
	CSetPassWord setpassDlg;
	setpassDlg.DoModal();

}




void COldPass::OnCancel() 
{

	CDialog::OnCancel();
}