public bool Add(EasyOne.Model.Collection.CollectionItemInfo collectionItemInfo) { string strSql = "INSERT INTO PE_CollectionItem (ItemId, ItemName, UrlName, CodeType, Url, Intro, NodeId, InfoNodeId, ModelId, SpecialId, OrderType, MaxNum, Detection, AutoCreateHtml) VALUES (@ItemId, @ItemName, @UrlName, @CodeType, @Url, @Intro, @NodeId, @InfoNodeId, @ModelId, @SpecialId, @OrderType, @MaxNum, @Detection, @AutoCreateHtml)"; collectionItemInfo.ItemId = this.GetMaxId() + 1; return(DBHelper.ExecuteSql(strSql, GetParameters(collectionItemInfo))); }
private static EasyOne.Model.Collection.CollectionItemInfo CollectionItemInfo(NullableDataReader rdr) { EasyOne.Model.Collection.CollectionItemInfo info = new EasyOne.Model.Collection.CollectionItemInfo(); info.ItemId = rdr.GetInt32("ItemId"); info.ItemName = rdr.GetString("ItemName"); info.UrlName = rdr.GetString("UrlName"); info.CodeType = rdr.GetString("CodeType"); info.Url = rdr.GetString("Url"); info.Intro = rdr.GetString("Intro"); info.NodeId = rdr.GetInt32("NodeId"); info.InfoNodeId = rdr.GetString("InfoNodeId"); info.ModelId = rdr.GetInt32("ModelId"); info.SpecialId = rdr.GetString("SpecialId"); info.OrderType = rdr.GetInt32("OrderType"); info.MaxNum = rdr.GetInt32("MaxNum"); info.NewsCollecDate = rdr.GetDateTime("NewsCollecDate"); info.AutoCreateHtml = rdr.GetBoolean("AutoCreateHtml"); info.Detection = rdr.GetBoolean("Detection"); return(info); }
private static Parameters GetParameters(EasyOne.Model.Collection.CollectionItemInfo collectionItemInfo) { Parameters parameters = new Parameters(); parameters.AddInParameter("@ItemId", DbType.Int32, collectionItemInfo.ItemId); parameters.AddInParameter("@ItemName", DbType.String, collectionItemInfo.ItemName); parameters.AddInParameter("@UrlName", DbType.String, collectionItemInfo.UrlName); parameters.AddInParameter("@CodeType", DbType.String, collectionItemInfo.CodeType); parameters.AddInParameter("@Url", DbType.String, collectionItemInfo.Url); parameters.AddInParameter("@Intro", DbType.String, collectionItemInfo.Intro); parameters.AddInParameter("@NodeId", DbType.Int32, collectionItemInfo.NodeId); parameters.AddInParameter("@InfoNodeId", DbType.String, collectionItemInfo.InfoNodeId); parameters.AddInParameter("@ModelId", DbType.Int32, collectionItemInfo.ModelId); parameters.AddInParameter("SpecialId", DbType.String, collectionItemInfo.SpecialId); parameters.AddInParameter("@OrderType", DbType.Int32, collectionItemInfo.OrderType); parameters.AddInParameter("@MaxNum", DbType.Int32, collectionItemInfo.MaxNum); parameters.AddInParameter("@Detection", DbType.Boolean, collectionItemInfo.Detection); parameters.AddInParameter("@AutoCreateHtml", DbType.Boolean, collectionItemInfo.AutoCreateHtml); return(parameters); }
public bool Update(EasyOne.Model.Collection.CollectionItemInfo collectionItemInfo) { string strSql = "UPDATE PE_CollectionItem SET ItemId = @ItemId, ItemName = @ItemName, UrlName = @UrlName, CodeType = @CodeType, Url = @Url, Intro = @Intro, NodeId = @NodeId, InfoNodeId = @InfoNodeId, ModelId = @ModelId, SpecialId = @SpecialId, OrderType = @OrderType, MaxNum = @MaxNum, Detection = @Detection, AutoCreateHtml = @AutoCreateHtml WHERE ItemId = @ItemId"; return(DBHelper.ExecuteSql(strSql, GetParameters(collectionItemInfo))); }