[(null)] 2023-03-23 09:10:18,876 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:18,921 [3] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:10:22,944 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:22,948 [3] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-03-23 09:10:23,008 [3] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-03-23 09:10:23,203 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:23,204 [3] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:10:23,211 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:23,217 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:10:23,228 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:23,228 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 09:10:23,278 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:10:23,357 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098,21099,21100,21101,21102) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:10:43,200 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:43,200 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-03-23 09:10:43,812 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:43,812 [19] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 09:10:43,984 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:10:43,985 [19] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 09:10:44,005 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:11,618 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:11,723 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:11,725 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:11,726 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:11,729 [16] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 09:22:11,750 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:11,754 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:20,477 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:20,477 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:21,916 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:21,916 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:23,156 [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=200;Connect Timeout=60'.
[(null)] 2023-03-23 09:22:59,457 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:59,459 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:59,528 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:59,528 [17] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21363
[(null)] 2023-03-23 09:22:59,738 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:59,955 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:59,956 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:22:59,962 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:22:59,962 [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)] 2023-03-23 09:22:59,966 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:22:59,970 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098,21099,21100,21101) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:23:06,210 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:23:06,211 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[(null)] 2023-03-23 09:23:06,214 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:23:06,215 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 09:23:06,220 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:23:06,220 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 09:23:06,222 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:23:51,888 [9] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:23:51,888 [9] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:24:00,959 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:24:00,959 [3] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-03-23 09:24:00,960 [3] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-03-23 09:24:01,117 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:24:01,117 [3] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:24:01,130 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:24:01,134 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-03-23 09:24:01,141 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:24:01,142 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 09:24:01,180 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-03-23 09:24:01,209 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21303,21274,21217,21124,21126,21128,21138,21028,20985,20942,20856,20839,20776,20787,20729,20668,20614,20564,20474,20479) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:26:54,145 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:26:54,145 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:27:19,862 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:27:19,864 [22] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '000001234'
[(null)] 2023-03-23 09:27:19,867 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:27:19,870 [22] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:27:50,285 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:27:50,286 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:28:29,109 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:28:29,113 [15] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-03-23 09:28:29,114 [15] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-03-23 09:28:29,140 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:28:29,142 [15] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:28:43,681 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:28:43,682 [15] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:29:05,253 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:29:05,254 [17] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-03-23 09:29:05,255 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-03-23 09:29:05,368 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:29:05,369 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:29:05,377 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:29:05,382 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:29:05,387 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:29:05,388 [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)] 2023-03-23 09:29:05,391 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:29:05,394 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098,21099,21100,21101) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:30:46,171 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:30:46,172 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-03-23 09:30:46,177 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:30:46,177 [23] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 09:30:46,179 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:30:46,179 [23] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 09:30:46,180 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:35:26,934 [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)] 2023-03-23 09:35:26,973 [18] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21364
[(null)] 2023-03-23 09:35:26,994 [18] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21364
[(null)] 2023-03-23 09:35:27,007 [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)] 2023-03-23 09:35:27,008 [18] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 09:35:27,018 [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)] 2023-03-23 09:35:27,068 [18] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21364
[(null)] 2023-03-23 09:35:27,547 [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)] 2023-03-23 09:35:27,633 [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)] 2023-03-23 09:35:27,634 [18] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:35:27,639 [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)] 2023-03-23 09:35:27,640 [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)] 2023-03-23 09:35:27,643 [18] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:35:27,646 [18] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098,21099,21100) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:36:01,448 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:36:01,461 [12] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:36:01,464 [12] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:36:01,465 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:36:01,466 [12] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:36:12,731 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:36:12,731 [12] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:36:13,443 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:36:13,444 [12] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:36:13,569 [12] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=200;Connect Timeout=60'.
[(null)] 2023-03-23 09:39:10,138 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:10,139 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:39:10,211 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:10,212 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:39:17,102 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:17,103 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:39:17,172 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:17,173 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:39:17,256 [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=200;Connect Timeout=60'.
[(null)] 2023-03-23 09:39:33,918 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:33,919 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:39:34,021 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:34,021 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21365
[(null)] 2023-03-23 09:39:34,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)] 2023-03-23 09:39:34,168 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:34,168 [16] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:39:34,174 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:39:34,175 [16] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 09:39:34,178 [16] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:39:34,181 [16] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21365,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098,21099) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:40:57,857 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:40:57,859 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:41:15,504 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:41:15,505 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-03-23 09:41:15,506 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-03-23 09:41:15,607 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:41:15,608 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 09:41:15,616 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:41:15,624 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:41:15,629 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:41:15,630 [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)] 2023-03-23 09:41:15,634 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:41:15,637 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21365,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098,21099) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 09:41:42,082 [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)] 2023-03-23 09:41:42,082 [18] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[(null)] 2023-03-23 09:41:42,194 [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)] 2023-03-23 09:41:42,195 [18] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 09:41:42,210 [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)] 2023-03-23 09:41:42,210 [18] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 09:41:42,213 [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)] 2023-03-23 09:43:36,622 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:43:36,623 [16] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 09:43:36,625 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:43:36,625 [16] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 09:43:36,629 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,765 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,776 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21366
[(null)] 2023-03-23 09:51:42,777 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21366
[(null)] 2023-03-23 09:51:42,778 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,778 [19] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 09:51:42,781 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,782 [19] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21366
[(null)] 2023-03-23 09:51:42,871 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,957 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,958 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 09:51:42,962 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 09:51:42,963 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 09:51:42,967 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 09:51:42,970 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21365,21366,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:11:02,195 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:11:02,196 [3] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:11:09,332 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:11:09,332 [19] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-03-23 10:11:09,333 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-03-23 10:11:09,436 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:11:09,445 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:11:09,456 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:11:09,456 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-03-23 10:11:09,470 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:11:09,471 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 10:11:09,473 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-03-23 10:11:09,476 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21303,21274,21217,21124,21126,21128,21138,21028,20985,20942,20856,20839,20776,20787,20729,20668,20614,20564,20474,20479) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:11:19,150 [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)] 2023-03-23 10:11:19,152 [27] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21303
[(null)] 2023-03-23 10:11:19,349 [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)] 2023-03-23 10:11:19,351 [27] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 10:11:19,352 [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)] 2023-03-23 10:11:19,353 [27] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 10:11:19,354 [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)] 2023-03-23 10:14:28,141 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:14:28,142 [23] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-03-23 10:14:28,143 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-03-23 10:14:28,233 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:14:28,233 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:14:28,243 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:14:28,244 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-03-23 10:14:28,249 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:14:28,250 [23] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 10:14:28,258 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-03-23 10:14:28,261 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21303,21274,21217,21124,21126,21128,21138,21028,20985,20942,20856,20839,20776,20787,20729,20668,20614,20564,20474,20479) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:14:45,468 [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)] 2023-03-23 10:14:45,469 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:14:49,019 [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)] 2023-03-23 10:14:49,023 [6] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[(null)] 2023-03-23 10:14:49,023 [6] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[(null)] 2023-03-23 10:14:49,135 [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)] 2023-03-23 10:14:49,136 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:14:49,143 [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)] 2023-03-23 10:14:49,148 [6] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-03-23 10:14:49,163 [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)] 2023-03-23 10:14:49,164 [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)] 2023-03-23 10:14:49,167 [6] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-03-23 10:14:49,172 [6] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21303,21274,21217,21124,21126,21128,21138,21028,20985,20942,20856,20839,20776,20787,20729,20668,20614,20564,20474,20479) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:14:55,482 [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)] 2023-03-23 10:14:55,482 [6] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 10:14:55,490 [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)] 2023-03-23 10:14:55,490 [6] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 10:14:55,493 [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)] 2023-03-23 10:24:49,550 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:49,562 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21367
[(null)] 2023-03-23 10:24:49,563 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21367
[(null)] 2023-03-23 10:24:49,564 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:49,564 [16] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 10:24:49,567 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:49,568 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21367
[(null)] 2023-03-23 10:24:55,916 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:55,916 [16] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21367
[(null)] 2023-03-23 10:24:56,128 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:56,128 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21367
[(null)] 2023-03-23 10:24:56,272 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:56,383 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:56,384 [16] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[(null)] 2023-03-23 10:24:56,387 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:24:56,388 [16] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 10:24:56,391 [16] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[(null)] 2023-03-23 10:24:56,394 [16] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21367,21303,21274,21217,21124,21126,21128,21138,21028,20985,20942,20856,20839,20776,20787,20729,20668,20614,20564,20474) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:28:04,424 [21] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:28:04,426 [21] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:28:11,779 [21] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:28:11,780 [21] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-03-23 10:28:11,784 [21] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-03-23 10:28:11,960 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:28:11,961 [29] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:28:11,969 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:28:11,969 [29] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 10:28:11,978 [29] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:28:11,979 [29] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 10:28:12,019 [29] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 10:28:12,052 [29] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281,20213) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:28:23,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)] 2023-03-23 10:28:23,024 [26] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 10:28:23,027 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:28:23,027 [26] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 10:28:23,031 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:05,801 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:05,818 [25] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21368
[(null)] 2023-03-23 10:30:05,819 [25] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21368
[(null)] 2023-03-23 10:30:05,820 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:05,821 [25] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 10:30:05,824 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:05,828 [25] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21368
[(null)] 2023-03-23 10:30:05,945 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:06,053 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:06,053 [25] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 10:30:06,058 [25] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:06,058 [25] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 10:30:06,061 [25] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 10:30:06,064 [25] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21368,21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:30:53,830 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:53,832 [17] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-03-23 10:30:54,445 [17] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-03-23 10:30:54,996 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:54,999 [17] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 10:30:55,012 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:55,014 [17] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 10:30:55,022 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:55,022 [17] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 10:30:55,026 [17] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 10:30:55,030 [17] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21368,21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 10:30:59,308 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:59,309 [17] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21368
[(null)] 2023-03-23 10:30:59,483 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:59,483 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 10:30:59,485 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:30:59,488 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 10:30:59,493 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:53:25,449 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 10:53:25,451 [3] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:18:26,947 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:26,948 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:18:34,730 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:34,731 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '000000646'
[(null)] 2023-03-23 11:18:34,732 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:34,735 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:18:39,214 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:39,215 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000646'
[(null)] 2023-03-23 11:18:39,216 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 522
[(null)] 2023-03-23 11:18:39,404 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:39,405 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:18:39,413 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:39,414 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-03-23 11:18:39,422 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:39,423 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:18:39,466 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-03-23 11:18:39,497 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21280,21175,21129,21047,20951,20832,20790,20735,20625,20514,20477,20409,20285,20176,20111,20064,19933,19837,19779,19660) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:18:52,503 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:52,504 [24] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:18:52,506 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:18:52,507 [24] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:18:52,511 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:39,754 [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)] 2023-03-23 11:23:39,765 [6] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21371
[(null)] 2023-03-23 11:23:39,766 [6] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21371
[(null)] 2023-03-23 11:23:39,767 [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)] 2023-03-23 11:23:39,770 [6] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:23:39,783 [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)] 2023-03-23 11:23:39,787 [6] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21371
[(null)] 2023-03-23 11:23:39,915 [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)] 2023-03-23 11:23:40,014 [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)] 2023-03-23 11:23:40,015 [6] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[(null)] 2023-03-23 11:23:40,018 [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)] 2023-03-23 11:23:40,018 [6] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:23:40,021 [6] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[(null)] 2023-03-23 11:23:40,023 [6] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21371,21280,21175,21129,21047,20951,20832,20790,20735,20625,20514,20477,20409,20285,20176,20111,20064,19933,19837,19779) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:23:48,538 [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)] 2023-03-23 11:23:48,540 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:23:51,306 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:51,307 [22] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000669'
[(null)] 2023-03-23 11:23:51,308 [22] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 545
[(null)] 2023-03-23 11:23:51,476 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:51,477 [22] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:23:51,486 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:51,490 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 545 ORDER BY Descrizione
[(null)] 2023-03-23 11:23:51,501 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:51,502 [22] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:23:51,547 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1
[(null)] 2023-03-23 11:23:51,577 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21302,21265,21228,21046,21011,20945,20961,20855,20782,20736,20634,20574,20583,20445,20369,20302,20308,20212,20148,20038) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:23:54,832 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:54,833 [22] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:23:54,835 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:23:54,836 [22] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:23:54,838 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,253 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,276 [13] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21372
[(null)] 2023-03-23 11:29:11,277 [13] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21372
[(null)] 2023-03-23 11:29:11,278 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,281 [13] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:29:11,285 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,288 [13] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21372
[(null)] 2023-03-23 11:29:11,359 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,436 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,437 [13] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 545 ORDER BY Descrizione
[(null)] 2023-03-23 11:29:11,442 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:29:11,442 [13] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:29:11,445 [13] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 545 And CodTipo = 1
[(null)] 2023-03-23 11:29:11,448 [13] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21372,21302,21265,21228,21046,21011,20945,20961,20855,20782,20736,20634,20574,20583,20445,20369,20302,20308,20212,20148) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:32:07,077 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:07,079 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '000002365'
[(null)] 2023-03-23 11:32:07,080 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:07,081 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:32:19,084 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:19,084 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000235'
[(null)] 2023-03-23 11:32:19,085 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 219
[(null)] 2023-03-23 11:32:19,229 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:19,230 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:32:19,237 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:19,246 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[(null)] 2023-03-23 11:32:19,253 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:19,254 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:32:19,293 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[(null)] 2023-03-23 11:32:19,326 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21299,21206,21244,21072,21010,20960,20907,20854,20747,20687,20637,20582,20537,20462,20370,20307,20242,20197,20081,20018) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:32:22,109 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:22,111 [24] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:32:22,113 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:32:22,114 [24] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:32:22,121 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:10,873 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:10,886 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21373
[(null)] 2023-03-23 11:34:10,887 [16] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21373
[(null)] 2023-03-23 11:34:10,888 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:10,889 [16] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:34:10,892 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:10,892 [16] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21373
[(null)] 2023-03-23 11:34:10,974 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:11,419 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:11,420 [16] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[(null)] 2023-03-23 11:34:11,424 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:34:11,425 [16] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:34:11,429 [16] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[(null)] 2023-03-23 11:34:11,432 [16] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21373,21299,21206,21244,21072,21010,20960,20907,20854,20747,20687,20637,20582,20537,20462,20370,20307,20242,20197,20081) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:41:51,776 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:41:51,777 [26] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000229'
[(null)] 2023-03-23 11:41:51,778 [26] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 217
[(null)] 2023-03-23 11:41:51,933 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:41:51,934 [26] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:41:51,941 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:41:51,945 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 217 ORDER BY Descrizione
[(null)] 2023-03-23 11:41:51,952 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:41:51,952 [26] 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)] 2023-03-23 11:41:51,989 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 217 And CodTipo = 1
[(null)] 2023-03-23 11:41:52,016 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21301,21261,21207,21176,21097,21031,20984,20923,20872,20835,20770,20711,20664,20604,20553,20518,20451,20393,20337,20262) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:41:54,763 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:41:54,764 [26] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:41:54,766 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:41:54,767 [26] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:41:54,771 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,118 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,132 [22] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21375
[(null)] 2023-03-23 11:42:23,135 [22] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21375
[(null)] 2023-03-23 11:42:23,136 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,140 [22] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:42:23,142 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,146 [22] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21375
[(null)] 2023-03-23 11:42:23,178 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,261 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,262 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 217 ORDER BY Descrizione
[(null)] 2023-03-23 11:42:23,265 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:42:23,265 [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)] 2023-03-23 11:42:23,269 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 217 And CodTipo = 1
[(null)] 2023-03-23 11:42:23,271 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21375,21301,21261,21207,21176,21097,21031,20984,20923,20872,20835,20770,20711,20664,20604,20553,20518,20451,20393,20337) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:43:29,909 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:29,911 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:43:33,672 [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)] 2023-03-23 11:43:33,673 [6] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[(null)] 2023-03-23 11:43:33,674 [6] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[(null)] 2023-03-23 11:43:33,840 [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)] 2023-03-23 11:43:33,840 [6] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:43:33,852 [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)] 2023-03-23 11:43:33,856 [6] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-03-23 11:43:33,864 [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)] 2023-03-23 11:43:33,866 [6] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:43:33,907 [6] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-03-23 11:43:33,942 [6] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21330,21275,21235,21117,21152,21043,20996,20939,20893,20831,20789,20733,20672,20623,20576,20516,20470,20413,20359,20284) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:43:37,628 [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)] 2023-03-23 11:43:37,629 [6] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:43:37,636 [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)] 2023-03-23 11:43:37,636 [6] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:43:37,638 [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)] 2023-03-23 11:43:46,417 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:46,418 [19] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000158'
[(null)] 2023-03-23 11:43:46,419 [19] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 153
[(null)] 2023-03-23 11:43:46,607 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:46,608 [19] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:43:46,624 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:46,625 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 153 ORDER BY Descrizione
[(null)] 2023-03-23 11:43:46,637 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:46,638 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:43:46,680 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1
[(null)] 2023-03-23 11:43:46,710 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21262,21180,21148,21032,20924,20836,20791,20712,20605,20519,20481,20394,20263,20178,20134,20040,20017,19900,19892,19839) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:43:49,485 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:49,486 [19] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:43:49,493 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:43:49,493 [19] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:43:49,504 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,450 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,469 [22] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21376
[(null)] 2023-03-23 11:44:27,470 [22] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21376
[(null)] 2023-03-23 11:44:27,472 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,472 [22] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:44:27,476 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,476 [22] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21376
[(null)] 2023-03-23 11:44:27,546 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,646 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,648 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 153 ORDER BY Descrizione
[(null)] 2023-03-23 11:44:27,651 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:27,652 [22] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:44:27,654 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 153 And CodTipo = 1
[(null)] 2023-03-23 11:44:27,657 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21376,21262,21180,21148,21032,20924,20836,20791,20712,20605,20519,20481,20394,20263,20178,20134,20040,20017,19900,19892) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:44:46,874 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:46,902 [22] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21377
[(null)] 2023-03-23 11:44:46,903 [22] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21377
[(null)] 2023-03-23 11:44:46,904 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:46,905 [22] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:44:46,916 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:46,917 [22] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21377
[(null)] 2023-03-23 11:44:47,107 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:47,202 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:47,203 [22] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[(null)] 2023-03-23 11:44:47,206 [22] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:44:47,207 [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)] 2023-03-23 11:44:47,211 [22] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[(null)] 2023-03-23 11:44:47,213 [22] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21377,21330,21275,21235,21117,21152,21043,20996,20939,20893,20831,20789,20733,20672,20623,20576,20516,20470,20413,20359) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:45:59,395 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:45:59,395 [16] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[(null)] 2023-03-23 11:45:59,396 [16] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[(null)] 2023-03-23 11:45:59,511 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:45:59,511 [16] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 11:45:59,525 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:45:59,526 [16] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 11:45:59,533 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:45:59,534 [16] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:45:59,538 [16] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 11:45:59,541 [16] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21365,21366,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179,21098) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:46:06,811 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:46:06,812 [16] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-03-23 11:46:06,988 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:46:06,988 [16] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:46:06,991 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:46:06,992 [16] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:46:06,993 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:47:24,341 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:47:24,341 [24] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:47:24,344 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:47:24,345 [24] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:47:24,346 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:45,819 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:45,832 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21378
[(null)] 2023-03-23 11:48:45,833 [19] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21378
[(null)] 2023-03-23 11:48:45,834 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:45,834 [19] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 11:48:45,837 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:45,837 [19] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21378
[(null)] 2023-03-23 11:48:45,952 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:46,025 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:46,026 [19] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 11:48:46,031 [19] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:48:46,031 [19] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:48:46,035 [19] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 11:48:46,037 [19] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21365,21366,21378,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178,21179) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:50:04,173 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:04,173 [26] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[(null)] 2023-03-23 11:50:04,175 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:04,175 [26] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 11:50:04,177 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:04,177 [26] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 11:50:04,179 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:43,465 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:43,475 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21379
[(null)] 2023-03-23 11:50:43,476 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21379
[(null)] 2023-03-23 11:50:43,477 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:43,478 [26] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21379
[(null)] 2023-03-23 11:50:43,500 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:43,595 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:43,595 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[(null)] 2023-03-23 11:50:43,600 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:50:43,601 [26] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 11:50:43,604 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[(null)] 2023-03-23 11:50:43,607 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21363,21364,21365,21366,21378,21379,21304,21305,21307,21263,21264,21268,21271,21276,21277,21210,21218,21223,21234,21178) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 11:59:54,026 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 11:59:54,027 [30] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:00:01,182 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:00:01,185 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[(null)] 2023-03-23 12:00:01,187 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[(null)] 2023-03-23 12:00:01,411 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:00:01,412 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:00:01,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)] 2023-03-23 12:00:01,432 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-03-23 12:00:01,450 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:00:01,450 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:00:01,563 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-03-23 12:00:01,610 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21243,21139,21044,20958,20796,20688,20631,20483,20417,20303,20069,19901,19774,19708,19589,19458,19385,19224,19108,19067) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:00:50,194 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:00:50,195 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:00:50,198 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:00:50,198 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:00:50,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)] 2023-03-23 12:16:51,725 [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)] 2023-03-23 12:16:51,726 [27] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:17:12,037 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:12,041 [23] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000684'
[(null)] 2023-03-23 12:17:12,044 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 560
[(null)] 2023-03-23 12:17:12,306 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:12,307 [23] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:17:12,315 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:12,321 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[(null)] 2023-03-23 12:17:12,330 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:12,331 [23] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:17:12,373 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[(null)] 2023-03-23 12:17:12,403 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21287,21050,20957,20738,20633,20416,20290,20067,19927,19709,19605,19386,19268,19066,18963,18749,18647,18441,18338,18141) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:17:18,429 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:18,430 [16] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 83
[(null)] 2023-03-23 12:17:18,437 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:18,438 [16] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:17:18,444 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:17:18,445 [16] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:17:18,454 [16] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,236 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,281 [30] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21380
[(null)] 2023-03-23 12:19:40,284 [30] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21380
[(null)] 2023-03-23 12:19:40,285 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,289 [30] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 12:19:40,292 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,293 [30] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21380
[(null)] 2023-03-23 12:19:40,420 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,640 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,641 [30] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[(null)] 2023-03-23 12:19:40,645 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:19:40,645 [30] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:19:40,648 [30] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[(null)] 2023-03-23 12:19:40,651 [30] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21380,21287,21050,20957,20738,20633,20416,20290,20067,19927,19709,19605,19386,19268,19066,18963,18749,18647,18441,18338) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:21:16,838 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:21:16,841 [13] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000268'
[(null)] 2023-03-23 12:21:16,841 [13] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 238
[(null)] 2023-03-23 12:21:17,015 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:21:17,016 [13] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:21:17,030 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:21:17,031 [13] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:21:17,042 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:21:17,042 [13] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:21:17,082 [13] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:21:17,113 [13] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388,20389,20390,20391,20392,20415,20047) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:21:34,795 [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)] 2023-03-23 12:21:34,796 [27] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 8
[(null)] 2023-03-23 12:21:34,801 [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)] 2023-03-23 12:21:34,802 [27] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:21:34,804 [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)] 2023-03-23 12:21:34,804 [27] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:21:34,812 [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)] 2023-03-23 12:22:25,175 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:25,191 [24] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21381
[(null)] 2023-03-23 12:22:25,192 [24] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21381
[(null)] 2023-03-23 12:22:25,192 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:25,193 [24] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 12:22:25,196 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:25,197 [24] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21381
[(null)] 2023-03-23 12:22:25,255 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:25,350 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:25,351 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:22:25,356 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:25,356 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:22:25,359 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:22:25,361 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388,20389,20390,20391,20392,20415) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:22:32,983 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:32,983 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 9
[(null)] 2023-03-23 12:22:32,988 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:32,988 [24] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:22:32,990 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:22:32,990 [24] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:22:32,991 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:21,690 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:21,701 [15] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21382
[(null)] 2023-03-23 12:23:21,702 [15] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21382
[(null)] 2023-03-23 12:23:21,703 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:21,704 [15] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21382
[(null)] 2023-03-23 12:23:21,770 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:21,868 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:21,869 [15] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:23:21,874 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:21,875 [15] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:23:21,878 [15] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:23:21,880 [15] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21382,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388,20389,20390,20391,20392) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:23:27,654 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:27,654 [15] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 10
[(null)] 2023-03-23 12:23:27,679 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:27,680 [15] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:23:27,684 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:23:27,684 [15] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:23:27,690 [15] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:12,687 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:12,700 [3] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21383
[(null)] 2023-03-23 12:24:12,701 [3] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21383
[(null)] 2023-03-23 12:24:12,702 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:12,703 [3] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21383
[(null)] 2023-03-23 12:24:12,762 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:12,871 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:12,871 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:24:12,876 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:12,877 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:24:12,880 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:24:12,882 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21382,21383,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388,20389,20390,20391) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:24:18,376 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:18,377 [3] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 11
[(null)] 2023-03-23 12:24:18,399 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:18,400 [3] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:24:18,402 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:18,403 [3] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:24:18,405 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:24:47,116 [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)] 2023-03-23 12:24:47,124 [27] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21384
[(null)] 2023-03-23 12:24:47,125 [27] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21384
[(null)] 2023-03-23 12:24:47,126 [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)] 2023-03-23 12:24:47,126 [27] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21384
[(null)] 2023-03-23 12:24:47,163 [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)] 2023-03-23 12:24:47,259 [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)] 2023-03-23 12:24:47,259 [27] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:24:47,264 [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)] 2023-03-23 12:24:47,264 [27] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:24:47,267 [27] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:24:47,269 [27] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21382,21383,21384,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388,20389,20390) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:24:51,528 [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)] 2023-03-23 12:24:51,529 [27] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 12
[(null)] 2023-03-23 12:24:51,534 [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)] 2023-03-23 12:24:51,535 [27] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:24:51,537 [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)] 2023-03-23 12:24:51,537 [27] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:24:51,539 [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)] 2023-03-23 12:25:32,925 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:32,947 [23] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21385
[(null)] 2023-03-23 12:25:32,948 [23] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21385
[(null)] 2023-03-23 12:25:32,949 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:32,949 [23] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21385
[(null)] 2023-03-23 12:25:33,002 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:33,092 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:33,093 [23] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:25:33,097 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:33,097 [23] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:25:33,100 [23] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:25:33,103 [23] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21382,21383,21384,21385,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388,20389) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:25:38,774 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:38,775 [23] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 13
[(null)] 2023-03-23 12:25:38,780 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:38,781 [23] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:25:38,782 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:25:38,783 [23] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:25:38,784 [23] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:26:00,394 [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)] 2023-03-23 12:26:00,407 [18] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21386
[(null)] 2023-03-23 12:26:00,408 [18] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21386
[(null)] 2023-03-23 12:26:00,408 [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)] 2023-03-23 12:26:00,409 [18] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21386
[(null)] 2023-03-23 12:26:00,432 [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)] 2023-03-23 12:26:00,512 [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)] 2023-03-23 12:26:00,513 [18] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:26:00,517 [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)] 2023-03-23 12:26:00,517 [18] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:26:00,520 [18] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:26:00,522 [18] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21382,21383,21384,21385,21386,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737,20388) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:26:05,971 [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)] 2023-03-23 12:26:05,971 [18] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 14
[(null)] 2023-03-23 12:26:06,261 [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)] 2023-03-23 12:26:06,262 [18] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:26:06,264 [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)] 2023-03-23 12:26:06,265 [18] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:26:06,266 [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)] 2023-03-23 12:26:35,748 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:26:35,758 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21387
[(null)] 2023-03-23 12:26:35,759 [26] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21387
[(null)] 2023-03-23 12:26:35,760 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:26:35,761 [26] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21387
[(null)] 2023-03-23 12:26:35,813 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:26:35,917 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:26:35,917 [26] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 238 ORDER BY Descrizione
[(null)] 2023-03-23 12:26:35,921 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:26:35,922 [26] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:26:35,925 [26] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 238 And CodTipo = 1
[(null)] 2023-03-23 12:26:35,927 [26] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21381,21382,21383,21384,21385,21386,21387,21033,21034,21035,21036,21053,21054,21055,20705,20706,20707,20708,20709,20737) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:33:46,968 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:33:46,968 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:33:53,035 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:33:53,046 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[(null)] 2023-03-23 12:33:53,046 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[(null)] 2023-03-23 12:33:53,275 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:33:53,275 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 12:33:53,282 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:33:53,286 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-03-23 12:33:53,294 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:33:53,295 [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)] 2023-03-23 12:33:53,370 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-03-23 12:33:53,399 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21343,21294,21237,21120,21134,21051,21004,20956,20900,20830,20795,20739,20685,20632,20578,20476,20480,20412,20358,20301) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 12:36:50,162 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:36:50,162 [30] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[(null)] 2023-03-23 12:36:50,168 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:36:50,169 [30] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 12:36:50,171 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:36:50,172 [30] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 12:36:50,173 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 12:40:15,052 [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)] 2023-03-23 12:40:15,084 [6] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21391
[(null)] 2023-03-23 12:40:15,085 [6] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21391
[(null)] 2023-03-23 12:40:15,087 [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)] 2023-03-23 12:40:15,113 [6] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 12:40:15,116 [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)] 2023-03-23 12:40:15,140 [6] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21391
[(null)] 2023-03-23 12:40:24,350 [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)] 2023-03-23 12:40:24,351 [6] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21391
[(null)] 2023-03-23 12:40:24,778 [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)] 2023-03-23 12:40:24,778 [6] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21391
[(null)] 2023-03-23 12:40:25,464 [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)] 2023-03-23 12:40:25,654 [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)] 2023-03-23 12:40:25,655 [6] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[(null)] 2023-03-23 12:40:25,676 [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)] 2023-03-23 12:40:25,677 [6] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 12:40:25,684 [6] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[(null)] 2023-03-23 12:40:25,691 [6] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21391,21343,21294,21237,21120,21134,21051,21004,20956,20900,20830,20795,20739,20685,20632,20578,20476,20480,20412,20358) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 13:00:45,080 [26] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:00:45,081 [26] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 13:00:54,419 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:00:54,422 [3] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[(null)] 2023-03-23 13:00:54,423 [3] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[(null)] 2023-03-23 13:00:54,574 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:00:54,575 [3] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 13:00:54,583 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:00:54,587 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-03-23 13:00:54,594 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:00:54,595 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 13:00:54,631 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-03-23 13:00:54,658 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21243,21139,21044,20958,20796,20688,20631,20483,20417,20303,20069,19901,19774,19708,19589,19458,19385,19224,19108,19067) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 13:01:13,486 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:13,486 [17] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 13:01:13,489 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:13,490 [17] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 13:01:13,491 [17] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:13,807 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:13,808 [3] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 13:01:13,834 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:13,835 [3] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 13:01:18,815 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:18,816 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-03-23 13:01:18,821 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:18,821 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 13:01:18,824 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-03-23 13:01:18,827 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21243,21139,21044,20958,20796,20688,20631,20483,20417,20303,20069,19901,19774,19708,19589,19458,19385,19224,19108,19067) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 13:01:24,224 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:24,224 [3] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21243
[(null)] 2023-03-23 13:01:25,586 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:25,586 [3] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 13:01:25,590 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:25,591 [3] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 13:01:25,596 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:38,557 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:38,558 [3] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-03-23 13:01:38,561 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:38,562 [3] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 13:01:38,569 [3] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-03-23 13:01:38,571 [3] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21243,21139,21044,20958,20796,20688,20631,20483,20417,20303,20069,19901,19774,19708,19589,19458,19385,19224,19108,19067) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 13:01:41,474 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:41,475 [3] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 13:01:41,481 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:01:41,482 [3] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 13:01:41,483 [3] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:02:15,572 [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)] 2023-03-23 13:02:15,574 [27] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-03-23 13:02:15,594 [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)] 2023-03-23 13:02:15,595 [27] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 13:02:15,603 [27] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-03-23 13:02:15,606 [27] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21243,21139,21044,20958,20796,20688,20631,20483,20417,20303,20069,19901,19774,19708,19589,19458,19385,19224,19108,19067) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 13:02:19,830 [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)] 2023-03-23 13:02:19,830 [27] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 13:02:19,843 [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)] 2023-03-23 13:02:19,843 [27] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 13:02:19,845 [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)] 2023-03-23 13:06:09,714 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:09,746 [30] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21395
[(null)] 2023-03-23 13:06:09,750 [30] DEBUG Query - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 21395
[(null)] 2023-03-23 13:06:09,755 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:09,756 [30] DEBUG Query - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[(null)] 2023-03-23 13:06:09,763 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:09,764 [30] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21395
[(null)] 2023-03-23 13:06:10,593 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=200;Connect Timeout=60'.
[(null)] 2023-03-23 13:06:17,641 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:17,641 [30] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21395
[(null)] 2023-03-23 13:06:17,828 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:17,829 [30] DEBUG Query - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 21395
[(null)] 2023-03-23 13:06:17,964 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:18,077 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:18,078 [30] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[(null)] 2023-03-23 13:06:18,081 [30] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:18,082 [30] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 13:06:18,084 [30] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[(null)] 2023-03-23 13:06:18,087 [30] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21395,21243,21139,21044,20958,20796,20688,20631,20483,20417,20303,20069,19901,19774,19708,19589,19458,19385,19224,19108) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 13:06:51,489 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:51,490 [13] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 13:06:51,493 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 13:06:51,494 [13] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 13:06:51,495 [13] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:41,383 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:41,387 [20] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 15:31:45,709 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:45,713 [20] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 15:31:51,947 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:51,961 [20] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-03-23 15:31:51,961 [20] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-03-23 15:31:52,872 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:52,874 [20] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 15:31:52,883 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:52,883 [20] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 15:31:52,891 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:31:52,892 [20] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 15:31:52,934 [20] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 15:31:52,966 [20] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21368,21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 15:32:00,634 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:32:00,635 [20] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21368
[(null)] 2023-03-23 15:32:00,844 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:32:00,845 [20] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 15:32:00,858 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:32:00,859 [20] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 15:32:00,860 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:32:10,373 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:32:10,374 [20] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 15:32:10,378 [20] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 15:32:10,378 [20] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 15:32:10,381 [20] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 15:32:10,384 [20] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21368,21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 17:20:10,933 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:10,943 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 17:20:14,372 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:14,375 [24] DEBUG Query - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[(null)] 2023-03-23 17:20:14,378 [24] DEBUG Query - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[(null)] 2023-03-23 17:20:14,519 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:14,520 [24] DEBUG Query - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[(null)] 2023-03-23 17:20:14,528 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:14,532 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 17:20:14,540 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:14,541 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 17:20:14,575 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 17:20:14,600 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21368,21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281) ORDER BY Data DESC, Numero DESC
[(null)] 2023-03-23 17:20:18,485 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:18,486 [24] DEBUG Query - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato  FROM viewDocVendTestata WHERE IDDocVendTestata = 21368
[(null)] 2023-03-23 17:20:18,637 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:18,638 [24] DEBUG Query - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[(null)] 2023-03-23 17:20:18,651 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:18,651 [24] DEBUG Query - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[(null)] 2023-03-23 17:20:18,653 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:29,946 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:29,947 [24] DEBUG Query - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[(null)] 2023-03-23 17:20:29,953 [24] DEBUG Query - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[(null)] 2023-03-23 17:20:29,953 [24] DEBUG Query - ExecuteReader: WITH tmp AS (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) SELECT IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 AND 20 ORDER BY RowNum
[(null)] 2023-03-23 17:20:29,960 [24] DEBUG Query - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[(null)] 2023-03-23 17:20:29,963 [24] DEBUG Query - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata  WHERE IDDocVendTestata IN (21368,21273,21226,21111,21151,21038,20982,20927,20879,20834,20766,20715,20682,20624,20569,20488,20457,20405,20352,20281) ORDER BY Data DESC, Numero DESC