public ActionResult Edit(BaoYangPackageActivityConfig model)
{
string js = "<script>alert(\"保存失败 \");location='/BaoYangPackageActivityConfig/Index';</script>";
if (model.Id != 0)
{
if (BaoYangPackageActivityConfigManager.UpdateBaoYangPackageActivityConfig(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
else
{
if (BaoYangPackageActivityConfigManager.InsertBaoYangPackageActivityConfig(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
}
public static bool UpdateBaoYangPackageActivityConfig(BaoYangPackageActivityConfig model)
{
const string sql = @"UPDATE [Configuration].[dbo].[SE_BaoYangPackageActivityConfig]
SET
ActivityName = @ActivityName ,
ActivityStatus = @ActivityStatus ,
CheckStatus = @CheckStatus ,
LayerImage = @LayerImage ,
CouponId = @CouponId ,
ButtonChar = @ButtonChar ,
ActivityImage = @ActivityImage,
UpdateTime = GETDATE(),
GetRuleGUID=@GetRuleGUID
WHERE Id = @Id";
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@ActivityName", model.ActivityName),
new SqlParameter("@ActivityNum", model.ActivityNum),
new SqlParameter("@ActivityStatus", model.ActivityStatus),
new SqlParameter("@ButtonChar", model.ButtonChar),
new SqlParameter("@CheckStatus", model.CheckStatus),
new SqlParameter("@CouponId", model.CouponId),
new SqlParameter("@LayerImage", model.LayerImage),
new SqlParameter("@Id", model.Id),
new SqlParameter("@ActivityImage", model.ActivityImage),
new SqlParameter("@GetRuleGUID", model.GetRuleGUID ?? string.Empty)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0);
}
public static bool InsertBaoYangPackageActivityConfig(BaoYangPackageActivityConfig model)
{
const string sql = @"INSERT INTO [Configuration].[dbo].[SE_BaoYangPackageActivityConfig]
(
[ActivityNum]
,[ActivityName]
,[ActivityStatus]
,[CheckStatus]
,[LayerImage]
,[CouponId]
,[ButtonChar]
,[CreateTime]
,[UpdateTime]
,ActivityImage
,GetRuleGUID
)
VALUES ( @ActivityNum
,@ActivityName
,@ActivityStatus
,@CheckStatus
,@LayerImage
,@CouponId
,@ButtonChar
,GETDATE()
,GETDATE()
,@ActivityImage
,@GetRuleGUID
)SELECT @@IDENTITY
";
string activityNum = Guid.NewGuid().ToString();
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@ActivityName", model.ActivityName),
new SqlParameter("@ActivityNum", activityNum),
new SqlParameter("@ActivityStatus", model.ActivityStatus),
new SqlParameter("@ButtonChar", model.ButtonChar),
new SqlParameter("@CheckStatus", model.CheckStatus),
new SqlParameter("@CouponId", model.CouponId),
new SqlParameter("@LayerImage", model.LayerImage),
new SqlParameter("@ActivityImage", model.ActivityImage),
new SqlParameter("@GetRuleGUID", model.GetRuleGUID)
};
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters)) > 0);
}
public bool InsertBaoYangPackageActivityConfig(BaoYangPackageActivityConfig model)
{
try
{
return(DalBaoYangPackageActivityConfig.InsertBaoYangPackageActivityConfig(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new BaoYangPackageActivityConfigException(1, "InsertBaoYangPackageActivityConfig", ex);
Logger.Log(Level.Error, exception, "InsertBaoYangPackageActivityConfig");
throw ex;
}
}
