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