student.cpp

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

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

#include "stdafx.h"
#include "Student.h"

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

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

//##ModelId=40A481F301B6
Student::Student()
{
	ID = 0;
	Name = "";
	Sex = true;
	Birthday.ParseDateTime("1980-1-1") ;
	Num =  0;
	EMail = "";
	Remark = "";
}

//##ModelId=40A481F301B7
Student::~Student()
{

}

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

//##ModelId=40A481F301A5
void Student::AddNew(CDaoRecordset *RS)
{
	RS->AddNew();
	RS->SetFieldValue("Name", LPCSTR(Name));
	RS->SetFieldValue("Sex", COleVariant(short(Sex?-1:0), VT_BOOL));
	RS->SetFieldValue("remark", LPCSTR(Remark));
	RS->SetFieldValue("birthday", Birthday);
	RS->SetFieldValue("number", COleVariant(Num));
	RS->SetFieldValue("Class_ID", COleVariant(ClassID));
	RS->SetFieldValue("EMail", LPCSTR(EMail));
	RS->Update();
	RS->MoveLast();
	ID = RS->GetFieldValue("ID").lVal;
}

//##ModelId=40A481F30197
void Student::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("remark", LPCSTR(Remark));
		RS->SetFieldValue("birthday", Birthday);
		RS->SetFieldValue("number", COleVariant(Num));
		RS->SetFieldValue("Class_ID", COleVariant(ClassID));
		RS->SetFieldValue("EMail", LPCSTR(EMail));
		RS->Update();
	}	
}

//##ModelId=40A481F30187
void Student::Load(CDaoRecordset *RS)
{
	RS->SetCurrentIndex("ID");
	if(RS->Seek("=", &COleVariant(ID)))
	{
	//	ID = RS->GetFieldValue(_T("ID")).lVal;
		Name = V_BSTRT(&RS->GetFieldValue(_T("Name")));
		Sex = RS->GetFieldValue(_T("Sex")).boolVal==-1;;
		Birthday = RS->GetFieldValue(_T("birthday"));
		Num =  RS->GetFieldValue(_T("num")).lVal;
		EMail = V_BSTRT(&RS->GetFieldValue("EMail"));
		Remark = V_BSTRT(&RS->GetFieldValue("Remark"));
		ClassID = RS->GetFieldValue(_T("Class_ID")).lVal;
	}
}

//##ModelId=40A481F3011D
void Student::Set(int id, CString name, bool sex, COleDateTime birthday, long classid, long num, CString email, CString remark)
{
	ID = id;
	Name = name;
	Sex = sex;
	Birthday = birthday;
	Num =  num;
	EMail = email;
	Remark = remark;
	ClassID = classid;
}

//##ModelId=40A481F30109
Student::Student(int id, CString name, bool sex, COleDateTime birthday, long classid, long num, CString email, CString remark)
{
	Set( id,  name,  sex,  birthday,  classid, num,  email,  remark);
}