private static QueryFilterOperation NewOperation(string name, string format)
{
QueryFilterOperation op = new QueryFilterOperation(name, format);
filters[name] = op;
return(op);
}
public override string FilterValues()
{
UpdateValues();
QueryFilterOperation op = QueryFilterOperation.GetByName(Filter);
if (op == null)
{
return(null);
}
else
{
return(op.FilterSql(false, Column, Value1, Value2));
}
}
public override string FilterValues()
{
UpdateValues();
string pv = Statement.EscapeQuotes(Value1);
string pv2 = (spinButton2 == null) ? null : Statement.EscapeQuotes(Value2);
QueryFilterOperation op = QueryFilterOperation.GetByName(Filter);
if (op == null)
{
return(null);
}
else
{
return(op.FilterSql(false, String.Format("(strftime(\"%s\", current_timestamp) - {0})", Column), pv, pv2));
}
}
public override string FilterValues()
{
UpdateValues();
string val1 = Statement.EscapeQuotes(Value1.ToLower());
string col = String.Format("lower({0})", Column);
QueryFilterOperation op = QueryFilterOperation.GetByName(Filter);
if (op == null)
{
return(null);
}
else
{
return(op.FilterSql(true, col, val1, null));
}
}
private static QueryFilterOperation NewOperation(string name, string format)
{
QueryFilterOperation op = new QueryFilterOperation(name, format);
filters[name] = op;
return op;
}
