Beispiel #1
0
 public static ProductCategoryBll GetInstance()
 {
     if (instance == null)
     {
         instance = new ProductCategoryBll();
     }
     return(instance);
 }
Beispiel #2
0
        /// <summary>
        /// 添加溢出值   后台修改 比例
        /// </summary>
        /// <param name="ProductId"></param>
        public void UpdateInventoryOver(object oid)
        {
            int      ProductId             = (int)oid;
            DateTime dt                    = DateTime.Now.Date;
            var      InventoryHistory      = InventoryOverHistoryBLL.GetInstance().TableNoTracking().Where(o => o.CreTime >= dt).ToList();
            var      store                 = StoreBll.GetInstance().TableNoTracking().Where(o => o.State == (int)StoreState.线中).ToList();
            var      ProductCategory       = ProductCategoryBll.GetInstance().TableNoTracking().ToList();
            var      ProductCategoryidlist = ProductCategory.Select(o => o.Id).ToList();

            ProductCategoryidlist.Add(0);
            var Productlist   = ProductBll.GetInstance().TableNoTracking().Where(o => o.Id == ProductId && o.State == ProductStateEnum.架).ToList();
            var Productidlist = Productlist.Select(o => o.Id).ToList();

            Productidlist.Add(0);
            var StockSettinglist = StockSettingBLL.GetInstance().TableNoTracking().Where(o => Productidlist.Contains(o.ProductId)).ToList();

            if (store != null && store.Count > 0)
            {
                foreach (var itemstore in store)
                {
                    if (ProductCategory != null && ProductCategory.Count > 0)
                    {
                        foreach (var itemProductCategory in ProductCategory)
                        {
                            if (InventoryHistory != null && InventoryHistory.Count > 0)
                            {
                                foreach (var objInventoryHistory in InventoryHistory)
                                {
                                    ////    //店铺   分类下  当天的总库存
                                    List <StockOutInView> StockOutInViewlist = InventoryBLL.GetInstance().GetStockTotal(itemstore.Id, itemProductCategory.Id, objInventoryHistory.CreTime);
                                    List <Product>        ProductList        = Productlist.Where(o => o.ProductCategoryId == itemProductCategory.Id).ToList();
                                    #region MyRegion
                                    if (ProductList != null)
                                    {
                                        foreach (var item in ProductList)
                                        {
                                            string sql = " update  [InventoryOver] set     ";
                                            int    i   = 1;
                                            #region 循环
                                            string tstr = "";
                                            while (i < 49)
                                            {
                                                //分类下
                                                var EmployeeProductViewModellistitem = new List <StockOutInView>();
                                                #region MyRegion
                                                if (i == 1)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time1 != null).ToList();
                                                }
                                                else
                                                if (i == 2)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time2 != null).ToList();
                                                }
                                                else
                                                if (i == 3)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time3 != null).ToList();
                                                }

                                                else
                                                if (i == 4)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time4 != null).ToList();
                                                }

                                                else
                                                if (i == 5)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time5 != null).ToList();
                                                }

                                                else
                                                if (i == 6)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time6 != null).ToList();
                                                }
                                                else
                                                if (i == 7)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time7 != null).ToList();
                                                }
                                                else
                                                if (i == 8)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time8 != null).ToList();
                                                }


                                                else
                                                if (i == 9)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time9 != null).ToList();
                                                }


                                                else
                                                if (i == 10)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time10 != null).ToList();
                                                }


                                                else
                                                if (i == 11)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time11 != null).ToList();
                                                }

                                                else
                                                if (i == 12)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time12 != null).ToList();
                                                }


                                                else
                                                if (i == 13)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time13 != null).ToList();
                                                }



                                                else
                                                if (i == 14)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time14 != null).ToList();
                                                }


                                                else
                                                if (i == 15)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time15 != null).ToList();
                                                }


                                                else
                                                if (i == 16)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time16 != null).ToList();
                                                }

                                                else
                                                if (i == 17)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time17 != null).ToList();
                                                }

                                                else
                                                if (i == 18)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time18 != null).ToList();
                                                }

                                                else
                                                if (i == 19)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time19 != null).ToList();
                                                }

                                                else
                                                if (i == 20)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time20 != null).ToList();
                                                }

                                                else
                                                if (i == 21)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time21 != null).ToList();
                                                }


                                                else
                                                if (i == 22)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time22 != null).ToList();
                                                }


                                                else
                                                if (i == 23)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time23 != null).ToList();
                                                }

                                                else
                                                if (i == 24)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time24 != null).ToList();
                                                }


                                                else
                                                if (i == 25)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time25 != null).ToList();
                                                }


                                                else
                                                if (i == 26)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time26 != null).ToList();
                                                }

                                                else
                                                if (i == 27)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time27 != null).ToList();
                                                }



                                                else
                                                if (i == 28)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time28 != null).ToList();
                                                }


                                                else
                                                if (i == 29)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time29 != null).ToList();
                                                }

                                                else
                                                if (i == 30)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time30 != null).ToList();
                                                }


                                                else
                                                if (i == 31)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time31 != null).ToList();
                                                }



                                                else
                                                if (i == 32)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time32 != null).ToList();
                                                }


                                                else
                                                if (i == 33)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time33 != null).ToList();
                                                }

                                                else
                                                if (i == 34)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time34 != null).ToList();
                                                }

                                                else
                                                if (i == 35)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time35 != null).ToList();
                                                }

                                                else
                                                if (i == 36)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time36 != null).ToList();
                                                }


                                                else
                                                if (i == 37)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time37 != null).ToList();
                                                }
                                                else
                                                if (i == 38)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time38 != null).ToList();
                                                }
                                                else
                                                if (i == 39)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time39 != null).ToList();
                                                }
                                                else
                                                if (i == 40)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time40 != null).ToList();
                                                }

                                                else
                                                if (i == 41)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time41 != null).ToList();
                                                }

                                                else
                                                if (i == 42)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time42 != null).ToList();
                                                }
                                                else
                                                if (i == 43)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time43 != null).ToList();
                                                }
                                                else
                                                if (i == 44)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time44 != null).ToList();
                                                }

                                                else
                                                if (i == 45)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time45 != null).ToList();
                                                }


                                                else
                                                if (i == 46)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time46 != null).ToList();
                                                }

                                                else
                                                if (i == 47)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time47 != null).ToList();
                                                }

                                                else
                                                if (i == 48)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time48 != null).ToList();
                                                }
                                                #endregion
                                                //产品下的总库存
                                                int TotalInventory = EmployeeProductViewModellistitem.Select(o => o.EmployeeId).Distinct().Count();
                                                //百分比计算
                                                var StockSetting = StockSettinglist.Where(o => o.ProductId == item.Id).FirstOrDefault();
                                                if (StockSetting != null)
                                                {
                                                    TotalInventory = ZConvert.StrToInt(TotalInventory * ((StockSetting.OverflowValue - 100) / 100));
                                                }
                                                else
                                                {
                                                    TotalInventory = 0;
                                                }

                                                tstr += "    [Time" + i + "]=" + TotalInventory + ",";

                                                i++;
                                            }
                                            #endregion


                                            if (!string.IsNullOrEmpty(tstr))
                                            {
                                                tstr = tstr.Substring(0, tstr.Length - 1);
                                            }
                                            sql += tstr;
                                            sql += "  where  [StoreId]=" + itemstore.Id + " and  [ProductId]=" + item.Id + " and  [CreTime]='" + objInventoryHistory.CreTime.Date + "'";

                                            ExecuteSqlCommand(sql, null);
                                        }
                                    }
                                    #endregion
                                }
                            }
                        }
                    }
                }
            }
        }
