コード例 #1
0
 public void Delete(StockInDetail data)
 {
     StockInDetailDAO.Delete(data);
 }
コード例 #2
0
ファイル: StockCreateForm.cs プロジェクト: DelLitt/opmscoral
        private object[] AddBlockToDataGrid(StockInDetail stockInDetail, IList stockList, IList returnStockList, int rowIndex)
        {
            var obj = new object[MAX_COLUMN];
            obj[BLOCK_ID_POS] = stockInDetail.Product.BlockInDetail.BlockInDetailPK.BlockDetailId;
            obj[PRODUCT_MASTER_ID_POS] = stockInDetail.Product.ProductMaster.ProductMasterId;
            obj[STOCK_IN_DATE_ID_POS] = stockInDetail.StockIn.StockInDate;
            obj[PRODUCT_MASTER_NAME_POS] = stockInDetail.Product.ProductMaster.ProductName;
            obj[PRODUCT_PRICE_POS] = stockInDetail.Price;
            obj[PRODUCT_QUANTITY_POS] = stockInDetail.Quantity;

            long stockQty = 0;
            if (stockList != null && stockList.Count > 0)
            {
                foreach (Stock stock in stockList)
                {
                    if (stockInDetail.Product.ProductId == stock.Product.ProductId)
                    {
                        stockQty += stock.Quantity;
                    }
                }
            }
            obj[STOCK_QUANTITY_POS] = stockQty;

            long returnQty = 0;
            if (returnStockList != null && returnStockList.Count > 0)
            {
                foreach (ReturnProduct returnProduct in returnStockList)
                {
                    if (stockInDetail.Product.ProductId == returnProduct.ProductId)
                    {
                        returnQty += returnProduct.Quantity;
                    }
                }
            }
            var remainQty = stockInDetail.Quantity - stockQty - returnQty;
            obj[REMAIN_QUANTITY_POS] = remainQty;
            obj[MAX_COLUMN - 1] = rowIndex;
            return obj;
        }
コード例 #3
0
 public void Update(StockInDetail data)
 {
     StockInDetailDAO.Update(data);
 }
コード例 #4
0
 public StockInDetail Add(StockInDetail data)
 {
     StockInDetailDAO.Add(data);
     return data;
 }
コード例 #5
0
        public BlockInDetail Add(BlockInDetail data)
        {
            var pk = new BlockInDetailPK {BlockId = 1};
            var maxId = BlockInDetailDAO.SelectSpecificType(null, Projections.Max("BlockInDetailPK.BlockDetailId"));

            pk.BlockDetailId = maxId == null ? "1" : (Int64.Parse(maxId.ToString()) + 1).ToString();

            data.BlockInDetailPK = pk;

            var maxProduct = ProductDAO.SelectSpecificType(null, Projections.Max("ProductId"));
            Int64 maxProductId = 1;
            if (maxProduct != null)
            {
                maxProductId = (Int64)maxProduct + 1;
            }

            var maxStockInId = StockInDAO.SelectSpecificType(null, Projections.Max("StockInId"));
            if (maxStockInId == null)
            {
                maxStockInId = (long) 1;
            }
            else
            {
                maxStockInId = (long)maxStockInId + 1;
            }

            var stockIn = new StockIn {StockInDate = data.ImportDate};
            data.StockInId = (long)maxStockInId;

            BlockInDetailDAO.Add(data);
            StockInDAO.Add(stockIn);

            foreach (Product product in data.Products)
            {
                // TODO product.ProductId = maxProductId++;
                product.BlockInDetail = data;
                ProductDAO.Add(product);

                var stockInDetail = new StockInDetail
                                        {
                                            Product = product,
                                            ProductId = product.ProductId,
                                            StockIn = stockIn,
                                            Quantity = product.Quantity,
                                            Price = product.Price,
                                            StockInType = (Int64)StockInDetail.StockInStatus.IMPORTED,
                                            StockInDetailPK =
                                                new StockInDetailPK
                                                    {StockInId = stockIn.StockInId, ProductId = product.ProductId}
                                        };
                StockInDetailDAO.Add(stockInDetail);
            }

            return data;
        }
