public static int CreateMultiplePromotionCode(PromotionCodeModel promotionCodeModel, int num) { if (num == -1) { num = promotionCodeModel.Number; } return(CreateMultiplePromotionCode2(promotionCodeModel, num)); }
public static void CreateOrYzPromotion(string userId, decimal money, int OrderID) { if (money > 1000) { money = 1000; } var promotionCodeModel = new PromotionCodeModel(); promotionCodeModel.OrderId = 0; promotionCodeModel.Status = 0; promotionCodeModel.Description = "满" + (money + 1) + "元可用,仅限保养产品使用"; promotionCodeModel.Discount = (int)Math.Ceiling(money); promotionCodeModel.MinMoney = (money + 1); promotionCodeModel.EndTime = DateTime.Now.AddMonths(6).Date; promotionCodeModel.StartTime = DateTime.Now.Date; promotionCodeModel.UserId = new Guid(userId); promotionCodeModel.CodeChannel = "途虎免单券"; promotionCodeModel.BatchId = OrderID; promotionCodeModel.RuleId = 23; var result = CreateMultiplePromotionCode(promotionCodeModel, 1); }
public static int CreateMultiplePromotionCode2(PromotionCodeModel promotionCodeModel, int num) { try { using (var cmd = new SqlCommand("[Gungnir].[dbo].[Beautify_CreatePromotionCode]")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@StartTime", promotionCodeModel.StartTime.ToString()); cmd.Parameters.AddWithValue("@EndDateTime", promotionCodeModel.EndTime.ToString()); cmd.Parameters.AddWithValue("@Type", promotionCodeModel.Type); cmd.Parameters.AddWithValue("@Description", promotionCodeModel.Description); cmd.Parameters.AddWithValue("@Discount", promotionCodeModel.Discount); cmd.Parameters.AddWithValue("@MinMoney", promotionCodeModel.MinMoney); cmd.Parameters.AddWithValue("@Number", num); cmd.Parameters.AddWithValue("@CodeChannel", promotionCodeModel.CodeChannel); cmd.Parameters.AddWithValue("@UserID", promotionCodeModel.UserId); cmd.Parameters.AddWithValue("@BatchID", promotionCodeModel.BatchId == null ? 0 : promotionCodeModel.BatchId.Value); cmd.Parameters.AddWithValue("@RuleID", promotionCodeModel.RuleId); cmd.Parameters.Add(new SqlParameter() { ParameterName = "@Results", DbType = DbType.Int32, Direction = ParameterDirection.Output, Value = 0 }); DbHelper.ExecuteNonQuery(cmd); var result = Convert.ToInt32(cmd.Parameters["@Results"].Value); return(result); } } catch (Exception ex) { Logger.Error(ex.Message, ex); return(-99); } }
public static void CreateOrYzPromotion(string userId) { var lPro = new List <PromotionCodeModel>(); for (var i = 0; i < 6; i++) { var promotionCodeModel = new PromotionCodeModel(); promotionCodeModel.OrderId = 0; promotionCodeModel.Status = 0; switch (i) { case 0: //轮胎券 promotionCodeModel.Type = 1; promotionCodeModel.Description = "满599元可用,仅限轮胎产品使用"; promotionCodeModel.Discount = 10; promotionCodeModel.MinMoney = 599; promotionCodeModel.EndTime = DateTime.Now.AddDays(14); promotionCodeModel.RuleId = 25; break; case 1: //保养券 promotionCodeModel.Type = 2; promotionCodeModel.Description = "满299元可用,仅限保养产品使用"; promotionCodeModel.Discount = 20; promotionCodeModel.MinMoney = 299; promotionCodeModel.EndTime = DateTime.Now.AddDays(14); promotionCodeModel.RuleId = 23; break; case 2: //车品券 promotionCodeModel.Type = 8; promotionCodeModel.Description = "满79元可用,仅限车品产品使用"; promotionCodeModel.Discount = 5; promotionCodeModel.MinMoney = 79; promotionCodeModel.EndTime = DateTime.Now.AddDays(14); promotionCodeModel.RuleId = 30; break; case 3: //美容券 promotionCodeModel.Type = 5; promotionCodeModel.Description = "可用于洗车、打蜡产品使用"; promotionCodeModel.Discount = 5; promotionCodeModel.MinMoney = 5; promotionCodeModel.EndTime = DateTime.Now.AddDays(14); promotionCodeModel.RuleId = 32; break; case 4: //保养券 promotionCodeModel.Type = 2; promotionCodeModel.Description = "满199元可用,仅限保养产品使用"; promotionCodeModel.Discount = 10; promotionCodeModel.MinMoney = 199; promotionCodeModel.EndTime = DateTime.Now.AddDays(14); promotionCodeModel.RuleId = 23; break; case 5: //洗车券 promotionCodeModel.Type = 3; promotionCodeModel.Description = "可用于标准洗车5座"; promotionCodeModel.Discount = 0; promotionCodeModel.MinMoney = 0; promotionCodeModel.EndTime = DateTime.Now.AddDays(14); promotionCodeModel.RuleId = 42; break; } promotionCodeModel.StartTime = DateTime.Now; promotionCodeModel.UserId = new Guid(userId); promotionCodeModel.CodeChannel = "途虎新手大礼包"; promotionCodeModel.BatchId = -1; lPro.Add(promotionCodeModel); } using (var helper = DbHelper.CreateDbHelper()) { helper.BeginTransaction(); for (var i = 0; i < lPro.Count; i++) { var promotionCodeModel = new PromotionCodeModel(); promotionCodeModel = lPro[i]; #region 创建优惠券 var result = 0; try { result = CreateMultiplePromotionCode(promotionCodeModel, 1); if (result > 0) { } else { helper.Rollback(); } } catch (Exception ex) { Logger.Error(ex); helper.Rollback(); } #endregion 创建优惠券 } } }