ubiset.cpp

采用MFC+SQLSERVER 2000的图书管理系统,ODBC方式连接数据库。功能包括 书籍管理

// UBISet.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "UBISet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUBISet

IMPLEMENT_DYNAMIC(CUBISet, CRecordset)

CUBISet::CUBISet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CUBISet)
	m_Bid = _T("");
	m_Bisbn = _T("");
	m_Bname = _T("");
	m_Bauthor = _T("");
	m_Bpress = _T("");
	m_Btheme = _T("");
	m_Bclassify = _T("");
	m_Binds = _T("");
	m_Bprice = _T("");
	m_Bseriesname = _T("");
	m_Bdescribe = _T("");
	m_Btiaoma = _T("");
	m_Iid = 0;
	m_Ibid = _T("");
	m_Iuid = _T("");
	m_Irenew = 0;
	m_Istate = 0;
	m_Uid = _T("");
	m_Upassword = _T("");
	m_Upower = 0;
	m_Usex = FALSE;
	m_Uname = _T("");
	m_Uaddress = _T("");
	m_Utel = _T("");
	m_Uemail = _T("");
	m_Uclass = _T("");
	m_Udepartment = _T("");
	m_Umajor = _T("");
	m_Uclassno = _T("");
	m_Ucorporation = _T("");
	m_Ureadstat = FALSE;
	m_nFields = 34;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CUBISet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MySQL");
}

CString CUBISet::GetDefaultSQL()
{
	return _T("[dbo].[BOOK],[dbo].[BORROWINFORM],[dbo].[USERS]");
}

void CUBISet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CUBISet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[Bid]"), m_Bid);
	RFX_Text(pFX, _T("[Bisbn]"), m_Bisbn);
	RFX_Text(pFX, _T("[Bname]"), m_Bname);
	RFX_Text(pFX, _T("[Bauthor]"), m_Bauthor);
	RFX_Text(pFX, _T("[Bpress]"), m_Bpress);
	RFX_Text(pFX, _T("[Btheme]"), m_Btheme);
	RFX_Text(pFX, _T("[Bclassify]"), m_Bclassify);
	RFX_Text(pFX, _T("[Binds]"), m_Binds);
	RFX_Text(pFX, _T("[Bprice]"), m_Bprice);
	RFX_Text(pFX, _T("[Bseriesname]"), m_Bseriesname);
	RFX_Text(pFX, _T("[Bdescribe]"), m_Bdescribe);
	RFX_Text(pFX, _T("[Btiaoma]"), m_Btiaoma);
	RFX_Long(pFX, _T("[Iid]"), m_Iid);
	RFX_Text(pFX, _T("[Ibid]"), m_Ibid);
	RFX_Text(pFX, _T("[Iuid]"), m_Iuid);
	RFX_Date(pFX, _T("[Ibegindate]"), m_Ibegindate);
	RFX_Date(pFX, _T("[Ienddate]"), m_Ienddate);
	RFX_Long(pFX, _T("[Irenew]"), m_Irenew);
	RFX_Date(pFX, _T("[Irealdate]"), m_Irealdate);
	RFX_Long(pFX, _T("[Istate]"), m_Istate);
	RFX_Text(pFX, _T("[Uid]"), m_Uid);
	RFX_Text(pFX, _T("[Upassword]"), m_Upassword);
	RFX_Long(pFX, _T("[Upower]"), m_Upower);
	RFX_Bool(pFX, _T("[Usex]"), m_Usex);
	RFX_Text(pFX, _T("[Uname]"), m_Uname);
	RFX_Text(pFX, _T("[Uaddress]"), m_Uaddress);
	RFX_Text(pFX, _T("[Utel]"), m_Utel);
	RFX_Text(pFX, _T("[Uemail]"), m_Uemail);
	RFX_Text(pFX, _T("[Uclass]"), m_Uclass);
	RFX_Text(pFX, _T("[Udepartment]"), m_Udepartment);
	RFX_Text(pFX, _T("[Umajor]"), m_Umajor);
	RFX_Text(pFX, _T("[Uclassno]"), m_Uclassno);
	RFX_Text(pFX, _T("[Ucorporation]"), m_Ucorporation);
	RFX_Bool(pFX, _T("[Ureadstat]"), m_Ureadstat);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CUBISet diagnostics

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

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