       

Local: PDVServico

Mensagem: There is already an open DataReader associated with this Command which must be closed first.
Instrucao SQL
Select cli_Codigo CLI_CODIGO, cli_Nome + ' ' + isnull(cli_Sobrenome,'') As Nome,CLI_DDDCELULAR,
cli_TelefoneCelular CLI_TELEFONECELULAR,
cli_DocumentoPrincipal CLI_DOCUMENTOPRINCIPAL,
cli_EMail CLI_EMAIL,cli_Endereco CLI_ENDERECO,cli_Numero CLI_NUMERO,cli_Complemento CLI_COMPLEMENTO,
cli_Bairro CLI_BAIRRO,cli_Cidade CLI_CIDADE,cli_UF CLI_UF,cli_CEP CLI_CEP,cli_CodigoTabelaPrecoServico CLI_CODIGOTABELAPRECOSERVICO,
cli_CodigoConvenio CLI_CODIGOCONVENIO,cli_DescontoPadrao CLI_DESCONTOPADRAO, cli_DescontoPadraoProduto CLI_DESCONTOPADRAOPRODUTO , cli_PrefereETicket CLI_PREFEREETICKET,
cli_Nome CLI_NOME,cli_Sobrenome CLI_SOBRENOME,isnull(cli_ValorSaldo, 0) As CLI_VALORSALDO, isnull(cli_ValorSaldoVoucher, 0) As CLI_VALORSALDOVOUCHER, cli_DataCadastramento CLI_DATACADASTRAMENTO,
cli_Latitude As CLI_LATITUDE, cli_Longitude As CLI_LONGITUDE, isnull(ccv_Nome, '') As CCV_NOME, cli_Observacao As CLI_OBSERVACAO, cli_TipoCobranca As CLI_TIPOCOBRANCA , CLI_DATANASCIMENTO, cli_FormaComunicacaoProcessos As CLI_FORMACOMUNICACAOPROCESSOS, CLI_DIASDELIVERY, isnull(cli_Ranking, 'X') As CLI_RANKING 
, CLI_TELEFONERESIDENCIAL, CLI_INSCRICAOMUNICIPAL, CLI_DDDRESIDENCIAL, CLI_DOCUMENTOSECUNDARIO, CLI_DDDCOMERCIAL, CLI_SEXO, CLI_TIPOCLIENTE, CLI_TELEFONECOMERCIAL 
 From tbCliente (NOLOCK)
Left Join tbConvenio (NOLOCK) On cli_CodigoEmpresa = ccv_CodigoEmpresa And cli_CodigoConvenio = ccv_Codigo And ccv_Ativo = 1 
Where tbCliente.cli_CodigoEmpresa = 6
And cli_Codigo in (68495) 
And cli_CodigoLoja = 432
Order By cli_Nome, cli_Sobrenome



Stack Trace:    at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException)
   at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela)
   at ideologica.clsBD_Cliente.Carregar(String Campos, String Condicao, String Ordem, Boolean ConsideraOperadoresESeuAcessoALojas)
   at ideologica.frmPDVServico.Pesquisar(Boolean CargaDeTitulos, String CodigoClienteEspecifico)
   at ideologica.frmPDVServico.Incluir(String Nome, String Telefone, String DocumentoPrincipal, String Sobrenome, String DataNascimento, String EmailCliente, String Sexo, String TipoCliente, String DDDCelular, String DDDResidencial, String TelefoneResidencial, String DDDComercial, String TelefoneComercial, String DocumentoSecundario, String IM, String CEP, String Endereco, String Numero, String Complemento, String Bairro, String UF, String Cidade)
   at ideologica.frmPDVServico.cmdPesquisar_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-AN5QNID
Memória:                      7,90 GB
Sistema Operacional:          Microsoft Windows 10 Pro
Processador:                  Intel(R) Core(TM) i5-6500T CPU @ 2.50GHz (2496Mhz)
Usuário:                      DESKTOP-AN5QNID\Dell
Resolução do Vídeo:           1024x768
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-AN5QNID