private void btnView_Click(object sender, EventArgs e) { StudentSemsSocreArchive sssa = listView1.SelectedItems[0].Tag as StudentSemsSocreArchive; ScoreEditor.SemesterScoreArchiveDetails viewer = new ScoreEditor.SemesterScoreArchiveDetails(this.PrimaryKey, sssa.Uid, sssa.RefEntryUid); viewer.ShowDialog(); }
private void listView1_MouseDoubleClick(object sender, MouseEventArgs e) { if (listView1.SelectedIndices.Count == 1) { StudentSemsSocreArchive sssa = listView1.SelectedItems[0].Tag as StudentSemsSocreArchive; ScoreEditor.SemesterScoreArchiveDetails viewer = new ScoreEditor.SemesterScoreArchiveDetails(this.PrimaryKey, sssa.Uid, sssa.RefEntryUid); viewer.ShowDialog(); } }
private void btnDelete_Click(object sender, EventArgs e) { List <K12.Data.StudentRecord> studentList = K12.Data.Student.SelectByIDs(K12.Presentation.NLDPanels.Student.SelectedSource); Dictionary <string, K12.Data.StudentRecord> studentDic = new Dictionary <string, K12.Data.StudentRecord>(); foreach (K12.Data.StudentRecord each in studentList) { if (!studentDic.ContainsKey(each.ID)) { studentDic.Add(each.ID, each); } } UpdateHelper updateHelper = new UpdateHelper(); // QueryHelper qh = new QueryHelper(); if (MsgBox.Show("您確定要刪除此學期成績(封存)?", "", MessageBoxButtons.YesNo) == DialogResult.No) { return; } foreach (string studentID in K12.Presentation.NLDPanels.Student.SelectedSource) { StudentSemsSocreArchive sssa = listView1.SelectedItems[0].Tag as StudentSemsSocreArchive; string sql = "DELETE FROM $semester_entry_score_archive WHERE uid={0} ;"; string sql2 = "DELETE FROM $semester_subject_score_archive WHERE uid={0}"; // 刪除分項成績 sql = string.Format(sql, sssa.RefEntryUid); //刪除科目成績 sql2 = string.Format(sql2, sssa.Uid); List <string> sqls = new List <string>(); sqls.Add(sql); sqls.Add(sql2); //string sqls = sql + sql2; //qh.Select(sqls); updateHelper.Execute(sqls); // 刪除學期成績(封存) +封存時間log StringBuilder deleteDesc = new StringBuilder(""); deleteDesc.AppendLine("學生姓名:" + studentDic[studentID].Name + " "); deleteDesc.AppendLine("刪除 " + listView1.SelectedItems[0].SubItems[0].Text + " 學年度 第 " + listView1.SelectedItems[0].SubItems[1].Text + " 學期 學期成績(封存)"); FISCA.LogAgent.ApplicationLog.Log("學期成績(封存)", "刪除", "學生", this.PrimaryKey, deleteDesc.ToString()); MsgBox.Show("刪除完成。"); Changed(); } }
public void FillListView() { QueryHelper qh = new QueryHelper(); string sql = @"SELECT a.uid , a.ref_student_id , a.school_year , a.semester , a.grade_year, array_to_string(xpath('//SemesterEntryScore/Entry[@分項=''學業'']/@成績', xmlparse(content b.score_info)), '')::text AS 學業成績 , a.last_update, a.ref_sems_entry_uid FROM $semester_subject_score_archive a LEFT JOIN $semester_entry_score_archive b ON a.ref_sems_entry_uid=b.uid WHERE a.ref_student_id={0}"; sql = string.Format(sql, this.PrimaryKey); try { DataTable dt = qh.Select(sql); int i = 0; foreach (DataRow dr in dt.Rows) { StudentSemsSocreArchive sssa = new StudentSemsSocreArchive(); sssa.Uid = dr["uid"].ToString(); sssa.RefEntryUid = dr["ref_sems_entry_uid"].ToString(); listView1.Items.Add(dr["school_year"].ToString()); listView1.Items[i].Tag = sssa; listView1.Items[i].SubItems.Add(dr["semester"].ToString()); listView1.Items[i].SubItems.Add(dr["grade_year"].ToString()); listView1.Items[i].SubItems.Add(dr["學業成績"].ToString()); listView1.Items[i].SubItems.Add(dr["last_update"].ToString()); i++; } } catch (Exception ex) { MsgBox.Show("取得學生學期成績(封存)發生錯誤。"); } _ReloadArchiveData = false; //Cyn }