teacher.cpp

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

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

#include "stdafx.h"
#include "SM.h"
#include "Teacher.h"

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

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

//##ModelId=40A481F20020
Teacher::Teacher()
{
	ID = 0;
	Name = _T("");
	Sex = true;
	Tele = _T("");
	Mail = _T("");
}

//##ModelId=40A481F20021
Teacher::~Teacher()
{

}

//##ModelId=40A481F103D8
void Teacher::Set(long id, CString name, bool sex, CString tele, CString mail)
{
	ID = id;
	Name = name;
	Sex = sex;
	Tele = tele;
	Mail = mail;
}

//##ModelId=40A481F103C9
void Teacher::AddNew(CDaoRecordset *RS)
{
	RS->AddNew();
	RS->SetFieldValue("Name", LPCSTR(Name));
	RS->SetFieldValue("Sex", COleVariant(short(Sex?-1:0), VT_BOOL));
	RS->SetFieldValue("Tele", LPCSTR(Tele));
	RS->SetFieldValue("EMail", LPCSTR(Mail));
	RS->Update();
	RS->MoveLast();
	ID = RS->GetFieldValue("ID").lVal;
}

//##ModelId=40A481F103BD
void Teacher::Load(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
		Sex = RS->GetFieldValue(_T("Sex")).boolVal==-1;
		Name = V_BSTRT(&RS->GetFieldValue(_T("Name")));
		Tele = V_BSTRT(&RS->GetFieldValue(_T("Tele")));
		Mail = V_BSTRT(&RS->GetFieldValue("EMail"));
	}
}

//##ModelId=40A481F103BB
void Teacher::Update(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
		RS->Edit();
		RS->SetFieldValue("Name", LPCSTR(Name));
		RS->SetFieldValue("Sex", COleVariant(short(Sex?-1:0), VT_BOOL));
		RS->SetFieldValue("Tele", LPCSTR(Tele));
		RS->SetFieldValue("EMail", LPCSTR(Mail));
		RS->Update();
	}
	
}

//##ModelId=40A481F103B9
void Teacher::Delete(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
		RS->Delete();
}

//##ModelId=40A481F1039A
Teacher::Teacher(long id, CString name, bool sex, CString tele, CString mail)
{
	Set( id,  name,  sex,  tele,  mail);
}