[3] 2024-02-20 08:39:19,979 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 08:39:20,352 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 08:39:20,466 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 08:39:29,172 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000807'
[7] 2024-02-20 08:39:29,186 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 683
[7] 2024-02-20 08:39:29,822 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 08:39:29,872 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[7] 2024-02-20 08:39:30,319 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[7] 2024-02-20 08:39:30,356 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[7] 2024-02-20 08:39:30,382 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34579,34538,34475,34424,34371,34320,34276,34249,34173,34115,34052,34000,33963,33938,33868,33815,33751,33701,33588,33508) ORDER BY Data DESC, Numero DESC
[8] 2024-02-20 08:39:34,524 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[8] 2024-02-20 08:39:34,548 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[7] 2024-02-20 08:40:20,538 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34625
[7] 2024-02-20 08:40:20,540 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34625
[7] 2024-02-20 08:40:20,542 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[7] 2024-02-20 08:40:20,560 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34625
[3] 2024-02-20 08:40:20,948 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 683 ORDER BY Descrizione
[3] 2024-02-20 08:40:20,951 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 08:40:20,954 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 683 And CodTipo = 1
[3] 2024-02-20 08:40:20,956 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34625,34579,34538,34475,34424,34371,34320,34276,34249,34173,34115,34052,34000,33963,33938,33868,33815,33751,33701,33588) ORDER BY Data DESC, Numero DESC
[9] 2024-02-20 08:41:01,355 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[9] 2024-02-20 08:41:07,643 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000525'
[9] 2024-02-20 08:41:07,644 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 401
[7] 2024-02-20 08:41:07,935 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 08:41:07,946 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 401 ORDER BY Descrizione
[7] 2024-02-20 08:41:07,950 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[7] 2024-02-20 08:41:07,995 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 401 And CodTipo = 1
[7] 2024-02-20 08:41:08,025 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34580,34506,34375,34285,34195,34058,33967,33874,33753,33657,33571,33471,33387,33313,33205,33023,32937,32865,32799,32742) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 08:59:35,350 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 08:59:35,679 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[3] 2024-02-20 08:59:35,794 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 08:59:49,571 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[7] 2024-02-20 08:59:49,582 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[3] 2024-02-20 08:59:50,194 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 08:59:50,245 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[3] 2024-02-20 08:59:50,641 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 08:59:50,676 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[3] 2024-02-20 08:59:50,701 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34582,34519,34501,34500,34498,34427,34379,34334,34281,34228,34218,34185,34179,34177,34117,34087,34013,33962,33902,33875) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 09:00:14,257 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 09:00:14,276 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[8] 2024-02-20 09:09:16,998 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[8] 2024-02-20 09:09:17,388 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[8] 2024-02-20 09:09:17,542 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[9] 2024-02-20 09:09:28,063 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000684'
[9] 2024-02-20 09:09:28,068 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 560
[8] 2024-02-20 09:09:28,963 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[8] 2024-02-20 09:09:29,061 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[8] 2024-02-20 09:09:29,609 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[8] 2024-02-20 09:09:29,651 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[8] 2024-02-20 09:09:29,678 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34444,34333,34131,34015,33837,33714,33534,33446,33266,33171,32985,32914,32783,32709,32555,32396,32342,32251,32033,31947) ORDER BY Data DESC, Numero DESC
[9] 2024-02-20 09:09:45,306 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 83
[9] 2024-02-20 09:09:45,319 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[9] 2024-02-20 09:09:45,337 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[8] 2024-02-20 09:12:33,290 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34629
[8] 2024-02-20 09:12:33,291 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34629
[8] 2024-02-20 09:12:33,293 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[8] 2024-02-20 09:12:33,314 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34629
[9] 2024-02-20 09:14:14,673 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34629
[9] 2024-02-20 09:14:14,854 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34629
[8] 2024-02-20 09:14:15,030 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[8] 2024-02-20 09:14:15,033 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[8] 2024-02-20 09:14:15,036 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[8] 2024-02-20 09:14:15,038 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34629,34444,34333,34131,34015,33837,33714,33534,33446,33266,33171,32985,32914,32783,32709,32555,32396,32342,32251,32033) ORDER BY Data DESC, Numero DESC
[10] 2024-02-20 09:16:23,367 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 1
[6] 2024-02-20 09:17:19,030 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000219'
[6] 2024-02-20 09:17:19,031 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 207
[10] 2024-02-20 09:17:19,203 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[10] 2024-02-20 09:17:19,214 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[10] 2024-02-20 09:17:19,216 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[10] 2024-02-20 09:17:19,219 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[10] 2024-02-20 09:17:19,222 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34582,34519,34501,34500,34498,34427,34379,34334,34281,34228,34218,34185,34179,34177,34117,34087,34013,33962,33902,33875) ORDER BY Data DESC, Numero DESC
[6] 2024-02-20 09:17:25,081 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[6] 2024-02-20 09:17:25,082 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[10] 2024-02-20 09:18:53,776 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000684'
[10] 2024-02-20 09:18:53,778 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 560
[6] 2024-02-20 09:18:54,394 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[6] 2024-02-20 09:18:54,401 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[6] 2024-02-20 09:18:54,404 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[6] 2024-02-20 09:18:54,406 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[6] 2024-02-20 09:18:54,409 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34629,34444,34333,34131,34015,33837,33714,33534,33446,33266,33171,32985,32914,32783,32709,32555,32396,32342,32251,32033) ORDER BY Data DESC, Numero DESC
[8] 2024-02-20 09:18:58,710 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34629
[8] 2024-02-20 09:18:58,826 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 83
[8] 2024-02-20 09:18:58,827 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[8] 2024-02-20 09:18:58,827 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[10] 2024-02-20 09:19:03,449 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34629
[10] 2024-02-20 09:19:03,540 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34629
[3] 2024-02-20 09:19:55,996 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000850'
[3] 2024-02-20 09:19:55,997 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 726
[6] 2024-02-20 09:19:56,329 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[6] 2024-02-20 09:19:56,336 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 726 ORDER BY Descrizione
[6] 2024-02-20 09:19:56,342 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[6] 2024-02-20 09:19:56,375 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1
[6] 2024-02-20 09:19:56,400 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34494,34429,34370,34345,34264,34170,34133,34051,34023,33960,33867,33842,33771,33720,33640,33569,33539,33481,33447,33375) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 09:20:05,195 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 105
[3] 2024-02-20 09:20:05,200 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 09:20:05,201 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[6] 2024-02-20 09:21:39,480 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[6] 2024-02-20 09:21:39,483 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[6] 2024-02-20 09:21:39,486 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[6] 2024-02-20 09:21:39,489 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34629,34444,34333,34131,34015,33837,33714,33534,33446,33266,33171,32985,32914,32783,32709,32555,32396,32342,32251,32033) ORDER BY Data DESC, Numero DESC
[6] 2024-02-20 09:21:44,052 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34632
[6] 2024-02-20 09:21:44,052 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34632
[6] 2024-02-20 09:21:44,054 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[6] 2024-02-20 09:21:44,057 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34632
[8] 2024-02-20 09:21:44,391 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 207 ORDER BY Descrizione
[8] 2024-02-20 09:21:44,393 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[8] 2024-02-20 09:21:44,396 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 207 And CodTipo = 1
[8] 2024-02-20 09:21:44,398 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34632,34582,34519,34501,34500,34498,34427,34379,34334,34281,34228,34218,34185,34179,34177,34117,34087,34013,33962,33902) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 09:22:02,228 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:22:05,300 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[3] 2024-02-20 09:22:05,301 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[3] 2024-02-20 09:22:05,461 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:22:05,467 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[3] 2024-02-20 09:22:05,472 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:22:05,509 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[3] 2024-02-20 09:22:05,534 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435,34434,34432,34430) ORDER BY Data DESC, Numero DESC
[6] 2024-02-20 09:22:11,932 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[6] 2024-02-20 09:22:11,936 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[6] 2024-02-20 09:22:11,937 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[3] 2024-02-20 09:23:43,594 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34633
[3] 2024-02-20 09:23:43,595 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34633
[3] 2024-02-20 09:23:43,595 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[3] 2024-02-20 09:23:43,599 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34633
[8] 2024-02-20 09:23:47,220 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34633
[8] 2024-02-20 09:23:47,400 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34633
[3] 2024-02-20 09:23:47,636 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 726 ORDER BY Descrizione
[3] 2024-02-20 09:23:47,638 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:23:47,641 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 726 And CodTipo = 1
[3] 2024-02-20 09:23:47,643 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34633,34494,34429,34370,34345,34264,34170,34133,34051,34023,33960,33867,33842,33771,33720,33640,33569,33539,33481,33447) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 09:30:10,616 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[7] 2024-02-20 09:30:10,958 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 09:30:11,072 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[3] 2024-02-20 09:30:12,464 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 09:30:15,248 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[7] 2024-02-20 09:30:15,253 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[3] 2024-02-20 09:30:15,691 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:30:15,736 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[3] 2024-02-20 09:30:16,206 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:30:16,217 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[3] 2024-02-20 09:30:16,221 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435,34434,34432,34430) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 09:30:25,105 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[3] 2024-02-20 09:30:25,114 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 09:30:25,132 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[3] 2024-02-20 09:30:33,280 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[3] 2024-02-20 09:30:33,280 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[7] 2024-02-20 09:30:33,452 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 09:30:33,474 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[7] 2024-02-20 09:30:33,478 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[7] 2024-02-20 09:30:33,482 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[7] 2024-02-20 09:30:33,485 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435,34434,34432,34430) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 09:30:38,199 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[3] 2024-02-20 09:30:38,199 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 09:30:38,200 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[9] 2024-02-20 09:32:32,390 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34636
[9] 2024-02-20 09:32:32,391 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34636
[9] 2024-02-20 09:32:32,395 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[9] 2024-02-20 09:32:32,413 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34636
[8] 2024-02-20 09:32:36,923 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34636
[8] 2024-02-20 09:32:37,102 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34636
[3] 2024-02-20 09:34:45,346 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34636
[3] 2024-02-20 09:34:45,564 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34636
[3] 2024-02-20 09:34:46,023 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[3] 2024-02-20 09:34:46,026 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:34:46,030 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[3] 2024-02-20 09:34:46,032 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435,34434,34432) ORDER BY Data DESC, Numero DESC
[10] 2024-02-20 09:37:46,915 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 4
[10] 2024-02-20 09:37:46,916 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[10] 2024-02-20 09:37:46,917 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[3] 2024-02-20 09:40:52,590 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34637
[3] 2024-02-20 09:40:52,591 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34637
[3] 2024-02-20 09:40:52,593 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34637
[3] 2024-02-20 09:42:13,751 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:42:28,717 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000646'
[3] 2024-02-20 09:42:28,718 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 522
[3] 2024-02-20 09:42:28,943 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:42:28,951 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[3] 2024-02-20 09:42:28,961 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:42:28,994 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[3] 2024-02-20 09:42:29,019 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34484,34482,34428,34328,34275,34197,34196,34121,34010,33886,33885,33818,33697,33579,33568,33518,33426,33325,33324,33254) ORDER BY Data DESC, Numero DESC
[10] 2024-02-20 09:42:33,662 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[10] 2024-02-20 09:42:33,663 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[3] 2024-02-20 09:44:14,872 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34637
[3] 2024-02-20 09:44:15,044 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34637
[10] 2024-02-20 09:44:21,172 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34637
[10] 2024-02-20 09:44:21,275 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34637
[10] 2024-02-20 09:44:33,185 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34637
[10] 2024-02-20 09:44:33,276 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34637
[10] 2024-02-20 09:44:33,729 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[10] 2024-02-20 09:44:33,732 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[10] 2024-02-20 09:44:33,736 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[10] 2024-02-20 09:44:33,739 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435,34434) ORDER BY Data DESC, Numero DESC
[10] 2024-02-20 09:44:52,269 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:44:55,926 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[3] 2024-02-20 09:44:55,963 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[3] 2024-02-20 09:44:56,170 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:44:56,222 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[3] 2024-02-20 09:44:56,227 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:44:56,274 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[3] 2024-02-20 09:44:56,298 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34446,34149,34027,33843,33700,33595,33543,33449,33272,33176,32988,32904,32786,32711,32525,32477,32404,32403,32243,32056) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 09:46:35,687 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 09:46:35,688 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[10] 2024-02-20 09:46:43,035 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34638
[10] 2024-02-20 09:46:43,036 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34638
[10] 2024-02-20 09:46:43,036 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[10] 2024-02-20 09:46:43,040 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34638
[3] 2024-02-20 09:46:47,089 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34638
[3] 2024-02-20 09:46:47,278 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34638
[10] 2024-02-20 09:46:56,103 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34638
[10] 2024-02-20 09:46:56,198 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34638
[10] 2024-02-20 09:46:56,447 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 522 ORDER BY Descrizione
[10] 2024-02-20 09:46:56,449 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[10] 2024-02-20 09:46:56,452 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 522 And CodTipo = 1
[10] 2024-02-20 09:46:56,454 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34638,34484,34482,34428,34328,34275,34197,34196,34121,34010,33886,33885,33818,33697,33579,33568,33518,33426,33325,33324) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 09:49:18,739 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34639
[7] 2024-02-20 09:49:18,739 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34639
[7] 2024-02-20 09:49:18,739 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[7] 2024-02-20 09:49:18,744 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34639
[3] 2024-02-20 09:53:51,128 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 09:53:51,485 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:53:51,608 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 09:54:23,902 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000981'
[7] 2024-02-20 09:54:23,908 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 857
[7] 2024-02-20 09:54:23,985 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 09:54:31,695 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000981'
[7] 2024-02-20 09:54:31,696 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 857
[7] 2024-02-20 09:54:31,706 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[9] 2024-02-20 09:55:53,179 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[10] 2024-02-20 09:56:28,406 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[10] 2024-02-20 09:56:28,425 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[3] 2024-02-20 09:56:28,635 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 09:56:28,681 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[3] 2024-02-20 09:56:29,362 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 09:56:29,409 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[3] 2024-02-20 09:56:29,414 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435,34434) ORDER BY Data DESC, Numero DESC
[10] 2024-02-20 09:56:47,708 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[10] 2024-02-20 09:56:48,046 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[10] 2024-02-20 09:56:48,074 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[14] 2024-02-20 09:59:41,762 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34641
[14] 2024-02-20 09:59:41,763 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34641
[14] 2024-02-20 09:59:41,768 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[14] 2024-02-20 09:59:41,787 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34641
[14] 2024-02-20 09:59:41,958 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[14] 2024-02-20 09:59:41,961 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[14] 2024-02-20 09:59:41,965 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[14] 2024-02-20 09:59:41,968 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34641,34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483,34435) ORDER BY Data DESC, Numero DESC
[17] 2024-02-20 09:59:52,996 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 1
[17] 2024-02-20 09:59:52,997 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[17] 2024-02-20 09:59:52,998 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[21] 2024-02-20 10:03:31,947 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34642
[21] 2024-02-20 10:03:31,952 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34642
[21] 2024-02-20 10:03:32,000 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34642
[21] 2024-02-20 10:03:32,442 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[21] 2024-02-20 10:03:32,445 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[21] 2024-02-20 10:03:32,449 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[21] 2024-02-20 10:03:32,452 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34642,34641,34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 10:16:01,296 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 10:16:01,639 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 10:16:01,757 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 10:16:03,328 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 10:16:06,512 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[7] 2024-02-20 10:16:06,517 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[3] 2024-02-20 10:16:07,107 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 10:16:07,163 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[3] 2024-02-20 10:16:07,571 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 10:16:07,580 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[3] 2024-02-20 10:16:07,584 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34639,34446,34149,34027,33843,33700,33595,33543,33449,33272,33176,32988,32904,32786,32711,32525,32477,32404,32403,32243) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 10:17:30,080 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[7] 2024-02-20 10:17:30,081 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[7] 2024-02-20 10:17:30,221 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 10:17:30,227 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[7] 2024-02-20 10:17:30,231 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[7] 2024-02-20 10:17:30,236 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[7] 2024-02-20 10:17:30,238 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34642,34641,34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486,34483) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 10:17:38,400 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[3] 2024-02-20 10:17:38,413 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 10:17:38,432 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[7] 2024-02-20 10:20:03,083 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34643
[7] 2024-02-20 10:20:03,083 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34643
[7] 2024-02-20 10:20:03,088 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[7] 2024-02-20 10:20:03,106 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34643
[7] 2024-02-20 10:20:03,352 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[7] 2024-02-20 10:20:03,355 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[7] 2024-02-20 10:20:03,359 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[7] 2024-02-20 10:20:03,363 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34643,34642,34641,34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 10:34:37,964 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[7] 2024-02-20 10:34:38,308 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 10:34:38,420 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[3] 2024-02-20 10:34:46,056 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000235'
[3] 2024-02-20 10:34:46,062 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 219
[7] 2024-02-20 10:34:46,520 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 10:34:46,571 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[7] 2024-02-20 10:34:46,979 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[7] 2024-02-20 10:34:47,016 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[7] 2024-02-20 10:34:47,045 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34326,34263,34172,33763,30691,30587,30527,30480,30441,30378,30313,30231,30174,30134,30033,29974,29926,29881,29841,29736) ORDER BY Data DESC, Numero DESC
[8] 2024-02-20 10:34:51,516 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[8] 2024-02-20 10:34:51,536 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[8] 2024-02-20 10:37:14,352 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34644
[8] 2024-02-20 10:37:14,352 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34644
[8] 2024-02-20 10:37:14,355 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[8] 2024-02-20 10:37:14,375 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34644
[8] 2024-02-20 10:37:15,613 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[8] 2024-02-20 10:37:15,615 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[8] 2024-02-20 10:37:15,617 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[8] 2024-02-20 10:37:15,620 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34644,34326,34263,34172,33763,30691,30587,30527,30480,30441,30378,30313,30231,30174,30134,30033,29974,29926,29881,29841) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 10:37:21,493 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34644
[7] 2024-02-20 10:37:21,666 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[7] 2024-02-20 10:37:21,667 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[10] 2024-02-20 10:37:25,099 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 219 ORDER BY Descrizione
[10] 2024-02-20 10:37:25,102 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[10] 2024-02-20 10:37:25,105 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 219 And CodTipo = 1
[10] 2024-02-20 10:37:25,108 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34644,34326,34263,34172,33763,30691,30587,30527,30480,30441,30378,30313,30231,30174,30134,30033,29974,29926,29881,29841) ORDER BY Data DESC, Numero DESC
[11] 2024-02-20 10:37:34,216 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[11] 2024-02-20 10:37:34,218 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[13] 2024-02-20 10:38:15,190 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[12] 2024-02-20 10:38:19,611 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000243'
[12] 2024-02-20 10:38:19,611 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 224
[8] 2024-02-20 10:38:19,752 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[8] 2024-02-20 10:38:19,760 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[8] 2024-02-20 10:38:19,763 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[8] 2024-02-20 10:38:19,767 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[8] 2024-02-20 10:38:19,770 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34643,34642,34641,34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487,34486) ORDER BY Data DESC, Numero DESC
[10] 2024-02-20 10:38:29,362 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 58
[10] 2024-02-20 10:38:29,363 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[10] 2024-02-20 10:38:29,364 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[13] 2024-02-20 10:40:16,214 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34645
[13] 2024-02-20 10:40:16,214 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34645
[13] 2024-02-20 10:40:16,215 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[13] 2024-02-20 10:40:16,219 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34645
[8] 2024-02-20 10:40:16,402 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 224 ORDER BY Descrizione
[8] 2024-02-20 10:40:16,405 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[8] 2024-02-20 10:40:16,409 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 224 And CodTipo = 1
[8] 2024-02-20 10:40:16,412 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34645,34643,34642,34641,34637,34636,34578,34577,34576,34539,34517,34516,34503,34502,34497,34496,34495,34493,34488,34487) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 11:04:56,648 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 11:04:57,007 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 11:04:57,134 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 11:05:08,294 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000684'
[7] 2024-02-20 11:05:08,300 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 560
[3] 2024-02-20 11:05:09,268 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 11:05:09,318 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[3] 2024-02-20 11:05:09,791 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 11:05:09,801 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[3] 2024-02-20 11:05:09,806 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34629,34444,34333,34131,34015,33837,33714,33534,33446,33266,33171,32985,32914,32783,32709,32555,32396,32342,32251,32033) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 11:05:14,103 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34629
[7] 2024-02-20 11:05:14,208 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 83
[7] 2024-02-20 11:05:14,212 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[7] 2024-02-20 11:05:14,231 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[3] 2024-02-20 11:05:21,431 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34629
[3] 2024-02-20 11:05:21,551 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34629
[3] 2024-02-20 11:05:22,101 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 560 ORDER BY Descrizione
[3] 2024-02-20 11:05:22,103 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 11:05:22,106 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 560 And CodTipo = 1
[3] 2024-02-20 11:05:22,108 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34629,34444,34333,34131,34015,33837,33714,33534,33446,33266,33171,32985,32914,32783,32709,32555,32396,32342,32251,32033) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 11:13:36,637 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 11:13:36,970 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 11:13:37,083 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 11:13:50,527 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000237'
[7] 2024-02-20 11:13:50,532 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 221
[3] 2024-02-20 11:13:51,213 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 11:13:51,276 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[3] 2024-02-20 11:13:51,729 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 11:13:51,772 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[3] 2024-02-20 11:13:51,801 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34584,34518,34499,34438,34401,34340,34290,34217,34186,34146,34085,34030,33975,33903,33880,33835,33765,33713,33659,33600) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 11:13:57,102 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 11:13:57,122 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[7] 2024-02-20 11:15:29,041 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34646
[7] 2024-02-20 11:15:29,044 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34646
[7] 2024-02-20 11:15:29,047 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[7] 2024-02-20 11:15:29,065 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34646
[3] 2024-02-20 11:15:29,342 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 221 ORDER BY Descrizione
[3] 2024-02-20 11:15:29,345 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 11:15:29,348 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 221 And CodTipo = 1
[3] 2024-02-20 11:15:29,350 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34646,34584,34518,34499,34438,34401,34340,34290,34217,34186,34146,34085,34030,33975,33903,33880,33835,33765,33713,33659) ORDER BY Data DESC, Numero DESC
[7] 2024-02-20 12:01:00,824 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 12:01:01,056 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[7] 2024-02-20 12:01:01,244 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 12:01:01,354 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 12:01:01,361 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[3] 2024-02-20 12:01:02,935 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[8] 2024-02-20 12:01:02,960 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[7] 2024-02-20 12:01:09,110 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000228'
[7] 2024-02-20 12:01:09,115 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 216
[3] 2024-02-20 12:01:09,789 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 12:01:09,833 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[3] 2024-02-20 12:01:10,315 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 12:01:10,352 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[3] 2024-02-20 12:01:10,380 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34588,34512,34476,34454,34405,34348,34296,34256,34216,34148,34086,34031,33974,33947,33897,33844,33772,33721,33675,33593) ORDER BY Data DESC, Numero DESC
[9] 2024-02-20 12:01:18,883 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFattDest = 16
[9] 2024-02-20 12:01:18,896 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[9] 2024-02-20 12:01:18,915 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[11] 2024-02-20 12:04:31,884 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34648
[11] 2024-02-20 12:04:31,884 DEBUG - ExecuteScalar: SELECT Numero FROM DocVendTestata WHERE IDDocVendTestata = 34648
[11] 2024-02-20 12:04:31,887 DEBUG - GetDataTable: SELECT CodTipo,Codice,Descrizione FROM InfoComuni WHERE CodLingua = 0
[11] 2024-02-20 12:04:31,906 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34648
[7] 2024-02-20 12:04:40,248 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34648
[7] 2024-02-20 12:04:40,428 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34648
[3] 2024-02-20 12:04:40,725 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 216 ORDER BY Descrizione
[3] 2024-02-20 12:04:40,728 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 12:04:40,731 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 216 And CodTipo = 1
[3] 2024-02-20 12:04:40,733 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34648,34588,34512,34476,34454,34405,34348,34296,34256,34216,34148,34086,34031,33974,33947,33897,33844,33772,33721,33675) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 12:26:28,747 INFO  - DB Connection string: 'Data Source=LocalHost\SQLExpress;Initial Catalog=DB__TPPos;Integrated Security=False;User ID=sa;Password=system;Max Pool Size=400;Connect Timeout=120'.
[3] 2024-02-20 12:26:29,175 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 12:26:30,308 DEBUG - GetDataTable: SELECT CodTipo,Codice,Valore,ValoreNum,ISNULL(CAST(DecryptByPassPhrase('T3cn0Pr0', ValoreBinary) AS VARCHAR(MAX)), '') AS ValoreBinary FROM Configurazioni
[7] 2024-02-20 12:26:35,184 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[7] 2024-02-20 12:26:35,190 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[3] 2024-02-20 12:26:35,758 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[3] 2024-02-20 12:26:35,857 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[3] 2024-02-20 12:26:36,275 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[3] 2024-02-20 12:26:36,294 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[3] 2024-02-20 12:26:36,303 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34639,34446,34149,34027,33843,33700,33595,33543,33449,33272,33176,32988,32904,32786,32711,32525,32477,32404,32403,32243) ORDER BY Data DESC, Numero DESC
[3] 2024-02-20 12:26:42,735 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34639
[3] 2024-02-20 12:26:43,103 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[3] 2024-02-20 12:26:43,132 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[8] 2024-02-20 12:29:08,160 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34639
[8] 2024-02-20 12:29:08,286 DEBUG - ExecuteNonQuery: DELETE FROM DocVendRighe WHERE IDDocVendTestata = 34639
[9] 2024-02-20 12:29:08,543 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[9] 2024-02-20 12:29:08,563 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[9] 2024-02-20 12:29:08,565 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[9] 2024-02-20 12:29:08,568 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34639,34446,34149,34027,33843,33700,33595,33543,33449,33272,33176,32988,32904,32786,32711,32525,32477,32404,32403,32243) ORDER BY Data DESC, Numero DESC
[8] 2024-02-20 12:29:14,752 DEBUG - ExecuteReader: SELECT *, dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata = 34639
[8] 2024-02-20 12:29:14,836 DEBUG - GetDataTable: SELECT IDRepProd,Codice,Descrizione FROM viewRepartoProduzione WHERE IDPV = -1 ORDER BY Descrizione
[8] 2024-02-20 12:29:14,837 DEBUG - GetDataTable: SELECT IDCategoria,Codice,Descrizione FROM viewCategoria ORDER BY Descrizione
[9] 2024-02-20 12:29:35,238 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[9] 2024-02-20 12:29:35,260 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[9] 2024-02-20 12:29:35,267 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[9] 2024-02-20 12:29:35,274 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34639,34446,34149,34027,33843,33700,33595,33543,33449,33272,33176,32988,32904,32786,32711,32525,32477,32404,32403,32243) ORDER BY Data DESC, Numero DESC
[8] 2024-02-20 12:29:48,866 DEBUG - ExecuteScalar: SELECT IDClienteFatt FROM ClienteFatturazione WHERE Codice = '00000576'
[8] 2024-02-20 12:29:48,926 DEBUG - ExecuteReader: SELECT * FROM viewClienteFatturazione WHERE IDClienteFatt = 452
[9] 2024-02-20 12:29:49,078 DEBUG - ExecuteReader: SELECT Codice, Testo FROM LocStrings WHERE CodLingua = 0
[9] 2024-02-20 12:29:49,108 DEBUG - GetDataTable: SELECT IDClienteFattDest,Descrizione,IndirizzoCompleto FROM viewClienteFatturazione_Destinazioni WHERE IDClienteFatt = 452 ORDER BY Descrizione
[9] 2024-02-20 12:29:49,115 DEBUG - ExecuteReader: With tmp As (SELECT IDDocVendTestata, ROW_NUMBER() OVER (ORDER BY Data DESC, Numero DESC) AS RowNum FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1) Select IDDocVendTestata FROM tmp WHERE RowNum BETWEEN 1 And 20 ORDER BY RowNum
[9] 2024-02-20 12:29:49,123 DEBUG - ExecuteScalar: SELECT COUNT(*) FROM viewDocVendTestata WHERE IDClienteFatt = 452 And CodTipo = 1
[9] 2024-02-20 12:29:49,129 DEBUG - GetDataTable: SELECT *,dbo.ufnGetLocDescrInfoComune(0, 55, CodStato) As DescrStato FROM viewDocVendTestata WHERE IDDocVendTestata IN (34639,34446,34149,34027,33843,33700,33595,33543,33449,33272,33176,32988,32904,32786,32711,32525,32477,32404,32403,32243) ORDER BY Data DESC, Numero DESC