hbdatedataset.cpp

串口调试助手的源代码

// Written by JHCC, 1997

// HBDateDataSet.cpp : implementation file
//

#include "stdafx.h"
#include "JHHB.h"
#include "HBDateDataSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CHBDateDataSet

IMPLEMENT_DYNAMIC(CHBDateDataSet, CRecordset)

CHBDateDataSet::CHBDateDataSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CHBDateDataSet)
	m_NO = 0.0;
	m_STATION = 0.0;
	m_PHTIME = _T("");
	m_PH = 0.0;
	m_COD = 0.0;
	m_FLOW = 0.0;
	m_NH4N = 0.0;
	m_SHARED = FALSE;
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;

//	m_strFilterDateFmt = _T("[PHDATE] = DateValue('%Y-%m-%d')");
	m_strFilterDateFmt = _T("[PHDATE] = {d '%Y-%m-%d'}");
}

void	CHBDateDataSet::GenParam(COleDateTime  time)
{
	m_strFilter = time.Format(m_strFilterDateFmt);
}

CString CHBDateDataSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=JHHB");
}

CString CHBDateDataSet::GetDefaultSQL()
{
	return _T("[HBDATA]");
}

void CHBDateDataSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CHBDateDataSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Double(pFX, _T("[NO]"), m_NO);
	RFX_Double(pFX, _T("[STATION]"), m_STATION);
	RFX_Date(pFX, _T("[PHDATE]"), m_PHDATE);
	RFX_Text(pFX, _T("[PHTIME]"), m_PHTIME);
	RFX_Double(pFX, _T("[PH]"), m_PH);
	RFX_Double(pFX, _T("[COD]"), m_COD);
	RFX_Double(pFX, _T("[FLOW]"), m_FLOW);
	RFX_Double(pFX, _T("[NH4N]"), m_NH4N);
	RFX_Bool(pFX, _T("[SHARED]"), m_SHARED);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CHBDateDataSet diagnostics

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

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