void InheritColumns(SubPanelSequentialSqlSet set)
{
PersonId = new Column(set.PersonId, this);
EncounterId = new Column(set.EncounterId, this);
Date = new AutoAliasedColumn(set.Date, this);
EventId = new EventIdColumn(set.EventId, this);
}
void SetSelect()
{
var first = this.First() as PanelItemSequentialSqlSet;
PersonId = new Column(first.PersonId);
EncounterId = new Column(first.EncounterId);
Date = new AutoAliasedColumn(first.Date.Name, first.Date.AliasMarker);
EventId = new EventIdColumn(first.EventId);
}
void SetColumns()
{
var aliasMarker = compilerOptions.Alias;
PersonId = new Column(compilerOptions.FieldPersonId);
if (concept.IsEncounterBased)
{
EncounterId = new Column(compilerOptions.FieldEncounterId);
Date = new AutoAliasedColumn(concept.SqlFieldDate, aliasMarker, this);
}
if (concept.IsEventBased)
{
EventId = new EventIdColumn(concept.SqlFieldEvent, aliasMarker, this);
}
else
{
EventId = new EventIdColumn();
}
}
void CheckNumericFilter()
{
if (panelitem.UseNumericFilter)
{
Number = new AutoAliasedColumn(concept.SqlFieldNumeric, compilerOptions.Alias, this);
var val1 = panelitem.NumericFilter.Filter[0];
switch (panelitem.NumericFilter.FilterType)
{
case NumericFilterType.GreaterThan:
where.Add(Number > val1);
return;
case NumericFilterType.GreaterThanOrEqualTo:
where.Add(Number >= val1);
return;
case NumericFilterType.LessThan:
where.Add(Number < val1);
return;
case NumericFilterType.LessThanOrEqualTo:
where.Add(Number <= val1);
return;
case NumericFilterType.EqualTo:
where.Add(Number == val1);
return;
case NumericFilterType.Between:
var val2 = panelitem.NumericFilter.Filter[1];
where.Add(Number == val1 & val2);
return;
default:
return;
}
}
}
public AutoAliasedColumn(AutoAliasedColumn col, IAliasedSet set) : base(col.Name)
{
Name = col.Name;
AliasMarker = col.AliasMarker;
Set = set;
}