public StringBuilder GeraInsertOracleGCamposGDic(GCamposGDic gCamposGDic)
{
var rel = (gCamposGDic.Relatorio == true) ? 1 : 0;
return(new StringBuilder().AppendLine($@"
/*************************************************************
{gCamposGDic.TabelaPrincipal} - {gCamposGDic.Tabela} - {gCamposGDic.Coluna}
*************************************************************/
SELECT COUNT(*) INTO EXIST FROM {gCamposGDic.TabelaPrincipal} WHERE TABELA = '{gCamposGDic.Tabela}' AND COLUNA = '{gCamposGDic.Coluna}';
IF EXIST = 0 THEN
INSERT INTO {gCamposGDic.TabelaPrincipal} (TABELA, COLUNA, DESCRICAO, RELATORIO, APLICACOES)
VALUES('{gCamposGDic.Tabela}', '{gCamposGDic.Coluna}', ''{gCamposGDic.Descricao}', {rel}, '{gCamposGDic.Aplicacoes}');
END IF {Environment.NewLine}"));
}
public StringBuilder GeraInsertSqlGCamposGDic(GCamposGDic gCamposGDic)
{
StringBuilder builder = new StringBuilder();
var rel = (gCamposGDic.Relatorio == true) ? 1 : 0;
#region Monta insert
return(builder.Append($@"
/*************************************************************
{gCamposGDic.TabelaPrincipal} - {gCamposGDic.Tabela} - {gCamposGDic.Coluna}
*************************************************************/
IF NOT EXISTS (SELECT NULL FROM {gCamposGDic.TabelaPrincipal} WHERE TABELA = '{gCamposGDic.Tabela}' AND COLUNA = '{gCamposGDic.Coluna}')
BEGIN
INSERT INTO {gCamposGDic.TabelaPrincipal} (TABELA,COLUNA,DESCRICAO,RELATORIO,APLICACOES)
VALUES ('{gCamposGDic.Tabela}','{gCamposGDic.Coluna}','{gCamposGDic.Descricao}',{rel},'{gCamposGDic.Aplicacoes}')
END {Environment.NewLine}"));
#endregion Monta insert
}
private GCamposGDic GetDadosGcamposGic()
{
var tabela = string.Empty;
GCamposGDic gGCamposGDic = new GCamposGDic();
if (rbGDic.Checked == true)
{
tabela = "GDIC";
}
if (rbGCampos.Checked == true)
{
tabela = "GCAMPOS";
}
gGCamposGDic.TabelaPrincipal = tabela;
gGCamposGDic.Tabela = txtTabela.Text.ToUpper();
gGCamposGDic.Coluna = txtColuna.Text.ToUpper();
gGCamposGDic.Descricao = txtDescricao.Text.ToUpper();
gGCamposGDic.Relatorio = chbRelatorio.Checked;
gGCamposGDic.Aplicacoes = txtAplicacao.Text.ToUpper();
return(gGCamposGDic);
}
