Пример #1
0
    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());
    }
Пример #2
0
    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());
    }
Пример #3
0
    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());
    }
Пример #4
0
    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());
    }