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); }