logondlg.cpp

这个请假管理系统可以很方便的让你去进行学生请假信息的存储和浏览

#include "stdafx.h"
#include "cc.h"
#include "LogonDlg.h"
#include"ccdlg.h"

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

/////////////////////////////////////////////////////////////////////////////

extern CCcApp theApp;

CLogonDlg::CLogonDlg(CWnd* pParent /*=NULL*/): CDialog(CLogonDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogonDlg)
	m_strPass = _T("");
	m_strAdmin = _T("");
	//}}AFX_DATA_INIT
}


void CLogonDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogonDlg)
	DDX_Text(pDX, IDC_EDIT1, m_strPass);
	DDX_Text(pDX, IDC_ADMIN_NAME, m_strAdmin);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////

void CLogonDlg::OnOK() 
{
	UpdateData();	
	if(m_strAdmin.IsEmpty() || m_strPass.IsEmpty())  
	{
		AfxMessageBox("请输入用户名和密码！");
	}
	else
	{
		CString sql="SELECT * FROM Admin where AdminName='"+theApp.g_Admin+"' and pwd='"+m_strPass+"'";
		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)	 //如果没有此用户和密码
			{
				MessageBox("请输入正确的用户名和密码!","错误",MB_ICONEXCLAMATION);
				SetDlgItemText(IDC_EDIT1,"");
				GetDlgItem(IDC_EDIT1)->SetFocus();
			}
			else
			{
				theApp.g_Admin=m_strAdmin;
				theApp.g_Pass=m_strPass;
				CDialog::OnOK();
			}
		}
		catch (_com_error e)								
		{													
			CATCH_ERROR;
			return;
		}
	}	
	
}

void CLogonDlg::OnCancel() 
{

	((CCcDlg*)AfxGetMainWnd())->EndDialog(IDOK);
	
	CDialog::OnCancel();
}

BOOL CLogonDlg::OnInitDialog()   //读出用户名显示
{
	CDialog::OnInitDialog();
	try
	{
		m_pRecordset.CreateInstance("ADODB.Recordset");
		m_pRecordset->Open((_variant_t)"SELECT * FROM Admin",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	
		if(!m_pRecordset->adoEOF)
		{
			theApp.g_Admin=((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AdminName"));
			SetDlgItemText(IDC_ADMIN_NAME,theApp.g_Admin);
		}	
		m_pRecordset->Close();
	}

	catch (_com_error e)								
	{	
		CATCH_ERROR;		
		return false;
	}
	return TRUE;  
}