collectionlistrules.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

namespace PowerEasy.SqlServerDal.Collection
{
    using PowerEasy.IDal.Collection;
    using PowerEasy.Model.Collection;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Data;

    public class CollectionListRules : ICollectionListRules
    {
        public bool Add(PowerEasy.Model.Collection.CollectionListRuleInfo collectionListRuleInfo)
        {
            string strSql = "INSERT INTO PE_CollectionListRules (ItemId,ListBeginCode,ListEndCode,LinkBeginCode,LinkEndCode,IsLinkSpecialSolution,RedirectUrl,UsePaging)VALUES(@ItemId,@ListBeginCode,@ListEndCode,@LinkBeginCode,@LinkEndCode,@IsLinkSpecialSolution,@RedirectUrl,@UsePaging)";
            return DBHelper.ExecuteSql(strSql, GetParameters(collectionListRuleInfo));
        }

        private static PowerEasy.Model.Collection.CollectionListRuleInfo CollectionListRuleInfo(NullableDataReader rdr)
        {
            PowerEasy.Model.Collection.CollectionListRuleInfo info = new PowerEasy.Model.Collection.CollectionListRuleInfo();
            info.ItemId = rdr.GetInt32("ItemId");
            info.ListBeginCode = rdr.GetString("ListBeginCode");
            info.ListEndCode = rdr.GetString("ListEndCode");
            info.LinkBeginCode = rdr.GetString("LinkBeginCode");
            info.LinkEndCode = rdr.GetString("LinkEndCode");
            info.IsLinkSpecialSolution = rdr.GetBoolean("IsLinkSpecialSolution");
            info.RedirectUrl = rdr.GetString("RedirectUrl");
            info.UsePaging = rdr.GetBoolean("UsePaging");
            return info;
        }

        public bool Delete(int id)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ItemId", DbType.Int32, id);
            string strSql = "Delete from PE_CollectionListRules  where ItemId = @ItemId";
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool Exists(int id)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ItemId", DbType.Int32, id);
            return DBHelper.ExistsSql("Select COUNT(*) From PE_CollectionListRules Where @ItemId = ItemId", cmdParams);
        }

        public PowerEasy.Model.Collection.CollectionListRuleInfo GetInfoById(int id)
        {
            Parameters cmdParams = new Parameters();
            string strCommand = "SELECT * FROM PE_CollectionListRules  WHERE ItemId=@ItemId";
            cmdParams.AddInParameter("@ItemId", DbType.Int32, id);
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                if (reader.Read())
                {
                    return CollectionListRuleInfo(reader);
                }
                return new PowerEasy.Model.Collection.CollectionListRuleInfo(true);
            }
        }

        private static Parameters GetParameters(PowerEasy.Model.Collection.CollectionListRuleInfo collectionListRuleInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@ItemId", DbType.Int32, collectionListRuleInfo.ItemId);
            parameters.AddInParameter("@ListBeginCode", DbType.String, collectionListRuleInfo.ListBeginCode);
            parameters.AddInParameter("@ListEndCode", DbType.String, collectionListRuleInfo.ListEndCode);
            parameters.AddInParameter("@LinkBeginCode", DbType.String, collectionListRuleInfo.LinkBeginCode);
            parameters.AddInParameter("@LinkEndCode", DbType.String, collectionListRuleInfo.LinkEndCode);
            parameters.AddInParameter("@IsLinkSpecialSolution", DbType.Boolean, collectionListRuleInfo.IsLinkSpecialSolution);
            parameters.AddInParameter("@RedirectUrl", DbType.String, collectionListRuleInfo.RedirectUrl);
            parameters.AddInParameter("@UsePaging", DbType.Boolean, collectionListRuleInfo.UsePaging);
            return parameters;
        }

        public bool Update(PowerEasy.Model.Collection.CollectionListRuleInfo collectionListRuleInfo)
        {
            string strSql = "UPDATE PE_CollectionListRules  SET ItemId=@ItemId,ListBeginCode=@ListBeginCode,ListEndCode = @ListEndCode,LinkBeginCode = @LinkBeginCode,LinkEndCode = @LinkEndCode,IsLinkSpecialSolution = @IsLinkSpecialSolution,RedirectUrl = @RedirectUrl, UsePaging = @UsePaging WHERE  ItemId = @ItemId";
            return DBHelper.ExecuteSql(strSql, GetParameters(collectionListRuleInfo));
        }
    }
}