コード例 #6
0
        void _departmentStockAdhocProcessingView_ProcessAdhocStocksEvent(object sender, DepartmentStockAdhocProcessingEventArgs e)
        {
            try
            {

                long departmentId = -1;
                StockOut stockOut = null;
                StockIn stockIn = new StockIn();
                stockIn.CreateDate = DateTime.Now;
                stockIn.UpdateDate = DateTime.Now;
                stockIn.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                stockIn.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                stockIn.StockInDate = DateTime.Now;
                stockIn.StockInType = 2; // stock in for fixing department stock quantity
                stockIn.StockInId = StockInLogic.FindMaxId();
                stockIn.StockInDetails = new ArrayList();
                long stockOutDetailMaxId = StockOutDetailLogic.FindMaxId() + 1;
                long stockOutMaxId = StockOutLogic.FindMaxId()+1;
                for (int i=0; i< e.DeptStockProcessedList.Count;i++)
                {
                    DepartmentStockTemp stockTemp = (DepartmentStockTemp) e.DeptStockProcessedList[i];
                    if(stockTemp.DepartmentStockTempPK.DepartmentId != departmentId)
                    {
                        departmentId = stockTemp.DepartmentStockTempPK.DepartmentId;

                        if (stockOut != null)
                        {
                            StockOutLogic.AddFixedStockOut(stockOut);
                        }
                        stockOut = new StockOut();
                        stockOut.CreateDate = DateTime.Now;
                        stockOut.UpdateDate = DateTime.Now;
                        stockOut.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                        stockOut.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                        stockOut.StockOutDate = DateTime.Now;
                        stockOut.StockOutDetails = new ArrayList();
                        stockOut.DepartmentId = departmentId;
                        stockOut.DefectStatus = new StockDefectStatus{ DefectStatusId = 0};

                        stockOut.StockoutId =  stockOutMaxId++;
                    }

                    stockTemp.Fixed = 1;
                    stockTemp.UpdateDate = DateTime.Now;
                    stockTemp.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                    DepartmentStockTempLogic.Update(stockTemp);
                    long realQty = stockTemp.GoodQuantity + stockTemp.ErrorQuantity + stockTemp.DamageQuantity +
                                   stockTemp.LostQuantity + stockTemp.UnconfirmQuantity;
                    if(stockTemp.Quantity < realQty)
                    {
                        long stockInQty = realQty - stockTemp.Quantity;
                        StockOutDetail stockOutDetail = new StockOutDetail();
                        stockOutDetail.CreateDate = DateTime.Now;
                        stockOutDetail.UpdateDate = DateTime.Now;
                        stockOutDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                        stockOutDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                        stockOutDetail.Quantity = stockInQty;
                        stockOutDetail.Product = stockTemp.Product;
                        stockOutDetail.StockOutId = stockOut.StockoutId;
                        stockOutDetail.StockOut = stockOut;
                        stockOutDetail.DefectStatus = new StockDefectStatus{DefectStatusId = 0};
                        stockOutDetail.Description = "Export goods";
                        stockOutDetail.ProductMaster = stockTemp.ProductMaster;
                        stockOutDetail.StockOutDetailId = stockOutDetailMaxId++;
                        stockOut.StockOutDetails.Add(stockOutDetail);

                        StockInDetail stockInDetail = new StockInDetail();
                        stockInDetail.CreateDate = DateTime.Now;
                        stockInDetail.UpdateDate = DateTime.Now;
                        stockInDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                        stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                        stockInDetail.StockInType = 0;
                        stockInDetail.StockIn = stockIn;

                        stockInDetail.Quantity = stockInQty;
                        stockInDetail.Product = stockTemp.Product;
                        stockInDetail.ProductMaster = stockTemp.ProductMaster;
                        stockInDetail.StockInDetailPK = new StockInDetailPK
                                                            {
                                                                ProductId = stockTemp.Product.ProductId,
                                                                StockInId = stockIn.StockInId
                                                            };
                        stockIn.StockInDetails.Add(stockInDetail);

                    }

                    if (i == e.DeptStockProcessedList.Count - 1) // last item
                    {
                        StockOutLogic.AddFixedStockOut(stockOut);
                    }
                }
                StockInLogic.AddFixedStockIn(stockIn);

            }
            catch (Exception)
            {
                e.HasErrors = true;
                throw;
            }
        }
