special.cs

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

namespace PowerEasy.SqlServerDal.Contents
{
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using PowerEasy.Common;
    using PowerEasy.Enumerations;
    using PowerEasy.IDal.Contents;
    using PowerEasy.Model.Contents;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class Special : ISpecial
    {
        private int m_TotalOfSpecial;

        public bool AddSpecial(SpecialInfo specialInfo)
        {
            Parameters parms = new Parameters();
            specialInfo.SpecialId = GetMaxSpecialId() + 1;
            specialInfo.OrderId = GetMaxSpecialOrderId(specialInfo.SpecialCategoryId) + 1;
            GetSpecialParameters(specialInfo, parms);
            string strSql = "INSERT INTO PE_Specials(SpecialID,SpecialName,SpecialCategoryID,SpecialDir,SpecialIdentifier,SpecialPic,SpecialTips,SpecialTemplatePath,SearchTemplatePath,IsElite,OrderId,OpenType,Description,IsCreateListPage,ListPageSavePathType,ListPagePostfix,Custom_Content)VALUES(@SpecialID,@SpecialName,@SpecialCategoryId,@SpecialDir,@SpecialIdentifier,@SpecialPic,@SpecialTips,@SpecialTemplatePath,@SearchTemplatePath,@IsElite,@OrderId,@OpenType,@Description,@IsCreateListPage,@ListPageSavePathType,@ListPagePostfix,@CustomContent)";
            return DBHelper.ExecuteSql(strSql, parms);
        }

        public bool AddSpecialCategory(SpecialCategoryInfo specialCategoryInfo)
        {
            Parameters parms = new Parameters();
            specialCategoryInfo.SpecialCategoryId = GetMaxSpecialCategoryId() + 1;
            specialCategoryInfo.OrderId = GetMaxSpecialCategoryOrderId() + 1;
            GetSpecialCategoryParameters(specialCategoryInfo, parms);
            string strSql = "INSERT INTO PE_SpecialCategory(SpecialCategoryID,SpecialCategoryName,SpecialCategoryDir,SpecialTemplatePath,SearchTemplatePath,OrderId,OpenType,PagePostfix,IsCreateHtml,Description)VALUES(@SpecialCategoryID,@SpecialCategoryName,@SpecialCategoryDir,@SpecialTemplatePath,@SearchTemplatePath,@OrderId,@OpenType,@PagePostfix,@IsCreateHtml,@Description)";
            return DBHelper.ExecuteSql(strSql, parms);
        }

        public bool AddToSpecialInfos(int specialId, int generalId)
        {
            int num = GetMaxSpecialInfoId() + 1;
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialInfoId", DbType.Int32, num);
            cmdParams.AddInParameter("@SpecialId", DbType.Int32, specialId);
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            string strSql = "INSERT INTO PE_SpecialInfos(SpecialInfoID,SpecialID,GeneralId)VALUES(@SpecialInfoId,@SpecialId,@GeneralId)";
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool DeleteSpecial(int specialId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialId", DbType.Int32, specialId);
            string strSql = "DELETE FROM PE_Specials WHERE SpecialID=@SpecialId";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialCategoryById(int specialCategoryId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryId", DbType.Int32, specialCategoryId);
            string strSql = "DELETE FROM PE_SpecialCategory WHERE SpecialCategoryID=@SpecialCategoryId";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialCategoryIdInSpecials(int specialCategoryId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryId", DbType.Int32, specialCategoryId);
            string strSql = "DELETE FROM PE_Specials WHERE SpecialCategoryID=@SpecialCategoryId";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialIdInSpecialInfos(string specialIds)
        {
            string strSql = "DELETE FROM PE_SpecialInfos WHERE SpecialID IN(" + specialIds + ")";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialInfoById(string specialInfoIds)
        {
            string strSql = "DELETE FROM PE_SpecialInfos WHERE SpecialInfoID IN(" + specialInfoIds + ")";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialInfoById(string specialInfoIds, int specialId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialId", DbType.Int32, specialId);
            string strSql = "DELETE FROM PE_SpecialInfos WHERE SpecialID!=@SpecialId AND SpecialInfoID IN(" + specialInfoIds + ")";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialInfoBySpecialId(int specialId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialId", DbType.Int32, specialId);
            string strSql = "DELETE FROM PE_SpecialInfos WHERE SpecialID=@SpecialId";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool DeleteSpecialInfos(int generalId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            string strSql = "DELETE FROM PE_SpecialInfos WHERE GeneralId=@GeneralId";
            try
            {
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                return true;
            }
            catch
            {
                return false;
            }
        }

        public bool ExistInSpecialInfos(int generalId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            string strSql = "SELECT COUNT(*) FROM PE_SpecialInfos WHERE GeneralId=@GeneralId";
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool ExistInSpecialInfos(int specialId, int generalId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialId", DbType.Int32, specialId);
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            string strSql = "SELECT COUNT(*) FROM PE_SpecialInfos WHERE SpecialID=@SpecialId AND GeneralId=@GeneralId";
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool ExistsSpecialCategoryIdInSpecials(int specialCategoryId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryId", DbType.Int32, specialCategoryId);
            string strSql = "SELECT COUNT(*) FROM PE_Specials WHERE SpecialCategoryID=@SpecialCategoryId";
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool ExistsSpecialCategoryName(string specialCategoryName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryName", DbType.String, specialCategoryName);
            string strSql = "SELECT COUNT(*) FROM PE_SpecialCategory WHERE SpecialCategoryName=@SpecialCategoryName";
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool ExistsSpecialDir(string specialDir)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialDir", DbType.String, specialDir);
            string strSql = "SELECT COUNT(*) FROM PE_Specials WHERE SpecialDir=@SpecialDir";
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool ExistsSpecialName(string specialName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialName", DbType.String, specialName);
            string strSql = "SELECT COUNT(*) FROM PE_Specials WHERE SpecialName=@SpecialName";
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public int GetCountSpecial(int specialCategoryId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryId", DbType.Int32, specialCategoryId);
            string strSql = "SELECT COUNT(*) FROM PE_Specials";
            if (specialCategoryId > 0)
            {
                strSql = strSql + " WHERE SpecialCategoryID=@SpecialCategoryId";
            }
            return DataConverter.CLng(DBHelper.ExecuteScalarSql(strSql, cmdParams));
        }

        public string GetGeneralIdBySpecialId(string specialId)
        {
            StringBuilder builder = new StringBuilder();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT GeneralId FROM PE_SpecialInfos WHERE SpecialID IN(" + specialId + ")"))
            {
                while (reader.Read())
                {
                    builder.Append(reader.GetInt32("GeneralId"));
                    builder.Append(",");
                }
            }
            return builder.ToString().TrimEnd(new char[] { ',' });
        }

        public string GetGeneralIdBySpecialInfoId(string specialInfoId)
        {
            StringBuilder builder = new StringBuilder();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT GeneralId FROM PE_SpecialInfos WHERE SpecialInfoId IN(" + specialInfoId + ")"))
            {
                while (reader.Read())
                {
                    builder.Append(reader.GetInt32("GeneralId"));
                    builder.Append(",");
                }
            }
            return builder.ToString().TrimEnd(new char[] { ',' });
        }

        private static int GetMaxSpecialCategoryId()
        {
            return DBHelper.GetMaxId("PE_SpecialCategory", "SpecialCategoryID");
        }

        private static int GetMaxSpecialCategoryOrderId()
        {
            return DBHelper.GetMaxId("PE_SpecialCategory", "OrderId");
        }

        private static int GetMaxSpecialId()
        {
            return DBHelper.GetMaxId("PE_Specials", "SpecialID");
        }

        private static int GetMaxSpecialInfoId()
        {
            return DBHelper.GetMaxId("PE_SpecialInfos", "SpecialInfoID");
        }

        private static int GetMaxSpecialOrderId(int specialCategoryId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryId", DbType.Int32, specialCategoryId);
            string strSql = "SELECT MAX(OrderId) FROM PE_Specials WHERE SpecialCategoryID=@SpecialCategoryId";
            return DataConverter.CLng(DBHelper.ExecuteScalarSql(strSql, cmdParams));
        }

        public SpecialCategoryInfo GetSpecialCategoryInfoById(int specialCategoryId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialCategoryId", DbType.Int32, specialCategoryId);
            string strCommand = "SELECT * FROM PE_SpecialCategory WHERE SpecialCategoryID =@SpecialCategoryId";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                if (reader.Read())
                {
                    return SpecialCategoryInfoFromrdr(reader);
                }
                return new SpecialCategoryInfo(true);
            }
        }

        public IList<SpecialCategoryInfo> GetSpecialCategoryList()
        {
            IList<SpecialCategoryInfo> list = new List<SpecialCategoryInfo>();
            string strCommand = "SELECT * FROM PE_SpecialCategory ORDER BY OrderId,SpecialCategoryID DESC";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, null))
            {
                while (reader.Read())
                {
                    list.Add(SpecialCategoryInfoFromrdr(reader));
                }
            }
            return list;
        }