public bool EditSettingV1(Guid?activityID, CouponActivityModel CASModel) { if (CASModel != null) { return(dbManager.Execute(connection => DalSetting_CouponSetting.EditSettingV1(connection, activityID, CASModel))); } else { return(false); } }
public ActionResult EditV1(Guid?activityID) { ViewBag.CouponTypes = settingManager.SelectAllPromotionRules(); if (activityID == null) { ViewBag.Title = "添加优惠券活动页"; ViewBag.ActivityType = 0; return(View()); } else { ViewBag.Title = "编辑优惠券活动页"; CouponActivityModel model = settingManager.FetchCouponActivity(activityID.Value); ViewBag.ActivityType = model.ActivityType; return(View(model)); } }
public bool EditSettingV1(Guid?activityID, CouponActivityModel CASModel) { try { if (CASModel != null) { return(handler.EditSettingV1(activityID, CASModel)); } else { return(false); } } catch (Exception ex) { logger.Log(Level.Error, ex, "EditSetting"); throw; } }
/// <summary> /// 添加/修改(多张表) /// </summary> /// <param name="connection"></param> /// <param name="PKID"></param> /// <returns></returns> public static bool EditSetting(SqlConnection connection, Guid?activityID, CouponActivityModel CASModel) { var tran = connection.BeginTransaction(); try { var paras = new[] { new SqlParameter("@ActivityID", activityID ?? Guid.NewGuid()), new SqlParameter("@ActivityName", CASModel.ActivityName), new SqlParameter("@ActivityChannel", CASModel.ActivityChannel), new SqlParameter("@StartTime", CASModel.StartTime), new SqlParameter("@EndTime", CASModel.EndTime), new SqlParameter("@BannerImg", CASModel.BannerImg), new SqlParameter("@ActivityRuleImg", CASModel.ActivityRuleImg), new SqlParameter("@CouponNum", CASModel.CouponNum), new SqlParameter("@IsNewUser", CASModel.IsNewUser), new SqlParameter("@ActivityType", CASModel.ActivityType) }; if (activityID == null) { paras[0].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "Activity..CouponActivity_InsertCouponActivity", paras); CASModel.ActivityID = (Guid)paras[0].Value; } else { SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "Activity..CouponActivity_UpdateCouponActivity", paras); CASModel.ActivityID = activityID.Value; } if (activityID != null) { SqlHelper.ExecuteNonQuery(tran, CommandType.Text, @"UPDATE Activity..tbl_CouponActivity_Coupon SET Deleted = 1 WHERE ActivityID = @ActivityID;", new SqlParameter("@ActivityID", CASModel.ActivityID)); } foreach (var item in CASModel.Coupons) { if (item.PKID == 0) { //添加 SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "Activity..CouponActivity_InsertCouponActivity_Coupon", new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@CouponType", item.CouponType), new SqlParameter("@Money", item.Money), new SqlParameter("@MinMoney", item.MinMoney), new SqlParameter("@DateWay", item.DateWay), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate), new SqlParameter("@ValidDays", item.ValidDays), new SqlParameter("@Instructions", item.Instructions), new SqlParameter("@CouponNum", item.CouponNum == 0 ? (object)null : item.CouponNum)); } else { //更新现有的优惠券 SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "Activity..CouponActivity_UpdateCouponActivity_Coupon", new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@CouponType", item.CouponType), new SqlParameter("@Money", item.Money), new SqlParameter("@MinMoney", item.MinMoney), new SqlParameter("@DateWay", item.DateWay), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate), new SqlParameter("@ValidDays", item.ValidDays), new SqlParameter("@Instructions", item.Instructions), new SqlParameter("@CouponNum", item.CouponNum == 0 ? (object)null : item.CouponNum), new SqlParameter("@PKID", item.PKID)); } } SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, activityID == null ? "Activity..CouponActivity_InsertCouponActivity_Page" : "Activity..CouponActivity_UpdateCouponActivity_Page", new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@PageNumber", CASModel.SuccessPage.PageNumber), new SqlParameter("@TopImg", CASModel.SuccessPage.TopImg), new SqlParameter("@CenterImg", CASModel.SuccessPage.CenterImg), new SqlParameter("@BottomImg", CASModel.SuccessPage.BottomImg), new SqlParameter("@IOSLink", CASModel.SuccessPage.IOSLink), new SqlParameter("@AndroidLink", CASModel.SuccessPage.AndroidLink), new SqlParameter("@JumpMillisecond", CASModel.SuccessPage.JumpMillisecond)); SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, activityID == null ? "Activity..CouponActivity_InsertCouponActivity_Page" : "Activity..CouponActivity_UpdateCouponActivity_Page", new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@PageNumber", CASModel.ErrorPage.PageNumber), new SqlParameter("@TopImg", CASModel.ErrorPage.TopImg), new SqlParameter("@CenterImg", CASModel.ErrorPage.CenterImg), new SqlParameter("@BottomImg", CASModel.ErrorPage.BottomImg), new SqlParameter("@IOSLink", CASModel.ErrorPage.IOSLink), new SqlParameter("@AndroidLink", CASModel.ErrorPage.AndroidLink), new SqlParameter("@JumpMillisecond", CASModel.ErrorPage.JumpMillisecond)); tran.Commit(); return(true); } //catch //{ // return false; //} finally { tran.Dispose(); } }
/// <summary> /// 添加/修改(多张表) /// </summary> /// <param name="connection"></param> /// <param name="PKID"></param> /// <returns></returns> public static bool EditSettingV1(SqlConnection connection, Guid?activityID, CouponActivityModel CASModel) { var tran = connection.BeginTransaction(); try { var paras = new[] { new SqlParameter("@ActivityID", activityID ?? Guid.NewGuid()), new SqlParameter("@ActivityName", CASModel.ActivityName), new SqlParameter("@ActivityChannel", CASModel.ActivityChannel), new SqlParameter("@StartTime", CASModel.StartTime), new SqlParameter("@EndTime", CASModel.EndTime), new SqlParameter("@BannerImg", CASModel.BannerImg), new SqlParameter("@ActivityRuleImg", CASModel.ActivityRuleImg), new SqlParameter("@CouponNum", CASModel.CouponNum), new SqlParameter("@IsNewUser", CASModel.IsNewUser), new SqlParameter("@ActivityType", CASModel.ActivityType) }; if (activityID == null) { paras[0].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "Activity..CouponActivity_InsertCouponActivity", paras); CASModel.ActivityID = (Guid)paras[0].Value; } else { const string sql = @"UPDATE Activity..tbl_CouponActivity SET ActivityName = @ActivityName, ActivityChannel = @ActivityChannel, StartTime = @StartTime, EndTime = @EndTime, BannerImg = @BannerImg, ActivityRuleImg = @ActivityRuleImg, CouponNum = @CouponNum, IsNewUser = @IsNewUser, LastUpdateDateTime = GETDATE(), ActivityType=@ActivityType WHERE ActivityID = @ActivityID; "; SqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, paras); CASModel.ActivityID = activityID.Value; } if (activityID != null) { SqlHelper.ExecuteNonQuery(tran, CommandType.Text, @"UPDATE Activity..tbl_CouponActivity_Coupon SET Deleted = 1 WHERE ActivityID = @ActivityID;", new SqlParameter("@ActivityID", CASModel.ActivityID)); } foreach (var item in CASModel.Coupons) { if (item.PKID == 0) { const string sql = @"INSERT INTO Activity..tbl_CouponActivity_Coupon ( ActivityID, CouponType, Money, MinMoney, DateWay, StartDate, EndDate, ValidDays, Instructions , CouponNum, CouponId ) VALUES ( @ActivityID, -- ActivityID - uniqueidentifier @CouponType, -- CouponType - int @Money, -- Money - int @MinMoney, -- MinMoney - int @DateWay, @StartDate, -- StartTime - datetime @EndDate, -- EndTime - datetime @ValidDays, -- ValidTime - int @Instructions, -- Instructions - nvarchar(200) @CouponNum, @CouponId );" ; //添加 SqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@CouponType", item.CouponType), new SqlParameter("@Money", item.Money), new SqlParameter("@MinMoney", item.MinMoney), new SqlParameter("@DateWay", item.StartDate.HasValue ? 0 : 1), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate), new SqlParameter("@ValidDays", item.ValidDays), new SqlParameter("@Instructions", item.Instructions), new SqlParameter("@CouponNum", item.CouponNum == 0 ? (object)null : item.CouponNum), new SqlParameter("@CouponId", item.CouponId)); } else { const string sql = @"UPDATE Activity..tbl_CouponActivity_Coupon SET Deleted = 0 , ActivityID = @ActivityID , CouponType = @CouponType , [Money] = @Money , MinMoney = @MinMoney , DateWay = @DateWay , StartDate = @StartDate , EndDate = @EndDate , ValidDays = @ValidDays , Instructions = @Instructions , CouponNum = @CouponNum , CouponId = @CouponId WHERE PKID = @PKID"; //更新现有的优惠券 SqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@CouponType", item.CouponType), new SqlParameter("@Money", item.Money), new SqlParameter("@MinMoney", item.MinMoney), new SqlParameter("@DateWay", item.StartDate.HasValue ? 0 : 1), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate), new SqlParameter("@ValidDays", item.ValidDays), new SqlParameter("@Instructions", item.Instructions), new SqlParameter("@CouponNum", item.CouponNum == 0 ? (object)null : item.CouponNum), new SqlParameter("@PKID", item.PKID), new SqlParameter("@CouponId", item.CouponId)); } } if (true) { const string insertPage = @"INSERT INTO Activity..tbl_CouponActivity_Page ( ActivityID, PageNumber, TopImg, CenterImg, BottomImg, IOSLink, AndroidLink, JumpMillisecond ) VALUES ( @ActivityID, -- ActivityID - uniqueidentifier @PageNumber, -- PageNumber - tinyint @TopImg, -- TopImg - nvarchar(200) @CenterImg, -- CenterImg - nvarchar(200) @BottomImg, -- BottomImg - nvarchar(200) @IOSLink, -- IOSLink - nvarchar(200) @AndroidLink, -- AndroidLink - nvarchar(200) @JumpMillisecond -- JumpMillisecond - int );" ; const string updatePage = @"UPDATE Activity..tbl_CouponActivity_Page SET TopImg = @TopImg, CenterImg = @CenterImg, BottomImg = @BottomImg, IOSLink = @IOSLink, AndroidLink = @AndroidLink, JumpMillisecond = @JumpMillisecond, LastUpdateDateTime = GETDATE() WHERE ActivityID = @ActivityID AND PageNumber = @PageNumber;" ; var successParameters = new SqlParameter[] { new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@PageNumber", CASModel.SuccessPage.PageNumber), new SqlParameter("@TopImg", CASModel.SuccessPage.TopImg), new SqlParameter("@CenterImg", CASModel.SuccessPage.CenterImg), new SqlParameter("@BottomImg", CASModel.SuccessPage.BottomImg), new SqlParameter("@IOSLink", CASModel.SuccessPage.IOSLink), new SqlParameter("@AndroidLink", CASModel.SuccessPage.AndroidLink), new SqlParameter("@JumpMillisecond", CASModel.SuccessPage.JumpMillisecond) }; SqlHelper.ExecuteNonQuery(tran, CommandType.Text, activityID == null ? insertPage : updatePage, successParameters); var errorParameters = new SqlParameter[] { new SqlParameter("@ActivityID", CASModel.ActivityID), new SqlParameter("@PageNumber", CASModel.ErrorPage.PageNumber), new SqlParameter("@TopImg", CASModel.ErrorPage.TopImg), new SqlParameter("@CenterImg", CASModel.ErrorPage.CenterImg), new SqlParameter("@BottomImg", CASModel.ErrorPage.BottomImg), new SqlParameter("@IOSLink", CASModel.ErrorPage.IOSLink), new SqlParameter("@AndroidLink", CASModel.ErrorPage.AndroidLink), new SqlParameter("@JumpMillisecond", CASModel.ErrorPage.JumpMillisecond) }; SqlHelper.ExecuteNonQuery(tran, CommandType.Text, activityID == null ? insertPage : updatePage, errorParameters); } tran.Commit(); return(true); } //catch //{ // return false; //} finally { tran.Dispose(); } }