[(null)] 2023-06-27 09:04:25,336 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:25,376 [62] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:04:35,715 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:35,715 [62] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000249'
[(null)] 2023-06-27 09:04:35,725 [62] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 227
[(null)] 2023-06-27 09:04:35,875 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:35,875 [62] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:04:35,885 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:35,885 [62] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 227 ORDER BY Descrizione
[(null)] 2023-06-27 09:04:35,895 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:35,895 [62] 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-06-27 09:04:35,925 [62] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 227 And CodTipo = 1
[(null)] 2023-06-27 09:04:35,955 [62] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25368,25121,24966,24774,24655,24351,24194,23830,23728,23570,23388,23161,23101,22793,22503,22199,22114,21930,21765,21593) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:04:52,903 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:52,903 [62] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:04:52,913 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:04:52,913 [62] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:04:52,923 [62] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:06:58,973 [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-06-27 09:06:58,993 [32] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25594
[(null)] 2023-06-27 09:06:58,993 [32] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25594
[(null)] 2023-06-27 09:06:58,993 [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-06-27 09:06:58,993 [32] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:06:58,993 [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-06-27 09:06:59,003 [32] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25594
[(null)] 2023-06-27 09:06:59,043 [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-06-27 09:06:59,373 [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-06-27 09:06:59,373 [32] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 227 ORDER BY Descrizione
[(null)] 2023-06-27 09:06:59,373 [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-06-27 09:06:59,373 [32] 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-06-27 09:06:59,373 [32] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 227 And CodTipo = 1
[(null)] 2023-06-27 09:06:59,383 [32] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25594,25368,25121,24966,24774,24655,24351,24194,23830,23728,23570,23388,23161,23101,22793,22503,22199,22114,21930,21765) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:09:12,933 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:09:12,933 [41] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-06-27 09:09:12,993 [41] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-06-27 09:09:13,433 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:09:13,433 [41] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:09:13,443 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:09:13,443 [41] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:09:13,453 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:09:13,453 [41] 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-06-27 09:09:13,493 [41] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:09:13,513 [41] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374,25376,25378,25379,25384) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:09:43,927 [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-06-27 09:09:43,927 [63] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-06-27 09:09:43,937 [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-06-27 09:09:43,937 [63] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:09:43,937 [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-06-27 09:09:43,937 [63] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:09:43,937 [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-06-27 09:12:03,732 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:12:03,742 [40] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25595
[(null)] 2023-06-27 09:12:03,742 [40] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25595
[(null)] 2023-06-27 09:12:03,742 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:12:03,742 [40] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:12:03,742 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:12:03,742 [40] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25595
[(null)] 2023-06-27 09:12:03,832 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:12:03,962 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:12:03,962 [40] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:12:03,972 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:12:03,972 [40] 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-06-27 09:12:03,972 [40] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:12:03,972 [40] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374,25376,25378,25379) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:13:56,151 [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-06-27 09:13:56,151 [65] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-06-27 09:13:56,151 [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-06-27 09:13:56,161 [65] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:13:56,161 [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-06-27 09:13:56,161 [65] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:13:56,161 [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-06-27 09:19:37,457 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:37,457 [12] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:19:40,354 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:40,354 [40] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-06-27 09:19:40,354 [40] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-06-27 09:19:40,474 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:40,474 [12] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:19:40,484 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:40,514 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:40,524 [12] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:19:40,524 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:40,524 [12] 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-06-27 09:19:40,524 [12] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:19:40,534 [12] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374,25376,25378,25379) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:19:40,594 [40] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25596
[(null)] 2023-06-27 09:19:40,594 [40] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25596
[(null)] 2023-06-27 09:19:40,604 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:40,664 [40] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25596
[(null)] 2023-06-27 09:19:41,294 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:41,434 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:41,434 [40] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:19:41,444 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:41,444 [40] 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-06-27 09:19:41,454 [40] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:19:41,464 [40] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374,25376,25378) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:19:56,995 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:56,995 [40] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-06-27 09:19:57,005 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:57,005 [40] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:19:57,005 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:19:57,005 [40] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:19:57,005 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:23:49,875 [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-06-27 09:23:49,875 [43] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:24:20,062 [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-06-27 09:24:20,062 [19] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000158'
[(null)] 2023-06-27 09:24:20,072 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 153
[(null)] 2023-06-27 09:24:20,242 [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-06-27 09:24:20,242 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:24:20,252 [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-06-27 09:24:20,252 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 153 ORDER BY Descrizione
[(null)] 2023-06-27 09:24:20,262 [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-06-27 09:24:20,262 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 09:24:20,302 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1
[(null)] 2023-06-27 09:24:20,322 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25562,25526,25453,25377,25285,25203,25132,25055,24968,24892,24776,24657,24614,24566,24515,24350,24280,24199,24128,24040) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:24:27,551 [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-06-27 09:24:27,551 [19] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:24:27,562 [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-06-27 09:24:27,562 [19] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:24:27,562 [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-06-27 09:24:44,836 [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-06-27 09:24:44,886 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:24:44,886 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:24:44,886 [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-06-27 09:24:44,886 [19] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:24:44,886 [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-06-27 09:24:44,886 [19] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:26:22,338 [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-06-27 09:26:22,338 [37] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:26:37,429 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:26:37,439 [55] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25598
[(null)] 2023-06-27 09:26:37,439 [55] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25598
[(null)] 2023-06-27 09:26:37,439 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:26:37,439 [55] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:26:37,439 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:26:37,449 [55] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25598
[(null)] 2023-06-27 09:26:37,479 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:26:37,689 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:26:37,689 [55] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 153 ORDER BY Descrizione
[(null)] 2023-06-27 09:26:37,689 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:26:37,689 [55] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 09:26:37,699 [55] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1
[(null)] 2023-06-27 09:26:37,699 [55] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25598,25562,25526,25453,25377,25285,25203,25132,25055,24968,24892,24776,24657,24614,24566,24515,24350,24280,24199,24128) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:27:42,728 [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-06-27 09:27:42,728 [49] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:27:42,898 [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-06-27 09:27:42,908 [49] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:27:59,658 [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-06-27 09:27:59,658 [49] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:27:59,738 [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-06-27 09:27:59,738 [49] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:28:31,182 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:31,182 [13] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000807'
[(null)] 2023-06-27 09:28:31,182 [13] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 683
[(null)] 2023-06-27 09:28:31,372 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:31,372 [13] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:28:31,372 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:31,372 [13] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[(null)] 2023-06-27 09:28:31,382 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:31,382 [13] 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-06-27 09:28:31,412 [13] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[(null)] 2023-06-27 09:28:31,442 [13] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25564,25528,25452,25375,25326,25281,25233,25202,25119,25054,25022,24967,24927,24891,24834,24773,24711,24654,24616,24565) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:28:35,652 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:35,652 [13] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:28:35,652 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:35,652 [13] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:28:35,652 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:49,853 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:49,853 [13] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:28:49,923 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:28:49,923 [13] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:28:50,183 [13] 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-06-27 09:29:31,872 [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-06-27 09:29:31,882 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25599
[(null)] 2023-06-27 09:29:31,882 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25599
[(null)] 2023-06-27 09:29:31,882 [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-06-27 09:29:31,882 [75] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:29:31,892 [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-06-27 09:29:31,892 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25599
[(null)] 2023-06-27 09:29:31,932 [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-06-27 09:29:32,032 [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-06-27 09:29:32,032 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[(null)] 2023-06-27 09:29:32,032 [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-06-27 09:29:32,032 [75] 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-06-27 09:29:32,032 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[(null)] 2023-06-27 09:29:32,042 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25599,25564,25528,25452,25375,25326,25281,25233,25202,25119,25054,25022,24967,24927,24891,24834,24773,24711,24654,24616) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:29:43,991 [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-06-27 09:29:43,991 [75] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-06-27 09:29:43,991 [75] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-06-27 09:29:44,111 [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-06-27 09:29:44,111 [75] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:29:44,121 [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-06-27 09:29:44,121 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:29:44,131 [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-06-27 09:29:44,131 [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-06-27 09:29:44,171 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:29:44,191 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25597,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374,25376) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:29:58,174 [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-06-27 09:29:58,174 [75] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:29:58,264 [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-06-27 09:29:58,264 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25597
[(null)] 2023-06-27 09:29:58,364 [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-06-27 09:29:58,469 [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-06-27 09:29:58,469 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:29:58,479 [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-06-27 09:29:58,479 [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-06-27 09:29:58,479 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:29:58,479 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25597,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374,25376) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:30:25,996 [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-06-27 09:30:25,996 [22] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-06-27 09:30:26,036 [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-06-27 09:30:26,036 [22] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:30:26,056 [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-06-27 09:30:26,056 [22] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:30:26,086 [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-06-27 09:34:09,059 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:09,099 [79] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25600
[(null)] 2023-06-27 09:34:09,099 [79] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25600
[(null)] 2023-06-27 09:34:09,099 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:09,099 [79] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:34:09,099 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:09,119 [79] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25600
[(null)] 2023-06-27 09:34:09,269 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:09,349 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:09,349 [79] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:34:09,359 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:09,369 [79] 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-06-27 09:34:09,369 [79] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:34:09,379 [79] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25597,25600,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372,25374) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:34:21,702 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:21,702 [79] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-06-27 09:34:21,702 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:21,702 [79] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:34:21,712 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:34:21,712 [79] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:34:21,712 [79] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:35:24,866 [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-06-27 09:35:24,866 [37] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[(null)] 2023-06-27 09:35:29,758 [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-06-27 09:35:29,758 [75] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-06-27 09:35:29,758 [75] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-06-27 09:35:29,908 [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-06-27 09:35:29,908 [75] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:35:29,918 [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-06-27 09:35:29,918 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-06-27 09:35:29,928 [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-06-27 09:35:29,928 [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-06-27 09:35:29,968 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-06-27 09:35:29,988 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25555,25440,25447,25449,25451,25373,25323,25286,25236,25113,25116,25117,25118,25062,25018,24972,24929,24826,24827,24829) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:35:35,478 [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-06-27 09:35:35,478 [63] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:35:35,898 [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-06-27 09:35:35,898 [63] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:35:36,068 [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-06-27 09:41:52,654 [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-06-27 09:41:52,684 [49] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:41:52,684 [49] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:41:52,684 [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-06-27 09:41:52,684 [49] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 09:41:52,704 [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-06-27 09:41:52,704 [49] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:45:04,199 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:45:04,199 [13] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[(null)] 2023-06-27 09:45:11,665 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:45:11,675 [72] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-06-27 09:45:11,675 [72] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-06-27 09:45:11,806 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:45:11,806 [72] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:45:11,806 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:45:11,806 [72] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-06-27 09:45:11,816 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:45:11,816 [72] 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-06-27 09:45:11,816 [72] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-06-27 09:45:11,816 [72] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25601,25555,25440,25447,25449,25451,25373,25323,25286,25236,25113,25116,25117,25118,25062,25018,24972,24929,24826,24827) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:45:17,977 [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-06-27 09:45:17,977 [65] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:45:18,137 [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-06-27 09:45:18,137 [65] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:45:18,137 [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-06-27 09:45:18,137 [65] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:45:18,137 [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-06-27 09:45:25,913 [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-06-27 09:45:25,913 [65] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:45:25,993 [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-06-27 09:45:25,993 [65] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:47:27,001 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:47:27,021 [55] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25602
[(null)] 2023-06-27 09:47:27,021 [55] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25602
[(null)] 2023-06-27 09:47:27,021 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:47:27,021 [55] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25602
[(null)] 2023-06-27 09:47:27,061 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:47:27,351 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:47:27,351 [55] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 09:47:27,361 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 09:47:27,361 [55] 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-06-27 09:47:27,361 [55] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 09:47:27,361 [55] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25597,25600,25602,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:58:02,794 [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-06-27 09:58:02,794 [71] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[(null)] 2023-06-27 09:58:08,245 [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-06-27 09:58:08,245 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[(null)] 2023-06-27 09:58:12,698 [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-06-27 09:58:12,698 [23] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-06-27 09:58:12,698 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-06-27 09:58:12,848 [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-06-27 09:58:12,848 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 09:58:12,858 [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-06-27 09:58:12,858 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-06-27 09:58:12,868 [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-06-27 09:58:12,868 [23] 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-06-27 09:58:12,898 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-06-27 09:58:12,918 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25601,25555,25440,25447,25449,25451,25373,25323,25286,25236,25113,25116,25117,25118,25062,25018,24972,24929,24826,24827) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 09:58:18,327 [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-06-27 09:58:18,327 [23] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 09:58:18,487 [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-06-27 09:58:18,487 [23] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 09:58:18,487 [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-06-27 09:58:18,487 [23] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 09:58:18,487 [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-06-27 10:00:12,999 [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-06-27 10:00:12,999 [42] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 10:00:13,149 [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-06-27 10:00:13,149 [42] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 10:00:18,876 [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-06-27 10:00:18,876 [42] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 10:00:18,946 [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-06-27 10:00:18,946 [42] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25601
[(null)] 2023-06-27 10:00:19,056 [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-06-27 10:00:19,316 [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-06-27 10:00:19,316 [42] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-06-27 10:00:19,316 [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-06-27 10:00:19,316 [42] 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-06-27 10:00:19,326 [42] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-06-27 10:00:19,326 [42] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25601,25555,25440,25447,25449,25451,25373,25323,25286,25236,25113,25116,25117,25118,25062,25018,24972,24929,24826,24827) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 10:10:59,057 [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-06-27 10:10:59,057 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 10:37:46,499 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:37:46,499 [72] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 10:37:49,828 [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-06-27 10:37:49,828 [69] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000669'
[(null)] 2023-06-27 10:37:49,828 [69] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 545
[(null)] 2023-06-27 10:37:49,978 [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-06-27 10:37:49,978 [69] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 10:37:49,988 [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-06-27 10:37:49,988 [69] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 545 ORDER BY Descrizione
[(null)] 2023-06-27 10:37:49,998 [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-06-27 10:37:49,998 [69] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 10:37:50,028 [69] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1
[(null)] 2023-06-27 10:37:50,058 [69] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25540,25480,25366,25319,25244,25265,25120,25069,25031,24981,24889,24913,24841,24759,24719,24640,24508,24406,24360,24318) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 10:38:11,937 [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-06-27 10:38:11,937 [69] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 10:38:11,957 [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-06-27 10:38:11,957 [69] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 10:38:11,967 [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-06-27 10:39:21,861 [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-06-27 10:39:21,871 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25604
[(null)] 2023-06-27 10:39:21,871 [75] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25604
[(null)] 2023-06-27 10:39:21,871 [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-06-27 10:39:21,871 [75] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 10:39:21,871 [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-06-27 10:39:21,871 [75] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25604
[(null)] 2023-06-27 10:39:21,911 [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-06-27 10:39:22,091 [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-06-27 10:39:22,091 [75] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 545 ORDER BY Descrizione
[(null)] 2023-06-27 10:39:22,091 [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-06-27 10:39:22,091 [75] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 10:39:22,101 [75] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1
[(null)] 2023-06-27 10:39:22,101 [75] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25604,25540,25480,25366,25319,25244,25265,25120,25069,25031,24981,24889,24913,24841,24759,24719,24640,24508,24406,24360) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 10:43:06,075 [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-06-27 10:43:06,075 [58] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 10:43:09,891 [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-06-27 10:43:09,891 [58] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2023-06-27 10:43:09,891 [58] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2023-06-27 10:43:10,054 [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-06-27 10:43:10,054 [58] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 10:43:10,061 [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-06-27 10:43:10,061 [58] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-06-27 10:43:10,071 [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-06-27 10:43:10,071 [58] 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-06-27 10:43:10,101 [58] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-06-27 10:43:10,131 [58] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25570,25521,25488,25398,25340,25297,25241,25149,25164,25063,25016,24980,24936,24847,24862,24777,24721,24669,24630,24502) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 10:44:31,784 [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-06-27 10:44:31,784 [21] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 10:44:31,794 [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-06-27 10:44:31,794 [21] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 10:44:31,804 [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-06-27 10:45:55,735 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:45:55,785 [72] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25605
[(null)] 2023-06-27 10:45:55,785 [72] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25605
[(null)] 2023-06-27 10:45:55,785 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:45:55,785 [72] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 10:45:55,795 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:45:55,795 [72] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25605
[(null)] 2023-06-27 10:45:55,935 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:45:56,115 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:45:56,115 [72] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-06-27 10:45:56,115 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 10:45:56,115 [72] 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-06-27 10:45:56,115 [72] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-06-27 10:45:56,125 [72] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25605,25570,25521,25488,25398,25340,25297,25241,25149,25164,25063,25016,24980,24936,24847,24862,24777,24721,24669,24630) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 11:51:13,789 [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-06-27 11:51:13,789 [49] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 11:51:14,734 [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-06-27 11:51:14,734 [52] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 11:51:17,176 [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-06-27 11:51:17,176 [49] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 11:51:18,077 [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-06-27 11:51:18,077 [52] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 11:51:28,512 [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-06-27 11:51:28,512 [52] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2023-06-27 11:51:28,532 [52] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2023-06-27 11:51:28,706 [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-06-27 11:51:28,706 [52] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 11:51:28,716 [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-06-27 11:51:28,716 [52] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-06-27 11:51:28,726 [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-06-27 11:51:28,726 [52] 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-06-27 11:51:28,756 [52] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-06-27 11:51:28,786 [52] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25576,25481,25485,25405,25339,25299,25250,25152,25167,25081,25023,24991,24939,24848,24849,24779,24727,24682,24632,24514) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 11:51:35,929 [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-06-27 11:51:35,929 [52] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2023-06-27 11:51:35,929 [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-06-27 11:51:35,939 [52] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 11:51:35,949 [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-06-27 11:51:35,949 [52] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 11:51:35,959 [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-06-27 11:54:52,195 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:54:52,215 [55] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25611
[(null)] 2023-06-27 11:54:52,215 [55] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25611
[(null)] 2023-06-27 11:54:52,215 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:54:52,215 [55] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 11:54:52,215 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:54:52,215 [55] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25611
[(null)] 2023-06-27 11:55:01,087 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:55:01,087 [55] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25611
[(null)] 2023-06-27 11:55:01,247 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:55:01,247 [55] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25611
[(null)] 2023-06-27 11:55:01,377 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:55:01,607 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:55:01,607 [55] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-06-27 11:55:01,617 [55] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 11:55:01,617 [55] 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-06-27 11:55:01,617 [55] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-06-27 11:55:01,627 [55] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25611,25576,25481,25485,25405,25339,25299,25250,25152,25167,25081,25023,24991,24939,24848,24849,24779,24727,24682,24632) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:06:18,446 [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-06-27 12:06:18,446 [57] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000684'
[(null)] 2023-06-27 12:06:18,456 [57] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 560
[(null)] 2023-06-27 12:06:18,626 [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-06-27 12:06:18,636 [57] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 12:06:18,636 [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-06-27 12:06:18,646 [57] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[(null)] 2023-06-27 12:06:18,646 [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-06-27 12:06:18,646 [57] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 12:06:18,676 [57] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[(null)] 2023-06-27 12:06:18,706 [57] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25401,25300,25078,24990,24780,24681,24511,24369,24156,24055,23852,23741,23509,23396,23184,23068,22864,22749,22614,22512) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:06:24,695 [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-06-27 12:06:24,695 [57] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 83
[(null)] 2023-06-27 12:06:24,705 [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-06-27 12:06:24,705 [57] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 12:06:24,705 [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-06-27 12:06:24,705 [57] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 12:06:24,715 [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-06-27 12:08:51,417 [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-06-27 12:08:51,427 [57] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25612
[(null)] 2023-06-27 12:08:51,437 [57] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25612
[(null)] 2023-06-27 12:08:51,437 [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-06-27 12:08:51,437 [57] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 12:08:51,437 [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-06-27 12:08:51,437 [57] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25612
[(null)] 2023-06-27 12:08:51,517 [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-06-27 12:08:51,621 [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-06-27 12:08:51,621 [57] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[(null)] 2023-06-27 12:08:51,631 [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-06-27 12:08:51,631 [57] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 12:08:51,631 [57] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[(null)] 2023-06-27 12:08:51,631 [57] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25612,25401,25300,25078,24990,24780,24681,24511,24369,24156,24055,23852,23741,23509,23396,23184,23068,22864,22749,22614) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:11:51,271 [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-06-27 12:11:51,271 [67] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000646'
[(null)] 2023-06-27 12:11:51,271 [67] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 522
[(null)] 2023-06-27 12:11:51,431 [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-06-27 12:11:51,431 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 12:11:51,441 [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-06-27 12:11:51,441 [67] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-06-27 12:11:51,451 [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-06-27 12:11:51,451 [67] 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-06-27 12:11:51,481 [67] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-06-27 12:11:51,511 [67] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25527,25487,25399,25294,25196,25128,25070,24979,24890,24851,24778,24670,24561,24510,24356,24276,24214,24144,24044,23962) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:11:58,991 [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-06-27 12:11:59,001 [67] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 12:11:59,001 [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-06-27 12:11:59,001 [67] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 12:11:59,011 [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-06-27 12:15:00,495 [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-06-27 12:15:00,515 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25613
[(null)] 2023-06-27 12:15:00,515 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25613
[(null)] 2023-06-27 12:15:00,515 [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-06-27 12:15:00,515 [26] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 12:15:00,525 [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-06-27 12:15:00,525 [26] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25613
[(null)] 2023-06-27 12:15:00,635 [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-06-27 12:15:00,735 [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-06-27 12:15:00,745 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-06-27 12:15:00,745 [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-06-27 12:15:00,745 [26] 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-06-27 12:15:00,755 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-06-27 12:15:00,765 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25613,25527,25487,25399,25294,25196,25128,25070,24979,24890,24851,24778,24670,24561,24510,24356,24276,24214,24144,24044) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:17:20,739 [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-06-27 12:17:20,739 [46] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 12:17:23,084 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:17:23,084 [41] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000248'
[(null)] 2023-06-27 12:17:23,084 [41] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 226
[(null)] 2023-06-27 12:17:23,234 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:17:23,234 [41] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 12:17:23,244 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:17:23,244 [41] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2023-06-27 12:17:23,254 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:17:23,254 [41] 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-06-27 12:17:23,284 [41] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2023-06-27 12:17:23,314 [41] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25535,25482,25338,25237,25153,24946,24906,24854,24725,24629,24570,24519,24370,24224,24248,24097,24006,23961,23911,23786) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:17:28,728 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:17:28,728 [41] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 12:17:28,728 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:17:28,728 [41] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 12:17:28,738 [41] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:25:33,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-06-27 12:25:33,601 [80] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25616
[(null)] 2023-06-27 12:25:33,601 [80] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25616
[(null)] 2023-06-27 12:25:33,601 [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-06-27 12:25:33,601 [80] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 12:25:33,601 [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-06-27 12:25:33,601 [80] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25616
[(null)] 2023-06-27 12:25:33,651 [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-06-27 12:25:33,821 [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-06-27 12:25:33,821 [80] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2023-06-27 12:25:33,821 [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-06-27 12:25:33,821 [80] 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-06-27 12:25:33,861 [80] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2023-06-27 12:25:33,951 [80] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25616,25535,25482,25338,25237,25153,24946,24906,24854,24725,24629,24570,24519,24370,24224,24248,24097,24006,23961,23911) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:28:46,007 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:28:46,007 [72] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 12:28:58,769 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:28:58,769 [72] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[(null)] 2023-06-27 12:28:58,769 [72] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[(null)] 2023-06-27 12:28:58,919 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:28:58,919 [72] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 12:28:58,929 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:28:58,929 [72] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-06-27 12:28:58,939 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:28:58,939 [72] 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-06-27 12:28:58,969 [72] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-06-27 12:28:58,999 [72] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25490,25410,25298,25154,25079,24989,24852,24781,24673,24512,24368,24229,24157,24053,23919,23850,23742,23588,23512,23395) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:29:06,749 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:29:06,749 [72] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 12:29:06,749 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:29:06,749 [72] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 12:29:06,759 [72] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:29:07,589 [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-06-27 12:29:07,589 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 12:29:07,599 [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-06-27 12:29:07,599 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 12:38:29,455 [54] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:38:29,465 [54] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25619
[(null)] 2023-06-27 12:38:29,465 [54] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25619
[(null)] 2023-06-27 12:38:29,475 [54] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:38:29,475 [54] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 12:38:29,475 [54] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:38:29,475 [54] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25619
[(null)] 2023-06-27 12:38:29,661 [54] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:38:29,771 [54] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:38:29,771 [54] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-06-27 12:38:29,781 [54] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 12:38:29,781 [54] 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-06-27 12:38:29,781 [54] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-06-27 12:38:29,781 [54] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25619,25490,25410,25298,25154,25079,24989,24852,24781,24673,24512,24368,24229,24157,24053,23919,23850,23742,23588,23512) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 12:38:56,448 [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-06-27 12:38:56,448 [67] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25619
[(null)] 2023-06-27 12:38:56,788 [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-06-27 12:38:56,788 [67] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 12:38:56,798 [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-06-27 12:38:56,798 [67] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 12:38:56,808 [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-06-27 12:39:01,386 [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-06-27 12:39:01,386 [67] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25619
[(null)] 2023-06-27 12:39:01,456 [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-06-27 12:39:01,456 [67] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25619
[(null)] 2023-06-27 12:39:01,636 [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=200;Connect Timeout=60'.
[(null)] 2023-06-27 12:48:54,464 [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-06-27 12:48:54,464 [65] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 13:00:19,694 [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-06-27 13:00:19,694 [48] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-06-27 13:00:19,854 [48] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-06-27 13:00:20,024 [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-06-27 13:00:20,024 [48] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 13:00:20,024 [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-06-27 13:00:20,034 [48] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 13:00:20,034 [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-06-27 13:00:20,034 [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-06-27 13:00:20,074 [48] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 13:00:20,094 [48] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25597,25600,25606,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494,25372) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 13:00:32,276 [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-06-27 13:00:32,276 [56] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-06-27 13:00:32,286 [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-06-27 13:00:32,286 [56] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 13:00:32,286 [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-06-27 13:00:32,286 [56] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 13:00:32,286 [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-06-27 13:06:43,782 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:06:43,802 [20] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25620
[(null)] 2023-06-27 13:06:43,802 [20] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25620
[(null)] 2023-06-27 13:06:43,802 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:06:43,812 [20] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 13:06:43,812 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:06:43,812 [20] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25620
[(null)] 2023-06-27 13:06:43,962 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:06:44,032 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:06:44,032 [20] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-06-27 13:06:44,042 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:06:44,042 [20] 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-06-27 13:06:44,042 [20] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-06-27 13:06:44,042 [20] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25595,25596,25597,25600,25606,25620,25566,25568,25569,25529,25531,25445,25446,25448,25450,25459,25462,25468,25493,25494) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 13:07:00,995 [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-06-27 13:07:00,995 [56] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-06-27 13:07:00,995 [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-06-27 13:07:00,995 [56] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 13:07:00,995 [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-06-27 13:07:00,995 [56] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 13:07:01,005 [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-06-27 13:10:17,780 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:10:17,800 [40] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25621
[(null)] 2023-06-27 13:10:17,800 [40] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25621
[(null)] 2023-06-27 13:10:17,800 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 13:10:17,800 [40] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25621
[(null)] 2023-06-27 13:10:17,830 [40] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 19:22:17,396 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 19:22:17,406 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 19:22:25,238 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 19:22:25,238 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000235'
[(null)] 2023-06-27 19:22:25,238 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 219
[(null)] 2023-06-27 19:22:25,368 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 19:22:25,368 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-06-27 19:22:25,378 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 19:22:25,378 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[(null)] 2023-06-27 19:22:25,388 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-06-27 19:22:25,388 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 19:22:25,418 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[(null)] 2023-06-27 19:22:25,448 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25580,25530,25539,25421,25350,25304,25264,25215,25170,25097,25038,24998,24951,24912,24803,24736,24688,24639,24599,24503) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 19:22:30,587 [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-06-27 19:22:30,587 [34] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 19:22:30,927 [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-06-27 19:22:30,927 [34] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 19:22:30,947 [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-06-27 19:28:21,592 [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-06-27 19:28:21,612 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25631
[(null)] 2023-06-27 19:28:21,612 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 25631
[(null)] 2023-06-27 19:28:21,612 [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-06-27 19:28:21,612 [19] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-06-27 19:28:21,612 [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-06-27 19:28:21,622 [19] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 25631
[(null)] 2023-06-27 19:28:21,652 [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-06-27 19:28:21,832 [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-06-27 19:28:21,832 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[(null)] 2023-06-27 19:28:21,832 [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-06-27 19:28:21,832 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-06-27 19:28:21,842 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[(null)] 2023-06-27 19:28:21,842 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (25631,25580,25530,25539,25421,25350,25304,25264,25215,25170,25097,25038,24998,24951,24912,24803,24736,24688,24639,24599) ORDER BY Data DESC, Numero DESC
[(null)] 2023-06-27 19:28:26,940 [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-06-27 19:28:26,940 [19] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 25631
[(null)] 2023-06-27 19:28:27,090 [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-06-27 19:28:27,090 [19] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-06-27 19:28:27,100 [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-06-27 19:28:27,100 [19] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-06-27 19:28:27,100 [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'.