public static Cond NotIn(Expr expr, List <Constant> values)
{
Cond oper = new Cond();
OmConstantCollection col = new OmConstantCollection();
for (int i = 0; i < values.Count; i++)
{
col.Add(values[i].Const);
}
oper.Term = WhereTerm.CreateNotIn(expr.Expression, col);
return(oper);
}
/// <summary>
/// Renders a list of values
/// </summary>
/// <param name="builder"></param>
/// <param name="values"></param>
/// <returns></returns>
protected virtual void ConstantList(StringBuilder builder, OmConstantCollection values)
{
for (int i = 0; i < values.Count; i++)
{
OmConstant val = values[i];
Constant(builder, val);
if (i != values.Count - 1)
{
Coma(builder);
}
}
}
/// <summary>
/// Creates a WhereTerm which represents SQL IN clause
/// </summary>
/// <param name="expr">Expression to be looked up</param>
/// <param name="values">List of values</param>
/// <returns></returns>
static Cond In(Expr expr, List <Constant> values)
{
OmConstantCollection col = new OmConstantCollection();
for (int i = 0; i < values.Count; i++)
{
col.Add(values[i].Const.Value);
}
Cond term = new Cond();
term.Term = WhereTerm.CreateIn(expr.Expression, col);
return(term);
}
