clog.cpp

书库管理 使用时要输入密码

// CLog.cpp : 实现文件
//

#include "stdafx.h"
#include "BookManage.h"
#include "CLog.h"
#include ".\clog.h"

//extern CBookManageApp theApp;
// CCLog 对话框

IMPLEMENT_DYNAMIC(CCLog, CDialog)
CCLog::CCLog(CWnd* pParent /*=NULL*/)
	: CDialog(CCLog::IDD, pParent)
	, m_user(_T("BookManager"))
	, m_pwd(_T(""))
{
}

CCLog::~CCLog()
{
}

void CCLog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_USERNAME, m_user);
	DDX_Text(pDX, IDC_EDIT_PASSWORD, m_pwd);
}


BEGIN_MESSAGE_MAP(CCLog, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
END_MESSAGE_MAP()


// CCLog 消息处理程序

void CCLog::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码

	UpdateData();
	if(!m_user.IsEmpty()&&!m_pwd.IsEmpty())
	{
		m_pwd=theApp.addpwd(m_pwd,true);
		CString sql="SELECT * FROM Pass where UserName='"+m_user+"' and PassWord='"+m_pwd+"'";
		try
		{
			m_pRecordset.CreateInstance("ADODB.Recordset");
			m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);

			if(m_pRecordset->adoEOF)
			{
				AfxMessageBox("用户名或密码错误");
				return;
			}
			else
			{
				theApp.name=m_user;
				theApp.pwd=m_pwd;
				CDialog::OnOK();
				return;
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString temp;
			temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
			AfxMessageBox(temp);
			return;
		}

	}
	
}