2024/07/03 18:00:01 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20002', '6', '93500846', 'HAV3305', '40', '2024/07/03 16:42:14', '2024/07/03 17:59:44', '2024/07/03 17:59:44', '113', '7', 'DN', '03741047', '0', '0', '3', '0', '0', 'Y', '5272', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 17:59:58', '0', '66859191006HAV3305')"}} 2024/07/03 18:00:01 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:00:03 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'AZT7973' AND EntryDatetime = '2024/07/03 16:32:31')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:58:39', ExitDatetime = '2024/07/03 17:59:58', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'AZT7973' AND EntryDatetime = '2024/07/03 16:32:31'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'AZT7973', '2024/07/03 16:32:31', '2024/07/03 17:58:39', '2024/07/03 17:59:58', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:00:03 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:00:08 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '40', '2024/07/03 17:59:44', '45', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '94', '43', '528', '22', '0', '66859191006HAV3305')"}} 2024/07/03 18:00:08 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:30 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2937' AND EntryDatetime = '2024/07/03 17:09:46')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:56:21', ExitDatetime = '2024/07/03 18:01:38', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2937' AND EntryDatetime = '2024/07/03 17:09:46'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL2937', '2024/07/03 17:09:46', '2024/07/03 17:56:21', '2024/07/03 18:01:38', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:01:30 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:44 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2303' AND EntryDatetime = '2024/07/03 17:46:06')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:00:49', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2303' AND EntryDatetime = '2024/07/03 17:46:06'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL2303', '2024/07/03 17:46:06', '2024/07/03 18:00:49', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:01:44 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:44 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL5783' AND EntryDatetime = '2024/07/03 17:09:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:57:13', ExitDatetime = '2024/07/03 18:01:55', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL5783' AND EntryDatetime = '2024/07/03 17:09:53'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MZL5783', '2024/07/03 17:09:53', '2024/07/03 17:57:13', '2024/07/03 18:01:55', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:01:44 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:45 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/07/03 18:00:49', '10', '0', '2024/07/03 17:46:06', '0', '1', 'NEL2303', '0', '0', '668591D1008NEL2303', '20', '')"}} 2024/07/03 18:01:45 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:49 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1867' AND EntryDatetime = '2024/07/03 17:10:04')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:01:56', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1867' AND EntryDatetime = '2024/07/03 17:10:04'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL1867', '2024/07/03 17:10:04', '2024/07/03 18:01:56', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:01:49 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:50 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '66859214007NEL1867', '606104', '822550145', 'NEL1867', '2024/07/03 17:10:04', '2024/07/03 18:01:56', '2024/07/03 18:02:02', '20', '0', '365', '345', '24070302', '', '0', '0')"}} 2024/07/03 18:01:50 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:52 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'NEL1867', '20', '2024/07/03 17:10:04', '2024/07/03 18:01:56', '2024/07/03 18:01:56', '113', '7', 'DL', '21338906', '0', '0', '3', '0', '0', 'N', '1427', '1K0001', '', '822550145', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:02:04', '0', '66859214007NEL1867')"}} 2024/07/03 18:01:52 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:52 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'NEL2303', '20', '2024/07/03 17:46:06', '2024/07/03 18:00:49', '2024/07/03 18:00:49', '113', '7', 'DL', '21338800', '0', '0', '3', '0', '0', 'Y', '4428', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:01:09', '0', '668591D1008NEL2303')"}} 2024/07/03 18:01:52 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:54 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '822550145', '0', '20', '0', '1', '2024/07/03 18:01:56', '10', '0', '2024/07/03 17:10:04', '0', '1', 'NEL1867', '0', '0', '66859214007NEL1867', '20', '')"}} 2024/07/03 18:01:54 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:01:55 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/07/03 18:00:49', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '48', '46', '309', '42', '0', '668591D1008NEL2303')"}} 2024/07/03 18:01:55 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:22 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BKU5972' AND EntryDatetime = '2024/07/03 16:59:49')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:01:38', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BKU5972' AND EntryDatetime = '2024/07/03 16:59:49'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'BKU5972', '2024/07/03 16:59:49', '2024/07/03 18:01:38', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:02:22 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:23 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '15', '66859202015BKU5972', '606104', '668568037', 'BKU5972', '2024/07/03 16:59:49', '2024/07/03 18:01:38', '2024/07/03 18:02:23', '40', '0', '108', '68', '24070303', '', '0', '0')"}} 2024/07/03 18:02:23 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:28 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '15', '668568037', '0', '40', '0', '1', '2024/07/03 18:01:38', '10', '0', '2024/07/03 16:59:49', '0', '0', 'BKU5972', '0', '1', '66859202015BKU5972', '40', '')"}} 2024/07/03 18:02:28 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:37 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL5337' AND EntryDatetime = '2024/07/03 17:09:58')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:57:48', ExitDatetime = '2024/07/03 18:02:45', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL5337' AND EntryDatetime = '2024/07/03 17:09:58'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MZL5337', '2024/07/03 17:09:58', '2024/07/03 17:57:48', '2024/07/03 18:02:45', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:02:37 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:40 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '15', '89052070', 'BKU5972', '40', '2024/07/03 16:59:49', '2024/07/03 18:01:38', '2024/07/03 18:01:38', '113', '7', 'DL', '21337532', '0', '0', '3', '0', '0', 'Y', '4999', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:02:35', '0', '66859202015BKU5972')"}} 2024/07/03 18:02:40 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:47 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL3937' AND EntryDatetime = '2024/07/03 17:09:37')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:56:36', ExitDatetime = '2024/07/03 18:02:55', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL3937' AND EntryDatetime = '2024/07/03 17:09:37'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MZL3937', '2024/07/03 17:09:37', '2024/07/03 17:56:36', '2024/07/03 18:02:55', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:02:47 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:02:56 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1867' AND EntryDatetime = '2024/07/03 17:10:04')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:01:56', ExitDatetime = '2024/07/03 18:03:04', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1867' AND EntryDatetime = '2024/07/03 17:10:04'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL1867', '2024/07/03 17:10:04', '2024/07/03 18:01:56', '2024/07/03 18:03:04', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:02:56 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:03:44 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL3936' AND EntryDatetime = '2024/07/03 17:10:13')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:56:51', ExitDatetime = '2024/07/03 18:03:53', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL3936' AND EntryDatetime = '2024/07/03 17:10:13'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MZL3936', '2024/07/03 17:10:13', '2024/07/03 17:56:51', '2024/07/03 18:03:53', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:03:44 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:04:03 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2303' AND EntryDatetime = '2024/07/03 17:46:06')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:00:49', ExitDatetime = '2024/07/03 18:04:14', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2303' AND EntryDatetime = '2024/07/03 17:46:06'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL2303', '2024/07/03 17:46:06', '2024/07/03 18:00:49', '2024/07/03 18:04:14', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:04:03 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:04:39 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = '2116EJ' AND EntryDatetime = '2024/07/03 08:04:33')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:04:36', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '34', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = '2116EJ' AND EntryDatetime = '2024/07/03 08:04:33'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', '2116EJ', '2024/07/03 08:04:33', '', '2024/07/03 18:04:36', '2', '1', '2', '192.168.50.150', '34', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:04:39 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:05:22 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20003', 'TDE7213', '2024/07/03 18:05:22', '', '2024/07/03 18:05:22', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/03 18:05:22 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:05:23 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'TDE7213' AND EntryDatetime = '2024/07/03 18:05:22')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:05:22', TransStatus = '2', EntryEmqID = '2', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'TDE7213' AND EntryDatetime = '2024/07/03 18:05:22'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20003', 'TDE7213', '2024/07/03 18:05:22', '', '2024/07/03 18:05:22', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:05:23 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:05:49 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20003', 'RAV3653', '2024/07/03 18:05:48', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/03 18:05:49 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:05:54 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'RAV3653' AND EntryDatetime = '2024/07/03 18:05:48')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:05:51', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'RAV3653' AND EntryDatetime = '2024/07/03 18:05:48'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20003', 'RAV3653', '2024/07/03 18:05:48', '', '2024/07/03 18:05:51', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:05:54 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:06:03 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2380' AND EntryDatetime = '2024/07/03 15:52:52')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:56:15', ExitDatetime = '2024/07/03 18:06:13', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2380' AND EntryDatetime = '2024/07/03 15:52:52'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL2380', '2024/07/03 15:52:52', '2024/07/03 17:56:15', '2024/07/03 18:06:13', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:06:03 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:06:08 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BKU5972' AND EntryDatetime = '2024/07/03 16:59:49')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:01:38', ExitDatetime = '2024/07/03 18:06:07', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BKU5972' AND EntryDatetime = '2024/07/03 16:59:49'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'BKU5972', '2024/07/03 16:59:49', '2024/07/03 18:01:38', '2024/07/03 18:06:07', '2', '1', '2', '192.168.50.150', '0', '0', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:06:08 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:06:13 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BKU5972' AND EntryDatetime = '2024/07/03 16:59:49')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:01:38', ExitDatetime = '2024/07/03 18:06:07', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BKU5972' AND EntryDatetime = '2024/07/03 16:59:49'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'BKU5972', '2024/07/03 16:59:49', '2024/07/03 18:01:38', '2024/07/03 18:06:07', '2', '1', '2', '192.168.50.150', '0', '1', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:06:13 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:06:13 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2387' AND EntryDatetime = '2024/07/03 15:52:42')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:54:55', ExitDatetime = '2024/07/03 18:06:23', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2387' AND EntryDatetime = '2024/07/03 15:52:42'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL2387', '2024/07/03 15:52:42', '2024/07/03 17:54:55', '2024/07/03 18:06:23', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:06:13 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:08:05 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RDS6170' AND EntryDatetime = '2024/07/03 17:46:46')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:08:04', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RDS6170' AND EntryDatetime = '2024/07/03 17:46:46'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'RDS6170', '2024/07/03 17:46:46', '', '2024/07/03 18:08:04', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:08:05 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:09:16 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20003', 'TDE7213', '2024/07/03 18:09:16', '', '2024/07/03 18:09:16', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/03 18:09:16 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:09:17 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'TDE7213' AND EntryDatetime = '2024/07/03 18:09:16')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:09:16', TransStatus = '2', EntryEmqID = '2', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'TDE7213' AND EntryDatetime = '2024/07/03 18:09:16'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20003', 'TDE7213', '2024/07/03 18:09:16', '', '2024/07/03 18:09:16', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:09:17 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:11:09 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20003', 'RAG3856', '2024/07/03 18:11:06', '', '2024/07/03 18:11:06', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/03 18:11:09 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:11:09 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'RAG3856' AND EntryDatetime = '2024/07/03 18:11:06')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:11:06', TransStatus = '2', EntryEmqID = '2', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'RAG3856' AND EntryDatetime = '2024/07/03 18:11:06'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20003', 'RAG3856', '2024/07/03 18:11:06', '', '2024/07/03 18:11:06', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:11:09 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:12:22 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3239' AND EntryDatetime = '2024/07/03 17:47:43')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:12:17', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3239' AND EntryDatetime = '2024/07/03 17:47:43'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3239', '2024/07/03 17:47:43', '2024/07/03 18:12:17', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:12:22 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:12:22 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '0', '0', '40', '0', '0', '2024/07/03 18:12:17', '10', '0', '2024/07/03 17:47:43', '0', '0', 'RAV3239', '0', '0', '66859481007RAV3239', '40', '')"}} 2024/07/03 18:12:22 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:12:30 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'RAV3239', '40', '2024/07/03 17:47:43', '2024/07/03 18:12:17', '2024/07/03 18:12:17', '113', '7', 'DL', '21338907', '0', '0', '3', '0', '0', 'Y', '5096', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:12:38', '0', '66859481007RAV3239')"}} 2024/07/03 18:12:30 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:12:37 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '7', '0', '40', '2024/07/03 18:12:17', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '36', '50', '353', '38', '0', '66859481007RAV3239')"}} 2024/07/03 18:12:37 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:13:01 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20003', 'RAV3980', '2024/07/03 18:12:58', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/03 18:13:01 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:13:02 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'RAV3980' AND EntryDatetime = '2024/07/03 17:34:51')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 17:34:51', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20003' AND CarPlate = 'RAV3980' AND EntryDatetime = '2024/07/03 17:34:51'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20003', 'RAV3980', '2024/07/03 17:34:51', '', '2024/07/03 17:34:51', '2', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:13:02 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:15:09 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL0832' AND EntryDatetime = '2024/07/03 16:38:20')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:15:12', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL0832' AND EntryDatetime = '2024/07/03 16:38:20'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL0832', '2024/07/03 16:38:20', '2024/07/03 18:15:12', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:15:09 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:15:10 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '1647197457', '0', '20', '0', '1', '2024/07/03 18:15:12', '10', '0', '2024/07/03 16:38:20', '0', '1', 'NEL0832', '0', '0', '66859530007NEL0832', '20', '')"}} 2024/07/03 18:15:10 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:15:10 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '66859530007NEL0832', '606104', '1647197457', 'NEL0832', '2024/07/03 16:38:20', '2024/07/03 18:15:12', '2024/07/03 18:15:20', '20', '0', '416', '396', '24070303', '', '0', '0')"}} 2024/07/03 18:15:10 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:15:17 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'NEL0832', '20', '2024/07/03 16:38:20', '2024/07/03 18:15:12', '2024/07/03 18:15:12', '113', '7', 'DL', '21338908', '0', '0', '3', '0', '0', 'N', '3669', '1K0001', '', '1647197457', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:15:27', '0', '66859530007NEL0832')"}} 2024/07/03 18:15:17 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:17:05 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_ApsCheckOut (CLOUD_LOC_ID, CLOUD_EQP_ID, TransAmount, Subtype, TransDateTime, TransLastDateTime, AgentNumber, TransCount, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '7300', '-1', '2024/07/03 18:14:09', '2024/07/02 18:11:04', '4941', '319', '0')"}} 2024/07/03 18:17:05 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:17:33 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3239' AND EntryDatetime = '2024/07/03 17:47:43')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:12:17', ExitDatetime = '2024/07/03 18:17:30', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3239' AND EntryDatetime = '2024/07/03 17:47:43'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3239', '2024/07/03 17:47:43', '2024/07/03 18:12:17', '2024/07/03 18:17:30', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:17:33 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:21 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED8523' AND EntryDatetime = '2024/07/03 17:34:30')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:18:13', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED8523' AND EntryDatetime = '2024/07/03 17:34:30'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'AED8523', '2024/07/03 17:34:30', '2024/07/03 18:18:13', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:18:21 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:21 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '14', '1959469535', '0', '20', '0', '1', '2024/07/03 18:18:13', '10', '0', '2024/07/03 17:34:30', '0', '1', 'AED8523', '0', '0', '668595E5014AED8523', '20', '')"}} 2024/07/03 18:18:21 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:22 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '14', '668595E5014AED8523', '606104', '1959469535', 'AED8523', '2024/07/03 17:34:30', '2024/07/03 18:18:13', '2024/07/03 18:18:18', '20', '0', '142', '122', '24070303', '', '0', '0')"}} 2024/07/03 18:18:22 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:24 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '14', '89052070', 'AED8523', '20', '2024/07/03 17:34:30', '2024/07/03 18:18:13', '2024/07/03 18:18:13', '113', '7', 'DL', '21337068', '0', '0', '3', '0', '0', 'N', '7287', '1K0001', '', '1959469535', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:18:21', '0', '668595E5014AED8523')"}} 2024/07/03 18:18:24 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:26 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL0832' AND EntryDatetime = '2024/07/03 16:38:20')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:15:12', ExitDatetime = '2024/07/03 18:18:35', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL0832' AND EntryDatetime = '2024/07/03 16:38:20'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL0832', '2024/07/03 16:38:20', '2024/07/03 18:15:12', '2024/07/03 18:18:35', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:18:26 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:40 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED9177' AND EntryDatetime = '2024/07/03 17:34:24')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:18:34', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED9177' AND EntryDatetime = '2024/07/03 17:34:24'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'AED9177', '2024/07/03 17:34:24', '2024/07/03 18:18:34', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:18:40 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:41 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '14', '1959469535', '0', '20', '0', '1', '2024/07/03 18:18:34', '10', '0', '2024/07/03 17:34:24', '0', '1', 'AED9177', '0', '0', '668595FA014AED9177', '20', '')"}} 2024/07/03 18:18:41 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:41 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '14', '668595FA014AED9177', '606104', '1959469535', 'AED9177', '2024/07/03 17:34:24', '2024/07/03 18:18:34', '2024/07/03 18:18:38', '20', '0', '122', '102', '24070303', '', '0', '0')"}} 2024/07/03 18:18:41 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:18:44 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '14', '89052070', 'AED9177', '20', '2024/07/03 17:34:24', '2024/07/03 18:18:34', '2024/07/03 18:18:34', '113', '7', 'DL', '21337069', '0', '0', '3', '0', '0', 'N', '5174', '1K0001', '', '1959469535', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:18:41', '0', '668595FA014AED9177')"}} 2024/07/03 18:18:44 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:21:00 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_ApsCheckOut (CLOUD_LOC_ID, CLOUD_EQP_ID, TransAmount, Subtype, TransDateTime, TransLastDateTime, AgentNumber, TransCount, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '6720', '-1', '2024/07/03 18:18:32', '2024/07/02 18:20:20', '4941', '291', '0')"}} 2024/07/03 18:21:00 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:21:09 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED8523' AND EntryDatetime = '2024/07/03 17:34:30')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:18:13', ExitDatetime = '2024/07/03 18:21:19', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED8523' AND EntryDatetime = '2024/07/03 17:34:30'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'AED8523', '2024/07/03 17:34:30', '2024/07/03 18:18:13', '2024/07/03 18:21:19', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:21:09 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:21:19 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED9177' AND EntryDatetime = '2024/07/03 17:34:24')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:18:34', ExitDatetime = '2024/07/03 18:21:27', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED9177' AND EntryDatetime = '2024/07/03 17:34:24'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'AED9177', '2024/07/03 17:34:24', '2024/07/03 18:18:34', '2024/07/03 18:21:27', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:21:19 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:27:55 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20003', 'RAV3653', '2024/07/03 18:27:53', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/03 18:27:55 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:30:51 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RAV3563' AND EntryDatetime = '2024/07/03 17:32:57')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:30:48', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RAV3563' AND EntryDatetime = '2024/07/03 17:32:57'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'RAV3563', '2024/07/03 17:32:57', '', '2024/07/03 18:30:48', '2', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:30:51 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:33:06 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'NKG8728', '2024/07/03 18:33:14', '', '', '0', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')"}} 2024/07/03 18:33:06 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:33:49 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2737' AND EntryDatetime = '2024/07/03 17:41:16')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:32:50', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2737' AND EntryDatetime = '2024/07/03 17:41:16'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NKG2737', '2024/07/03 17:41:16', '2024/07/03 18:32:50', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:33:49 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:34:57 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/07/03 18:32:50', '10', '0', '2024/07/03 17:41:16', '0', '1', 'NKG2737', '0', '1', '66859952008NKG2737', '20', '')"}} 2024/07/03 18:34:57 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:34:57 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/07/03 18:32:50', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '102', '20', '0', '66859952008NKG2737')"}} 2024/07/03 18:34:57 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:35:00 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'NKG2737', '20', '2024/07/03 17:41:16', '2024/07/03 18:32:50', '2024/07/03 18:32:50', '113', '7', 'DL', '21338801', '0', '0', '3', '0', '0', 'Y', '4737', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:33:20', '0', '66859952008NKG2737')"}} 2024/07/03 18:35:00 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:36:57 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RAV3092' AND EntryDatetime = '2024/07/03 17:04:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:36:55', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RAV3092' AND EntryDatetime = '2024/07/03 17:04:28'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'RAV3092', '2024/07/03 17:04:28', '', '2024/07/03 18:36:55', '2', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:36:57 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:37:15 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV0030' AND EntryDatetime = '2024/07/03 17:27:02')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:35:41', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV0030' AND EntryDatetime = '2024/07/03 17:27:02'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV0030', '2024/07/03 17:27:02', '2024/07/03 18:35:41', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:37:15 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:37:16 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '40', '0', '0', '2024/07/03 18:35:41', '10', '0', '2024/07/03 17:27:02', '0', '0', 'RAV0030', '0', '0', '668599FD008RAV0030', '40', '')"}} 2024/07/03 18:37:16 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:37:28 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'RAV0030', '40', '2024/07/03 17:27:02', '2024/07/03 18:35:41', '2024/07/03 18:35:41', '113', '7', 'DL', '21338802', '0', '0', '3', '0', '88666183', 'Y', '9456', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:36:46', '0', '668599FD008RAV0030')"}} 2024/07/03 18:37:28 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:37:30 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '40', '2024/07/03 18:35:41', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '105', '22', '0', '668599FD008RAV0030')"}} 2024/07/03 18:37:30 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:39:15 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2737' AND EntryDatetime = '2024/07/03 17:41:16')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:32:50', ExitDatetime = '2024/07/03 18:39:24', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2737' AND EntryDatetime = '2024/07/03 17:41:16'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NKG2737', '2024/07/03 17:41:16', '2024/07/03 18:32:50', '2024/07/03 18:39:24', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:39:15 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:39:44 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV0030' AND EntryDatetime = '2024/07/03 17:27:02')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:35:41', ExitDatetime = '2024/07/03 18:39:39', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV0030' AND EntryDatetime = '2024/07/03 17:27:02'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV0030', '2024/07/03 17:27:02', '2024/07/03 18:35:41', '2024/07/03 18:39:39', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:39:44 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:39:54 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2385' AND EntryDatetime = '2024/07/03 15:53:15')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 17:56:42', ExitDatetime = '2024/07/03 18:40:04', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL2385' AND EntryDatetime = '2024/07/03 15:53:15'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL2385', '2024/07/03 15:53:15', '2024/07/03 17:56:42', '2024/07/03 18:40:04', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/03 18:39:54 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:43:11 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'APZ8069' AND EntryDatetime = '2024/07/03 17:56:09')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:43:09', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'APZ8069' AND EntryDatetime = '2024/07/03 17:56:09'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'APZ8069', '2024/07/03 17:56:09', '', '2024/07/03 18:43:09', '2', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:43:11 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:45:00 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8728' AND EntryDatetime = '2024/07/03 18:33:14')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:44:16', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8728' AND EntryDatetime = '2024/07/03 18:33:14'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NKG8728', '2024/07/03 18:33:14', '2024/07/03 18:44:16', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:45:00 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:45:00 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/07/03 18:44:16', '10', '0', '2024/07/03 18:33:14', '0', '1', 'NKG8728', '0', '0', '66859C00008NKG8728', '20', '')"}} 2024/07/03 18:45:00 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:45:13 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'NKG8728', '20', '2024/07/03 18:33:14', '2024/07/03 18:44:16', '2024/07/03 18:44:16', '113', '7', 'DL', '21338803', '0', '0', '3', '0', '0', 'Y', '2771', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:44:28', '0', '66859C00008NKG8728')"}} 2024/07/03 18:45:13 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:45:15 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/07/03 18:44:16', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '107', '22', '0', '66859C00008NKG8728')"}} 2024/07/03 18:45:15 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:47:24 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8728' AND EntryDatetime = '2024/07/03 18:33:14')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:44:16', ExitDatetime = '2024/07/03 18:47:32', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8728' AND EntryDatetime = '2024/07/03 18:33:14'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NKG8728', '2024/07/03 18:33:14', '2024/07/03 18:44:16', '2024/07/03 18:47:32', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:47:24 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:47:43 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'NCF8596', '2024/07/03 18:47:52', '', '', '0', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')"}} 2024/07/03 18:47:43 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:51:11 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = '8525XL' AND EntryDatetime = '2024/07/03 17:59:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/03 18:51:08', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = '8525XL' AND EntryDatetime = '2024/07/03 17:59:18'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', '8525XL', '2024/07/03 17:59:18', '', '2024/07/03 18:51:08', '2', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:51:11 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:53:04 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'RBY2387', '2024/07/03 18:52:57', '', '', '0', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')"}} 2024/07/03 18:53:04 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:53:47 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX7159' AND EntryDatetime = '2024/07/03 17:48:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:52:56', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX7159' AND EntryDatetime = '2024/07/03 17:48:38'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MNX7159', '2024/07/03 17:48:38', '2024/07/03 18:52:56', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:53:47 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:53:47 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/07/03 18:52:56', '10', '0', '2024/07/03 17:48:38', '0', '1', 'MNX7159', '0', '0', '66859E08008MNX7159', '20', '')"}} 2024/07/03 18:53:47 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:53:50 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'MNX7159', '20', '2024/07/03 17:48:38', '2024/07/03 18:52:56', '2024/07/03 18:52:56', '113', '7', 'DL', '21338804', '0', '0', '3', '0', '0', 'Y', '2104', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:53:09', '0', '66859E08008MNX7159')"}} 2024/07/03 18:53:50 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:53:53 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/07/03 18:52:56', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '109', '22', '0', '66859E08008MNX7159')"}} 2024/07/03 18:53:53 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:54:11 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '871PQZ' AND EntryDatetime = '2024/07/03 17:48:47')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:53:24', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '871PQZ' AND EntryDatetime = '2024/07/03 17:48:47'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', '871PQZ', '2024/07/03 17:48:47', '2024/07/03 18:53:24', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:54:11 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:54:12 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/07/03 18:53:24', '10', '0', '2024/07/03 17:48:47', '0', '1', '871PQZ', '0', '0', '66859E24008871PQZ', '20', '')"}} 2024/07/03 18:54:12 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:54:14 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', '871PQZ', '20', '2024/07/03 17:48:47', '2024/07/03 18:53:24', '2024/07/03 18:53:24', '113', '7', 'DL', '21338805', '0', '0', '3', '0', '0', 'Y', '0275', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/03 18:53:31', '0', '66859E24008871PQZ')"}} 2024/07/03 18:54:14 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:54:17 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/07/03 18:53:24', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '111', '22', '0', '66859E24008871PQZ')"}} 2024/07/03 18:54:17 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:58:21 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX7159' AND EntryDatetime = '2024/07/03 17:48:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:52:56', ExitDatetime = '2024/07/03 18:58:28', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX7159' AND EntryDatetime = '2024/07/03 17:48:38'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MNX7159', '2024/07/03 17:48:38', '2024/07/03 18:52:56', '2024/07/03 18:58:28', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:58:21 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/03 18:58:25 - Loc20_UploadData Receive：{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '871PQZ' AND EntryDatetime = '2024/07/03 17:48:47')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/03 18:53:24', ExitDatetime = '2024/07/03 18:58:34', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '871PQZ' AND EntryDatetime = '2024/07/03 17:48:47'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', '871PQZ', '2024/07/03 17:48:47', '2024/07/03 18:53:24', '2024/07/03 18:58:34', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/03 18:58:25 - Loc20_UploadData Response：{"errCode":"000000","errMsg":"正常","responseData":{}}