private StringBuilder MontaTodosParametrosInsert()
{
var parametro = new StringBuilder();
parametro.Append($" INSERT INTO {NomeTabela}" + Environment.NewLine);
parametro.Append(" (");
for (var i = 0; i < ListaAtributosTabela.Count; i++)
{
if (i == ListaAtributosTabela.Count - 1)
{
parametro.Append($" {ListaAtributosTabela[i].COLUMN_NAME}");
}
else if (i == 0)
{
parametro.Append($"{ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine);
}
else
{
parametro.Append($" {ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine);
}
}
parametro.Append(")" + Environment.NewLine);
parametro.Append(" VALUES" + Environment.NewLine);
parametro.Append(" (");
for (var i = 0; i < ListaAtributosTabela.Count; i++)
{
if (i == ListaAtributosTabela.Count - 1)
{
parametro.Append($" P_{ListaAtributosTabela[i].COLUMN_NAME}");
}
else if (i == 0)
{
parametro.Append($"{NomeTabela.TratarNomeSequence()}," + Environment.NewLine);
}
else
{
parametro.Append($" P_{ListaAtributosTabela[i].COLUMN_NAME}," + Environment.NewLine);
}
}
parametro.Append(");");
return(parametro);
}
