public void stockSearchView_SearchStockEvent(object sender, DepartmentStockSearchEventArgs e) { var objectCriteria = new ObjectCriteria(true); objectCriteria.AddEqCriteria("s.DelFlg", (long)0); objectCriteria.AddEqCriteria("sdetail.DelFlg", (long)0); objectCriteria.AddLikeCriteria("pm.ProductMasterId", e.ProductMasterId + "%"); objectCriteria.AddLikeCriteria("pm.ProductName", e.ProductMasterName + "%"); objectCriteria.AddEqCriteria("pm.ProductType", e.ProductType); objectCriteria.AddEqCriteria("pm.ProductSize", e.ProductSize); objectCriteria.AddEqCriteria("pm.ProductColor", e.ProductColor); objectCriteria.AddEqCriteria("pm.Manufacturer", e.Manufacturer); objectCriteria.AddEqCriteria("pm.Country", e.Country); objectCriteria.AddEqCriteria("s.DepartmentStockPK.DepartmentId", CurrentDepartment.Get().DepartmentId); e.DepartmentStockList = DepartmentStockLogic.FindByQuery(objectCriteria); }
public void stockSearchView_InitStockSearchEvent(object sender, DepartmentStockSearchEventArgs e) { var criteria = new ObjectCriteria(); criteria.AddEqCriteria("DelFlg", (long)0); e.ProductTypeList = ProductTypeLogic.FindAll(criteria); e.ProductTypeList.Insert(0, new ProductType()); e.ProductSizeList = ProductSizeLogic.FindAll(criteria); e.ProductSizeList.Insert(0, new ProductSize()); e.ProductColorList = ProductColorLogic.FindAll(criteria); e.ProductColorList.Insert(0, new ProductColor()); e.ManufacturerList = ManufacturerLogic.FindAll(criteria); e.ManufacturerList.Insert(0, new Manufacturer()); e.CountryList = CountryLogic.FindAll(criteria); e.CountryList.Insert(0, new Country()); }
private void DepartmentStockSearchForm_Load(object sender, EventArgs e) { var eventArgs = new DepartmentStockSearchEventArgs(); EventUtility.fireEvent(InitDepartmentStockSearchEvent, this, eventArgs); productMasterSearchControl.cbbProductType.DataSource = eventArgs.ProductTypeList; productMasterSearchControl.cbbProductType.DisplayMember = "TypeName"; productMasterSearchControl.cbbProductSize.DataSource = eventArgs.ProductSizeList; productMasterSearchControl.cbbProductSize.DisplayMember = "SizeName"; productMasterSearchControl.cbbProductColor.DataSource = eventArgs.ProductColorList; productMasterSearchControl.cbbProductColor.DisplayMember = "ColorName"; productMasterSearchControl.cbbCountry.DataSource = eventArgs.CountryList; productMasterSearchControl.cbbCountry.DisplayMember = "CountryName"; }
private void btnSearch_Click(object sender, EventArgs e) { var eventArgs = new DepartmentStockSearchEventArgs { ProductMasterId = productMasterSearchControl.txtProductMasterId.Text, ProductMasterName = productMasterSearchControl.txtProductName.Text, ProductSize = productMasterSearchControl.cbbProductSize.SelectedIndex > 0 ? ((ProductSize)productMasterSearchControl.cbbProductSize.SelectedItem) : null, ProductType = productMasterSearchControl.cbbProductType.SelectedIndex > 0 ? ((ProductType)productMasterSearchControl.cbbProductType.SelectedItem) : null, ProductColor = productMasterSearchControl.cbbProductColor.SelectedIndex > 0 ? ((ProductColor)productMasterSearchControl.cbbProductColor.SelectedItem) : null, Country = productMasterSearchControl.cbbCountry.SelectedIndex > 0 ? ((Country)productMasterSearchControl.cbbCountry.SelectedItem) : null, Manufacturer = productMasterSearchControl.cbbManufacturer.SelectedIndex > 0 ? ((Manufacturer)productMasterSearchControl.cbbManufacturer.SelectedItem) : null, Distributor = productMasterSearchControl.cbbDistributor.SelectedIndex > 0 ? ((Distributor)productMasterSearchControl.cbbDistributor.SelectedItem) : null, Packager = productMasterSearchControl.cbbPackager.SelectedIndex > 0 ? ((Packager)productMasterSearchControl.cbbPackager.SelectedItem) : null }; EventUtility.fireEvent(SearchDepartmentStockEvent, this, eventArgs); DepartmentStockSearchResultList = eventArgs.DepartmentStockList; PopulateDataGrid(); }
private void DepartmentStockSearchForm_Load(object sender, EventArgs e) { stockViewList = new DepartmentStockViewCollection(bdsStockView); bdsStockView.ResetBindings(true); stockList = new DepartmentStockCollection(bdsStock); bdsStock.ResetBindings(true); var eventArgs = new DepartmentStockSearchEventArgs(); EventUtility.fireEvent(InitDepartmentStockSearchEvent, this, eventArgs); productMasterSearchControl.cbbProductType.DataSource = eventArgs.ProductTypeList; productMasterSearchControl.cbbProductType.DisplayMember = "TypeName"; productMasterSearchControl.cbbProductSize.DataSource = eventArgs.ProductSizeList; productMasterSearchControl.cbbProductSize.DisplayMember = "SizeName"; productMasterSearchControl.cbbProductColor.DataSource = eventArgs.ProductColorList; productMasterSearchControl.cbbProductColor.DisplayMember = "ColorName"; productMasterSearchControl.cbbCountry.DataSource = eventArgs.CountryList; productMasterSearchControl.cbbCountry.DisplayMember = "CountryName"; }
private void btnSearch_Click(object sender, EventArgs e) { var eventArgs = new DepartmentStockSearchEventArgs { ProductMasterId = productMasterSearchControl.txtProductMasterId.Text, ProductMasterName = productMasterSearchControl.txtProductName.Text, ProductSize = productMasterSearchControl.cbbProductSize.SelectedIndex > 0 ? ((ProductSize)productMasterSearchControl.cbbProductSize.SelectedItem) : null, ProductType = productMasterSearchControl.cbbProductType.SelectedIndex > 0 ? ((ProductType)productMasterSearchControl.cbbProductType.SelectedItem) : null, ProductColor = productMasterSearchControl.cbbProductColor.SelectedIndex > 0 ? ((ProductColor)productMasterSearchControl.cbbProductColor.SelectedItem) : null, Country = productMasterSearchControl.cbbCountry.SelectedIndex > 0 ? ((Country)productMasterSearchControl.cbbCountry.SelectedItem) : null, Manufacturer = productMasterSearchControl.cbbManufacturer.SelectedIndex > 0 ? ((Manufacturer)productMasterSearchControl.cbbManufacturer.SelectedItem) : null, Distributor = productMasterSearchControl.cbbDistributor.SelectedIndex > 0 ? ((Distributor)productMasterSearchControl.cbbDistributor.SelectedItem) : null, Packager = productMasterSearchControl.cbbPackager.SelectedIndex > 0 ? ((Packager)productMasterSearchControl.cbbPackager.SelectedItem) : null }; EventUtility.fireEvent(SearchDepartmentStockEvent, this, eventArgs); DepartmentStockSearchResultList = eventArgs.DepartmentStockList; if(DepartmentStockSearchResultList!= null && DepartmentStockSearchResultList.Count > 0) { stockViewList.Clear(); foreach (DepartmentStockView departmentStockView in DepartmentStockSearchResultList) { stockViewList.Add(departmentStockView); } bdsStockView.ResetBindings(false); dgvStockView.Refresh(); dgvStockView.Invalidate(); } }
public void stockSearchView_SearchStockEvent(object sender, DepartmentStockSearchEventArgs e) { var criteria = new SubObjectCriteria("ProductMaster"); if (!string.IsNullOrEmpty(e.ProductMasterId)) { criteria.AddLikeCriteria("ProductMasterId", "%" + e.ProductMasterId + "%"); } criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddLikeCriteria("ProductName", "%" +e.ProductMasterName + "%"); if (e.ProductType != null && e.ProductType.TypeId > 0) { criteria.AddEqCriteria("ProductType.TypeId", e.ProductType.TypeId); } if (e.ProductSize != null && e.ProductSize.SizeId > 0) { criteria.AddEqCriteria("ProductSize.SizeId", e.ProductSize.SizeId); } if (e.ProductColor != null && e.ProductColor.ColorId > 0) { criteria.AddEqCriteria("ProductColor.ColorId", e.ProductColor.ColorId); } if (e.Country != null && e.Country.CountryId > 0) { criteria.AddEqCriteria("Country.CountryId", e.Country.CountryId); } if (!string.IsNullOrEmpty(e.Description)) { criteria.AddLikeCriteria("Description", "%" + e.Description +"%"); } criteria.AddOrder("ProductName",true); var objectCriteria = new ObjectCriteria(true); objectCriteria.AddEqCriteria("DelFlg", (long)0); if (!string.IsNullOrEmpty(e.ProductId)) { objectCriteria.AddLikeCriteria("DepartmentStockPK.ProductId", "%" + e.ProductMasterId + "%"); } objectCriteria.AddEqCriteria("DepartmentStockPK.DepartmentId", CurrentDepartment.Get().DepartmentId); objectCriteria.AddSubCriteria("ProductMaster",criteria); IList departmentStocks = DepartmentStockLogic.FindAll(objectCriteria); IList stockViewList = new ArrayList(); // create stock view if (departmentStocks != null && departmentStocks.Count > 0) { DepartmentStockView stockView = null; foreach (DepartmentStock departmentStock in departmentStocks) { if (stockView!=null) { if(!stockView.ProductMaster.ProductName.Equals( departmentStock.Product.ProductMaster.ProductName)) { stockViewList.Add(stockView); stockView = null; } } if(stockView == null) { stockView = new DepartmentStockView(); stockView.ProductMaster = departmentStock.Product.ProductMaster; stockView.DepartmentStocks = new ArrayList(); } stockView.DepartmentStocks.Add(departmentStock); stockView.Quantity += departmentStock.Quantity; stockView.GoodQuantity += departmentStock.GoodQuantity; } // add last item if(stockView!=null) { stockViewList.Add(stockView); stockView = null; } e.DepartmentStockList = stockViewList; } }