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