public static bool InsertActivityPageUrlConfig(ActivityPageUrlConfig model, ref int id)
{
const string sql = @" INSERT INTO Configuration..[SE_ActivityPageUrlConfig]
(
[ActivityPageId]
,[Url]
,[CreateTime]
,[CreateName]
,[UpdateTime]
,[UpdateName]
,[Name]
)
VALUES (
@ActivityPageId
,@Url
,GETDATE()
,@CreateName
,GETDATE()
,@UpdateName
,@Name
)SELECT @@IDENTITY";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@CreateName", model.CreateName ?? "途虎测试"),
new SqlParameter("@Url", model.Url),
new SqlParameter("@Name", model.Name),
new SqlParameter("@ActivityPageId", model.ActivityPageId),
new SqlParameter("@UpdateName", model.UpdateName ?? "途虎测试"),
};
id = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParameter));
return(id > 0);
}
public bool InsertActivityPageUrlConfig(ActivityPageUrlConfig model, ref int id)
{
try
{
return(DALRegionActivityPageConfig.InsertActivityPageUrlConfig(model, ref id));
}
catch (Exception ex)
{
Logger.Log(Level.Error, ex, "InsertActivityPageConfig");
throw ex;
}
}
public bool UpdateActivityPageUrlConfig(ActivityPageUrlConfig model)
{
try
{
return(DALRegionActivityPageConfig.UpdateActivityPageUrlConfig(model));
}
catch (Exception ex)
{
Logger.Log(Level.Error, ex, "UpdateActivityPageUrlConfig");
throw ex;
}
}
public static bool UpdateActivityPageUrlConfig(ActivityPageUrlConfig model)
{
const string sql = @"UPDATE Configuration..SE_ActivityPageUrlConfig SET
[Url]=@Url
,[ActivityPageId]=@ActivityPageId
,[UpdateTime]=GETDATE()
,[UpdateName]=@UpdateName
,[Name]=@Name
WHERE Id=@Id";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@CreateName", model.CreateName ?? "途虎测试"),
new SqlParameter("@Url", model.Url),
new SqlParameter("@Name", model.Name),
new SqlParameter("@ActivityPageId", model.ActivityPageId),
new SqlParameter("@UpdateName", model.UpdateName ?? "途虎测试"),
new SqlParameter("@Id", model.Id),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
