PXResultset<CSCalendarDate> calendarResults = PXSelect<CSCalendarDate,
Where<CSCalendarDate.calendarID, In<Required<CSCalendarDate.calendarID>>>,
OrderBy<Asc<CSCalendarDate.calendarID>>>
.Select(Base, (object)calendarIDs);
List<CSCalendarDate> calendarDates = new List<CSCalendarDate>();
foreach (PXResult<CSCalendarDate> res in calendarResults)
{
CSCalendarDate dateRow = res;
calendarDates.Add(dateRow);
}
I have error at this in calendarResults row.
Cannot create an abstract class.
Its my DAC:
[Serializable]
[PXCacheName(Messages.CalendarDate)]
[PXProjection(typeof(SelectBase<CSCalendarDate,
LeftJoin<CSCalendarExceptions, On<CSCalendarDate.date, Equal<CSCalendarExceptions.date>,
And<CSCalendarExceptions.workDay, Equal<False>>>>,
Where<CSCalendarExceptions.date, IsNull>,
Aggregate<GroupBy<CSCalendarDate.date, GroupBy<CSCalendarDate.calendarID>>>,
OrderBy<Asc<CSCalendarDate.date>>>), Persistent = false)]
public class CSCalendarDate : PXBqlTable, IBqlTable
{
#region CalendarID
public abstract class calendarID : PX.Data.BQL.BqlString.Field<calendarID> { }
[PXDBString(10, IsUnicode = true, BqlTable = typeof(CSCalendarDate))]
public virtual string CalendarID { get; set; }
#endregion
#region Date
public abstract class date : PX.Data.BQL.BqlDateTime.Field<date> { }
[PXDBDate(BqlTable = typeof(CSCalendarDate))]
public virtual DateTime? Date { get; set; }
#endregion
}