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;
}
}
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 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);
}
