public ActionResult GetAllActionInfos() { //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)XDZ.RolePermission.Model.Enum.DelFlagEnum.Normal; //拿到过滤条件用户名和备注的值 string schName = Request["schName"]; string schRemark = Request["schRemark"]; var queryParam = new ActionQueryParam() { PageSize = pageSize, PageIndex = pageIndex, Total = total, SchName = schName, SchRemark = schRemark }; var pageData = ActionInfoBll.LoadPageData(queryParam); //获取部分列 var temp = pageData.Select(u => new { ID = u.Id, u.ModifyOn, u.ActionName, u.Remark, u.HttpMethod, u.SubTime, u.IsMenu, u.Url, u.Sort, u.MenuIcon }); var data = new { total = queryParam.Total, rows = temp.ToList() }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAllActionInfos() { // jQuery easyui: table format: {total:32, rows:[{}{}]} // those data are passing through the Request from client, when the table is initialized. int pageSize = int.Parse(Request["rows"] ?? "10"); int pageIndex = int.Parse(Request["page"] ?? "1"); int totalData = 0; string srchName = Request["srchName"]; string srchRemark = Request["srchRemark"]; #region Old Pagination //// Get the current page data //// 如果有导航属性时,使用微软的默认序列化方式的时候会出现问题: 循环引用的问题 //// 解决方案: 直接选要显示的属性(非导航属性) //var pageData = ActionInfoService.GetPageEntities( // pageSize, // pageIndex, // out totalData, // u => u.DelFlag == DelFlagEnum.Normal, // u => u.Id, // true).Select(u => new { u.Id, u.ActionName, u.Url, u.HttpMethod, u.IsMenu, u.MenuIcon, u.Sort, u.SubTime, u.ModifiedOn, u.Remark }); #endregion var actionQueryParam = new ActionQueryParam() { PageIndex = pageIndex, PageSize = pageSize, Total = 0, SrchName = srchName, SrchRemark = srchRemark }; var pageData = ActionInfoService.LoadPageData(actionQueryParam) .Select(u => new { u.Id, u.ActionName, u.Url, u.HttpMethod, u.IsMenu, u.MenuIcon, u.Sort, u.SubTime, u.ModifiedOn, u.Remark }); var data = new { total = actionQueryParam.Total, rows = pageData.ToList() }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public IQueryable <ActionInfo> LoadPageData(ActionQueryParam actionQueryParam) { short normalFlag = (short)gs.RolePermission.Model.Enum.DelFlagEnum.Normal; //拿到未删除的数据 var temp = DbSession.ActionInfoDal.GetEntities(u => u.DelFlag == normalFlag); //过滤 if (!string.IsNullOrEmpty(actionQueryParam.SchName)) { temp = temp.Where(u => u.ActionName.Contains(actionQueryParam.SchName)).AsQueryable(); } if (!string.IsNullOrEmpty(actionQueryParam.SchRemark)) { temp = temp.Where(u => u.Remark.Contains(actionQueryParam.SchRemark)).AsQueryable(); } actionQueryParam.Total = temp.Count(); //分页 return(temp.OrderBy(u => u.Id) .Skip(actionQueryParam.PageSize * (actionQueryParam.PageIndex - 1)) .Take(actionQueryParam.PageSize).AsQueryable()); }
//获取数据 public ActionResult GetAllActionInfos() { int pageSize = int.Parse(Request["rows"] ?? "10"); int pageIndex = int.Parse(Request["page"] ?? "1"); int total = 0; string schName = Request["schName"]; string schRemark = Request["schRemark"]; var queryParam = new ActionQueryParam() { PageIndex = pageIndex, PageSize = pageSize, Total = 0, SchName = schName, SchRemark = schRemark }; var pageData = ActionInfoService.LoagPageData(queryParam); var temp = pageData.Select( a => new { ID = a.ID, a.IsMenu, a.Url, a.Remark, a.Sort, a.SubTime, a.ModfiedOn, a.HttpMethd, a.MenuIcon, a.ActionName }); var data = new { total = queryParam.Total, rows = temp.ToList() }; return(Json(data, JsonRequestBehavior.AllowGet)); }