public static void Add(SqlConnection connection, My_Center_News _My_Center_News)
{
var sqlParamters = new[]
{
new SqlParameter("@UserObjectID", _My_Center_News.UserObjectID ?? ""),
new SqlParameter("@News", _My_Center_News.News ?? ""),
new SqlParameter("@Type", _My_Center_News.Type ?? ""),
new SqlParameter("@Titel", _My_Center_News.Titel ?? ""),
new SqlParameter("@OrderNo", _My_Center_News.OrderNo ?? "")
};
var sql = "INSERT INTO tbl_My_Center_News(UserObjectID,News,Type,CreateTime,Title,OrderID) VALUES(@UserObjectID,@News,@Type,GETDATE(),@Titel,@OrderNo)";
SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, sqlParamters);
}
public void AddDALMy_Center_News(My_Center_News news)
{
try
{
this.handler.AddDALMy_Center_News(news);
}
catch (TuhuBizException)
{
throw;
}
catch (Exception innerEx)
{
var exception = new OprLogException(BizErrorCode.SystemError, "AddDALMy_Center_News出错", innerEx);
logger.Log(Level.Error, exception, "Error occurred in AddDALMy_Center_News.");
throw exception;
}
}
public void AddDALMy_Center_News(My_Center_News news)
{
dbManager.Execute(connection => DALMy_Center_News.Add(connection, news));
}
