protected virtual IEnumerable billed()
{
UsageFilter filter = Filter.Current;
if (filter == null)
{
return(new List <PMTran>());
}
PXSelectBase <PMTran> select = new PXSelectJoin <
PMTran,
LeftJoin <CRCase,
On <CRCase.noteID, Equal <PMTran.origRefID>,
Or <CRCase.caseID, Equal <PMTran.caseID> > > >,
Where <
PMTran.billed, Equal <True>,
And <PMTran.projectID, Equal <Current <UsageFilter.contractID> > > > >
(this);
if (!string.IsNullOrEmpty(filter.InvFinPeriodID))
{
FinPeriod finPeriod = PXSelect <FinPeriod, Where <FinPeriod.finPeriodID, Equal <Current <UsageFilter.invFinPeriodID> > > > .Select(this);
if (finPeriod != null)
{
select.WhereAnd <Where <PMTran.billedDate, Between <Required <FinPeriod.startDate>, Required <FinPeriod.endDate> > > >();
}
}
return(select.Select());
}
protected virtual void UsageFilter_RowSelected(PXCache sender, PXRowSelectedEventArgs e)
{
UsageFilter row = e.Row as UsageFilter;
if (row != null)
{
UnBilled.Cache.AllowInsert = row.ContractID != null && (row.ContractStatus == Contract.status.Active || row.ContractStatus == Contract.status.InUpgrade);
}
}
