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