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