nametable.cpp

用算法来实现一个收费系统

// NameTable.cpp : implementation file
//

#include "stdafx.h"
#include "lanesoft.h"
#include "NameTable.h"
#include "Mainfrm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CNameTable

IMPLEMENT_DYNAMIC(CNameTable, CRecordset)

CNameTable::CNameTable(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CNameTable)
	m_GRADE = 0;
	m_MANID = 0;
	m_MANNAME = _T("");
	m_MANPWD = _T("");
	m_WORK_CLASS = 0;
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CNameTable::GetDefaultConnect()
{
	return _T("ODBC;DSN=hm");
}

CString CNameTable::GetDefaultSQL()
{
	return _T("[dbo].[NAME]");
}

void CNameTable::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CNameTable)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[GRADE]"), m_GRADE);
	RFX_Long(pFX, _T("[MANID]"), m_MANID);
	RFX_Text(pFX, _T("[MANNAME]"), m_MANNAME);
	RFX_Text(pFX, _T("[MANPWD]"), m_MANPWD);
	RFX_Long(pFX, _T("[WORK_CLASS]"), m_WORK_CLASS);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CNameTable diagnostics

#ifdef _DEBUG
void CNameTable::AssertValid() const
{
	CRecordset::AssertValid();
}

void CNameTable::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
void CNameTable::WriteIn(Data_Name *pName)
{
	AddNew();
	m_GRADE = pName->m_nGreade;
	m_MANID = pName->m_nManNo;
	m_MANNAME = pName->m_sManName;
	m_MANPWD =	pName->m_sPassword;
	m_WORK_CLASS = pName->m_nWork_Class;
	Update();
//	Requery() ;hm 2001.10.18

}