コード例 #1
0
        internal SemesterScoreRecordEditor(SemesterScoreRecord info)
        {
            SemesterSubjectScoreRecord = info;

            RefStudentID     = info.RefStudentID;
            ID               = info.ID;
            SchoolYear       = info.SchoolYear;
            Semester         = info.Semester;
            GradeYear        = info.GradeYear;
            LearnDomainScore = info.LearnDomainScore;
            CourseLearnScore = info.CourseLearnScore;

            Dictionary <string, SubjectScore> subjectList = new Dictionary <string, SubjectScore>();

            foreach (var subject in info.Subjects.Values)
            {
                subjectList.Add(subject.Subject, subject.Clone() as SubjectScore);
            }
            Subjects = subjectList;

            Dictionary <string, DomainScore> domainList = new Dictionary <string, DomainScore>();

            foreach (var domain in info.Domains.Values)
            {
                domainList.Add(domain.Domain, domain.Clone() as DomainScore);
            }
            Domains = domainList;
        }
コード例 #2
0
        public static List <SemesterScoreRecord> GetSemesterScores(IEnumerable <string> primaryKeys)
        {
            DSXmlHelper helper = new DSXmlHelper("GetSemesterSubjectScore");

            helper.AddElement("Field");
            helper.AddElement("Field", "ID");
            helper.AddElement("Field", "RefStudentId");
            helper.AddElement("Field", "SchoolYear");
            helper.AddElement("Field", "Semester");
            helper.AddElement("Field", "GradeYear");
            helper.AddElement("Field", "ScoreInfo");
            helper.AddElement("Condition");
            helper.AddElement("Condition", "StudentIDList");
            foreach (var each in primaryKeys)
            {
                helper.AddElement("Condition/StudentIDList", "ID", each);
            }

            DSResponse rsp = FISCA.Authentication.DSAServices.CallService("SmartSchool.Score.GetSemesterSubjectScore", new DSRequest(helper));

            List <SemesterScoreRecord> result = new List <SemesterScoreRecord>();

            foreach (XmlElement element in rsp.GetContent().GetElements("SemesterSubjectScore"))
            {
                SemesterScoreRecord record = new SemesterScoreRecord(element);
                result.Add(record);
            }
            return(result);
        }
コード例 #3
0
ファイル: AvgObj.cs プロジェクト: ratalai/StudentRecordReport
 /// <summary>
 /// 讀取學期成績AvgScore
 /// </summary>
 /// <param name="ssr"></param>
 public void LoadData(SemesterScoreRecord ssr)
 {
     if (ssr.Semester == 1)
     {
         MidtermAvg = ssr.AvgScore;
     }
     else if (ssr.Semester == 2)
     {
         FinalAvg = ssr.AvgScore;
     }
 }
コード例 #4
0
 private void btnEdit_Click(object sender, EventArgs e)
 {
     if (listView.SelectedItems.Count == 1)
     {
         SemesterScoreRecord record = listView.SelectedItems[0].Tag as SemesterScoreRecord;
         SemesterScoreEditor edit   = new SemesterScoreEditor(record, RunningID);
         if (edit.ShowDialog() == DialogResult.OK)
         {
             _bgWorker.RunWorkerAsync();
         }
     }
 }
コード例 #5
0
        public SemesterScoreEditor(SemesterScoreRecord ssr, string id)
        {
            InitializeComponent();
            _ssr = ssr;
            _sid = id;

            //record舊資料for log
            foreach (SubjectScore ss in _ssr.Subjects.Values)
            {
                _old.Add(ss.Subject + "_節數", ss.Period + "");
                _old.Add(ss.Subject + "_權數", ss.Credit + "");
                _old.Add(ss.Subject + "_成績", ss.Score + "");
                _old.Add(ss.Subject + "_類別", ss.Type + "");
                _old.Add(ss.Subject + "_群組", ss.Domain + "");
                _old.Add(ss.Subject + "_Level", ss.Level + "");
            }

            //科目對照
            foreach (SubjectRecord r in _A.Select <SubjectRecord>())
            {
                if (!_SubjectDic.ContainsKey(r.Name))
                {
                    _SubjectDic.Add(r.Name, r);
                }
            }

            //新增科目下拉清單
            //colSubjectName.Items.Add(""); //空白預設項
            foreach (string name in _SubjectDic.Keys)
            {
                colSubjectName.Items.Add(name);
            }

            //Type
            colSubjectType.Items.Add("Regular");
            colSubjectType.Items.Add("Honor");

            //Domain
            Dictionary <int, List <Tool.Domain> > domains = Tool.DomainDic;

            foreach (int grade in domains.Keys)
            {
                foreach (Tool.Domain domain in domains[grade])
                {
                    if (!colDomain.Items.Contains(domain.Name))
                    {
                        colDomain.Items.Add(domain.Name);
                    }
                }
            }
        }
