[(null)] 2023-10-06 08:43:55,539 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:43:55,559 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 08:44:03,391 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:44:03,391 [19] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000249'
[(null)] 2023-10-06 08:44:03,401 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 227
[(null)] 2023-10-06 08:44:03,661 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:44:03,661 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 08:44:03,671 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:44:03,671 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 227 ORDER BY Descrizione
[(null)] 2023-10-06 08:44:03,691 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:44:03,691 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 227 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 08:44:03,721 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 227 And CodTipo = 1
[(null)] 2023-10-06 08:44:03,751 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (28994,28766,28381,28234,28091,27869,27736,27426,27186,26686,26415,26143,25861,25594,25368,25121,24966,24774,24655,24351) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 08:44:10,454 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:44:10,454 [32] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 08:44:10,464 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:44:10,464 [32] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 08:44:10,514 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:13,969 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:14,099 [69] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29134
[(null)] 2023-10-06 08:47:14,099 [69] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29134
[(null)] 2023-10-06 08:47:14,099 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:14,099 [69] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 08:47:14,099 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:14,099 [69] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29134
[(null)] 2023-10-06 08:47:14,239 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:14,529 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:14,529 [69] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 227 ORDER BY Descrizione
[(null)] 2023-10-06 08:47:14,539 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:47:14,539 [69] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 227 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 08:47:14,539 [69] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 227 And CodTipo = 1
[(null)] 2023-10-06 08:47:14,539 [69] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29134,28994,28766,28381,28234,28091,27869,27736,27426,27186,26686,26415,26143,25861,25594,25368,25121,24966,24774,24655) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 08:53:45,344 [58] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:53:45,344 [58] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[(null)] 2023-10-06 08:53:58,139 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:53:58,139 [50] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-10-06 08:53:58,139 [50] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-10-06 08:53:58,309 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:53:58,309 [50] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 08:53:58,309 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:53:58,319 [50] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-10-06 08:53:58,319 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:53:58,319 [50] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 08:53:58,359 [50] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-10-06 08:53:58,379 [50] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29090,29022,28974,28936,28823,28824,28825,28765,28724,28681,28647,28535,28538,28540,28541,28475,28418,28369,28335,28250) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 08:54:02,277 [56] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:54:02,277 [56] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 08:54:02,277 [56] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:54:02,277 [56] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 08:54:02,277 [56] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:54:02,697 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:54:02,697 [50] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 08:54:02,697 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:54:02,697 [50] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 08:58:15,339 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:58:15,339 [32] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000807'
[(null)] 2023-10-06 08:58:15,349 [32] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 683
[(null)] 2023-10-06 08:58:15,519 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:58:15,519 [32] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 08:58:15,519 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:58:15,529 [32] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[(null)] 2023-10-06 08:58:15,529 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:58:15,529 [32] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 08:58:15,569 [32] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[(null)] 2023-10-06 08:58:15,599 [32] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29073,29023,28981,28946,28887,28838,28770,28729,28688,28642,28604,28530,28479,28438,28378,28340,28302,28239,28174,28089) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 08:58:19,838 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:58:19,838 [32] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 08:58:19,848 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:58:19,848 [32] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 08:58:19,848 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:03,604 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:03,614 [32] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29138
[(null)] 2023-10-06 08:59:03,614 [32] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29138
[(null)] 2023-10-06 08:59:03,614 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:03,624 [32] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 08:59:03,624 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:03,624 [32] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29138
[(null)] 2023-10-06 08:59:06,545 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:06,545 [32] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29138
[(null)] 2023-10-06 08:59:08,383 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:08,383 [32] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29138
[(null)] 2023-10-06 08:59:08,433 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:08,513 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:08,513 [32] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[(null)] 2023-10-06 08:59:08,523 [32] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:08,523 [32] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 08:59:08,523 [32] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[(null)] 2023-10-06 08:59:08,523 [32] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29138,29073,29023,28981,28946,28887,28838,28770,28729,28688,28642,28604,28530,28479,28438,28378,28340,28302,28239,28174) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 08:59:37,680 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:37,690 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29139
[(null)] 2023-10-06 08:59:37,700 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29139
[(null)] 2023-10-06 08:59:37,700 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:37,700 [75] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 08:59:37,700 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:37,700 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29139
[(null)] 2023-10-06 08:59:37,800 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:37,910 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:37,910 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-10-06 08:59:37,910 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 08:59:37,910 [75] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 08:59:37,910 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-10-06 08:59:37,920 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29139,29090,29022,28974,28936,28823,28824,28825,28765,28724,28681,28647,28535,28538,28540,28541,28475,28418,28369,28335) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:00:56,187 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:00:56,187 [43] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-10-06 09:00:56,197 [43] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-10-06 09:00:56,397 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:00:56,397 [43] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:00:56,407 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:00:56,407 [43] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 09:00:56,417 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:00:56,417 [43] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:00:56,457 [43] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 09:00:56,487 [43] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937,28938,28947,28889,28890) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:01:02,031 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:01:02,031 [69] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-10-06 09:01:02,041 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:01:02,041 [69] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:01:02,041 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:01:02,041 [69] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:01:02,061 [69] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,521 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,601 [3] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29140
[(null)] 2023-10-06 09:02:34,601 [3] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29140
[(null)] 2023-10-06 09:02:34,601 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,601 [3] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 09:02:34,601 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,611 [3] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29140
[(null)] 2023-10-06 09:02:34,721 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,911 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,911 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 09:02:34,922 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:02:34,922 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:02:34,922 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 09:02:34,931 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937,28938,28947,28889) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:04:11,486 [58] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:04:11,486 [58] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-10-06 09:04:11,486 [58] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:04:11,486 [58] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:04:11,496 [58] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:04:11,496 [58] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:04:11,496 [58] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:06:39,954 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:06:39,964 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29141
[(null)] 2023-10-06 09:06:39,964 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29141
[(null)] 2023-10-06 09:06:39,964 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:06:39,964 [19] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29141
[(null)] 2023-10-06 09:06:39,994 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:06:40,064 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:06:40,064 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 09:06:40,074 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:06:40,074 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:06:40,074 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 09:06:40,084 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937,28938,28947) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:08:20,809 [38] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:08:20,816 [38] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:08:20,816 [38] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:08:20,816 [38] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:08:20,816 [38] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:09:22,058 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:09:22,078 [50] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29142
[(null)] 2023-10-06 09:09:22,078 [50] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29142
[(null)] 2023-10-06 09:09:22,078 [50] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:09:22,078 [50] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29142
[(null)] 2023-10-06 09:18:17,057 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:17,057 [47] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:18:22,146 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:22,556 [43] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-10-06 09:18:22,556 [43] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-10-06 09:18:22,756 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:22,756 [43] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:18:22,766 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:22,776 [43] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 09:18:22,776 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:22,776 [43] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:18:22,776 [43] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 09:18:22,786 [43] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937,28938,28947) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:18:30,441 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:30,441 [43] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-10-06 09:18:30,441 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:30,451 [43] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:18:30,451 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:30,451 [43] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:18:30,451 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:43,561 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:43,561 [43] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[(null)] 2023-10-06 09:18:50,393 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:50,393 [43] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-10-06 09:18:50,393 [43] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-10-06 09:18:50,523 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:50,523 [43] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:18:50,533 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:50,533 [43] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-10-06 09:18:50,533 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:50,533 [43] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:18:50,573 [43] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-10-06 09:18:50,593 [43] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29139,29142,29090,29022,28974,28936,28823,28824,28825,28765,28724,28681,28647,28535,28538,28540,28541,28475,28418,28369) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:18:59,763 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:59,763 [43] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29142
[(null)] 2023-10-06 09:18:59,933 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:18:59,933 [43] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:19:00,233 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:19:00,233 [43] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:19:00,233 [43] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:41,456 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:41,456 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29142
[(null)] 2023-10-06 09:24:41,576 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:41,576 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29142
[(null)] 2023-10-06 09:24:41,726 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:41,846 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:41,846 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-10-06 09:24:41,846 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:41,846 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:24:41,856 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-10-06 09:24:41,856 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29139,29142,29090,29022,28974,28936,28823,28824,28825,28765,28724,28681,28647,28535,28538,28540,28541,28475,28418,28369) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:24:46,746 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:46,746 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:24:46,746 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:24:46,746 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:24:46,756 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:03,212 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:03,222 [53] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:03,222 [53] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:03,222 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:03,222 [53] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 09:27:03,232 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:03,232 [53] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:10,211 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:10,211 [53] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:10,391 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:10,391 [53] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:10,651 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=200;Connect Timeout=60'.
[(null)] 2023-10-06 09:27:28,793 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:28,803 [53] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:28,873 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:28,873 [53] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29146
[(null)] 2023-10-06 09:27:29,043 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:29,163 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:29,163 [53] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 09:27:29,163 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:29,163 [53] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:27:29,173 [53] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 09:27:29,173 [53] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937,28938) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:27:35,088 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:35,088 [59] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-10-06 09:27:35,098 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:35,098 [59] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:27:35,098 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:27:35,098 [59] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:27:35,098 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:28:27,323 [52] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:28:27,333 [52] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29147
[(null)] 2023-10-06 09:28:27,333 [52] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29147
[(null)] 2023-10-06 09:28:27,333 [52] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:28:27,333 [52] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 09:28:27,333 [52] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:28:27,333 [52] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29147
[(null)] 2023-10-06 09:34:47,034 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:34:47,034 [22] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29147
[(null)] 2023-10-06 09:34:47,404 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:34:47,404 [22] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29147
[(null)] 2023-10-06 09:34:47,544 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:34:47,684 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:34:47,684 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-10-06 09:34:47,684 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:34:47,684 [22] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:34:47,694 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-10-06 09:34:47,694 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29139,29142,29147,29090,29022,28974,28936,28823,28824,28825,28765,28724,28681,28647,28535,28538,28540,28541,28475,28418) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:42:03,899 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:42:03,909 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:42:03,909 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:42:03,909 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:42:03,919 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:43:30,372 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:30,372 [49] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:43:34,450 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:34,450 [49] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-10-06 09:43:34,460 [49] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-10-06 09:43:34,620 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:34,620 [49] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:43:34,630 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:34,630 [49] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 09:43:34,640 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:34,640 [49] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:43:34,680 [49] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 09:43:34,710 [49] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473,25325) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:43:40,173 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:40,173 [49] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:43:40,173 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:43:40,173 [49] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:43:40,193 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:23,370 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:23,370 [75] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:44:23,660 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:23,660 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:44:24,010 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=200;Connect Timeout=60'.
[(null)] 2023-10-06 09:44:46,784 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:46,784 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:44:50,742 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:50,742 [67] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000017'
[(null)] 2023-10-06 09:44:50,742 [67] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 16
[(null)] 2023-10-06 09:44:50,902 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:50,912 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 09:44:50,912 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:50,912 [67] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 16 ORDER BY Descrizione
[(null)] 2023-10-06 09:44:50,922 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:50,922 [67] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:44:50,972 [67] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1
[(null)] 2023-10-06 09:44:50,992 [67] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (28723,28656,28548,28496,28420,28348,28253,28138,28047,27953,27834,27748,27716,27669,27560,27481,27276,27189,27053,26923) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:44:59,284 [38] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:59,284 [38] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 09:44:59,284 [38] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:44:59,284 [38] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 09:44:59,294 [38] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:46:18,356 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:46:18,356 [59] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:46:18,556 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:46:18,566 [59] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29152
[(null)] 2023-10-06 09:46:18,736 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:46:18,906 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:46:18,906 [59] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 09:46:18,916 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:46:18,916 [59] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:46:18,916 [59] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 09:46:18,916 [59] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:50:33,810 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:33,830 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29154
[(null)] 2023-10-06 09:50:33,830 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29154
[(null)] 2023-10-06 09:50:33,830 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:33,840 [17] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 09:50:33,840 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:33,840 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29154
[(null)] 2023-10-06 09:50:38,898 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:38,898 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29154
[(null)] 2023-10-06 09:50:39,598 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:39,598 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29154
[(null)] 2023-10-06 09:50:39,638 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:40,818 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:40,818 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 16 ORDER BY Descrizione
[(null)] 2023-10-06 09:50:40,818 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:50:40,818 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:50:40,828 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1
[(null)] 2023-10-06 09:50:40,828 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29154,28723,28656,28548,28496,28420,28348,28253,28138,28047,27953,27834,27748,27716,27669,27560,27481,27276,27189,27053) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 09:55:18,789 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:55:18,959 [70] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29155
[(null)] 2023-10-06 09:55:18,959 [70] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29155
[(null)] 2023-10-06 09:55:18,959 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:55:18,959 [70] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 09:55:18,969 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:55:18,969 [70] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29155
[(null)] 2023-10-06 09:55:19,219 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:55:19,479 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:55:19,479 [70] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 09:55:19,489 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 09:55:19,489 [70] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 09:55:19,529 [70] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 09:55:19,559 [70] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29155,29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 10:00:02,628 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:00:02,628 [75] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 10:15:12,756 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:15:12,756 [73] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 10:15:15,903 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:15:15,913 [61] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2023-10-06 10:15:15,913 [61] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2023-10-06 10:15:16,133 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:15:16,133 [61] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 10:15:16,153 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:15:16,163 [61] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-10-06 10:15:16,173 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:15:16,173 [61] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 10:15:16,223 [61] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-10-06 10:15:16,253 [61] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29101,29032,28989,28949,28850,28851,28784,28734,28689,28663,28547,28576,28498,28430,28374,28346,28269,28278,28199,28140) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 10:30:59,089 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:30:59,089 [15] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 10:31:11,281 [37] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:11,281 [37] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-10-06 10:31:11,281 [37] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-10-06 10:31:11,401 [37] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:11,401 [37] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 10:31:11,411 [37] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:11,411 [37] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 10:31:11,421 [37] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:11,421 [37] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 10:31:11,461 [37] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 10:31:11,481 [37] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984,28937) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 10:31:46,336 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:46,336 [51] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-10-06 10:31:46,386 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:46,386 [51] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 10:31:46,436 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:31:46,436 [51] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 10:31:46,436 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,377 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,387 [36] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29156
[(null)] 2023-10-06 10:34:28,387 [36] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29156
[(null)] 2023-10-06 10:34:28,387 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,387 [36] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 10:34:28,397 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,397 [36] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29156
[(null)] 2023-10-06 10:34:28,527 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,597 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,597 [36] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 10:34:28,607 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:34:28,607 [36] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 10:34:28,607 [36] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 10:34:28,607 [36] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980,28984) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 10:35:13,247 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:35:13,247 [59] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-10-06 10:35:13,247 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:35:13,247 [59] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 10:35:13,247 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:35:13,257 [59] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 10:35:13,257 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:46,090 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:46,100 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29157
[(null)] 2023-10-06 10:37:46,100 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29157
[(null)] 2023-10-06 10:37:46,100 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:46,100 [26] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29157
[(null)] 2023-10-06 10:37:46,150 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:46,232 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:46,232 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 10:37:46,232 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:46,232 [26] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 10:37:46,242 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 10:37:46,242 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979,28980) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 10:37:59,105 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:59,105 [26] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-10-06 10:37:59,125 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:59,125 [26] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 10:37:59,135 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:37:59,135 [26] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 10:37:59,135 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:44,928 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:44,938 [67] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29158
[(null)] 2023-10-06 10:39:44,938 [67] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29158
[(null)] 2023-10-06 10:39:44,938 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:44,938 [67] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29158
[(null)] 2023-10-06 10:39:44,948 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:45,018 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:45,018 [67] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 10:39:45,018 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:45,018 [67] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 10:39:45,018 [67] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 10:39:45,028 [67] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29158,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 10:39:55,202 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:55,202 [67] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-10-06 10:39:55,202 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:55,202 [67] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 10:39:55,212 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:39:55,212 [67] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 10:39:55,212 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:42:37,118 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:42:37,128 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29159
[(null)] 2023-10-06 10:42:37,128 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29159
[(null)] 2023-10-06 10:42:37,128 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:42:37,128 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29159
[(null)] 2023-10-06 10:42:37,238 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:42:37,308 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:42:37,308 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 10:42:37,308 [75] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 10:42:37,308 [75] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 10:42:37,318 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 10:42:37,318 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29158,29159,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 11:25:22,008 [46] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:22,008 [46] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 11:25:29,225 [34] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:29,225 [34] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000850'
[(null)] 2023-10-06 11:25:29,245 [34] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 726
[(null)] 2023-10-06 11:25:29,405 [34] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:29,405 [34] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 11:25:29,415 [34] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:29,415 [34] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 726 ORDER BY Descrizione
[(null)] 2023-10-06 11:25:29,425 [34] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:29,425 [34] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 11:25:29,465 [34] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1
[(null)] 2023-10-06 11:25:29,485 [34] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29106,29037,28945,28855,28720,28554,28436,28401,28347,28263,28139,28049,27960,27851,27749,26983,26754) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 11:25:50,204 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:50,204 [33] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 105
[(null)] 2023-10-06 11:25:50,204 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:50,204 [33] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 11:25:50,214 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:25:50,214 [33] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 11:25:50,224 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,291 [42] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,311 [42] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29163
[(null)] 2023-10-06 11:29:54,311 [42] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29163
[(null)] 2023-10-06 11:29:54,311 [42] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,311 [42] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 11:29:54,311 [42] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,311 [42] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29163
[(null)] 2023-10-06 11:29:54,361 [42] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,571 [42] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,571 [42] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 726 ORDER BY Descrizione
[(null)] 2023-10-06 11:29:54,581 [42] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:29:54,581 [42] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 11:29:54,581 [42] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1
[(null)] 2023-10-06 11:29:54,591 [42] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29163,29106,29037,28945,28855,28720,28554,28436,28401,28347,28263,28139,28049,27960,27851,27749,26983,26754) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 11:31:20,132 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:31:20,132 [73] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000646'
[(null)] 2023-10-06 11:31:20,132 [73] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 522
[(null)] 2023-10-06 11:31:20,282 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:31:20,282 [73] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 11:31:20,292 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:31:20,292 [73] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-10-06 11:31:20,302 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:31:20,302 [73] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 11:31:20,332 [73] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-10-06 11:31:20,352 [73] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29096,28990,28885,28830,28690,28602,28555,28483,28377,28306,28256,28192,28093,27998,27959,27879,27787,27702,27670,27611) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 11:31:24,926 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:31:24,926 [73] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 11:31:24,936 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:31:24,936 [73] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 11:31:24,947 [73] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,064 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,074 [47] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29164
[(null)] 2023-10-06 11:33:50,074 [47] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29164
[(null)] 2023-10-06 11:33:50,074 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,074 [47] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 11:33:50,084 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,084 [47] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29164
[(null)] 2023-10-06 11:33:50,174 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,284 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,284 [47] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-10-06 11:33:50,284 [47] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:33:50,284 [47] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 11:33:50,284 [47] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-10-06 11:33:50,284 [47] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29164,29096,28990,28885,28830,28690,28602,28555,28483,28377,28306,28256,28192,28093,27998,27959,27879,27787,27702,27670) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 11:46:29,920 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:29,920 [44] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-10-06 11:46:29,920 [44] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-10-06 11:46:30,160 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:30,160 [44] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 11:46:30,170 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:30,170 [44] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 11:46:30,180 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:30,180 [44] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 11:46:30,210 [44] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 11:46:30,240 [44] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29155,29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 11:46:35,759 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:35,759 [65] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29155
[(null)] 2023-10-06 11:46:35,939 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:35,939 [65] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 11:46:35,939 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:46:35,939 [65] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 11:46:35,949 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:47:11,632 [21] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:47:11,632 [21] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 11:47:11,632 [21] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 11:47:11,632 [21] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 11:47:11,632 [21] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 11:47:11,642 [21] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29155,29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 12:09:45,459 [52] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:45,459 [52] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 12:09:49,158 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:49,398 [76] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2023-10-06 12:09:49,398 [76] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2023-10-06 12:09:49,558 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:49,558 [76] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 12:09:49,568 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:49,568 [76] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-10-06 12:09:49,578 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:49,578 [76] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 12:09:49,608 [76] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-10-06 12:09:49,628 [76] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29101,29032,28989,28949,28850,28851,28784,28734,28689,28663,28547,28576,28498,28430,28374,28346,28269,28278,28199,28140) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 12:09:59,783 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:59,783 [76] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 12:09:59,783 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:09:59,783 [76] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 12:09:59,793 [76] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,497 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,517 [53] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29167
[(null)] 2023-10-06 12:12:49,517 [53] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29167
[(null)] 2023-10-06 12:12:49,517 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,517 [53] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 12:12:49,527 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,527 [53] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29167
[(null)] 2023-10-06 12:12:49,567 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,747 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,747 [53] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-10-06 12:12:49,757 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:12:49,757 [53] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 12:12:49,757 [53] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-10-06 12:12:49,757 [53] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29167,29101,29032,28989,28949,28850,28851,28784,28734,28689,28663,28547,28576,28498,28430,28374,28346,28269,28278,28199) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 12:23:15,321 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:15,321 [44] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 12:23:30,183 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:30,183 [70] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000248'
[(null)] 2023-10-06 12:23:30,193 [70] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 226
[(null)] 2023-10-06 12:23:30,343 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:30,343 [70] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 12:23:30,343 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:30,353 [70] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2023-10-06 12:23:30,363 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:30,363 [70] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 12:23:30,393 [70] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2023-10-06 12:23:30,413 [70] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29029,28898,28841,28744,28661,28607,28565,28433,28345,28268,28277,28155,28054,27940,27973,27830,27719,27673,27562,27480) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 12:23:34,526 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:34,526 [70] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 12:23:34,546 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:23:34,546 [70] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 12:23:34,546 [70] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:46,866 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:46,906 [65] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29172
[(null)] 2023-10-06 12:27:46,906 [65] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29172
[(null)] 2023-10-06 12:27:46,906 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:46,906 [65] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 12:27:46,906 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:46,906 [65] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29172
[(null)] 2023-10-06 12:27:47,016 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:47,286 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:47,286 [65] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2023-10-06 12:27:47,286 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 12:27:47,286 [65] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 12:27:47,286 [65] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2023-10-06 12:27:47,296 [65] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29172,29029,28898,28841,28744,28661,28607,28565,28433,28345,28268,28277,28155,28054,27940,27973,27830,27719,27673,27562) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 13:07:12,766 [36] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:12,766 [36] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 13:07:25,001 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:25,001 [53] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2023-10-06 13:07:25,021 [53] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2023-10-06 13:07:25,181 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:25,181 [53] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 13:07:25,181 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:25,191 [53] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-10-06 13:07:25,191 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:25,191 [53] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 13:07:25,231 [53] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-10-06 13:07:25,251 [53] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29108,29047,28987,28952,28894,28849,28795,28745,28705,28664,28549,28557,28501,28431,28384,28354,28300,28273,28205,28147) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 13:07:35,995 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:35,995 [53] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2023-10-06 13:07:35,995 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:36,006 [53] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 13:07:36,036 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:07:36,036 [53] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 13:07:36,056 [53] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:54,841 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:54,861 [65] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29184
[(null)] 2023-10-06 13:11:54,861 [65] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29184
[(null)] 2023-10-06 13:11:54,861 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:54,861 [65] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 13:11:54,871 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:54,871 [65] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29184
[(null)] 2023-10-06 13:11:54,971 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:55,231 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:55,231 [65] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-10-06 13:11:55,231 [65] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:11:55,231 [65] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 13:11:55,231 [65] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-10-06 13:11:55,241 [65] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29184,29108,29047,28987,28952,28894,28849,28795,28745,28705,28664,28549,28557,28501,28431,28384,28354,28300,28273,28205) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 13:14:43,731 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:43,731 [16] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-10-06 13:14:43,741 [16] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-10-06 13:14:43,923 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:43,933 [16] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 13:14:43,933 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:43,933 [16] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 13:14:43,943 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:43,943 [16] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 13:14:43,983 [16] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 13:14:44,013 [16] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29155,29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 13:14:48,763 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:48,773 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29155
[(null)] 2023-10-06 13:14:49,343 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:49,343 [16] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 13:14:49,353 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:14:49,353 [16] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 13:14:49,353 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:41,774 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:41,774 [33] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 13:58:45,081 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:45,131 [61] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2023-10-06 13:58:45,171 [61] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2023-10-06 13:58:45,471 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:45,471 [61] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 13:58:45,501 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:45,551 [61] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-10-06 13:58:45,551 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:45,561 [61] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 13:58:45,631 [61] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-10-06 13:58:45,691 [61] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29167,29101,29032,28989,28949,28850,28851,28784,28734,28689,28663,28547,28576,28498,28430,28374,28346,28269,28278,28199) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 13:58:55,141 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:55,141 [61] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 13:58:55,155 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 13:58:55,155 [61] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 13:58:55,155 [61] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:10,706 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:11,096 [60] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29185
[(null)] 2023-10-06 14:00:11,096 [60] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29185
[(null)] 2023-10-06 14:00:11,096 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:11,096 [60] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 14:00:11,096 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:11,096 [60] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29185
[(null)] 2023-10-06 14:00:11,186 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:11,386 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:11,386 [60] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-10-06 14:00:11,396 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 14:00:11,396 [60] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 14:00:11,396 [60] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-10-06 14:00:11,396 [60] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29167,29185,29101,29032,28989,28949,28850,28851,28784,28734,28689,28663,28547,28576,28498,28430,28374,28346,28269,28278) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 15:43:06,018 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:06,028 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 15:43:07,927 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:07,927 [26] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 15:43:18,645 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:19,445 [67] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-10-06 15:43:19,675 [67] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-10-06 15:43:19,855 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:19,855 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 15:43:19,865 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:19,865 [67] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 15:43:19,875 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:19,875 [67] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 15:43:19,905 [67] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 15:43:19,925 [67] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29159,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978,28979) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 15:43:27,443 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:27,443 [67] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-10-06 15:43:27,443 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:27,443 [67] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 15:43:27,453 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:43:27,453 [67] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 15:43:27,453 [67] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:04,655 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:04,675 [48] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29187
[(null)] 2023-10-06 15:56:04,675 [48] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29187
[(null)] 2023-10-06 15:56:04,675 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:04,675 [48] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-10-06 15:56:04,675 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:04,675 [48] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29187
[(null)] 2023-10-06 15:56:11,631 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:11,631 [48] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29187
[(null)] 2023-10-06 15:56:11,811 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:11,811 [48] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29187
[(null)] 2023-10-06 15:56:11,911 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:13,371 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:13,371 [48] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 15:56:13,381 [48] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:13,381 [48] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 15:56:13,381 [48] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 15:56:13,391 [48] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29159,29187,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977,28978) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 15:56:27,171 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:27,171 [28] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-10-06 15:56:27,171 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:27,171 [28] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 15:56:27,171 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 15:56:27,171 [28] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 15:56:27,181 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:18,552 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:18,562 [63] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29188
[(null)] 2023-10-06 16:00:18,562 [63] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 29188
[(null)] 2023-10-06 16:00:18,562 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:18,562 [63] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29188
[(null)] 2023-10-06 16:00:25,847 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:25,857 [63] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29188
[(null)] 2023-10-06 16:00:26,017 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:26,017 [63] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 29188
[(null)] 2023-10-06 16:00:26,097 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:26,187 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:26,197 [63] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 16:00:26,197 [63] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 16:00:26,197 [63] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 16:00:26,197 [63] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 16:00:26,207 [63] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29159,29187,29188,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 17:01:50,441 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:01:50,441 [44] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 17:01:50,441 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:01:50,441 [60] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 17:02:00,820 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:00,840 [44] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[(null)] 2023-10-06 17:02:00,850 [44] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[(null)] 2023-10-06 17:02:01,190 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:01,190 [44] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 17:02:01,200 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:01,200 [44] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-10-06 17:02:01,220 [44] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:01,220 [44] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 17:02:01,250 [44] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-10-06 17:02:01,280 [44] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29109,28992,28786,28796,28704,28560,28503,28375,28279,28207,28097,27901,27804,27679,27621,27527,27425,27386,27322,27277) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 17:02:12,172 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:12,172 [60] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29109
[(null)] 2023-10-06 17:02:12,342 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:12,342 [60] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 17:02:12,372 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:02:12,372 [60] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 17:02:12,392 [60] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:42,570 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:42,570 [59] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 17:15:46,551 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:46,561 [80] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-10-06 17:15:46,561 [80] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-10-06 17:15:46,731 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:46,741 [80] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 17:15:46,741 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:46,751 [80] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 17:15:46,751 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:46,751 [80] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 17:15:46,781 [80] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 17:15:46,811 [80] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29155,29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 17:15:51,441 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:51,441 [80] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29155
[(null)] 2023-10-06 17:15:51,741 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:51,741 [80] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 17:15:51,741 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:15:51,741 [80] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 17:15:51,751 [80] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:16:27,040 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:16:27,040 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-10-06 17:16:27,040 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 17:16:27,040 [23] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 17:16:27,050 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-10-06 17:16:27,050 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29155,29028,28836,28722,28539,28421,28241,28127,28031,27949,27738,27665,27523,27110,26806,26295,26030,25914,25726,25473) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 18:00:18,985 [56] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:18,985 [56] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 18:00:23,197 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:23,197 [57] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2023-10-06 18:00:23,207 [57] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2023-10-06 18:00:23,367 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:23,367 [57] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 18:00:23,377 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:23,377 [57] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-10-06 18:00:23,387 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:23,387 [57] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 18:00:23,427 [57] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-10-06 18:00:23,447 [57] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29167,29185,29101,29032,28989,28949,28850,28851,28784,28734,28689,28663,28547,28576,28498,28430,28374,28346,28269,28278) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 18:00:35,975 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:35,975 [57] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29185
[(null)] 2023-10-06 18:00:36,145 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:36,145 [57] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 18:00:36,145 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 18:00:36,145 [57] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 18:00:36,155 [57] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:30:39,616 [49] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:30:39,616 [49] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 19:30:41,566 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:30:41,566 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 19:30:44,841 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:30:44,851 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 19:47:08,358 [71] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:08,358 [71] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 19:47:24,721 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:24,721 [29] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-10-06 19:47:24,721 [29] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-10-06 19:47:24,901 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:24,901 [29] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-10-06 19:47:24,911 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:24,911 [29] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-10-06 19:47:24,921 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:24,921 [29] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-10-06 19:47:24,961 [29] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-10-06 19:47:24,981 [29] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (29140,29141,29146,29152,29156,29157,29159,29187,29188,29077,29078,29079,29081,29085,29088,29024,29027,28975,28976,28977) ORDER BY Data DESC, Numero DESC
[(null)] 2023-10-06 19:47:56,365 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:56,365 [28] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 29079
[(null)] 2023-10-06 19:47:56,545 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:56,555 [28] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-10-06 19:47:56,555 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:56,555 [28] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-10-06 19:47:56,555 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-10-06 19:47:56,555 [28] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-10-06 19:47:56,565 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.