public static bool InsertActivityPageRegionConfig(ActivityPageRegionConfig model, ref int id)
{
const string sql = @" INSERT INTO Configuration..[SE_ActivityPageRegionConfig]
(
[UrlId]
,[Province]
,[City]
,[CreateTime]
,[CreateName]
)
VALUES (
@UrlId
,@Province
,@City
,GETDATE()
,@CreateName
)SELECT @@IDENTITY";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@UrlId", model.UrlId),
new SqlParameter("@Province", model.Province),
new SqlParameter("@City", model.City),
new SqlParameter("@CreateName", model.CreateName ?? "途虎测试")
};
id = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParameter));
return(id > 0);
}
public bool InsertActivityPageRegionConfig(ActivityPageRegionConfig model)
{
try
{
int outid = 0;
return(DALRegionActivityPageConfig.InsertActivityPageRegionConfig(model, ref outid));
}
catch (Exception ex)
{
Logger.Log(Level.Error, ex, "InsertActivityPageRegionConfig");
throw ex;
}
}
