routeset.cpp

汽车站售票管理系统,源代码完整无错

// RouteSet.cpp : implementation file
//

#include "stdafx.h"
#include "StationManage.h"
#include "RouteSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRouteSet

IMPLEMENT_DYNAMIC(CRouteSet, CRecordset)

CRouteSet::CRouteSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CRouteSet)
	m_route_id = 0;
	m_route = _T("");
	m_start = _T("");
	m_end = _T("");
	m_distance = 0.0;
	m_drivetime = 0.0;
	m_price = 0.0;
	m_nFields = 7;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CRouteSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=StationManage");
}

CString CRouteSet::GetDefaultSQL()
{
	return _T("[dbo].[route]");
}

void CRouteSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CRouteSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[route_id]"), m_route_id);
	RFX_Text(pFX, _T("[route]"), m_route);
	RFX_Text(pFX, _T("[start]"), m_start);
	RFX_Text(pFX, _T("[end]"), m_end);
	RFX_Double(pFX, _T("[distance]"), m_distance);
	RFX_Double(pFX, _T("[drivetime]"), m_drivetime);
	RFX_Double(pFX, _T("[price]"), m_price);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CRouteSet diagnostics

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

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

CRouteSet * CRouteSet::SearchById(int routeid)
{
	if (!this->IsOpen())
	{
		this->Open();
	}	
	this->MoveFirst();
	while (!this->IsEOF())
	{
		if (this->m_route_id==routeid)
		{
			return this;
		}
		else
		{
			this->MoveNext();
		}
	}
	if (this->IsEOF())
	{
		return NULL;
	}
}