teachinglist.cpp

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

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

#include "stdafx.h"
#include "SM.h"
#include "teacher.h"
#include "teaching.h"
#include "baselist.h"
#include "TeachingList.h"

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

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

//##ModelId=40A481F1002F
TeachingList::TeachingList(CListCtrl *plist):BaseList(plist)
{
	
}

//##ModelId=40A481F10031
TeachingList::~TeachingList()
{

}

//##ModelId=40A481F10024
void TeachingList::LoadData(long class_id)
{
	CString sql, s;
	s.Format("%ld", class_id);
	sql = "SELECT * from teachinglist WHERE teaching.class_id = " + s ;
	Teachings.clear();
	CDaoQueryDef QD(&theDatabase);
	CDaoRecordset RS;
	QD.Create(NULL, sql);
	RS.Open(&QD);
	while(!RS.IsEOF())
	{
		Teachings.push_back(ListData(Teaching(RS.GetFieldValue("ID").lVal,
											RS.GetFieldValue("class_id").lVal,
											RS.GetFieldValue("subject_id").lVal,
											RS.GetFieldValue("teacher_id").lVal
											),
									 V_BSTRT(&RS.GetFieldValue("subject")),
								     V_BSTRT(&RS.GetFieldValue("name"))
								   )
						   );
		RS.MoveNext();
	}
	RS.Close();
	QD.Close();
}

//##ModelId=40A481F10003
void TeachingList::Clear()
{
	BaseList::Clear();
	Teachings.clear();
}

//##ModelId=40A481F10002
void TeachingList::Init()
{
	pList->InsertColumn(0, _T("科目"), LVCFMT_LEFT, 75);
	pList->InsertColumn(1, _T("教师"), LVCFMT_LEFT, 76);
}

//##ModelId=40A481F10000
void TeachingList::Load(long class_id)
{
	Clear();
	LoadData(class_id);
	int i = 0;
	for(vector<ListData>::iterator iter=Teachings.begin(); iter!=Teachings.end(); iter++, i++)
	{
		pList->InsertItem(i, iter->SubjectTitle);
		pList->SetItem(i, 1, LVIF_TEXT, iter->TeacherName, 0, 0, 0, 0);
		pList->SetItemData(i, i);
	}
	pList->SetItemState(0, LVIS_SELECTED|LVIS_FOCUSED, LVIS_SELECTED|LVIS_FOCUSED);
}

//##ModelId=40A481F003D9
void TeachingList::Search(CString subject)
{
	SetSelected(Find(0, subject));
}

//##ModelId=40A481F003D8
Teaching& TeachingList::GetSelectTeaching()
{
	return Teachings[GetSelectedData()].TeachingData;
}