using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Linq.Expressions; using EMIS.Entities; using EMIS.DataLogic.ScoreManage; using EMIS.ViewModel; using Bowin.Common.Linq.Entity; using Bowin.Common.Linq; using EMIS.ViewModel.ScoreManage; using EMIS.ViewModel.Students; using EMIS.DataLogic.Repositories; using EMIS.CommonLogic.CalendarManage; using EMIS.Utility.FormValidate; using EMIS.DataLogic.ChargeManage.ArrearsSituation; using EMIS.CommonLogic.SystemServices; using EMIS.ViewModel.CacheManage; namespace EMIS.CommonLogic.ScoreManage { public class FinalExaminationServices : BaseWorkflowServices, IFinalExaminationServices { public Lazy StudentScoreServices { get; set; } public ScoreDAL scoreDAL { get; set; } public FinalExaminationDAL finalExaminationDAL { get; set; } public Lazy SchoolYearServices { get; set; } public ScoreRepository scoreRepository { get; set; } public MisconductDAL MisconductDAL { get; set; } public Lazy ScoreServices { get; set; } public ExamsStateSettingDAL examsStateSettingDAL { get; set; } public Lazy ParameterServices { get; set; } public RetakePlanStudentRepository retakePlanStudentRepository { get; set; } protected Func, IQueryable> DataRangeFunction { get; set; } protected Func, IQueryable> GerenateResitDataRangeFunction { get; set; } protected Func>> CollegeExpression { get; set; } public FinalExaminationServices() { DataRangeFunction = (x => this.GetQueryByDataRangeByDepartment(x)); GerenateResitDataRangeFunction = (x => this.GetQueryByDataRangeByDepartment(x)); DataRangeUserFunc = ((x, y) => this.IsUserInDataRangeByDepartment(x, y)); CollegeExpression = (w => (x => x.CF_Department.CF_College.CollegeID == w)); } /// /// 获取工作流可录入状态 /// /// public int? GetIsEntryStatus() { var status = this.GetStatusViewList().Where(x => (x.Description ?? "").Contains("[ENTRY]")).Select(x => x.ID).FirstOrDefault(); return status; } /// /// 查询期末设定 /// /// /// /// /// /// /// /// /// /// /// public Bowin.Common.Linq.Entity.IGridResultSet GetFinalExaminationViewGrid(ViewModel.ConfiguretView configuretView, Guid? collegeID, Guid? departmentID, Guid? schoolyearID, Guid? coursematerialID, int? courseTypeID, int? examsCategoryID, int? examinationType, int? approvalStatus, int? gradeYearID, int pageIndex, int pageSize) { var statusList = this.GetStatusViewList(); Expression> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE); if (collegeID.HasValue) exp = exp.And(this.CollegeExpression(collegeID)); if (departmentID.HasValue) exp = exp.And(x => x.DepartmentID == departmentID); if (schoolyearID.HasValue) exp = exp.And(x => x.SchoolyearID == schoolyearID); if (coursematerialID.HasValue) exp = exp.And(x => x.CoursematerialID == coursematerialID); if (courseTypeID.HasValue) exp = exp.And(x => x.CourseTypeID == courseTypeID); if (examsCategoryID.HasValue) exp = exp.And(x => x.ExamsCategoryID == examsCategoryID); if (examinationType.HasValue) exp = exp.And(x => x.ExaminationType == examinationType); if (approvalStatus.HasValue) exp = exp.And(x => x.ApprovalStatus == approvalStatus); if (gradeYearID.HasValue) exp = exp.And(x => x.GradeYearID == gradeYearID); var query = finalExaminationDAL.GetFinalExaminationViewQueryable(exp); if (!string.IsNullOrEmpty(configuretView.ConditionValue)) query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim()); var resultQueryable = this.DataRangeFunction(query).OrderByDescending(x => x.SchoolyearCode).ThenByDescending(x => x.CourseName); var result = resultQueryable.ToGridResultSet(pageIndex, pageSize); result.rows.ForEach(x => x.ApprovalStatusName = statusList.FirstOrDefault(w => w.ID == x.ApprovalStatus).Name); return result; } /// /// 查询期末设定 /// /// /// /// /// /// /// /// /// /// /// public List GetFinalExaminationViewList(ViewModel.ConfiguretView configuretView, Guid? collegeID, Guid? departmentID, Guid? schoolyearID, Guid? coursematerialID, int? courseTypeID, int? examsCategoryID, int? examinationType, int? approvalStatus) { var statusList = this.GetStatusViewList(); Expression> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE); if (collegeID.HasValue) exp = exp.And(this.CollegeExpression(collegeID)); if (departmentID.HasValue) exp = exp.And(x => x.DepartmentID == departmentID); if (schoolyearID.HasValue) exp = exp.And(x => x.SchoolyearID == schoolyearID); if (coursematerialID.HasValue) exp = exp.And(x => x.CoursematerialID == coursematerialID); if (courseTypeID.HasValue) exp = exp.And(x => x.CourseTypeID == courseTypeID); if (examsCategoryID.HasValue) exp = exp.And(x => x.ExamsCategoryID == examsCategoryID); if (examinationType.HasValue) exp = exp.And(x => x.ExaminationType == examinationType); if (approvalStatus.HasValue) exp = exp.And(x => x.ApprovalStatus == approvalStatus); var query = finalExaminationDAL.GetFinalExaminationViewQueryable(exp); if (!string.IsNullOrEmpty(configuretView.ConditionValue)) query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim()); var result = this.DataRangeFunction(query).OrderByDescending(x => x.SchoolyearCode).ThenByDescending(x => x.CourseName).ToList(); result.ForEach(x => x.ApprovalStatusName = statusList.FirstOrDefault(w => w.ID == x.ApprovalStatus).Name); return result; } /// /// 查询考试设定相关学生明细表，按兵良要求，暂时用于补考设定学生明细导出功能 /// /// /// /// /// /// /// /// /// /// /// public List GetFinalExaminationStudentDetailsList(ViewModel.ConfiguretView configuretView, Guid? collegeID, Guid? departmentID, Guid? schoolyearID, Guid? coursematerialID, int? courseTypeID, int? examsCategoryID, int? examinationType, int? approvalStatus, int? gradeYearID, List FinalExaminationIDList) { var statusList = this.GetStatusViewList(); Expression> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE); if (FinalExaminationIDList != null) exp = exp.And(x => FinalExaminationIDList.Contains(x.FinalExaminationID)); if (collegeID.HasValue) exp = exp.And(this.CollegeExpression(collegeID)); if (departmentID.HasValue) exp = exp.And(x => x.DepartmentID == departmentID); if (schoolyearID.HasValue) exp = exp.And(x => x.SchoolyearID == schoolyearID); if (coursematerialID.HasValue) exp = exp.And(x => x.CoursematerialID == coursematerialID); if (courseTypeID.HasValue) exp = exp.And(x => x.CourseTypeID == courseTypeID); if (examsCategoryID.HasValue) exp = exp.And(x => x.ExamsCategoryID == examsCategoryID); if (examinationType.HasValue) exp = exp.And(x => x.ExaminationType == examinationType); if (approvalStatus.HasValue) exp = exp.And(x => x.ApprovalStatus == approvalStatus); if (gradeYearID.HasValue) exp = exp.And(x => x.GradeYearID == gradeYearID); var query = finalExaminationDAL.GetFinalExaminationStudentDetailsList(exp); if (!string.IsNullOrEmpty(configuretView.ConditionValue)) query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim()); var result = this.GerenateResitDataRangeFunction(query).OrderBy(x => x.SchoolyearCode).ThenBy(x => x.ClassmajorNo).ThenByDescending(x => x.CourseName).ToList(); //result.ForEach(x => x.ApprovalStatusName = statusList.FirstOrDefault(w => w.ID == x.ApprovalStatus).Name); return result; } /// /// 查询期末设定实体 /// /// /// public ViewModel.ScoreManage.FinalExaminationView GetFinalExaminationView(Guid? finalExaminationID) { Expression> exp = (x => x.FinalExaminationID == finalExaminationID); return finalExaminationDAL.GetFinalExaminationViewQueryable(exp).FirstOrDefault(); } /// /// 查询期末设定实体 /// /// /// public Entities.ER_FinalExamination GetFinalExamination(Guid? finalExaminationID) { return finalExaminationDAL.finalExaminationRepository.GetSingle(x => x.FinalExaminationID == finalExaminationID, (x => x.ER_FinalExaminationStudent), (x => x.ER_FinalExaminationStudent.Select(w => w.CF_Student)), (x => x.ER_Score), (x => x.CF_Schoolyear)); } /// /// 添加,加上总学时 /// /// public void FinalExaminationAdd(ViewModel.ScoreManage.FinalExaminationView finalExaminationView, List ClassmajorIDList) { try { var statusList = this.GetStatusViewList(); //获取工作流列表 ER_FinalExamination finalExamination = null; var schoolyear = SchoolYearServices.Value.GetSchoolYear(finalExaminationView.SchoolyearID); var listStudent=new List(); //var finalExaminationRepeat = finalExaminationDAL.finalExaminationRepository.GetSingle(x => x.ClassName == finalExaminationView.ClassName && x.FinalExaminationID != finalExaminationView.FinalExaminationID); //if (finalExaminationRepeat!=null) //{ // throw new Exception("录入班级名称重复！"); //} //取消期末设定，补考设定 录入班级名称唯一性判断 if (finalExaminationView.isAutoAdd==true) { listStudent= finalExaminationDAL.studentRepository.GetList(x => ClassmajorIDList.Contains(x.ClassmajorID), (x => x.CF_Classmajor.CF_Grademajor)).ToList(); } var userIDs = listStudent.Select(x => x.UserID).ToList(); if (finalExaminationView.FinalExaminationID == null || finalExaminationView.FinalExaminationID == Guid.Empty) { finalExaminationView.IsEntry = false; finalExamination = new ER_FinalExamination(); finalExamination.FinalExaminationID = Guid.NewGuid(); finalExamination.SchoolyearID = finalExaminationView.SchoolyearID; finalExamination.GradeYearID = finalExaminationView.GradeYearID; finalExamination.CollegeID = finalExaminationView.CollegeID; //finalExamination.ClassmajorID = finalExaminationView.ClassmajorID; finalExamination.DepartmentID = finalExaminationView.DepartmentID; finalExamination.ClassName = finalExaminationView.ClassName; finalExamination.CoursematerialID = finalExaminationView.CoursematerialID; finalExamination.CourseTypeID = finalExaminationView.CourseTypeID; finalExamination.ExamsCategoryID = finalExaminationView.ExamsCategoryID; finalExamination.ExaminationModeID = finalExaminationView.ExaminationModeID; finalExamination.Credit = finalExaminationView.Credit; //总学时 finalExamination.TotalHours = finalExaminationView.TotalHours; finalExamination.ExamsDatetime = finalExaminationView.ExamsDatetime; finalExamination.ResultTypeID = finalExaminationView.ResultTypeID; finalExamination.CreatorUserID = finalExaminationView.CreatorUserID; finalExamination.EntryDeadlineTime = finalExaminationView.EntryDeadlineTime; finalExamination.IsEntry = finalExaminationView.IsEntry; finalExamination.ExaminationType = finalExaminationView.ExaminationType; finalExamination.ApprovalStatus = this.GetStartStatus(); finalExamination.IsGenerate = false; SetNewStatus(finalExamination); UnitOfWork.Add(finalExamination); if (finalExaminationView.IsEntry == true) { //当考试设定改为可录入时，调用工作流 StartUp(new List { finalExamination.FinalExaminationID }, EMIS.Utility.FormValidate.CustomPrincipal.Current.UserID, null); } } else { finalExamination = GetFinalExamination(finalExaminationView.FinalExaminationID); if (finalExamination == null) { throw new Exception("未找到相对应的数据！"); } //审核中的数据（节点的Description为[AP]）和end的节点不能修改 var status = statusList.Where(x => (x.Description ?? "").Contains("[AP]") || (x.Description ?? "").Contains("[PASS]")).Select(x => x.ID).ToList(); if (status.Contains(finalExamination.ApprovalStatus)) { //|| finalExamination.ApprovalStatus == (int)EMIS.ViewModel.CF_ScoreState.Rebut 取消审核驳回，在期末设定及补考设定功能中应可进行信息修改 2016年11月4日14:56:58 throw new Exception("该数据已经成绩录入或者已审核，不能做任何修改！"); } finalExamination.SchoolyearID = finalExaminationView.SchoolyearID; finalExamination.GradeYearID = finalExaminationView.GradeYearID; finalExamination.CollegeID = finalExaminationView.CollegeID; //finalExamination.ClassmajorID = finalExaminationView.ClassmajorID; finalExamination.DepartmentID = finalExaminationView.DepartmentID; finalExamination.ClassName = finalExaminationView.ClassName; finalExamination.CoursematerialID = finalExaminationView.CoursematerialID; finalExamination.CourseTypeID = finalExaminationView.CourseTypeID; finalExamination.ExamsCategoryID = finalExaminationView.ExamsCategoryID; finalExamination.ExaminationModeID = finalExaminationView.ExaminationModeID; finalExamination.Credit = finalExaminationView.Credit; //总学时 finalExamination.TotalHours = finalExaminationView.TotalHours; finalExamination.ExamsDatetime = finalExaminationView.ExamsDatetime; finalExamination.ResultTypeID = finalExaminationView.ResultTypeID; finalExamination.CreatorUserID = finalExaminationView.CreatorUserID; finalExamination.EntryDeadlineTime = finalExaminationView.EntryDeadlineTime; finalExamination.ExaminationType = finalExaminationView.ExaminationType; if (finalExamination.IsEntry != finalExaminationView.IsEntry && finalExaminationView.IsEntry == true) { //当考试设定改为可录入时，调用工作流 StartUp(new List { finalExamination.FinalExaminationID }, EMIS.Utility.FormValidate.CustomPrincipal.Current.UserID, ""); finalExamination.IsEntry = finalExaminationView.IsEntry; } //if (finalExamination.ApprovalStatus == (int)EMIS.ViewModel.CF_ScoreState.Rebut) //{ // finalExamination.ApprovalStatus = (int)EMIS.ViewModel.CF_ScoreState.Rebut; //} //else //{ // finalExamination.ApprovalStatus = finalExaminationView.IsEntry == true ? (int)EMIS.ViewModel.CF_ScoreState.CanInput : (int)EMIS.ViewModel.CF_ScoreState.NoCanInput; //} SetModifyStatus(finalExamination); } List finalExaminationStudentList = new List(); //如果是补考或者毕业补考，需要读出添加学生的期末考试状况，注意还有补考设定编辑的那一边 if (finalExamination.ExamsCategoryID == (int)CF_ExamsCategory.Resit || finalExamination.ExamsCategoryID == (int)CF_ExamsCategory.GraduationExam) { finalExaminationStudentList = finalExaminationDAL .GetFinalExaminationByResitStudent(x => x.CoursematerialID == finalExaminationView.CoursematerialID, userIDs.Select(x => (Guid?)x).ToList()).ToList(); } List newFinalExaminationStudentList = new List(); foreach (var student in listStudent) { int? schoolyearNumID, startTermID; schoolyearNumID = (finalExamination.CF_Schoolyear.Value - ((student.CF_Classmajor.CF_Grademajor.GradeID * 2) - 1 + (student.CF_Classmajor.CF_Grademajor.SemesterID - 1)) - (finalExamination.CF_Schoolyear.SchoolcodeID == student.CF_Classmajor.CF_Grademajor.SemesterID ? 0 : 1)) / 2 + 1; startTermID = finalExamination.CF_Schoolyear.Value - ((student.CF_Classmajor.CF_Grademajor.GradeID * 2) - 1 + (student.CF_Classmajor.CF_Grademajor.SemesterID - 1)) + 1; var lastFinalExamination = finalExaminationStudentList.FirstOrDefault(x => x.UserID == student.UserID); if (lastFinalExamination != null) { schoolyearNumID = lastFinalExamination.SchoolyearNumID; startTermID = lastFinalExamination.StarttermID; } newFinalExaminationStudentList.Add(new ER_FinalExaminationStudent { FinalExaminationStudentID = Guid.NewGuid(), FinalExaminationID = finalExamination.FinalExaminationID, SchoolyearNumID = schoolyearNumID, StarttermID = startTermID, UserID = student.UserID, RecordStatus = (int)SYS_STATUS.USABLE, CreateUserID = CustomPrincipal.Current.UserID, CreateTime = DateTime.Now, ModifyUserID = CustomPrincipal.Current.UserID, ModifyTime = DateTime.Now }); } if (finalExaminationView.isAutoAdd == true && ClassmajorIDList.Count>0) { UnitOfWork.Remove(x => x.FinalExaminationID == finalExamination.FinalExaminationID); UnitOfWork.Remove(x => !userIDs.Contains((Guid)x.UserID) && x.FinalExaminationID == finalExamination.FinalExaminationID); } UnitOfWork.Commit(); UnitOfWork.BulkInsert(newFinalExaminationStudentList); } catch (Exception) { throw; } } /// /// 删除 /// /// public void FinalExaminationDelete(List finalExaminationIDs) { try { if (finalExaminationIDs.Count > 0) { var startStatus=this.GetStartStatus(); var finalExamination = finalExaminationDAL.finalExaminationRepository.GetList(x => finalExaminationIDs.Contains(x.FinalExaminationID) && x.ApprovalStatus != startStatus).FirstOrDefault(); if (finalExamination != null) throw new Exception("不是未开放状态，不能删除该考试设定！"); UnitOfWork.Remove(x => finalExaminationIDs.Contains(x.FinalExaminationID)); UnitOfWork.Remove(x => finalExaminationIDs.Contains(x.FinalExaminationID)); this.UnitOfWork.Commit(); } } catch (Exception) { throw; } } /// /// 删除学生 /// /// public void FinalExaminationStudentDelete(Guid finalExaminationID,List UserID) { try { if (UserID.Count > 0) { var StatusViewList=this.GetStatusViewList(); var status = StatusViewList.Where(x => (x.Description ?? "").Contains("[AP]") || (x.Description ?? "").Contains("[PASS]")).Select(x => x.ID).ToList(); var finalExamination = finalExaminationDAL.finalExaminationRepository.GetList(x => x.FinalExaminationID == finalExaminationID&& status.Contains(x.ApprovalStatus)).FirstOrDefault(); if (finalExamination != null) throw new Exception("不是未开放状态或重录待审状态，不能删除该考试设定的学生！"); var query = scoreDAL.finalExaminationRepository.GetList(x => x.FinalExaminationID == finalExaminationID, (x => x.CF_Schoolyear), x => x.ER_FinalExaminationStudent).ToList(); var scoreList = scoreRepository.GetList(x => x.FinalExaminationID == finalExaminationID && UserID.Contains(x.UserID)).ToList(); foreach (var score in scoreList) { if (score.RecordStatus == (int)SYS_STATUS.UNUSABLE) { throw new Exception("选中的学生不是能够重录的学生，不能删除该考试设定的学生！"); } } var scoreIDList = scoreList.Select(x => x.ScoreID).ToList(); UnitOfWork.Remove(x => scoreIDList.Contains(x.ScoreID.Value)); UnitOfWork.Remove(x => x.FinalExaminationID == finalExaminationID && UserID.Contains((Guid)x.UserID)); UnitOfWork.Remove(x => x.FinalExaminationID == finalExaminationID && UserID.Contains(x.UserID)); this.UnitOfWork.Commit(); } } catch (Exception) { throw; } } /// /// 根据教学任务生成期末设定,加上总学时 /// public void GenerateFinalExamination(Guid? schoolyearID, Guid? collegeID, int? gradeID, int? standardID, bool isGenerateNotSubmit) { try { List listClassmajor = new List(); List list = new List(); Expression> educationMissionClassExp = (x => true); Expression> exp = x => true; if (!isGenerateNotSubmit) { educationMissionClassExp = (x => x.RecordStatus != (int)EMIS.ViewModel.EM_EducationMissionClassStatus.NotSubmitted); } var schoolYear = this.SchoolYearServices.Value.GetSchoolYear(schoolyearID); var queryEducationMission = this.DataRangeFunction(finalExaminationDAL.GetEducationMission(schoolyearID, exp, educationMissionClassExp)); //获取教学任务 if (collegeID.HasValue) { queryEducationMission = queryEducationMission.Where(x => x.CollegeID == collegeID); } if (gradeID.HasValue && gradeID != -1) { queryEducationMission = queryEducationMission.Where(x => x.GradeYearID == gradeID); } if (standardID.HasValue) { queryEducationMission = queryEducationMission.Where(x => x.StandardID == standardID); } var educationMissionIDs = queryEducationMission.Select(x => x.EducationMissionID).ToList(); //教学任务ID var queryEducationMissionClassList = finalExaminationDAL.educationMissionClassRepository .GetList(x => educationMissionIDs.Contains(x.EducationMissionID), (x => x.EM_MissionClassTeacher), (x => x.EM_EducationSchedulingClass.Select(w => w.ES_AdultEducationSchedule.Select(y => y.ES_AdultEducationScheduleTeacher))), (x => x.EM_CourseProcess.Select(w => w.EM_CourseProcessTeacher))).ToList(); var educationMissionClassIDs = queryEducationMissionClassList.ToList().Select(x => x.EducationMissionClassID).ToList(); var queryEducationSchedulingClass = finalExaminationDAL.educationSchedulingClassRepository .GetList(x => educationMissionClassIDs.Contains((Guid)x.EducationMissionClassID), (x => x.EM_EducationMissionClass), (x => x.CF_Student), (x => x.CF_Student.Select(w => w.CF_Classmajor.CF_Grademajor)), (x => x.CF_Student.Select(w => w.ER_RetakePlanStudent))).ToList(); var EducationMissionList = queryEducationMission.ToList(); //查出由重修计划生成的教学任务的ID，通过重修名单表ER_RetakePlanStudent的EducationMissionID确定 var retakePlanEducationMissionIDs = retakePlanStudentRepository.GetList(x => educationMissionIDs.Contains(x.EducationMissionID)).Select(x => x.EducationMissionID).ToList(); //重修考试性质 int? retakeExamsCategoryID = ParameterServices.Value.GetParameterValue(CF_ParameterType.RetakeExamsCatagoryID); var startStatusID = this.GetStartStatus(); foreach (var educationMission in EducationMissionList) { var maxCourseTeacher = ( from missionClass in queryEducationMissionClassList from courseProcess in missionClass.EM_CourseProcess from courseTeacher in courseProcess.EM_CourseProcessTeacher where courseTeacher.TeachType == (int)EMIS.ViewModel.EM_TeachingMethod.Lecturer && missionClass.EducationMissionID == educationMission.EducationMissionID group courseProcess by courseTeacher.UserID into g select new { UserID = g.Key, CourseTimes = g.Sum(x => x.Times) } ).OrderByDescending(x => x.CourseTimes).FirstOrDefault(); if (maxCourseTeacher == null) { maxCourseTeacher = ( from missionClass in queryEducationMissionClassList from teacher in missionClass.EM_MissionClassTeacher from schedule in missionClass.EM_EducationSchedulingClass .SelectMany(x => x.ES_AdultEducationSchedule) .SelectMany(x => x.ES_AdultEducationScheduleTeacher) .Where(x => x.UserID == teacher.UserID) .GroupBy(x => x.UserID) .Select(x => new { UserID = x.Key, CourseTimes = (int?)x.Count() }).DefaultIfEmpty() where teacher.TeachType == (int)EMIS.ViewModel.EM_TeachingMethod.Lecturer && missionClass.EducationMissionID == educationMission.EducationMissionID select new { UserID = teacher.UserID, CourseTimes = (int?)(schedule == null ? 0 : schedule.CourseTimes) } ).OrderByDescending(x => x.CourseTimes).FirstOrDefault(); } var userID = maxCourseTeacher != null ? maxCourseTeacher.UserID : null; var mainEducationMissionClass = queryEducationMissionClassList.Where(x => x.EducationMissionID == educationMission.EducationMissionID).FirstOrDefault(); var mainEducationSchedulingClassList = queryEducationSchedulingClass.Where(x => x.EM_EducationMissionClass.EducationMissionID == educationMission.EducationMissionID).ToList(); var studentList = mainEducationSchedulingClassList.SelectMany(x => x.CF_Student).GroupBy(x => x.UserID) .Select(x => x.FirstOrDefault()).ToList(); ER_FinalExamination finalExamination = new ER_FinalExamination(); finalExamination.FinalExaminationID = Guid.NewGuid(); finalExamination.SchoolyearID = educationMission.SchoolyearID; //如果教学任务中的年级为空，默认取学年学期对应的学年，适用于选修课（任选课） finalExamination.GradeYearID = educationMission.GradeYearID == null ? schoolYear.Years : educationMission.GradeYearID; if (educationMission.HandleModeID == (int)CF_HandleMode.MinorCourse) { string gradeStr = educationMission.ClassName.Substring(0, 4); int grade = Convert.ToInt32(gradeStr); finalExamination.GradeYearID = grade; } else { //如果教学任务中的年级为空，默认取学年学期对应的学年，适用于选修课（任选课） finalExamination.GradeYearID = educationMission.GradeYearID == null ? schoolYear.Years : educationMission.GradeYearID; } finalExamination.DepartmentID = educationMission.DepartmentID; finalExamination.ClassName = educationMission.ClassName; finalExamination.CoursematerialID = educationMission.CoursematerialID; finalExamination.EducationMissionID = educationMission.EducationMissionID; finalExamination.CourseTypeID = educationMission.CourseTypeID; //由重修计划生成的教学任务,其考试性质为重修设置 -> 参数设定设置的重修考试性质 if (retakePlanEducationMissionIDs.Contains(educationMission.EducationMissionID)) finalExamination.ExamsCategoryID = retakeExamsCategoryID; else finalExamination.ExamsCategoryID = (int)EMIS.ViewModel.CF_ExamsCategory.FinalExam; finalExamination.ExaminationModeID = educationMission.ExaminationModeID; finalExamination.Credit = educationMission.Credit; //总学时 finalExamination.TotalHours = educationMission.TotalHours; finalExamination.CreatorUserID = userID; finalExamination.ExaminationType = (int)EMIS.ViewModel.CF_ExaminationType.FinalExamination; finalExamination.ApprovalStatus = startStatusID;//(int)EMIS.ViewModel.CF_ScoreState.NoCanInput; finalExamination.ResultTypeID = educationMission.ResultTypeID; finalExamination.CollegeID = educationMission.CollegeID; finalExamination.ClassmajorID = educationMission.ClassmajorID; finalExamination.IsGenerate = false; finalExamination.IsEntry = false; SetNewStatus(finalExamination); finalExamination.ER_FinalExaminationStudent = new HashSet(); foreach (var student in studentList) { //(schoolyear - startSchoolyear.Value - (specialtyCourse.SchoolcodeID == grademajor.SchoolcodeID ? 0 : 1)) / 2 + 1 = specialtyCourse.SchoolyearNumID var gradeSchoolyearValue = ((student.CF_Classmajor.CF_Grademajor.GradeID * 2) - 1 + (student.CF_Classmajor.CF_Grademajor.SemesterID - 1)); //需要检查生成的学生有否该教学任务的重修记录，如果有，需要将开课学年和开课学期替换成重修记录中的开课学年和开课学期 var retakePlanStudent = student.ER_RetakePlanStudent.FirstOrDefault(x => x.EducationMissionID == educationMission.EducationMissionID); var newFinalExaminationStudent = new ER_FinalExaminationStudent { FinalExaminationStudentID = Guid.NewGuid(), FinalExaminationID = finalExamination.FinalExaminationID, SchoolyearNumID = (retakePlanStudent != null) ? retakePlanStudent.SchoolyearNumID : (schoolYear.Value - gradeSchoolyearValue - (schoolYear.SchoolcodeID == student.CF_Classmajor.CF_Grademajor.SemesterID ? 0 : 1)) / 2 + 1, StarttermID = (retakePlanStudent != null) ? retakePlanStudent.StarttermID : (schoolYear.Value - gradeSchoolyearValue + 1), UserID = student.UserID }; this.SetNewStatus(newFinalExaminationStudent); finalExamination.ER_FinalExaminationStudent.Add(newFinalExaminationStudent); } list.Add(finalExamination); } UnitOfWork.BulkInsert(list); UnitOfWork.BulkInsert(list.SelectMany(x => x.ER_FinalExaminationStudent).ToList()); } catch (Exception ex) { throw; } } /// /// 获取期末设定学生 /// /// /// /// /// public IGridResultSet GetFinalExaminationStudent(Guid? finalExaminationID) { return finalExaminationDAL.GetFinalExaminationStudentList(finalExaminationID,null).OrderBy(x => x.LoginID).ToGridResultSet(); } /// /// 获取期末设定学生 /// /// /// /// /// public BaseStudentView GetFinalExaminationStudentForStudentAdd(Guid? finalExaminationID,Guid? userID) { return finalExaminationDAL.GetFinalExaminationStudentList(finalExaminationID, userID).FirstOrDefault(); } /// /// 添加期末设定学生 /// /// /// public void FinalExaminationStudentAdd(Guid? finalExaminationID, List listBaseStudentView) { try { var queryUserIDList = listBaseStudentView.Select(x => x.UserID).ToList(); ER_FinalExamination finalExamination = GetFinalExamination(finalExaminationID); if (finalExamination != null) { var statusList = this.GetStatusViewList(); //审核中的数据（节点的Description为[AP]）和end的节点不能修改 var status = statusList.Where(x => (x.Description ?? "").Contains("[AP]") && (x.Description ?? "").Contains("[PASS]")).Select(x => x.ID).ToList(); List finalExaminationStudentList = new List(); if (status.Contains(finalExamination.ApprovalStatus)) { throw new Exception("该数据已经提交或已审核，不能修改学生！"); } UnitOfWork.Remove(x => x.FinalExaminationID == finalExamination.FinalExaminationID); UnitOfWork.Remove(x => !queryUserIDList.Contains((Guid)x.UserID) && x.FinalExaminationID == finalExamination.FinalExaminationID); //如果是补考或者毕业补考，需要读出添加学生的期末考试状况，注意还有补考设定编辑的那一边 if (finalExamination.ExamsCategoryID == (int)CF_ExamsCategory.Resit || finalExamination.ExamsCategoryID == (int)CF_ExamsCategory.GraduationExam) { finalExaminationStudentList = finalExaminationDAL .GetFinalExaminationByResitStudent(x => x.FinalExaminationID == finalExaminationID, queryUserIDList.Select(x => (Guid?)x).ToList()).ToList(); } var listStudent = finalExaminationDAL.studentRepository.GetList(x => queryUserIDList.Contains(x.UserID), (x => x.CF_Classmajor.CF_Grademajor)).ToList(); foreach (var student in listStudent) { int? schoolyearNumID, startTermID; schoolyearNumID = (finalExamination.CF_Schoolyear.Value - ((student.CF_Classmajor.CF_Grademajor.GradeID * 2) - 1 + (student.CF_Classmajor.CF_Grademajor.SemesterID - 1)) - (finalExamination.CF_Schoolyear.SchoolcodeID == student.CF_Classmajor.CF_Grademajor.SemesterID ? 0 : 1)) / 2 + 1; startTermID = finalExamination.CF_Schoolyear.Value - ((student.CF_Classmajor.CF_Grademajor.GradeID * 2) - 1 + (student.CF_Classmajor.CF_Grademajor.SemesterID - 1)) + 1; var lastFinalExamination = finalExaminationStudentList.FirstOrDefault(x => x.UserID == student.UserID); if (lastFinalExamination != null) { schoolyearNumID = lastFinalExamination.SchoolyearNumID; startTermID = lastFinalExamination.StarttermID; } finalExamination.ER_FinalExaminationStudent.Add(new ER_FinalExaminationStudent { FinalExaminationStudentID = Guid.NewGuid(), FinalExaminationID = finalExamination.FinalExaminationID, SchoolyearNumID = schoolyearNumID, StarttermID = startTermID, UserID = student.UserID, RecordStatus = (int)SYS_STATUS.USABLE, CreateUserID = CustomPrincipal.Current.UserID, CreateTime = DateTime.Now, ModifyUserID = CustomPrincipal.Current.UserID, ModifyTime = DateTime.Now }); } UnitOfWork.Commit(); } } catch (Exception) { throw; } } /// /// 添加期末设定学生 /// /// /// public void StudentAdd(FinalExaminationView finalExaminationView) { try { List sutdentIDList = new List(); sutdentIDList.Add(finalExaminationView.UserID); var queryUserIDList = sutdentIDList; ER_FinalExamination finalExamination = GetFinalExamination(finalExaminationView.FinalExaminationID); if (finalExamination != null) { var addOrUpdate = finalExaminationDAL.FinalExaminationStudentRepository.Entities.Where(x => x.FinalExaminationID == finalExamination.FinalExaminationID && x.UserID == finalExaminationView.UserID).FirstOrDefault(); var statusList = this.GetStatusViewList(); //审核中的数据（节点的Description为[AP]）和end的节点不能修改 var status = statusList.Where(x => (x.Description ?? "").Contains("[AP]") || (x.Description ?? "").Contains("[PASS]")).Select(x => x.ID).ToList(); List finalExaminationStudentList = new List(); if (status.Contains(finalExamination.ApprovalStatus)) { throw new Exception("不是未开放状态或重录待审状态，不能更变该考试设定的学生！"); } //学生在数据库中的考试科目 var OtrerStudentList = finalExaminationDAL.FinalExaminationStudentRepository.GetList(x => queryUserIDList.Contains((Guid)x.UserID) && x.FinalExaminationID != finalExaminationView.FinalExaminationID).ToList(); //学生在数据库中的期末设定ID var OtrerFinalExaminationIDList = finalExaminationDAL.FinalExaminationStudentRepository.GetList(x => queryUserIDList.Contains((Guid)x.UserID) && x.FinalExaminationID != finalExaminationView.FinalExaminationID).Select(x => x.FinalExaminationID).ToList(); //学生在数据库中的期末设定 var OtrerFinalExaminationList = finalExaminationDAL.finalExaminationRepository.GetList(x => OtrerFinalExaminationIDList.Contains(x.FinalExaminationID)).ToList(); //foreach (var of in OtrerFinalExaminationList) //{ // if (of.CoursematerialID == finalExamination.CoursematerialID // && of.ExamsCategoryID == finalExamination.ExamsCategoryID) // { // int? schoolyearNumID, startTermID; // double StarttermID = Convert.ToDouble(finalExaminationView.StarttermID); // double two = 2.0; // double Startterm = Convert.ToDouble(StarttermID / two); // schoolyearNumID = Convert.ToInt32(Math.Ceiling(Startterm)); // startTermID = finalExaminationView.StarttermID; // foreach (var os in OtrerStudentList) // { // if (os.StarttermID == startTermID) // { // throw new Exception("该学生数据重复，重复的录入班名称为：" + of.ClassName + "请检查!"); // } // } // } //} //如果是补考或者毕业补考，需要读出添加学生的期末考试状况，注意还有补考设定编辑的那一边 if (finalExamination.ExamsCategoryID == (int)CF_ExamsCategory.Resit || finalExamination.ExamsCategoryID == (int)CF_ExamsCategory.GraduationExam) { finalExaminationStudentList = finalExaminationDAL .GetFinalExaminationByResitStudent(x => x.FinalExaminationID == finalExaminationView.FinalExaminationID, queryUserIDList.Select(x => (Guid?)x).ToList()).ToList(); } var listStudent = finalExaminationDAL.studentRepository.GetList(x => queryUserIDList.Contains(x.UserID), (x => x.CF_Classmajor.CF_Grademajor)).ToList(); if (addOrUpdate == null) { foreach (var student in listStudent) { int? schoolyearNumID, startTermID; double StarttermID = Convert.ToDouble(finalExaminationView.StarttermID); double two = 2.0; double Startterm = Convert.ToDouble(StarttermID / two); schoolyearNumID = Convert.ToInt32(Math.Ceiling(Startterm)); startTermID = finalExaminationView.StarttermID; var lastFinalExamination = finalExaminationStudentList.FirstOrDefault(x => x.UserID == student.UserID); if (lastFinalExamination != null) { schoolyearNumID = lastFinalExamination.SchoolyearNumID; startTermID = lastFinalExamination.StarttermID; } finalExamination.ER_FinalExaminationStudent.Add(new ER_FinalExaminationStudent { FinalExaminationStudentID = Guid.NewGuid(), FinalExaminationID = finalExamination.FinalExaminationID, SchoolyearNumID = schoolyearNumID, StarttermID = startTermID, UserID = student.UserID, RecordStatus = (int)SYS_STATUS.USABLE, CreateUserID = CustomPrincipal.Current.UserID, CreateTime = DateTime.Now, ModifyUserID = CustomPrincipal.Current.UserID, ModifyTime = DateTime.Now }); } } else { foreach (var student in listStudent) { int? schoolyearNumID, startTermID; double StarttermID = Convert.ToDouble(finalExaminationView.StarttermID); double two = 2.0; double Startterm = Convert.ToDouble(StarttermID / two); schoolyearNumID = Convert.ToInt32(Math.Ceiling(Startterm)); startTermID = finalExaminationView.StarttermID; var lastFinalExamination = finalExaminationStudentList.FirstOrDefault(x => x.UserID == student.UserID); if (lastFinalExamination != null) { schoolyearNumID = lastFinalExamination.SchoolyearNumID; startTermID = lastFinalExamination.StarttermID; } addOrUpdate.FinalExaminationID = finalExamination.FinalExaminationID; addOrUpdate.SchoolyearNumID = schoolyearNumID; addOrUpdate.StarttermID = startTermID; addOrUpdate.UserID = student.UserID; addOrUpdate.RecordStatus = (int)SYS_STATUS.USABLE; addOrUpdate.CreateUserID = CustomPrincipal.Current.UserID; addOrUpdate.CreateTime = DateTime.Now; addOrUpdate.ModifyUserID = CustomPrincipal.Current.UserID; addOrUpdate.ModifyTime = DateTime.Now; } } UnitOfWork.Commit(); } } catch (Exception) { throw; } } /// /// 期末生成,按兵良要求，加上院系所、年级、专业下拉条件 增加班级条件，加上总学时 /// public virtual void GenerateResitExamination(Guid? schoolyearID, Guid? collegeID, int? gradeID, int? standardID, Guid? classmajorID) { try { var startStatusID = this.GetStartStatus(); var statusList = this.GetStatusViewList(); var curUser = EMIS.Utility.FormValidate.CustomPrincipal.Current; var curSchoolyear = SchoolYearServices.Value.GetCurrentSchoolYear(); ER_ExamsStateSetting examsStateSetting = finalExaminationDAL.ExamsStateSettingRepository.GetSingle(x => x.ExamsStateID == (int)CF_ExamsState.Suspension); List listFinalExamination = new List(); //List SlistFinalExamination = new List(); //var studentList = this.DataRangeFunction(finalExaminationDAL.GetResitFinalExaminationStudent(schoolyearID, approvedStatus)).ToList(); var query = this.GerenateResitDataRangeFunction(finalExaminationDAL.GetNotPassStudent(schoolyearID)); //var q = finalExaminationDAL.GetSuspensionStudent(schoolyearID); //var Squery = this.GerenateResitDataRangeFunction(q); if (collegeID.HasValue) {//院系所 query = query.Where(x => x.CollegeID == collegeID); //Squery = Squery.Where(x => x.CollegeID == collegeID); } if (gradeID.HasValue && gradeID != -1) {//年级 query = query.Where(x => x.Year == gradeID); //Squery = Squery.Where(x => x.Year == gradeID); } if (standardID.HasValue) //专业 { query = query.Where(x => x.StandardID == standardID); //Squery = Squery.Where(x => x.StandardID == standardID); } if (classmajorID.HasValue) { query = query.Where(x => x.ClassmajorID == classmajorID); //Squery = Squery.Where(x => x.ClassmajorID == classmajorID); } var studentList = query.ToList(); //var SuspensionsutdentList = Squery.ToList(); var queryFinalExamination = studentList.GroupBy(x => new { x.Year, x.CollegeID, x.GrademajorID, x.GrademajorName, x.CoursematerialID, x.DepartmentID, x.CourseName, x.CourseTypeID, x.ExaminationModeID, x.StartTermID, x.Credit, //总学时 x.TotalHours, x.ResultTypeID, x.ExamsCategoryID, }); //var queryFinal = SuspensionsutdentList.GroupBy(x => new //{ // x.Year, // x.CollegeID, // x.GrademajorID, // x.GrademajorName, // x.CoursematerialID, // x.DepartmentID, // x.CourseName, // x.CourseTypeID, // x.ExaminationModeID, // x.StartTermID, // x.Credit, // x.ResultTypeID //}); foreach (var finalExaminationView in queryFinalExamination) { ER_FinalExamination finalExamination = new ER_FinalExamination(); if (finalExaminationView.Key.ExamsCategoryID == (int)CF_ExamsCategory.Resit) { string className = finalExaminationView.Key.CourseName + " - " + finalExaminationView.Key.GrademajorName + "-补考"; finalExamination.FinalExaminationID = Guid.NewGuid(); finalExamination.SchoolyearID = curSchoolyear.SchoolYearID; finalExamination.GradeYearID = finalExaminationView.Key.Year; finalExamination.DepartmentID = finalExaminationView.Key.DepartmentID; finalExamination.ClassName = className; finalExamination.CoursematerialID = finalExaminationView.Key.CoursematerialID; finalExamination.CourseTypeID = finalExaminationView.Key.CourseTypeID; finalExamination.ExamsCategoryID = finalExaminationView.Key.ExamsCategoryID; //(int)EMIS.ViewModel.CF_ExamsCategory.Resit; finalExamination.ExaminationModeID = finalExaminationView.Key.ExaminationModeID; finalExamination.Credit = finalExaminationView.Key.Credit; //总学时 finalExamination.TotalHours = finalExaminationView.Key.TotalHours; finalExamination.ExaminationType = (int)EMIS.ViewModel.CF_ExaminationType.ResitExamination; finalExamination.ApprovalStatus = startStatusID; //(int)EMIS.ViewModel.CF_ScoreState.NoCanInput; finalExamination.ResultTypeID = finalExaminationView.Key.ResultTypeID; finalExamination.CollegeID = finalExaminationView.Key.CollegeID; finalExamination.IsEntry = false; finalExamination.CreatorUserID = finalExaminationView.FirstOrDefault().CreatorUserID; SetNewStatus(finalExamination); } else { string className = finalExaminationView.Key.CourseName + " - " + finalExaminationView.Key.GrademajorName + " - " + IdNameExt.GetDictionaryItem(DictionaryItem.CF_ExamsCategory.ToString()).Where(x => x.Value == finalExaminationView.Key.ExamsCategoryID).Select(x => x.Name).FirstOrDefault(); finalExamination.FinalExaminationID = Guid.NewGuid(); finalExamination.SchoolyearID = curSchoolyear.SchoolYearID; finalExamination.GradeYearID = finalExaminationView.Key.Year; finalExamination.DepartmentID = finalExaminationView.Key.DepartmentID; finalExamination.ClassName = className; finalExamination.CoursematerialID = finalExaminationView.Key.CoursematerialID; finalExamination.CourseTypeID = finalExaminationView.Key.CourseTypeID; finalExamination.ExamsCategoryID = finalExaminationView.Key.ExamsCategoryID; //(int)EMIS.ViewModel.CF_ExamsCategory.Resit; finalExamination.ExaminationModeID = finalExaminationView.Key.ExaminationModeID; finalExamination.Credit = finalExaminationView.Key.Credit; //总学时 finalExamination.TotalHours = finalExaminationView.Key.TotalHours; finalExamination.ExaminationType = (int)EMIS.ViewModel.CF_ExaminationType.ResitExamination; finalExamination.ApprovalStatus = startStatusID; //(int)EMIS.ViewModel.CF_ScoreState.NoCanInput; finalExamination.ResultTypeID = finalExaminationView.Key.ResultTypeID; finalExamination.CollegeID = finalExaminationView.Key.CollegeID; finalExamination.IsEntry = false; finalExamination.CreatorUserID = finalExaminationView.FirstOrDefault().CreatorUserID; SetNewStatus(finalExamination); } var queryStudent = finalExaminationView.Select(x => new ER_FinalExaminationStudent { FinalExaminationStudentID = Guid.NewGuid(), FinalExaminationID = finalExamination.FinalExaminationID, UserID = x.UserID, SchoolyearNumID = x.SchoolyearNumID, StarttermID = x.StartTermID, RecordStatus = (int)SYS_STATUS.USABLE, CreateTime = DateTime.Now, CreateUserID = curUser.UserID, ModifyTime = DateTime.Now, ModifyUserID = curUser.UserID }); finalExamination.ER_FinalExaminationStudent = new HashSet(queryStudent.ToList()); listFinalExamination.Add(finalExamination); } //foreach (var finalExaminationView in queryFinal) //{ // string className = finalExaminationView.Key.CourseName + " - " + finalExaminationView.Key.GrademajorName + "-缓考补考"; // ER_FinalExamination finalExamination = new ER_FinalExamination(); // finalExamination.FinalExaminationID = Guid.NewGuid(); // finalExamination.SchoolyearID = curSchoolyear.SchoolYearID; // finalExamination.GradeYearID = finalExaminationView.Key.Year; // finalExamination.DepartmentID = finalExaminationView.Key.DepartmentID; // finalExamination.ClassName = className; // finalExamination.CoursematerialID = finalExaminationView.Key.CoursematerialID; // finalExamination.CourseTypeID = finalExaminationView.Key.CourseTypeID; // finalExamination.ExamsCategoryID = (int)CF_ExamsCategory.DelayExam; // finalExamination.ExaminationModeID = finalExaminationView.Key.ExaminationModeID; // finalExamination.Credit = finalExaminationView.Key.Credit; // finalExamination.ExaminationType = (int)EMIS.ViewModel.CF_ExaminationType.ResitExamination; // finalExamination.ApprovalStatus = this.GetStartStatus(); //(int)EMIS.ViewModel.CF_ScoreState.NoCanInput; // finalExamination.ResultTypeID = finalExaminationView.Key.ResultTypeID; // finalExamination.CollegeID = finalExaminationView.Key.CollegeID; // finalExamination.IsEntry = false; // SetNewStatus(finalExamination); // var queryStudent = finalExaminationView.Select(x => new ER_FinalExaminationStudent // { // FinalExaminationStudentID = Guid.NewGuid(), // FinalExaminationID = finalExamination.FinalExaminationID, // UserID = x.UserID, // SchoolyearNumID = x.SchoolyearNumID, // //StarttermID = x.StartTermID, // RecordStatus = (int)SYS_STATUS.USABLE, // CreateTime = DateTime.Now, // CreateUserID = curUser.UserID, // ModifyTime = DateTime.Now, // ModifyUserID = curUser.UserID // }); // finalExamination.ER_FinalExaminationStudent = new HashSet(queryStudent.ToList()); // SlistFinalExamination.Add(finalExamination); //} UnitOfWork.BulkInsert(listFinalExamination); UnitOfWork.BulkInsert(listFinalExamination.SelectMany(x => x.ER_FinalExaminationStudent).ToList()); //UnitOfWork.BulkInsert(SlistFinalExamination); //UnitOfWork.BulkInsert(SlistFinalExamination.SelectMany(x => x.ER_FinalExaminationStudent).ToList()); UnitOfWork.Commit(); } catch (Exception) { throw; } } /// /// 毕业生成 增加院系所、专业、班级条件，加上总学时 /// public void GenerateGraduationExam(int? year, Guid? collegeID, int? standardID, Guid? classmajorID, decimal? learnSystem) { try { var startStatusID = this.GetStartStatus(); var curUser = EMIS.Utility.FormValidate.CustomPrincipal.Current; var curSchoolyear = SchoolYearServices.Value.GetCurrentSchoolYear(); List listFinalExamination = new List(); var query = this.GerenateResitDataRangeFunction(finalExaminationDAL.GetGraduationExamStudent(year)); if (collegeID.HasValue) //院系所 query = query.Where(x => x.CollegeID == collegeID); if (year.HasValue && year != -1) //年级 query = query.Where(x => x.Year == year); if (standardID.HasValue) //专业 query = query.Where(x => x.StandardID == standardID); if (classmajorID.HasValue) query = query.Where(x => x.ClassmajorID == classmajorID); if (learnSystem.HasValue && learnSystem != -1) query = query.Where(x => x.LearnSystem == learnSystem); var studentList = query.ToList(); var queryFinalExamination = studentList.GroupBy(x => new { x.Year, x.CollegeID, x.GrademajorID, x.GrademajorName, x.CoursematerialID, x.DepartmentID, x.CourseName, x.CourseTypeID, x.ExaminationModeID, x.StartTermID, x.Credit, //总学时 x.TotalHours, x.ResultTypeID, }); foreach (var finalExaminationView in queryFinalExamination) { string className = finalExaminationView.Key.CourseName + " - " + finalExaminationView.Key.GrademajorName + "-毕业补考"; ER_FinalExamination finalExamination = new ER_FinalExamination(); finalExamination.FinalExaminationID = Guid.NewGuid(); finalExamination.SchoolyearID = curSchoolyear.SchoolYearID; finalExamination.GradeYearID = finalExaminationView.Key.Year; finalExamination.DepartmentID = finalExaminationView.Key.DepartmentID; finalExamination.ClassName = className; finalExamination.CoursematerialID = finalExaminationView.Key.CoursematerialID; finalExamination.CourseTypeID = finalExaminationView.Key.CourseTypeID; finalExamination.ExamsCategoryID = (int)EMIS.ViewModel.CF_ExamsCategory.GraduationExam; finalExamination.ExaminationModeID = finalExaminationView.Key.ExaminationModeID; finalExamination.Credit = finalExaminationView.Key.Credit; //总学时 finalExamination.TotalHours = finalExaminationView.Key.TotalHours; finalExamination.ExaminationType = (int)EMIS.ViewModel.CF_ExaminationType.ResitExamination; finalExamination.ApprovalStatus = startStatusID; //(int)EMIS.ViewModel.CF_ScoreState.NoCanInput; finalExamination.ResultTypeID = finalExaminationView.Key.ResultTypeID; finalExamination.CollegeID = finalExaminationView.Key.CollegeID; finalExamination.CreatorUserID = finalExaminationView.FirstOrDefault().CreatorUserID; finalExamination.IsEntry = false; SetNewStatus(finalExamination); var queryStudent = finalExaminationView.Select(x => new ER_FinalExaminationStudent { FinalExaminationStudentID = Guid.NewGuid(), FinalExaminationID = finalExamination.FinalExaminationID, UserID = x.UserID, SchoolyearNumID = x.SchoolyearNumID, StarttermID = x.StartTermID, RecordStatus = (int)SYS_STATUS.USABLE, CreateTime = DateTime.Now, CreateUserID = curUser.UserID, ModifyTime = DateTime.Now, ModifyUserID = curUser.UserID }); finalExamination.ER_FinalExaminationStudent = new HashSet(queryStudent.ToList()); listFinalExamination.Add(finalExamination); } UnitOfWork.BulkInsert(listFinalExamination); UnitOfWork.BulkInsert(listFinalExamination.SelectMany(x => x.ER_FinalExaminationStudent).ToList()); UnitOfWork.Commit(); } catch (Exception) { throw; } } /// /// 更新 是否可录入字段 /// /// public void GetFinal_ResitExaminationIsEntry(List finalExaminationIDs) { try { var statusList = this.GetStatusViewList(); var startStatus = this.GetStartStatus(); // //可录入节点的Description用[ENTRY]标识 var status = statusList.Where(x => (x.Description ?? "").Contains("[ENTRY]")).Select(x => x.ID).FirstOrDefault(); if (finalExaminationIDs.Count > 0) { var query = finalExaminationDAL.finalExaminationRepository.GetList(x => finalExaminationIDs.Contains(x.FinalExaminationID)).ToList(); if (query.Where(x => x.ApprovalStatus != startStatus).FirstOrDefault() != null) throw new Exception("只能操作未开放的数据！"); StartUp(finalExaminationIDs, EMIS.Utility.FormValidate.CustomPrincipal.Current.UserID, null); query.ForEach(x => x.IsEntry = true); //query.ForEach(x => x.ApprovalStatus = status); UnitOfWork.Commit(); } } catch (Exception) { throw; } } /// /// 撤销录入 /// /// public void GetFinal_ResitExaminationBack(List finalExaminationIDs) { try { var statusList = this.GetStatusViewList(); var startStatus = this.GetStartStatus(); // var actionList = WorkflowServices.Value.GetActionView("ER_FinalExamination", finalExaminationIDs[0], CustomPrincipal.Current.UserID).ToList(); var actionID = actionList.Where(x => (x.Description ?? "").Contains("[Cancel]")).Select(w => w.ActionID).FirstOrDefault(); //可录入节点的Description用[ENTRY]标识 if (actionID == null || actionID==Guid.Empty) { throw new Exception("没有对应的流程，请添加！"); } var status = statusList.Where(x => (x.Description ?? "").Contains("[ENTRY]")).FirstOrDefault(); if (finalExaminationIDs.Count > 0) { var query = finalExaminationDAL.finalExaminationRepository.GetList(x => finalExaminationIDs.Contains(x.FinalExaminationID)).ToList(); if (query.Where(x => x.ApprovalStatus != status.ID).FirstOrDefault() != null) throw new Exception("只能操作可录入状态的数据！"); Approve(finalExaminationIDs, EMIS.Utility.FormValidate.CustomPrincipal.Current.UserID, actionID, null); query.ForEach(x => x.IsEntry = true); UnitOfWork.Commit(); } ScoreServices.Value.ScoreDelete(finalExaminationIDs); } catch (Exception) { throw; } } public List GetFinalExaminationViewList_Excel(ConfiguretView configuretView, Guid? collegeID, Guid? departmentID, Guid? schoolyearID, Guid? coursematerialID, int? courseTypeID, int? examsCategoryID, int? examinationType, int? approvalStatus, int? gradeYearID, List FinalExaminationIDList) { var statusList = this.GetStatusViewList(); Expression> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE); if (FinalExaminationIDList != null) exp = exp.And(x => FinalExaminationIDList.Contains(x.FinalExaminationID)); if (collegeID.HasValue) exp = exp.And(this.CollegeExpression(collegeID)); if (departmentID.HasValue) exp = exp.And(x => x.DepartmentID == departmentID); if (schoolyearID.HasValue) exp = exp.And(x => x.SchoolyearID == schoolyearID); if (coursematerialID.HasValue) exp = exp.And(x => x.CoursematerialID == coursematerialID); if (courseTypeID.HasValue) exp = exp.And(x => x.CourseTypeID == courseTypeID); if (examsCategoryID.HasValue) exp = exp.And(x => x.ExamsCategoryID == examsCategoryID); if (examinationType.HasValue) exp = exp.And(x => x.ExaminationType == examinationType); if (approvalStatus.HasValue) exp = exp.And(x => x.ApprovalStatus == approvalStatus); if (gradeYearID.HasValue) exp = exp.And(x => x.GradeYearID == gradeYearID); var query = finalExaminationDAL.GetFinalExaminationViewQueryable(exp); if (!string.IsNullOrEmpty(configuretView.ConditionValue)) query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim()); var result = this.DataRangeFunction(query).OrderByDescending(x => x.SchoolyearCode).ThenByDescending(x => x.CourseName).ToList(); result.ForEach(x => x.ApprovalStatusName = statusList.FirstOrDefault(w => w.ID == x.ApprovalStatus).Name); return result; } public FinalExaminationView GetStarttermID(Guid? finalExaminationID, Guid? UserID) { FinalExaminationView f = new FinalExaminationView(); var finalExamination = GetFinalExamination(finalExaminationID); var student = finalExaminationDAL.studentRepository.GetSingle(x => x.UserID == UserID, (x => x.CF_Classmajor.CF_Grademajor),(x=>x.Sys_User)); var startTermID = finalExamination.CF_Schoolyear.Value - ((student.CF_Classmajor.CF_Grademajor.GradeID * 2) - 1 + (student.CF_Classmajor.CF_Grademajor.SemesterID - 1)) + 1; f.StarttermID = startTermID; f.UserName = student.Sys_User.Name; return f; } //public string CanBatchEdit(List finalExaminationIDs) //{ // var finalExaminationList = finalExaminationDAL.finalExaminationRepository.GetList(x => finalExaminationIDs.Contains(x.FinalExaminationID)).ToList(); // var statusList = this.GetStatusViewList(); //获取工作流列表 // var status = statusList.Where(x => (x.Description ?? "").Contains("[AP]") || (x.Description ?? "").Contains("[PASS]")).Select(x => x.ID).ToList(); // foreach(var f in finalExaminationList){ // if (status.Contains(f.ApprovalStatus)) // { // return "不能修改"; // } // } // return "可以修改"; //} } }