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