productset.cpp

使用vc进行数据库编程的好例子

// ProductSet.cpp : implementation file
//

#include "stdafx.h"
#include "ManageSystem.h"
#include "ProductSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProductSet

IMPLEMENT_DYNAMIC(CProductSet, CRecordset)

CProductSet::CProductSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CProductSet)
	m_prodt_name = _T("");
	m_class_id = 0;
	m_specification = _T("");
	m_producing_area = _T("");
	m_provide_area = _T("");
	m_amount = 0;
	m_unit_price = _T("");
	m_company_name = _T("");
	m_company_addr = _T("");
	m_linkman = _T("");
	m_comp_telephone = _T("");
	m_prodt_resume = _T("");
	m_picture_addr = _T("");
	m_nFields = 13;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CProductSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=KeChengSheJi");
}

CString CProductSet::GetDefaultSQL()
{
	return _T("[dbo].[productinfo]");
}

void CProductSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CProductSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[prodt_name]"), m_prodt_name);
	RFX_Long(pFX, _T("[class_id]"), m_class_id);
	RFX_Text(pFX, _T("[specification]"), m_specification);
	RFX_Text(pFX, _T("[producing_area]"), m_producing_area);
	RFX_Text(pFX, _T("[provide_area]"), m_provide_area);
	RFX_Long(pFX, _T("[amount]"), m_amount);
	RFX_Text(pFX, _T("[unit_price]"), m_unit_price);
	RFX_Text(pFX, _T("[company_name]"), m_company_name);
	RFX_Text(pFX, _T("[company_addr]"), m_company_addr);
	RFX_Text(pFX, _T("[linkman]"), m_linkman);
	RFX_Text(pFX, _T("[comp_telephone]"), m_comp_telephone);
	RFX_Text(pFX, _T("[prodt_resume]"), m_prodt_resume);
	RFX_Text(pFX, _T("[picture_addr]"), m_picture_addr);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CProductSet diagnostics

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

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