protected virtual IEnumerable translationHistoryRecords()
{
PXSelectBase <TranslationHistory> cmd;
TranslationEnqFilter filter = Filter.Current as TranslationEnqFilter;
this.TranslationHistoryRecords.Cache.AllowInsert = false;
this.TranslationHistoryRecords.Cache.AllowDelete = false;
this.TranslationHistoryRecords.Cache.AllowUpdate = false;
TranslationHistoryRecords.Cache.Clear();
cmd = new PXSelectOrderBy <TranslationHistory,
OrderBy <Desc <TranslationHistory.finPeriodID,
Desc <TranslationHistory.translDefId,
Asc <TranslationHistory.referenceNbr> > > > >(this);
if (filter.TranslDefId != null)
{
cmd.WhereAnd <Where <TranslationHistory.translDefId, Equal <Current <TranslationEnqFilter.translDefId> > > >();
}
if (filter.FinPeriodID != null)
{
cmd.WhereAnd <Where <TranslationHistory.finPeriodID, Equal <Current <TranslationEnqFilter.finPeriodID> > > >();
}
if (filter.Released == false)
{
cmd.WhereAnd <Where <TranslationHistory.status, NotEqual <TranslationReleased> > >();
}
if (filter.Unreleased == false)
{
cmd.WhereAnd <Where <TranslationHistory.status, NotEqual <TranslationUnReleased> > >();
}
if (filter.Voided == false)
{
cmd.WhereAnd <Where <TranslationHistory.status, NotEqual <TranslationVoided> > >();
}
foreach (PXResult <TranslationHistory> thist in cmd.Select())
{
yield return(thist);
}
}