public DataSet TransportadoraDaNotaFiscal(string codigoEstabelecimento, string serieNotaFiscal, string nrNotaFiscal) { //INICIALIZAÇÃO DO DATASET E DATATABLE DataSet dataSetPrincipal = new DataSet("dataSetPrincipal"); DataTable tabelaRelatorio = new DataTable("tabelaRelatorio"); try { //MONTANDO AS COLUNAS DA TABELA RELATORIO //tabelaRelatorio.Columns.Add("bairroTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("cepTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("cgcTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("cidadeTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codtranspTransporte", typeof(int)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("enderecoTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("estadoTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("insestadualTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nomeTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nomeabrevTransporte", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("paisTransporte", typeof(string)).AllowDBNull = true; tabelaRelatorio.Columns.Add("bairroTransporte"); tabelaRelatorio.Columns.Add("cepTransporte"); tabelaRelatorio.Columns.Add("cgcTransporte"); tabelaRelatorio.Columns.Add("cidadeTransporte"); tabelaRelatorio.Columns.Add("codtranspTransporte"); tabelaRelatorio.Columns.Add("enderecoTransporte"); tabelaRelatorio.Columns.Add("estadoTransporte"); tabelaRelatorio.Columns.Add("insestadualTransporte"); tabelaRelatorio.Columns.Add("nomeTransporte"); tabelaRelatorio.Columns.Add("nomeabrevTransporte"); tabelaRelatorio.Columns.Add("paisTransporte"); //CONSUMINDO WEBSERVICES DO ERP relatoriosB2BObjClient ErpService = new relatoriosB2BObjClient(); //ErpService.Timeout = 99999999; DetalheNotaFiscal_ttEmitenteRow[] EmitenteNotaFiscal; DetalheNotaFiscal_ttFatDuplicRow[] FaturasNotaFiscal; DetalheNotaFiscal_ttItNotaFiscRow[] ItensNotaFiscal; DetalheNotaFiscal_ttNotaFiscalRow[] NotaFiscal; DetalheNotaFiscal_ttTotaisRow[] TotaisNotaFiscal; DetalheNotaFiscal_ttTransporteRow[] TransportadoraNotaFiscal; ErpService.DetalheNotaFiscal(codigoEstabelecimento, serieNotaFiscal, nrNotaFiscal, out NotaFiscal, out EmitenteNotaFiscal, out TransportadoraNotaFiscal, out ItensNotaFiscal, out FaturasNotaFiscal, out TotaisNotaFiscal); //LOOP PARA POPULAR OS DADOS NA TABELA for (int i = 0; i < TransportadoraNotaFiscal.Length; i++) { tabelaRelatorio.Rows.Add(TransportadoraNotaFiscal[i].bairro, TransportadoraNotaFiscal[i].cep, TransportadoraNotaFiscal[i].cgc, TransportadoraNotaFiscal[i].cidade, TransportadoraNotaFiscal[i].codtransp, TransportadoraNotaFiscal[i].endereco, TransportadoraNotaFiscal[i].estado, TransportadoraNotaFiscal[i].insestadual, TransportadoraNotaFiscal[i].nome, TransportadoraNotaFiscal[i].nomeabrev, TransportadoraNotaFiscal[i].pais ); } } catch (SoapException ex) { System.Diagnostics.EventLog.WriteEntry("WebServices Report", ex.Detail.InnerText.ToString(), System.Diagnostics.EventLogEntryType.Error, 666); throw new SoapException("An error occurred in the webservices when retrieving the data, see the event viewer for more details.", SoapException.ClientFaultCode); } //ATRIBUINDO DATATABLE AO DATASET dataSetPrincipal.Tables.Add(tabelaRelatorio); //RETORNO DO DATASET return(dataSetPrincipal); }
public DataSet DetalhesDaNotaFiscal(string codigoEstabelecimento, string serieNotaFiscal, string nrNotaFiscal) { //INICIALIZAÇÃO DO DATASET E DATATABLE DataSet dataSetPrincipal = new DataSet("dataSetPrincipal"); DataTable tabelaRelatorio = new DataTable("tabelaRelatorio"); try { //MONTANDO AS COLUNAS DA TABELA RELATORIO #region Colunas da Tabela //tabelaRelatorio.Columns.Add("cgc", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codcondpag", typeof(int)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codemitente", typeof(int)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codestabel", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codnota", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("dtcancel", typeof(DateTime)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("dtconfirma", typeof(DateTime)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("dtemisnota", typeof(DateTime)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("dtsaida", typeof(DateTime)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("insestadual", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("natoperacao", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nometransp", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nrnotafis", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nrpedcli", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nrvolumes", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("observnota", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("pesobrutot", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("pesoliqtot", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("serie", typeof(int)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("vlmercad", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("vltotipi", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("vltotnota", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("cgcEmitente", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codemitenteEmitente", typeof(int)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codgrcliEmitente", typeof(int)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("descricaoEmitente", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("insestadualEmitente", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nomeEmitente", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("telefoneEmitente", typeof(string)).AllowDBNull = true; tabelaRelatorio.Columns.Add("cgc"); tabelaRelatorio.Columns.Add("codcondpag"); tabelaRelatorio.Columns.Add("codemitente"); tabelaRelatorio.Columns.Add("codestabel"); tabelaRelatorio.Columns.Add("codnota"); tabelaRelatorio.Columns.Add("dtcancel"); tabelaRelatorio.Columns.Add("dtconfirma"); tabelaRelatorio.Columns.Add("dtemisnota"); tabelaRelatorio.Columns.Add("dtsaida"); tabelaRelatorio.Columns.Add("insestadual"); tabelaRelatorio.Columns.Add("natoperacao"); tabelaRelatorio.Columns.Add("nometransp"); tabelaRelatorio.Columns.Add("nrnotafis"); tabelaRelatorio.Columns.Add("nrpedcli"); tabelaRelatorio.Columns.Add("nrvolumes"); tabelaRelatorio.Columns.Add("observnota"); tabelaRelatorio.Columns.Add("pesobrutot"); tabelaRelatorio.Columns.Add("pesoliqtot"); tabelaRelatorio.Columns.Add("serie"); tabelaRelatorio.Columns.Add("vlmercad"); tabelaRelatorio.Columns.Add("vltotipi"); tabelaRelatorio.Columns.Add("vltotnota"); tabelaRelatorio.Columns.Add("codrep"); tabelaRelatorio.Columns.Add("cgcEmitente"); tabelaRelatorio.Columns.Add("codemitenteEmitente"); tabelaRelatorio.Columns.Add("codgrcliEmitente"); tabelaRelatorio.Columns.Add("descricaoEmitente"); tabelaRelatorio.Columns.Add("insestadualEmitente"); tabelaRelatorio.Columns.Add("nomeEmitente"); tabelaRelatorio.Columns.Add("telefoneEmitente"); #endregion //CONSUMINDO WEBSERVICES DO ERP relatoriosB2BObjClient ErpService = new relatoriosB2BObjClient(); //ErpService.Timeout = 99999999; DetalheNotaFiscal_ttNotaFiscalRow[] NotaFiscal; DetalheNotaFiscal_ttEmitenteRow[] EmitenteNotaFiscal; DetalheNotaFiscal_ttFatDuplicRow[] FaturasNotaFiscal; DetalheNotaFiscal_ttItNotaFiscRow[] ItensNotaFiscal; DetalheNotaFiscal_ttTotaisRow[] TotaisNotaFiscal; DetalheNotaFiscal_ttTransporteRow[] TransportadoraNotaFiscal; ErpService.DetalheNotaFiscal(codigoEstabelecimento, serieNotaFiscal, nrNotaFiscal, out NotaFiscal, out EmitenteNotaFiscal, out TransportadoraNotaFiscal, out ItensNotaFiscal, out FaturasNotaFiscal, out TotaisNotaFiscal); //LOOP PARA POPULAR OS DADOS NA TABELA for (int i = 0; i < NotaFiscal.Length; i++) { for (int y = 0; y < EmitenteNotaFiscal.Length; y++) { if (NotaFiscal[i].codemitente.Value == EmitenteNotaFiscal[y].codemitente.Value) { #region Adcionando Valores na Tabela tabelaRelatorio.Rows.Add(NotaFiscal[i].cgc, NotaFiscal[i].codcondpag.GetValueOrDefault(0), NotaFiscal[i].codemitente.GetValueOrDefault(0), NotaFiscal[i].codestabel, NotaFiscal[i].codnota, Convert.ToDateTime(NotaFiscal[i].dtcancel.GetValueOrDefault()).ToShortDateString(), Convert.ToDateTime(NotaFiscal[i].dtconfirma.GetValueOrDefault()).ToShortDateString(), Convert.ToDateTime(NotaFiscal[i].dtemisnota.GetValueOrDefault()).ToShortDateString(), Convert.ToDateTime(NotaFiscal[i].dtsaida.GetValueOrDefault()).ToShortDateString(), NotaFiscal[i].insestadual, NotaFiscal[i].natoperacao, NotaFiscal[i].nometransp, NotaFiscal[i].nrnotafis, NotaFiscal[i].nrpedcli, NotaFiscal[i].nrvolumes, NotaFiscal[i].observnota, Convert.ToDecimal(NotaFiscal[i].pesobrutot.GetValueOrDefault(0)).ToString("0.00"), Convert.ToDecimal(NotaFiscal[i].pesoliqtot.GetValueOrDefault(0)).ToString("0.00"), NotaFiscal[i].serie, Convert.ToDecimal(NotaFiscal[i].vlmercad.GetValueOrDefault(0)).ToString("0.00"), Convert.ToDecimal(NotaFiscal[i].vltotipi.GetValueOrDefault(0)).ToString("0.00"), Convert.ToDecimal(NotaFiscal[i].vltotnota.GetValueOrDefault(0)).ToString("0.00"), //22 NotaFiscal[i].codrep.GetValueOrDefault(0), EmitenteNotaFiscal[y].cgc, EmitenteNotaFiscal[y].codemitente.GetValueOrDefault(0), EmitenteNotaFiscal[y].codgrcli.GetValueOrDefault(0), EmitenteNotaFiscal[y].descricao, EmitenteNotaFiscal[y].insestadual, EmitenteNotaFiscal[y].nomeemit, EmitenteNotaFiscal[y].telefone //7 ); #endregion } } } } catch (SoapException ex) { System.Diagnostics.EventLog.WriteEntry("WebServices Report", ex.Detail.InnerText.ToString(), System.Diagnostics.EventLogEntryType.Error, 666); throw new SoapException("An error occurred in the webservices when retrieving the data, see the event viewer for more details.", SoapException.ClientFaultCode); } //ATRIBUINDO DATATABLE AO DATASET dataSetPrincipal.Tables.Add(tabelaRelatorio); //RETORNO DO DATASET return(dataSetPrincipal); }
public DataSet TotaisDaNotaFiscal(string codigoEstabelecimento, string serieNotaFiscal, string nrNotaFiscal) { //INICIALIZAÇÃO DO DATASET E DATATABLE DataSet dataSetPrincipal = new DataSet("dataSetPrincipal"); DataTable tabelaRelatorio = new DataTable("tabelaRelatorio"); try { //MONTANDO AS COLUNAS DA TABELA RELATORIO //tabelaRelatorio.Columns.Add("baseicmsTotais", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("baseicmssubTotais", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("codestabelTotais", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("nrnotafisTotais", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("serieTotais", typeof(string)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("vlicmsTotais", typeof(decimal)).AllowDBNull = true; //tabelaRelatorio.Columns.Add("vlicmssubTotais", typeof(decimal)).AllowDBNull = true; tabelaRelatorio.Columns.Add("baseicmsTotais"); tabelaRelatorio.Columns.Add("baseicmssubTotais"); tabelaRelatorio.Columns.Add("codestabelTotais"); tabelaRelatorio.Columns.Add("nrnotafisTotais"); tabelaRelatorio.Columns.Add("serieTotais"); tabelaRelatorio.Columns.Add("vlicmsTotais"); tabelaRelatorio.Columns.Add("vlicmssubTotais"); //CONSUMINDO WEBSERVICES DO ERP relatoriosB2BObjClient ErpService = new relatoriosB2BObjClient(); //ErpService.Timeout = 99999999; DetalheNotaFiscal_ttEmitenteRow[] EmitenteNotaFiscal; DetalheNotaFiscal_ttFatDuplicRow[] FaturasNotaFiscal; DetalheNotaFiscal_ttItNotaFiscRow[] ItensNotaFiscal; DetalheNotaFiscal_ttNotaFiscalRow[] NotaFiscal; DetalheNotaFiscal_ttTotaisRow[] TotaisNotaFiscal; DetalheNotaFiscal_ttTransporteRow[] TransportadoraNotaFiscal; ErpService.DetalheNotaFiscal(codigoEstabelecimento, serieNotaFiscal, nrNotaFiscal, out NotaFiscal, out EmitenteNotaFiscal, out TransportadoraNotaFiscal, out ItensNotaFiscal, out FaturasNotaFiscal, out TotaisNotaFiscal); //LOOP PARA POPULAR OS DADOS NA TABELA for (int i = 0; i < TotaisNotaFiscal.Length; i++) { tabelaRelatorio.Rows.Add(Convert.ToDecimal(TotaisNotaFiscal[i].baseicms.Value).ToString("0.00"), Convert.ToDecimal(TotaisNotaFiscal[i].baseicmssub.Value).ToString("0.00"), TotaisNotaFiscal[i].codestabel, TotaisNotaFiscal[i].nrnotafis, TotaisNotaFiscal[i].serie, Convert.ToDecimal(TotaisNotaFiscal[i].vlicms.Value).ToString("0.00"), Convert.ToDecimal(TotaisNotaFiscal[i].vlicmssub.Value).ToString("0.00") ); } } catch (SoapException ex) { System.Diagnostics.EventLog.WriteEntry("WebServices Report", ex.Detail.InnerText.ToString(), System.Diagnostics.EventLogEntryType.Error, 666); throw new SoapException("An error occurred in the webservices when retrieving the data, see the event viewer for more details.", SoapException.ClientFaultCode); } //ATRIBUINDO DATATABLE AO DATASET dataSetPrincipal.Tables.Add(tabelaRelatorio); //RETORNO DO DATASET return(dataSetPrincipal); }