コード例 #7
0
        public void DeleteList(IList<BlockInDetail> deleteList)
        {
            foreach (var blockInDetail in deleteList)
            {
                // Delete Block
                blockInDetail.DelFlg = 1;
                BlockInDetailDAO.Update(blockInDetail);

                // Delete Stock In
                StockIn stockIn = null;
                if (blockInDetail.StockInId != 0)
                {
                    stockIn = StockInDAO.FindById(blockInDetail.StockInId);
                    if (stockIn != null)
                    {
                        stockIn.DelFlg = 1;
                        StockInDAO.Update(stockIn);
                    }
                }

                foreach (Product product in blockInDetail.Products)
                {
                    product.DelFlg = 1;
                    ProductDAO.Update(product);
                    if (stockIn != null)
                    {
                        var stockInDetail = new StockInDetail
                                                {
                                                    Product = product,
                                                    StockIn = stockIn,
                                                    DelFlg = 1,
                                                    StockInDetailPK =
                                                        new StockInDetailPK
                                                            {
                                                                StockInId = stockIn.StockInId,
                                                                ProductId = product.ProductId
                                                            }
                                                };
                        StockInDetailDAO.Update(stockInDetail);
                    }
                }
            }
        }
コード例 #8
0
        public void Update(BlockInDetail data)
        {
            // Update block
            BlockInDetailDAO.Update(data);

            // Update Stock In
            StockIn stockIn = null;
            if (data.StockInId != 0)
            {
                stockIn = StockInDAO.FindById(data.StockInId);
                if (stockIn != null)
                {
                    stockIn.StockInDate = data.ImportDate;
                    StockInDAO.Update(stockIn);
                }
            }

            // Get the max id of product
            var maxProduct = ProductDAO.SelectSpecificType(null, Projections.Max("ProductId"));
            Int64 maxProductId = 1;
            if (maxProduct != null)
            {
                maxProductId = ((Int64)maxProduct) + 1;
            }

            foreach (Product product in data.Products)
            {
                // Add new Product
                if (string.IsNullOrEmpty(product.ProductId))
                {
                    // TODO product.ProductId = maxProductId++;
                    ProductDAO.Add(product);
                    if (stockIn != null)
                    {
                        var stockInDetail = new StockInDetail
                        {
                            Product = product,
                            ProductId = product.ProductId,
                            StockIn = stockIn,
                            Quantity = product.Quantity,
                            Price = product.Price,
                            StockInDetailPK =
                                new StockInDetailPK { StockInId = stockIn.StockInId, ProductId = product.ProductId }
                        };
                        StockInDetailDAO.Add(stockInDetail);
                    }
                }
                // Update Product
                else {
                    ProductDAO.Update(product);
                    if (stockIn != null)
                    {
                        var stockInDetail = new StockInDetail
                        {
                            Product = product,
                            ProductId = product.ProductId,
                            StockIn = stockIn,
                            Quantity = product.Quantity,
                            Price = product.Price,
                            StockInDetailPK =
                                new StockInDetailPK { StockInId = stockIn.StockInId, ProductId = product.ProductId }
                        };
                        StockInDetailDAO.Update(stockInDetail);
                    }
                }
            }
        }
