collectionfieldrules.cs

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

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

    public class CollectionFieldRules : ICollectionFieldRules
    {
        public bool Add(PowerEasy.Model.Collection.CollectionFieldRuleInfo collectionFieldRuleInfo)
        {
            string strSql = "INSERT INTO PE_CollectionFieldRules(FieldRuleId,ItemId,FieldName,FieldType,RuleType,BeginCode,EndCode,PrivateFilter,FilterRuleId,UsePaging,SpecialSetting)VALUES(@FieldRuleId,@ItemId,@FieldName,@FieldType,@RuleType,@BeginCode,@EndCode,@PrivateFilter,@FilterRuleId,@UsePaging,@SpecialSetting)";
            collectionFieldRuleInfo.FieldRuleId = GetMaxId() + 1;
            return DBHelper.ExecuteSql(strSql, GetParameters(collectionFieldRuleInfo));
        }

        private static PowerEasy.Model.Collection.CollectionFieldRuleInfo CollectionFieldRuleInfo(NullableDataReader rdr)
        {
            PowerEasy.Model.Collection.CollectionFieldRuleInfo info = new PowerEasy.Model.Collection.CollectionFieldRuleInfo();
            info.FieldRuleId = rdr.GetInt32("FieldRuleId");
            info.ItemId = rdr.GetInt32("ItemId");
            info.FieldName = rdr.GetString("FieldName");
            info.FieldType = rdr.GetString("FieldType");
            info.RuleType = rdr.GetInt32("RuleType");
            info.BeginCode = rdr.GetString("BeginCode");
            info.EndCode = rdr.GetString("EndCode");
            info.PrivateFilter = rdr.GetString("PrivateFilter");
            info.FilterRuleId = rdr.GetString("FilterRuleId");
            info.UsePaging = rdr.GetBoolean("UsePaging");
            info.SpecialSetting = rdr.GetString("SpecialSetting");
            return info;
        }

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

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

        public bool Exists(int itemId, string fieldName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ItemId", DbType.Int32, itemId);
            cmdParams.AddInParameter("@FieldName", DbType.String, fieldName);
            return DBHelper.ExistsSql("Select COUNT(*) From PE_CollectionFieldRules Where @ItemId = ItemId And FieldName=@FieldName", cmdParams);
        }

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

        public IList<PowerEasy.Model.Collection.CollectionFieldRuleInfo> GetList(int itemId)
        {
            string strCommand = "select * from PE_CollectionFieldRules where ItemID = @ItemID";
            IList<PowerEasy.Model.Collection.CollectionFieldRuleInfo> list = new List<PowerEasy.Model.Collection.CollectionFieldRuleInfo>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ItemID", DbType.Int32, itemId);
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(CollectionFieldRuleInfo(reader));
                }
            }
            return list;
        }

        private static int GetMaxId()
        {
            return DBHelper.GetMaxId("PE_CollectionFieldRules", "FieldRuleId");
        }

        private static Parameters GetParameters(PowerEasy.Model.Collection.CollectionFieldRuleInfo collectionFieldRuleInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@FieldRuleId", DbType.Int32, collectionFieldRuleInfo.FieldRuleId);
            parameters.AddInParameter("@ItemId", DbType.Int32, collectionFieldRuleInfo.ItemId);
            parameters.AddInParameter("@FieldName", DbType.String, collectionFieldRuleInfo.FieldName);
            parameters.AddInParameter("@FieldType", DbType.String, collectionFieldRuleInfo.FieldType);
            parameters.AddInParameter("@RuleType", DbType.Int32, collectionFieldRuleInfo.RuleType);
            parameters.AddInParameter("@BeginCode", DbType.String, collectionFieldRuleInfo.BeginCode);
            parameters.AddInParameter("@EndCode", DbType.String, collectionFieldRuleInfo.EndCode);
            parameters.AddInParameter("@PrivateFilter", DbType.String, collectionFieldRuleInfo.PrivateFilter);
            parameters.AddInParameter("@FilterRuleId", DbType.String, collectionFieldRuleInfo.FilterRuleId);
            parameters.AddInParameter("@UsePaging", DbType.Boolean, collectionFieldRuleInfo.UsePaging);
            parameters.AddInParameter("@SpecialSetting", DbType.String, collectionFieldRuleInfo.SpecialSetting);
            return parameters;
        }

        public bool Update(PowerEasy.Model.Collection.CollectionFieldRuleInfo collectionFieldRuleInfo)
        {
            string strSql = "UPDATE PE_CollectionFieldRules SET  ItemId=@ItemId,FieldName = @FieldName,FieldType = @FieldType,RuleType=@RuleType,BeginCode=@BeginCode,EndCode = @EndCode,PrivateFilter = @PrivateFilter,FilterRuleId = @FilterRuleId,UsePaging = @UsePaging, SpecialSetting= @SpecialSetting WHERE  ItemId=@ItemId And FieldName = @FieldName";
            return DBHelper.ExecuteSql(strSql, GetParameters(collectionFieldRuleInfo));
        }
    }
}