hangban_recordset.cpp

航空管理系统 用vc6.0开发环境 odbc连接

// hangban_Recordset.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "hangban_Recordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// Changban_Recordset

IMPLEMENT_DYNAMIC(Changban_Recordset, CRecordset)

Changban_Recordset::Changban_Recordset(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(Changban_Recordset)
	m_column1 = _T("");
	m_column2 = _T("");
	m_column3 = _T("");
	m_column4 = _T("");
	m_column5 = _T("");
	m_column6 = _T("");
	m_column7 = 0;
	m_column8 = 0;
	m_column9 = 0;
	m_column10 = 0;
	m_column11 = 0;
	m_column12 = 0;
	m_column13 = 0;
	m_column14 = 0;
	m_column15 = 0;
	m_column16 = 0;
	m_column17 = 0;
	m_column18 = 0;
	m_column19 = 0;
	m_column20 = 0;
	m_column21 = 0;
	m_column22 = _T("");
	m_nFields = 22;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString Changban_Recordset::GetDefaultConnect()
{
	return _T("ODBC;DSN=hk");
}

CString Changban_Recordset::GetDefaultSQL()
{
	return _T("[dbo].[hk_hangban]");
}

void Changban_Recordset::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(Changban_Recordset)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[航班编号]"), m_column1);
	RFX_Text(pFX, _T("[航班姓名]"), m_column2);
	RFX_Text(pFX, _T("[起始地]"), m_column3);
	RFX_Text(pFX, _T("[航班时间]"), m_column4);
	RFX_Text(pFX, _T("[目的地]"), m_column5);
	RFX_Text(pFX, _T("[到达时间]"), m_column6);
	RFX_Long(pFX, _T("[一等仓单价]"), m_column7);
	RFX_Long(pFX, _T("[一等仓售票数]"), m_column8);
	RFX_Long(pFX, _T("[一等仓余票数]"), m_column9);
	RFX_Long(pFX, _T("[一等仓售票额]"), m_column10);
	RFX_Long(pFX, _T("[二等仓单价]"), m_column11);
	RFX_Long(pFX, _T("[二等仓售票数]"), m_column12);
	RFX_Long(pFX, _T("[二等仓余票数]"), m_column13);
	RFX_Long(pFX, _T("[二等仓售票额]"), m_column14);
	RFX_Long(pFX, _T("[三等仓单价]"), m_column15);
	RFX_Long(pFX, _T("[三等仓售票数]"), m_column16);
	RFX_Long(pFX, _T("[三等仓余票数]"), m_column17);
	RFX_Long(pFX, _T("[三等仓售票额]"), m_column18);
	RFX_Long(pFX, _T("[售票总金额]"), m_column19);
	RFX_Long(pFX, _T("[开资]"), m_column20);
	RFX_Long(pFX, _T("[利润]"), m_column21);
    RFX_Text(pFX, _T("[时间]"), m_column22);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// Changban_Recordset diagnostics

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

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