tealo.cpp

数据库管理系统

// TEALO.cpp : implementation file
//

#include "stdafx.h"
#include "SCMIS.h"
#include "TEALO.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CDatabase db;
/////////////////////////////////////////////////////////////////////////////
// CTEALO dialog


CTEALO::CTEALO(CWnd* pParent /*=NULL*/)
	: CDialog(CTEALO::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTEALO)
	m_name = _T("");
	m_pswd = _T("");
	//}}AFX_DATA_INIT
}


void CTEALO::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTEALO)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_pswd);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CTEALO message handlers

void CTEALO::OnOK() 
{
	// TODO: Add extra validation here
    CRecordset *m_recordset=new CRecordset(&db);
	CString strSQL;int count=0;
	UpdateData(TRUE);
	strSQL.Format("select NAME,PSWD from TEACHER where NAME='%s' AND PSWD='%s'",m_name,m_pswd);
	m_recordset->Open(CRecordset::forwardOnly/*AFX_DB_USE_DEFAULT_TYPE*/,strSQL);
	if(m_recordset->GetRecordCount()==0){
		if(count<3){
			MessageBox("login incorrect!");
			count++;
		}
		else{
			MessageBox("too many trials");
	
			CDialog::OnOK();
		}
	}
	else{
		
		CTeaMagDlg dlg;
        //dlg.m_id=this->m_id;
        dlg.m_teacher.Format("%s",this->m_name);
        this->ShowWindow(SW_HIDE);
		dlg.DoModal();
		

		CDialog::OnOK();
	}
	
}