public static bool UpdateConfigCoupon(SqlConnection conn, ConfigCoupon model)
{
const string sql = @"UPDATE [Configuration]..ConfigCoupon
SET BackgroundImage = @BackgroundImage ,
BackgroundSmallImage = @BackgroundSmallImage ,
BackgroundColor = @BackgroundColor ,
ActivityRule = @ActivityRule ,
LinkAvailable = @LinkAvailable ,
LinkImage = @LinkImage ,
LinkSamllImage = @LinkSamllImage ,
AppLink = @AppLink ,
WeixinLink = @WeixinLink ,
Link = @Link ,
CheckLink = @CheckLink ,
CreateTime = GETDATE()
WHERE Id = @Id";
var sqlParams = new SqlParameter[]
{
new SqlParameter("@ActivityRule", model.ActivityRule ?? string.Empty),
new SqlParameter("@AppLink", model.AppLink ?? string.Empty),
new SqlParameter("@BackgroundColor", model.BackgroundColor ?? string.Empty),
new SqlParameter("@BackgroundImage", model.BackgroundImage ?? string.Empty),
new SqlParameter("@BackgroundSmallImage", model.BackgroundSmallImage ?? string.Empty),
new SqlParameter("@LinkAvailable", model.LinkAvailable),
new SqlParameter("@LinkImage", model.LinkImage ?? string.Empty),
new SqlParameter("@LinkSamllImage", model.LinkSamllImage ?? string.Empty),
new SqlParameter("@WeixinLink", model.WeixinLink ?? string.Empty),
new SqlParameter("@Id", model.Id),
new SqlParameter("@Link", model.Link),
new SqlParameter("@CheckLink", model.CheckLink)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParams) > 0);
}
public ActionResult Add(ConfigCoupon model)
{
if (model.Id > 0)
{
DownloadAppManager.UpdateConfigCoupon(model);
}
else
{
DownloadAppManager.InsertConfigCoupon(model);
}
return(Redirect("Index"));
}
public bool UpdateConfigCoupon(ConfigCoupon model)
{
try
{
return(handler.UpdateConfigCoupon(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "UpdateConfigCoupon", ex);
Logger.Log(Level.Error, exception, "UpdateConfigCoupon");
throw ex;
}
}
public static bool InsertConfigCoupon(SqlConnection conn, ConfigCoupon model)
{
const string sql = @"INSERT INTO [Configuration]..ConfigCoupon
( BackgroundImage ,
BackgroundSmallImage ,
BackgroundColor ,
ActivityRule ,
LinkAvailable ,
LinkImage ,
LinkSamllImage ,
AppLink ,
WeixinLink ,
Link ,
CheckLink ,
CreateTime
)
VALUES ( @BackgroundImage , -- BackgroundImage - nvarchar(1000)
@BackgroundSmallImage , -- BackgroundSmallImage - nvarchar(1000)
@BackgroundColor , -- BackgroundColor - nvarchar(50)
@ActivityRule , -- ActivityRule - text
@LinkAvailable , -- LinkAvailable - bit
@LinkImage , -- LinkImage - nvarchar(1000)
@LinkSamllImage , -- LinkSamllImage - nvarchar(1000)
@AppLink , -- AppLink - nvarchar(1000)
@WeixinLink ,-- WeixinLink - nvarchar(1000)
@Link ,
@CheckLink ,
GETDATE()
)";
var sqlParams = new SqlParameter[]
{
new SqlParameter("@ActivityRule", model.ActivityRule ?? string.Empty),
new SqlParameter("@AppLink", model.AppLink ?? string.Empty),
new SqlParameter("@BackgroundColor", model.BackgroundColor ?? string.Empty),
new SqlParameter("@BackgroundImage", model.BackgroundImage ?? string.Empty),
new SqlParameter("@BackgroundSmallImage", model.BackgroundSmallImage ?? string.Empty),
new SqlParameter("@LinkAvailable", model.LinkAvailable),
new SqlParameter("@LinkImage", model.LinkImage ?? string.Empty),
new SqlParameter("@LinkSamllImage", model.LinkSamllImage ?? string.Empty),
new SqlParameter("@WeixinLink", model.WeixinLink ?? string.Empty),
new SqlParameter("@Link", model.Link),
new SqlParameter("@CheckLink", model.CheckLink)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParams) > 0);
}
public bool InsertConfigCoupon(ConfigCoupon model)
{
return(DALConfigApi.InsertConfigCoupon(conn, model));
}
public bool UpdateConfigCoupon(ConfigCoupon model)
{
return(DALConfigApi.UpdateConfigCoupon(conn, model));
}
