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