public DataTable GetProductList(int CategoryID, int PageIndex, int BrandID, decimal[] PriceRange, int OrderType, Hashtable Parameters, out int RecordCount, out int PageCount)
        {
            string where = String.Empty;

            int i = 0;

            if (Parameters != null)
            {
                foreach (string key in Parameters.Keys)
                {
                    CategoryParaModel para = new CategoryParaModelBll().GetModel(Convert.ToInt32(key), CategoryID);
                    if (i == Parameters.Count - 1)
                    {
                        where += String.Format(" and (pdproductpara.paraid = {0} and pdproductpara.paravalue like '%{1}%') ", key, para.ParaValues.Split(',')[Convert.ToInt32(Parameters[key])]);
                    }
                    else
                    {
                        where += String.Format(" and (pdproductpara.paraid = {0} and pdproductpara.paravalue like '%{1}%') ", key, para.ParaValues.Split(',')[Convert.ToInt32(Parameters[key])]);
                    }
                    i++;
                }
            }
            if (BrandID != 0)
            {
                where += " and pdproduct.brandid=" + BrandID;
            }
            if (PriceRange != null && PriceRange.Length == 2)
            {
                where += String.Format(" and pdproduct.merchantprice >= {0} and pdproduct.merchantprice <= {1}", PriceRange[0], PriceRange[1] + 0.99M);
            }

            string CategoryPath = Convert.ToString(GetCategoryInfo(CategoryID)["catepath"]);

            where += String.Format(" and pdproduct.catepath like '{0}%'", CategoryPath);
            where += " and pdproduct.status = 1";

            SearchPageInfo pageInfo = new SearchPageInfo();

            pageInfo.TableName     = "pdproductpara";
            pageInfo.PriKeyName    = "productid";
            pageInfo.FieldNames    = "pdproduct.productid,paraid,paravalue,productname,pdcategory.cateid,pdcategory.catepath,tradeprice,merchantprice,reduceprice,stock,smallimage,mediumimage,largeimage,keywords,brief,pageview,inserttime,changetime,pdproduct.status,score";
            pageInfo.TotalFieldStr = "";
            pageInfo.PageSize      = Config.ListPageSize;
            pageInfo.PageIndex     = PageIndex;
            pageInfo.OrderType     = GetOrderString(OrderType);
            pageInfo.StrWhere      = "1=1 " + where;
            pageInfo.StrJoin       = " inner join pdproduct on pdproduct.productid=pdproductpara.productid inner join pdcategory on pdproduct.cateid=pdcategory.cateid ";

            DataTable dt = CommDataHelper.GetDataFromMultiTablesByPage(pageInfo).Tables[0];

            RecordCount = pageInfo.TotalItem;
            PageCount   = pageInfo.TotalPage;

            return(dt);
        }