/// <summary> /// 是否為相同科目 /// </summary> private bool CheckSubject(SubjectObj each, SHSubjectScore subjectscore) { if (each.kcbs_sore.subject == subjectscore.Subject.Trim()) { if (subjectscore.Level.HasValue) { if (each.kcbs_sore.subject_level == subjectscore.Level.Value.ToString()) { return(true); } } } return(false); }
/// <summary> /// 取得科目成績Log UDT 的物件清單 /// </summary> private Dictionary <string, List <SubjectObj> > GetkcbsDic(List <string> StudentIDList) { Dictionary <string, List <SubjectObj> > dic = new Dictionary <string, List <SubjectObj> >(); string studentIDL = string.Join("','", StudentIDList); DataTable dt = tool._Q.Select(string.Format("select * from $kcbs.subjectscorelog where ref_student_id in ('{0}') and school_year='{1}' and semester='{2}'", studentIDL, _SchoolYear, _Semester)); foreach (DataRow each in dt.Rows) { //資料轉換 ScoreRow sRow = new ScoreRow(each); //每一個科目 SubjectObj s = new SubjectObj(sRow); if (!dic.ContainsKey(sRow.ref_student_id)) { dic.Add(sRow.ref_student_id, new List <SubjectObj>()); } dic[sRow.ref_student_id].Add(s); } return(dic); }