protected void RegistrarLog(Exception ex, OperacoesSAP operacao, int IdTransacaoSap = 0)
        {
            var SQL = new StringBuilder();

            SQL.AppendLine("INSERT INTO dbo.tb_sap_erros(id_transacao_sap, metodo, mensagem)");
            SQL.AppendFormat("VALUES({0}, '{1}', '{2}')", IdTransacaoSap, operacao.ToString(), ex.Message);

            try
            {
                var result = ExecutaSQL(SQL.ToString());
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        protected void RegistrarSolicitacao(int transacao_sap, OperacoesSAP operacao, int id_grv = 0, int id_atendimento = 0, int id_lote = 0)
        {
            var SQL = new StringBuilder();

            var teste = ConsultaSQL("select db_name()");

            SQL.AppendLine("INSERT INTO dbo.tb_sap_solicitacao(id_transacao_sap, operacao, id_grv, id_atendimento, id_lote)");
            SQL.AppendFormat("VALUES({0}, '{1}', {2}, {3}, {4})", transacao_sap, operacao.ToString(), id_grv, id_atendimento, id_lote);

            try
            {
                var result = ExecutaSQL(SQL.ToString());
            }
            catch (Exception)
            {
                throw;
            }
        }