public ActionResult SubmitPromitionActivity(SE_GetPromotionActivityConfig model, string CouponItems)
{
if (!string.IsNullOrWhiteSpace(CouponItems))
{
model.CouponItems = JsonConvert.DeserializeObject <IEnumerable <SE_GetPromotionActivityCouponInfoConfig> >(CouponItems);
PromotionActivityManager manager = new PromotionActivityManager();
if (model.ID == null)
{
model.CreatorUser = User.Identity.Name;
}
else
{
model.UpdateUser = User.Identity.Name;
}
if (manager.Save(model))
{
return(Json(1));
}
else
{
return(Json(0));
}
}
else
{
return(Json(0));
}
}
public bool Save(SE_GetPromotionActivityConfig model)
{
bool result = false;
string operate = "";
if (model.ID == null)
{
result = dal.Add(model);
operate = "新增";
}
else
{
result = dal.Update(model);
operate = "修改";
}
if (result)
{
using (var client = new ConfigLogClient())
{
client.InsertDefaultLogQueue("PromotionConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = model.ID?.ToString().ToLower(),
ObjectType = "PromotionActivity",
BeforeValue = "",
AfterValue = JsonConvert.SerializeObject(model),
Operate = operate,
Author = ThreadIdentity.Operator.Name
}));
}
}
return(result);
}
public SE_GetPromotionActivityConfig GetEntity(Guid ID)
{
SE_GetPromotionActivityConfig model = dal.GetEntity(ID).ConvertTo <SE_GetPromotionActivityConfig>().FirstOrDefault();
if (model != null)
{
model.CouponItems = dal.GetCouponInfo(ID).ConvertTo <SE_GetPromotionActivityCouponInfoConfig>();
}
return(model);
}
public ActionResult PromotionEdit(Guid?ID)
{
ViewBag.Count = 0;
if (ID == null)
{
return(View());
}
else
{
PromotionActivityManager manager = new PromotionActivityManager();
SE_GetPromotionActivityConfig model = manager.GetEntity(ID.Value);
ViewBag.Count = manager.GetPromotionActivityCountByID(ID.Value);
return(View(model));
}
}
public bool Update(SE_GetPromotionActivityConfig model)
{
bool result = false;
try
{
StringBuilder sql = new StringBuilder(@"UPDATE configuration.dbo.SE_GetPromotionActivityConfig SET
ActivityName =@ActivityName,
StartDateTime =@StartDateTime,
EndDateTime =@EndDateTime,
Channel =@Channel,
[Status] =@Status ,
TopBanner =@TopBanner,
BottomBanner =@BottomBanner,
NumberCodeTimes =@NumberCodeTimes,
ChartCodeTimes =@ChartCodeTimes,
AutoCompleteTimes =@AutoCompleteTimes,
CodeErrorTimes =@CodeErrorTimes,
LimitPhoneHourse =@LimitPhoneHourse,
NewUserValidMode =@NewUserValidMode,
SuccessfulTopBanner =@SuccessfulTopBanner,
SuccessfulCenterBanner =@SuccessfulCenterBanner,
SuccessfulBottomBanner=@SuccessfulBottomBanner ,
SuccessfulIOSUrl =@SuccessfulIOSUrl,
SuccessfulAndroidUrl =@SuccessfulAndroidUrl,
SuccessfulJumpMode =@SuccessfulJumpMode,
SuccessfulWaitTime=@SuccessfulWaitTime ,
FailTopBanner =@FailTopBanner,
FailCenterBanner =@FailCenterBanner,
FailBottomBanner =@FailBottomBanner,
FailIOSUrl =@FailIOSUrl,
FailAndroidUrl =@FailAndroidUrl,
FailJumpMode =@FailJumpMode,
FailWaitTime =@FailWaitTime,
UpdateDateTime=GETDATE(),
IsNewUser=@IsNewUser,
IsNeedCode=@IsNeedCode,
IsPostion=@IsPostion,IsSendMsg=@IsSendMsg,SendMsg=@SendMsg,
NewBottomBanner=@NewBottomBanner,NewPageIOSUrl=@NewPageIOSUrl,NewPageAndroidUrl=@NewPageAndroidUrl,
NewIOSUrl=@NewIOSUrl,NewAndroidUrl=@NewAndroidUrl,SuccessfulPageIOSUrl=@SuccessfulPageIOSUrl,SuccessfulPageAndroidUrl=@SuccessfulPageAndroidUrl,FailPageIOSUrl=@FailPageIOSUrl,FailPageAndroidUrl=@FailPageAndroidUrl,TipStyle=@TipStyle,NewJumpMode=@NewJumpMode,NewWaitTime=@NewWaitTime,
NewUserTip=@NewUserTip,OldUserTip=@OldUserTip,ActivityNoStartTip=@ActivityNoStartTip,ActivityOverTip=@ActivityOverTip,CouponTip=@CouponTip,PageTip=@PageTip,LimitUserTypeTip=@LimitUserTypeTip,AlreadyHadTip=@AlreadyHadTip,DefaultTip=@DefaultTip,BlackTip=@BlackTip,
CardChannel=@CardChannel,CardConsumedURL=@CardConsumedURL,CardExpireURL=@CardExpireURL,
CardGiftingURL=@CardGiftingURL,CardGiftTimeOutURL=@CardGiftTimeOutURL,CardDeleteURL=@CardDeleteURL,
CardUnavailableURL=@CardUnavailableURL,CardInvalidSerialCodeURL=@CardInvalidSerialCodeURL,TokenAccessFailedURL=@TokenAccessFailedURL,UpdateUser=@UpdateUser
WHERE ID=@ID
");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql.ToString();
cmd.Parameters.AddWithValue("@ActivityName", model.ActivityName);
cmd.Parameters.AddWithValue("@StartDateTime", model.StartDateTime);
cmd.Parameters.AddWithValue("@EndDateTime", model.EndDateTime);
cmd.Parameters.AddWithValue("@Channel", model.Channel);
cmd.Parameters.AddWithValue("@Status", model.Status);
cmd.Parameters.AddWithValue("@TopBanner", model.TopBanner);
cmd.Parameters.AddWithValue("@BottomBanner", model.BottomBanner);
cmd.Parameters.AddWithValue("@NumberCodeTimes", model.NumberCodeTimes);
cmd.Parameters.AddWithValue("@ChartCodeTimes", model.ChartCodeTimes);
cmd.Parameters.AddWithValue("@AutoCompleteTimes", model.AutoCompleteTimes);
cmd.Parameters.AddWithValue("@CodeErrorTimes", model.CodeErrorTimes);
cmd.Parameters.AddWithValue("@LimitPhoneHourse", model.LimitPhoneHourse);
cmd.Parameters.AddWithValue("@NewUserValidMode", model.NewUserValidMode);
cmd.Parameters.AddWithValue("@SuccessfulTopBanner", model.SuccessfulTopBanner);
cmd.Parameters.AddWithValue("@SuccessfulCenterBanner", model.SuccessfulCenterBanner);
cmd.Parameters.AddWithValue("@SuccessfulBottomBanner", model.SuccessfulBottomBanner);
cmd.Parameters.AddWithValue("@SuccessfulIOSUrl", model.SuccessfulIOSUrl);
cmd.Parameters.AddWithValue("@SuccessfulAndroidUrl", model.SuccessfulAndroidUrl);
cmd.Parameters.AddWithValue("@SuccessfulJumpMode", model.SuccessfulJumpMode);
cmd.Parameters.AddWithValue("@SuccessfulWaitTime", model.SuccessfulWaitTime);
cmd.Parameters.AddWithValue("@FailTopBanner", model.FailTopBanner);
cmd.Parameters.AddWithValue("@FailCenterBanner", model.FailCenterBanner);
cmd.Parameters.AddWithValue("@FailBottomBanner", model.FailBottomBanner);
cmd.Parameters.AddWithValue("@FailIOSUrl", model.FailIOSUrl);
cmd.Parameters.AddWithValue("@FailAndroidUrl", model.FailAndroidUrl);
cmd.Parameters.AddWithValue("@FailJumpMode", model.FailJumpMode);
cmd.Parameters.AddWithValue("@FailWaitTime", model.FailWaitTime);
cmd.Parameters.AddWithValue("@IsNewUser", model.IsNewUser);
cmd.Parameters.AddWithValue("@IsNeedCode", model.IsNeedCode);
cmd.Parameters.AddWithValue("@IsPostion", model.IsPostion);
cmd.Parameters.AddWithValue("@IsSendMsg", model.IsSendMsg);
cmd.Parameters.AddWithValue("@SendMsg", model.SendMsg);
cmd.Parameters.AddWithValue("@NewBottomBanner", model.NewBottomBanner);
cmd.Parameters.AddWithValue("@NewPageIOSUrl", model.NewPageIOSUrl);
cmd.Parameters.AddWithValue("@NewPageAndroidUrl", model.NewPageAndroidUrl);
cmd.Parameters.AddWithValue("@NewIOSUrl", model.NewIOSUrl);
cmd.Parameters.AddWithValue("@NewAndroidUrl", model.NewAndroidUrl);
cmd.Parameters.AddWithValue("@SuccessfulPageAndroidUrl", model.SuccessfulPageAndroidUrl);
cmd.Parameters.AddWithValue("@SuccessfulPageIOSUrl", model.SuccessfulPageIOSUrl);
cmd.Parameters.AddWithValue("@FailPageAndroidUrl", model.FailPageAndroidUrl);
cmd.Parameters.AddWithValue("@FailPageIOSUrl", model.FailPageIOSUrl);
cmd.Parameters.AddWithValue("@TipStyle", model.TipStyle);
cmd.Parameters.AddWithValue("@NewJumpMode", model.NewJumpMode);
cmd.Parameters.AddWithValue("@NewWaitTime", model.NewWaitTime);
cmd.Parameters.AddWithValue("@NewUserTip", model.NewUserTip);
cmd.Parameters.AddWithValue("@OldUserTip", model.OldUserTip);
cmd.Parameters.AddWithValue("@ActivityNoStartTip", model.ActivityNoStartTip);
cmd.Parameters.AddWithValue("@ActivityOverTip", model.ActivityOverTip);
cmd.Parameters.AddWithValue("@CouponTip", model.CouponTip);
cmd.Parameters.AddWithValue("@PageTip", model.PageTip);
cmd.Parameters.AddWithValue("@LimitUserTypeTip", model.LimitUserTypeTip);
cmd.Parameters.AddWithValue("@AlreadyHadTip", model.AlreadyHadTip);
cmd.Parameters.AddWithValue("@DefaultTip", model.DefaultTip);
cmd.Parameters.AddWithValue("@BlackTip", model.BlackTip);
cmd.Parameters.AddWithValue("@ID", model.ID.Value);
cmd.Parameters.AddWithValue("@CardChannel", model.CardChannel);
cmd.Parameters.AddWithValue("@CardConsumedURL", model.CardConsumedURL);
cmd.Parameters.AddWithValue("@CardExpireURL", model.CardExpireURL);
cmd.Parameters.AddWithValue("@CardGiftingURL", model.CardGiftingURL);
cmd.Parameters.AddWithValue("@CardGiftTimeOutURL", model.CardGiftTimeOutURL);
cmd.Parameters.AddWithValue("@CardDeleteURL", model.CardDeleteURL);
cmd.Parameters.AddWithValue("@CardUnavailableURL", model.CardUnavailableURL);
cmd.Parameters.AddWithValue("@CardInvalidSerialCodeURL", model.CardInvalidSerialCodeURL);
cmd.Parameters.AddWithValue("@TokenAccessFailedURL", model.TokenAccessFailedURL);
cmd.Parameters.AddWithValue("@UpdateUser", model.UpdateUser);
db.ExecuteNonQuery(cmd);
DeleteCouponInfo(db, model.ID.Value);
foreach (var item in model.CouponItems)
{
item.FK_GetPromotionActivityID = model.ID.Value;
item.Status = true;
InsertCouponInfo(db, item);
}
db.Commit();
result = true;
}
catch (Exception em)
{
db.Rollback();
result = false;
}
finally
{
db.Dispose();
}
return(result);
}
public bool Add(SE_GetPromotionActivityConfig model)
{
bool result = false;
StringBuilder sql = new StringBuilder();
try
{
db.BeginTransaction();
sql.Append(@" INSERT INTO Configuration.dbo.SE_GetPromotionActivityConfig
( ID ,
ActivityName ,
StartDateTime ,
EndDateTime ,
Channel ,
Status ,
TopBanner ,
BottomBanner ,
NumberCodeTimes ,
ChartCodeTimes ,
AutoCompleteTimes ,
CodeErrorTimes ,
LimitPhoneHourse ,
NewUserValidMode ,
SuccessfulTopBanner ,
SuccessfulCenterBanner ,
SuccessfulBottomBanner ,
SuccessfulIOSUrl ,
SuccessfulAndroidUrl ,
SuccessfulJumpMode ,
SuccessfulWaitTime ,
FailTopBanner ,
FailCenterBanner ,
FailBottomBanner ,
FailIOSUrl ,
FailAndroidUrl ,
FailJumpMode ,
FailWaitTime ,
CreateDateTime ,
UpdateDateTime,
IsNewUser,
IsNeedCode,
IsPostion,IsSendMsg,SendMsg,
NewBottomBanner,NewPageIOSUrl,NewPageAndroidUrl,NewIOSUrl,NewAndroidUrl,SuccessfulPageIOSUrl,SuccessfulPageAndroidUrl,FailPageIOSUrl,FailPageAndroidUrl,TipStyle,NewJumpMode,NewWaitTime,
NewUserTip,OldUserTip,ActivityNoStartTip,ActivityOverTip,CouponTip,PageTip,LimitUserTypeTip,AlreadyHadTip,DefaultTip,BlackTip,CardChannel,CardConsumedURL,CardExpireURL,
CardGiftingURL,CardGiftTimeOutURL,CardDeleteURL,CardUnavailableURL,CardInvalidSerialCodeURL,TokenAccessFailedURL,CreatorUser,UpdateUser
)");
sql.Append(@" VALUES ( @ID , -- ID - uniqueidentifier
@ActivityName , -- ActivityName - nvarchar(100)
@StartDateTime , -- StartDateTime - datetime
@EndDateTime , -- EndDateTime - datetime
@Channel, -- Channel - nvarchar(50)
@Status , -- Status - bigint
@TopBanner , -- TopBanner - nvarchar(500)
@BottomBanner , -- BottomBanner - nvarchar(500)
@NumberCodeTimes , -- NumberCodeTimes - int
@ChartCodeTimes , -- ChartCodeTimes - int
@AutoCompleteTimes , -- AutoCompleteTimes - int
@CodeErrorTimes , -- CodeErrorTimes - int
@LimitPhoneHourse, -- LimitPhoneHourse - int
@NewUserValidMode , -- NewUserValidMode - int
@SuccessfulTopBanner , -- SuccessfulTopBanner - nvarchar(500)
@SuccessfulCenterBanner , -- SuccessfulCenterBanner - nvarchar(500)
@SuccessfulBottomBanner , -- SuccessfulBottomBanner - nvarchar(500)
@SuccessfulIOSUrl , -- SuccessfulIOSUrl - nvarchar(100)
@SuccessfulAndroidUrl , -- SuccessfulAndroidUrl - nvarchar(100)
@SuccessfulJumpMode , -- SuccessfulJumpMode - int
@SuccessfulWaitTime , -- SuccessfulWaitTime - int
@FailTopBanner , -- FailTopBanner - nvarchar(500)
@FailCenterBanner , -- FailCenterBanner - nvarchar(500)
@FailBottomBanner , -- FailBottomBanner - nvarchar(500)
@FailIOSUrl , -- FailIOSUrl - nvarchar(100)
@FailAndroidUrl , -- FailAndroidUrl - nvarchar(100)
@FailJumpMode , -- FailJumpMode - int
@FailWaitTime , -- FailWaitTime - int
GETDATE() , -- CreateDateTime - datetime
GETDATE(), -- UpdateDateTime - datetime
@IsNewUser,
@IsNeedCode,
@IsPostion,@IsSendMsg,@SendMsg,
@NewBottomBanner,@NewPageIOSUrl,@NewPageAndroidUrl,@NewIOSUrl,@NewAndroidUrl,@SuccessfulPageIOSUrl,@SuccessfulPageAndroidUrl,@FailPageIOSUrl,@FailPageAndroidUrl,@TipStyle,@NewJumpMode,@NewWaitTime,
@NewUserTip,@OldUserTip,@ActivityNoStartTip,@ActivityOverTip,@CouponTip,@PageTip,@LimitUserTypeTip,@AlreadyHadTip,@DefaultTip,@BlackTip,@CardChannel,@CardConsumedURL,@CardExpireURL,
@CardGiftingURL,@CardGiftTimeOutURL,@CardDeleteURL,@CardUnavailableURL,@CardInvalidSerialCodeURL,@TokenAccessFailedURL,@CreatorUser,@UpdateUser
)");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql.ToString();
model.ID = Guid.NewGuid();
cmd.Parameters.AddWithValue("@ID", model.ID.Value);
cmd.Parameters.AddWithValue("@ActivityName", model.ActivityName);
cmd.Parameters.AddWithValue("@StartDateTime", model.StartDateTime);
cmd.Parameters.AddWithValue("@EndDateTime", model.EndDateTime);
cmd.Parameters.AddWithValue("@Channel", model.Channel);
cmd.Parameters.AddWithValue("@Status", model.Status);
cmd.Parameters.AddWithValue("@TopBanner", model.TopBanner);
cmd.Parameters.AddWithValue("@BottomBanner", model.BottomBanner);
cmd.Parameters.AddWithValue("@NumberCodeTimes", model.NumberCodeTimes);
cmd.Parameters.AddWithValue("@ChartCodeTimes", model.ChartCodeTimes);
cmd.Parameters.AddWithValue("@AutoCompleteTimes", model.AutoCompleteTimes);
cmd.Parameters.AddWithValue("@CodeErrorTimes", model.CodeErrorTimes);
cmd.Parameters.AddWithValue("@LimitPhoneHourse", model.LimitPhoneHourse);
cmd.Parameters.AddWithValue("@NewUserValidMode", model.NewUserValidMode);
cmd.Parameters.AddWithValue("@SuccessfulTopBanner", model.SuccessfulTopBanner);
cmd.Parameters.AddWithValue("@SuccessfulCenterBanner", model.SuccessfulCenterBanner);
cmd.Parameters.AddWithValue("@SuccessfulBottomBanner", model.SuccessfulBottomBanner);
cmd.Parameters.AddWithValue("@SuccessfulIOSUrl", model.SuccessfulIOSUrl);
cmd.Parameters.AddWithValue("@SuccessfulAndroidUrl", model.SuccessfulAndroidUrl);
cmd.Parameters.AddWithValue("@SuccessfulJumpMode", model.SuccessfulJumpMode);
cmd.Parameters.AddWithValue("@SuccessfulWaitTime", model.SuccessfulWaitTime);
cmd.Parameters.AddWithValue("@FailTopBanner", model.FailTopBanner);
cmd.Parameters.AddWithValue("@FailCenterBanner", model.FailCenterBanner);
cmd.Parameters.AddWithValue("@FailBottomBanner", model.FailBottomBanner);
cmd.Parameters.AddWithValue("@FailIOSUrl", model.FailIOSUrl);
cmd.Parameters.AddWithValue("@FailAndroidUrl", model.FailAndroidUrl);
cmd.Parameters.AddWithValue("@FailJumpMode", model.FailJumpMode);
cmd.Parameters.AddWithValue("@FailWaitTime", model.FailWaitTime);
cmd.Parameters.AddWithValue("@IsNewUser", model.IsNewUser);
cmd.Parameters.AddWithValue("@IsNeedCode", model.IsNeedCode);
cmd.Parameters.AddWithValue("@IsPostion", model.IsPostion);
cmd.Parameters.AddWithValue("@IsSendMsg", model.IsSendMsg);
cmd.Parameters.AddWithValue("@SendMsg", model.SendMsg);
cmd.Parameters.AddWithValue("@NewBottomBanner", model.NewBottomBanner);
cmd.Parameters.AddWithValue("@NewPageIOSUrl", model.NewPageIOSUrl);
cmd.Parameters.AddWithValue("@NewPageAndroidUrl", model.NewPageAndroidUrl);
cmd.Parameters.AddWithValue("@NewIOSUrl", model.NewIOSUrl);
cmd.Parameters.AddWithValue("@NewAndroidUrl", model.NewAndroidUrl);
cmd.Parameters.AddWithValue("@SuccessfulPageAndroidUrl", model.SuccessfulPageAndroidUrl);
cmd.Parameters.AddWithValue("@SuccessfulPageIOSUrl", model.SuccessfulPageIOSUrl);
cmd.Parameters.AddWithValue("@FailPageAndroidUrl", model.FailPageAndroidUrl);
cmd.Parameters.AddWithValue("@FailPageIOSUrl", model.FailPageIOSUrl);
cmd.Parameters.AddWithValue("@TipStyle", model.TipStyle);
cmd.Parameters.AddWithValue("@NewJumpMode", model.NewJumpMode);
cmd.Parameters.AddWithValue("@NewWaitTime", model.NewWaitTime);
cmd.Parameters.AddWithValue("@NewUserTip", model.NewUserTip);
cmd.Parameters.AddWithValue("@OldUserTip", model.OldUserTip);
cmd.Parameters.AddWithValue("@ActivityNoStartTip", model.ActivityNoStartTip);
cmd.Parameters.AddWithValue("@ActivityOverTip", model.ActivityOverTip);
cmd.Parameters.AddWithValue("@CouponTip", model.CouponTip);
cmd.Parameters.AddWithValue("@PageTip", model.PageTip);
cmd.Parameters.AddWithValue("@LimitUserTypeTip", model.LimitUserTypeTip);
cmd.Parameters.AddWithValue("@AlreadyHadTip", model.AlreadyHadTip);
cmd.Parameters.AddWithValue("@DefaultTip", model.DefaultTip);
cmd.Parameters.AddWithValue("@BlackTip", model.BlackTip);
cmd.Parameters.AddWithValue("@CardChannel", model.CardChannel);
cmd.Parameters.AddWithValue("@CardConsumedURL", model.CardConsumedURL);
cmd.Parameters.AddWithValue("@CardExpireURL", model.CardExpireURL);
cmd.Parameters.AddWithValue("@CardGiftingURL", model.CardGiftingURL);
cmd.Parameters.AddWithValue("@CardGiftTimeOutURL", model.CardGiftTimeOutURL);
cmd.Parameters.AddWithValue("@CardDeleteURL", model.CardDeleteURL);
cmd.Parameters.AddWithValue("@CardUnavailableURL", model.CardUnavailableURL);
cmd.Parameters.AddWithValue("@CardInvalidSerialCodeURL", model.CardInvalidSerialCodeURL);
cmd.Parameters.AddWithValue("@TokenAccessFailedURL", model.TokenAccessFailedURL);
cmd.Parameters.AddWithValue("@CreatorUser", model.CreatorUser);
cmd.Parameters.AddWithValue("@UpdateUser", model.UpdateUser);
db.ExecuteNonQuery(cmd);
foreach (var item in model.CouponItems)
{
item.FK_GetPromotionActivityID = model.ID.Value;
item.Status = true;
InsertCouponInfo(db, item);
}
db.Commit();
result = true;
}
catch (Exception em)
{
db.Rollback();
result = false;
}
finally
{
db.Dispose();
}
return(result);
}
