public ActionResult GetCouponValidate(Guid?guid, string startDateTime, string endDateTime) { if (!guid.HasValue) { return(Json(null)); } else { PromotionActivityManager manager = new PromotionActivityManager(); SE_GetPromotionActivityCouponInfoConfig model = manager.GetCouponValidate(guid.Value); if (model != null) { SE_CarTagCouponConfig config = new SE_CarTagCouponConfig() { CouponGuid = guid.ToString(), CreateDate = DateTime.Now, Description = model.Description, Discount = model.Discount, // EndDateTime =Convert.ToDateTime(endDateTime??DateTime.Now.ToString()), MinMoney = model.MinMoney, // StartDateTime= Convert.ToDateTime(startDateTime??DateTime.Now.AddMonths(1).ToString()), Status = true }; if (new CarTagManager().Add(config)) { return(Json(config)); } else { return(Json(null)); } } return(Json(null)); } }
private void InsertCouponInfo(AsyncDbHelper db, SE_GetPromotionActivityCouponInfoConfig item) { StringBuilder sql = new StringBuilder(); sql = new StringBuilder(@"INSERT INTO Configuration.dbo.SE_GetPromotionActivityCouponInfoConfig ( FK_GetPromotionActivityID , GetRuleID , GetRuleGUID , VerificationMode , ValidDays , ValidStartDateTime , ValidEndDateTime , UserType , Description , Discount , MinMoney , SingleQuantity , Quantity, [Status], GetUserType ) VALUES ( @FK_GetPromotionActivityID , -- FK_GetPromotionActivityID - uniqueidentifier @GetRuleID , -- GetRuleID - int @GetRuleGUID , -- GetRuleGUID - uniqueidentifier @VerificationMode , -- VerificationMode - int @ValidDays , -- ValidDays - int @ValidStartDateTime , -- ValidStartDateTime - datetime @ValidEndDateTime , -- ValidEndDateTime - datetime @UserType , -- UserType - int @Description , -- Description - nvarchar(50) @Discount , -- Discount - money @MinMoney , -- MinMoney - money @SingleQuantity , -- SingleQuantity - int @Quantity, -- Quantity - int @Status, @GetUserType )"); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = sql.ToString(); cmd.Parameters.AddWithValue("@FK_GetPromotionActivityID", item.FK_GetPromotionActivityID); cmd.Parameters.AddWithValue("@GetRuleID", item.GetRuleID); cmd.Parameters.AddWithValue("@GetRuleGUID", item.GetRuleGUID); cmd.Parameters.AddWithValue("@VerificationMode", item.VerificationMode); cmd.Parameters.AddWithValue("@ValidDays", item.ValidDays); cmd.Parameters.AddWithValue("@ValidStartDateTime", item.ValidStartDateTime); cmd.Parameters.AddWithValue("@ValidEndDateTime", item.ValidEndDateTime); cmd.Parameters.AddWithValue("@UserType", item.UserType); cmd.Parameters.AddWithValue("@Description", item.Description); cmd.Parameters.AddWithValue("@Discount", item.Discount); cmd.Parameters.AddWithValue("@MinMoney", item.MinMoney); cmd.Parameters.AddWithValue("@SingleQuantity", item.SingleQuantity); cmd.Parameters.AddWithValue("@Quantity", item.Quantity); cmd.Parameters.AddWithValue("@Status", item.Status); cmd.Parameters.AddWithValue("@GetUserType", item.GetUserType); db.ExecuteNonQuery(cmd); } }
public ActionResult GetCouponValidate(Guid?guid) { if (!guid.HasValue) { return(Json(null)); } else { PromotionActivityManager manager = new PromotionActivityManager(); SE_GetPromotionActivityCouponInfoConfig model = manager.GetCouponValidate(guid.Value); if (model.SingleQuantity != 1) { return(Json(null)); } return(Json(JsonConvert.SerializeObject(model))); } }
/// <summary> /// 验证蓄电池/加油卡浮动配置实体 /// </summary> /// <param name="model"></param> /// <returns></returns> public BaoYangResultEntity <bool> Validation(CouponActivityConfigV2Model model) { var result = new BaoYangResultEntity <bool>() { Status = true }; if (model.ChannelConfigs != null && model.ChannelConfigs.Any()) { foreach (var item in model.ChannelConfigs) { if (item.Type == ChannelConfigType.URL.ToString() && string.IsNullOrWhiteSpace(item.Url)) { result.Status = false; result.Msg = $"类型{item.Channel}必须输入跳转地址"; break; } if (item.Type == ChannelConfigType.Coupon.ToString()) { if (item.GetRuleGUID == Guid.Empty) { result.Status = false; result.Msg = $"优惠券码为空或不符合优惠券码规则"; break; } //验证优惠券 PromotionActivityManager manager = new PromotionActivityManager(); SE_GetPromotionActivityCouponInfoConfig Couponresult = manager.GetCouponValidate(item.GetRuleGUID); if (Couponresult == null) { result.Status = false; result.Msg = $"优惠券码{item.GetRuleGUID.ToString()} 验证失败"; break; } } } } return(result); }
private void UpdateCouponInfo(AsyncDbHelper db, SE_GetPromotionActivityCouponInfoConfig item) { StringBuilder sql = new StringBuilder(); sql.Append(@"UPDATE Configuration.dbo.SE_GetPromotionActivityCouponInfoConfig GetRuleID =@GetRuleID, GetRuleGUID=@GetRuleGUID , VerificationMode=@VerificationMode , ValidDays =@ValidDays, ValidStartDateTime =@ValidStartDateTime, ValidEndDateTime =@ValidEndDateTime, UserType =@UserType, [Description]=@Description, Discount=@Discount , MinMoney =@MinMoney, SingleQuantity =@SingleQuantity, Quantity=@Quantity WHERE FK_GetPromotionActivityID=@FK_GetPromotionActivityID "); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = sql.ToString(); cmd.Parameters.AddWithValue("@FK_GetPromotionActivityID", item.FK_GetPromotionActivityID); cmd.Parameters.AddWithValue("@GetRuleID", item.GetRuleID); cmd.Parameters.AddWithValue("@GetRuleGUID", item.GetRuleGUID); cmd.Parameters.AddWithValue("@VerificationMode", item.VerificationMode); cmd.Parameters.AddWithValue("@ValidDays", item.ValidDays); cmd.Parameters.AddWithValue("@ValidStartDateTime", item.ValidStartDateTime); cmd.Parameters.AddWithValue("@ValidEndDateTime", item.ValidEndDateTime); cmd.Parameters.AddWithValue("@UserType", item.UserType); cmd.Parameters.AddWithValue("@Description", item.Description); cmd.Parameters.AddWithValue("@Discount", item.Discount); cmd.Parameters.AddWithValue("@MinMoney", item.MinMoney); cmd.Parameters.AddWithValue("@SingleQuantity", item.SingleQuantity); cmd.Parameters.AddWithValue("@Quantity", item.Quantity); db.ExecuteNonQuery(cmd); } }
public ActionResult CouponInfo(SE_GetPromotionActivityCouponInfoConfig model) { return(View(model)); }