public override void Visit(WProcedureStatement node)
{
for (int i = 0; i < node.StatementList.Count; i++)
{
var statement = node.StatementList[i];
if (statement is WSelectStatement)
{
var sqlSelect = statement as WSelectStatement;
node.StatementList[i] = ConvertSqlSelectStatement(sqlSelect);
}
else if (statement is WInsertSpecification)
{
var sqlInsert = statement as WInsertSpecification;
node.StatementList[i] = ConvertSqlInsertStatement(sqlInsert);
}
else if (statement is WDeleteSpecification)
{
var sqlDelete = statement as WDeleteSpecification;
node.StatementList[i] = ConvertSqlDeleteStatement(sqlDelete);
}
else
{
statement.Accept(this);
}
}
}
public override void Visit(WProcedureStatement node)
{
base.Visit(node);
node.StatementList = Translate(node.StatementList);
}
public virtual void Visit(WProcedureStatement node)
{
node.AcceptChildren(this);
}
public virtual void Visit(WProcedureStatement node)
{
node.AcceptChildren(this);
}
/// <summary>
/// Records the declared parameter in the Store Procedure Statement
/// </summary>
/// <param name="node"></param>
public override void Visit(WProcedureStatement node)
{
var upperPar = _variables;
if (node.Parameters != null)
{
if (_variables == null)
{
_variables = new List<DeclareVariableElement>();
}
else
{
_variables = new List<DeclareVariableElement>(_variables);
}
foreach (var parameter in node.Parameters)
{
_variables.Add(parameter);
}
}
base.Visit(node);
_variables = upperPar;
}
public override void Visit(WProcedureStatement node)
{
for (int i = 0; i < node.StatementList.Count; i++)
{
var statement = node.StatementList[i];
if (statement is WSelectStatement)
{
var sqlSelect = statement as WSelectStatement;
node.StatementList[i] = ConvertSqlSelectStatement(sqlSelect);
}
else if (statement is WInsertSpecification)
{
var sqlInsert = statement as WInsertSpecification;
node.StatementList[i] = ConvertSqlInsertStatement(sqlInsert);
}
else if (statement is WDeleteSpecification)
{
var sqlDelete = statement as WDeleteSpecification;
node.StatementList[i] = ConvertSqlDeleteStatement(sqlDelete);
}
else
{
statement.Accept(this);
}
}
}
public override void Visit(WProcedureStatement node)
{
base.Visit(node);
ConvertToGraphModificationStatement(node.StatementList);
}
public override void Visit(WProcedureStatement node)
{
base.Visit(node);
ConvertToGraphModificationStatement(node.StatementList);
}