public string GetSelectExpression()
{
var sb = new StringBuilder();
m_condition.Render(sb);
return(sb.ToString());
}
public void Render(StringBuilder sb)
{
sb.Append("(");
m_subject.Render(sb);
sb.Append(" IN (");
var first = true;
foreach (var i in m_items)
{
if (!first)
{
sb.Append(", ");
}
first = false;
if (i is string)
{
sb.Append($"'{i}'");
}
else
{
sb.Append(i);
}
}
sb.Append("))");
}
public void Render(StringBuilder sb)
{
var sqlTypeName = SqlTypeMapper.GetSqlTypeName(m_targetType, 0);
if (string.IsNullOrWhiteSpace(sqlTypeName))
{
m_operand.Render(sb);
return;
}
sb.Append("CAST(");
m_operand.Render(sb);
sb.Append(" AS ");
sb.Append(sqlTypeName);
sb.Append(")");
}
public void Render(StringBuilder sb)
{
sb.Append(m_operation).Append("(");
m_left.Render(sb);
sb.Append(", ");
m_right.Render(sb);
sb.Append(")");
}
public void Render(StringBuilder sb)
{
sb.Append("(");
m_mappedLeft.Render(sb);
sb.Append(" LIKE ");
m_mappedRight.Render(sb);
sb.Append(")");
}
public void Render(StringBuilder sb)
{
sb.Append("(");
m_operand.Render(sb);
sb.Append(" IN ");
m_itemsSegment.Render(sb);
sb.Append(")");
}
public void Render(StringBuilder sb)
{
var nullRight = m_right as ConstantSegment;
if ((nullRight != null) && nullRight.IsNull &&
((m_symbol == s_supportedSymbols[ExpressionType.Equal]) ||
(m_symbol == s_supportedSymbols[ExpressionType.NotEqual])))
{
RenderNullCheck(sb, m_symbol == s_supportedSymbols[ExpressionType.Equal]);
return;
}
sb.Append("(");
m_left.Render(sb);
sb.Append(m_symbol);
m_right.Render(sb);
sb.Append(")");
}
public static void RenderBoolean(this IQuerySegment segment, StringBuilder target)
{
var bRend = segment as IBooleanSegment;
if (bRend != null)
{
bRend.RenderAsBoolean(target);
return;
}
segment.Render(target);
}
