private string GetRelationString(ColumnConditionDefinition columnCondition)
{
StringBuilder stringBuilder = new StringBuilder();
switch (columnCondition.Relation)
{
case Relations.Equals:
stringBuilder.Append($"{columnCondition.ColumnName} = '{columnCondition.Value1}'");
break;
case Relations.NotEqual:
stringBuilder.Append($"{columnCondition.ColumnName} <> '{columnCondition.Value1}'");
break;
case Relations.BiggerThan:
stringBuilder.Append($"{columnCondition.ColumnName} > '{columnCondition.Value1}'");
break;
case Relations.BiggerEquals:
stringBuilder.Append($"{columnCondition.ColumnName} >= '{columnCondition.Value1}'");
break;
case Relations.SmallerThan:
stringBuilder.Append($"{columnCondition.ColumnName} < '{columnCondition.Value1}'");
break;
case Relations.SmallerEquals:
stringBuilder.Append($"{columnCondition.ColumnName} <= '{columnCondition.Value1}'");
break;
case Relations.Between:
stringBuilder.Append($"{columnCondition.ColumnName} BETWEEN '{columnCondition.Value1}' AND '{columnCondition.Value2}'");
break;
case Relations.IsNull:
stringBuilder.Append($"{columnCondition.ColumnName} IS NULL");
break;
case Relations.IsNotNull:
stringBuilder.Append($"{columnCondition.ColumnName} IS NOT NULL");
break;
}
return(stringBuilder.ToString());
}
public IRelation <TComplete> Column(string columnName)
{
CurrentColumnCondition = new ColumnConditionDefinition(columnName);
CurrentSelectCondition = new SelectConditionDefinition <IConjunction <TComplete> >(columnName);
return((IRelation <TComplete>)(object) this);
}
