public string GerarBody() { var header = new StringBuilder(); header.Append($"create or replace package BODY {NomeTabela.TratarNomePackage()} is" + Environment.NewLine + Environment.NewLine); header.Append(BodyInsert()); header.Append(BodyUpdate()); header.Append(BodyDelete()); header.Append(BodySelect(true)); header.Append(BodySelect()); header.Append($"end {NomeTabela.TratarNomePackage()};" + Environment.NewLine); return(header.ToString()); }
public StringBuilder GerarPackageHeader() { var header = new StringBuilder(); header.Append($"create or replace package {NomeTabela.TratarNomePackage()} is" + Environment.NewLine + Environment.NewLine); header.Append(" TYPE TP_CURSOR IS REF CURSOR;" + Environment.NewLine + Environment.NewLine); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "I_" + NomeTabela.TratarNomeTabela(), true, false, false, false, true)); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "U_" + NomeTabela.TratarNomeTabela(), true)); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela(), true, false, true)); header.Append(AdicionaCabecalho(ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela(), true, true, true, true)); header.Append(AdicionaCabecalho( ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + "_ID", true, true, true)); header.Append(Environment.NewLine + Environment.NewLine + $"end {NomeTabela.TratarNomePackage()};" + Environment.NewLine); return(header); }
public StringBuilder GerarClasse() { var nomeProcBase = NomeTabela.TratarNomeTabela(); var classe = new StringBuilder(); classe.Append("using System.Net;" + N); classe.Append("using System;" + N + N); classe.Append("namespace MeuProjeto" + N); classe.Append("{" + N); classe.Append($" public class {nomeProcBase.ToLowerInvariant()}RequestRepository : ADORepository" + N); classe.Append(" {" + N + N); classe.Append($" private const string PackageName = \"{NomeTabela.TratarNomePackage()}\";" + N + N); classe.Append(Procedures(nomeProcBase)); classe.Append(GetById(nomeProcBase)); classe.Append(Add(nomeProcBase)); classe.Append(Update(nomeProcBase)); classe.Append(" }" + N); classe.Append("}" + N); return(classe); }
private StringBuilder Update() { var get = new StringBuilder(); get.Append($" update: function (body, callback) {{ {N}"); get.Append( $" oracleDb.executeProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "U_" + NomeTabela.TratarNomeTabela()}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_RESULT: {{ dir: oracleDb.type(\"BIND_OUT\"), type: oracleDb.type(\"STRING\") }}, {N}"); for (var i = 0; i < ListaAtributosTabela.Count; i++) { get.Append( $" P_{ListaAtributosTabela[i].COLUMN_NAME}: body.{ListaAtributosTabela[i].COLUMN_NAME},{N}"); } get.Append($" }}, \"P_RESULT\",{N}"); get.Append($" function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder GetAll() { var get = new StringBuilder(); get.Append($" getAll: function (callback) {{{N}"); get.Append( $" oracleDb.beginProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela()}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_CURSORSELECT: {{ type: oracleDb.type(\"CURSOR\"), dir: oracleDb.type(\"BIND_OUT\") }}{N}"); get.Append($" }}, \"P_CURSORSELECT\", function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder GetById() { var get = new StringBuilder(); get.Append($" getById: function (id, callback) {{{N}"); get.Append( $" oracleDb.beginProcedureById({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "S_" + NomeTabela.TratarNomeTabela() + "_ID"}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_CURSORSELECT: {{ type: oracleDb.type(\"CURSOR\"), dir: oracleDb.type(\"BIND_OUT\") }},{N}"); get.Append($" P_{ListaAtributosTabela.First().COLUMN_NAME}: id, {N}"); get.Append($" }}, function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }
private StringBuilder Delete() { var get = new StringBuilder(); get.Append($" delete: function (id, callback) {{ {N}"); get.Append( $" oracleDb.executeProcedure({ParamtersInput.ConnectionString.TratarNomeBase()}, \"{NomeTabela.TratarNomePackage()}.{ParamtersInput.Prefixos.Procedure + "D_" + NomeTabela.TratarNomeTabela()}\",{N}"); get.Append($" {{{N}"); get.Append( $" P_RESULT: {{ dir: oracleDb.type(\"BIND_OUT\"), type: oracleDb.type(\"STRING\") }}, {N}"); get.Append($" P_{ListaAtributosTabela.First().COLUMN_NAME}: id,{N}"); get.Append($" }}, \"P_RESULT\",{N}"); get.Append($" function (err, result) {{ {N}"); get.Append($" callback(err, result);{N}"); get.Append($" }});{N}"); get.Append($" }},{N}"); return(get); }