public async Task <PageList <Member> > GetUserFriends(ParaMember para) { var list = _db.Member .Where(x => !x.IsCloseData) .OrderByDescending(x => x.LastDate) .AsQueryable(); return(await PageList <Member> .CreateAsync(list, para.PageNumber, para.PageSize)); }
public async Task <PageList <Party> > GetMemberPartyList(ParaMember para) { var partylist = _db.Activity .Include(x => x.Party) .OrderByDescending(x => x.Party.PartyDate) .Where(x => x.UserId == para.UserId) .Select(x => x.Party); return(await PageList <Party> .CreateAsync(partylist, para.PageNumber, para.PageSize)); }
public async Task <PageList <Member> > GetMatchList(ParaMember param) { var memberCondition = _db.MemberCondition.FirstOrDefault(x => x.UserId == param.UserId); if (memberCondition == null) { memberCondition = param.Condition; } var matchList = _db.Member .Where(x => x.Sex != memberCondition.Sex) .OrderByDescending(p => p.ActiveDate).AsQueryable(); matchList = matchList.Where(x => (x.Marry >= memberCondition.MarryMin && x.Marry <= memberCondition.MarryMax) && (x.BirthYear >= memberCondition.YearMin && x.BirthYear <= memberCondition.YearMax) && (x.Education >= memberCondition.EducationMin && x.Education <= memberCondition.EducationMax) && (x.Heights >= memberCondition.HeightsMin && x.Heights <= memberCondition.HeightsMax) && (x.Weights >= memberCondition.WeightsMin && x.Weights <= memberCondition.WeightsMax) ); if (!string.IsNullOrEmpty(memberCondition.BloodInclude)) { matchList = matchList.Where(x => memberCondition.BloodInclude.Contains(x.Blood)); } if (!string.IsNullOrEmpty(memberCondition.StarInclude)) { matchList = matchList.Where(x => memberCondition.StarInclude.Contains(x.Star)); } if (!string.IsNullOrEmpty(memberCondition.CityInclude)) { matchList = matchList.Where(x => memberCondition.CityInclude.Contains(x.City)); } if (!string.IsNullOrEmpty(memberCondition.JobTypeInclude)) { matchList = matchList.Where(x => memberCondition.JobTypeInclude.Contains(x.JobType)); } if (!string.IsNullOrEmpty(memberCondition.ReligionInclude)) { matchList = matchList.Where(x => memberCondition.ReligionInclude.Contains(x.Religion)); } return(await PageList <Member> .CreateAsync(matchList, param.PageNumber, param.PageSize)); }