product.cs

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

                database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str3 + temp + "P." + searchType + " like '%" + keyword + "%'");
            }
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            IList<ProductDetailInfo> list = new List<ProductDetailInfo>();
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    ProductDetailInfo productInfo = new ProductDetailInfo();
                    ProductFromrdr<ProductDetailInfo>(reader, productInfo);
                    productInfo.EliteLevel = reader.GetInt32("EliteLevel");
                    productInfo.UpdateTime = new DateTime?(reader.GetDateTime("UpdateTime"));
                    productInfo.CreateTime = reader.IsDBNull("CreateTime") ? productInfo.UpdateTime : new DateTime?(reader.GetDateTime("CreateTime"));
                    productInfo.NodeName = reader.GetString("NodeName");
                    productInfo.NodeId = reader.GetInt32("NodeId");
                    productInfo.GeneralId = reader.GetInt32("GeneralId");
                    productInfo.ModelId = reader.GetInt32("ModelId");
                    productInfo.LinkType = reader.GetInt32("LinkType");
                    list.Add(productInfo);
                }
            }
            this.m_TotalOfAllProducts = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public IList<string> GetShopTableNames()
        {
            IList<string> list = new List<string>();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("select TableName from PE_Model where isEshop=1 and Disabled=0"))
            {
                while (reader.Read())
                {
                    list.Add(reader.GetString(0));
                }
            }
            return list;
        }

        private static void GetSortParameter(int listType, out string sortColumn, out string sorts)
        {
            sortColumn = "M.GeneralId";
            sorts = "DESC";
            switch (listType)
            {
                case -2:
                    sortColumn = "M.GeneralId";
                    sorts = "ASC";
                    return;

                case -1:
                case 0:
                    break;

                case 1:
                    sortColumn = "M.EliteLevel";
                    sorts = "DESC";
                    return;

                case 2:
                    sortColumn = "M.EliteLevel";
                    sorts = "ASC";
                    return;

                case 3:
                    sortColumn = "M.Priority";
                    sorts = "DESC";
                    return;

                case 4:
                    sortColumn = "M.Priority";
                    sorts = "ASC";
                    return;

                case 5:
                    sortColumn = "M.DayHits";
                    sorts = "DESC";
                    return;

                case 6:
                    sortColumn = "M.DayHits";
                    sorts = "ASC";
                    return;

                case 7:
                    sortColumn = "M.WeekHits";
                    sorts = "DESC";
                    return;

                case 8:
                    sortColumn = "M.WeekHits";
                    sorts = "ASC";
                    return;

                case 9:
                    sortColumn = "M.MonthHits";
                    sorts = "DESC";
                    return;

                case 10:
                    sortColumn = "M.MonthHits";
                    sorts = "ASC";
                    return;

                case 11:
                    sortColumn = "M.Hits";
                    sorts = "DESC";
                    return;

                case 12:
                    sortColumn = "M.Hits";
                    sorts = "ASC";
                    break;

                default:
                    return;
            }
        }

        private static string GetSpeedSearchFilter(string keyword, string filter, string temp)
        {
            switch (DataConverter.CLng(keyword))
            {
                case 20:
                    return filter;

                case 0x15:
                    filter = filter + temp + "P.EnableSale =1 ";
                    return filter;

                case 0x16:
                    filter = filter + temp + "P.EnableSale =0 ";
                    return filter;

                case 0x17:
                    filter = filter + temp + "P.ProductType =0 ";
                    return filter;

                case 0x18:
                    filter = filter + temp + "P.ProductType =3 ";
                    return filter;

                case 0x19:
                    filter = filter + temp + "P.IsHot =1 ";
                    return filter;

                case 0x1a:
                    filter = filter + temp + "P.IsNew =1 ";
                    return filter;

                case 0x1b:
                    filter = filter + temp + "P.IsBest =1 ";
                    return filter;

                case 0x1c:
                    filter = filter + temp + "P.SalePromotionType>0 ";
                    return filter;

                case 0x1d:
                    filter = filter + temp + "P.Stocks<=P.AlarmNum ";
                    return filter;

                case 30:
                    filter = filter + temp + "P.Stocks<=P.AlarmNum+P.OrderNum ";
                    return filter;

                case 0x1f:
                    filter = filter + temp + "P.Stocks<=0 ";
                    return filter;

                case 0x20:
                    filter = filter + temp + "P.EnableWholesale=1 ";
                    return filter;
            }
            return filter;
        }

        public int GetTotalOfAllProducts()
        {
            return this.m_TotalOfAllProducts;
        }

        public int GetTotalOfProducts()
        {
            return this.m_TotalOfProducts;
        }

        private static void ProductFromrdr<T>(NullableDataReader rdr, T productInfo) where T: ProductInfo
        {
            productInfo.ProductId = rdr.GetInt32("ProductId");
            productInfo.TableName = rdr.GetString("TableName");
            productInfo.ProductName = rdr.GetString("ProductName");
            productInfo.ProductType = (ProductType) rdr.GetInt32("ProductType");
            productInfo.ProductPic = rdr.GetString("ProductPic");
            productInfo.ProductThumb = rdr.GetString("ProductThumb");
            productInfo.Unit = rdr.GetString("Unit");
            productInfo.ProductNum = rdr.GetString("ProductNum");
            productInfo.ServiceTermUnit = (ServiceTermUnit) rdr.GetInt32("ServiceTermUnit");
            productInfo.ServiceTerm = rdr.GetInt32("ServiceTerm");
            productInfo.PriceInfo.Price = rdr.GetDecimal("Price");
            productInfo.PriceMarket = rdr.GetDecimal("Price_Market");
            productInfo.PriceInfo.PriceMember = rdr.GetDecimal("Price_Member");
            productInfo.PriceInfo.PriceAgent = rdr.GetDecimal("Price_Agent");
            productInfo.EnableWholesale = rdr.GetBoolean("EnableWholesale");
            productInfo.PriceInfo.PriceWholesale1 = rdr.GetDecimal("Price_Wholesale1");
            productInfo.PriceInfo.PriceWholesale2 = rdr.GetDecimal("Price_Wholesale2");
            productInfo.PriceInfo.PriceWholesale3 = rdr.GetDecimal("Price_Wholesale3");
            productInfo.PriceInfo.NumberWholesale1 = rdr.GetInt32("Number_Wholesale1");
            productInfo.PriceInfo.NumberWholesale2 = rdr.GetInt32("Number_Wholesale2");
            productInfo.PriceInfo.NumberWholesale3 = rdr.GetInt32("Number_Wholesale3");
            productInfo.PresentId = rdr.GetInt32("PresentID");
            productInfo.PresentNumber = rdr.GetInt32("PresentNumber");
            productInfo.PresentPoint = rdr.GetInt32("PresentPoint");
            productInfo.PresentExp = rdr.GetInt32("PresentExp");
            productInfo.PresentMoney = rdr.GetDecimal("PresentMoney");
            productInfo.StocksProject = (StocksProject) rdr.GetInt32("StocksProject");
            productInfo.SalePromotionType = rdr.GetInt32("SalePromotionType");
            productInfo.MinNumber = rdr.GetInt32("MinNumber");
            productInfo.Discount = rdr.GetDouble("Discount");
            productInfo.IncludeTax = (TaxRateType) rdr.GetInt32("IncludeTax");
            productInfo.TaxRate = rdr.GetDouble("TaxRate");
            productInfo.Properties = rdr.GetString("Properties");
            productInfo.Weight = rdr.GetDouble("Weight");
            productInfo.LimitNum = rdr.GetInt32("LimitNum");
            productInfo.EnableSingleSell = rdr.GetBoolean("EnableSingleSell");
            productInfo.DependentProducts = rdr.GetString("DependentProducts");
            productInfo.ProductKind = (ProductKind) rdr.GetInt32("ProductKind");
            productInfo.OrderNum = rdr.GetInt32("OrderNum");
            productInfo.Stocks = rdr.GetInt32("Stocks");
            productInfo.EnableSale = rdr.GetBoolean("EnableSale");
            productInfo.EnableBuyWhenOutofstock = rdr.GetBoolean("EnableBuyWhenOutofstock");
            productInfo.BarCode = rdr.GetString("BarCode");
            productInfo.ProductExplain = rdr.GetString("ProductExplain");
            productInfo.ProducerName = rdr.GetString("ProducerName");
            productInfo.TrademarkName = rdr.GetString("TrademarkName");
            productInfo.Keyword = rdr.GetString("Keyword");
            productInfo.Stars = rdr.GetInt32("Stars");
            productInfo.ProductIntro = rdr.GetString("ProductIntro");
            productInfo.IsNew = rdr.GetBoolean("IsNew");
            productInfo.IsHot = rdr.GetBoolean("IsHot");
            productInfo.IsBest = rdr.GetBoolean("IsBest");
            productInfo.ProductCharacter = (ProductCharacter) rdr.GetInt32("ProductCharacter");
            productInfo.DownloadUrl = rdr.GetString("DownloadUrl");
            productInfo.Remark = rdr.GetString("Remark");
            productInfo.AlarmNum = rdr.GetInt32("AlarmNum");
            productInfo.BuyTimes = rdr.GetInt32("BuyTimes");
        }

        public bool SetBest(string generalIdList, bool enableBest)
        {
            string strSql = "Update PE_CommonProduct Set IsBest=@enableBest Where ProductID in (" + generalIdList + ")";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@enableBest", DbType.Boolean, enableBest);
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool SetElite(string generalIdList, int eliteLevel)
        {
            string strSql = "UPDATE PE_CommonModel SET EliteLevel=@EliteLevel where GeneralId IN(" + generalIdList + ")";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@EliteLevel", DbType.Int32, eliteLevel);
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool SetHot(string generalIdList, bool enableHot)
        {
            string strSql = "Update PE_CommonProduct Set IsHot=@enableHot where ProductID IN (" + generalIdList + ")";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@enableHot", DbType.Boolean, enableHot);
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool SetNew(string generalIdList, bool enableNew)
        {
            string strSql = "Update PE_CommonProduct Set IsNew=@enableNew Where ProductID in (" + generalIdList + ")";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@enableNew", DbType.Boolean, enableNew);
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool SetSale(string generalIdList, bool enableSale)
        {
            string strSql = "Update PE_CommonProduct Set EnableSale=@EnableSale Where ProductID IN (" + generalIdList + ")";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@EnableSale", DbType.Boolean, enableSale);
            int num = 0x63;
            if (!enableSale)
            {
                num = 90;
            }
            if (DBHelper.ExecuteSql(strSql, cmdParams))
            {
                DBHelper.ExecuteSql("update PE_CommonModel set Status = @Status Where GeneralID in (" + generalIdList + ")", new Parameters("@Status", DbType.Int32, num));
            }
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }

        public bool Update(ProductInfo info, string tableName)
        {
            StringBuilder builder = new StringBuilder(0x80);
            builder.Append("UPDATE ");
            builder.Append(tableName);
            builder.Append(" SET ");
            DataRow[] dataRows = Query.GetDataRows(info.Fields, "FieldLevel=1");
            if (dataRows.Length > 0)
            {
                builder.Append(Query.GetUpdateFieldList(dataRows));
                builder.Append(" WHERE ID=" + info.ProductId.ToString());
                return DBHelper.ExecuteSql(builder.ToString(), GetParameters(info));
            }
            return false;
        }
    }
}