private void buttonX3_Click(object sender, EventArgs e)
{
if (MsgBox.Show("您確定要刪除此學期成績？", "", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
foreach (XmlElement var in QueryScore.GetSemesterEntryScoreBySemester(int.Parse(listView1.SelectedItems[0].SubItems[0].Text), int.Parse(listView1.SelectedItems[0].SubItems[1].Text), _CurrentID).GetContent().GetElements("SemesterEntryScore"))
{
RemoveScore.DeleteSemesterEntityScore(var.SelectSingleNode("@ID").InnerText);
}
foreach (XmlElement var in QueryScore.GetSemesterSubjectScoreBySemester(int.Parse(listView1.SelectedItems[0].SubItems[0].Text), int.Parse(listView1.SelectedItems[0].SubItems[1].Text), _CurrentID).GetContent().GetElements("SemesterSubjectScore"))
{
RemoveScore.DeleteSemesterSubjectScore(var.SelectSingleNode("@ID").InnerText);
}
// 刪除學期成績 log
StringBuilder deleteDesc = new StringBuilder("");
deleteDesc.AppendLine("學生姓名：" + Student.Instance.Items[_CurrentID].Name + " ");
deleteDesc.AppendLine("刪除 " + listView1.SelectedItems[0].SubItems[0].Text + " 學年度 第 " + listView1.SelectedItems[0].SubItems[1].Text + " 學期 學期成績");
CurrentUser.Instance.AppLog.Write(EntityType.Student, EntityAction.Delete, _CurrentID, deleteDesc.ToString(), Title, "");
EventHub.Instance.InvokScoreChanged(_CurrentID);
}
public override bool Fill()
{
SubProgress progress = new SubProgress(MainProgress, WeightTable.GetJobWeight("GetSemsMoral"));
try
{
Utility.StartTime("GetSemsMoral");
progress.ReportMessage("取得學期德行成績資料…");
List <List <string> > packages = Utility.SplitGetPackage(Students, PackageSize);
int offset = 1;
foreach (List <string> eachPackage in packages)
{
if (MainProgress.Cancellation)
{
return(false); //這個部份要看的必須是 MainProgress。
}
DSXmlHelper response = QueryScore.GetSemesterEntryScoreBySemester(true,
Parameters.SchoolYear,
Parameters.Semester,
QueryScore.EntryGroup.行為,
eachPackage.ToArray());
foreach (XmlElement eachStudent in response.GetElements("SemesterEntryScore"))
{
DSXmlHelper hlpScore = new DSXmlHelper(eachStudent);
string studentId = hlpScore.GetText("RefStudentId");
string scoreId = hlpScore.GetText("@ID");
if (Students.ContainsKey(studentId))
{
Student student = Students[studentId];
student.SemsMoral = new SemesterEntry("德行", eachStudent);
}
}
progress.ReportProgress((int)(((float)offset / packages.Count) * 100));
offset++;
}
progress.ReportProgress(100);
Utility.EndTime("GetSemsMoral");
return(true);
}
catch (Exception ex)
{
progress.ReportException(ex);
return(false);
}
}
private void btnArchive_Click(object sender, EventArgs e)
{
CreateUDTTable();
//寫入log
StringBuilder sb_log = new StringBuilder();
//封存 (複製sems_subj_score 和 sems_entry_score)
if (MsgBox.Show("確定將" + listView1.SelectedItems[0].SubItems[0].Text + "-" + listView1.SelectedItems[0].SubItems[1].Text + "學期成績，複製到「學期成績(封存)」？", "", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
UpdateHelper updateHelper = new UpdateHelper();
QueryHelper qh = new QueryHelper();
int uid = 0;
string searchSql = "SELECT id FROM sems_subj_score WHERE ref_student_id ={0} AND school_year={1} AND semester={2}";
searchSql = string.Format(searchSql, _CurrentID, listView1.SelectedItems[0].SubItems[0].Text, listView1.SelectedItems[0].SubItems[1].Text);
DataTable searchIDdt = qh.Select(searchSql);
if (searchIDdt.Rows.Count > 0)
{
try
{
foreach (XmlElement var in QueryScore.GetSemesterEntryScoreBySemester(int.Parse(listView1.SelectedItems[0].SubItems[0].Text), int.Parse(listView1.SelectedItems[0].SubItems[1].Text), _CurrentID).GetContent().GetElements("SemesterEntryScore"))
{
//複製學期分項成績(不複製德行成績)
string sql = @"INSERT INTO $semester_entry_score_archive (ref_student_id,school_year,semester, grade_year, score_info)
SELECT ref_student_id,school_year,semester, grade_year, score_info
FROM sems_entry_score
WHERE entry_group=1 AND id={0}
RETURNING uid";
sql = string.Format(sql, var.SelectSingleNode("@ID").InnerText);
//updateHelper.Execute(sql);
//取得回傳的uid讓$semester_subject_score_archive 寫入ref_sems_entry_uid
DataTable dt = qh.Select(sql);
foreach (DataRow dr in dt.Rows)
{
uid = int.Parse(dr["uid"].ToString());
}
}
}
catch (Exception ex)
{
MsgBox.Show("取得學生學期分項成績發生錯誤。" + ex.Message);
}
try
{
foreach (XmlElement var in QueryScore.GetSemesterSubjectScoreBySemester(int.Parse(listView1.SelectedItems[0].SubItems[0].Text), int.Parse(listView1.SelectedItems[0].SubItems[1].Text), _CurrentID).GetContent().GetElements("SemesterSubjectScore"))
{
//複製學期科目成績
string sql = @"INSERT INTO $semester_subject_score_archive (ref_student_id,school_year,semester, grade_year, score_info,ref_sems_entry_uid)
SELECT ref_student_id,school_year,semester, grade_year, score_info ,{0}
FROM sems_subj_score
WHERE id={1} ";
sql = string.Format(sql, uid, var.SelectSingleNode("@ID").InnerText);
updateHelper.Execute(sql);
}
}
catch (Exception ex)
{
MsgBox.Show("取得學生學期科目成績發生錯誤。" + ex.Message);
return;
}
sb_log.AppendLine("複製學生「" + Student.Instance.Items[_CurrentID].Name + "(學號" + Student.Instance.Items[_CurrentID].StudentNumber + ")」" + listView1.SelectedItems[0].SubItems[0].Text + "學年度第" + listView1.SelectedItems[0].SubItems[1].Text + "學期的學期成績至「學期成績(封存)」。");
FISCA.LogAgent.ApplicationLog.Log("學期成績", "封存", "學生", Student.Instance.Items[_CurrentID].ID, sb_log.ToString());
MsgBox.Show("封存成功。");
//todo 封存後，更新封存資料項目。
EventHub.OnArchiveChanged(); //Cynthia
}
else
{
MsgBox.Show(listView1.SelectedItems[0].SubItems[0].Text + "學年度第" + listView1.SelectedItems[0].SubItems[1].Text + "學期沒有科目成績。");
}
}