logonadmin.cpp

通过Access数据库实现对个人开支的管理

// LogonAdmin.cpp : implementation file
//
#include "Admin.h"
#include "stdafx.h"
#include "TotalPay.h"
#include "LogonAdmin.h"
#include "resource.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CLogonAdmin dialog

extern CTotalPayApp theApp;
CLogonAdmin::CLogonAdmin(CWnd* pParent /*=NULL*/)
: CDialog(CLogonAdmin::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogonAdmin)
	m_name = _T("");
	m_code = _T("");
	//}}AFX_DATA_INIT
}


void CLogonAdmin::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogonAdmin)
	DDX_Control(pDX, IDOK, m_ok);
	DDX_Control(pDX, IDCANCEL, m_cancel);
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_code);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CLogonAdmin message handlers

void CLogonAdmin::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	//如果用户名和密码不为空则执行以下操作
	if(!m_name.IsEmpty()&&!m_code.IsEmpty())
	{
		//成生sql语句
		
		CString sql="SELECT * FROM admin where admin='"+m_name+"' and pwd='"+m_code+"'";
		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)
			{
				m_pRecordset->Close();
				
				AfxMessageBox("用户名或密码错误!");
				return;
				
			}
			//用户名和密码存在，登录成功
			else
			{
				CAdmin *pDlg=new CAdmin(); 
				pDlg->Create(IDD_DIALOG_ADMIN); 
				pDlg->ShowWindow(SW_SHOW);
				CDialog::OnOK();
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString temp;
			temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
			AfxMessageBox(temp);
			return;
		}
	}
	//反之则
	else
		AfxMessageBox("请输入用户名和密码！");
	
	
}

BOOL CLogonAdmin::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_ok.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, 30);
	m_ok.SetBkColor(RGB(162,189,252));
	m_ok.SetRounded(TRUE);

	m_cancel.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, 30);
	m_cancel.SetBkColor(RGB(162,189,252));
	m_cancel.SetRounded(TRUE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}