moneyset.cpp

VC6数据库开发指南

// MoneySet.cpp : implementation file
//

#include "stdafx.h"
#include "manager.h"
#include "MoneySet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMoneySet

IMPLEMENT_DYNAMIC(CMoneySet, CDaoRecordset)

//记录集初始化
CMoneySet::CMoneySet(CDaoDatabase* pdb)
	: CDaoRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMoneySet)
	m_date = (DATE)0;
	m_salaryIn = 0;
	m_otherIn = 0;
	m_sumIn = 0;
	m_clothOut = 0;
	m_bigOut = 0;
	m_sumOut = 0;
	m_sumAll = 0;
	m_memo = _T("");
	m_foodOut = 0;
	m_nFields = 10;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dbOpenDynaset;
}


//缺省情况下记录集所使用的数据库
CString CMoneySet::GetDefaultDBName()
{
	char path[50];
	CString m_strDatabaseName;
    ::GetCurrentDirectory(50,path);
	strcat(path,"\\");
	m_strDatabaseName=_T(path);
	m_strDatabaseName+="Family.mdb";//得到数据库文件的路径
	return m_strDatabaseName;
}

//缺省情况下记录集所使用的数据库表
CString CMoneySet::GetDefaultSQL()
{
	return _T("[帐簿]");
}

//记录集与数据库表字段之间的数据交换
void CMoneySet::DoFieldExchange(CDaoFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMoneySet)
	pFX->SetFieldType(CDaoFieldExchange::outputColumn);
	DFX_DateTime(pFX, _T("[日期]"), m_date);
	DFX_Long(pFX, _T("[工资收入]"), m_salaryIn);
	DFX_Long(pFX, _T("[其它收入]"), m_otherIn);
	DFX_Long(pFX, _T("[总收入]"), m_sumIn);
	DFX_Long(pFX, _T("[添置衣物]"), m_clothOut);
	DFX_Long(pFX, _T("[购置大件]"), m_bigOut);
	DFX_Long(pFX, _T("[总支出]"), m_sumOut);
	DFX_Long(pFX, _T("[合计]"), m_sumAll);
	DFX_Text(pFX, _T("[备注]"), m_memo);
	DFX_Long(pFX, _T("[食品消费]"), m_foodOut);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMoneySet diagnostics

#ifdef _DEBUG
void CMoneySet::AssertValid() const
{
	CDaoRecordset::AssertValid();
}

void CMoneySet::Dump(CDumpContext& dc) const
{
	CDaoRecordset::Dump(dc);
}
#endif //_DEBUG