protected virtual IEnumerable ViewInventoryTranDet(PXAdapter adapter) { if ((this.ResultRecords.Current != null) && (this.Filter.Current != null)) { INItemSiteHist res = this.ResultRecords.Current; InventoryTranSumEnqFilter currentFilter = this.Filter.Current; InventoryTranDetEnq graph = PXGraph.CreateInstance <InventoryTranDetEnq>(); graph.Filter.Current.ByFinancialPeriod = currentFilter.ByFinancialPeriod; graph.Filter.Current.FinPeriodID = currentFilter.FinPeriodID; graph.Filter.Current.InventoryID = res.InventoryID; if (res.SubItemID != null) { INSubItem foundSubItem = INSubItem.PK.Find(graph, res.SubItemID); if (foundSubItem != null) { graph.Filter.Current.SubItemCD = foundSubItem.SubItemCD; } } graph.Filter.Current.SiteID = res.SiteID; // possibly null graph.Filter.Current.LocationID = res.LocationID; throw new PXRedirectRequiredException(graph, "Inventory Transaction Details"); } return(adapter.Get()); }
public virtual IEnumerable nextperiod(PXAdapter adapter) { InventoryTranSumEnqFilter filter = Filter.Current as InventoryTranSumEnqFilter; FinPeriod nextperiod = FinPeriodRepository.FindNextPeriod(FinPeriod.organizationID.MasterValue, filter.FinPeriodID, looped: true); filter.FinPeriodID = nextperiod?.FinPeriodID; return(adapter.Get()); }
public virtual IEnumerable nextperiod(PXAdapter adapter) { InventoryTranSumEnqFilter filter = Filter.Current as InventoryTranSumEnqFilter; FinPeriod nextperiod = PXSelect <FinPeriod, Where <FinPeriod.finPeriodID, Greater <Current <InventoryTranSumEnqFilter.finPeriodID> > >, OrderBy <Asc <FinPeriod.finPeriodID> > > .SelectWindowed(this, 0, 1); if (nextperiod == null) { nextperiod = PXSelectOrderBy <FinPeriod, OrderBy <Asc <FinPeriod.finPeriodID> > > .SelectWindowed(this, 0, 1); } filter.FinPeriodID = nextperiod.FinPeriodID; return(adapter.Get()); }
public virtual IEnumerable previousperiod(PXAdapter adapter) { InventoryTranSumEnqFilter filter = Filter.Current as InventoryTranSumEnqFilter; FinPeriod nextperiod = PXSelect <FinPeriod, Where <FinPeriod.finPeriodID, Less <Current <InventoryTranSumEnqFilter.finPeriodID> > >, OrderBy <Desc <FinPeriod.finPeriodID> > > .SelectWindowed(this, 0, 1); if (nextperiod == null) { nextperiod = PXSelectOrderBy <FinPeriod, OrderBy <Desc <FinPeriod.finPeriodID> > > .SelectWindowed(this, 0, 1); if (nextperiod == null) { yield return(filter); } } filter.FinPeriodID = nextperiod.FinPeriodID; yield return(filter); }