//public override void SetCurrentDal() //{ // this.currentDal =DBSession.userInfoDal; //} #endregion /// <summary> /// 多条件搜索 /// </summary> /// <param name="userSearchParms"></param> /// <returns></returns> public IQueryable <UserInfo> GetPageEntityBySearch(UserSearchParms userSearchParms) { short normal = (short)DelFlagEnum.Normal; var temp = DBSession.UserInfoDal.GetEntities(u => u.DelFlag == normal); if (!string.IsNullOrEmpty(userSearchParms.schName)) { temp = temp.Where <UserInfo>(u => u.UName.Contains(userSearchParms.schName)); } if (!string.IsNullOrEmpty(userSearchParms.schRemark)) { temp = temp.Where <UserInfo>(u => u.Remark.Contains(userSearchParms.schRemark)); } userSearchParms.total = temp.Count(); return(temp.OrderBy <UserInfo, int>(u => u.ID) .Skip(userSearchParms.pageSize * (userSearchParms.pageIndex - 1)) .Take(userSearchParms.pageSize)); }
//获取用户数据 public ActionResult GetUserInfo() { int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); int totalCount = 0; string schName = Request["schName"]; //获取要搜索的用户名 string schRemark = Request["schRemark"]; //获取要搜索的备注 UserSearchParms userSearchParms = new UserSearchParms() { pageIndex = pageIndex, pageSize = pageSize, total = totalCount, schName = schName, schRemark = schRemark }; var userInfoList = userInfoService.GetPageEntityBySearch(userSearchParms); //short delFlag = (short)DelFlagEnum.Normal; //var userInfoList = userInfoService.GetPageEntities(pageSize, pageIndex, out totalCount, u => u.DelFlag == delFlag, u => u.ID, true); var temp = from u in userInfoList select new { ID = u.ID, UName = u.UName, Pwd = u.Pwd, ShowName = u.ShowName, Remark = u.Remark, ModfiedOn = u.ModfiedOn }; return(Json(new { rows = temp, total = userSearchParms.total }, JsonRequestBehavior.AllowGet)); }