public override string ToString()
{
StringBuilder sb = new StringBuilder();
if (inputs.getInput_atIndex(0) == null)
{
sb.AppendLine("UPDATE error::NoTable SET ");
}
else
{
sb.AppendLine("UPDATE " + inputs.getInput_atIndex(0).ToString() + " SET");
if (inputs.getInput_atIndex(1) != null)
{
TabTool.incromentCount();
sb.AppendLine(TabTool.TabCount() + inputs.getInput_atIndex(1).ToString());
TabTool.deccromentCount();
}
if (inputs.getInput_atIndex(2) != null)
{
TabTool.incromentCount();
sb.AppendLine(TabTool.TabCount() + inputs.getInput_atIndex(2).ToString());
TabTool.deccromentCount();
}
}
return(sb.ToString());
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
sb.Append("WHERE ");
if (inputs.getInput_atIndex(0) != null)
{
sb.AppendLine("(");
TabTool.incromentCount();
sb.Append(TabTool.TabCount() + inputs.getInput_atIndex(0).ToString());
TabTool.deccromentCount();
sb.AppendLine(TabTool.TabCount() + ")");
}
if (inputs.getInput_atIndex(1) != null)
{
TabTool.incromentCount();
sb.Append(TabTool.TabCount() + inputs.getInput_atIndex(1).ToString());
TabTool.deccromentCount();
}
return(sb.ToString());
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
if (inputs.getInput_atIndex(0) == null)
{
sb.Append("INSERT INTO error::NoTable SET ");
}
else
{
sb.AppendLine("INSERT INTO " + inputs.getInput_atIndex(0).ToString() + " VALUES");
}
if (inputs.getInput_atIndex(1) != null)
{
sb.AppendLine("(");
TabTool.incromentCount();
sb.AppendLine(TabTool.TabCount() + inputs.getInput_atIndex(1).ToString());
TabTool.deccromentCount();
sb.AppendLine(")");
}
return(sb.ToString());
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
Vid_Object obj = inputs.getInput_atIndex(0);
if (obj == null ||
inputs.getInput_atIndex(1) == null)
{
sb.Append("");
}
else
{
switch (conditionType)
{
case WhereStatment_Type.LESS:
sb.Append(" " + inputs.getInput_atIndex(0).ToString());
sb.Append(" < " + inputs.getInput_atIndex(1).ToString() + " ");
break;
case WhereStatment_Type.LESS_EQU:
sb.Append(" " + inputs.getInput_atIndex(0).ToString());
sb.Append(" <= " + inputs.getInput_atIndex(1).ToString() + " ");
break;
case WhereStatment_Type.GREATER:
sb.Append(" " + inputs.getInput_atIndex(0).ToString());
sb.Append(" > " + inputs.getInput_atIndex(1).ToString() + " ");
break;
case WhereStatment_Type.GREATER_EQU:
sb.Append(" " + inputs.getInput_atIndex(0).ToString());
sb.Append(" >= " + inputs.getInput_atIndex(1).ToString() + " ");
break;
case WhereStatment_Type.EQU:
sb.Append(" " + inputs.getInput_atIndex(0).ToString());
sb.Append(" = " + inputs.getInput_atIndex(1).ToString() + " ");
break;
case WhereStatment_Type.NOT_EQU:
sb.Append(" " + inputs.getInput_atIndex(0).ToString());
sb.Append(" <> " + inputs.getInput_atIndex(1).ToString() + " ");
break;
case WhereStatment_Type.IN:
sb.Append(inputs.getInput_atIndex(0).ToString());
sb.Append(" IN ");
sb.AppendLine(TabTool.TabCount() + "(");
TabTool.incromentCount();
sb.AppendLine(TabTool.TabCount() + inputs.getInput_atIndex(1).ToString());
TabTool.deccromentCount();
sb.AppendLine(TabTool.TabCount() + ")");
break;
case WhereStatment_Type.EXISTS:
if (obj.output_dataType != VidData_Type.DATABASE_COL)
{
sb.AppendLine("EXISTS");
sb.Append("( " + inputs.getInput_atIndex(1).ToString() + " )");
}
break;
case WhereStatment_Type.NOT_EXISTS:
if (obj.output_dataType != VidData_Type.DATABASE_COL)
{
sb.AppendLine("NOT EXISTS");
sb.Append("( " + inputs.getInput_atIndex(1).ToString() + " )");
}
break;
case WhereStatment_Type.LIKE:
sb.Append(inputs.getInput_atIndex(0).ToString());
sb.Append(" LIKE");
sb.AppendLine(" " + inputs.getInput_atIndex(1).ToString() + " ");
break;
default:
break;
}
}
return(sb.ToString());
}
