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