public ActionResult GetRoleInfoList(int page, int rows, string RoleName, string Remark) { //int totalCount = 0; short delFlag = (short)DeleteEnumType.Normal; RoleInfoSearch roleInfoSearch = new RoleInfoSearch() { PageIndex = page, PageSize = rows, RoleName = RoleName, Remark = Remark, //TotalCount = totalCount }; var RoleInfoList = RoleInfoService.LoadSerachEntities(roleInfoSearch, delFlag).Select( u => new { u.ID, u.RoleName, u.Remark, u.SubTime, u.ModifiedOn, u.Sort }); //var RoleInfoList = RoleInfoService.LoadPageEntities(page, rows, out totalCount, u => u.DelFlag == delFlag, u => u.ID).Select(u => new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, SubTime = u.SubTime, Remark = u.Remark }); string data = WebCommon.GetJsonList(roleInfoSearch.TotalCount, RoleInfoList); return(Content(data)); }
public IQueryable <RoleInfo> LoadSerachEntities(RoleInfoSearch roleInfoSearch, short delFlag) { var temp = CurrentDal.LoadEntities(u => u.DelFlag == delFlag); if (!string.IsNullOrEmpty(roleInfoSearch.RoleName)) { temp = temp.Where(u => u.RoleName.Contains(roleInfoSearch.RoleName)); } if (!string.IsNullOrEmpty(roleInfoSearch.Remark)) { temp = temp.Where(u => u.Remark.Contains(roleInfoSearch.Remark)); } roleInfoSearch.TotalCount = temp.Count(); return(temp.OrderBy(u => u.ID).Skip((roleInfoSearch.PageIndex - 1) * roleInfoSearch.PageSize).Take(roleInfoSearch.PageSize)); }