[(null)] 2023-12-09 08:43:28,624 [45] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 08:43:28,642 [45] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 08:43:34,486 [45] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 08:43:34,489 [45] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-12-09 08:43:34,508 [45] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-12-09 08:43:35,005 [45] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 08:43:35,005 [45] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 08:43:35,011 [45] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 08:43:35,014 [45] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-12-09 08:43:35,020 [45] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 08:43:35,021 [45] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-12-09 08:43:35,054 [45] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-12-09 08:43:35,078 [45] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31765,31688,31555,31477,31365,31190,31083,30999,30907,30784,30623,30504,30315,30216,30056,29952,29769,29637,29456,29331) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 09:22:09,063 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:22:09,063 [33] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 09:22:24,162 [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-12-09 09:22:24,164 [17] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000646'
[(null)] 2023-12-09 09:22:24,165 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 522
[(null)] 2023-12-09 09:22:24,277 [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-12-09 09:22:24,278 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 09:22:24,284 [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-12-09 09:22:24,284 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-12-09 09:22:24,291 [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-12-09 09:22:24,292 [17] 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-12-09 09:22:24,324 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-12-09 09:22:24,347 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31686,31687,31623,31469,31471,31406,31331,31194,31234,31046,31047,30958,30902,30838,30759,30720,30672,30631,30568,30471) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 09:22:33,525 [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-12-09 09:22:33,525 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 09:22:33,542 [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-12-09 09:22:33,542 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 09:22:33,549 [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-12-09 09:30:40,905 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:30:40,905 [59] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 09:30:52,107 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:30:52,110 [59] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000248'
[(null)] 2023-12-09 09:30:52,112 [59] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 226
[(null)] 2023-12-09 09:30:52,215 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:30:52,216 [59] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 09:30:52,225 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:30:52,225 [59] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2023-12-09 09:30:52,233 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:30:52,234 [59] 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-12-09 09:30:52,267 [59] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2023-12-09 09:30:52,291 [59] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31768,31705,31595,31545,31481,31378,31306,31210,31226,31095,31008,30963,30919,30789,30714,30627,30630,30524,30427,30336) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 09:31:03,577 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:31:03,577 [59] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 09:31:03,579 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:31:03,579 [59] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 09:31:03,585 [59] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:34:26,884 [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-12-09 09:34:26,885 [69] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 09:34:33,217 [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-12-09 09:34:33,220 [69] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2023-12-09 09:34:33,221 [69] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2023-12-09 09:34:33,353 [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-12-09 09:34:33,354 [69] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 09:34:33,360 [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-12-09 09:34:33,363 [69] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-12-09 09:34:33,370 [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-12-09 09:34:33,370 [69] 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-12-09 09:34:33,403 [69] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-12-09 09:34:33,427 [69] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31784,31709,31658,31610,31479,31492,31424,31374,31343,31305,31184,31214,31148,31089,31058,31009,30910,30917,30861,30808) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 09:34:41,292 [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-12-09 09:34:41,292 [69] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2023-12-09 09:34:41,296 [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-12-09 09:34:41,297 [69] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 09:34:41,298 [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-12-09 09:34:41,299 [69] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 09:34:41,300 [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-12-09 09:36:38,853 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:36:38,868 [25] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31833
[(null)] 2023-12-09 09:36:38,868 [25] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31833
[(null)] 2023-12-09 09:36:38,869 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:36:38,869 [25] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-12-09 09:36:38,872 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:36:38,874 [25] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31833
[(null)] 2023-12-09 09:36:38,974 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:36:39,165 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:36:39,165 [25] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2023-12-09 09:36:39,168 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:36:39,169 [25] 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-12-09 09:36:39,172 [25] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2023-12-09 09:36:39,175 [25] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31833,31768,31705,31595,31545,31481,31378,31306,31210,31226,31095,31008,30963,30919,30789,30714,30627,30630,30524,30427) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 09:38:30,939 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:30,954 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31834
[(null)] 2023-12-09 09:38:30,955 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31834
[(null)] 2023-12-09 09:38:30,956 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:30,956 [16] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-12-09 09:38:30,971 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:30,973 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31834
[(null)] 2023-12-09 09:38:39,551 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:39,551 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 31834
[(null)] 2023-12-09 09:38:39,722 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:39,722 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31834
[(null)] 2023-12-09 09:38:39,821 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:39,930 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:39,931 [16] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-12-09 09:38:39,934 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 09:38:39,934 [16] 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-12-09 09:38:39,938 [16] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-12-09 09:38:39,941 [16] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31834,31784,31709,31658,31610,31479,31492,31424,31374,31343,31305,31184,31214,31148,31089,31058,31009,30910,30917,30861) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 10:58:48,340 [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-12-09 10:58:48,343 [13] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000646'
[(null)] 2023-12-09 10:58:48,344 [13] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 522
[(null)] 2023-12-09 10:58:48,531 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 10:58:48,531 [33] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 10:58:48,563 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 10:58:48,567 [33] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-12-09 10:58:48,574 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 10:58:48,575 [33] 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-12-09 10:58:48,607 [33] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-12-09 10:58:48,630 [33] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31686,31687,31623,31469,31471,31406,31331,31194,31234,31046,31047,30958,30902,30838,30759,30720,30672,30631,30568,30471) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 10:58:59,952 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 10:58:59,952 [33] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 10:58:59,959 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 10:58:59,959 [33] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 10:58:59,964 [33] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:38,020 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:38,110 [51] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:38,112 [51] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:38,112 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:38,115 [51] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-12-09 11:04:38,118 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:38,120 [51] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:45,382 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:45,382 [51] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:45,575 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:45,575 [51] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:45,734 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=200;Connect Timeout=60'.
[(null)] 2023-12-09 11:04:55,839 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:55,839 [51] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:55,924 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 11:04:55,924 [51] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:04:56,014 [51] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=200;Connect Timeout=60'.
[(null)] 2023-12-09 11:05:27,683 [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-12-09 11:05:27,684 [13] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:05:28,528 [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-12-09 11:05:28,528 [13] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31835
[(null)] 2023-12-09 11:05:28,610 [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-12-09 11:05:28,807 [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-12-09 11:05:28,808 [13] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-12-09 11:05:28,810 [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-12-09 11:05:28,811 [13] 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-12-09 11:05:28,814 [13] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-12-09 11:05:28,816 [13] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31835,31686,31687,31623,31469,31471,31406,31331,31194,31234,31046,31047,30958,30902,30838,30759,30720,30672,30631,30568) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 12:36:09,621 [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-12-09 12:36:09,622 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 12:36:15,322 [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-12-09 12:36:15,323 [67] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-12-09 12:36:15,325 [67] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-12-09 12:36:15,514 [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-12-09 12:36:15,514 [67] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 12:36:15,521 [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-12-09 12:36:15,526 [67] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-12-09 12:36:15,533 [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-12-09 12:36:15,534 [67] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-12-09 12:36:15,566 [67] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-12-09 12:36:15,590 [67] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31805,31806,31807,31760,31762,31763,31767,31772,31773,31685,31690,31691,31693,31701,31704,31716,31724,31725,31628,31629) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 12:36:22,850 [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-12-09 12:36:22,850 [40] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-12-09 12:36:23,267 [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-12-09 12:36:23,268 [40] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 12:36:23,272 [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-12-09 12:36:23,272 [40] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 12:36:23,275 [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-12-09 12:39:40,128 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 12:39:40,138 [31] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31845
[(null)] 2023-12-09 12:39:40,139 [31] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31845
[(null)] 2023-12-09 12:39:40,139 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 12:39:40,140 [31] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-12-09 12:39:40,142 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 12:39:40,144 [31] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31845
[(null)] 2023-12-09 12:39:40,208 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 12:39:40,420 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 12:39:40,420 [31] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-12-09 12:39:40,423 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 12:39:40,424 [31] 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-12-09 12:39:40,427 [31] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-12-09 12:39:40,430 [31] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31845,31805,31806,31807,31760,31762,31763,31767,31772,31773,31685,31690,31691,31693,31701,31704,31716,31724,31725,31628) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 12:40:57,950 [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-12-09 12:40:57,951 [13] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000807'
[(null)] 2023-12-09 12:40:57,952 [13] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 683
[(null)] 2023-12-09 12:40:58,099 [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-12-09 12:40:58,100 [13] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 12:40:58,106 [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-12-09 12:40:58,107 [13] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[(null)] 2023-12-09 12:40:58,113 [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-12-09 12:40:58,114 [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-12-09 12:40:58,144 [13] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[(null)] 2023-12-09 12:40:58,168 [13] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31770,31702,31637,31594,31546,31489,31410,31372,31329,31290,31256,31213,31135,31098,31026,30995,30961,30903,30839,30787) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 12:41:01,519 [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-12-09 12:41:01,520 [13] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 12:41:01,523 [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-12-09 12:41:01,523 [13] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 12:41:01,528 [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-12-09 12:42:23,477 [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-12-09 12:42:23,487 [52] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31846
[(null)] 2023-12-09 12:42:23,488 [52] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 31846
[(null)] 2023-12-09 12:42:23,489 [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-12-09 12:42:23,491 [52] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-12-09 12:42:23,493 [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-12-09 12:42:23,494 [52] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31846
[(null)] 2023-12-09 12:42:25,457 [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-12-09 12:42:25,457 [52] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 31846
[(null)] 2023-12-09 12:42:25,628 [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-12-09 12:42:25,629 [52] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 31846
[(null)] 2023-12-09 12:42:25,675 [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-12-09 12:42:25,764 [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-12-09 12:42:25,765 [52] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[(null)] 2023-12-09 12:42:25,767 [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-12-09 12:42:25,767 [52] 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-12-09 12:42:25,770 [52] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[(null)] 2023-12-09 12:42:25,772 [52] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31846,31770,31702,31637,31594,31546,31489,31410,31372,31329,31290,31256,31213,31135,31098,31026,30995,30961,30903,30839) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 13:01:51,174 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:51,175 [31] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-12-09 13:01:51,175 [31] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-12-09 13:01:51,302 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:51,303 [31] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-12-09 13:01:51,311 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:51,314 [31] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-12-09 13:01:51,318 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:51,318 [31] 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-12-09 13:01:51,322 [31] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-12-09 13:01:51,325 [31] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (31845,31805,31806,31807,31760,31762,31763,31767,31772,31773,31685,31690,31691,31693,31701,31704,31716,31724,31725,31628) ORDER BY Data DESC, Numero DESC
[(null)] 2023-12-09 13:01:55,907 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:55,908 [31] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 31805
[(null)] 2023-12-09 13:01:56,070 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:56,080 [31] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-12-09 13:01:56,084 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:56,084 [31] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-12-09 13:01:56,085 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 13:01:56,085 [31] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-12-09 13:01:56,086 [31] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-12-09 16:53:04,508 [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-12-09 16:53:04,511 [40] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0