public bool Add(CollectionHistoryInfo collectionHistoryInfo) { string strSql = "INSERT INTO PE_CollectionHistory(HistoryId, ItemId, ModelID, NodeID, GeneralID, Title, CollectionTime, Result, NewsUrl) VALUES (@HistoryID, @ItemId, @ModelID, @NodeID, @GeneralID, @Title, @CollectionTime, @Result, @NewsUrl)"; collectionHistoryInfo.HistoryId = this.GetMaxId() + 1; return(DBHelper.ExecuteSql(strSql, GetParameters(collectionHistoryInfo))); }
private static Parameters GetParameters(CollectionHistoryInfo collectionHistoryInfo) { Parameters parameters = new Parameters(); parameters.AddInParameter("@HistoryID", DbType.Int32, collectionHistoryInfo.HistoryId); parameters.AddInParameter("@ItemId", DbType.Int32, collectionHistoryInfo.ItemId); parameters.AddInParameter("@ModelID", DbType.Int32, collectionHistoryInfo.ModelId); parameters.AddInParameter("@NodeID", DbType.Int32, collectionHistoryInfo.NodeId); parameters.AddInParameter("@GeneralID", DbType.Int32, collectionHistoryInfo.GeneralId); parameters.AddInParameter("@Title", DbType.String, collectionHistoryInfo.Title); parameters.AddInParameter("@CollectionTime", DbType.DateTime, collectionHistoryInfo.CollectionTime); parameters.AddInParameter("@Result", DbType.Boolean, collectionHistoryInfo.Result); parameters.AddInParameter("@NewsUrl", DbType.String, collectionHistoryInfo.NewsUrl); return(parameters); }
public static bool Add(CollectionHistoryInfo collectionHistoryInfo) { return(dal.Add(collectionHistoryInfo)); }