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 departmentStockDetailView_SearchDepartmentStockInDetailEvent(object sender, DepartmentStockDetailEventArgs e) { long deptId = CurrentDepartment.Get().DepartmentId; var objectCriteria = new ObjectCriteria(true); objectCriteria.AddEqCriteria("s.DelFlg", CommonConstants.DEL_FLG_NO); objectCriteria.AddEqCriteria("pm.ProductMasterId", e.ProductMasterId); objectCriteria.AddEqCriteria("s.DepartmentStockInDetailPK.DepartmentId", deptId); objectCriteria.AddGreaterOrEqualsCriteria("deptStockIn.StockInDate", e.StockInDateFrom); objectCriteria.AddLesserOrEqualsCriteria("deptStockIn.StockInDate", e.StockInDateTo); e.DepartmentStockInDetailList = DepartmentStockInDetailLogic.FindByQuery(objectCriteria); e.ProductPrice = DepartmentPriceLogic.FindById(new DepartmentPricePK { ProductMasterId = e.ProductMasterId, DepartmentId = deptId }); }
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 goodsIOSearchView_DeleteBlockInDetailEvent(object sender, GoodsIOSearchEventArgs e) { // validate delete items // delete BlockInDetailLogic.DeleteList(e.DeleteList); // search again 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); }
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_RemainSearchStockEvent(object sender, StockSearchEventArgs e) { var criteria = new ObjectCriteria(); criteria.AddEqCriteria("DelFlg", (long)0); criteria.AddLesserOrEqualsCriteria("CreateDate", e.FromDate); IList deptStockInDetailFromList = DepartmentStockInDetailLogic.FindAll(criteria); criteria.AddNotEqualsCriteria("StockInType", (long)1); IList stockInDetailFromList = StockInDetailLogic.FindAll(criteria); criteria = new ObjectCriteria(); criteria.AddEqCriteria("DelFlg", (long)0); criteria.AddLesserOrEqualsCriteria("CreateDate", e.ToDate); IList deptStockInDetailToList = DepartmentStockInDetailLogic.FindAll(criteria); criteria.AddNotEqualsCriteria("StockInType", (long)1); IList stockInDetailToList = StockInDetailLogic.FindAll(criteria); // IList stockHistoryList = StockHistoryLogic.FindByMaxDate(criteria); var reportList = new List<UniversalStockReportObject>(); // calculate dau` ton` foreach (StockInDetail stockInDetail in stockInDetailFromList) { UniversalStockReportObject report = null; foreach (var reportObject in reportList) { if (stockInDetail.Product.ProductMaster.ProductMasterId.Equals(reportObject.ProductMaster.ProductMasterId)) { report = reportObject; break; } } if (report != null) { report.StockStartQuantity += stockInDetail.Quantity; report.StockInStartQuantity += stockInDetail.Quantity; } else { report = new UniversalStockReportObject(); reportList.Add(report); report.StockStartQuantity = stockInDetail.Quantity; report.StockInStartQuantity = stockInDetail.Quantity; } report.ProductMaster = stockInDetail.Product.ProductMaster; foreach (DepartmentStockInDetail deptStockInDetail in deptStockInDetailFromList) { if (report.ProductMaster.ProductMasterId.Equals(deptStockInDetail.Product.ProductMaster.ProductMasterId)) { report.StockStartQuantity -= deptStockInDetail.Quantity; report.DepartmentStockInStartQuantity += deptStockInDetail.Quantity; } } reportList.Add(report); } // calculate cuoi ton foreach (StockInDetail stockInDetail in stockInDetailToList) { UniversalStockReportObject report = null; foreach (var reportObject in reportList) { if (stockInDetail.Product.ProductMaster.ProductMasterId.Equals(reportObject.ProductMaster.ProductMasterId)) { report = reportObject; break; } } if (report != null) { report.StockEndQuantity += stockInDetail.Quantity; report.StockInEndQuantity += stockInDetail.Quantity; } else { report = new UniversalStockReportObject(); report.ProductMaster = stockInDetail.Product.ProductMaster; reportList.Add(report); report.StockEndQuantity = stockInDetail.Quantity; report.StockInEndQuantity = stockInDetail.Quantity; } foreach (DepartmentStockInDetail deptStockInDetail in deptStockInDetailToList) { if (report.ProductMaster.ProductMasterId.Equals(deptStockInDetail.Product.ProductMaster.ProductMasterId)) { report.StockEndQuantity -= deptStockInDetail.Quantity; report.DepartmentStockInEndQuantity += deptStockInDetail.Quantity; } } // foreach (StockHistory stockHistory in stockHistoryList) // { // if (report.ProductMaster.ProductMasterId.Equals(stockHistory.Product.ProductMaster.ProductMasterId)) // { // report.LostCount += stockHistory.LostCount; // report.GoodCount += stockHistory.GoodCount; // report.ErrorCount += stockHistory.ErrorCount; // report.DamageCount += stockHistory.DamageCount; // } // } } e.ReportList = reportList; }