mylibraryset.cpp

适合MFC初学者学习

// MyLibrarySet.cpp : implementation file
//

#include "stdafx.h"
#include "LLL.h"
#include "MyLibrarySet.h"
#include "BookManage.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMyLibrarySet

IMPLEMENT_DYNAMIC(CMyLibrarySet, CRecordset)

CMyLibrarySet::CMyLibrarySet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMyLibrarySet)
	m_ID = 0;
	m_number = _T("");
	m_type = _T("");
	m_name = _T("");
	m_auther = _T("");
	m_editer = _T("");
	m_inlibrary = _T("");
	m_borrowman = _T("");
	m_nFields = 8;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CMyLibrarySet::GetDefaultConnect()
{
	return _T("ODBC;DSN=Library");
}

CString CMyLibrarySet::GetDefaultSQL()
{
	return _T("[BookInfoTable]");
}

void CMyLibrarySet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMyLibrarySet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[编号]"), m_ID);
	RFX_Text(pFX, _T("[书号]"), m_number);
	RFX_Text(pFX, _T("[类型]"), m_type);
	RFX_Text(pFX, _T("[书名]"), m_name);
	RFX_Text(pFX, _T("[作者]"), m_auther);
	RFX_Text(pFX, _T("[出版社]"), m_editer);
	RFX_Text(pFX, _T("[是否在馆]"), m_inlibrary);
	RFX_Text(pFX, _T("[借书人]"), m_borrowman);
	//}}AFX_FIELD_MAP
}

//添加用户进表
bool CMyLibrarySet::AddBook(const CBook newBook)
{
	Open();
	AddNew();
	m_ID = newBook.m_uID;
	m_number = newBook.m_strnumber;
	m_type = newBook.m_strtype;
	m_name = newBook.m_strname;
	m_auther = newBook.m_strauther;
	m_editer = newBook.m_strediter;
	m_inlibrary = newBook.m_strinlibrary;
	m_borrowman = newBook.m_strborrowman;
	if (!Update())
	{
		Close();
		return false;
	}
	Close();
	return true;
}

//从表中删除用户
bool CMyLibrarySet::DeleteBook(UINT uID)
{
	CString strSql;
	strSql.Format("select * from UserTable where ID = %d", uID);
	Open(AFX_DB_USE_DEFAULT_TYPE, strSql);
	Delete();
	if (!Update())
		{
			Close();
			return false;
		}
		Close();
		return true;
}

//编辑用户
bool CMyLibrarySet::EditBook(CBook newBook)
{
	CString strSql;
	strSql.Format("select * from UserTable where ID = %d", newBook.m_uID);
	Open(AFX_DB_USE_DEFAULT_TYPE, strSql);
	if (!IsEOF())
	{
		Edit();
		m_ID = newBook.m_uID;
		m_number = newBook.m_strnumber;
		m_type = newBook.m_strtype;
		m_name = newBook.m_strname;
		m_auther = newBook.m_strauther;
		m_editer = newBook.m_strediter;
		//另外两项保持不变
	}
	if (!Update())
	{
		Close();
		return false;
	}
	Close();
	return true;
}

/////////////////////////////////////////////////////////////////////////////
// CMyLibrarySet diagnostics

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

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