teaching.cpp

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

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

#include "stdafx.h"
#include "SM.h"
#include "Teaching.h"

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

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

//##ModelId=40A481F101A5
Teaching::Teaching()
{
	Set(0, 0, 0, 0);
}

//##ModelId=40A481F101A6
Teaching::~Teaching()
{

}

//##ModelId=40A481F10178
Teaching::Teaching(long id, long class_id, long subject_id, long teacher_id)
{
	Set( id,  class_id,  subject_id, teacher_id);
}

//##ModelId=40A481F10167
inline void Teaching::Set(long id, long class_id, long subject_id, long teacher_id)
{
	ID = id, ClassID = class_id, SubjectID = subject_id, TeacherID = teacher_id  ;
}

//##ModelId=40A481F1015A
void Teaching::AddNew(CDaoRecordset *RS)
{
	RS->AddNew();
	RS->SetFieldValue("class_id", COleVariant(ClassID));
	RS->SetFieldValue("subject_id", COleVariant(SubjectID));
	RS->SetFieldValue("Teacher_id", COleVariant(TeacherID));
	RS->Update();
	RS->MoveLast();
	ID = RS->GetFieldValue("ID").lVal;
}

//##ModelId=40A481F10158
void Teaching::Load(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
		ClassID = RS->GetFieldValue(_T("class_id")).lVal;
		SubjectID = RS->GetFieldValue(_T("subject_id")).lVal;
		TeacherID = RS->GetFieldValue(_T("Teacher_id")).lVal;
	}	
}

//##ModelId=40A481F1014A
void Teaching::Update(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
		RS->Edit();
		RS->SetFieldValue("class_id", COleVariant(ClassID));
		RS->SetFieldValue("subject_id", COleVariant(SubjectID));
		RS->SetFieldValue("Teacher_id", COleVariant(TeacherID));
		RS->Update();
	}
}

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