示例#1
0
        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());
        }
示例#2
0
        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);
        }