class.cpp

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

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

#include "stdafx.h"
#include "SM.h"
#include "teacher.h"
#include "Class.h"

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

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

//##ModelId=40A481F70197
Class::Class()
{
	Set(0, _T(""), 0, 0);
}

//##ModelId=40A481F70198
Class::~Class()
{

}

//##ModelId=40A481F70169
inline void Class::Set(long id, CString title, long superior_id, long teacher_id)
{
	ID = id;
	Title = title;
	SuperiorID = superior_id;
	TeacherID = teacher_id;
}

//##ModelId=40A481F70159
Class::Class(long id, CString title, long superior_id, long teacher_id)
{
	Set(id,  title,  superior_id,  teacher_id);
}

//##ModelId=40A481F70157
void Class::AddNew(CDaoRecordset *RS)
{
	RS->AddNew();
	RS->SetFieldValue("Class", LPCTSTR(Title));
	RS->SetFieldValue("superior_id", COleVariant(SuperiorID));
	RS->SetFieldValue("Teacher_ID", COleVariant(TeacherID));
	RS->Update();
	RS->MoveLast();
	ID = RS->GetFieldValue("ID").lVal;
}

//##ModelId=40A481F7014A
void Class::Update(CDaoRecordset *RS)
{
	RS->SetCurrentIndex(_T("ID"));
	if(RS->Seek("=", &COleVariant(ID)))
	{
		RS->Edit();
		RS->SetFieldValue("Class", LPCTSTR(Title));
		RS->SetFieldValue("superior_id", COleVariant(SuperiorID));
		RS->SetFieldValue("Teacher_ID", COleVariant(TeacherID));
		RS->Update();
	}
}

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

//##ModelId=40A481F70139
void Class::Load(CDaoRecordset *RS)
{
	RS->SetCurrentIndex(_T("ID"));
	if(RS->Seek("=", &COleVariant(ID)))
	{
		Title = V_BSTRT(&RS->GetFieldValue("class"));
		SuperiorID = RS->GetFieldValue("superior_ID").lVal;
		TeacherID = RS->GetFieldValue("Teacher_ID").lVal;
	}
}

//##ModelId=40A481F70138
CString Class::GetTeacherName()
{
	CDaoTableDef td(&theDatabase);
	td.Open(_T("Teacher"));
	CDaoRecordset RS;
	RS.Open(&td);
	Teacher t;
	t.ID = TeacherID;
	t.Load(&RS);
	RS.Close();
	td.Close();
	return t.Name;
}