private void posLogView_SearchPosLogEvent(object sender, PosLogEventArgs e) { var criteria = new ObjectCriteria(); if(!string.IsNullOrEmpty(e.Username)) { criteria.AddLikeCriteria("PosUser", e.Username + "%"); } if(!string.IsNullOrEmpty(e.Action)) { criteria.AddLikeCriteria("PosAction", e.Action + "%"); } criteria.AddGreaterOrEqualsCriteria("Date", DateUtility.ZeroTime(e.LogDateFrom)); criteria.AddLesserOrEqualsCriteria("Date", DateUtility.MaxTime(e.LogDateTo)); criteria.AddOrder("Date", false); IList list = PosLogLogic.FindAll(criteria); e.PosLogList = list; }
public void departmentStockInSearchView_SearchMainStockInEvent(object sender, MainStockInSearchEventArgs e) { var criteria = new ObjectCriteria(); criteria.AddGreaterOrEqualsCriteria("StockInDate", e.StockInDateFrom); criteria.AddLesserOrEqualsCriteria("StockInDate", e.StockInDateTo); criteria.AddLikeCriteria("StockInId", e.StockInId + "%"); criteria.AddEqCriteria("DelFlg", (long)0); e.StockInList = StockInLogic.FindAll(criteria); }
public void departmentStockInSearchView_SearchDepartmentStockInEvent(object sender, DepartmentStockInSearchEventArgs e) { var criteria = new ObjectCriteria(); criteria.AddEqCriteria("DepartmentStockInPK.DepartmentId", CurrentDepartment.Get().DepartmentId); criteria.AddGreaterOrEqualsCriteria("StockInDate", e.StockInDateFrom); criteria.AddLesserOrEqualsCriteria("StockInDate", e.StockInDateTo); criteria.AddLikeCriteria("DepartmentStockInPK.StockInId", e.StockInId + "%"); criteria.AddEqCriteria("DelFlg", (long)0); e.DepartmeneStockInList = DepartmentStockInLogic.FindAll(criteria); EventUtility.fireEvent(CompletedSearchDepartmentStockInEvent,this,e); }
public void goodsIOSearchView_SearchBlockInDetailEvent(object sender, GoodsIOSearchEventArgs e) { var criteria = new ObjectCriteria(); if (!string.IsNullOrEmpty(e.BlockDetailId)) { criteria.AddLikeCriteria("BlockInDetailPK.BlockDetailId", string.Format("{0}%", e.BlockDetailId)); } criteria.AddGreaterOrEqualsCriteria("ImportDate", DateUtility.ZeroTime(e.ImportDateFrom)); criteria.AddLesserOrEqualsCriteria("ImportDate", DateUtility.MaxTime(e.ImportDateTo)); if (!e.IsNeedDelete) { criteria.AddEqCriteria("DelFlg", (Int64)0); } e.BlockDetailList = BlockInDetailLogic.FindAll(criteria); }
public void _departmentStockOutView_FillProductToComboEvent(object sender, DepartmentStockOutEventArgs e) { ComboBox comboBox = (ComboBox) sender; string originalText = comboBox.Text; if (e.IsFillToComboBox) { ProductMaster searchPM = e.SelectedDepartmentStockOutDetail.Product.ProductMaster; var criteria = new ObjectCriteria(true); criteria.AddEqCriteria("pm.DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddEqCriteria("stock.DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddLikeCriteria("pm.ProductName", "%" + searchPM.ProductName + "%"); criteria.MaxResult = 50; IList list = DepartmentStockLogic.FindByQueryForDeptStock(criteria); if(list ==null || list.Count == 0) { return; } IList result = new ArrayList(); foreach (DepartmentStock stock in list) { result.Add(stock.Product.ProductMaster); } IList retlist = RemoveDuplicateName(result); result = new ArrayList(); int count = 0; foreach (var p in retlist) { if (count == 50) { break; } result.Add(p); count++; } var productMasters = new BindingList<ProductMaster>(); foreach (ProductMaster master in result) { productMasters.Add(master); } var bindingSource = new BindingSource(); bindingSource.DataSource = productMasters; comboBox.DataSource = bindingSource; comboBox.DisplayMember = "TypeAndName"; comboBox.ValueMember = e.ComboBoxDisplayMember; comboBox.DropDownWidth = 300; comboBox.DropDownHeight = 200; // keep the original text comboBox.Text = originalText; comboBox.MaxDropDownItems = 10; } }
private void stockSearchView_BarcodeSearchStockEvent(object sender, StockSearchEventArgs e) { var subCriteria = new SubObjectCriteria("ProductMaster"); subCriteria.AddLikeCriteria("ProductName", "%" + e.ProductMasterName + "%"); subCriteria.AddEqCriteria("ProductType", e.ProductType); subCriteria.AddEqCriteria("ProductSize", e.ProductSize); subCriteria.AddEqCriteria("ProductColor", e.ProductColor); subCriteria.AddEqCriteria("Country", e.Country); subCriteria.AddEqCriteria("Manufacturer", e.Manufacturer); subCriteria.AddEqCriteria("Packager", e.Packager); subCriteria.AddEqCriteria("Distributor", e.Distributor); var criteria = new ObjectCriteria(true); criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddLikeCriteria("Product.ProductId", e.ProductMasterId + "%"); criteria.AddSubCriteria("ProductMaster", subCriteria); criteria.AddGreaterOrEqualsCriteria("CreateDate", DateUtility.ZeroTime(e.FromDate)); criteria.AddLesserOrEqualsCriteria("CreateDate", DateUtility.MaxTime(e.ToDate)); IList list = StockLogic.FindAll(criteria); e.StockList = list; }
public void stockSearchView_SearchStockEvent(object sender, StockSearchEventArgs e) { /* var subCriteria1 = new SubObjectCriteria("Product"); var subCriteria2 = new SubObjectCriteria("ProductMaster"); subCriteria2.AddLikeCriteria("ProductMasterId", e.ProductMasterId); subCriteria2.AddLikeCriteria("ProductName", e.ProductMasterName);*/ var criteria = new ObjectCriteria(true); criteria.AddEqCriteria("stock.DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddLikeCriteria("pm.ProductMasterId", e.ProductMasterId + "%"); criteria.AddLikeCriteria("pm.ProductName", "%" + e.ProductMasterName + "%"); criteria.AddEqCriteria("pm.ProductType", e.ProductType); criteria.AddEqCriteria("pm.ProductSize", e.ProductSize); criteria.AddEqCriteria("pm.ProductColor", e.ProductColor); criteria.AddEqCriteria("pm.Country", e.Country); criteria.AddEqCriteria("pm.Manufacturer", e.Manufacturer); criteria.AddEqCriteria("pm.Packager", e.Packager); criteria.AddEqCriteria("pm.Distributor", e.Distributor); IList list = StockLogic.FindByQuery(criteria); if(!CheckUtility.IsNullOrEmpty(GlobalCache.Instance().WarningText)) { MessageBox.Show(GlobalCache.Instance().WarningText); GlobalCache.Instance().WarningText = null; } e.StockList = list; }
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); }
void _departmentStockInView_FillProductToComboEvent(object sender, DepartmentStockInEventArgs e) { ComboBox comboBox = (ComboBox) sender; string originalText = comboBox.Text; if (e.IsFillToComboBox) { ProductMaster searchPM = e.SelectedDepartmentStockInDetail.Product.ProductMaster; var criteria = new ObjectCriteria(true); criteria.AddEqCriteria("pm.DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddEqCriteria("stock.DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddLikeCriteria("pm.ProductName", "%" + searchPM.ProductName + "%"); criteria.MaxResult = 50; IList list = StockLogic.FindByQueryForStockIn(criteria); // if (e.ComboBoxDisplayMember.Equals("ProductMasterId")) // { // result = ProductMasterLogic.FindProductMasterById(searchPM.ProductMasterId, 50,true); // } // else // { // result = ProductMasterLogic.FindProductMasterByName(searchPM.ProductName, 50,true); // } if(list ==null || list.Count == 0) { return; } IList result = new ArrayList(); foreach (Stock stock in list) { result.Add(stock.ProductMaster); } IList retlist = RemoveDuplicateName(result); result = new ArrayList(); int count = 0; foreach (var p in retlist) { result.Add(p); count++; } BindingList<ProductMaster> productMasters = new BindingList<ProductMaster>(); if (result != null) { foreach (ProductMaster master in result) { productMasters.Add(master); } } BindingSource bindingSource = new BindingSource(); bindingSource.DataSource = productMasters; comboBox.DataSource = bindingSource; comboBox.DisplayMember = "TypeAndName"; comboBox.ValueMember = e.ComboBoxDisplayMember; comboBox.DropDownWidth = 300; comboBox.DropDownHeight = 200; // keep the original text comboBox.Text = originalText; //comboBox.SelectedIndex = -1; //comboBox.SelectionStart = comboBox.Text.Length; //comboBox.DroppedDown = true; comboBox.MaxDropDownItems = 10; } }
void _departmentStockInView_FillProductToComboEvent(object sender, MainStockInEventArgs e) { ComboBox comboBox = (ComboBox) sender; string originalText = comboBox.Text; if (e.IsFillToComboBox) { ProductMaster searchPM = e.SelectedStockInDetail.Product.ProductMaster; System.Collections.IList result = null; if (e.ComboBoxDisplayMember.Equals("ProductMasterId")) { result = ProductMasterLogic.FindProductMasterById(searchPM.ProductMasterId, 50,true); } else { //result = ProductMasterLogic.FindProductMasterByName(searchPM.ProductName, 50,true); ObjectCriteria criteria = new ObjectCriteria(); criteria.AddLikeCriteria("ProductName", "%" + searchPM.ProductName + "%"); criteria.AddOrder("ProductName", true); criteria.MaxResult = 200; result = ProductMasterLogic.FindAll(criteria); } if(result==null) { return; } BindingList<ProductMaster> productMasters = new BindingList<ProductMaster>(); if (result != null) { result = RemoveDuplicateName(result); foreach (ProductMaster master in result) { productMasters.Add(master); } } BindingSource bindingSource = new BindingSource(); bindingSource.DataSource = productMasters; comboBox.DataSource = bindingSource; comboBox.DisplayMember = "ProductName"; comboBox.ValueMember = e.ComboBoxDisplayMember; comboBox.DropDownWidth = 300; comboBox.DropDownHeight = 200; // keep the original text comboBox.Text = originalText; if (result.Count > 0) { comboBox.SelectedIndex = 0; } comboBox.SelectionStart = comboBox.Text.Length; //comboBox.DroppedDown = false; comboBox.MaxDropDownItems = 15; } }
void _productMasterSearchOrCreateView_SearchCommonProductMasterEvent(object sender, ProductMasterSearchOrCreateEventArgs e) { var criteria = new ObjectCriteria(); if (!string.IsNullOrEmpty(e.ProductMasterId)) { /*long value = 0; Int64.TryParse(e.ProductMasterId, out value);*/ 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); } IList list = ProductMasterLogic.FindAll(criteria); IList returnList = new ArrayList(); if(list!=null && list.Count > 0) { foreach (ProductMaster master in list) { AddNonDuplicateItem(returnList, master); } } e.ProductMasterList = returnList; }
private void productMasterView_SearchProductMasterEvent(object sender, ProductMasterSearchOrCreateEventArgs e) { var criteria = new ObjectCriteria(); if (!string.IsNullOrEmpty(e.ProductMasterId)) { /*long value = 0; Int64.TryParse(e.ProductMasterId, out value);*/ 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); } e.ProductMasterList = ProductMasterLogic.FindAll(criteria); }
private void stockSearchView_BarcodeSearchStockEvent(object sender, StockSearchEventArgs e) { var subCriteria = new SubObjectCriteria("ProductMaster"); if(!string.IsNullOrEmpty(e.ProductMasterId)) { subCriteria.AddLikeCriteria("ProductMasterId", "%" + e.ProductMasterId + "%"); } if(!string.IsNullOrEmpty(e.ProductMasterName)) { subCriteria.AddLikeCriteria("ProductName", "%" + e.ProductMasterName + "%"); } if (e.ProductType != null) { subCriteria.AddEqCriteria("ProductType", e.ProductType); } if (e.ProductSize != null) { subCriteria.AddEqCriteria("ProductSize", e.ProductSize); } if (e.ProductColor != null) { subCriteria.AddEqCriteria("ProductColor", e.ProductColor); } if (e.Country != null) { subCriteria.AddEqCriteria("Country", e.Country); } if(e.Manufacturer!=null) { subCriteria.AddEqCriteria("Manufacturer", e.Manufacturer); } if(e.Packager!=null) { subCriteria.AddEqCriteria("Packager", e.Packager); } if (e.Distributor != null) { subCriteria.AddEqCriteria("Distributor", e.Distributor); } if (!string.IsNullOrEmpty(e.Description)) { subCriteria.AddLikeCriteria("Description", "%" + e.Description + "%"); } var criteria = new ObjectCriteria(true); criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO); bool searchByProductId = !string.IsNullOrEmpty(e.ProductId); if(searchByProductId) { criteria.AddLikeCriteria("Product.ProductId", "%" + e.ProductId + "%"); } criteria.AddSubCriteria("ProductMaster", subCriteria); criteria.AddOrder("ProductMaster.ProductName", true); criteria.AddOrder("Product.ProductId",true); IList list = StockLogic.FindAll(criteria); if(searchByProductId && e.RelevantProductFinding) { if(list!=null && list.Count > 0) { IList extraList = new ArrayList(); foreach (Stock stock in list) { Product product = stock.Product; subCriteria = new SubObjectCriteria("ProductMaster"); subCriteria.AddEqCriteria("ProductName", product.ProductMaster.ProductName); criteria = new ObjectCriteria(true); criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO); criteria.AddSubCriteria("ProductMaster", subCriteria); criteria.AddOrder("Product.ProductId", true); IList subList = StockLogic.FindAll(criteria); if(subList!=null && subList.Count > 0 ) { foreach (Stock stock1 in subList) { AddStockToList(extraList, stock1); } } } // add to original list foreach (Stock stock in extraList) { AddStockToList(list,stock); } } } e.StockList = list; }
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; } }