public SelectStatement Where(SelectColumn selectColumn, Operator @operator, string value1, string value2)
{
WhereColumn whereColumn = new WhereColumn(selectColumn.Join, selectColumn.ColumnDef, selectColumn.Statement, @operator, value1, value2);
WhereColumns.Add(whereColumn);
return(this);
}
public SelectStatement Where(string column, Operator @operator, string value1, string value2)
{
GetJoinAndColumnDef(column, (join, columnDef) =>
{
WhereColumn whereColumn = new WhereColumn(@join, columnDef, null, @operator, value1, value2);
WhereColumns.Add(whereColumn);
});
return(this);
}
private bool IsParamRequired(WhereColumn whereColumn)
{
switch (whereColumn.Operator)
{
case Operator.IsFalse:
case Operator.IsTrue:
case Operator.IsNull:
case Operator.IsNotNull:
return(false);
}
return(true);
}