/// <summary>
/// 儲存學習歷程項目
/// </summary>
/// <param name="SemesterHistoryItemEntityList"></param>
public static void SetSemesterHistoryItemEntityList(List <SemesterHistoryItemEntity> SemesterHistoryItemEntityList, List <string> StudntIDList)
{
Dictionary <string, JHSemesterHistoryRecord> JHSemesterHistoryRecordDic = new Dictionary <string, JHSemesterHistoryRecord>();
foreach (JHSemesterHistoryRecord shr in JHSemesterHistory.SelectByStudentIDs(StudntIDList))
{
JHSemesterHistoryRecordDic.Add(shr.RefStudentID, shr);
}
List <JHSemesterHistoryRecord> UpadteRecList = new List <JHSemesterHistoryRecord>();
foreach (SemesterHistoryItemEntity shie in SemesterHistoryItemEntityList)
{
K12.Data.SemesterHistoryItem shi = new K12.Data.SemesterHistoryItem();
shi.ClassName = shie.ClassName;
shi.GradeYear = shie.GradeYear;
shi.SchoolDayCount = shie.SchoolDayCount;
shi.SchoolYear = shie.Schoolyear;
shi.SeatNo = shie.SeatNo;
shi.Semester = shie.Semester;
shi.Teacher = shie.TeacherName;
if (JHSemesterHistoryRecordDic.ContainsKey(shie.StudentID))
{
// 完全沒學習歷程
if (shie.HasSemsterHistoryRec == false && shie.EditMode == SemesterHistoryItemEntity._EditMode.Insert)
{
JHSemesterHistoryRecordDic[shie.StudentID].SemesterHistoryItems.Add(shi);
}
// 有學習歷程
if (shie.HasSemsterHistoryRec)
{
K12.Data.SemesterHistoryItem rmItem = null;
foreach (K12.Data.SemesterHistoryItem sh in JHSemesterHistoryRecordDic[shie.StudentID].SemesterHistoryItems)
{
// 檢查當有同學年度學期移除
if (sh.SchoolYear == shi.SchoolYear && sh.Semester == shi.Semester)
{
rmItem = sh;
}
}
// 先移除舊的
if (rmItem != null)
{
JHSemesterHistoryRecordDic[shie.StudentID].SemesterHistoryItems.Remove(rmItem);
}
if (shie.EditMode == SemesterHistoryItemEntity._EditMode.Insert)
{
JHSemesterHistoryRecordDic[shie.StudentID].SemesterHistoryItems.Add(shi);
}
if (shie.EditMode == SemesterHistoryItemEntity._EditMode.Update)
{
JHSemesterHistoryRecordDic[shie.StudentID].SemesterHistoryItems.Add(shi);
}
if (shie.EditMode == SemesterHistoryItemEntity._EditMode.Delete)
{
}
}
UpadteRecList.Add(JHSemesterHistoryRecordDic[shie.StudentID]);
}
}
JHSemesterHistory.Update(UpadteRecList);
}
public Dictionary <string, bool> Evaluate(IEnumerable <StudentRecord> list)
{
_result.Clear();
Dictionary <string, bool> passList = new Dictionary <string, bool>();
Dictionary <string, List <JHSemesterScoreRecord> > studentSemesterScoreCache = new Dictionary <string, List <JHSemesterScoreRecord> >();
foreach (JHSemesterScoreRecord record in JHSemesterScore.SelectByStudentIDs(list.AsKeyList()))
{
if (!studentSemesterScoreCache.ContainsKey(record.RefStudentID))
{
studentSemesterScoreCache.Add(record.RefStudentID, new List <JHSemesterScoreRecord>());
}
studentSemesterScoreCache[record.RefStudentID].Add(record);
}
//學生能被承認的學年度學期對照
Dictionary <string, List <string> > studentSYSM = new Dictionary <string, List <string> >();
#region 學期歷程
foreach (K12.Data.SemesterHistoryRecord shr in K12.Data.SemesterHistory.SelectByStudentIDs(list.Select(x => x.ID)))
{
if (!studentSYSM.ContainsKey(shr.RefStudentID))
{
studentSYSM.Add(shr.RefStudentID, new List <string>());
}
Dictionary <string, K12.Data.SemesterHistoryItem> check = new Dictionary <string, K12.Data.SemesterHistoryItem>()
{
{ "1a", null },
{ "1b", null },
{ "2a", null },
{ "2b", null },
{ "3a", null },
{ "3b", null }
};
foreach (K12.Data.SemesterHistoryItem item in shr.SemesterHistoryItems)
{
string grade = item.GradeYear + "";
if (grade == "7")
{
grade = "1";
}
if (grade == "8")
{
grade = "2";
}
if (grade == "9")
{
grade = "3";
}
if (grade == "1" || grade == "2" || grade == "3")
{
string key = "";
if (item.Semester == 1)
{
key = grade + "a";
}
else if (item.Semester == 2)
{
key = grade + "b";
}
else
{
continue;
}
//相同年級取較新的學年度
if (check[key] == null)
{
check[key] = item;
}
else if (item.SchoolYear > check[key].SchoolYear)
{
check[key] = item;
}
}
}
foreach (string key in check.Keys)
{
if (check[key] == null)
{
continue;
}
K12.Data.SemesterHistoryItem item = check[key];
studentSYSM[shr.RefStudentID].Add(item.SchoolYear + "_" + item.Semester);
}
}
#endregion
foreach (StudentRecord each in list)
{
List <ResultDetail> resultList = new List <ResultDetail>();
// 有學期成績
if (studentSemesterScoreCache.ContainsKey(each.ID))
{
// 存放符合標準畢業領域成績
List <decimal> passScoreList = new List <decimal>();
//每個學期整理後的成績
List <List <K12.Data.DomainScore> > GradeScoreList = new List <List <K12.Data.DomainScore> >();
// 取得學生學生領域成績填入計算畢業成績用
foreach (JHSemesterScoreRecord record in studentSemesterScoreCache[each.ID])
{
string key = record.SchoolYear + "_" + record.Semester;
//只處理承認的學年度學期
if (!studentSYSM.ContainsKey(each.ID) || !studentSYSM[each.ID].Contains(key))
{
continue;
}
//整理後的領域成績
List <K12.Data.DomainScore> domainScoreList = new List <K12.Data.DomainScore>();
K12.Data.DomainScore 語文 = new K12.Data.DomainScore();
語文.Domain = "語文";
decimal sum = 0;
decimal credit = 0;
// 2017/5/25 穎驊新增， 因應 高雄客服 高雄小組 [05-01][--] 項目調整，
// 舊有邏輯無論該學期是否已經有教務作業期末結算完產生 "語文領域" 的領域成績，
// 皆會再額外再幫它算一次並且加入語文領域總分、語文領域權重，此行為容易造成資料的組成比重不對，產生錯誤無法解釋的語文領域分數，
// 現在加入新判斷，如果該學期已經有 語文領域成績， 則不會再另外計算、加入該學期的語文領域成績，
// 反之，如果該學期 沒有語文領域成績， 會再計算一次 補上，以作為畢業預警判斷使用。
bool hasLanguageDomain = false;
//跑一遍領域成績
foreach (K12.Data.DomainScore domain in record.Domains.Values)
{
if (domain.Domain == "語文")
{
hasLanguageDomain = true;
}
//這三種挑出來處理
if (domain.Domain == "國語文" || domain.Domain == "英語")
{
if (domain.Score.HasValue && domain.Credit.HasValue)
{
sum += domain.Score.Value * domain.Credit.Value;
credit += domain.Credit.Value;
//處理高雄語文顯示
// 加權總分
if (!TempData.tmpStudDomainScoreDict.ContainsKey(record.RefStudentID))
{
TempData.tmpStudDomainScoreDict.Add(record.RefStudentID, new Dictionary <string, decimal>());
}
if (!TempData.tmpStudDomainCreditDict.ContainsKey(record.RefStudentID))
{
TempData.tmpStudDomainCreditDict.Add(record.RefStudentID, new Dictionary <string, decimal>());
}
if (!TempData.tmpStudDomainScoreDict[record.RefStudentID].ContainsKey(domain.Domain))
{
TempData.tmpStudDomainScoreDict[record.RefStudentID].Add(domain.Domain, 0);
}
// 學分數
if (!TempData.tmpStudDomainCreditDict[record.RefStudentID].ContainsKey(domain.Domain))
{
TempData.tmpStudDomainCreditDict[record.RefStudentID].Add(domain.Domain, 0);
}
TempData.tmpStudDomainScoreDict[record.RefStudentID][domain.Domain] += (domain.Score.Value * domain.Credit.Value);
TempData.tmpStudDomainCreditDict[record.RefStudentID][domain.Domain] += domain.Credit.Value;
}
}
else
{
domainScoreList.Add(domain);
}
}
if (!hasLanguageDomain && credit > 0)
{
語文.Score = Math.Round(sum / credit, 2, MidpointRounding.AwayFromZero);
語文.Credit = credit;
domainScoreList.Add(語文);
}
//會被加入就代表承認了
GradeScoreList.Add(domainScoreList);
}
Dictionary <string, decimal> domainScoreSum = new Dictionary <string, decimal>();
Dictionary <string, decimal> domainScoreCount = new Dictionary <string, decimal>();
foreach (List <K12.Data.DomainScore> scoreList in GradeScoreList)
{
foreach (K12.Data.DomainScore ds in scoreList)
{
string domainName = ds.Domain;
if (!domainScoreSum.ContainsKey(domainName))
{
domainScoreSum.Add(domainName, 0);
}
if (!domainScoreCount.ContainsKey(domainName))
{
domainScoreCount.Add(domainName, 0);
}
if (ds.Score.HasValue)
{
domainScoreSum[domainName] += ds.Score.Value;
//同一學期不會有相同領域名稱,可直接作++
domainScoreCount[domainName]++;
}
}
}
//2017/5/9 穎驊修正 ，因應 高雄 [08-05][03] 畢業資格判斷成績及格標準調整 項目，
// 領域 分數超過60分 ，以 四捨五入取到小數第二位 ， 低於60分 採用 無條件進位至整數 (EX : 59.01 =60)
// (只有高雄版有如此機制，新竹版照舊不管分數高低都是四捨五入)
foreach (string domainName in domainScoreCount.Keys)
{
if (domainScoreCount[domainName] > 0)
{
decimal grScore = 0;
if (JHEvaluation.ScoreCalculation.Program.Mode == JHEvaluation.ScoreCalculation.ModuleMode.HsinChu)
{
grScore = Math.Round(domainScoreSum[domainName] / domainScoreCount[domainName], 2, MidpointRounding.AwayFromZero);
}
if (JHEvaluation.ScoreCalculation.Program.Mode == JHEvaluation.ScoreCalculation.ModuleMode.KaoHsiung)
{
if (domainScoreSum[domainName] / domainScoreCount[domainName] >= 60)
{
grScore = Math.Round(domainScoreSum[domainName] / domainScoreCount[domainName], 2, MidpointRounding.AwayFromZero);
}
else
{
grScore = Math.Ceiling(domainScoreSum[domainName] / domainScoreCount[domainName]);
}
}
if (grScore >= _score)
{
passScoreList.Add(grScore);
}
StudentDomainResult.AddDomain(each.ID, domainName, grScore, grScore >= _score);
}
}
// 當及格數小於標準數，標示不符格畢業規範
if (passScoreList.Count < _domain_count)
{
ResultDetail rd = new ResultDetail(each.ID, "0", "0");
rd.AddMessage("領域畢業加權總平均成績不符合畢業規範");
rd.AddDetail("領域畢業加權總平均成績不符合畢業規範");
resultList.Add(rd);
}
}
if (resultList.Count > 0)
{
_result.Add(each.ID, resultList);
passList.Add(each.ID, false);
}
else
{
passList.Add(each.ID, true);
}
}
return(passList);
}
