account.cpp

课程设计的简单Access学生数据库系统

// Account.cpp: implementation of the Account class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "sm.h"
#include "Account.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

//##ModelId=40A481F800BE
Account::Account()
{
	Set(0, "", "");
}

//##ModelId=40A481F800CB
Account::~Account()
{
	
}

//##ModelId=40A481F800BC
void Account::AddNew(CDaoRecordset *RS)
{
	RS->AddNew();
	RS->SetFieldValue("name", LPCSTR(Name));
	RS->SetFieldValue("pass", LPCSTR(Pass));
	RS->Update();
	RS->MoveLast();
	ID = RS->GetFieldValue("ID").lVal;
}

//##ModelId=40A481F800AE
void Account::Delete(CDaoRecordset *RS)
{
	if(ID==1)
	{
		AfxMessageBox("不能删除学校名称!");
		return;
	}
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
		RS->Delete();
}

//##ModelId=40A481F800AC
void Account::Update(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
		RS->Edit();
		if(ID!=1)
			RS->SetFieldValue("name", LPCSTR(Name));
		RS->SetFieldValue("pass", LPCSTR(Pass));
		RS->Update();
	}
}

//##ModelId=40A481F8009E
void Account::Load(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
		Name = V_BSTRT(&RS->GetFieldValue(_T("name")));
		Pass = V_BSTRT(&RS->GetFieldValue(_T("pass")));
	}
}

//##ModelId=40A481F80081
void Account::Set(long id, CString name, CString pass)
{
	ID = id, Name = name, Pass = pass;
}

//##ModelId=40A481F8007D
Account::Account(long id, CString name, CString pass)
{
	Set(id, name, pass);
}