/// <summary>
/// Not operator.
/// </summary>
/// <param name="def">Relation definition.</param>
/// <returns>Condition phrase.</returns>
public static APSqlConditionPhrase operator !(APRelationDef def)
{
APSqlConditionPhrase phrase = new APSqlConditionPhrase(def);
phrase.IsNot = !phrase.IsNot;
return(phrase);
}
/// <summary>
/// Not operator.
/// </summary>
/// <param name="def">Relation definition.</param>
/// <returns>Condition phrase.</returns>
public static APSqlConditionPhrase operator !(APRelationDef def)
{
APSqlConditionPhrase phrase = new APSqlConditionPhrase(def);
phrase.IsNot = !phrase.IsNot;
return phrase;
}
private void WriteConditionPhrase(ParserWriter writer, APSqlWherePhrase phrase, APSqlConditionJoinType join, OracleCommand dbCmd)
{
bool isFirst = true;
writer.Write("(");
while (phrase != null)
{
if (!isFirst)
{
writer.Write(join.ToString());
}
if (phrase.IsNot)
{
writer.Write("NOT (");
}
if (phrase is APSqlConditionAndPhrase)
{
WriteConditionPhrase(writer, (phrase as APSqlConditionAndPhrase).Child, APSqlConditionJoinType.AND, dbCmd);
}
else if (phrase is APSqlConditionOrPhrase)
{
WriteConditionPhrase(writer, (phrase as APSqlConditionOrPhrase).Child, APSqlConditionJoinType.OR, dbCmd);
}
else
{
APSqlConditionPhrase cond = phrase as APSqlConditionPhrase;
// for this, if columnDef is null, mean this is a 'EXISTS ( subquery )' phrase
// do not
// change to check ConditionOperator.
if (cond.ConditionOperator != APSqlConditionOperator.Exists && cond.ConditionOperator != APSqlConditionOperator.NotExists)
{
WriteSelectExpression(writer, cond.Expr);
}
if (cond.ConditionOperator == APSqlConditionOperator.Equals /*&& !cond.IsRelationDef*/ && (cond.Value == null || cond.Value == DBNull.Value))
{
writer.Write("IS NULL");
}
else if (cond.ConditionOperator == APSqlConditionOperator.NotEqual /*&& !cond.IsRelationDef*/ && (cond.Value == null || cond.Value == DBNull.Value))
{
writer.Write("IS NOT NULL");
}
else
{
switch (cond.ConditionOperator)
{
case APSqlConditionOperator.Equals: writer.Write("="); break;
case APSqlConditionOperator.NotEqual: writer.Write("<>"); break;
case APSqlConditionOperator.GreaterThan: writer.Write(">"); break;
case APSqlConditionOperator.GreaterThanOrEqual: writer.Write(">="); break;
case APSqlConditionOperator.LessThan: writer.Write("<"); break;
case APSqlConditionOperator.LessThanOrEqual: writer.Write("<="); break;
case APSqlConditionOperator.Between: writer.Write("BETWEEN"); break;
case APSqlConditionOperator.NotBetween: writer.Write("NOT BETWEEN"); break;
case APSqlConditionOperator.Like: writer.Write("LIKE"); break;
case APSqlConditionOperator.NotLike: writer.Write("NOT LIKE"); break;
case APSqlConditionOperator.In: writer.Write("IN"); break;
case APSqlConditionOperator.NotIn: writer.Write("NOT IN"); break;
case APSqlConditionOperator.Exists: writer.Write("EXISTS"); break;
case APSqlConditionOperator.NotExists: writer.Write("NOT EXISTS"); break;
}
object value = cond.Value;
if (!TryWriteValue(writer, value))
{
if (value is APSqlSelectCommand)
{
switch (cond.SubQueryScalarRestrict)
{
case APSqlSubQueryScalarRestrict.All: writer.Write("ALL"); break;
case APSqlSubQueryScalarRestrict.Some: writer.Write("SOME"); break;
case APSqlSubQueryScalarRestrict.Any: writer.Write("ANY"); break;
}
writer.Write("(");
int idented = writer.Idented++;
writer.WriteLine();
ParseSelectInternal(value as APSqlSelectCommand, dbCmd, writer);
writer.Idented = idented;
writer.Write(")");
}
else
{
if (cond.ConditionOperator == APSqlConditionOperator.In || cond.ConditionOperator == APSqlConditionOperator.NotIn)
{
writer.Write("(");
int i = 0;
foreach (object val in value as Array)
{
if (i != 0)
{
writer.Write(',');
}
string paramName = writer.GetSuitableParameterName(cond.ParamName);
paramName = String.Format("v_{0}${1}", paramName, i);
writer.Write(":" + paramName);
AddParameter(dbCmd, paramName, val, ParameterDirection.Input);
i++;
}
writer.Write(")");
}
else if (cond.ConditionOperator == APSqlConditionOperator.Between || cond.ConditionOperator == APSqlConditionOperator.NotBetween)
{
object begin = (value as Array).GetValue(0);
object end = (value as Array).GetValue(1);
if (!TryWriteValue(writer, begin))
{
string paramName = writer.GetSuitableParameterName(cond.ParamName);
writer.Write(":" + paramName);
AddParameter(dbCmd, paramName, begin, ParameterDirection.Input);
}
writer.Write("AND");
if (!TryWriteValue(writer, end))
{
string paramName = writer.GetSuitableParameterName(cond.ParamName);
writer.Write(":" + paramName);
AddParameter(dbCmd, paramName, end, ParameterDirection.Input);
}
}
else
{
string paramName = writer.GetSuitableParameterName(cond.ParamName);
writer.Write(":" + paramName);
AddParameter(dbCmd, paramName, value, ParameterDirection.Input);
}
}
}
}
}
if (phrase.IsNot)
{
writer.Write(")");
}
isFirst = false;
phrase = phrase.Next as APSqlWherePhrase;
}
writer.Write(")");
}
