       

Local: PDVServico

Mensagem: There is already an open DataReader associated with this Command which must be closed first.
Instrucao SQL
 Select tck_Codigo,tck_NomeCliente,tck_NomeOperadorEmitiu,tck_DataEmissao,tck_QuantidadeTotalPecas,tck_QuantidadeTotalPecasEntregues,cli_DDDCelular,cli_TelefoneCelular,cli_DDDComercial,cli_TelefoneComercial,cli_DDDResidencial,cli_TelefoneResidencial,cli_Endereco,cli_Numero,cli_Complemento,cli_Bairro,cli_Cidade,cli_UF,cli_CEP,cli_EMail,cli_Latitude,cli_Longitude,tck_DataEntregaUltimaPeca,tck_NumeroOS,tck_DataAnulacao,tck_NomeOperadorAnulou,tck_CodigoCliente, isnull(cli_ValorSaldo, 0) cli_ValorSaldo,  cli_Nome + ' ' + isnull(cli_Sobrenome,'') As Nome , isnull(tck_NomeClienteRepresentante, '') As tck_NomeClienteRepresentante,tck_NumeroOS  , ENTREGA.dly_Codigo As dly_Codigo, ENTREGA.dly_Tipo As dly_Tipo, ENTREGA.dly_Data As dly_Data, ENTREGA.dly_Status As dly_Status From tbTicket (NOLOCK)
Left Join tbCliente (NOLOCK) On tck_CodigoEmpresa = cli_CodigoEmpresa And tck_CodigoLoja = cli_CodigoLoja And tck_CodigoCliente = cli_Codigo
Left Join tbDelivery ENTREGA (NOLOCK) On tck_CodigoEmpresa = ENTREGA.dly_CodigoEmpresa And tck_CodigoLoja = ENTREGA.dly_CodigoLoja And tck_Codigo = ENTREGA.dly_CodigoTicket
And ENTREGA.dly_Status in ('A','M','C')
 And isnull(ENTREGA.dly_Tipo, 'E') in ('A','L','E')
Where tck_Ativo = 1 And tck_CodigoEmpresa = 6
And tck_CodigoLoja = 122 And tck_Codigo = -1



Stack Trace:    at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException)
   at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela)
   at ideologica.clsBD_Ticket.Carregar(String CodigoLoja, String Campos, String Condicao, String Ordem, String Grupo, String CondicaoDeliveryEntrega, String CondicaoDeliveryColeta)
   at ideologica.ctlIdeoCabecalhoTicketCliente.CarregarTicket(String CodigoLoja, String CodigoTicket, String CodigoOrcamento, String OrdemServico, String Etiqueta, String CondicaoTelaChamadora, Boolean TrazInformacaoDelivery)
   at ideologica.frmVisualizarTicketServico.Pesquisar(String CodigoTicket, String CodigoOrcamento, String OrdemServico, String Etiqueta)
   at ideologica.frmVisualizarTicketServico.InicializaJanela()
   at ideologica.frmPDVServico.cmdVisualizarTicket_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at Infragistics.Win.Misc.UltraButtonBase.OnClick(EventArgs e)
   at Infragistics.Win.Misc.UltraButton.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)



Local: System.Data

Mensagem: There is already an open DataReader associated with this Command which must be closed first.

Stack Trace:    at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela)

=========================
Informações do Aplicativo
=========================
Arquivo:                      PDVServico.exe
Caminho:                      C:\Allegro.IoT\PDVServico.exe
Versão:                       7.0.0.1238


======================
Informações da Máquina
======================
Nome da Máquina:              DESKTOP-RJ9H1S3
Memória:                      7,88 GB
Sistema Operacional:          Microsoft Windows 10 Pro
Processador:                  Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz (3392Mhz)
Usuário:                      DESKTOP-RJ9H1S3\Fabiana
Resolução do Vídeo:           1440x900
Versão SQL Server:            Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) 
	Mar 18 2018 09:11:49 
	Copyright (c) Microsoft Corporation
	Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19045: )



Versão exe: 7.0.0, Computador: DESKTOP-RJ9H1S3