C# ObjectCriteria.AddSearchInCriteria方法代码示例

        void stockInConfirmView_ConfirmStockInEvent(object sender, StockInConfirmEventArgs e)
        {
            try
            {
                ObjectCriteria objectCriteria = new ObjectCriteria();
                objectCriteria.AddSearchInCriteria("StockInId", e.ConfirmStockInList);
                objectCriteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                IList stockInList = StockInLogic.FindAll(objectCriteria);

                if (stockInList != null && stockInList.Count > 0)
                {
                    foreach (StockIn stockIn in stockInList)
                    {
                        if (stockIn.ConfirmFlg == 1)
                        {
                            stockIn.ConfirmFlg = 0;
                            StockInLogic.Update(stockIn);
                        }
                    }
                }
                else
                {
                    throw new BusinessException("Khong co gi de luu");
                }
            }
            catch (Exception exception)
            {
                e.EventResult = " Error !";
                e.HasErrors = true;
            }
        }

        public void mainStockOutView_LoadStockStatusEvent(object sender, MainStockOutEventArgs e)
        {
            IList productMasterIds = new ArrayList();
            foreach (ProductMaster master in e.SelectedProductMasterList)
            {
                productMasterIds.Add(master.ProductMasterId);
            }
            var criteria = new ObjectCriteria();
            criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            criteria.AddSearchInCriteria("ProductMaster.ProductMasterId", productMasterIds);
            IList list = StockLogic.FindAll(criteria);
            if (list.Count == 0)
            {
                return;
            }
            e.StockList = new ArrayList();
            e.FoundStockOutDetailList = new ArrayList();
            foreach (Stock stock in list)
            {
                StockOutDetail detail = new StockOutDetail();
                detail.Product = stock.Product;
                detail.GoodQuantity = stock.GoodQuantity;
                detail.ErrorQuantity = stock.ErrorQuantity;
                detail.LostQuantity = stock.LostQuantity;
                detail.DamageQuantity = stock.DamageQuantity;
                detail.UnconfirmQuantity = stock.UnconfirmQuantity;
                detail.Quantity = stock.Quantity;
                e.StockList.Add(stock);

                e.FoundStockOutDetailList.Add(detail);
            }
        }

        private IList GetRemainStockNumber(IList departmentStockIns)
        {
            IList productLists = new ArrayList();
            foreach (DepartmentStockOutDetail detail in departmentStockIns)
            {
                if (detail.Product != null)
                    productLists.Add(detail.Product.ProductId);
            }
            if (productLists.Count == 0)
            {
                return new ArrayList();
            }
            var criteria = new ObjectCriteria();
            criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            criteria.AddEqCriteria("DepartmentStockPK.DepartmentId", CurrentDepartment.Get().DepartmentId);
            criteria.AddSearchInCriteria("DepartmentStockPK.ProductId", productLists);
            IList stockList = DepartmentStockLogic.FindAll(criteria);

            if (stockList != null && stockList.Count > 0)
            {
                foreach (DepartmentStockOutDetail detail in departmentStockIns)
                {
                    foreach (DepartmentStock stock in stockList)
                    {
                        if (stock.DepartmentStockPK.ProductId.Equals(detail.Product.ProductId))
                        {
                            detail.Quantity = stock.Quantity;
                            break;
                        }
                    }
                }
            }

            return stockList;
        }

 void deptStockOutView_FindByStockInIdEvent(object sender, DepartmentStockOutEventArgs e)
 {
     if (e.SelectedStockInIds.Count > 0)
     {
         ObjectCriteria objectCriteria = new ObjectCriteria();
         objectCriteria.AddSearchInCriteria("DepartmentStockInDetailPK.StockInId", e.SelectedStockInIds);
         IList list = DepartmentStockInDetailLogic.FindAll(objectCriteria);
         IList stockOutList = new ArrayList();
         foreach (DepartmentStockInDetail inDetail in list)
         {
             DepartmentStockOutDetail deptDetail = new DepartmentStockOutDetail();
             deptDetail.CreateDate = DateTime.Now;
             deptDetail.UpdateDate = DateTime.Now;
             deptDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
             deptDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
             //deptDetail. = new DepartmentStockInDetailPK();
             deptDetail.Product = inDetail.Product;
             deptDetail.ProductMaster = inDetail.Product.ProductMaster;
             deptDetail.Quantity = inDetail.Quantity;
             deptDetail.GoodQuantity = inDetail.Quantity;
             stockOutList.Add(deptDetail);
         }
         IList stockList = GetRemainStockNumber(stockOutList);
         e.FoundDepartmentStockOutDetailList = stockOutList;
         e.DepartmentStockList = stockList;
     }
     EventUtility.fireEvent(CompletedFindByStockInEvent, this, e);
 }

        public void _departmentStockOutView_LoadStockStatusEvent(object sender, DepartmentStockOutEventArgs e)
        {
            if (e.SelectedProductMasterList == null || e.SelectedProductMasterList.Count == 0) return;

            IList productMasterIds = new ArrayList();
            foreach (ProductMaster master in e.SelectedProductMasterList)
            {
                productMasterIds.Add(master.ProductMasterId);
            }
            ObjectCriteria prdCrit = new ObjectCriteria();
            prdCrit.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            prdCrit.AddSearchInCriteria("ProductMaster.ProductMasterId", productMasterIds);
            IList prdList = ProductLogic.FindAll(prdCrit);

            IList stkPrdIdsList = new ArrayList();
            foreach (Product product in prdList)
            {
                stkPrdIdsList.Add(product.ProductId);
            }

            var criteria = new ObjectCriteria();
            criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            criteria.AddSearchInCriteria("DepartmentStockPK.ProductId", stkPrdIdsList);

            IList list = DepartmentStockLogic.FindAll(criteria);
            if (list.Count == 0)
            {
                return;
            }

            e.DepartmentStockList = new ArrayList();
            e.FoundDepartmentStockOutDetailList = new ArrayList();
            foreach (DepartmentStock stock in list)
            {
                /*if(stock.Quantity == 0)
                {
                    continue;
                }*/
                DepartmentStockOutDetail detail = new DepartmentStockOutDetail();
                detail.DepartmentStockOutDetailPK = new DepartmentStockOutDetailPK
                                                        {
                                                            DepartmentId = CurrentDepartment.Get().DepartmentId
                                                        };
                detail.Product = stock.Product;
                detail.GoodQuantity = stock.GoodQuantity;
                detail.ErrorQuantity = stock.ErrorQuantity;
                detail.LostQuantity = stock.LostQuantity;
                detail.DamageQuantity = stock.DamageQuantity;
                detail.UnconfirmQuantity = stock.UnconfirmQuantity;
                detail.Quantity = stock.Quantity;
                e.DepartmentStockList.Add(stock);
                e.FoundDepartmentStockOutDetailList.Add(detail);
            }
        }

        private void productMasterSearchDepartmentView_SearchProductEvent(object sender, ProductMasterSearchDepartmentEventArgs e)
        {
            ProductMaster searchProductMaster = e.SelectedProductMaster;
            ObjectCriteria searchByProductMasterCriteria = new ObjectCriteria();
            searchByProductMasterCriteria.AddEqCriteria("Department", CurrentDepartment.Get());
            searchByProductMasterCriteria.AddEqCriteria("ProductMaster", searchProductMaster);
            searchByProductMasterCriteria.AddOrder("CreateDate", false);
            searchByProductMasterCriteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            IList productsStockIn = DepartmentStockInDetailLogic.FindAllProductMaster(searchProductMaster);
            IList productsInStock = new ArrayList();
            IList productIds = new ArrayList();
            foreach (DepartmentStockInDetail detail in productsStockIn)
            {
                productIds.Add(detail.Product.ProductId);
            }
            ObjectCriteria stockCrit = new ObjectCriteria();
            stockCrit.AddSearchInCriteria("DepartmentStockPK.ProductId", productIds);
            if(e.AvailableInStock)
            {
                stockCrit.AddGreaterCriteria("GoodQuantity", (long) 0);
            }
            IList stockList = DepartmentStockLogic.FindAll(stockCrit);
            if (stockList != null && stockList.Count > 0)
            {
                foreach (DepartmentStock departmentStock in stockList)
                {
                    departmentStock.Product = ProductLogic.FindById(departmentStock.DepartmentStockPK.ProductId);
                    productsInStock.Add(departmentStock);
                }

            }
            e.ProductsInDepartment = productsInStock;
        }

        void departmentStockCheckingView_LoadGoodsByProductIdEvent(object sender, AppFrame.Presenter.GoodsIO.DepartmentGoodsIO.DepartmentStockCheckingEventArgs e)
        {
            string barCode = e.InputBarcode;
            Product product = ProductLogic.FindById(barCode);
            if(product==null)
            {
                return;
            }

            // search in temp stock
            ObjectCriteria criteria = new ObjectCriteria();
            criteria.AddEqCriteria("DepartmentStockTempPK.ProductId", product.ProductId);
            criteria.AddEqCriteria("DepartmentStockTempPK.DepartmentId", CurrentDepartment.Get().DepartmentId);
            criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            IList tempList =DepartmentStockTempLogic.FindAll(criteria);
            if(tempList!=null && tempList.Count > 0)
            {
                e.UnconfirmTempBarcode = true;
                throw new BusinessException("Mã vạch này đã kiểm trước đó và chưa được xác nhận. Xin liên hệ người quản lý kho.");
            }
            // search in stock
            ProductMaster searchProductMaster = product.ProductMaster;
            ObjectCriteria searchByProductMasterCriteria = new ObjectCriteria();
            /*searchByProductMasterCriteria.AddEqCriteria("Department", CurrentDepartment.Get());
            searchByProductMasterCriteria.AddEqCriteria("ProductMaster", searchProductMaster);
            searchByProductMasterCriteria.AddOrder("CreateDate", false);
            searchByProductMasterCriteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            IList productsStockIn = DepartmentStockInDetailLogic.FindAllProductMaster(searchProductMaster);*/
            searchByProductMasterCriteria.AddEqCriteria("ProductMaster", searchProductMaster);
            IList productsStockIn = ProductLogic.FindAll(searchByProductMasterCriteria);
            IList productsInStock = new ArrayList();
            IList productIds = new ArrayList();
            //foreach (DepartmentStockInDetail detail in productsStockIn)
            foreach (Product detail in productsStockIn)
            {
                productIds.Add(detail.ProductId);
            }
            ObjectCriteria stockCrit = new ObjectCriteria();
            stockCrit.AddSearchInCriteria("DepartmentStockPK.ProductId", productIds);
            stockCrit.AddEqCriteria("DepartmentStockPK.DepartmentId", CurrentDepartment.Get().DepartmentId);
            stockCrit.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            stockCrit.AddOrder("DepartmentStockPK.ProductId",true);
            IList departmentStocks = DepartmentStockLogic.FindAll(stockCrit);

            // create stock view
            if (departmentStocks != null && departmentStocks.Count > 0)
            {
                DepartmentStockView stockView = new DepartmentStockView();
                stockView.ProductMaster = product.ProductMaster;
                stockView.DepartmentStocks = departmentStocks;
                foreach (DepartmentStock departmentStock in departmentStocks)
                {

                    // empty old stock
                    departmentStock.GoodQuantity = 0;
                    departmentStock.ErrorQuantity = 0;
                    departmentStock.UnconfirmQuantity = 0;
                    departmentStock.LostQuantity = 0;
                    departmentStock.DamageQuantity = 0;

                    // sum new stock
                    stockView.Quantity += departmentStock.Quantity;
                    stockView.GoodQuantity += departmentStock.Quantity;
                    stockView.ErrorQuantity += departmentStock.ErrorQuantity;
                    stockView.UnconfirmQuantity += departmentStock.UnconfirmQuantity;
                    stockView.LostQuantity += departmentStock.LostQuantity;
                    stockView.DamageQuantity += departmentStock.DamageQuantity;
                    stockView.ProductId = product.ProductId;

                    stockView.ProductId = product.ProductId;

                }
                e.ScannedStockView = stockView;
            }
        }

 private void GetRemainStockNumber(IList departmentStockIns)
 {
     IList productMasterIds = new ArrayList();
     foreach (DepartmentStockInDetail detail in departmentStockIns)
     {
         if (detail.Product != null && detail.Product.ProductMaster != null && detail.Product.ProductMaster.ProductMasterId != null)
         productMasterIds.Add(detail.Product.ProductMaster.ProductMasterId);
     }
     if (productMasterIds.Count == 0)
     {
         return;
     }
     var criteria = new ObjectCriteria();
     criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
     criteria.AddSearchInCriteria("ProductMaster.ProductMasterId", productMasterIds);
     IList stockList = StockLogic.FindAll(criteria);
     criteria = new ObjectCriteria();
     criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
     criteria.AddEqCriteria("DepartmentPricePK.DepartmentId", (long)0);
     criteria.AddSearchInCriteria("DepartmentPricePK.ProductMasterId", productMasterIds);
     IList priceList = DepartmentPriceLogic.FindAll(criteria);
     foreach (DepartmentStockInDetail detail in departmentStockIns)
     {
         detail.StockQuantity = 0;
         if (detail.Product != null
             && detail.Product.ProductMaster != null
             && detail.Product.ProductMaster.ProductMasterId != null)
         {
             foreach (Stock stock in stockList)
             {
                 if (detail.Product.ProductMaster.ProductMasterId.Equals(stock.ProductMaster.ProductMasterId))
                 {
                     detail.StockQuantity += stock.Quantity;
                 }
             }
             foreach (DepartmentPrice price in priceList)
             {
                 if (detail.Product.ProductMaster.ProductMasterId.Equals(price.DepartmentPricePK.ProductMasterId))
                 {
                     detail.Price = price.Price;
                 }
             }
         }
     }
 }

        public override void departmentStockInView_SaveDepartmentStockInEvent(object sender, DepartmentStockInEventArgs e)
        {
            var stockIn = e.DepartmentStockIn;
            if (stockIn.StockInId == 0)
            {
                // if we are doing stock out to department
                if(e.ExportGoodsToDepartment)
                {
                    // execute stock out saving
                    StockOutLogic.Add(stockIn);
                    if (!e.IsForSync)
                    {
                        ClientUtility.Log(logger, stockIn.ToString(), "Xuất hàng ra cửa hàng");
                    }
                    else
                    {
                        ClientUtility.Log(logger, "Đồng bộ về cửa hàng.\r\n" + stockIn.ToString(), "Xuất hàng ra cửa hàng");
                    }

                }
                else
                {
                    DepartmentStockInLogic.Add(stockIn);
                    if (!e.IsForSync)
                    {
                        ClientUtility.Log(logger, stockIn.ToString(), "Nhập kho cửa hàng");
                    }
                    else
                    {
                        ClientUtility.Log(logger, "Đồng bộ về cửa hàng.\r\n" + stockIn.ToString(), "Đồng bộ về cửa hàng");
                    }
                }

            }
            else
            {
                DepartmentStockInLogic.Update(stockIn);
                if (!e.IsForSync)
                {
                    ClientUtility.Log(logger, stockIn.ToString(), "Nhập kho cửa hàng");
                }
                else
                {
                    ClientUtility.Log(logger, "Đồng bộ về cửa hàng.\r\n" + stockIn.ToString(), "Đồng bộ về cửa hàng");
                }
            }
            if (stockIn.DepartmentStockInPK != null && e.IsForSync)
            {
                e.DepartmentStockIn = DepartmentStockInLogic.FindById(stockIn.DepartmentStockInPK);
                IList productMasterIds = new ArrayList();
                foreach (DepartmentStockInDetail detail in e.DepartmentStockIn.DepartmentStockInDetails)
                {
                    if (!productMasterIds.Contains(detail.Product.ProductMaster.ProductMasterId))
                    {
                        productMasterIds.Add(detail.Product.ProductMaster.ProductMasterId);
                    }
                }
                var criteria = new ObjectCriteria();
                criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                criteria.AddEqCriteria("DepartmentPricePK.DepartmentId", (long)0);
                criteria.AddSearchInCriteria("DepartmentPricePK.ProductMasterId", productMasterIds);
                IList priceList = DepartmentPriceLogic.FindAll(criteria);
                foreach (DepartmentStockInDetail detail in e.DepartmentStockIn.DepartmentStockInDetails)
                {
                    foreach (DepartmentPrice price in priceList)
                    {
                        if (price.DepartmentPricePK.ProductMasterId.Equals(detail.Product.ProductMaster.ProductMasterId))
                        {
                            detail.Price = price.Price;
                        }
                    }
                }

                // Department information
                e.DepartmentStockIn.Department = DepartmentLogic.FindById(stockIn.DepartmentStockInPK.DepartmentId);
                criteria = new ObjectCriteria();
                criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                criteria.AddEqCriteria("EmployeePK.DepartmentId", stockIn.DepartmentStockInPK.DepartmentId);
                e.DepartmentStockIn.Department.Employees = EmployeeLogic.FindAll(criteria);
            }
            e.EventResult = "Success";
        }

        public virtual void departmentStockInView_SaveDepartmentStockInEvent(object sender, DepartmentStockInEventArgs e)
        {
            var stockIn = e.DepartmentStockIn;
            IList masterIds = new ArrayList();
            foreach (DepartmentStockInDetail detail in stockIn.DepartmentStockInDetails)
            {
                if (!masterIds.Contains(detail.Product.ProductMaster.ProductMasterId))
                {
                    masterIds.Add(detail.Product.ProductMaster.ProductMasterId);
                }
            }
            var cri2 = new ObjectCriteria();
            cri2.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
            cri2.AddEqCriteria("DepartmentPricePK.DepartmentId", (long)0);
            cri2.AddSearchInCriteria("DepartmentPricePK.ProductMasterId", masterIds);
            IList prices = DepartmentPriceLogic.FindAll(cri2);
            foreach (DepartmentStockInDetail detail in stockIn.DepartmentStockInDetails)
            {
                foreach (DepartmentPrice price in prices)
                {
                    if (price.DepartmentPricePK.ProductMasterId.Equals(detail.Product.ProductMaster.ProductMasterId))
                    {
                        detail.Price = price.Price;
                    }
                    if(price.Price <= 0)
                    {
                        throw new BusinessException(" Giá hàng của " + detail.Product.ProductMaster.ProductName + " bằng 0 hoặc âm. Đề nghị điều chỉnh trước khi xuất ra cửa hàng.");
                    }
                }
            }

            if (stockIn.StockInId == 0)
            {
                //StockOutLogic.Add(stockIn);
                DepartmentStockInLogic.Add(stockIn);
                if (!e.IsForSync)
                {
                    ClientUtility.Log(logger, stockIn.ToString(), "Nhập kho cửa hàng");
                }
                else
                {
                    ClientUtility.Log(logger, "Đồng bộ về cửa hàng.\r\n" + stockIn.ToString(), "Đồng bộ về cửa hàng");
                }
            }
            else
            {
                //StockOutLogic.Update(stockIn);
                DepartmentStockInLogic.Update(stockIn);
                if (!e.IsForSync)
                {
                    ClientUtility.Log(logger, "Chỉnh sửa " + stockIn.ToString(), "Chỉnh sửa Nhập kho cửa hàng");
                }
                else
                {
                    ClientUtility.Log(logger, "Đồng bộ về cửa hàng.\r\n" + stockIn.ToString(), "Đồng bộ về cửa hàng");
                }
            }
            if (stockIn.DepartmentStockInPK != null && e.IsForSync)
            {
                e.DepartmentStockIn = DepartmentStockInLogic.FindById(stockIn.DepartmentStockInPK);
                IList productMasterIds = new ArrayList();
                foreach (DepartmentStockInDetail detail in e.DepartmentStockIn.DepartmentStockInDetails)
                {
                    if (!productMasterIds.Contains(detail.Product.ProductMaster.ProductMasterId))
                    {
                        productMasterIds.Add(detail.Product.ProductMaster.ProductMasterId);
                    }
                }
                var criteria = new ObjectCriteria();
                criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                criteria.AddEqCriteria("DepartmentPricePK.DepartmentId", (long)0);
                criteria.AddSearchInCriteria("DepartmentPricePK.ProductMasterId", productMasterIds);
                IList priceList = DepartmentPriceLogic.FindAll(criteria);
                foreach (DepartmentStockInDetail detail in e.DepartmentStockIn.DepartmentStockInDetails)
                {
                    foreach (DepartmentPrice price in priceList)
                    {
                        if (price.DepartmentPricePK.ProductMasterId.Equals(detail.Product.ProductMaster.ProductMasterId))
                        {
                            detail.Price = price.Price;
                        }
                    }
                }

                // Department information
                if (DepartmentLogic != null)
                {
                    e.DepartmentStockIn.Department = DepartmentLogic.FindById(stockIn.DepartmentStockInPK.DepartmentId);
                    criteria = new ObjectCriteria();
                    criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                    criteria.AddEqCriteria("EmployeePK.DepartmentId", stockIn.DepartmentStockInPK.DepartmentId);
                    e.DepartmentStockIn.Department.Employees = EmployeeLogic.FindAll(criteria);
                }
            }

            e.EventResult = "Success";
        }

        void departmentStockInExtraView_LoadStockInByProductMaster(object sender, DepartmentStockInEventArgs e)
        {
            if(e.ProductMasterList == null || e.ProductMasterList.Count == 0 )
                    {
                        return;
                    }
                    ObjectCriteria prdMasterCrit = new ObjectCriteria();
                    IList prdNames = new ArrayList();
                    foreach (ProductMaster list in e.ProductMasterList)
                    {
                        prdNames.Add(list.ProductName);
                    }
                    IList prdMasterList = new ArrayList();
                    foreach (ProductMaster master in e.ProductMasterList)
                    {
                        prdMasterList.Add(master);
                    }
                    /*prdMasterCrit.AddSearchInCriteria("ProductName", prdNames);
                    prdMasterCrit.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                    prdMasterList = ProductMasterLogic.FindAll(prdMasterCrit);*/

                    if (prdMasterList != null && prdMasterList.Count > 0)
                    {
                        IList prdMstIds = new ArrayList();
                        foreach (ProductMaster master in prdMasterList)
                        {
                            prdMstIds.Add(master.ProductMasterId);
                        }
                        IList stockOutList = new ArrayList();
                        ObjectCriteria stkCriteria = new ObjectCriteria();
                        stkCriteria.AddSearchInCriteria("ProductMaster.ProductMasterId", prdMstIds);
                        stkCriteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
                        //stkCriteria.AddGreaterCriteria("GoodQuantity", (long)0);
                        IList stockList = StockLogic.FindAll(stkCriteria);

                        foreach (Stock inDetail in stockList)
                        {
                            DepartmentStockInDetail deptDetail = new DepartmentStockInDetail();
                            deptDetail.CreateDate = DateTime.Now;
                            deptDetail.UpdateDate = DateTime.Now;
                            deptDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
                            deptDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
                            deptDetail.DepartmentStockInDetailPK = new DepartmentStockInDetailPK();
                            deptDetail.Product = inDetail.Product;
                            deptDetail.ProductMaster = inDetail.Product.ProductMaster;
                            deptDetail.Quantity = inDetail.Quantity;
                            stockOutList.Add(deptDetail);
                        }
                        GetRemainStockNumber(stockOutList);
                        MinusConfirmStockOut(stockOutList);
                        e.SelectedStockOutDetails = stockOutList;
                    }
        }

        public void stockCreateView_SearchStockInDetailEvent(object sender, StockCreateEventArgs e)
        {
            // Search StockInDetail
            var subCriteria = new SubObjectCriteria("StockIn");
            subCriteria.AddGreaterOrEqualsCriteria("StockInDate", DateUtility.ZeroTime(e.ImportDateFrom));
            subCriteria.AddLesserOrEqualsCriteria("StockInDate", DateUtility.MaxTime(e.ImportDateTo));
            subCriteria.AddEqCriteria("DelFlg", (long)0);

            var criteria = new ObjectCriteria();
            criteria.AddEqCriteria("DelFlg", (long)0);
            criteria.AddEqCriteria("StockInType", (Int64)e.StockInStatus);
            criteria.AddSubCriteria("StockIn", subCriteria);
            IList stockInDetailList = StockInDetailLogic.FindAll(criteria);
            e.StockInDetailList = stockInDetailList;

            // Search Stock
            if (stockInDetailList.Count > 0)
            {
                // build the Product id list
                IList productIdList = new ArrayList();
                foreach (StockInDetail stockInDetail in stockInDetailList)
                {
                    productIdList.Add(stockInDetail.Product.ProductId);
                }
                criteria = new ObjectCriteria();
                criteria.AddSearchInCriteria("Product.ProductId", productIdList);
                e.StockList = StockLogic.FindAll(criteria);

                criteria = new ObjectCriteria();
                criteria.AddSearchInCriteria("ProductId", productIdList);
                e.ReturnProductList = ReturnProductLogic.FindAll(criteria);
            }
        }