private static void Reg_Table_Add_Helper(string CreateUID, string EditUID, Eva_Regular Eva_Regular, int[] tables, int[] eva_roles, string[] course_types) { try { //匹配并进行关联 for (int i = 0; i < tables.Count(); i++) { //定期评价添加 Eva_Distribution distribution = new Eva_Distribution() { CousrseType_Id = course_types[i], Evaluate_Id = Eva_Regular.Id, Eva_Role = eva_roles[i], CreateTime = DateTime.Now, CreateUID = CreateUID, EditTime = DateTime.Now, EditUID = EditUID, IsDelete = (int)IsDelete.No_Delete, IsEnable = (int)IsEnable.Enable, Table_Id = tables[i] }; JsonModel model = Constant.Eva_DistributionService.Add(distribution); if (model.errNum == (int)errNum.Success) { if (!Constant.Eva_Distribution_List.Contains(distribution)) { Constant.Eva_Distribution_List.Add(distribution); distribution.Id = RequestHelper.int_transfer(Convert.ToString(model.retData)); //表格的计数 Eva_Table table = Constant.Eva_Table_List.FirstOrDefault(t => t.Id == tables[i]); //直接进行更改 if (table != null) { table.UseTimes += 1; JsonModel m = Constant.Eva_TableService.Update(table); } } } } } catch (Exception ex) { LogHelper.Error(ex); } }
public static object Teacher_Course_Dis(string TeacherUID, Eva_Distribution dis) { object teacher_course_dis = null; try { teacher_course_dis = (from teacher in Constant.Teacher_List where teacher.UniqueNo == TeacherUID join room in Constant.CourseRoom_List.ToList().Distinct(new CourseRoomComparer()) on teacher.UniqueNo equals room.TeacherUID join course in Constant.Course_List on room.Coures_Id equals course.UniqueNo join cou_rel in Constant.CourseRel_List on course.UniqueNo equals cou_rel.Course_Id join eva_dis in Constant.Eva_Distribution_List.Where(t => t.Evaluate_Id == dis.Evaluate_Id) on cou_rel.CourseType_Id equals eva_dis.CousrseType_Id select new { course.UniqueNo, course.Name, course.DepartMentID, eva_dis.Table_Id }).Distinct().ToList(); } catch (Exception ex) { LogHelper.Error(ex); } return(teacher_course_dis); }