public string FormatValue(QItem Value, IDbCommand command = null)
{
if (Value == null)
{
return(string.Empty);
}
if (Value is QQuery && ((QQuery)Value).Table != null)
{
QQuery squery = (QQuery)Value;
if (squery.Columns.Count == 0)
{
squery.Columns.Add(new QColumn(squery.Table.PrimaryKey));
}
return("(" + squery.Format(command) + ")");
}
else if (Value is QExpression)
{
return("(" + Value.Format(command) + ")");
}
else
{
return(Value.Format(command));
}
}
public override string Format(IDbCommand command = null)
{
string f1 = value1?.Format(command) ?? string.Empty;
string f2 = value2?.Format(command) ?? string.Empty;
if (f1.Length == 0 || f2.Length == 0)
{
return(string.Empty);
}
if (Query?.Table?.Schema?.System == DBSystem.MSSql ||
Query?.Table?.Schema?.System == DBSystem.Postgres ||
Query?.Table?.Schema?.System == DBSystem.SQLite)
{
return(f1 + " and " + f2);
}
else
{
return(string.Format("({0}, {1})", f1, f2));
}
}
