public IHttpActionResult BasicMaintain(BasicMaintainModel model) { ResultPageData rs = new ResultPageData(); try { var List = dbContext.v_Jusoft_PcSysEnType.Where(p => true); if (model.IdParent != null) { List = List.Where(p => p.IdSysEnType == model.IdParent); } if (model.IdSysEnType != null) { List = List.Where(p => p.IdParent == model.IdSysEnType); } if (!string.IsNullOrEmpty(model.SeachKey)) { List = List.Where(p => p.Name.Contains(model.SeachKey)); } List <decimal?> Ids = dbContext.f_getEnTypeList(5).Select(p => p.Id).ToList(); List = List.Where(p => Ids.Contains(p.Id)); var Data = List.Select(p => new { p.Id, p.ParentName, p.SysEnTypeName, p.Name, p.Memo }).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize); return(JsonResultHelper.JsonResult(Data)); } catch (Exception ex) { return(JsonResultHelper.JsonResult(1000, ex.Message)); } }
public object BasicMaintain(BasicMaintainModel model) { ResultPageData rs = new ResultPageData(); try { var List = dbContext.v_Jusoft_PcSysEnType.Where(p => true); if (model.IdParent != null) { List = List.Where(p => p.IdSysEnType == model.IdParent); } if (model.IdSysEnType != null) { List = List.Where(p => p.IdParent == model.IdSysEnType); } if (!string.IsNullOrEmpty(model.SeachKey)) { List = List.Where(p => p.Name.Contains(model.SeachKey)); } List <decimal?> Ids = dbContext.f_getEnTypeList(5).Select(p => p.Id).ToList(); List = List.Where(p => Ids.Contains(p.Id)); var Data = List.Select(p => new { p.Id, p.ParentName, p.SysEnTypeName, p.Name, p.Memo }).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize); rs.Data = Data; rs.PageIndex = model.PageIndex; rs.HasNextPage = Data.HasNextPage; rs.PageCount = Data.PageCount; rs.TotalItemCount = Data.TotalItemCount; rs.Code = 0; rs.strResult = "ok"; return(Json(rs)); } catch (Exception ex) { rs.Code = 1001; rs.strResult = ex.Message; return(Json(rs)); } }