logdlg.cpp

具有添加,删除,修改,更新的功能,用ado读ini文件访问数据库

// LogDlg.cpp : implementation file
//

#include "stdafx.h"
#include "学生成绩管理系统.h"
#include "LogDlg.h"
#include "GlobalVarFunc.h"
#include "DBOper.h"
#include <time.h>
#include "ado.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLogDlg dialog
extern bool gDBConnected;

CLogDlg::CLogDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLogDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogDlg)
	m_username = _T("");
	m_password = _T("");
	//}}AFX_DATA_INIT
}


void CLogDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogDlg)
	DDX_Control(pDX, IDC_STATIC2, m_mima);
	DDX_Control(pDX, IDC_STATIC1, m_users);
	DDX_Control(pDX, IDCANCEL, m_CANCEL);
	DDX_Control(pDX, IDOK, m_OK);
	DDX_Text(pDX, IDC_EDIT1, m_username);
	DDX_Text(pDX, IDC_EDIT2, m_password);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CLogDlg message handlers

void CLogDlg::OnOK() 
{
	// TODO: Add extra validation here
	 int         ret;
	if(false==gDBConnected )
	{
		MessageBox("数据库尚未连接!");
		return;
	}
	UpdateData(TRUE);
	ret=QueryInfoYonghuTable(m_username,m_password);
	switch(ret)
	{
		case -2:
			MessageBox("密码错误!");
			m_icount++;
			if(m_icount==4) 
			{
				MessageBox("超过三次,退出!");
				DisconnectDatabase();
				AfxGetMainWnd()->PostMessage(WM_QUIT);
				EndDialog(IDCANCEL);
			}
			return;
		case -1:
			MessageBox("访问数据表失败!");
			DisconnectDatabase();
			AfxGetMainWnd()->PostMessage(WM_QUIT);
			EndDialog(IDCANCEL);
			break;
		case 0:
			MessageBox("用户不存在!");
			m_icount++;
			if(m_icount==4) 
			{
				MessageBox("超过三次,退出!");
				DisconnectDatabase();
				AfxGetMainWnd()->PostMessage(WM_QUIT);
				EndDialog(IDCANCEL);
			}
			return;
		case 1:
			DisconnectDatabase();
			MessageBox("登陆成功!");
			break;
	}
	CDialog::OnOK();
}

void CLogDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	MessageBox("失败");
	AfxGetMainWnd()->PostMessage(WM_QUIT);
	EndDialog(IDCANCEL);
	CDialog::OnCancel();
	CDialog::OnCancel();
}