roomrecordset.cpp

实现简单的酒店订房系统

// RoomRecordset.cpp : implementation file
//

#include "stdafx.h"
#include "order.h"
#include "RoomRecordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRoomRecordset

IMPLEMENT_DYNAMIC(CRoomRecordset, CRecordset)

CRoomRecordset::CRoomRecordset(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CRoomRecordset)
	m_rid = _T("");
	m_rprice = 0;
	m_rstate = _T("");
	m_rbdate = _T("");
	m_rdays = 0;
	m_rvip = _T("");
	m_rname = _T("");
	m_rsex = _T("");
	m_nFields = 8;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}
int CRoomRecordset::MyGetRecordCount(CRoomRecordset *pSet)
{
	int nCnt=0;
	if(!pSet->IsBOF())
		pSet->MoveFirst();
	while(!pSet->IsEOF())
		pSet->MoveNext();
	nCnt=pSet->GetRecordCount();
	return nCnt;
}
int CRoomRecordset::CheckRoomId(CString str)
{
	CRoomRecordset rs;
	rs.Open();
	rs.m_strFilter="rid='"+str+"' and rstate='N'";
	rs.Requery();
	int num=rs.GetRecordCount();
	return num;
}

CString CRoomRecordset::GetDefaultConnect()
{
	return _T("ODBC;DSN=order1");
}

CString CRoomRecordset::GetDefaultSQL()
{
	return _T("[roominfo]");
}

void CRoomRecordset::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CRoomRecordset)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[rid]"), m_rid);
	RFX_Long(pFX, _T("[rprice]"), m_rprice);
	RFX_Text(pFX, _T("[rstate]"), m_rstate);
	RFX_Text(pFX, _T("[rbdate]"), m_rbdate);
	RFX_Long(pFX, _T("[rdays]"), m_rdays);
	RFX_Text(pFX, _T("[rvip]"), m_rvip);
	RFX_Text(pFX, _T("[rname]"), m_rname);
	RFX_Text(pFX, _T("[rsex]"), m_rsex);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CRoomRecordset diagnostics

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

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