private List <K12.Data.SubjectScore> CalculateSubjectScore(List <SCAttendRecord> scattendList) { Dictionary <string, SubjectCalc> subjectScores = new Dictionary <string, SubjectCalc>(); foreach (SCAttendRecord attend in scattendList) { CourseRecord course = attend.Course; if (!subjectScores.ContainsKey(course.Subject)) { subjectScores.Add(course.Subject, new SubjectCalc(course.Domain, attend.Score, attend.Effort, course.Credit, course.Period, attend.Text)); } } List <K12.Data.SubjectScore> list = new List <K12.Data.SubjectScore>(); foreach (string key in subjectScores.Keys) { K12.Data.SubjectScore subject = new K12.Data.SubjectScore(); subject.Subject = key; subject.Domain = subjectScores[key].Domain; subject.Credit = subjectScores[key].Credit; subject.Period = subjectScores[key].Period; subject.Text = subjectScores[key].Text; subject.Score = subjectScores[key].Score; subject.Effort = subjectScores[key].Effort; list.Add(subject); } return(list); }
public bool Add(SemesterData semester, K12.Data.SubjectScore subject) { if (!_scores.ContainsKey(semester)) { _scores.Add(semester, new ScoreData("" + subject.Period, "" + subject.Credit, "" + subject.Score)); return(true); } return(false); }
public bool Add(SemesterData semester, K12.Data.SubjectScore subject) { if (!_subjectScores.ContainsKey(subject.Subject)) { _subjectScores.Add(subject.Subject, new Dictionary <SemesterData, ScoreData>()); } if (!_subjectScores[subject.Subject].ContainsKey(semester)) { _subjectScores[subject.Subject].Add(semester, new ScoreData("" + subject.Period, "" + subject.Credit, "" + subject.Score)); return(true); } return(false); }
private void btnSave_Click(object sender, EventArgs e) { if (!inputed) { MsgBox.Show("尚未輸入成績"); return; } if (!IsValid()) { return; } try { int schoolYear = int.Parse(cboSchoolYear.Text); int semester = int.Parse(cboSemester.Text); //int gradeYear = 0; //SemesterScoreRecordEditor editor = new SemesterScoreRecordEditor(_student, schoolYear, semester, gradeYear); JHSemesterScoreRecord newRecord = new JHSemesterScoreRecord(); newRecord.RefStudentID = _student.ID; newRecord.SchoolYear = schoolYear; newRecord.Semester = semester; K12.Data.DomainScore liter = new K12.Data.DomainScore(); PeriodCredit literpc1 = new PeriodCredit(); PeriodCredit literpc2 = new PeriodCredit(); literpc1.Parse(textBoxX25.Text); literpc2.Parse(textBoxX26.Text); //if (!int.TryParse(textBoxX25.Text, out literpc1)) // literpc1 = 0; //if (!int.TryParse(textBoxX26.Text, out literpc2)) // literpc2 = 0; int effort1, effort2; if (!int.TryParse(textBoxX17.Text, out effort1)) { effort1 = 0; } if (!int.TryParse(textBoxX18.Text, out effort2)) { effort2 = 0; } liter.Period = literpc1.Period + literpc2.Period; liter.Credit = literpc1.Credit + literpc2.Credit; liter.Domain = "語文"; //liter.Effort = (int)((effort1 + effort2) / 2); liter.Effort = 1; decimal d; liter.Score = decimal.TryParse(labelX14.Text, out d) ? (decimal?)d : null; liter.Text = textBoxX9.Text + " " + textBoxX10.Text; newRecord.Domains.Add("語文", liter); if (CheckDomainValid(textBoxX27, textBoxX3, textBoxX19)) { newRecord.Domains.Add("數學", GetDomainScore("語文", textBoxX27, textBoxX3, textBoxX19, textBoxX11)); } if (CheckDomainValid(textBoxX28, textBoxX4, textBoxX20)) { newRecord.Domains.Add("社會", GetDomainScore("社會", textBoxX28, textBoxX4, textBoxX20, textBoxX12)); } if (CheckDomainValid(textBoxX29, textBoxX5, textBoxX21)) { newRecord.Domains.Add("藝術與人文", GetDomainScore("藝術與人文", textBoxX29, textBoxX5, textBoxX21, textBoxX13)); } if (CheckDomainValid(textBoxX30, textBoxX6, textBoxX22)) { newRecord.Domains.Add("自然與生活科技", GetDomainScore("自然與生活科技", textBoxX30, textBoxX6, textBoxX22, textBoxX14)); } if (CheckDomainValid(textBoxX31, textBoxX7, textBoxX23)) { newRecord.Domains.Add("健康與體育", GetDomainScore("健康與體育", textBoxX31, textBoxX7, textBoxX23, textBoxX15)); } if (CheckDomainValid(textBoxX32, textBoxX8, textBoxX24)) { newRecord.Domains.Add("綜合活動", GetDomainScore("綜合活動", textBoxX32, textBoxX8, textBoxX24, textBoxX16)); } if (textBoxX25.Enabled) { K12.Data.SubjectScore subject1 = new K12.Data.SubjectScore(); subject1.Domain = "語文"; subject1.Subject = textBoxX36.Text; subject1.Score = decimal.Parse(textBoxX1.Text); //subject1.Effort = int.Parse(textBoxX17.Text); subject1.Effort = 1; subject1.Text = textBoxX9.Text; //subject1.Period = subject1.Credit = int.Parse(textBoxX25.Text); subject1.Period = literpc1.Period; subject1.Credit = literpc1.Credit; newRecord.Subjects.Add(subject1.Subject, subject1); } if (textBoxX26.Enabled) { K12.Data.SubjectScore subject2 = new K12.Data.SubjectScore(); subject2.Domain = "語文"; subject2.Subject = textBoxX37.Text; subject2.Score = decimal.Parse(textBoxX2.Text); subject2.Effort = int.Parse(textBoxX18.Text); subject2.Text = textBoxX10.Text; //subject2.Period = subject2.Credit = int.Parse(textBoxX26.Text); subject2.Period = literpc2.Period; subject2.Credit = literpc2.Credit; newRecord.Subjects.Add(subject2.Subject, subject2); } foreach (DataGridViewRow row in dgv.Rows) { if (row.IsNewRow) { continue; } PeriodCredit pc = new PeriodCredit(); pc.Parse("" + row.Cells[chsPeriodCredit.Index].Value); K12.Data.SubjectScore subject = new K12.Data.SubjectScore(); subject.Domain = "" + row.Cells[chsDomain.Index].Value; subject.Subject = "" + row.Cells[chsSubject.Index].Value; subject.Period = pc.Period; subject.Credit = pc.Credit; subject.Score = decimal.Parse("" + row.Cells[chsScore.Index].Value); //subject.Effort = int.Parse("" + row.Cells[chsEffort.Index].Value); subject.Effort = 1; subject.Text = "" + row.Cells[chsText.Index].Value; newRecord.Subjects.Add(subject.Subject, subject); } if (!string.IsNullOrEmpty(textBoxX33.Text)) { newRecord.Domains.Add("彈性課程", GetElasticDomain()); } if (!string.IsNullOrEmpty(textBoxX34.Text)) { newRecord.LearnDomainScore = decimal.Parse(textBoxX34.Text); } if (!string.IsNullOrEmpty(textBoxX35.Text)) { newRecord.CourseLearnScore = decimal.Parse(textBoxX35.Text); } JHSemesterScore.Insert(newRecord); SaveLog(newRecord); } catch (Exception ex) { MsgBox.Show("儲存失敗"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } this.DialogResult = DialogResult.OK; }
public override void InitializeImport(SmartSchool.API.PlugIn.Import.ImportWizard wizard) { Dictionary <string, int> _ID_SchoolYear_Semester_GradeYear = new Dictionary <string, int>(); Dictionary <string, List <string> > _ID_SchoolYear_Semester_Subject = new Dictionary <string, List <string> >(); Dictionary <string, JHStudentRecord> _StudentCollection = new Dictionary <string, JHStudentRecord>(); Dictionary <JHStudentRecord, Dictionary <int, decimal> > _StudentPassScore = new Dictionary <JHStudentRecord, Dictionary <int, decimal> >(); Dictionary <string, List <JHSemesterScoreRecord> > semsDict = new Dictionary <string, List <JHSemesterScoreRecord> >(); wizard.PackageLimit = 3000; //wizard.ImportableFields.AddRange("領域", "科目", "學年度", "學期", "權數", "節數", "分數評量", "努力程度", "文字描述", "註記"); //wizard.ImportableFields.AddRange("領域", "科目", "學年度", "學期", "權數", "節數", "分數評量", "文字描述", "註記"); //2015.1.27 Cloud新增 wizard.ImportableFields.AddRange("領域", "科目", "學年度", "學期", "權數", "節數", "成績", "原始成績", "補考成績", "努力程度", "文字描述", "註記"); wizard.RequiredFields.AddRange("領域", "科目", "學年度", "學期"); wizard.ValidateStart += delegate(object sender, SmartSchool.API.PlugIn.Import.ValidateStartEventArgs e) { #region ValidateStart _ID_SchoolYear_Semester_GradeYear.Clear(); _ID_SchoolYear_Semester_Subject.Clear(); _StudentCollection.Clear(); List <JHStudentRecord> list = JHStudent.SelectByIDs(e.List); MultiThreadWorker <JHStudentRecord> loader = new MultiThreadWorker <JHStudentRecord>(); loader.MaxThreads = 3; loader.PackageSize = 250; loader.PackageWorker += delegate(object sender1, PackageWorkEventArgs <JHStudentRecord> e1) { foreach (var item in JHSemesterScore.SelectByStudents(e1.List)) { if (!semsDict.ContainsKey(item.RefStudentID)) { semsDict.Add(item.RefStudentID, new List <JHSchool.Data.JHSemesterScoreRecord>()); } semsDict[item.RefStudentID].Add(item); } }; loader.Run(list); foreach (JHStudentRecord stu in list) { if (!_StudentCollection.ContainsKey(stu.ID)) { _StudentCollection.Add(stu.ID, stu); } } #endregion }; wizard.ValidateRow += delegate(object sender, SmartSchool.API.PlugIn.Import.ValidateRowEventArgs e) { #region ValidateRow int t; decimal d; JHStudentRecord student; if (_StudentCollection.ContainsKey(e.Data.ID)) { student = _StudentCollection[e.Data.ID]; } else { e.ErrorMessage = "壓根就沒有這個學生" + e.Data.ID; return; } bool inputFormatPass = true; #region 驗各欄位填寫格式 foreach (string field in e.SelectFields) { string value = e.Data[field]; switch (field) { default: break; case "領域": //if (value == "") //{ // inputFormatPass &= false; // e.ErrorFields.Add(field, "必須填寫"); //} //else if (!Domains.Contains(value)) //{ // inputFormatPass &= false; // e.ErrorFields.Add(field, "必須為七大領域"); //} break; case "科目": if (value == "") { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填寫"); } break; case "學年度": if (value == "" || !int.TryParse(value, out t)) { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填入學年度"); } break; case "權數": case "節數": if (value == "" || !decimal.TryParse(value, out d)) { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填入數值"); } break; //case "成績年級": // if (value == "" || !int.TryParse(value, out t)) // { // inputFormatPass &= false; // e.ErrorFields.Add(field, "必須填入整數"); // } // break; case "學期": if (value == "" || !int.TryParse(value, out t) || t > 2 || t < 1) { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填入1或2"); } break; //case "分數評量": // if (value != "" && !decimal.TryParse(value, out d)) // { // inputFormatPass &= false; // e.ErrorFields.Add(field, "必須填入空白或數值"); // } // break; case "成績": if (value != "" && !decimal.TryParse(value, out d)) { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填入空白或數值"); } break; case "原始成績": if (value != "" && !decimal.TryParse(value, out d)) { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填入空白或數值"); } break; case "補考成績": if (value != "" && !decimal.TryParse(value, out d)) { inputFormatPass &= false; e.ErrorFields.Add(field, "必須填入空白或數值"); } break; //case "努力程度": // if (value != "" && !int.TryParse(value, out t)) // { // inputFormatPass &= false; // e.ErrorFields.Add(field, "必須填入空白或數值"); // } // break; } } #endregion //輸入格式正確才會針對情節做檢驗 if (inputFormatPass) { string errorMessage = ""; string subject = e.Data["科目"]; string schoolYear = e.Data["學年度"]; string semester = e.Data["學期"]; int? sy = null; int? se = null; if (int.TryParse(schoolYear, out t)) { sy = t; } if (int.TryParse(semester, out t)) { se = t; } if (sy != null && se != null) { string key = e.Data.ID + "_" + sy + "_" + se; #region 驗證新增科目成績 List <JHSemesterScoreRecord> semsList; if (semsDict.ContainsKey(student.ID)) { semsList = semsDict[student.ID]; } else { semsList = new List <JHSemesterScoreRecord>(); } foreach (JHSemesterScoreRecord record in semsList) { if (record.SchoolYear != sy) { continue; } if (record.Semester != se) { continue; } bool isNewSubjectInfo = true; string message = ""; foreach (K12.Data.SubjectScore s in record.Subjects.Values) { if (s.Subject == subject) { isNewSubjectInfo = false; } } if (isNewSubjectInfo) { if (!e.WarningFields.ContainsKey("查無此科目")) { e.WarningFields.Add("查無此科目", "學生在此學期並無此筆科目成績資訊,將會新增此科目成績"); } foreach (string field in new string[] { "領域", "科目", "學年度", "學期", "權數", "節數" }) { if (!e.SelectFields.Contains(field)) { message += (message == "" ? "發現此學期無此科目,\n將會新增成績\n缺少成績必要欄位" : "、") + field; } } if (message != "") { errorMessage += (errorMessage == "" ? "" : "\n") + message; } } } #endregion #region 驗證重複科目資料 //string skey = subject + "_" + le; string skey = subject; if (!_ID_SchoolYear_Semester_Subject.ContainsKey(key)) { _ID_SchoolYear_Semester_Subject.Add(key, new List <string>()); } if (_ID_SchoolYear_Semester_Subject[key].Contains(skey)) { errorMessage += (errorMessage == "" ? "" : "\n") + "同一學期不允許多筆相同科目的資料"; } else { _ID_SchoolYear_Semester_Subject[key].Add(skey); } #endregion } e.ErrorMessage = errorMessage; } #endregion }; wizard.ImportPackage += delegate(object sender, SmartSchool.API.PlugIn.Import.ImportPackageEventArgs e) { #region ImportPackage Dictionary <string, List <RowData> > id_Rows = new Dictionary <string, List <RowData> >(); #region 分包裝 foreach (RowData data in e.Items) { if (!id_Rows.ContainsKey(data.ID)) { id_Rows.Add(data.ID, new List <RowData>()); } id_Rows[data.ID].Add(data); } #endregion //List<SmartSchool.Feature.Score.AddScore.InsertInfo> insertList = new List<SmartSchool.Feature.Score.AddScore.InsertInfo>(); //List<SmartSchool.Feature.Score.EditScore.UpdateInfo> updateList = new List<SmartSchool.Feature.Score.EditScore.UpdateInfo>(); List <JHSemesterScoreRecord> insertList = new List <JHSemesterScoreRecord>(); List <JHSemesterScoreRecord> updateList = new List <JHSemesterScoreRecord>(); //交叉比對各學生資料 #region 交叉比對各學生資料 foreach (string id in id_Rows.Keys) { XmlDocument doc = new XmlDocument(); JHStudentRecord studentRec = _StudentCollection[id]; //該學生的學期科目成績 Dictionary <SemesterInfo, JHSemesterScoreRecord> semesterScoreDictionary = new Dictionary <SemesterInfo, JHSemesterScoreRecord>(); #region 整理現有的成績資料 List <JHSchool.Data.JHSemesterScoreRecord> semsList; if (semsDict.ContainsKey(studentRec.ID)) { semsList = semsDict[studentRec.ID]; } else { semsList = new List <JHSchool.Data.JHSemesterScoreRecord>(); } foreach (JHSemesterScoreRecord var in semsList) { SemesterInfo info = new SemesterInfo(); info.SchoolYear = var.SchoolYear; info.Semester = var.Semester; if (!semesterScoreDictionary.ContainsKey(info)) { semesterScoreDictionary.Add(info, var); } //string key = var.Subject + "_" + var.Level; //if (!semesterScoreDictionary.ContainsKey(var.SchoolYear)) // semesterScoreDictionary.Add(var.SchoolYear, new Dictionary<int, Dictionary<string, SemesterSubjectScoreInfo>>()); //if (!semesterScoreDictionary[var.SchoolYear].ContainsKey(var.Semester)) // semesterScoreDictionary[var.SchoolYear].Add(var.Semester, new Dictionary<string, SemesterSubjectScoreInfo>()); //if (!semesterScoreDictionary[var.SchoolYear][var.Semester].ContainsKey(key)) // semesterScoreDictionary[var.SchoolYear][var.Semester].Add(key, var); } #endregion //要匯入的學期科目成績 Dictionary <SemesterInfo, Dictionary <string, RowData> > semesterImportScoreDictionary = new Dictionary <SemesterInfo, Dictionary <string, RowData> >(); #region 整理要匯入的資料 foreach (RowData row in id_Rows[id]) { int t; string subject = row["科目"]; string schoolYear = row["學年度"]; string semester = row["學期"]; int sy = int.Parse(schoolYear); int se = int.Parse(semester); SemesterInfo info = new SemesterInfo(); info.SchoolYear = sy; info.Semester = se; if (!semesterImportScoreDictionary.ContainsKey(info)) { semesterImportScoreDictionary.Add(info, new Dictionary <string, RowData>()); } if (!semesterImportScoreDictionary[info].ContainsKey(subject)) { semesterImportScoreDictionary[info].Add(subject, row); } } #endregion //學期年級重整 //Dictionary<SemesterInfo, int> semesterGradeYear = new Dictionary<SemesterInfo, int>(); //要變更成績的學期 List <SemesterInfo> updatedSemester = new List <SemesterInfo>(); //在變更學期中新增加的成績資料 Dictionary <SemesterInfo, List <RowData> > updatedNewSemesterScore = new Dictionary <SemesterInfo, List <RowData> >(); //要增加成績的學期 Dictionary <SemesterInfo, List <RowData> > insertNewSemesterScore = new Dictionary <SemesterInfo, List <RowData> >(); //開始處理ImportScore #region 開始處理ImportScore foreach (SemesterInfo info in semesterImportScoreDictionary.Keys) { foreach (string subject in semesterImportScoreDictionary[info].Keys) { RowData data = semesterImportScoreDictionary[info][subject]; //如果是本來沒有這筆學期的成績就加到insertNewSemesterScore if (!semesterScoreDictionary.ContainsKey(info)) { if (!insertNewSemesterScore.ContainsKey(info)) { insertNewSemesterScore.Add(info, new List <RowData>()); } insertNewSemesterScore[info].Add(data); } else { bool hasChanged = false; //修改已存在的資料 if (semesterScoreDictionary[info].Subjects.ContainsKey(subject)) { JHSemesterScoreRecord record = semesterScoreDictionary[info]; #region 直接修改已存在的成績資料的Detail foreach (string field in e.ImportFields) { K12.Data.SubjectScore score = record.Subjects[subject]; string value = data[field]; //"分數評量", "努力程度", "文字描述", "註記" switch (field) { default: break; case "領域": if (score.Domain != value) { score.Domain = value; hasChanged = true; } break; case "權數": if ("" + score.Credit != value) { score.Credit = decimal.Parse(value); hasChanged = true; } break; case "節數": if ("" + score.Period != value) { score.Period = decimal.Parse(value); hasChanged = true; } break; //case "成績年級": // int gy = int.Parse(data["成績年級"]); // if (record.GradeYear != gy) // { // semesterGradeYear[info] = gy; // hasChanged = true; // } // break; //case "分數評量": // if ("" + score.Score != value) // { // decimal d; // if (decimal.TryParse(value, out d)) // score.Score = d; // else // score.Score = null; // hasChanged = true; // } // break; case "成績": if ("" + score.Score != value) { decimal d; if (decimal.TryParse(value, out d)) { score.Score = d; } else { score.Score = null; } hasChanged = true; } break; case "原始成績": if ("" + score.ScoreOrigin != value) { decimal d; if (decimal.TryParse(value, out d)) { score.ScoreOrigin = d; } else { score.ScoreOrigin = null; } hasChanged = true; } break; case "補考成績": if ("" + score.ScoreMakeup != value) { decimal d; if (decimal.TryParse(value, out d)) { score.ScoreMakeup = d; } else { score.ScoreMakeup = null; } hasChanged = true; } break; //case "努力程度": // if ("" + score.Effort != value) // { // int i; // if (int.TryParse(value, out i)) // score.Effort = i; // else // score.Effort = null; // hasChanged = true; // } // break; case "文字描述": if ("" + score.Text != value) { score.Text = value; hasChanged = true; } break; case "註記": if (score.Comment != value) { score.Comment = value; hasChanged = true; } break; } } #endregion } else//加入新成績至已存在的學期 { if (!updatedNewSemesterScore.ContainsKey(info)) { updatedNewSemesterScore.Add(info, new List <RowData>()); } updatedNewSemesterScore[info].Add(data); hasChanged = true; } //真的有變更 if (hasChanged) { #region 登錄有變更的學期 if (!updatedSemester.Contains(info)) { updatedSemester.Add(info); } #endregion } } } } #endregion //處理已登錄要更新的學期成績 #region 處理已登錄要更新的學期成績 foreach (SemesterInfo info in updatedSemester) { //Dictionary<int, Dictionary<int, string>> semeScoreID = (Dictionary<int, Dictionary<int, string>>)studentRec.Fields["SemesterSubjectScoreID"]; //string semesterScoreID = semeScoreID[sy][se];//從學期抓ID //int gradeyear = semesterGradeYear[info];//抓年級 //XmlElement subjectScoreInfo = doc.CreateElement("SemesterSubjectScoreInfo"); #region 產生該學期科目成績的XML //foreach (SemesterSubjectScoreInfo scoreInfo in semesterScoreDictionary[sy][se].Values) //{ // subjectScoreInfo.AppendChild(doc.ImportNode(scoreInfo.Detail, true)); //} updateList.Add(semesterScoreDictionary[info]); //if (updatedNewSemesterScore.ContainsKey(sy) && updatedNewSemesterScore[sy].ContainsKey(se)) if (updatedNewSemesterScore.ContainsKey(info)) { foreach (RowData row in updatedNewSemesterScore[info]) { //XmlElement newScore = doc.CreateElement("Subject"); K12.Data.SubjectScore subjectScore = new K12.Data.SubjectScore(); #region 建立newScore //foreach (string field in new string[] { "領域", "科目", "權數", "節數", "分數評量", "努力程度", "文字描述", "註記" }) //foreach (string field in new string[] { "領域", "科目", "權數", "節數", "分數評量", "文字描述", "註記" }) foreach (string field in new string[] { "領域", "科目", "權數", "節數", "成績", "原始成績", "補考成績", "文字描述", "註記" }) { if (e.ImportFields.Contains(field)) { decimal d; #region 填入科目資訊 string value = row[field]; switch (field) { default: break; case "領域": subjectScore.Domain = value; break; case "科目": subjectScore.Subject = value; break; case "權數": subjectScore.Credit = decimal.Parse(value); break; case "節數": subjectScore.Period = decimal.Parse(value); break; //case "分數評量": // decimal d; // if (decimal.TryParse(value, out d)) // subjectScore.Score = d; // else // subjectScore.Score = null; // break; case "成績": if (decimal.TryParse(value, out d)) { subjectScore.Score = d; } else { subjectScore.Score = null; } break; case "原始成績": if (decimal.TryParse(value, out d)) { subjectScore.ScoreOrigin = d; } else { subjectScore.ScoreOrigin = null; } break; case "補考成績": if (decimal.TryParse(value, out d)) { subjectScore.ScoreMakeup = d; } else { subjectScore.ScoreMakeup = null; } break; //case "努力程度": // int i; // if (int.TryParse(value, out i)) // subjectScore.Effort = i; // else // subjectScore.Effort = null; // break; case "文字描述": subjectScore.Text = value; break; case "註記": subjectScore.Comment = value; break; } #endregion } } #endregion //subjectScoreInfo.AppendChild(newScore); JHSemesterScoreRecord record = semesterScoreDictionary[info]; if (!record.Subjects.ContainsKey(subjectScore.Subject)) { record.Subjects.Add(subjectScore.Subject, subjectScore); } else { record.Subjects[subjectScore.Subject] = subjectScore; } updateList.Add(record); } } #endregion //updateList.Add(new SmartSchool.Feature.Score.EditScore.UpdateInfo(semesterScoreID, gradeyear, subjectScoreInfo)); } #endregion //處理新增成績學期 #region 處理新增成績學期 foreach (SemesterInfo info in insertNewSemesterScore.Keys) { //int gradeyear = semesterGradeYear[info];//抓年級 foreach (RowData row in insertNewSemesterScore[info]) { K12.Data.SubjectScore subjectScore = new K12.Data.SubjectScore(); //foreach (string field in new string[] { "領域", "科目", "權數", "節數", "分數評量", "努力程度", "文字描述", "註記" }) //foreach (string field in new string[] { "領域", "科目", "權數", "節數", "分數評量", "文字描述", "註記" }) foreach (string field in new string[] { "領域", "科目", "權數", "節數", "成績", "原始成績", "補考成績", "文字描述", "註記" }) { if (e.ImportFields.Contains(field)) { decimal d; string value = row[field]; switch (field) { default: break; case "領域": subjectScore.Domain = value; break; case "科目": subjectScore.Subject = value; break; case "權數": subjectScore.Credit = decimal.Parse(value); break; case "節數": subjectScore.Period = decimal.Parse(value); break; //case "分數評量": // decimal d; // if (decimal.TryParse(value, out d)) // subjectScore.Score = d; // else // subjectScore.Score = null; // break; case "成績": if (decimal.TryParse(value, out d)) { subjectScore.Score = d; } else { subjectScore.Score = null; } break; case "原始成績": if (decimal.TryParse(value, out d)) { subjectScore.ScoreOrigin = d; } else { subjectScore.ScoreOrigin = null; } break; case "補考成績": if (decimal.TryParse(value, out d)) { subjectScore.ScoreMakeup = d; } else { subjectScore.ScoreMakeup = null; } break; //case "努力程度": // int i; // if (int.TryParse(value, out i)) // subjectScore.Effort = i; // else // subjectScore.Effort = null; // break; case "文字描述": subjectScore.Text = value; break; case "註記": subjectScore.Comment = value; break; } } } //subjectScoreInfo.AppendChild(newScore); JHSemesterScoreRecord record = new JHSemesterScoreRecord(); record.SchoolYear = info.SchoolYear; record.Semester = info.Semester; record.RefStudentID = studentRec.ID; //record.GradeYear = gradeyear; if (!record.Subjects.ContainsKey(subjectScore.Subject)) { record.Subjects.Add(subjectScore.Subject, subjectScore); } else { record.Subjects[subjectScore.Subject] = subjectScore; } insertList.Add(record); } //insertList.Add(new SmartSchool.Feature.Score.AddScore.InsertInfo(studentRec.StudentID, "" + sy, "" + se, gradeyear, "", subjectScoreInfo)); } #endregion } #endregion Dictionary <string, JHSemesterScoreRecord> iList = new Dictionary <string, JHSemesterScoreRecord>(); Dictionary <string, JHSemesterScoreRecord> uList = new Dictionary <string, JHSemesterScoreRecord>(); foreach (var record in insertList) { string key = record.RefStudentID + "_" + record.SchoolYear + "_" + record.Semester; if (!iList.ContainsKey(key)) { iList.Add(key, new JHSemesterScoreRecord()); } JHSemesterScoreRecord newRecord = iList[key]; newRecord.RefStudentID = record.RefStudentID; newRecord.SchoolYear = record.SchoolYear; newRecord.Semester = record.Semester; foreach (var subject in record.Subjects.Keys) { if (!newRecord.Subjects.ContainsKey(subject)) { newRecord.Subjects.Add(subject, record.Subjects[subject]); } } } foreach (var record in updateList) { string key = record.RefStudentID + "_" + record.SchoolYear + "_" + record.Semester; if (!uList.ContainsKey(key)) { uList.Add(key, record); } JHSemesterScoreRecord newRecord = uList[key]; newRecord.RefStudentID = record.RefStudentID; newRecord.SchoolYear = record.SchoolYear; newRecord.Semester = record.Semester; newRecord.ID = record.ID; foreach (var subject in record.Subjects.Keys) { if (!newRecord.Subjects.ContainsKey(subject)) { newRecord.Subjects.Add(subject, record.Subjects[subject]); } } } List <string> ids = new List <string>(id_Rows.Keys); Dictionary <string, JHSemesterScoreRecord> origs = new Dictionary <string, JHSemesterScoreRecord>(); foreach (var record in JHSemesterScore.SelectByStudentIDs(ids)) { if (!origs.ContainsKey(record.ID)) { origs.Add(record.ID, record); } } foreach (var record in uList.Values) { if (origs.ContainsKey(record.ID)) { foreach (var domain in origs[record.ID].Domains.Keys) { if (!record.Domains.ContainsKey(domain)) { record.Domains.Add(domain, origs[record.ID].Domains[domain]); } } } } JHSemesterScore.Insert(new List <JHSemesterScoreRecord>(iList.Values)); JHSemesterScore.Update(new List <JHSemesterScoreRecord>(uList.Values)); FISCA.LogAgent.ApplicationLog.Log("成績系統.匯入匯出", "匯入學期科目成績", "總共匯入" + (insertList.Count + updateList.Count) + "筆學期科目成績。"); #endregion }; wizard.ImportComplete += delegate { MsgBox.Show("匯入完成"); }; }
private void btnSave_Click(object sender, EventArgs e) { if (!inputed) { MsgBox.Show("尚未輸入成績"); return; } // 驗證所有權數欄位 ValidAllPCTextBox(); if (!IsValid()) { return; } try { int schoolYear = int.Parse(cboSchoolYear.Text); int semester = int.Parse(cboSemester.Text); //int gradeYear = 0; //SemesterScoreRecordEditor editor = new SemesterScoreRecordEditor(_student, schoolYear, semester, gradeYear); JHSemesterScoreRecord newRecord = new JHSemesterScoreRecord(); newRecord.RefStudentID = _student.ID; newRecord.SchoolYear = schoolYear; newRecord.Semester = semester; List <string> checkSubjName = new List <string>(); // 檢查科目名稱是否相同,因為科目名稱重複會造成新增錯誤,科目名稱是唯一值。 foreach (DataGridViewRow row in dgv.Rows) { if (row.Cells[chsSubject.Index].Value != null) { string tmpSubjName = "" + row.Cells[chsSubject.Index].Value; if (checkSubjName.Contains(tmpSubjName)) { FISCA.Presentation.Controls.MsgBox.Show("科目名稱重複,無法儲存。"); return; } else { checkSubjName.Add(tmpSubjName); } } } //2018/4/16 穎驊因應高雄項目[02-03][06]學期成績,快速新增功能如無原始成績,則結算學期領域成績時快速新增的成績都會變成"0"分 // 新增原始成績登錄、語文領域,另外看來以前不流行 datagridView 這土法煉鋼有點驚人呀!!。 //2018/5/22 穎驊再次註解,恩正說不必新增原始成績欄位給屬用者輸入,直接抓分數就好,所以將上一版的輸入格拿掉 if (CheckDomainValid(txtPC1, txtScore1, txtScore1, txtEffort1)) { newRecord.Domains.Add("國語文", GetDomainScore("國語文", txtPC1, txtScore1, txtScore1, txtEffort1, txtText1)); } if (CheckDomainValid(txtPC2, txtScore2, txtScore2, txtEffort2)) { newRecord.Domains.Add("英語", GetDomainScore("英語", txtPC2, txtScore2, txtScore2, txtEffort2, txtText2)); } if (CheckDomainValid(txtPC3, txtScore3, txtScore3, txtEffort3)) { newRecord.Domains.Add("數學", GetDomainScore("數學", txtPC3, txtScore3, txtScore3, txtEffort3, txtText3)); } if (CheckDomainValid(txtPC4, txtScore4, txtScore4, txtEffort4)) { newRecord.Domains.Add("社會", GetDomainScore("社會", txtPC4, txtScore4, txtScore4, txtEffort4, txtText4)); } //if (CheckDomainValid(txtPC5, txtScore5, txtScore5, txtEffort5)) // newRecord.Domains.Add("藝術與人文", GetDomainScore("藝術與人文", txtPC5, txtScore5, txtScore5, txtEffort5, txtText5)); //if (CheckDomainValid(txtPC6, txtScore6, txtScore6, txtEffort6)) // newRecord.Domains.Add("自然與生活科技", GetDomainScore("自然與生活科技", txtPC6, txtScore6, txtScore6, txtEffort6, txtText6)); if (CheckDomainValid(txtPC5, txtScore5, txtScore5, txtEffort5)) { newRecord.Domains.Add("自然科學", GetDomainScore("自然科學", txtPC5, txtScore5, txtScore5, txtEffort5, txtText5)); } if (CheckDomainValid(txtPC6, txtScore6, txtScore6, txtEffort6)) { newRecord.Domains.Add("藝術", GetDomainScore("藝術", txtPC6, txtScore6, txtScore6, txtEffort6, txtText6)); } if (CheckDomainValid(txtPC7, txtScore7, txtScore7, txtEffort7)) { newRecord.Domains.Add("健康與體育", GetDomainScore("健康與體育", txtPC7, txtScore7, txtScore7, txtEffort7, txtText7)); } if (CheckDomainValid(txtPC8, txtScore8, txtScore8, txtEffort8)) { newRecord.Domains.Add("綜合活動", GetDomainScore("綜合活動", txtPC8, txtScore8, txtScore8, txtEffort8, txtText8)); } if (CheckDomainValid(txtPC9, txtScore9, txtScore9, txtEffort9)) { newRecord.Domains.Add("語文", GetDomainScore("語文", txtPC9, txtScore9, txtScore9, txtEffort9, txtText9)); } if (CheckDomainValid(txtPC10, txtScore10, txtScore10, txtEffort10)) { newRecord.Domains.Add("科技", GetDomainScore("科技", txtPC10, txtScore10, txtScore10, txtEffort10, txtText10)); } foreach (DataGridViewRow row in dgv.Rows) { if (row.IsNewRow) { continue; } PeriodCredit pc = new PeriodCredit(); pc.Parse("" + row.Cells[chsPeriodCredit.Index].Value); K12.Data.SubjectScore subject = new K12.Data.SubjectScore(); subject.Domain = "" + row.Cells[chsDomain.Index].Value; subject.Subject = "" + row.Cells[chsSubject.Index].Value; subject.Period = pc.Period; subject.Credit = pc.Credit; subject.Score = decimal.Parse("" + row.Cells[chsScore.Index].Value); subject.ScoreOrigin = decimal.Parse("" + row.Cells[chsScore.Index].Value); // 2018/5/22 穎華聽從恩正建議,原始成績直接抓取成績即可 subject.Effort = int.Parse("" + row.Cells[chsEffort.Index].Value); subject.Text = "" + row.Cells[chsText.Index].Value; newRecord.Subjects.Add(subject.Subject, subject); } if (!string.IsNullOrEmpty(txtElastic.Text)) { newRecord.Domains.Add("彈性課程", GetElasticDomain()); } if (!string.IsNullOrEmpty(txtLearnDomain.Text)) { newRecord.LearnDomainScore = decimal.Parse(txtLearnDomain.Text); } if (!string.IsNullOrEmpty(txtCourseLearn.Text)) { newRecord.CourseLearnScore = decimal.Parse(txtCourseLearn.Text); } JHSemesterScore.Insert(newRecord); SaveLog(newRecord); } catch (Exception ex) { MsgBox.Show("儲存失敗"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } this.DialogResult = DialogResult.OK; }
public RSubjectScore(K12.Data.SubjectScore score) { Name = score.Subject; Score = score.Score; //Period = score.Period; }
private void btnSave_Click(object sender, EventArgs e) { if (!inputed) { MsgBox.Show("尚未輸入成績"); return; } if (!IsValid()) { return; } try { int schoolYear = int.Parse(cboSchoolYear.Text); int semester = int.Parse(cboSemester.Text); //int gradeYear = 0; //SemesterScoreRecordEditor editor = new SemesterScoreRecordEditor(_student, schoolYear, semester, gradeYear); JHSemesterScoreRecord newRecord = new JHSemesterScoreRecord(); newRecord.RefStudentID = _student.ID; newRecord.SchoolYear = schoolYear; newRecord.Semester = semester; List <string> checkSubjName = new List <string>(); // 檢查科目名稱是否相同,因為科目名稱重複會造成新增錯誤,科目名稱是唯一值。 foreach (DataGridViewRow row in dgv.Rows) { if (row.Cells[chsSubject.Index].Value != null) { string tmpSubjName = "" + row.Cells[chsSubject.Index].Value; if (checkSubjName.Contains(tmpSubjName)) { FISCA.Presentation.Controls.MsgBox.Show("科目名稱重複,無法儲存。"); return; } else { checkSubjName.Add(tmpSubjName); } } } if (CheckDomainValid(txtPC1, txtScore1, txtEffort1)) { newRecord.Domains.Add("國語文", GetDomainScore("國語文", txtPC1, txtScore1, txtEffort1, txtText1)); } if (CheckDomainValid(txtPC2, txtScore2, txtEffort2)) { newRecord.Domains.Add("英語", GetDomainScore("英語", txtPC2, txtScore2, txtEffort2, txtText2)); } if (CheckDomainValid(txtPC3, txtScore3, txtEffort3)) { newRecord.Domains.Add("數學", GetDomainScore("數學", txtPC3, txtScore3, txtEffort3, txtText3)); } if (CheckDomainValid(txtPC4, txtScore4, txtEffort4)) { newRecord.Domains.Add("社會", GetDomainScore("社會", txtPC4, txtScore4, txtEffort4, txtText4)); } if (CheckDomainValid(txtPC5, txtScore5, txtEffort5)) { newRecord.Domains.Add("藝術與人文", GetDomainScore("藝術與人文", txtPC5, txtScore5, txtEffort5, txtText5)); } if (CheckDomainValid(txtPC6, txtScore6, txtEffort6)) { newRecord.Domains.Add("自然與生活科技", GetDomainScore("自然與生活科技", txtPC6, txtScore6, txtEffort6, txtText6)); } if (CheckDomainValid(txtPC7, txtScore7, txtEffort7)) { newRecord.Domains.Add("健康與體育", GetDomainScore("健康與體育", txtPC7, txtScore7, txtEffort7, txtText7)); } if (CheckDomainValid(txtPC8, txtScore8, txtEffort8)) { newRecord.Domains.Add("綜合活動", GetDomainScore("綜合活動", txtPC8, txtScore8, txtEffort8, txtText8)); } foreach (DataGridViewRow row in dgv.Rows) { if (row.IsNewRow) { continue; } PeriodCredit pc = new PeriodCredit(); pc.Parse("" + row.Cells[chsPeriodCredit.Index].Value); K12.Data.SubjectScore subject = new K12.Data.SubjectScore(); subject.Domain = "" + row.Cells[chsDomain.Index].Value; subject.Subject = "" + row.Cells[chsSubject.Index].Value; subject.Period = pc.Period; subject.Credit = pc.Credit; subject.Score = decimal.Parse("" + row.Cells[chsScore.Index].Value); subject.Effort = int.Parse("" + row.Cells[chsEffort.Index].Value); subject.Text = "" + row.Cells[chsText.Index].Value; newRecord.Subjects.Add(subject.Subject, subject); } if (!string.IsNullOrEmpty(txtElastic.Text)) { newRecord.Domains.Add("彈性課程", GetElasticDomain()); } if (!string.IsNullOrEmpty(txtLearnDomain.Text)) { newRecord.LearnDomainScore = decimal.Parse(txtLearnDomain.Text); } if (!string.IsNullOrEmpty(txtCourseLearn.Text)) { newRecord.CourseLearnScore = decimal.Parse(txtCourseLearn.Text); } JHSemesterScore.Insert(newRecord); SaveLog(newRecord); } catch (Exception ex) { MsgBox.Show("儲存失敗"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } this.DialogResult = DialogResult.OK; }
private void btnSave_Click(object sender, EventArgs e) { if (!inputed) { MsgBox.Show("尚未輸入成績"); return; } if (!IsValid()) { return; } try { int schoolYear = int.Parse(cboSchoolYear.Text); int semester = int.Parse(cboSemester.Text); //int gradeYear = 0; //SemesterScoreRecordEditor editor = new SemesterScoreRecordEditor(_student, schoolYear, semester, gradeYear); JHSemesterScoreRecord newRecord = new JHSemesterScoreRecord(); newRecord.RefStudentID = _student.ID; newRecord.SchoolYear = schoolYear; newRecord.Semester = semester; // 2018.09.22 [ischoolKingdom] Vicky依據 [J成績][HC][03] 快速新增學期成績修正,將語文領域的子領域兩個項目欄位拿掉,僅保留輸入語文領域成績的單一功能。 if (CheckDomainValid(textBoxPC1, textBoxScore1, textBoxEffort1)) { newRecord.Domains.Add("語文", GetDomainScore("語文", textBoxPC1, textBoxScore1, textBoxEffort1, textBoxText1)); } if (CheckDomainValid(textBoxPC2, textBoxScore2, textBoxEffort2)) { newRecord.Domains.Add("數學", GetDomainScore("數學", textBoxPC2, textBoxScore2, textBoxEffort2, textBoxText2)); } if (CheckDomainValid(textBoxPC3, textBoxScore3, textBoxEffort3)) { newRecord.Domains.Add("社會", GetDomainScore("社會", textBoxPC3, textBoxScore3, textBoxEffort3, textBoxText3)); } //if (CheckDomainValid(textBoxPC4, textBoxScore4, textBoxEffort4)) // newRecord.Domains.Add("藝術與人文", GetDomainScore("藝術與人文", textBoxPC4, textBoxScore4, textBoxEffort4, textBoxText4)); //if (CheckDomainValid(textBoxPC5, textBoxScore5, textBoxEffort5)) // newRecord.Domains.Add("自然與生活科技", GetDomainScore("自然與生活科技", textBoxPC5, textBoxScore5, textBoxEffort5, textBoxText5)); if (CheckDomainValid(textBoxPC4, textBoxScore4, textBoxEffort4)) { newRecord.Domains.Add("藝術", GetDomainScore("藝術", textBoxPC4, textBoxScore4, textBoxEffort4, textBoxText4)); } if (CheckDomainValid(textBoxPC5, textBoxScore5, textBoxEffort5)) { newRecord.Domains.Add("自然科學", GetDomainScore("自然科學", textBoxPC5, textBoxScore5, textBoxEffort5, textBoxText5)); } if (CheckDomainValid(textBoxPC6, textBoxScore6, textBoxEffort6)) { newRecord.Domains.Add("健康與體育", GetDomainScore("健康與體育", textBoxPC6, textBoxScore6, textBoxEffort6, textBoxText6)); } if (CheckDomainValid(textBoxPC7, textBoxScore7, textBoxEffort7)) { newRecord.Domains.Add("綜合活動", GetDomainScore("綜合活動", textBoxPC7, textBoxScore7, textBoxEffort7, textBoxText7)); } if (CheckDomainValid(textBoxPC8, textBoxScore8, textBoxEffort8)) { newRecord.Domains.Add("科技", GetDomainScore("科技", textBoxPC8, textBoxScore8, textBoxEffort8, textBoxText8)); } foreach (DataGridViewRow row in dgv.Rows) { if (row.IsNewRow) { continue; } PeriodCredit pc = new PeriodCredit(); pc.Parse("" + row.Cells[chsPeriodCredit.Index].Value); K12.Data.SubjectScore subject = new K12.Data.SubjectScore(); subject.Domain = "" + row.Cells[chsDomain.Index].Value; subject.Subject = "" + row.Cells[chsSubject.Index].Value; subject.Period = pc.Period; subject.Credit = pc.Credit; subject.Score = decimal.Parse("" + row.Cells[chsScore.Index].Value); // 2018.09.22 [ischoolKingdom] Vicky 依據 [J成績][HC][03]快速新增學期成績修正 項目,使輸入成績一併儲存至原始成績。 subject.ScoreOrigin = decimal.Parse("" + row.Cells[chsScore.Index].Value); //subject.Effort = int.Parse("" + row.Cells[chsEffort.Index].Value); subject.Effort = 1; subject.Text = "" + row.Cells[chsText.Index].Value; newRecord.Subjects.Add(subject.Subject, subject); } if (!string.IsNullOrEmpty(textBoxX33.Text)) { newRecord.Domains.Add("彈性課程", GetElasticDomain()); } if (!string.IsNullOrEmpty(textBoxX34.Text)) { newRecord.LearnDomainScore = decimal.Parse(textBoxX34.Text); } if (!string.IsNullOrEmpty(textBoxX35.Text)) { newRecord.CourseLearnScore = decimal.Parse(textBoxX35.Text); } JHSemesterScore.Insert(newRecord); SaveLog(newRecord); } catch (Exception ex) { MsgBox.Show("儲存失敗"); this.DialogResult = DialogResult.Cancel; this.Close(); return; } this.DialogResult = DialogResult.OK; }