logon.cpp

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

// Logon.cpp : implementation file
//

#include "stdafx.h"
#include "TotalPay.h"
#include "Logon.h"
#include "WinXPButtonST.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CLogon dialog

extern CTotalPayApp theApp;
CLogon::CLogon(CWnd* pParent /*=NULL*/)
	: CDialog(CLogon::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogon)
	m_user = _T("");
	m_pwd = _T("");
	//}}AFX_DATA_INIT
}


void CLogon::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogon)
	DDX_Control(pDX, IDC_REGISTER, m_register);
	DDX_Control(pDX, IDCANCEL, m_cancel);
	DDX_Control(pDX, IDOK, m_ok);
	DDX_Control(pDX, IDC_COMBO1, m_1);
	DDX_CBString(pDX, IDC_COMBO1, m_user);
	DDX_Text(pDX, IDC_EDIT1, m_pwd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLogon, CDialog)
	//{{AFX_MSG_MAP(CLogon)
	ON_BN_CLICKED(IDC_REGISTER, OnRegister)
	ON_COMMAND(ID_REGISTER, OnRegister)

	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLogon message handlers

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

}

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

	
	

	
	int numline=0;
	CString sql="select name from alluser order by name desc";
	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("你的数据库中还没有出差记录信息！");
		}
		else
		{
			while(!m_pRecordset->adoEOF)
			{
				m_1.InsertString(0,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("name"));
				sql=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("name");
				m_pRecordset->MoveNext();
			}
			SetDlgItemText(IDC_COMBO1,sql);
		}
		m_pRecordset->Close();
	}
	catch(_com_error e)///捕捉异常
	{
		CString temp;
		temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
		AfxMessageBox(temp);
		return false;
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CLogon::OnRegister() 
{	
	CRegister dlg;
	dlg.DoModal();

}