public ActionResult GetUserInfo() { string name = Request["name"]; string remark = Request["remark"]; int pageIndex = int.Parse(Request["page"]); //当前页码 int pageSize = int.Parse(Request["rows"]); //显示的条数 int totalCount = 0; short deleteType = (short)DeleteEnumType.Normal; UserInfoSearchParam userInfoSearchParam = new UserInfoSearchParam { UName = name, URemark = remark, DelFlag = deleteType, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount }; var userInfoList = userInfoService.LoadSearchUserInfo(userInfoSearchParam); //var userInfoList=userInfoService.LoadPagedEntities<string>(pageIndex, pageSize, out totalCount, // c =>c.DelFlag== deleteType, c=>c.Sort,true); var temp = from u in userInfoList select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, Remark = u.Remark, SubTime = u.SubTime, DelFlag = u.DelFlag, Sort = u.Sort }; return(Json(new { rows = temp, total = userInfoSearchParam.TotalCount }, JsonRequestBehavior.AllowGet)); }
public IQueryable <UserInfo> LoadSearchUserInfo(UserInfoSearchParam userInfoSearchParam) { var temp = this.DbSession.UserInfoDal.LoadEntities(c => true); if (!string.IsNullOrEmpty(userInfoSearchParam.UName)) { temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSearchParam.UName)); } if (!string.IsNullOrEmpty(userInfoSearchParam.URemark)) { temp = temp.Where <UserInfo>(u => u.Remark.Contains(userInfoSearchParam.URemark)); } userInfoSearchParam.TotalCount = temp.Count(); return(temp.Where(u => u.DelFlag == userInfoSearchParam.DelFlag).OrderBy <UserInfo, string>(u => u.Sort).Skip <UserInfo>((userInfoSearchParam.PageIndex - 1) * userInfoSearchParam .PageSize).Take <UserInfo>(userInfoSearchParam.PageSize)); }