/// <summary>
/// 根据客户系统编号获取客户所有优惠券信息
/// </summary>
/// <param name="customerSysNo">客户系统编号</param>
/// <param name="status">优惠券状态(0:所有)</param>
/// <param name="platformType">使用平台</param>
/// <returns>优惠券信息集合</returns>
/// <remarks>2013-08-30 吴文强 创建</remarks>
public override IList <SpCoupon> GetCustomerCoupons(int customerSysNo, PromotionStatus.优惠券状态 status, PromotionStatus.促销使用平台[] platformType)
{
if (platformType == null)
{
platformType = new PromotionStatus.促销使用平台[] { };
}
const string strSql = @"
select * from SpCoupon
where CustomerSysNo = @CustomerSysNo
and (WebPlatform = (@WebPlatform)
or ShopPlatform = (@ShopPlatform)
or MallAppPlatform = (@MallAppPlatform)
or LogisticsAppPlatform = (@LogisticsAppPlatform)
)
and (0 = @Status or Status = @Status)";
var entity = Context.Sql(strSql)
.Parameter("CustomerSysNo", customerSysNo)
.Parameter("WebPlatform", platformType.Any(p => p == PromotionStatus.促销使用平台.PC商城) ? (int)PromotionStatus.商城使用.是 : -1)
.Parameter("ShopPlatform", platformType.Any(p => p == PromotionStatus.促销使用平台.门店) ? (int)PromotionStatus.门店使用.是 : -1)
.Parameter("MallAppPlatform", platformType.Any(p => p == PromotionStatus.促销使用平台.手机商城) ? (int)PromotionStatus.手机商城使用.是 : -1)
.Parameter("LogisticsAppPlatform", platformType.Any(p => p == PromotionStatus.促销使用平台.物流App) ? (int)PromotionStatus.物流App使用.是 : -1)
.Parameter("Status", status)
//.Parameter("Status", status)
.QueryMany <SpCoupon>();
return(entity);
}
/// <summary>
/// 获取用户优惠券
/// </summary>
/// <param name="status">status: 20 已审核(当前可用)，30 已使用</param>
/// <returns>优惠券</returns>
/// <remarks> 2013-9-16 杨浩 创建</remarks>
public Result <IList <Coupon> > GetCoupons(PromotionStatus.优惠券状态 status)
{
int count = 0;
int type = 1;
if (status == PromotionStatus.优惠券状态.已使用)
{
type = 2;
}
var temp = Hyt.DataAccess.Promotion.ISpCouponDao.Instance.Seach(1, 20, CurrentUser.SysNo, status, null, null, type, out count);
//var temp = Hyt.BLL.Promotion.SpCouponBo.Instance.GetCustomerCoupons(CurrentUser.SysNo, status);
var data = temp.Select(t => new Coupon
{
SysNo = t.SysNo,
CouponAmount = t.CouponAmount,
CouponCode = t.CouponCode,
CustomerSysNo = t.CustomerSysNo,
Description = t.Description,
PromotionSysNo = t.PromotionSysNo,
RequirementAmount = t.RequirementAmount,
StartTime = t.StartTime,
EndTime = t.EndTime,
Color = "#3390d0"//bc33d0
}).ToList();
return(new Result <IList <Coupon> >
{
Data = data,
Status = true,
StatusCode = 1
});
}
/// <summary> /// 根据客户系统编号获取客户所有优惠券信息 /// </summary> /// <param name="customerSysNo">客户系统编号</param> /// <param name="status">优惠券状态(Null:所有)</param> /// <param name="platformType">使用平台</param> /// <returns>优惠券信息集合</returns> /// <remarks>2013-08-30 吴文强 创建</remarks> public abstract IList <SpCoupon> GetCustomerCoupons(int customerSysNo, PromotionStatus.优惠券状态 status, PromotionStatus.促销使用平台[] platformType);
/// <summary>
/// 根据客户系统编号获取客户所有优惠券信息(已经优惠卡号)
/// </summary>
/// <param name="customerSysNo">客户系统编号</param>
/// <param name="status">优惠券状态(Null:所有)</param>
/// <param name="platformType">使用平台</param>
/// <returns>优惠券信息集合</returns>
/// <remarks>2014-06-18 朱成果 创建</remarks>
public IList <CBSpCoupon> GetCustomerCouponsWithCard(int customerSysNo, PromotionStatus.优惠券状态 status, PromotionStatus.促销使用平台[] platformType)
{
return(Hyt.DataAccess.Promotion.ISpCouponDao.Instance.GetCustomerCouponsWithCard(customerSysNo, status, platformType));
}
/// <summary>
/// 根据客户系统编号获取客户所有优惠券信息
/// </summary>
/// <param name="customerSysNo">客户系统编号</param>
/// <param name="status">优惠券状态(Null:所有)</param>
/// <param name="platformType">优惠券使用平台类型</param>
/// <returns>优惠券信息集合</returns>
/// <remarks>2013-08-30 吴文强 创建</remarks>
public IList <SpCoupon> GetCustomerCoupons(int customerSysNo, PromotionStatus.优惠券状态 status,
PromotionStatus.促销使用平台[] platformType = null)
{
return(ISpCouponDao.Instance.GetCustomerCoupons(customerSysNo, status, platformType));
}
