public DetailViewForm(string CourseID)
{
InitializeComponent();
List <AssignmentExamSCAttendRecord> records = AssignmentExamSCAttend.SelectByCourseID(CourseID);
AssignmentExamCourseRecord course = AssignmentExamCourse.SelectByID(CourseID);
mCourseName = course.Name;
mSchoolYear = "" + course.SchoolYear;
mSemester = "" + course.Semester;
Dictionary <string, string> Scores = new Dictionary <string, string>();
foreach (AssignmentExamSetupRecord setuprecord in course.ExamSetups)
{
if (!Scores.ContainsKey(setuprecord.SubExamID))
{
Scores.Add(setuprecord.SubExamID, "");
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.FillWeight = 33;
column.HeaderText = setuprecord.Name;
column.Name = setuprecord.SubExamID;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvDetail.Columns.Add(column);
}
}
if (course != null)
{
foreach (AssignmentExamSCAttendRecord record in records)
{
Dictionary <string, string> CurSocres = new Dictionary <string, string>();
foreach (string Key in Scores.Keys)
{
if (!CurSocres.ContainsKey(Key))
{
CurSocres.Add(Key, Scores[Key]);
}
}
foreach (AssignmentExamRecord aerecord in record.AssignmentExams)
{
if (CurSocres.ContainsKey(aerecord.SubExamID))
{
CurSocres[aerecord.SubExamID] = K12.Data.Decimal.GetString(aerecord.Score);
}
}
List <object> values = new List <object>();
values.Add(record.Student.Class.Name);
values.Add(record.Student.SeatNo);
values.Add(record.Student.StudentNumber);
values.Add(record.Student.Name);
foreach (string value in CurSocres.Values)
{
values.Add(value);
}
int RowIndex = dgvDetail.Rows.Add(values.ToArray());
//int RowIndex = dgvDetail.Rows.Add(record.Student.Class.Name , record.Student.SeatNo , record.Student.StudentNumber, record.Student.Name);
}
}
#region Sample
//DataGridViewTextBoxColumn c1 = new DataGridViewTextBoxColumn();
//c1.FillWeight = 33;
//c1.HeaderText = "小考1";
//c1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//DataGridViewTextBoxColumn c2 = new DataGridViewTextBoxColumn();
//c2.FillWeight = 33;
//c2.HeaderText = "小考2";
//c2.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//DataGridViewTextBoxColumn c3 = new DataGridViewTextBoxColumn();
//c3.FillWeight = 34;
//c3.HeaderText = "小考3";
//c3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//dgvDetail.Columns.Add(c1);
//dgvDetail.Columns.Add(c2);
//dgvDetail.Columns.Add(c3);
//DataGridViewRow r1 = new DataGridViewRow();
//r1.CreateCells(dgvDetail, "301", "1", "9602001", "張君雅", "98", "80", "95");
//DataGridViewRow r2 = new DataGridViewRow();
//r2.CreateCells(dgvDetail, "301", "2", "9602002", "林測試", "40", "52", "");
//DataGridViewRow r3 = new DataGridViewRow();
//r3.CreateCells(dgvDetail, "301", "3", "9602003", "許某人", "74", "", "");
//DataGridViewRow r4 = new DataGridViewRow();
//r4.CreateCells(dgvDetail, "301", "4", "9602004", "尤比爾", "78", "76", "81");
//DataGridViewRow r5 = new DataGridViewRow();
//r5.CreateCells(dgvDetail, "301", "5", "9602005", "王同學", "61", "69", "");
//dgvDetail.Rows.Add(r1);
//dgvDetail.Rows.Add(r2);
//dgvDetail.Rows.Add(r3);
//dgvDetail.Rows.Add(r4);
//dgvDetail.Rows.Add(r5);
#endregion
//if (row == null) return;
//Row = row;
//Text += " - " + row.CourseName;
}
/// <summary>
/// 初始化介面
/// </summary>
private void RefreshUI()
{
#region 將所有控制項失效
this.TitleText = InitialTitleText + " 資料準備中..";
foreach (Control vControl in Controls)
{
vControl.Enabled = false;
}
#endregion
#region 初始化學年度學期
try
{
int schoolYear = int.Parse(K12.Data.School.DefaultSchoolYear);
int semester = int.Parse(K12.Data.School.DefaultSemester);
for (int i = -2; i <= 2; i++)
{
cboSchoolYear.Items.Add(i + schoolYear);
}
cboSemester.Items.Add(1);
cboSemester.Items.Add(2);
cboSchoolYear.SelectedItem = schoolYear;
cboSemester.SelectedItem = semester;
}
catch (Exception)
{
}
#endregion
#region 初始化領域下拉選單
cboDomain.Items.Clear();
KeyValuePair <string, string> displayAllDomains = new KeyValuePair <string, string>("顯示全部領域", "顯示全部領域");
cboDomain.DisplayMember = "Key";
cboDomain.ValueMember = "Value";
cboDomain.Items.Add(displayAllDomains);
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += (sender, e) =>
{
List <string> Domains = AssignmentExamCourse.SelectDomains();
e.Result = Domains;
};
worker.RunWorkerCompleted += (sender, e) =>
{
List <string> Domains = e.Result as List <string>;
foreach (string Domain in Domains)
{
cboDomain.Items.Add(new KeyValuePair <string, string>(Domain.Equals("") ? "(空白)or未設定領域" : Domain, Domain));
}
foreach (Control vControl in Controls)
{
vControl.Enabled = true;
}
this.TitleText = InitialTitleText;
};
worker.RunWorkerAsync();
#endregion
}
/// <summary>
/// 根據條件取得課程
/// </summary>
/// <param name="SchoolYear">學年度</param>
/// <param name="Semester">學期</param>
/// <param name="Domain">領域</param>
/// <param name="CompleteInputCount">完整小考輸入次數</param>
/// <param name="ProgressChange">進度函式</param>
/// <returns></returns>
public static List <AssignmentExamCourseRecord> Select(int?SchoolYear, int?Semester, string Domain, int?CompleteInputCount, Action <int, object> ProgressChange)
{
ProgressChange.Invoke(0, "取得課程");
#region Step1:根據學年度學期取得課程
//1.根據學年度學期取得課程
List <string> CourseIDs = new List <string>();
QueryHelper Helper = new QueryHelper();
StringBuilder strBuilder = new StringBuilder();
strBuilder.AppendLine("select id from course where subject!='' ");
if (SchoolYear.HasValue)
{
strBuilder.Append(" and school_year=" + SchoolYear.Value);
}
if (Semester.HasValue)
{
strBuilder.Append(" and semester=" + Semester.Value);
}
if (!Domain.Equals("顯示全部領域"))
{
if (Domain.Equals(""))
{
strBuilder.Append(" and domain is null");
}
else
{
strBuilder.Append(" and domain='" + Domain + "'");
}
}
DataTable Table = Helper.Select(strBuilder.ToString());
foreach (DataRow Row in Table.Rows)
{
string CourseID = Row.Field <string>("id");
CourseIDs.Add(CourseID);
}
FunctionSpliter <string, AssignmentExamCourseRecord> CourseSpliter = new FunctionSpliter <string, AssignmentExamCourseRecord>(1000, 1);
CourseSpliter.ProgressChange = (x) => ProgressChange(x, "分批取得課程");
CourseSpliter.Function = x => AssignmentExamCourse.SelectByIDs(x);
List <AssignmentExamCourseRecord> records = CourseSpliter
.Execute(CourseIDs);
#endregion
#region 已使用Native Query來篩選出科目不為空白的課程
//1.1 取得課程標籤為社團或聯課活動的課程編號
//List<string> AssociationCourseIDs = CourseTag
// .SelectByCourseIDs(records.Select(x => x.ID))
// .Where(x => x.FullName.Contains("聯課活動") || x.FullName.Contains("社團"))
// .Select(x => x.RefEntityID).ToList();
//records = records.Where(x => !AssociationCourseIDs.Contains(x.ID)).ToList();
#endregion
#region 已使用Native Query來篩選領域
//2.根據領域篩選出課程
//if (!Domain.Equals("顯示全部領域"))
// records = records.Where(x=>x.Domain.Equals(Domain)).ToList();
#endregion
//3.根據課程編號篩選出學生修課
ProgressChange(100, "已取得課程");
FunctionSpliter <string, AssignmentExamSCAttendRecord> SCAttendSpliter = new FunctionSpliter <string, AssignmentExamSCAttendRecord>(100, 3);
SCAttendSpliter.ProgressChange = (x) => ProgressChange(x, "分批取得學生修課");
SCAttendSpliter.Function = x => AssignmentExamSCAttend.SelectByCourseIDs(x);
List <AssignmentExamSCAttendRecord> screcords = SCAttendSpliter
.Execute(CourseIDs);
ProgressChange.Invoke(100, "已取得學生修課");
//4.計算每個課程的小考完整輸入次數
ProgressChange.Invoke(0, "計算小考輸入次數");
double Progress = 0;
foreach (AssignmentExamCourseRecord courserecord in records)
{
Progress++;
int Percentage = (int)((Progress / records.Count) * 100);
ProgressChange.Invoke(Percentage, "計算小考輸入次數");
//4.1 選出課程的學生修課紀錄
List <AssignmentExamSCAttendRecord> curscrecords = screcords.Where(x => x.RefCourseID == courserecord.ID && (x.Student.Status == K12.Data.StudentRecord.StudentStatus.一般)).ToList();
//4.2 紀錄每個小考已輸入小考成績的結構
Dictionary <string, int> InputCount = new Dictionary <string, int>();
//4.3 循訪課程學生修課
foreach (AssignmentExamSCAttendRecord screcord in curscrecords)
{
// 非一般生不列入
if (screcord.Student.Status != StudentRecord.StudentStatus.一般)
{
continue;
}
//4.4 循訪每個學生修課的小考紀錄
foreach (AssignmentExamRecord aerecord in screcord.AssignmentExams)
{
//4.5 假設小考編號不存在列表中
if (!InputCount.ContainsKey(aerecord.SubExamID))
{
InputCount.Add(aerecord.SubExamID, 0);
}
//4.6 假設有輸入小考成績則加入統計中
if (aerecord.Score.HasValue)
{
InputCount[aerecord.SubExamID]++;
}
}
}
//5 判斷小考統計是否等於修課人數，是的話將完整輸入次數加1
foreach (string Key in InputCount.Keys)
{
if (InputCount[Key] >= curscrecords.Count)
{
courserecord.FinishedCount++;
}
}
}
ProgressChange.Invoke(100, "計算小考輸入次數");
return(CompleteInputCount != null?records.Where(x => x.FinishedCount < CompleteInputCount).ToList() : records);
}
private void SelectAssignmentExam()
{
string Domain = string.Empty;
int? CompleteInputCount = null;
int? SchoolYear = (int?)cboSchoolYear.SelectedItem;
int? Semester = (int?)cboSemester.SelectedItem;
if (chkCondition.Checked)
{
CompleteInputCount = intTimes.Value;
}
if (cboDomain.SelectedItem != null)
{
KeyValuePair <string, string> KeyValue = (KeyValuePair <string, string>)cboDomain.SelectedItem;
Domain = KeyValue.Value;
}
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += (sender, e) =>
{
List <AssignmentExamCourseRecord> records = AssignmentExamCourse
.Select(SchoolYear
, Semester
, Domain
, CompleteInputCount
, worker.ReportProgress);
worker.ReportProgress(0, "資料呈現");
e.Result = records;
};
worker.ProgressChanged += (sender, e) =>
{
MotherForm.SetStatusBarMessage("" + e.UserState, e.ProgressPercentage);
};
worker.RunWorkerCompleted += (sender, e) =>
{
List <AssignmentExamCourseRecord> records = e.Result as List <AssignmentExamCourseRecord>;
foreach (AssignmentExamCourseRecord record in records)
{
dgvInfo.Rows.Add(record.ID,
record.Domain,
record.Name,
record.MajorTeacherName,
record.ExamCount,
record.FinishedCount);
}
dgvInfo.ResumeLayout();
this.TitleText = InitialTitleText;
foreach (Control vControl in Controls)
{
vControl.Enabled = true;
}
MotherForm.SetStatusBarMessage("資料呈現", 100);
};
dgvInfo.SuspendLayout();
dgvInfo.Rows.Clear();
this.TitleText = InitialTitleText + " 資料查詢中..";
foreach (Control vControl in Controls)
{
vControl.Enabled = false;
}
worker.WorkerReportsProgress = true;
worker.RunWorkerAsync();
}
