[(null)] 2022-03-11 09:27:32,901 [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)] 2022-03-11 09:27:32,963 [20] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:27:32,963 [20] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:27:35,706 [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)] 2022-03-11 09:27:35,706 [26] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2022-03-11 09:27:35,706 [26] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2022-03-11 09:27:35,815 [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)] 2022-03-11 09:27:35,815 [26] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:27:35,815 [26] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:27:35,815 [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)] 2022-03-11 09:27:35,815 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 09:27:35,831 [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)] 2022-03-11 09:27:35,831 [26] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 09:27:35,847 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 09:27:35,878 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852,5854,5859,5799) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 09:27:52,661 [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)] 2022-03-11 09:27:52,661 [25] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2022-03-11 09:27:52,661 [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)] 2022-03-11 09:27:52,661 [25] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 09:27:52,677 [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)] 2022-03-11 09:27:52,677 [25] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 09:27:52,693 [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)] 2022-03-11 09:34:25,271 [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)] 2022-03-11 09:34:25,303 [20] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:34:25,303 [20] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:34:25,303 [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)] 2022-03-11 09:34:25,303 [20] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 09:34:25,303 [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)] 2022-03-11 09:34:25,318 [20] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:34:32,807 [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)] 2022-03-11 09:34:32,807 [20] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:34:32,886 [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)] 2022-03-11 09:34:32,886 [20] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:34:32,948 [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=200;Connect Timeout=60'.
[(null)] 2022-03-11 09:36:49,782 [18] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:36:49,782 [18] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:36:49,797 [18] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:36:49,797 [18] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6122
[(null)] 2022-03-11 09:36:49,828 [18] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:36:49,985 [18] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:36:49,985 [18] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 09:36:50,000 [18] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:36:50,000 [18] 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)] 2022-03-11 09:36:50,000 [18] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 09:36:50,000 [18] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852,5854,5859) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 09:40:02,890 [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)] 2022-03-11 09:40:02,890 [22] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:40:02,890 [22] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:40:06,603 [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)] 2022-03-11 09:40:06,603 [22] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2022-03-11 09:40:06,603 [22] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2022-03-11 09:40:06,697 [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)] 2022-03-11 09:40:06,697 [22] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:40:06,697 [22] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:40:06,712 [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)] 2022-03-11 09:40:06,712 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2022-03-11 09:40:06,712 [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)] 2022-03-11 09:40:06,712 [22] 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)] 2022-03-11 09:40:06,743 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2022-03-11 09:40:06,759 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6095,5964,5917,5855,5751,5703,5646,5594,5566,5489,5440,5401,5375,5290,5214,5180,5128,5087,5012,4900) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 09:40:18,880 [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)] 2022-03-11 09:40:18,880 [22] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 09:40:18,880 [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)] 2022-03-11 09:40:18,880 [22] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 09:40:18,880 [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)] 2022-03-11 09:43:06,962 [27] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:43:06,962 [27] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6123
[(null)] 2022-03-11 09:43:06,962 [27] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6123
[(null)] 2022-03-11 09:43:06,962 [27] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:43:06,962 [27] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 09:43:06,978 [27] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:43:06,978 [27] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6123
[(null)] 2022-03-11 09:43:07,041 [27] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:43:07,119 [27] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:43:07,119 [27] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2022-03-11 09:43:07,119 [27] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 09:43:07,119 [27] 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)] 2022-03-11 09:43:07,119 [27] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2022-03-11 09:43:07,119 [27] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6123,6095,5964,5917,5855,5751,5703,5646,5594,5566,5489,5440,5401,5375,5290,5214,5180,5128,5087,5012) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 09:57:59,575 [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)] 2022-03-11 09:57:59,575 [19] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000302'
[(null)] 2022-03-11 09:57:59,575 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 255
[(null)] 2022-03-11 09:57:59,922 [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)] 2022-03-11 09:57:59,922 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:57:59,937 [19] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 09:57:59,937 [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)] 2022-03-11 09:57:59,937 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 255 ORDER BY Descrizione
[(null)] 2022-03-11 09:57:59,953 [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)] 2022-03-11 09:57:59,953 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 09:57:59,968 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1
[(null)] 2022-03-11 09:58:00,000 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6077,6027,5992,5943,5905,5856,5801,5753,5704,5649,5609,5554,5490,5443,5412,5371,5335,5278,5230,5175) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:00:38,194 [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)] 2022-03-11 10:00:38,194 [24] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 10:00:38,210 [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)] 2022-03-11 10:00:38,210 [24] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 10:00:38,210 [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)] 2022-03-11 10:37:32,703 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:37:32,703 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:37:32,703 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:37:47,973 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:37:47,973 [15] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2022-03-11 10:37:47,973 [15] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2022-03-11 10:37:48,082 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:37:48,082 [15] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:37:48,082 [15] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:37:48,082 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:37:48,098 [15] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 10:37:48,098 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:37:48,098 [15] 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)] 2022-03-11 10:37:48,129 [15] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 10:37:48,145 [15] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852,5854,5859) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:37:56,278 [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)] 2022-03-11 10:37:56,278 [22] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2022-03-11 10:37:56,278 [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)] 2022-03-11 10:37:56,294 [22] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 10:37:56,294 [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)] 2022-03-11 10:37:56,294 [22] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 10:37:56,294 [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)] 2022-03-11 10:38:04,467 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:38:04,467 [15] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:38:04,467 [15] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:38:11,015 [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)] 2022-03-11 10:38:11,015 [22] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000229'
[(null)] 2022-03-11 10:38:11,015 [22] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 217
[(null)] 2022-03-11 10:38:11,095 [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)] 2022-03-11 10:38:11,095 [22] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:38:11,110 [22] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:38:11,110 [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)] 2022-03-11 10:38:11,110 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 217 ORDER BY Descrizione
[(null)] 2022-03-11 10:38:11,110 [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)] 2022-03-11 10:38:11,110 [22] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 217 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 10:38:11,142 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 217 And CodTipo = 1
[(null)] 2022-03-11 10:38:11,157 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6072,6042,5988,5935,5907,5850,5791,5760,5712,5636,5596,5546,5493,5450,5402,5363,5340,5285,5215,5177) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:38:13,809 [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)] 2022-03-11 10:38:13,809 [22] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 10:38:13,809 [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)] 2022-03-11 10:38:13,809 [22] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 10:38:13,809 [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)] 2022-03-11 10:41:18,134 [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)] 2022-03-11 10:41:18,165 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6127
[(null)] 2022-03-11 10:41:18,165 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6127
[(null)] 2022-03-11 10:41:18,165 [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)] 2022-03-11 10:41:18,180 [17] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 10:41:18,180 [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)] 2022-03-11 10:41:18,212 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6127
[(null)] 2022-03-11 10:41:18,290 [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)] 2022-03-11 10:41:18,446 [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)] 2022-03-11 10:41:18,446 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 217 ORDER BY Descrizione
[(null)] 2022-03-11 10:41:18,446 [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)] 2022-03-11 10:41:18,446 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 217 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 10:41:18,477 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 217 And CodTipo = 1
[(null)] 2022-03-11 10:41:18,493 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6127,6072,6042,5988,5935,5907,5850,5791,5760,5712,5636,5596,5546,5493,5450,5402,5363,5340,5285,5215) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:41:29,399 [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)] 2022-03-11 10:41:29,524 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6128
[(null)] 2022-03-11 10:41:29,524 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6128
[(null)] 2022-03-11 10:41:29,524 [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)] 2022-03-11 10:41:29,524 [17] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 10:41:29,539 [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)] 2022-03-11 10:41:29,539 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6128
[(null)] 2022-03-11 10:41:29,696 [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)] 2022-03-11 10:41:29,821 [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)] 2022-03-11 10:41:29,821 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 10:41:29,836 [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)] 2022-03-11 10:41:29,836 [17] 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)] 2022-03-11 10:41:29,867 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 10:41:29,883 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6128,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852,5854) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:41:36,303 [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)] 2022-03-11 10:41:36,303 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2022-03-11 10:41:36,318 [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)] 2022-03-11 10:41:36,318 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 10:41:36,334 [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)] 2022-03-11 10:41:36,334 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 10:41:36,334 [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)] 2022-03-11 10:45:12,615 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:45:12,615 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:45:12,615 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:45:15,376 [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)] 2022-03-11 10:45:15,376 [25] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2022-03-11 10:45:15,376 [25] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2022-03-11 10:45:15,454 [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)] 2022-03-11 10:45:15,454 [25] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:45:15,454 [25] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:45:15,454 [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)] 2022-03-11 10:45:15,454 [25] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 10:45:15,470 [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)] 2022-03-11 10:45:15,470 [25] 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)] 2022-03-11 10:45:15,470 [25] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 10:45:15,470 [25] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6128,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852,5854) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:45:20,661 [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)] 2022-03-11 10:45:20,661 [25] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2022-03-11 10:45:20,661 [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)] 2022-03-11 10:45:20,661 [25] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 10:45:20,677 [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)] 2022-03-11 10:45:20,677 [25] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 10:45:20,677 [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)] 2022-03-11 10:52:27,129 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:52:27,129 [28] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:52:27,145 [28] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:52:30,386 [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)] 2022-03-11 10:52:30,402 [17] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000017'
[(null)] 2022-03-11 10:52:30,402 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 16
[(null)] 2022-03-11 10:52:30,511 [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)] 2022-03-11 10:52:30,511 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:52:30,511 [17] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 10:52:30,511 [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)] 2022-03-11 10:52:30,511 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 16 ORDER BY Descrizione
[(null)] 2022-03-11 10:52:30,527 [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)] 2022-03-11 10:52:30,527 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 10:52:30,542 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1
[(null)] 2022-03-11 10:52:30,574 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6047,5942,5857,5754,5639,5556,5444,5362,5283,5179,4989,4885,4801,4729,4639,4530,4449,4356,4274,4204) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 10:52:54,910 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:52:54,910 [14] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 10:52:54,926 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 10:52:54,926 [14] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 10:52:54,926 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:11,646 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:11,646 [28] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2022-03-11 11:00:11,646 [28] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2022-03-11 11:00:11,771 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:11,771 [28] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:00:11,771 [28] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:00:11,771 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:11,771 [28] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2022-03-11 11:00:11,787 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:11,787 [28] 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)] 2022-03-11 11:00:11,802 [28] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2022-03-11 11:00:11,834 [28] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6082,6040,5995,5955,5919,5864,5816,5764,5718,5676,5618,5560,5511,5461,5413,5373,5341,5299,5244,5191) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:00:14,176 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:14,176 [28] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 11:00:14,176 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:00:14,176 [28] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 11:00:14,176 [28] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:04,011 [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)] 2022-03-11 11:03:04,089 [24] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6129
[(null)] 2022-03-11 11:03:04,089 [24] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6129
[(null)] 2022-03-11 11:03:04,089 [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)] 2022-03-11 11:03:04,105 [24] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 11:03:04,105 [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)] 2022-03-11 11:03:04,105 [24] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6129
[(null)] 2022-03-11 11:03:04,292 [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)] 2022-03-11 11:03:04,433 [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)] 2022-03-11 11:03:04,433 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 11:03:04,433 [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)] 2022-03-11 11:03:04,433 [24] 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)] 2022-03-11 11:03:04,464 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 11:03:04,480 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6128,6129,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6130
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6130
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:42,571 [15] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6130
[(null)] 2022-03-11 11:03:42,649 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:42,712 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:42,712 [15] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2022-03-11 11:03:42,712 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:03:42,712 [15] 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)] 2022-03-11 11:03:42,743 [15] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2022-03-11 11:03:42,759 [15] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6130,6082,6040,5995,5955,5919,5864,5816,5764,5718,5676,5618,5560,5511,5461,5413,5373,5341,5299,5244) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:06:16,174 [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)] 2022-03-11 11:06:16,174 [25] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:06:16,174 [25] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:06:47,419 [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)] 2022-03-11 11:06:47,419 [19] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000302'
[(null)] 2022-03-11 11:06:47,419 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 255
[(null)] 2022-03-11 11:06:48,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)] 2022-03-11 11:06:48,652 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:06:48,652 [19] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:06:48,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)] 2022-03-11 11:06:48,652 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 255 ORDER BY Descrizione
[(null)] 2022-03-11 11:06:48,668 [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)] 2022-03-11 11:06:48,668 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 11:06:48,683 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1
[(null)] 2022-03-11 11:06:48,714 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6077,6027,5992,5943,5905,5856,5801,5753,5704,5649,5609,5554,5490,5443,5412,5371,5335,5278,5230,5175) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:07:03,070 [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)] 2022-03-11 11:07:03,070 [16] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 11:07:03,070 [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)] 2022-03-11 11:07:03,070 [16] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 11:07:03,085 [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)] 2022-03-11 11:07:13,088 [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)] 2022-03-11 11:07:13,088 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:07:13,104 [19] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:07:26,633 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:07:26,633 [9] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2022-03-11 11:07:26,648 [9] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2022-03-11 11:07:26,742 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:07:26,742 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:07:26,742 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:07:26,742 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:07:26,742 [9] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 11:07:26,758 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:07:26,758 [9] 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)] 2022-03-11 11:07:26,789 [9] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 11:07:26,836 [9] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6128,6129,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851,5852) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:07:47,769 [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)] 2022-03-11 11:07:47,769 [26] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2022-03-11 11:07:47,785 [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)] 2022-03-11 11:07:47,785 [26] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 11:07:47,785 [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)] 2022-03-11 11:07:47,785 [26] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 11:07:47,785 [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)] 2022-03-11 11:09:18,092 [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)] 2022-03-11 11:09:18,170 [25] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6131
[(null)] 2022-03-11 11:09:18,186 [25] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6131
[(null)] 2022-03-11 11:09:18,186 [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)] 2022-03-11 11:09:18,186 [25] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 11:09:18,186 [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)] 2022-03-11 11:09:18,186 [25] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6131
[(null)] 2022-03-11 11:09:50,337 [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)] 2022-03-11 11:09:50,337 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6131
[(null)] 2022-03-11 11:09:50,524 [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)] 2022-03-11 11:09:50,524 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6131
[(null)] 2022-03-11 11:09:50,712 [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)] 2022-03-11 11:09:50,899 [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)] 2022-03-11 11:09:50,899 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 16 ORDER BY Descrizione
[(null)] 2022-03-11 11:09:50,899 [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)] 2022-03-11 11:09:50,899 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 11:09:50,931 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 16 And CodTipo = 1
[(null)] 2022-03-11 11:09:50,946 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6131,6047,5942,5857,5754,5639,5556,5444,5362,5283,5179,4989,4885,4801,4729,4639,4530,4449,4356,4274) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6132
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6132
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:11:22,931 [14] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6132
[(null)] 2022-03-11 11:11:23,040 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:11:23,103 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:11:23,103 [14] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2022-03-11 11:11:23,118 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 11:11:23,118 [14] 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)] 2022-03-11 11:11:23,150 [14] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2022-03-11 11:11:23,165 [14] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6122,6128,6129,6132,6074,6080,6036,6044,6045,6050,6051,5982,5987,5936,5941,5894,5896,5897,5914,5851) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:22:54,924 [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)] 2022-03-11 11:22:54,924 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 255 ORDER BY Descrizione
[(null)] 2022-03-11 11:22:54,924 [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)] 2022-03-11 11:22:54,924 [22] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 11:22:54,955 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1
[(null)] 2022-03-11 11:22:54,971 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6077,6027,5992,5943,5905,5856,5801,5753,5704,5649,5609,5554,5490,5443,5412,5371,5335,5278,5230,5175) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:23:03,921 [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)] 2022-03-11 11:23:03,921 [22] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 11:23:03,921 [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)] 2022-03-11 11:23:03,921 [22] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 11:23:03,921 [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)] 2022-03-11 11:24:46,399 [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)] 2022-03-11 11:24:46,399 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:24:46,399 [17] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:24:51,248 [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)] 2022-03-11 11:24:51,264 [17] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2022-03-11 11:24:51,264 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2022-03-11 11:24:51,369 [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)] 2022-03-11 11:24:51,369 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:24:51,369 [17] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:24:51,369 [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)] 2022-03-11 11:24:51,369 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2022-03-11 11:24:51,369 [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)] 2022-03-11 11:24:51,369 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 11:24:51,400 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2022-03-11 11:24:51,416 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6075,6048,6024,5994,5957,5918,5916,5746,5747,5748,5597,5599,5601,5576,5519,5468,5423,5379,5383,5287) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:33:40,604 [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)] 2022-03-11 11:33:40,698 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6133
[(null)] 2022-03-11 11:33:40,698 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6133
[(null)] 2022-03-11 11:33:40,698 [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)] 2022-03-11 11:33:40,698 [19] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 11:33:40,698 [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)] 2022-03-11 11:33:40,698 [19] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6133
[(null)] 2022-03-11 11:33:40,963 [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)] 2022-03-11 11:33:41,260 [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)] 2022-03-11 11:33:41,260 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 255 ORDER BY Descrizione
[(null)] 2022-03-11 11:33:41,260 [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)] 2022-03-11 11:33:41,260 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 11:33:41,276 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 255 And CodTipo = 1
[(null)] 2022-03-11 11:33:41,276 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6133,6077,6027,5992,5943,5905,5856,5801,5753,5704,5649,5609,5554,5490,5443,5412,5371,5335,5278,5230) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 11:43:20,483 [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)] 2022-03-11 11:43:20,483 [16] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 11:43:20,483 [16] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:19:11,590 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:19:11,590 [6] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2022-03-11 12:19:11,590 [6] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2022-03-11 12:19:11,699 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:19:11,699 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:19:11,699 [6] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:19:11,715 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:19:11,715 [6] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2022-03-11 12:19:11,715 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:19:11,715 [6] 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)] 2022-03-11 12:19:11,730 [6] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2022-03-11 12:19:11,762 [6] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6075,6048,6024,5994,5957,5918,5916,5746,5747,5748,5597,5599,5601,5576,5519,5468,5423,5379,5383,5287) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 12:19:14,811 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:19:14,811 [6] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 12:19:14,827 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:19:14,827 [6] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 12:19:14,827 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:24:02,394 [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)] 2022-03-11 12:24:02,394 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6139
[(null)] 2022-03-11 12:24:02,394 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6139
[(null)] 2022-03-11 12:24:02,394 [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)] 2022-03-11 12:24:02,394 [26] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 12:24:02,394 [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)] 2022-03-11 12:24:02,410 [26] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6139
[(null)] 2022-03-11 12:24:02,550 [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)] 2022-03-11 12:24:02,691 [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)] 2022-03-11 12:24:02,691 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2022-03-11 12:24:02,691 [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)] 2022-03-11 12:24:02,691 [26] 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)] 2022-03-11 12:24:02,691 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2022-03-11 12:24:02,707 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6139,6075,6048,6024,5994,5957,5918,5916,5746,5747,5748,5597,5599,5601,5576,5519,5468,5423,5379,5383) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 12:24:10,023 [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)] 2022-03-11 12:24:10,023 [26] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 12:24:10,023 [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)] 2022-03-11 12:24:10,023 [26] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 12:24:10,023 [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)] 2022-03-11 12:26:26,663 [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)] 2022-03-11 12:26:26,694 [24] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6140
[(null)] 2022-03-11 12:26:26,694 [24] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6140
[(null)] 2022-03-11 12:26:26,694 [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)] 2022-03-11 12:26:26,694 [24] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6140
[(null)] 2022-03-11 12:26:26,756 [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)] 2022-03-11 12:26:27,151 [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)] 2022-03-11 12:26:27,151 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2022-03-11 12:26:27,167 [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)] 2022-03-11 12:26:27,167 [24] 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)] 2022-03-11 12:26:27,198 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2022-03-11 12:26:27,214 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6139,6140,6075,6048,6024,5994,5957,5918,5916,5746,5747,5748,5597,5599,5601,5576,5519,5468,5423,5379) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 12:42:06,271 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:06,271 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:42:06,271 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:42:09,229 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:09,229 [9] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000248'
[(null)] 2022-03-11 12:42:09,245 [9] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 226
[(null)] 2022-03-11 12:42:09,323 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:09,323 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:42:09,323 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:42:09,339 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:09,339 [9] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2022-03-11 12:42:09,339 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:09,339 [9] 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)] 2022-03-11 12:42:09,370 [9] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2022-03-11 12:42:09,401 [9] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6096,6046,6007,5958,5915,5860,5814,5765,5713,5666,5617,5558,5501,5448,5422,5376,5331,5286,5231,5187) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 12:42:13,148 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:13,148 [9] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 12:42:13,164 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:42:13,164 [9] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 12:42:13,164 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 12:56:29,995 [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)] 2022-03-11 12:56:29,995 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:56:30,010 [24] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:56:35,299 [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)] 2022-03-11 12:56:35,299 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2022-03-11 12:56:35,299 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2022-03-11 12:56:35,424 [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)] 2022-03-11 12:56:35,424 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:56:35,424 [24] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:56:35,440 [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)] 2022-03-11 12:56:35,440 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2022-03-11 12:56:35,440 [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)] 2022-03-11 12:56:35,440 [24] 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)] 2022-03-11 12:56:35,471 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2022-03-11 12:56:35,487 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6097,6043,6005,5960,5920,5867,5811,5763,5717,5679,5619,5570,5507,5446,5419,5378,5345,5305,5249,5176) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 12:56:42,848 [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)] 2022-03-11 12:56:42,848 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2022-03-11 12:56:42,863 [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)] 2022-03-11 12:56:42,863 [19] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 12:56:42,863 [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)] 2022-03-11 12:56:42,863 [19] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 12:56:42,863 [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)] 2022-03-11 12:57:55,004 [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)] 2022-03-11 12:57:55,004 [16] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 12:57:55,269 [16] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 13:13:23,743 [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)] 2022-03-11 13:13:23,743 [23] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 13:13:23,743 [23] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 13:13:23,743 [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)] 2022-03-11 13:13:23,743 [23] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 13:13:23,759 [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)] 2022-03-11 13:13:23,759 [23] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 13:13:35,052 [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)] 2022-03-11 13:13:35,052 [23] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 13:13:35,130 [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)] 2022-03-11 13:13:35,130 [23] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 13:13:35,271 [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)] 2022-03-11 13:13:35,991 [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)] 2022-03-11 13:13:35,991 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2022-03-11 13:13:36,006 [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)] 2022-03-11 13:13:36,006 [23] 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)] 2022-03-11 13:13:36,038 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2022-03-11 13:13:36,053 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6145,6097,6043,6005,5960,5920,5867,5811,5763,5717,5679,5619,5570,5507,5446,5419,5378,5345,5305,5249) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 13:45:01,120 [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)] 2022-03-11 13:45:01,120 [25] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 13:45:01,120 [25] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 13:45:03,693 [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)] 2022-03-11 13:45:03,693 [25] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000248'
[(null)] 2022-03-11 13:45:03,709 [25] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 226
[(null)] 2022-03-11 13:45:03,803 [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)] 2022-03-11 13:45:03,803 [25] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 13:45:03,818 [25] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 13:45:03,818 [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)] 2022-03-11 13:45:03,818 [25] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2022-03-11 13:45:03,834 [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)] 2022-03-11 13:45:03,834 [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)] 2022-03-11 13:45:03,881 [25] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2022-03-11 13:45:03,896 [25] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6096,6046,6007,5958,5915,5860,5814,5765,5713,5666,5617,5558,5501,5448,5422,5376,5331,5286,5231,5187) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 13:45:07,579 [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)] 2022-03-11 13:45:07,579 [25] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 13:45:07,595 [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)] 2022-03-11 13:45:07,595 [25] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 13:45:07,595 [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)] 2022-03-11 13:46:55,110 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 13:46:55,126 [14] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6146
[(null)] 2022-03-11 13:46:55,126 [14] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6146
[(null)] 2022-03-11 13:46:55,126 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 13:46:55,126 [14] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 13:46:55,126 [14] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 13:46:55,126 [14] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6146
[(null)] 2022-03-11 13:52:48,341 [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)] 2022-03-11 13:52:48,341 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6146
[(null)] 2022-03-11 13:52:48,404 [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)] 2022-03-11 13:52:48,404 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6146
[(null)] 2022-03-11 13:52:48,466 [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)] 2022-03-11 13:52:48,529 [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)] 2022-03-11 13:52:48,529 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 226 ORDER BY Descrizione
[(null)] 2022-03-11 13:52:48,544 [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)] 2022-03-11 13:52:48,544 [17] 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)] 2022-03-11 13:52:48,544 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 226 And CodTipo = 1
[(null)] 2022-03-11 13:52:48,544 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6146,6096,6046,6007,5958,5915,5860,5814,5765,5713,5666,5617,5558,5501,5448,5422,5376,5331,5286,5231) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 14:05:12,243 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:12,243 [6] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '0000428'
[(null)] 2022-03-11 14:05:12,243 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:12,259 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 14:05:12,259 [6] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 14:05:19,216 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:19,216 [6] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000428'
[(null)] 2022-03-11 14:05:19,216 [6] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 304
[(null)] 2022-03-11 14:05:19,339 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:19,339 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 14:05:19,354 [6] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 14:05:19,354 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:19,354 [6] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 304 ORDER BY Descrizione
[(null)] 2022-03-11 14:05:19,370 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:19,370 [6] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 304 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 14:05:19,385 [6] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 304 And CodTipo = 1
[(null)] 2022-03-11 14:05:19,401 [6] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6098,6049,6006,5959,5866,5808,5770,5715,5677,5562,5496,5464,5420,5377,5300,5243,5178,5144,5104,4997) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 14:05:22,959 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:22,959 [6] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 14:05:22,959 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:05:22,959 [6] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 14:05:22,959 [6] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 14:07:04,580 [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)] 2022-03-11 14:07:04,595 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6147
[(null)] 2022-03-11 14:07:04,595 [17] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6147
[(null)] 2022-03-11 14:07:04,595 [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)] 2022-03-11 14:07:04,595 [17] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 14:07:04,595 [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)] 2022-03-11 14:07:04,595 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6147
[(null)] 2022-03-11 14:07:04,627 [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)] 2022-03-11 14:07:04,705 [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)] 2022-03-11 14:07:04,705 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 304 ORDER BY Descrizione
[(null)] 2022-03-11 14:07:04,705 [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)] 2022-03-11 14:07:04,705 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 304 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2022-03-11 14:07:04,705 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 304 And CodTipo = 1
[(null)] 2022-03-11 14:07:04,705 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6147,6098,6049,6006,5959,5866,5808,5770,5715,5677,5562,5496,5464,5420,5377,5300,5243,5178,5144,5104) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 15:58:12,461 [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)] 2022-03-11 15:58:12,461 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 15:58:12,461 [23] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 15:58:18,987 [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)] 2022-03-11 15:58:18,987 [23] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2022-03-11 15:58:18,987 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2022-03-11 15:58:19,112 [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)] 2022-03-11 15:58:19,112 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 15:58:19,112 [23] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 15:58:19,128 [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)] 2022-03-11 15:58:19,128 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2022-03-11 15:58:19,128 [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)] 2022-03-11 15:58:19,128 [23] 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)] 2022-03-11 15:58:19,128 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2022-03-11 15:58:19,128 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6145,6097,6043,6005,5960,5920,5867,5811,5763,5717,5679,5619,5570,5507,5446,5419,5378,5345,5305,5249) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 15:58:23,896 [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)] 2022-03-11 15:58:23,896 [23] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 15:58:23,911 [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)] 2022-03-11 15:58:23,911 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2022-03-11 15:58:23,911 [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)] 2022-03-11 15:58:23,911 [23] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 15:58:23,927 [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)] 2022-03-11 15:58:23,927 [23] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 15:58:23,927 [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)] 2022-03-11 18:40:01,242 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 18:40:01,248 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:40:01,248 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:40:04,602 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 18:40:04,602 [9] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2022-03-11 18:40:04,602 [9] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2022-03-11 18:40:04,711 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 18:40:04,711 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:40:04,711 [9] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:40:04,711 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 18:40:04,711 [9] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2022-03-11 18:40:04,727 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2022-03-11 18:40:04,727 [9] 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)] 2022-03-11 18:40:04,742 [9] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2022-03-11 18:40:04,758 [9] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6139,6140,6141,6075,6048,6024,5994,5957,5918,5916,5746,5747,5748,5597,5599,5601,5576,5519,5468,5423) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 18:40:27,751 [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)] 2022-03-11 18:40:27,751 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 18:40:27,751 [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)] 2022-03-11 18:40:27,751 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 18:40:27,766 [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)] 2022-03-11 18:50:21,968 [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)] 2022-03-11 18:50:21,983 [20] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6149
[(null)] 2022-03-11 18:50:21,983 [20] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 6149
[(null)] 2022-03-11 18:50:21,983 [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)] 2022-03-11 18:50:21,983 [20] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2022-03-11 18:50:21,983 [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)] 2022-03-11 18:50:21,983 [20] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 6149
[(null)] 2022-03-11 18:50:22,124 [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)] 2022-03-11 18:50:22,218 [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)] 2022-03-11 18:50:22,218 [20] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2022-03-11 18:50:22,218 [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)] 2022-03-11 18:50:22,218 [20] 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)] 2022-03-11 18:50:22,218 [20] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2022-03-11 18:50:22,218 [20] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6139,6140,6141,6149,6075,6048,6024,5994,5957,5918,5916,5746,5747,5748,5597,5599,5601,5576,5519,5468) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 18:50:55,138 [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)] 2022-03-11 18:50:55,138 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:50:55,138 [17] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:50:59,774 [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)] 2022-03-11 18:50:59,774 [17] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2022-03-11 18:50:59,774 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2022-03-11 18:50:59,910 [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)] 2022-03-11 18:50:59,910 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:50:59,915 [17] DEBUG Query - ExecuteReader: SELECT Codice, WebWidth FROM LocStrings WHERE CodLingua = 0
[(null)] 2022-03-11 18:50:59,915 [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)] 2022-03-11 18:50:59,915 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2022-03-11 18:50:59,915 [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)] 2022-03-11 18:50:59,915 [17] 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)] 2022-03-11 18:50:59,915 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2022-03-11 18:50:59,915 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (6145,6097,6043,6005,5960,5920,5867,5811,5763,5717,5679,5619,5570,5507,5446,5419,5378,5345,5305,5249) ORDER BY Data DESC, Numero DESC
[(null)] 2022-03-11 18:51:04,183 [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)] 2022-03-11 18:51:04,183 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 6145
[(null)] 2022-03-11 18:51:04,199 [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)] 2022-03-11 18:51:04,199 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2022-03-11 18:51:04,199 [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)] 2022-03-11 18:51:04,199 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2022-03-11 18:51:04,199 [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)] 2022-03-11 18:51:04,199 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2022-03-11 18:51:04,199 [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'.