protected virtual IEnumerable filter() { PXCache cache = this.Caches[typeof(SchedulesFilter)]; if (cache != null) { SchedulesFilter filter = cache.Current as SchedulesFilter; if (filter != null) { int startRow = 0; int totalRows = 0; filter.TotalDeferred = 0; filter.TotalScheduled = 0; foreach (SchedulesInqResult schedulesInqRow in Records.View.Select(new[] { filter }, null, PXView.Searches, null, PXView.Descendings, Records.View.GetExternalFilters(), ref startRow, 0, ref totalRows)) { filter.TotalDeferred += schedulesInqRow.SignDefAmt; filter.TotalScheduled += schedulesInqRow.SignTotalAmt; } } } yield return(cache.Current); cache.IsDirty = false; }
public virtual IEnumerable items() { SchedulesFilter filter = this.Filter.Current; if (filter != null) { PXSelectBase <DRScheduleDetail> select = new PXSelectJoin < DRScheduleDetail, InnerJoin <DRSchedule, On <DRSchedule.scheduleID, Equal <DRScheduleDetail.scheduleID> >, InnerJoin <DRDeferredCode, On <DRDeferredCode.deferredCodeID, Equal <DRScheduleDetail.defCode> > > >, Where < DRDeferredCode.accountType, Equal <Current <SchedulesFilter.accountType> >, And <DRScheduleDetail.status, Equal <DRScheduleStatus.DraftStatus>, And <DRSchedule.isCustom, Equal <True> > > > > (this); if (!string.IsNullOrEmpty(filter.DeferredCode)) { select.WhereAnd <Where <DRScheduleDetail.defCode, Equal <Current <SchedulesFilter.deferredCode> > > >(); } if (filter.BranchID != null) { select.WhereAnd <Where <DRScheduleDetail.branchID, Equal <Current <SchedulesFilter.branchID> > > >(); } if (filter.AccountID != null) { select.WhereAnd <Where <DRScheduleDetail.defAcctID, Equal <Current <SchedulesFilter.accountID> > > >(); } if (filter.SubID != null) { select.WhereAnd <Where <DRScheduleDetail.defSubID, Equal <Current <SchedulesFilter.subID> > > >(); } if (filter.BAccountID != null) { select.WhereAnd <Where <DRScheduleDetail.bAccountID, Equal <Current <SchedulesFilter.bAccountID> > > >(); } if (filter.ComponentID != null) { select.WhereAnd <Where <DRScheduleDetail.componentID, Equal <Current <SchedulesFilter.componentID> > > >(); } return(select.Select()); } else { return(null); } }
public virtual IEnumerable records() { SchedulesFilter filter = this.Filter.Current; if (filter != null) { PXSelectBase <SchedulesInqResult> select = new PXSelectJoin <SchedulesInqResult, InnerJoin <DRSchedule, On <DRSchedule.scheduleID, Equal <SchedulesInqResult.scheduleID> >, InnerJoin <DRDeferredCode, On <DRDeferredCode.deferredCodeID, Equal <SchedulesInqResult.defCode> >, LeftJoin <InventoryItem, On <InventoryItem.inventoryID, Equal <SchedulesInqResult.componentID> > > > >, Where <DRDeferredCode.accountType, Equal <Current <SchedulesFilter.accountType> > > >(this); if (!string.IsNullOrEmpty(filter.DeferredCode)) { select.WhereAnd <Where <SchedulesInqResult.defCode, Equal <Current <SchedulesFilter.deferredCode> > > >(); } if (filter.AccountID != null) { select.WhereAnd <Where <SchedulesInqResult.defAcctID, Equal <Current <SchedulesFilter.accountID> > > >(); } if (filter.SubID != null) { select.WhereAnd <Where <SchedulesInqResult.defSubID, Equal <Current <SchedulesFilter.subID> > > >(); } if (filter.BAccountID != null) { select.WhereAnd <Where <SchedulesInqResult.bAccountID, Equal <Current <SchedulesFilter.bAccountID> > > >(); } if (filter.ComponentID != null) { select.WhereAnd <Where <SchedulesInqResult.componentID, Equal <Current <SchedulesFilter.componentID> > > >(); } foreach (PXResult <SchedulesInqResult, DRSchedule, DRDeferredCode, InventoryItem> record in select.Select()) { SchedulesInqResult sd = (SchedulesInqResult)record; InventoryItem item = (InventoryItem)record; sd.ComponentCD = item.InventoryCD; sd.DocumentType = DRScheduleDocumentType.BuildDocumentType(sd.Module, sd.DocType); yield return(sd); } } else { yield break; } }
protected virtual void SchedulesFilter_AccountType_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e) { SchedulesFilter row = e.Row as SchedulesFilter; if (row != null) { row.BAccountID = null; row.DeferredCode = null; row.AccountID = null; row.SubID = null; } }
protected virtual IEnumerable filter() { PXCache cache = this.Caches[typeof(SchedulesFilter)]; if (cache != null) { SchedulesFilter filter = cache.Current as SchedulesFilter; if (filter != null) { int startRow = 0; int totalRows = 0; filter.TotalDeferred = 0; filter.TotalScheduled = 0; BqlCommand cmd = ComposeBQLCommandForRecords(filter); if (cmd == null) { yield return(cache.Current); } cmd = cmd.AggregateNew <Aggregate < Sum <SchedulesInqResult.signTotalAmt, Sum <SchedulesInqResult.signDefAmt> > > >(); PXView view = new PXView(this, true, cmd); List <object> record = view.Select(new[] { filter }, null, null, null, null, Records.View.GetExternalFilters(), ref startRow, 0, ref totalRows); if (record.Count > 0) { PXResult <SchedulesInqResult, DRSchedule, DRDeferredCode, InventoryItem> rec = (PXResult <SchedulesInqResult, DRSchedule, DRDeferredCode, InventoryItem>)record[0]; filter.TotalScheduled = ((SchedulesInqResult)rec).SignTotalAmt; filter.TotalDeferred = ((SchedulesInqResult)rec).SignDefAmt; } } } yield return(cache.Current); cache.IsDirty = false; }
public virtual BqlCommand ComposeBQLCommandForRecords(SchedulesFilter filter) { if (filter == null) { return(null); } PXSelectBase <SchedulesInqResult> select = new PXSelectJoin <SchedulesInqResult, InnerJoin <DRSchedule, On <DRSchedule.scheduleID, Equal <SchedulesInqResult.scheduleID> >, InnerJoin <DRDeferredCode, On <DRDeferredCode.deferredCodeID, Equal <SchedulesInqResult.defCode> >, LeftJoin <InventoryItem, On <InventoryItem.inventoryID, Equal <SchedulesInqResult.componentID> > > > >, Where <DRDeferredCode.accountType, Equal <Current <SchedulesFilter.accountType> > > >(this); if (!string.IsNullOrEmpty(filter.DeferredCode)) { select.WhereAnd <Where <SchedulesInqResult.defCode, Equal <Current <SchedulesFilter.deferredCode> > > >(); } if (filter.OrgBAccountID != null) { select.WhereAnd <Where <SchedulesInqResult.branchID, Inside <Current <SchedulesFilter.orgBAccountID> > > >(); //MatchWithOrg } if (filter.AccountID != null) { select.WhereAnd <Where <SchedulesInqResult.defAcctID, Equal <Current <SchedulesFilter.accountID> > > >(); } if (filter.SubID != null) { select.WhereAnd <Where <SchedulesInqResult.defSubID, Equal <Current <SchedulesFilter.subID> > > >(); } if (filter.BAccountID != null) { select.WhereAnd <Where <SchedulesInqResult.bAccountID, Equal <Current <SchedulesFilter.bAccountID> > > >(); } if (filter.ComponentID != null) { select.WhereAnd <Where <SchedulesInqResult.componentID, Equal <Current <SchedulesFilter.componentID> > > >(); } return(select.View.BqlSelect); }
public virtual IEnumerable records() { var ret = new List <SchedulesInqResult>(); int startRow = PXView.StartRow; int totalRows = 0; SchedulesFilter filter = this.Filter.Current; BqlCommand cmd = ComposeBQLCommandForRecords(filter); if (cmd == null) { return(ret); } PXView view = new PXView(this, true, cmd); foreach (PXResult <SchedulesInqResult, DRSchedule, DRDeferredCode, InventoryItem> record in view.Select( PXView.Currents, null, PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startRow, PXView.MaximumRows, ref totalRows)) { SchedulesInqResult schedulesInqResult = (SchedulesInqResult)record; InventoryItem inventoryItem = (InventoryItem)record; schedulesInqResult.ComponentCD = inventoryItem.InventoryCD; schedulesInqResult.DocumentType = DRScheduleDocumentType.BuildDocumentType(schedulesInqResult.Module, schedulesInqResult.DocType); ret.Add(schedulesInqResult); } PXView.StartRow = 0; return(ret); }
public virtual IEnumerable items() { SchedulesFilter filter = this.Filter.Current; if (filter != null) { PXSelectBase <DRScheduleDetail> select = new PXSelectJoin < DRScheduleDetail, InnerJoin <DRSchedule, On <DRSchedule.scheduleID, Equal <DRScheduleDetail.scheduleID> >, InnerJoin <DRDeferredCode, On <DRDeferredCode.deferredCodeID, Equal <DRScheduleDetail.defCode> > > >, Where < DRDeferredCode.accountType, Equal <Current <DRDraftScheduleProc.SchedulesFilter.accountType> >, And <DRScheduleDetail.status, Equal <DRScheduleStatus.DraftStatus>, And <DRSchedule.isCustom, Equal <True> > > >, OrderBy < Asc <DRScheduleDetail.scheduleID, Asc <DRScheduleDetail.componentID, Asc <DRScheduleDetail.detailLineNbr> > > > > (this); BqlCommand command = select.View.BqlSelect; if (!string.IsNullOrEmpty(filter.DeferredCode)) { command = command.WhereAnd <Where <DRScheduleDetail.defCode, Equal <Current <SchedulesFilter.deferredCode> > > >(); } if (filter.BranchID != null) { command = command.WhereAnd <Where <DRScheduleDetail.branchID, Equal <Current <SchedulesFilter.branchID> > > >(); } if (filter.AccountID != null) { command = command.WhereAnd <Where <DRScheduleDetail.defAcctID, Equal <Current <SchedulesFilter.accountID> > > >(); } if (filter.SubID != null) { command = command.WhereAnd <Where <DRScheduleDetail.defSubID, Equal <Current <SchedulesFilter.subID> > > >(); } if (filter.BAccountID != null) { command = command.WhereAnd <Where <DRScheduleDetail.bAccountID, Equal <Current <SchedulesFilter.bAccountID> > > >(); } if (filter.ComponentID != null) { command = command.WhereAnd <Where <DRScheduleDetail.componentID, Equal <Current <SchedulesFilter.componentID> > > >(); } return(command.CreateView(this, mergeCache: !select.View.IsReadOnly).SelectExternalWithPaging()); } else { return(null); } }
public virtual IEnumerable records() { var ret = new List <SchedulesInqResult>(); int startRow = PXView.StartRow; int totalRows = 0; SchedulesFilter filter = this.Filter.Current; if (filter != null) { PXSelectBase <SchedulesInqResult> select = new PXSelectJoin <SchedulesInqResult, InnerJoin <DRSchedule, On <DRSchedule.scheduleID, Equal <SchedulesInqResult.scheduleID> >, InnerJoin <DRDeferredCode, On <DRDeferredCode.deferredCodeID, Equal <SchedulesInqResult.defCode> >, LeftJoin <InventoryItem, On <InventoryItem.inventoryID, Equal <SchedulesInqResult.componentID> > > > >, Where <DRDeferredCode.accountType, Equal <Current <SchedulesFilter.accountType> > > >(this); if (!string.IsNullOrEmpty(filter.DeferredCode)) { select.WhereAnd <Where <SchedulesInqResult.defCode, Equal <Current <SchedulesFilter.deferredCode> > > >(); } if (filter.AccountID != null) { select.WhereAnd <Where <SchedulesInqResult.defAcctID, Equal <Current <SchedulesFilter.accountID> > > >(); } if (filter.SubID != null) { select.WhereAnd <Where <SchedulesInqResult.defSubID, Equal <Current <SchedulesFilter.subID> > > >(); } if (filter.BAccountID != null) { select.WhereAnd <Where <SchedulesInqResult.bAccountID, Equal <Current <SchedulesFilter.bAccountID> > > >(); } if (filter.ComponentID != null) { select.WhereAnd <Where <SchedulesInqResult.componentID, Equal <Current <SchedulesFilter.componentID> > > >(); } foreach (PXResult <SchedulesInqResult, DRSchedule, DRDeferredCode, InventoryItem> record in select.View.Select( PXView.Currents, null, PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startRow, PXView.MaximumRows, ref totalRows)) { SchedulesInqResult schedulesInqResult = (SchedulesInqResult)record; InventoryItem inventoryItem = (InventoryItem)record; schedulesInqResult.ComponentCD = inventoryItem.InventoryCD; schedulesInqResult.DocumentType = DRScheduleDocumentType.BuildDocumentType(schedulesInqResult.Module, schedulesInqResult.DocType); ret.Add(schedulesInqResult); } } PXView.StartRow = 0; return(ret); }