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