parcelset.cpp

VC实现word 和ACCESS数据库的连接

// ParcelSet.cpp : implementation file
//

#include "stdafx.h"
#include "show.h"
#include "ParcelSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CParcelSet

IMPLEMENT_DYNAMIC(CParcelSet, CDaoRecordset)

CParcelSet::CParcelSet(CDaoDatabase* pdb)
	: CDaoRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CParcelSet)
	m_ProName = _T("");
	m_ParcelId = 0;
	m_LandUser = _T("");
	m_Use = _T("");
	m_Location = _T("");
	m_Area = 0.0f;
	m_PtStr = _T("");
	m_Memo = _T("");
	m_nFields = 8;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dbOpenDynaset;
}


CString CParcelSet::GetDefaultDBName()
{
	return _T(_GetBinDir()+"\\宗地数据库.mdb");
}

CString CParcelSet::GetDefaultSQL()
{
	return _T("SELECT * FROM [宗地]");
}

void CParcelSet::DoFieldExchange(CDaoFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CParcelSet)
	pFX->SetFieldType(CDaoFieldExchange::outputColumn);
	DFX_Text(pFX, _T("[工程名]"), m_ProName);
	DFX_Long(pFX, _T("[宗地号]"), m_ParcelId);
	DFX_Text(pFX, _T("[土地使用单位]"), m_LandUser);
	DFX_Text(pFX, _T("[用途]"), m_Use);
	DFX_Text(pFX, _T("[土地座落]"), m_Location);
	DFX_Single(pFX, _T("[面积（米）]"), m_Area);
	DFX_Text(pFX, _T("[坐标串]"), m_PtStr);
	DFX_Text(pFX, _T("[备注]"), m_Memo);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CParcelSet diagnostics

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

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