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));
}
