fpsys.cpp

基于指纹技术的学生考勤系统

// FPSys.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "FPSys.h"
#include "FPSysDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFPSysApp

BEGIN_MESSAGE_MAP(CFPSysApp, CWinApp)
	//{{AFX_MSG_MAP(CFPSysApp)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG
	ON_COMMAND(ID_HELP, CWinApp::OnHelp)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFPSysApp construction

CFPSysApp::CFPSysApp()
{
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CFPSysApp object

CFPSysApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CFPSysApp initialization
int m_iSetType;
int m_iConnDes;
long dwMachineNumber;
CDatabase m_db;

BOOL CFPSysApp::InitInstance()
{
	AfxEnableControlContainer();

	// Standard initialization
	// If you are not using these features and wish to reduce the size
	//  of your final executable, you should remove from the following
	//  the specific initialization routines you do not need.

#ifdef _AFXDLL
	Enable3dControls();			// Call this when using MFC in a shared DLL
#else
	Enable3dControlsStatic();	// Call this when linking to MFC statically
#endif

	CFPSysDlg dlg;
	m_pMainWnd = &dlg;
	int nResponse = dlg.DoModal();
	if (nResponse == IDOK)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with OK
	}
	else if (nResponse == IDCANCEL)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with Cancel
	}

	// Since the dialog has been closed, return FALSE so that we exit the
	//  application, rather than start the application's message pump.
	return FALSE;
}

CString FromIDToName(CString tabName,CString attr,int id)	//通过编号获得名字
{
	CString sql;
	CString sRet;
	sql.Format("select *from %s where %s=%d",tabName,attr,id);
	TRY{
		CRecordset rs(&m_db);
		rs.Open(CRecordset::dynaset,sql);
		if(!rs.IsEOF())
		{
			CDBVariant var;
			rs.GetFieldValue(1,sRet);
		}
		rs.Close();
		return sRet;
	}
	CATCH(CDBException,ex)
	{
		AfxMessageBox(ex->m_strError);
		AfxMessageBox(ex->m_strStateNativeOrigin);
	}
	AND_CATCH(CMemoryException,pEx)
	{
		pEx->ReportError();
		AfxMessageBox("memory exception");
	}
	AND_CATCH(CException,e)
	{
		TCHAR szError[100];
		e->GetErrorMessage(szError,100);
		AfxMessageBox(szError);
	}
	END_CATCH
	return _T("");
}

int FromNameToID(CString tabName,CString attr,CString name)	//通过名字获得编号
{
	CString sql;
	int iRet;
	sql.Format("select *from %s where %s='%s'",tabName,attr,name);
	TRY{
		CRecordset rs(&m_db);
		rs.Open(CRecordset::dynaset,sql);
		if(!rs.IsEOF())
		{
			CDBVariant var;
			rs.GetFieldValue((short)0,var,SQL_C_SLONG);
			if(var.m_dwType!=DBVT_NULL)
				iRet=var.m_iVal;
			var.Clear();
		}
		rs.Close();
		return iRet;
	}
	return -1;
	CATCH(CDBException,ex)
	{
		AfxMessageBox(ex->m_strError);
		AfxMessageBox(ex->m_strStateNativeOrigin);
	}
	AND_CATCH(CMemoryException,pEx)
	{
		pEx->ReportError();
		AfxMessageBox("memory exception");
	}
	AND_CATCH(CException,e)
	{
		TCHAR szError[100];
		e->GetErrorMessage(szError,100);
		AfxMessageBox(szError);
	}
	END_CATCH
	return -1;
}