daohbrecset.cpp

串口调试助手的源代码

// Written by JHCC, 1997

// DaoHBRecSet.cpp : implementation file
//

#include "stdafx.h"
#include "JHHB.h"
#include "DaoHBRecSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDaoHBRecSet

IMPLEMENT_DYNAMIC(CDaoHBRecSet, CDaoRecordset)

CDaoHBRecSet::CDaoHBRecSet(CDaoDatabase* pdb)
	: CDaoRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CDaoHBRecSet)
	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 = dbOpenDynaset;

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

	m_strFilterStationFmt = _T("([STATION] = %f))");
	m_strFilterOrderBy = _T(" Order by [NO] ASC");
}

void	CDaoHBRecSet::GenParam(COleDateTime  time, int  nStation)
{
	CString	strFilterFmt = time.Format(m_strFilterDateFmt);
	strFilterFmt += _T(" AND ");
	strFilterFmt += m_strFilterStationFmt;
	m_strFilter.Format(strFilterFmt, (double)nStation);	
	m_strFilter += m_strFilterOrderBy;
}

CString CDaoHBRecSet::GetDefaultDBName()
{
	ASSERT(FALSE);
	return  _T("");
}

CString CDaoHBRecSet::GetDefaultSQL()
{
	ASSERT(FALSE);
	return  _T("");
}

void CDaoHBRecSet::DoFieldExchange(CDaoFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CDaoHBRecSet)
	pFX->SetFieldType(CDaoFieldExchange::outputColumn);
	DFX_Double(pFX, _T("[NO]"), m_NO);
	DFX_Double(pFX, _T("[STATION]"), m_STATION);
	DFX_DateTime(pFX, _T("[PHDATE]"), m_PHDATE);
	DFX_Text(pFX, _T("[PHTIME]"), m_PHTIME);
	DFX_Double(pFX, _T("[PH]"), m_PH);
	DFX_Double(pFX, _T("[COD]"), m_COD);
	DFX_Double(pFX, _T("[FLOW]"), m_FLOW);
	DFX_Double(pFX, _T("[NH4N]"), m_NH4N);
	DFX_Bool(pFX, _T("[SHARED]"), m_SHARED);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CDaoHBRecSet diagnostics

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

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