コード例 #6
0
        private string GetSemesterScoreInfo(SemesterScoreRecord record)
        {
            StringBuilder sb = new StringBuilder();

            sb.AppendLine("平均成績:" + record.AvgScore);
            sb.AppendLine("平均GPA:" + record.AvgGPA);

            foreach (SubjectScore ss in record.Subjects.Values)
            {
                sb.AppendLine("科目:" + ss.Subject + " 節數:" + ss.Period + " 權數:" + ss.Credit + " 成績:" + ss.Score);
            }

            return(sb.ToString());
        }
コード例 #7
0
        /// <summary>
        /// 設定學期成績
        /// </summary>
        /// <param name="ssr"></param>
        public void SetSubjects(SemesterScoreRecord ssr)
        {
            //各科目學期成績(obj version)
            foreach (string subj in ssr.Subjects.Keys)
            {
                string subjKey = ssr.SchoolYear + "_" + subj;

                if (!SubjectObjDic.ContainsKey(subjKey))
                {
                    SubjectObjDic.Add(subjKey, new SubjectObj());
                }

                SubjectObjDic[subjKey].LoadData(ssr.Subjects[subj]);

                //將科目清單分類
                if (SchoolYearToGrade.ContainsKey(ssr.SchoolYear))
                {
                    int grade = SchoolYearToGrade[ssr.SchoolYear];
                    if (grade <= 6)
                    {
                        if (!SubjectList6.Contains(subj))
                        {
                            SubjectList6.Add(subj);
                        }
                    }
                    else
                    {
                        if (!SubjectList12.Contains(subj))
                        {
                            SubjectList12.Add(subj);
                        }
                    }
                }
            }

            //排序科目清單
            SortSubjects();

            //各學期平均成績
            string key = ssr.SchoolYear + "";

            if (!AvgObjDic.ContainsKey(key))
            {
                AvgObjDic.Add(key, new AvgObj());
            }

            AvgObjDic[key].LoadData(ssr);
        }
コード例 #8
0
        private void btnOk_Click(object sender, EventArgs e)
        {
            int    schoolYear = int.Parse(cboSchoolYear.Text);
            int    semester   = int.Parse(cboSemester.Text);
            string key        = schoolYear + "_" + semester;

            if (_list.Contains(key))
            {
                MessageBox.Show("該學年度學期已存在,無法新增");
            }
            else
            {
                SemesterScoreRecord record = new SemesterScoreRecord(_id, schoolYear, semester);
                K12.Data.SemesterScore.Insert(record);
                this.DialogResult = DialogResult.OK;
                this.Close();
            }
        }
コード例 #9
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (listView.SelectedItems.Count == 1)
            {
                SemesterScoreRecord record = listView.SelectedItems[0].Tag as SemesterScoreRecord;

                if (MessageBox.Show("確認刪除「" + record.SchoolYear + "學年度 第" + record.Semester + "學期」的學期成績?", "ischool", MessageBoxButtons.OKCancel) == DialogResult.OK)
                {
                    StudentRecord student = record.Student;
                    string        str     = "學年度:" + record.SchoolYear + " 學期:" + record.Semester;
                    str += Tool.GetStudentInfo(record.Student);
                    str += GetSemesterScoreInfo(record);
                    FISCA.LogAgent.ApplicationLog.Log("成績系統.學期成績", "刪除學期成績", str);

                    K12.Data.SemesterScore.Delete(record);
                    _bgWorker.RunWorkerAsync();
                }
            }
        }
コード例 #10
0
 public StudentObj(StudentRecord sr)
 {
     StudentRecord       = sr;
     SemesterScoreRecord = new SemesterScoreRecord();
 }
