ExamResultTFIELTSModel GetTFIELTSExamResult(Guid studentID) { //从数据库中根据StudentID、ExamDate、ExamType 选择考试条目 ExamResultEntity examResult = repository.ExamResult .FirstOrDefault(e => e.StudentID == studentID && e.IsBeforeSign == true && (e.ExamType == ExamType.TOFEL || e.ExamType == ExamType.IELTS)); if (examResult == null) { examResult = new ExamResultEntity { ResultID = Guid.NewGuid(), StudentID = studentID, ExamID = Guid.NewGuid(), IsBeforeSign = true, ExamType = ExamType.TOFEL }; } ExamResultTFIELTSEntity examResultDetail = repository.ExamResultTFIELTS.SingleOrDefault(e => e.ExamID == examResult.ExamID); if (examResultDetail == null) { examResultDetail = new ExamResultTFIELTSEntity { ExamID = examResult.ExamID, Total = examResult.Total }; } return new ExamResultTFIELTSModel { ExamResult = examResult, ExamResultDetail = examResultDetail }; }
public void SaveExamResultTFIELTS(ExamResultTFIELTSEntity tfIELTSDetail) { if (tfIELTSDetail.ExamID == Guid.Empty) tfIELTSDetail.ExamID = Guid.NewGuid(); ExamResultTFIELTSEntity originDetail = context.ExamResult_TF_IELTS.SingleOrDefault(e => e.ExamID == tfIELTSDetail.ExamID); if (originDetail == null) { context.ExamResult_TF_IELTS.Add(tfIELTSDetail); } else { context.Entry(originDetail).CurrentValues.SetValues(tfIELTSDetail); } context.SaveChanges(); }
public void SaveExamResultTFIELTS(ExamResultTFIELTSEntity tfIELTSDetail) { ExamResultTFIELTSEntity originDetail = context.ExamResult_TF_IELTS.SingleOrDefault(e => e.ExamID == tfIELTSDetail.ExamID); if (originDetail == null) { if (tfIELTSDetail.Total > 0) context.ExamResult_TF_IELTS.Add(tfIELTSDetail); else return; } else { if (tfIELTSDetail.Total > 0) context.Entry(originDetail).CurrentValues.SetValues(tfIELTSDetail); else context.ExamResult_TF_IELTS.Remove(originDetail); } context.SaveChanges(); }