public static WhereFilterCollection WhereColumnLike(this WhereFilterCollection query, string leftTableAlias, string leftField, string text, LikeMode mode = LikeMode.Default)
{
query.Add(new ColumnLikeWhereFilter()
{
LeftColumn = new Column(leftTableAlias, leftField),
LikeMode = mode,
Text = text
});
return(query);
}
public static WhereFilterCollection WhereColumnColumn(this WhereFilterCollection query, string leftTableAlias, string leftField, Compare comparison, string rightTableAlias, string rightField)
{
var whereFilter = new ColumnColumnWhereFilter()
{
LeftColumn = new Column(leftTableAlias, leftField),
Operator = comparison,
RightColumn = new Column(rightTableAlias, rightField)
};
query.Add(whereFilter);
return(query);
}
public static WhereFilterCollection WhereColumnValue(this WhereFilterCollection query, string leftTableAlias, string leftField, Compare comparison, string rightValue, DbType rightType, string parameterAlias = null, string isNullValue = null)
{
var whereFilter = new ColumnValueWhereFilter()
{
LeftColumn = new Column(leftTableAlias, leftField),
Operator = comparison,
RightValue = new LiteralValue(rightValue, rightType),
ParameterAlias = parameterAlias,
IsNullValue = isNullValue
};
query.Add(whereFilter);
return(query);
}
public static WhereFilterCollection WhereColumnIn(this WhereFilterCollection query, string leftTableAlias, string leftField, List <string> rightValues, DbType rightType, string parameterAlias = null)
{
var where = new ColumnInWhereFilter()
{
LeftColumn = new Column(leftTableAlias, leftField),
ParameterAlias = parameterAlias,
RightValues = new List <LiteralValue>()
};
foreach (var v in rightValues)
{
where.RightValues.Add(new LiteralValue(v, rightType));
}
query.Add(where);
return(query);
}
public static WhereFilterCollection Where(this WhereFilterCollection query, string sql)
{
query.Add(new SqlWhereFilter(sql));
return(query);
}
public static WhereFilterCollection WhereCollection(this WhereFilterCollection query, Combine groupingOperator, WhereFilterCollection collection)
{
collection.GroupingOperator = groupingOperator;
query.Add(collection);
return(query);
}
