productorderset.cpp

一个非常不错的MFC ODBC范例

// ProductOrderSet.cpp : implementation file
//

#include "stdafx.h"
#include "ProductOrderSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProductOrderSet

IMPLEMENT_DYNAMIC(CProductOrderSet, CRecordset)

CProductOrderSet::CProductOrderSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CProductOrderSet)
	m_CategoryName = _T("");
	m_ProductName = _T("");
	m_UnitPrice = _T("");
	m_QuantityPerUnit = _T("");
	m_Quantity = 0;
	m_Discount = 0.0f;
	m_ProductID = 0;
	m_CategoryID = 0;
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CProductOrderSet::GetDefaultConnect()
{
	//return _T("ODBC;DSN=MyNWind");
	return _T("ODBC;DSN=MyNWind;UID=sa;PWD=''");
}

CString CProductOrderSet::GetDefaultSQL()
{
	return _T("[dbo].[Produt_Order_Details]");
}

void CProductOrderSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CProductOrderSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[CategoryName]"), m_CategoryName);
	RFX_Text(pFX, _T("[ProductName]"), m_ProductName);
	RFX_Date(pFX, _T("[OrderDate]"), m_OrderDate);
	RFX_Text(pFX, _T("[UnitPrice]"), m_UnitPrice);
	RFX_Text(pFX, _T("[QuantityPerUnit]"), m_QuantityPerUnit);
	RFX_Int(pFX, _T("[Quantity]"), m_Quantity);
	RFX_Single(pFX, _T("[Discount]"), m_Discount);
	RFX_Long(pFX, _T("[ProductID]"), m_ProductID);
	RFX_Long(pFX, _T("[CategoryID]"), m_CategoryID);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CProductOrderSet diagnostics

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

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