public static void LoadData()
{
AccessHelper ah = new AccessHelper();
foreach (UDT_ClassRoomLayout udtLayout in ah.Select<UDT_ClassRoomLayout>())
{
ClassRoomLayout layout = new ClassRoomLayout(udtLayout);
layouts.Add(layout);
dicLayouts.Add(layout.UID, layout);
}
}
private void frmSeatTable_Load(object sender, EventArgs e)
{
this.MaximizeBox = true;
if (K12.Presentation.NLDPanels.Course.SelectedSource.Count < 1)
{
MessageBox.Show("請選擇課程");
return;
}
//1. 取得目前選取的課程
AccessHelper ah = new AccessHelper();
this.currentCourseID = K12.Presentation.NLDPanels.Course.SelectedSource[0];
K12.Data.CourseRecord rec = K12.Data.Course.SelectByID(this.currentCourseID);
this.expandablePanel1.TitleText = rec.Name;
List<UDT.CourseExt> course_exts = ah.Select<UDT.CourseExt>("ref_course_id=" + this.currentCourseID);
if (course_exts.Count == 0)
this.currentCourseExt = null;
else
{
this.currentCourseExt = course_exts[0];
this.expandablePanel1.TitleText = rec.Name + " ( " + this.currentCourseExt.SubjectCode + " )";
}
//2. 取得所有的座位表樣版
this.allLayouts = new List<ClassRoomLayout>();
List<UDT_ClassRoomLayout> udtLayouts =(new AccessHelper()).Select<UDT_ClassRoomLayout>();
foreach(UDT_ClassRoomLayout udtL in udtLayouts)
{
ClassRoomLayout lt = new ClassRoomLayout(udtL);
this.allLayouts.Add(lt);
this.cboLayouts.Items.Add(lt);
//this.cboLayouts.SelectedIndex = 0;
}
//3. 取得此課程的座位表樣版
this.layout = this.allLayouts[0]; //預設 layout
List<UDT.CourseExt> course_ext = ah.Select<UDT.CourseExt>("ref_course_id=" + this.currentCourseID );
if ((course_ext.Count ==0) || (course_ext[0].ClassroomLayoutID == null)) {
//採預設 layout，所以不作任何事。
}
else {
foreach(ClassRoomLayout crl in this.allLayouts) {
if (this.currentCourseExt.ClassroomLayoutID.ToString() == crl.UID ) {
this.layout = crl ;
break ;
}
}
}
this.currentCourseExt.ClassroomLayoutID = int.Parse(this.layout.UID);
//4. 取得修課學生
this.GetSCAttendExt();
//5. 指定課程的座位樣版
this.cboLayouts.SelectedItem = this.layout ; //會觸發 selectedindex_change 事件
}
private void cboLayouts_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboLayouts.SelectedItem == null)
return ;
this.layout = (ClassRoomLayout)cboLayouts.SelectedItem;
this.pnlContainer.Text = this.layout.ClassRoomName;
//畫出課程教室座位分佈圖
DrawClassroomLayout();
//將修課學生的座位資訊填入座位樣版中
this.fillStudentSeatPosition();
//填入修課學生
this.fillListBox();
}