public JsonModel DeleteCourseType_TableHelper(int Id) { int intSuccess = (int)errNum.Success; JsonModel jsmodel = new JsonModel(); try { Eva_CourseType_Table delete_Eva_CourseType_Table = Constant.Eva_CourseType_Table_List.FirstOrDefault(i => i.Id == Id); if (delete_Eva_CourseType_Table != null) { Eva_CourseType_Table delete_Eva_CourseType_Table_clone = Constant.Clone <Eva_CourseType_Table>(delete_Eva_CourseType_Table); delete_Eva_CourseType_Table_clone.IsDelete = (int)IsDelete.Delete; var jsmo = Constant.Eva_CourseType_TableService.Update(delete_Eva_CourseType_Table_clone); if (jsmo.errNum == 0) { Constant.Eva_CourseType_Table_List.Remove(delete_Eva_CourseType_Table); jsmodel = JsonModel.get_jsonmodel(intSuccess, "success", 0); TableUsingReduce(delete_Eva_CourseType_Table_clone.TableId); } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "该项分配不存在"); } } } catch (Exception ex) { jsonModel = JsonModel.get_jsonmodel(3, "failed", ex.Message); LogHelper.Error(ex); } return(jsmodel); }
public JsonModel AddCourseType_TableHelper(string CourseTypeId, string CreateUID, List <int> tableList, int SectionId) { int intSuccess = (int)errNum.Success; JsonModel jsmodel = new JsonModel(); try { jsmodel = JsonModel.get_jsonmodel(intSuccess, "success", 0); // where t.IsEnable == (int)IsEnable.Enable var tablss_add = (from vir_t in tableList join tab_c in Constant.Eva_CourseType_Table_List on new { TableId = vir_t, CourseTypeId = CourseTypeId, SectionID = SectionId, } equals new { TableId = (int)tab_c.TableId, CourseTypeId = tab_c.CourseTypeId, SectionID = (int)tab_c.StudySection_Id, } into tabc_cs from tac_ in tabc_cs.DefaultIfEmpty() where tac_ == null select new { tac_, vir_t }).ToList(); var tablss_delete = (from tab_c in Constant.Eva_CourseType_Table_List where tab_c.CourseTypeId == CourseTypeId && tab_c.StudySection_Id == SectionId join t in Constant.Eva_Table_List on tab_c.TableId equals t.Id join vir_t in tableList on t.Id equals vir_t into vir_ts from vir_t_ in vir_ts.DefaultIfEmpty() where vir_t_ == 0 select new { tab_c, vir_t_ }).ToList(); foreach (var item in tablss_add) { Eva_CourseType_Table ect = new Eva_CourseType_Table() { CourseTypeId = CourseTypeId, CreateTime = DateTime.Now, CreateUID = CreateUID, IsDelete = (int)IsDelete.No_Delete, TableId = item.vir_t, StudySection_Id = SectionId, }; var jsmo = Constant.Eva_CourseType_TableService.Add(ect); if (jsmo.errNum == 0) { Constant.Eva_CourseType_Table_List.Add(ect); ect.Id = Convert.ToInt32(jsmo.retData); TableUsingAdd(ect.TableId); } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "内部错误"); break; } } foreach (var item in tablss_delete) { Eva_CourseType_Table eva_CourseType_Table_clone = Constant.Clone <Eva_CourseType_Table>(item.tab_c); eva_CourseType_Table_clone.IsDelete = (int)IsDelete.Delete; var jsm = Constant.Eva_CourseType_TableService.Update(eva_CourseType_Table_clone); if (jsm.errNum == 0) { Constant.Eva_CourseType_Table_List.Remove(item.tab_c); } else { jsonModel = JsonModel.get_jsonmodel(3, "failed", "内部错误"); break; } } } catch (Exception ex) { jsonModel = JsonModel.get_jsonmodel(3, "failed", ex.Message); LogHelper.Error(ex); } return(jsmodel); }