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);
}