Beispiel #3
0
        /// <summary>
        /// 添加溢出值
        /// </summary>
        public void AddInventoryOver()
        {
            int Stockdate = ZConvert.StrToInt(ZConfig.GetConfigString("Stockdate"));


            DateTime Time = DateTime.Now;

            for (int z = 0; z < Stockdate; z++)
            {
                int t = z == 0 ? 0 : 1;
                Time = Time.AddDays(t);
                var InventoryHistory = InventoryOverHistoryBLL.GetInstance().TableNoTracking().Where(o => o.CreTime == Time.Date).FirstOrDefault();
                if (InventoryHistory == null)
                {
                    // 添加记录
                    InventoryOverHistory obj = new InventoryOverHistory();
                    obj.CreTime = Time.Date;
                    InventoryOverHistoryBLL.GetInstance().Add(obj);
                    var store                 = StoreBll.GetInstance().TableNoTracking().Where(o => o.State == (int)StoreState.线中).ToList();
                    var ProductCategory       = ProductCategoryBll.GetInstance().TableNoTracking().ToList();
                    var ProductCategoryidlist = ProductCategory.Select(o => o.Id).ToList();
                    ProductCategoryidlist.Add(0);

                    var Productlist   = ProductBll.GetInstance().TableNoTracking().Where(o => ProductCategoryidlist.Contains(o.ProductCategoryId) && o.State == ProductStateEnum.架).ToList();
                    var Productidlist = Productlist.Select(o => o.Id).ToList();
                    Productidlist.Add(0);
                    var StockSettinglist = StockSettingBLL.GetInstance().TableNoTracking().Where(o => Productidlist.Contains(o.ProductId)).ToList();

                    if (store != null && store.Count > 0)
                    {
                        foreach (var itemstore in store)
                        {
                            if (ProductCategory != null && ProductCategory.Count > 0)
                            {
                                foreach (var itemProductCategory in ProductCategory)
                                {
                                    #region MyRegion
                                    ////    //店铺   分类下  当天的总库存
                                    List <StockOutInView> StockOutInViewlist = InventoryBLL.GetInstance().GetStockTotal(itemstore.Id, itemProductCategory.Id, Time);

                                    List <Product> ProductList = Productlist.Where(o => o.ProductCategoryId == itemProductCategory.Id).ToList();
                                    if (ProductList != null)
                                    {
                                        foreach (var item in ProductList)
                                        {
                                            string sql = "  INSERT INTO [InventoryOver]  ([StoreId]   ,[ProductId]    ,[CreTime]   ";
                                            sql += "      ,[Time1] ,[Time2]  ,[Time3]  ,[Time4]  ,[Time5]   ,[Time6]   ,[Time7]  ,[Time8]  ,[Time9]  ,[Time10]  ,[Time11] ,[Time12]  ,[Time13]  ,[Time14] ,[Time15]  ";
                                            sql += "       ,[Time16]   ,[Time17]   ,[Time18]   ,[Time19]   ,[Time20]   ,[Time21]    ,[Time22]    ,[Time23]  ";
                                            sql += "       ,[Time24]  ,[Time25]   ,[Time26]  ,[Time27]   ,[Time28] ,[Time29] ,[Time30]  ,[Time31]    ,[Time32]  ,[Time33]  ";
                                            sql += "        ,[Time34]  ,[Time35]  ,[Time36]  ,[Time37]    ,[Time38]   ,[Time39]    ,[Time40]  ,[Time41]  ,[Time42] ,[Time43]   ,[Time44] ,[Time45]  ,[Time46]  ,[Time47] ,[Time48]  ";
                                            sql += "        )  ";
                                            sql += "      VALUES  ";
                                            sql += "         (" + itemstore.Id + "," + item.Id + ",'" + Time.Date + "'  ";
                                            int i = 1;
                                            #region 循环

                                            while (i < 49)
                                            {
                                                //分类下
                                                var EmployeeProductViewModellistitem = new List <StockOutInView>();


                                                #region MyRegion
                                                if (i == 1)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time1 != null).ToList();
                                                }
                                                else
                                                if (i == 2)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time2 != null).ToList();
                                                }
                                                else
                                                if (i == 3)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time3 != null).ToList();
                                                }

                                                else
                                                if (i == 4)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time4 != null).ToList();
                                                }

                                                else
                                                if (i == 5)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time5 != null).ToList();
                                                }

                                                else
                                                if (i == 6)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time6 != null).ToList();
                                                }
                                                else
                                                if (i == 7)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time7 != null).ToList();
                                                }
                                                else
                                                if (i == 8)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time8 != null).ToList();
                                                }


                                                else
                                                if (i == 9)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time9 != null).ToList();
                                                }


                                                else
                                                if (i == 10)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time10 != null).ToList();
                                                }


                                                else
                                                if (i == 11)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time11 != null).ToList();
                                                }

                                                else
                                                if (i == 12)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time12 != null).ToList();
                                                }


                                                else
                                                if (i == 13)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time13 != null).ToList();
                                                }



                                                else
                                                if (i == 14)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time14 != null).ToList();
                                                }


                                                else
                                                if (i == 15)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time15 != null).ToList();
                                                }


                                                else
                                                if (i == 16)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time16 != null).ToList();
                                                }

                                                else
                                                if (i == 17)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time17 != null).ToList();
                                                }

                                                else
                                                if (i == 18)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time18 != null).ToList();
                                                }

                                                else
                                                if (i == 19)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time19 != null).ToList();
                                                }

                                                else
                                                if (i == 20)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time20 != null).ToList();
                                                }

                                                else
                                                if (i == 21)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time21 != null).ToList();
                                                }


                                                else
                                                if (i == 22)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time22 != null).ToList();
                                                }


                                                else
                                                if (i == 23)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time23 != null).ToList();
                                                }

                                                else
                                                if (i == 24)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time24 != null).ToList();
                                                }


                                                else
                                                if (i == 25)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time25 != null).ToList();
                                                }


                                                else
                                                if (i == 26)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time26 != null).ToList();
                                                }

                                                else
                                                if (i == 27)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time27 != null).ToList();
                                                }



                                                else
                                                if (i == 28)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time28 != null).ToList();
                                                }


                                                else
                                                if (i == 29)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time29 != null).ToList();
                                                }

                                                else
                                                if (i == 30)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time30 != null).ToList();
                                                }


                                                else
                                                if (i == 31)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time31 != null).ToList();
                                                }



                                                else
                                                if (i == 32)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time32 != null).ToList();
                                                }


                                                else
                                                if (i == 33)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time33 != null).ToList();
                                                }

                                                else
                                                if (i == 34)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time34 != null).ToList();
                                                }

                                                else
                                                if (i == 35)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time35 != null).ToList();
                                                }

                                                else
                                                if (i == 36)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time36 != null).ToList();
                                                }


                                                else
                                                if (i == 37)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time37 != null).ToList();
                                                }
                                                else
                                                if (i == 38)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time38 != null).ToList();
                                                }
                                                else
                                                if (i == 39)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time39 != null).ToList();
                                                }
                                                else
                                                if (i == 40)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time40 != null).ToList();
                                                }

                                                else
                                                if (i == 41)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time41 != null).ToList();
                                                }

                                                else
                                                if (i == 42)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time42 != null).ToList();
                                                }
                                                else
                                                if (i == 43)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time43 != null).ToList();
                                                }
                                                else
                                                if (i == 44)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time44 != null).ToList();
                                                }

                                                else
                                                if (i == 45)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time45 != null).ToList();
                                                }


                                                else
                                                if (i == 46)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time46 != null).ToList();
                                                }

                                                else
                                                if (i == 47)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time47 != null).ToList();
                                                }

                                                else
                                                if (i == 48)
                                                {
                                                    EmployeeProductViewModellistitem = StockOutInViewlist.Where(o => o.PrdouctId == item.Id && o.Time48 != null).ToList();
                                                }



                                                #endregion


                                                //产品下的总库存
                                                int TotalInventory = EmployeeProductViewModellistitem.Select(o => o.EmployeeId).Distinct().Count();


                                                //百分比计算

                                                var StockSetting = StockSettinglist.Where(o => o.ProductId == item.Id).FirstOrDefault();
                                                if (StockSetting != null)
                                                {
                                                    TotalInventory = ZConvert.StrToInt(TotalInventory * ((StockSetting.OverflowValue - 100) / 100));
                                                }
                                                else
                                                {
                                                    TotalInventory = 0;
                                                }



                                                sql += "  ," + TotalInventory + " ";



                                                i++;
                                            }
                                            #endregion

                                            sql += "   )";

                                            ExecuteSqlCommand(sql, null);
                                        }
                                    }
                                    #endregion
                                }
                            }
                        }
                    }
                }
            }
        }