コード例 #11
0
 public static SemesterScoreRecordEditor GetEditor(this SemesterScoreRecord semesterSubjectScoreRecord)
 {
     return(new SemesterScoreRecordEditor(semesterSubjectScoreRecord));
 }
コード例 #12
0
ファイル: Tool.cs プロジェクト: ratalai/CourseGradeB
        /// <summary>
        /// 計算指定學生在該學年度學期的累計GPA
        /// </summary>
        /// <param name="ids"></param>
        /// <param name="schoolYear"></param>
        /// <param name="semester"></param>
        public static void SetCumulateGPA(List <string> ids, int schoolYear, int semester)
        {
            //學期歷程
            Dictionary <string, string> sems_history = new Dictionary <string, string>();

            foreach (SemesterHistoryRecord shr in K12.Data.SemesterHistory.SelectByStudentIDs(ids))
            {
                foreach (SemesterHistoryItem item in shr.SemesterHistoryItems)
                {
                    //學生年級對照
                    string key = item.RefStudentID + "_" + item.SchoolYear + "_" + item.Semester;
                    if (!sems_history.ContainsKey(key))
                    {
                        if (item.Semester == 1)
                        {
                            sems_history.Add(key, item.GradeYear + "上");
                        }
                        else
                        {
                            sems_history.Add(key, item.GradeYear + "下");
                        }
                    }
                }
            }

            //取得學期成績紀錄
            Dictionary <string, K12.Data.SemesterScoreRecord> update = new Dictionary <string, SemesterScoreRecord>();

            foreach (var record in K12.Data.SemesterScore.SelectBySchoolYearAndSemester(ids, schoolYear, semester))
            {
                if (!update.ContainsKey(record.RefStudentID))
                {
                    update.Add(record.RefStudentID, record);
                }
            }

            //結算累計GPA
            Dictionary <string, Dictionary <string, SemesterScoreRecord> > student_gpa_dic = new Dictionary <string, Dictionary <string, SemesterScoreRecord> >();

            foreach (SemesterScoreRecord r in K12.Data.SemesterScore.SelectByStudentIDs(ids))
            {
                //學年度學期判斷排除
                if (r.SchoolYear > schoolYear)
                {
                    continue;
                }
                else if (r.SchoolYear == schoolYear)
                {
                    if (r.Semester > semester)
                    {
                        continue;
                    }
                }

                string key = r.RefStudentID + "_" + r.SchoolYear + "_" + r.Semester;

                if (!student_gpa_dic.ContainsKey(r.RefStudentID))
                {
                    student_gpa_dic.Add(r.RefStudentID, new Dictionary <string, SemesterScoreRecord>());
                }

                if (sems_history.ContainsKey(key))
                {
                    string grade = sems_history[key];
                    if (grade == "9上" || grade == "9下" || grade == "10上" || grade == "10下" || grade == "11上" || grade == "11下" || grade == "12上" || grade == "12下")
                    {
                        if (!student_gpa_dic[r.RefStudentID].ContainsKey(grade))
                        {
                            student_gpa_dic[r.RefStudentID].Add(grade, r);
                        }

                        SemesterScoreRecord ssr = student_gpa_dic[r.RefStudentID][grade];

                        //如果有相同grade的record,以較新的為主
                        if (r.SchoolYear > ssr.SchoolYear)
                        {
                            student_gpa_dic[r.RefStudentID][grade] = r;
                        }
                        else if (r.SchoolYear == ssr.SchoolYear)
                        {
                            if (r.Semester > ssr.Semester)
                            {
                                student_gpa_dic[r.RefStudentID][grade] = r;
                            }
                        }
                    }
                }
            }

            foreach (string id in update.Keys)
            {
                if (!student_gpa_dic.ContainsKey(id))
                {
                    continue;
                }

                SemesterScoreRecord ssr = update[id];

                decimal total = 0;
                int     count = 0;

                foreach (SemesterScoreRecord r in student_gpa_dic[id].Values)
                {
                    if (r.AvgGPA.HasValue)
                    {
                        total += r.AvgGPA.Value;
                        count++;
                    }
                }

                if (count > 0)
                {
                    ssr.CumulateGPA = Math.Round(total / count, 2, MidpointRounding.AwayFromZero);
                }
            }

            K12.Data.SemesterScore.Update(update.Values);
        }