/// <summary>
/// 获取店铺优惠活动
/// </summary>
/// <param name="index">当前页</param>
/// <param name="size">分页大小</param>
/// <param name="sellerId">卖家Id</param>
/// <param name="status">状态 true为可用正在进行中和即将开始 false为不可用或已结束</param>
/// <returns></returns>
public IPagedList <Promotion.Activity> PromotionActivityPagedList(int index, int size, int?sellerId = null, bool?status = null)
{
return(Try(nameof(PromotionActivityPagedList), () =>
{
var cmd = SqlBuilder.Select("*")
.From("Activity")
.Where(sellerId.HasValue, "SellerId=@sellerId", new { sellerId })
.Where(status.HasValue && status.Value, "(Status=1 and StoppedOn>now())")
.Where(status.HasValue && !status.Value, "(Status=0 or StoppedOn<now())")
.ToCommand(index, size);
return PromotionConn.PagedList <Promotion.Activity>(index, size, cmd);
}));
}
