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