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