/// <summary>
/// 查询已核销的礼券
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IEnumerable<CardCancelSummaryModel> GetCoupon(CardCancelSummaryQueryModel query)
{
const string sqlSelect =
@"select a.innerid as Cardid, a.title, a.titlesub, a.logourl, a.amount, a.buyprice, a.costprice, a.maxcount, a.count, a.cardtype, a.codetype, a.createdtime,
(select count(1)
from coupon_code where isused = 1 and usedtime > @starttime and usedtime < @endtime
and cardid=a.innerid
and `code` not in (select `code` from coupon_settcoderecord where cardid = a.innerid)) as CanedCount
from coupon_card as a where a.shopid=@shopid;";
//更新礼券code
return Helper.Query<CardCancelSummaryModel>(sqlSelect,
new
{
starttime = query.StartTime?.ToString("yyyy-MM-dd 00:00:00"),
endtime = query.EndTime?.ToString("yyyy-MM-dd 23:59:59"),
shopid = query.Shopid
});
}
