private void worker_DoWork(object sender, DoWorkEventArgs e)
{
List <StudentScore> Students = StudentIDs.ToStudentScore();
List <StudentScore> noValid = Students.ReadCalculationRule(this); //沒有計算規則的學生。
if (noValid.Count > 0)
{
throw new CalculationException(noValid, "下列學生沒有計算規則，無法計算成績。");
}
Students.ReadSemesterScore(SchoolYear, Semester, this);
if (RecalculateAll)
{
Students.ClearLearningDomainScore(SemesterData.Empty);
}
Students.CalculateLearningDomainSemesterScore(new string[] { });
Students.SaveSemesterScore(this);
//儲存 Log。
try
{
LogSaver logger = FISCA.LogAgent.ApplicationLog.CreateLogSaverInstance();
logger.Log("學生學期學習領域成績計算(學生)", "計算學生學期學習領域成績", "計算學生數：" + Students.Count);
//logger.BatchLogCompleted += delegate(object sender1, EventArgs e1) { };
//logger.BatchLogFailure += delegate(object sender1, LogErrorEventArgs e1) { };
foreach (StudentScore each in Students)
{
StringBuilder description = new StringBuilder();
description.AppendLine(string.Format("學生：{0}({1})", each.Name, each.StudentNumber));
description.AppendLine(string.Format("學年度：{0} 學期：{1}", SchoolYear, Semester));
foreach (LogData log in each.SemestersScore[SemesterData.Empty].Domain.Log)
{
description.Append(log.ToString());
}
description.Append(each.SemestersScore[SemesterData.Empty].LearningLog.ToString());
description.Append(each.SemestersScore[SemesterData.Empty].CourseLog.ToString());
logger.AddBatch("學生學期學習領域成績計算(學生)", "計算學生學期學習領域成績", "student", each.Id, description.ToString());
}
logger.LogBatch();
}
catch { }
Feedback("", 0);
}
private void worker_DoWork(object sender, DoWorkEventArgs e)
{
List <StudentScore> Students = StudentIDs.ToStudentScore();
List <StudentScore> noValid = Students.ReadCalculationRule(this); //沒有計算規則的學生。
if (noValid.Count > 0)
{
throw new CalculationException(noValid, "下列學生沒有計算規則，無法計算成績。");
}
// 2016/ 6/6 穎驊製作，恩正說從這邊先於Students.ReadAttendScore 攔科目名稱重覆，否則進去攔的資料太複雜，
#region 檢查科目重複問題
Feedback("檢查學生修課內容", 0);
List <JHSCAttendRecord> scAttendList = JHSCAttend.SelectByStudentIDs(StudentIDs);
Dictionary <string, List <JHSCAttendRecord> > scAttendCheck = new Dictionary <string, List <JHSchool.Data.JHSCAttendRecord> >();
// 穎驊重做，檢查重覆修習科目
Dictionary <string, List <JHSCAttendRecord> > duplicateErrorCourse = new Dictionary <string, List <JHSCAttendRecord> >();
//把課程讀下來快取，穎驊筆記: 這一行超級重要，如果沒有的話至少多100倍的時間下面Foreach 才能算完，不誇張
JHSchool.Data.JHCourse.SelectAll();
//List<string> ErrorMessages = new List<string>();
int count = 0;
foreach (JHSCAttendRecord scAttendRec in scAttendList)
{
Feedback("檢查學生修課內容", ++count * 100 / scAttendList.Count);
if (scAttendRec.Course.SchoolYear == SchoolYear && scAttendRec.Course.Semester == Semester && scAttendRec.Course.CalculationFlag == "1")
{
String duplicateErrorCourseKey = scAttendRec.Student.ID + "_" + scAttendRec.Course.Subject;
if (!scAttendCheck.ContainsKey(duplicateErrorCourseKey))
{
scAttendCheck.Add(duplicateErrorCourseKey, new List <JHSchool.Data.JHSCAttendRecord>());
}
else
{
//重複了
if (!duplicateErrorCourse.ContainsKey(duplicateErrorCourseKey))
{
duplicateErrorCourse.Add(duplicateErrorCourseKey, scAttendCheck[duplicateErrorCourseKey]);
}
}
scAttendCheck[duplicateErrorCourseKey].Add(scAttendRec);
}
}
if (duplicateErrorCourse.Count > 0)
{
throw new DuplicatedSubjectException(new List <List <JHSCAttendRecord> >(duplicateErrorCourse.Values));
}
#endregion
Students.ReadAttendScore(SchoolYear, Semester, new string[] { }, this);
noValid = Students.CalcuateAttendScore(this); //回傳沒有修課的學生。
Students.SaveAttendScore(new string[] { }, this);
Students.ReadSemesterScore(SchoolYear, Semester, this);
if (RecalculateAll)
{
Students.ClearSubjectScore(SemesterData.Empty);
}
Students.CalcuateSubjectSemesterScore(new string[] { });
Students.SaveSemesterScore(this);
//儲存 Log。
try
{
LogSaver logger = FISCA.LogAgent.ApplicationLog.CreateLogSaverInstance();
logger.Log("學生學期科目成績計算(學生)", "計算學生學期科目成績", "計算學生數：" + Students.Count);
//logger.BatchLogCompleted += delegate(object sender1, EventArgs e1) { };
//logger.BatchLogFailure += delegate(object sender1, LogErrorEventArgs e1) { };
foreach (StudentScore each in Students)
{
StringBuilder description = new StringBuilder();
description.AppendLine(string.Format("學生：{0}({1})", each.Name, each.StudentNumber));
description.AppendLine(string.Format("學年度：{0} 學期：{1}", SchoolYear, Semester));
foreach (LogData log in each.SemestersScore[SemesterData.Empty].Subject.Log)
{
description.Append(log.ToString());
}
logger.AddBatch("學生學期科目成績計算(學生)", "計算學生學期科目成績", "student", each.Id, description.ToString());
}
logger.LogBatch();
}
catch { }
}
/// <summary>
/// 每1000筆資料,分批執行匯入
/// Return是Log資訊
/// </summary>
public override string Import(List <Campus.DocumentValidator.IRowStream> Rows)
{
List <MoralScoreLogRobot> LogList = new List <MoralScoreLogRobot>();
//取得匯入資料中,所有學生編號下的的日常生活表現資料
List <SHMoralScoreRecord> MoralScoreList = GetMoralScoreList(Rows);
List <SHMoralScoreRecord> InsertList = new List <SHMoralScoreRecord>();
List <SHMoralScoreRecord> UpdateList = new List <SHMoralScoreRecord>();
int NochangeCount = 0; //未處理資料記數
if (mOption.Action == ImportAction.InsertOrUpdate)
{
foreach (IRowStream Row in Rows)
{
int SchoolYear = int.Parse(Row.GetValue("學年度"));
int Semester = int.Parse(Row.GetValue("學期"));
string StudentNumber = Row.GetValue("學號");
SHStudentRecord student = StudentRecordByStudentNumber[StudentNumber];
SHMoralScoreRecord SSR = GetMoralScoreRecord(MoralScoreList, StudentNumber, SchoolYear, Semester);
//Log機器人
MoralScoreLogRobot log = new MoralScoreLogRobot(student, faceDic.Keys.ToList());
if (SSR == null) //新增SHMoralScoreRecord
{
SHMoralScoreRecord newRecord = new SHMoralScoreRecord();
newRecord.RefStudentID = student.ID;
newRecord.SchoolYear = SchoolYear;
newRecord.Semester = Semester;
newRecord.TextScore = GetInsertTextScore(Row);
//Log
log.SetOldLost();
log.SetNew(newRecord);
InsertList.Add(newRecord);
}
else //已存在資料需要修改 or 覆蓋
{
//Log(old)
log.SetOld(SSR);
//取得新的Xml結構
SSR.TextScore = GetUpdateTextScore(SSR, Row);
//Log(New)
log.SetNew(SSR);
if (!string.IsNullOrEmpty(log.LogToString()))
{
UpdateList.Add(SSR);
}
}
LogList.Add(log);
}
}
if (InsertList.Count > 0)
{
try
{
SHMoralScore.Insert(InsertList);
}
catch (Exception ex)
{
MsgBox.Show("於新增資料時發生錯誤!!\n" + ex.Message);
}
}
if (UpdateList.Count > 0)
{
try
{
SHMoralScore.Update(UpdateList);
}
catch (Exception ex)
{
MsgBox.Show("於更新資料時發生錯誤!!\n" + ex.Message);
}
}
//批次記錄Log
LogSaver Batch = FISCA.LogAgent.ApplicationLog.CreateLogSaverInstance();
foreach (MoralScoreLogRobot each in LogList)
{
if (!string.IsNullOrEmpty(each.LogToString()))
{
Batch.AddBatch("學務系統.匯入文字評量", "student", each._student.ID, each.LogToString());
}
else
{
NochangeCount++;
}
}
Batch.LogBatch(true);
//Summary Log
StringBuilder sbSummary = new StringBuilder();
sbSummary.AppendLine("匯入文字評量操作：");
sbSummary.AppendLine("新增：" + InsertList.Count + "筆資料");
sbSummary.AppendLine("更新：" + UpdateList.Count + "筆資料");
sbSummary.AppendLine("未更動：" + NochangeCount + "筆資料");
FISCA.LogAgent.ApplicationLog.Log("學務系統.匯入文字評量", "匯入", sbSummary.ToString());
//StringBuilder sbSummary2 = new StringBuilder();
//sbSummary2.AppendLine("匯入文字評量操作：");
//sbSummary2.AppendLine("新增：" + InsertList.Count + "筆資料");
//sbSummary2.AppendLine("更新：" + UpdateList.Count + "筆資料");
//sbSummary2.AppendLine("未更動：" + NochangeCount + "筆資料");
return("");
}
private void worker_DoWork(object sender, DoWorkEventArgs e)
{
List <StudentScore> Students = StudentIDs.ToStudentScore();
List <StudentScore> noValid = Students.ReadCalculationRule(this); //沒有計算規則的學生。
if (noValid.Count > 0)
{
throw new CalculationException(noValid, "下列學生沒有計算規則，無法計算畢業成績。");
}
Students.ReadSemesterScore(this); //讀取所有學期的成績。
Students.ReadSemesterHistory(this); //讀取學期歷程。
noValid = Students.VaidSixSemesterHistory(); //驗證學期歷程是否完整。
if (noValid.Count > 0)
{
throw new CalculationException(noValid, "下列學生學期歷程不完整，無法計算畢業成績。");
}
noValid = Students.ValidSixSemesterDomainScore(); //驗證學期成績是否完整。
if (noValid.Count > 0)
{
throw new CalculationException(noValid, "下列學生並沒有完整的十二學期成績，無法計算畢業成績。");
}
Students.ReadGraduateScore(this); //讀取畢業成績。
Students.CalculateGraduateScore(); //計算畢業成績。
// 取得學生 ID
List <string> StudIDs = (from Stud in Students select Stud.Id).ToList();
// 學生科目成績(彈性課程)
Dictionary <string, List <K12.Data.SubjectScore> > StudSubjScore = new Dictionary <string, List <K12.Data.SubjectScore> >();
Dictionary <string, decimal> StudDomainNullScore = new Dictionary <string, decimal>();
foreach (JHSemesterScoreRecord Scr in JHSemesterScore.SelectByStudentIDs(StudentIDs))
{
// 取得領域名稱空白
List <K12.Data.SubjectScore> ss = (from ss1 in Scr.Subjects where ss1.Value.Domain == "" select ss1.Value).ToList();
if (ss.Count > 0)
{
if (StudSubjScore.ContainsKey(Scr.RefStudentID))
{
StudSubjScore[Scr.RefStudentID].AddRange(ss);
}
else
{
StudSubjScore.Add(Scr.RefStudentID, ss);
}
}
}
// 計算彈性課程成績
foreach (KeyValuePair <string, List <K12.Data.SubjectScore> > data in StudSubjScore)
{
decimal sum = 0, Credit = 0;
foreach (K12.Data.SubjectScore ss in data.Value)
{
if (ss.Credit.HasValue)
{
Credit += ss.Credit.Value;
}
if (ss.Score.HasValue)
{
sum += ss.Score.Value;
}
}
if (!StudDomainNullScore.ContainsKey(data.Key))
{
if (Credit > 0)
{
decimal score = sum / Credit;
StudDomainNullScore.Add(data.Key, score);
}
}
}
foreach (StudentScore ss in Students)
{
if (StudDomainNullScore.ContainsKey(ss.Id))
{
//2017/5/9 穎驊修正 ，因應 高雄 [08-05][03] 畢業資格判斷成績及格標準調整 項目，
// 領域 分數超過60分 ，以 四捨五入取到小數第二位 ， 低於60分 採用 無條件進位至整數 (EX : 59.01 =60)
//decimal score = ss.CalculationRule.ParseDomainScore(StudDomainNullScore[ss.Id]);
decimal score = 0;
if (JHEvaluation.ScoreCalculation.Program.Mode == JHEvaluation.ScoreCalculation.ModuleMode.HsinChu)
{
score = ss.CalculationRule.ParseDomainScore(StudDomainNullScore[ss.Id]);
}
if (JHEvaluation.ScoreCalculation.Program.Mode == JHEvaluation.ScoreCalculation.ModuleMode.KaoHsiung)
{
if (StudDomainNullScore[ss.Id] >= 60)
{
score = ss.CalculationRule.ParseDomainScore(StudDomainNullScore[ss.Id]);
}
else
{
score = Math.Ceiling(StudDomainNullScore[ss.Id]);
}
}
if (ss.GraduateScore.Contains("彈性課程"))
{
ss.GraduateScore["彈性課程"].Value = score;
}
else
{
GraduateScore gs = new GraduateScore();
gs.Value = score;
ss.GraduateScore.Add("彈性課程", gs);
}
}
}
Students.SaveGraduateScore(this);//儲存畢業成績。
//儲存 Log。
try
{
LogSaver logger = FISCA.LogAgent.ApplicationLog.CreateLogSaverInstance();
logger.Log("學生畢業成績計算(學生)", "計算學生畢業成績", "計算學生數：" + Students.Count);
//logger.BatchLogCompleted += delegate(object sender1, EventArgs e1) { };
//logger.BatchLogFailure += delegate(object sender1, LogErrorEventArgs e1) { };
foreach (StudentScore each in Students)
{
StringBuilder description = new StringBuilder();
description.AppendLine(string.Format("學生：{0}({1})", each.Name, each.StudentNumber));
foreach (LogData log in each.GraduateScore.Log)
{
description.Append(log.ToString());
}
description.Append(each.GraduateScore.LearningLog.ToString());
description.Append(each.GraduateScore.CourseLog.ToString());
logger.AddBatch("學生畢業成績計算", "計算學生畢業成績", "student", each.Id, description.ToString());
}
logger.LogBatch();
}
catch { }
Feedback("", 0);
}