addhbdataset.cpp

环保局污染设备在线控制系统

// Written by JHCC, 1997

// AddHBDataSet.cpp : implementation file
//

#include "stdafx.h"
#include "JHHB.h"
#include "AddHBDataSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddHBDataSet

IMPLEMENT_DYNAMIC(CAddHBDataSet, CRecordset)

CAddHBDataSet::CAddHBDataSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CAddHBDataSet)
	m_NO = 0.0;
	m_STATION = 0.0;
	m_PHTIME = _T("");
	m_PH = 0.0;
	m_SHARED = FALSE;
	m_COD = 0.0;
	m_FLOW = 0.0;
	m_NH4N = 0.0;
	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'})");

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

void	CAddHBDataSet::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 CAddHBDataSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=JHHB");
}

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

void CAddHBDataSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CAddHBDataSet)
	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_Bool(pFX, _T("[SHARED]"), m_SHARED);
	RFX_Double(pFX, _T("[COD]"), m_COD);
	RFX_Double(pFX, _T("[FLOW]"), m_FLOW);
	RFX_Double(pFX, _T("[NH4N]"), m_NH4N);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CAddHBDataSet diagnostics

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

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