예제 #1
0
        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));
            }
        }
예제 #2
0
        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));
            }
        }