/// <summary> /// 获取奖品列表 /// </summary> /// <param name="scenicId">景区id</param> /// <returns></returns> public TPageResult <PrizeUserViewDto> GetPrizeUserList(PrizeUserQureyDto model) { var result = new TPageResult <PrizeUserViewDto>(); var tbl_WeiXinPrizeUser = PredicateBuilder.True <Tbl_PrizeUser>(); var tbl_WeiXinPrize = PredicateBuilder.True <Tbl_Prize>(); var tbl_WeiXin_User = PredicateBuilder.True <Tbl_WeiXinUser>(); //tbl_WeiXinPrizeUser = tbl_WeiXinPrizeUser.And(p => p.ScenicId == model.ScenicId); if (!string.IsNullOrEmpty(model.Number)) { tbl_WeiXinPrizeUser = tbl_WeiXinPrizeUser.And(o => o.Number == model.Number); } if (model.WinningTime.HasValue) { tbl_WeiXinPrizeUser = tbl_WeiXinPrizeUser.And(o => o.WinningDate == model.WinningTime.Value); } if (!string.IsNullOrEmpty(model.WinningType)) { tbl_WeiXinPrize = tbl_WeiXinPrize.And(o => o.Name == model.WinningType); } if (model.UserId.HasValue) { tbl_WeiXin_User = tbl_WeiXin_User.And(o => o.Id == model.UserId); } if (!string.IsNullOrEmpty(model.UserNickName)) { tbl_WeiXin_User = tbl_WeiXin_User.And(o => o.NickName.Contains(model.UserNickName)); } var weiXinPrizeUser = _weiXinPrizeUserRepository._dbset.Where(tbl_WeiXinPrizeUser); var weiXinPrize = _weiXinPrizeRepository._dbset.Where(tbl_WeiXinPrize); var weiXin_User = _weiXinUserRepository._dbset.Where(tbl_WeiXin_User); var linq = (from a in weiXinPrizeUser join b in weiXinPrize on a.PrizeId equals b.Id join c in weiXin_User on a.OpenId equals c.OpenId select new PrizeUserViewDto { OpenId = a.OpenId, IsUse = a.IsUse, Number = a.Number, WinningDate = a.CreateTime, Name = b.Name, PrizeName = b.PrizeName, UserId = c.Id, UserNickName = c.NickName, MinUseAmount = b.MinUseAmount, StartDate = a.StartDate, EndDate = a.EndDate }).OrderByDescending(c => c.WinningDate); var pageList = PaginationHelper.FindPagedList(model.Page, model.Limit, linq); return(result.SuccessResult(pageList.Data, pageList.TotalCount)); }
/// <summary> /// 获取奖品列表 /// </summary> /// <param name="scenicId">景区id</param> /// <returns></returns> public TPageResult <PrizeUserViewDto> GetPrizeUserList(PrizeUserQureyDto model) { return(_weiXinPrizeUserService.GetPrizeUserList(model)); }
public ActionResult WinningCheckListData(PrizeUserQureyDto model) { var result = _weiXinPrizeFacadeService.GetPrizeUserList(model); return(Json(result, JsonRequestBehavior.AllowGet)); }