public ActionResult GetAllRoleInfos() { //jquery easyUI:table:{total:32,rows:[{},{}]}//需要json数据格式 //jquery easyUI:table:在初始化时自动发送以下两个参数值 int pageSize = int.Parse(Request["rows"] ?? "10"); int pageIndex = int.Parse(Request["page"] ?? "1"); int total = 0; //short delFlagNormal = (short)gs.RolePermission.Model.Enum.DelFlagEnum.Normal; //拿到过滤条件用户名和备注的值 string schName = Request["schName"]; string schRemark = Request["schRemark"]; var queryParam = new RoleQueryParam() { PageSize = pageSize, PageIndex = pageIndex, Total = total, SchName = schName, SchRemark = schRemark }; var pageData = RoleInfoBll.LoadPageData(queryParam); //获取部分列 var temp = pageData.Select(u => new { ID = u.Id, u.ModifyOn, u.RoleName, u.Remark, u.SubTime }); //拿到当前页的数据 //var pageData=UserInfoBll.GetPageEntities(pageSize, pageIndex,out total, u => u.DelFlag == delFlagNormal,u=>u.Id,true).Select(u=>new { ID=u.Id,u.ModifyOn,u.Pwd,u.Remark,u.ShowName,u.SubTime,u.UName}); var data = new { total = queryParam.Total, rows = temp.ToList() }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult List(RoleQueryParam queryParam) { Expression <Func <Tapp_Role, bool> > predicate = c => true; if (!string.IsNullOrEmpty(queryParam.RoleName)) { predicate = predicate.And(c => c.RoleName.Contains(queryParam.RoleName)); } HKSJRecruitmentContext ctx = HttpContext.GetDbContext <HKSJRecruitmentContext>(); IPageList <Tapp_Role> models = ctx.Tapp_Role .Where(predicate) .OrderUsingSortExpression(queryParam.Sort, queryParam.Order) .ToPagedList(queryParam.PageIndex, queryParam.PageSize); List <Tapp_Role> dtos = models.ToList(); return(Content(this.GetJSON(new { total = models.PageInfo.TotalCount, rows = dtos }), this.JsonContentType())); }
public IQueryable <RoleInfo> LoadPageData(RoleQueryParam roleQueryParam) { short normalFlag = (short)gs.RolePermission.Model.Enum.DelFlagEnum.Normal; //拿到未删除的数据 xx var temp = DbSession.RoleInfoDal.GetEntities(u => u.DelFlag == normalFlag); //过滤 if (!string.IsNullOrEmpty(roleQueryParam.SchName)) { temp = temp.Where(u => u.RoleName.Contains(roleQueryParam.SchName)).AsQueryable(); } if (!string.IsNullOrEmpty(roleQueryParam.SchRemark)) { temp = temp.Where(u => u.Remark.Contains(roleQueryParam.SchRemark)).AsQueryable(); } roleQueryParam.Total = temp.Count(); //分页 return(temp.OrderBy(u => u.Id) .Skip(roleQueryParam.PageSize * (roleQueryParam.PageIndex - 1)) .Take(roleQueryParam.PageSize).AsQueryable()); }