/// <summary> /// 根据搜索分页显示角色信息 /// </summary> /// <param name="roleSearchParms"></param> /// <returns></returns> public IQueryable <RoleInfo> GetPageEntityBySearch(RoleSearchParms roleSearchParms) { short Normal = (short)DelFlagEnum.Normal; //删除标记为正常 var temp = DBSession.RoleInfoDal.GetEntities(r => r.DelFlag == Normal); //查询所有的角色信息 if (!string.IsNullOrEmpty(roleSearchParms.RoleName)) { temp = temp.Where(r => r.RoleName.Contains(roleSearchParms.RoleName));//如果有角色名称 则筛选 } if (!string.IsNullOrEmpty(roleSearchParms.Remark)) { temp = temp.Where(r => r.Remark.Contains(roleSearchParms.Remark));//如果有备注 则筛选 } roleSearchParms.total = temp.Count();//筛选完之后的总条数 return(temp = temp.OrderBy <RoleInfo, int>(r => r.ID) .Skip(roleSearchParms.pageSize * (roleSearchParms.pageIndex - 1)) .Take(roleSearchParms.pageSize)); //分页后的数据 }
//获取角色信息 public ActionResult GetRoleInfo() { int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); int total = 0; string RoleName = Request["RoleName"]; string Remark = Request["Remark"]; RoleSearchParms roleSearchParms = new RoleSearchParms { pageIndex = pageIndex, pageSize = pageSize, total = total, RoleName = RoleName, Remark = Remark }; //获取搜索后的数据 var roleInfoList = RoleInfoService.GetPageEntityBySearch(roleSearchParms); var temp = from r in roleInfoList select new { ID = r.ID, RoleName = r.RoleName, SubTime = r.SubTime, ModfiedOn = r.ModfiedOn, Remark = r.Remark }; return(Json(new { rows = temp, total = roleSearchParms.total }, JsonRequestBehavior.AllowGet)); }