userset.cpp

适合MFC初学者学习

// UserSet.cpp : implementation file
//

#include "stdafx.h"
#include "LLL.h"
#include "UserSet.h"

#include "UserManage.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUserSet

IMPLEMENT_DYNAMIC(CUserSet, CRecordset)

CUserSet::CUserSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CUserSet)
	m_ID = 0;
	m_UserName = _T("");
	m_Popedom = _T("");
	m_PassWord = _T("");
	m_info = _T("");
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CUserSet::GetDefaultSQL()
{
	return _T("[UserInfoTable]");
}

void CUserSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CUserSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[编号]"), m_ID);
	RFX_Text(pFX, _T("[用户名]"), m_UserName);
	RFX_Text(pFX, _T("[用户类型]"), m_Popedom);
	RFX_Text(pFX, _T("[用户密码]"), m_PassWord);
	RFX_Text(pFX, _T("[借阅信息]"), m_info);
	//}}AFX_FIELD_MAP
}

void CUserSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CUserSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}

//添加用户进表
bool CUserSet::AddUser(const CUser newUser)
{
	Open();
	AddNew();
	m_ID = newUser.m_uID;
	m_UserName = newUser.m_strUserName;
	m_PassWord = newUser.m_strPassword;
	m_Popedom = newUser.m_strPopedom;
	m_info = newUser.m_strinfo;
	if (!Update())
	{
		Close();
		return false;
	}
	Close();
	return true;
}

//从表中删除用户
bool CUserSet::DeleteUser(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 CUserSet::EditUser(CUser newUser)
{
	CString strSql;
	strSql.Format("select * from UserTable where ID = %d", newUser.m_uID);
	Open(AFX_DB_USE_DEFAULT_TYPE, strSql);
	if (!IsEOF())
	{
		Edit();
		m_PassWord = newUser.m_strPassword;
	}
	if (!Update())
	{
		Close();
		return false;
	}
	Close();
	return true;
}

/////////////////////////////////////////////////////////////////////////////
// CUserSet diagnostics

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