コード例 #9
0
        public void mainStockInView_FindByBarcodeEvent(object sender, MainStockInEventArgs e)
        {
            var subCriteria = new SubObjectCriteria("StockOut");
            subCriteria.AddEqCriteria("DefectStatus.DefectStatusId", (long)4); // tạm xuất là 4
            var objectCriteria = new ObjectCriteria();
            objectCriteria.AddEqCriteria("Product.ProductId", e.ProductId);
            objectCriteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            objectCriteria.AddEqCriteria("DefectStatus.DefectStatusId", (long) 4);
            //objectCriteria.AddSubCriteria("StockOut", subCriteria);
            IList list = StockOutDetailLogic.FindAll(objectCriteria);
            if (list!=null && list.Count > 0)
            {
                var detail = new StockInDetail { Product = ((StockOutDetail)list[0]).Product };
                foreach (StockOutDetail soDetail in list)
                {
                    detail.StockOutQuantity += soDetail.Quantity;
                }
                e.StockInDetail = detail;
            }

            IList reStockInList = StockInLogic.FindReStockIn(e.ProductId);
            if(reStockInList!=null)
            {
                foreach (StockInDetail inDetail in reStockInList)
                {
                    e.StockInDetail.ReStockQuantity += inDetail.Quantity;
                }
            }

            e.EventResult = "Success";
        }
コード例 #10
0
        void inventoryCheckingView_SaveInventoryCheckingEvent(object sender, InventoryCheckingEventArgs e)
        {
            if(e.SaveStockList!=null && e.SaveStockList.Count > 0)
               {
               /*foreach (Stock stock in e.SaveStockList)
               {
                   stock.CreateDate = DateTime.Now;
                   stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                   stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                   stock.UpdateDate = DateTime.Now;
                   stock.DelFlg = 0;

                   // calculate business
                   StockLogic.Update(stock);

                   e.HasErrors = false;

               }*/
               // ++ AMEND FOR SHOES STOCK CHECKING 19/10/2009
               StockIn stockIn = new StockIn();
               stockIn.NotUpdateMainStock = false;
               stockIn.CreateDate = DateTime.Now;
               stockIn.UpdateDate = DateTime.Now;
               stockIn.StockInDate = DateTime.Now;
               stockIn.CreateId = ClientInfo.getInstance().LoggedUser.Name;
               stockIn.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
               stockIn.DelFlg = 0;
               stockIn.Description = " NHẬP TỪ SỐ LƯỢNG KIỂM KÊ";

               IList stockInDetailList = new ArrayList();
               foreach (Stock stock in e.SaveStockList)
               {
                   StockInDetail inDetail = new StockInDetail();
                   inDetail.CreateDate = DateTime.Now;
                   inDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                   inDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                   inDetail.UpdateDate = DateTime.Now;
                   inDetail.DelFlg = 0;
                   inDetail.Product = stock.Product;
                   inDetail.Quantity = stock.GoodQuantity;
                   inDetail.DelFlg = 0;
                   inDetail.StockIn = stockIn;
                   // calculate business
                   inDetail.StockInDetailPK = new StockInDetailPK
                                                  {
                                                      ProductId = stock.Product.ProductId
                                                  };
                   stockInDetailList.Add(inDetail);
               }
               stockIn.StockInDetails = stockInDetailList;
               StockInLogic.AddForStockOutToProducer(stockIn);
               e.HasErrors = false;
               // ++ AMEND FOR SHOES STOCK CHECKING 19/10/2009
               }
        }
コード例 #11
0
 /// <summary>
 /// Delete StockInDetail from database.
 /// </summary>
 /// <param name="data"></param>
 /// <returns></returns>
 public void Delete(StockInDetail data)
 {
     HibernateTemplate.Delete(data);
 }
コード例 #12
0
 /// <summary>
 /// Add StockInDetail to database.
 /// </summary>
 /// <param name="data"></param>
 /// <returns></returns>
 public StockInDetail Add(StockInDetail data)
 {
     HibernateTemplate.Save(data);
     return data;
 }
コード例 #13
0
 /// <summary>
 /// Update StockInDetail to database.
 /// </summary>
 /// <param name="data"></param>
 /// <returns></returns>
 public void Update(StockInDetail data)
 {
     HibernateTemplate.Update(data);
 }