public IQueryable <UserInfo> LoadPageUserInfos(Models.Params.QueryParam param) { short delNormal = (short)Models.Enum.DelFlagEnum.Normal; //先查出所有未删除的数据 var temp = dbSession.UserInfoDal.LoadEntities(u => u.DelFlag == delNormal); if (!string.IsNullOrEmpty(param.SearchName)) { temp = temp.Where(u => u.UName.Contains(param.SearchName)); } param.Total = temp.Count(); return(temp.OrderByDescending(u => u.InTime) .Skip(param.PageSize * (param.PageIndex - 1)) .Take(param.PageSize).AsQueryable()); }
public IQueryable <PersonalUser> LoadPagePersonalUser(Models.Params.QueryParam param) { var allPerUser = dbSession.PersonalUserDal.LoadEntities(r => r.Id > 0); var allUserMsg = dbSession.UserMessageDal.LoadEntities(c => c.Id > 0); var data = from t in allPerUser join c in allUserMsg on t.Id equals c.UserId select new { t.Id, t.InTime, t.UName, t.Mobile, t.QQ, t.WeChat, t.State, t.Email, c.Pay }; if (!string.IsNullOrEmpty(param.SearchName)) { data = data.Where(d => d.UName.Contains(param.SearchName)); } if (!string.IsNullOrEmpty(param.Mobile)) { data = data.Where(d => d.UName.Contains(param.SearchName)); } param.Total = data.Count(); return(data.OrderByDescending(d => d.Id) .Skip(param.PageSize * (param.PageIndex - 1)) .Take(param.PageSize).AsQueryable() as IQueryable <PersonalUser>);//类型转换为 IQueryable<Recharge> }