2024/06/20 09:12:38 - 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 = '118GUB' AND EntryDatetime = '2024/06/20 08:38:52')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:12:32', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '118GUB' AND EntryDatetime = '2024/06/20 08:38: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', '118GUB', '2024/06/20 08:38:52', '2024/06/20 09:12:32', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:12:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:12:39 - 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/06/20 09:12:32', '10', '0', '2024/06/20 08:38:52', '0', '1', '118GUB', '0', '0', '6673F280008118GUB', '20', '')"}} 2024/06/20 09:12:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:12:51 - 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', '118GUB', '20', '2024/06/20 08:38:52', '2024/06/20 09:12:32', '2024/06/20 09:12:32', '113', '5', 'BM', '27301355', '0', '0', '3', '0', '0', 'Y', '4129', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:13:00', '0', '6673F280008118GUB')"}} 2024/06/20 09:12:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:12: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/06/20 09:12:32', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '40', '118', '20', '0', '6673F280008118GUB')"}} 2024/06/20 09:12:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:14:04 - 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 = '118GUB' AND EntryDatetime = '2024/06/20 08:38:52')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:12:32', ExitDatetime = '2024/06/20 09:14:10', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '118GUB' AND EntryDatetime = '2024/06/20 08:38: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', '118GUB', '2024/06/20 08:38:52', '2024/06/20 09:12:32', '2024/06/20 09:14:10', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:14:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:21:28 - 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', 'MNX8128', '2024/06/20 09:21:32', '', '', '0', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:21:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:21:38 - 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', 'MNX8127', '2024/06/20 09:21:43', '', '', '0', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:21:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:30:33 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'ATZ6566', '2024/06/20 09:30:28', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/20 09:30:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:31:32 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'MNX5186', '2024/06/20 09:31:26', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:31:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:33:54 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'NDV9910' AND EntryDatetime = '2024/06/20 07:48:11')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:33:42', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'NDV9910' AND EntryDatetime = '2024/06/20 07:48:11'\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', 'NDV9910', '2024/06/20 07:48:11', '2024/06/20 09:33:42', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:33:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:33:55 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', '6', '0', '0', '20', '0', '0', '2024/06/20 09:33:42', '10', '0', '2024/06/20 07:48:11', '0', '1', 'NDV9910', '0', '0', '6673F776006NDV9910', '20', '')"}} 2024/06/20 09:33:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:33:57 - 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', 'NDV9910', '20', '2024/06/20 07:48:11', '2024/06/20 09:33:42', '2024/06/20 09:33:42', '113', '5', 'BP', '17123714', '0', '0', '3', '0', '0', 'Y', '7066', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:33:54', '0', '6673F776006NDV9910')"}} 2024/06/20 09:33:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:34:04 - 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', '20', '2024/06/20 09:33:42', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '56', '428', '12', '0', '6673F776006NDV9910')"}} 2024/06/20 09:34:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:34:17 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MSM9030' AND EntryDatetime = '2024/06/20 07:48:05')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:34:11', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MSM9030' AND EntryDatetime = '2024/06/20 07:48:05'\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', 'MSM9030', '2024/06/20 07:48:05', '2024/06/20 09:34:11', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:34:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:34:18 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', '6', '0', '0', '20', '0', '0', '2024/06/20 09:34:11', '10', '0', '2024/06/20 07:48:05', '0', '1', 'MSM9030', '0', '0', '6673F793006MSM9030', '20', '')"}} 2024/06/20 09:34:18 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:34:21 - 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', 'MSM9030', '20', '2024/06/20 07:48:05', '2024/06/20 09:34:11', '2024/06/20 09:34:11', '113', '5', 'BP', '17123715', '0', '0', '3', '0', '0', 'Y', '0220', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:34:17', '0', '6673F793006MSM9030')"}} 2024/06/20 09:34:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:34:23 - 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', '20', '2024/06/20 09:34:11', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '56', '430', '12', '0', '6673F793006MSM9030')"}} 2024/06/20 09:34:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:36:58 - 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 = 'MSM9030' AND EntryDatetime = '2024/06/20 07:48:05')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:34:11', ExitDatetime = '2024/06/20 09:36:55', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MSM9030' AND EntryDatetime = '2024/06/20 07:48:05'\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', 'MSM9030', '2024/06/20 07:48:05', '2024/06/20 09:34:11', '2024/06/20 09:36:55', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:36:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:37:07 - 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 = 'NDV9910' AND EntryDatetime = '2024/06/20 07:48:11')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:33:42', ExitDatetime = '2024/06/20 09:37:01', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'NDV9910' AND EntryDatetime = '2024/06/20 07:48:11'\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', 'NDV9910', '2024/06/20 07:48:11', '2024/06/20 09:33:42', '2024/06/20 09:37:01', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:37:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:37:42 - 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 = 'MNX8127' AND EntryDatetime = '2024/06/20 09:21:43')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:37:19', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX8127' AND EntryDatetime = '2024/06/20 09:21: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', 'MNX8127', '2024/06/20 09:21:43', '2024/06/20 09:37:19', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:37:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:37:43 - 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/06/20 09:37:19', '10', '0', '2024/06/20 09:21:43', '0', '1', 'MNX8127', '0', '0', '6673F84F008MNX8127', '20', '')"}} 2024/06/20 09:37:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:37: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', 'MNX8127', '20', '2024/06/20 09:21:43', '2024/06/20 09:37:19', '2024/06/20 09:37:19', '113', '5', 'BM', '27301356', '0', '0', '3', '0', '0', 'Y', '4779', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:37:58', '0', '6673F84F008MNX8127')"}} 2024/06/20 09:37:50 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:37: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/06/20 09:37:19', '100', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '2', '39', '115', '20', '0', '6673F84F008MNX8127')"}} 2024/06/20 09:37:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:38:16 - 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 = 'MNX8128' AND EntryDatetime = '2024/06/20 09:21:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:38:19', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX8128' AND EntryDatetime = '2024/06/20 09:21:32'\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', 'MNX8128', '2024/06/20 09:21:32', '2024/06/20 09:38:19', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:38:16 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:38: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', '20', '0', '0', '2024/06/20 09:38:19', '10', '0', '2024/06/20 09:21:32', '0', '1', 'MNX8128', '0', '0', '6673F88B008MNX8128', '20', '')"}} 2024/06/20 09:38:16 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:38: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', '8', '89052070', 'MNX8128', '20', '2024/06/20 09:21:32', '2024/06/20 09:38:19', '2024/06/20 09:38:19', '113', '5', 'BM', '27301357', '0', '0', '3', '0', '0', 'Y', '2831', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:38:30', '0', '6673F88B008MNX8128')"}} 2024/06/20 09:38:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:38:26 - 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/06/20 09:38:19', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '39', '117', '20', '0', '6673F88B008MNX8128')"}} 2024/06/20 09:38:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:39:15 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'ATD5129', '2024/06/20 09:39:12', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/20 09:39:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:40:11 - 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 = 'MNX8128' AND EntryDatetime = '2024/06/20 09:21:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:38:19', ExitDatetime = '2024/06/20 09:40:17', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX8128' AND EntryDatetime = '2024/06/20 09:21:32'\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', 'MNX8128', '2024/06/20 09:21:32', '2024/06/20 09:38:19', '2024/06/20 09:40:17', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:40:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:40: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 = 'MNX8127' AND EntryDatetime = '2024/06/20 09:21:43')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:37:19', ExitDatetime = '2024/06/20 09:40:36', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MNX8127' AND EntryDatetime = '2024/06/20 09:21: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', 'MNX8127', '2024/06/20 09:21:43', '2024/06/20 09:37:19', '2024/06/20 09:40:36', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:40:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:40:44 - 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', 'NKG8802', '2024/06/20 09:40:46', '', '', '0', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:40:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:41:50 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'BTV5931', '2024/06/20 09:41:45', '', '', '0', '1', '', '192.168.50.150', '38', '0', '0', '0', '', '0')"}} 2024/06/20 09:41:50 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:41: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 = 'BTV5931' AND EntryDatetime = '2024/06/03 14:58:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/06/03 14:58:32', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '38', CHK_SYN = '0', VehicleType = '0', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'BTV5931' AND EntryDatetime = '2024/06/03 14:58:32'\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', 'BTV5931', '2024/06/03 14:58:32', '', '2024/06/03 14:58:32', '2', '1', '', '192.168.50.150', '38', '0', '0', '1', '', '0')\r\nEND\r\n"}} 2024/06/20 09:41:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:42:00 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'NEL8265', '2024/06/20 09:41:55', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:42:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:42:00 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'AED5533' AND EntryDatetime = '2024/06/20 07:41:16')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:41:43', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'AED5533' AND EntryDatetime = '2024/06/20 07: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('20002', 'AED5533', '2024/06/20 07:41:16', '2024/06/20 09:41:43', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:42:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:42:01 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', '6', '0', '0', '20', '0', '0', '2024/06/20 09:41:43', '10', '0', '2024/06/20 07:41:16', '0', '1', 'AED5533', '0', '0', '6673F957006AED5533', '20', '')"}} 2024/06/20 09:42:01 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:42:05 - 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', 'AED5533', '20', '2024/06/20 07:41:16', '2024/06/20 09:41:43', '2024/06/20 09:41:43', '113', '5', 'BP', '17123716', '0', '0', '3', '0', '0', 'Y', '0331', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:42:01', '0', '6673F957006AED5533')"}} 2024/06/20 09:42:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:42:07 - 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', '20', '2024/06/20 09:41:43', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '56', '432', '12', '0', '6673F957006AED5533')"}} 2024/06/20 09:42:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:43:20 - 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 = 'AED5533' AND EntryDatetime = '2024/06/20 07:41:16')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:41:43', ExitDatetime = '2024/06/20 09:43:17', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'AED5533' AND EntryDatetime = '2024/06/20 07: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('20002', 'AED5533', '2024/06/20 07:41:16', '2024/06/20 09:41:43', '2024/06/20 09:43:17', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:43:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:43:50 - 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', 'RBY3152', '2024/06/20 09:43:45', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/20 09:43:50 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:44:33 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'J59220', '2024/06/20 09:44:31', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/20 09:44:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:44:56 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', '5130TG', '2024/06/20 09:44:52', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/20 09:44:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:02 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', '026MEM', '2024/06/20 09:50:01', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:02 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:02 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', '使890', '2024/06/20 09:49:56', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:02 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:07 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'L7860', '2024/06/20 09:50:04', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:12 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'NEL7819', '2024/06/20 09:50:08', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:12 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:16 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'L2883', '2024/06/20 09:50:12', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:16 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:21 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'NEL7817', '2024/06/20 09:50:16', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:26 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'MZL5889', '2024/06/20 09:50:21', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'MZL5880', '2024/06/20 09:50:29', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'MZL6717', '2024/06/20 09:50:26', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:50:40 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'EL7803', '2024/06/20 09:50:33', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:50:40 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:51:03 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'ZL6716', '2024/06/20 09:51:01', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:51:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:51: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 = 'ZL6716' AND EntryDatetime = '2023/08/19 14:27:21')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'ZL6716' AND EntryDatetime = '2023/08/19 14:27:21'\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', 'ZL6716', '2023/08/19 14:27:21', '', '', '2', '3', '', '192.168.50.150', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/20 09:51:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:51:17 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'NEL7808', '2024/06/20 09:51:11', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:51:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:51:21 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'NCG8179', '2024/06/20 09:51:17', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:51:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:51:22 - 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 = 'NCG8179' AND EntryDatetime = '2023/08/19 14:27:11')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'NCG8179' AND EntryDatetime = '2023/08/19 14:27:11'\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', 'NCG8179', '2023/08/19 14:27:11', '', '', '2', '3', '', '192.168.50.150', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/20 09:51:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:52:07 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'MSD3962', '2024/06/20 09:52:03', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:52:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:52:07 - 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', '105PQU', '2024/06/20 09:52:11', '', '', '0', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:52:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:52:53 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'MMP0019', '2024/06/20 09:52:48', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:52:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:54:25 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'NCG8170', '2024/06/20 09:54:21', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:54:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:54:59 - 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', 'MNX2303', '2024/06/20 09:55:02', '', '', '0', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')"}} 2024/06/20 09:54:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:55: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 = 'NKG8802' AND EntryDatetime = '2024/06/20 09:40:46')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:55:08', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8802' AND EntryDatetime = '2024/06/20 09:40: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', 'NKG8802', '2024/06/20 09:40:46', '2024/06/20 09:55:08', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:55:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:55: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', '0', '0', '20', '0', '0', '2024/06/20 09:55:08', '10', '0', '2024/06/20 09:40:46', '0', '1', 'NKG8802', '0', '0', '6673FC7C007NKG8802', '20', '')"}} 2024/06/20 09:55:10 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:55: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', 'NKG8802', '20', '2024/06/20 09:40:46', '2024/06/20 09:55:08', '2024/06/20 09:55:08', '113', '5', 'BM', '27301321', '0', '0', '3', '0', '0', 'Y', '1589', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:55:17', '0', '6673FC7C007NKG8802')"}} 2024/06/20 09:55:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:55:20 - 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', '20', '2024/06/20 09:55:08', '50', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '1', '40', '100', '20', '0', '6673FC7C007NKG8802')"}} 2024/06/20 09:55:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:56:45 - 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 = 'NKG8802' AND EntryDatetime = '2024/06/20 09:40:46')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:55:08', ExitDatetime = '2024/06/20 09:56:47', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8802' AND EntryDatetime = '2024/06/20 09:40: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', 'NKG8802', '2024/06/20 09:40:46', '2024/06/20 09:55:08', '2024/06/20 09:56:47', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:56:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:58: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 = 'RBY3152' AND EntryDatetime = '2024/06/20 09:43:45')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/20 09:58:35', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3152' AND EntryDatetime = '2024/06/20 09:43:45'\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', 'RBY3152', '2024/06/20 09:43:45', '2024/06/20 09:58:35', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:58:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:58: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', '40', '0', '0', '2024/06/20 09:58:35', '10', '0', '2024/06/20 09:43:45', '0', '0', 'RBY3152', '0', '0', '6673FD4B008RBY3152', '40', '')"}} 2024/06/20 09:58:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:58:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","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('20002', 'RBK1822', '2024/06/20 09:58:39', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/20 09:58:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:58:47 - 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', 'RBY3152', '40', '2024/06/20 09:43:45', '2024/06/20 09:58:35', '2024/06/20 09:58:35', '113', '5', 'BM', '27301358', '0', '0', '3', '0', '0', 'Y', '9518', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/20 09:58:57', '0', '6673FD4B008RBY3152')"}} 2024/06/20 09:58:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:58:54 - 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/06/20 09:58:35', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '2', '40', '116', '20', '0', '6673FD4B008RBY3152')"}} 2024/06/20 09:58:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/20 09:59:17 - 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 = 'BTV5931' AND EntryDatetime = '2024/06/20 09:41:45')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/06/20 09:59:13', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '38', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'BTV5931' AND EntryDatetime = '2024/06/20 09:41:45'\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', 'BTV5931', '2024/06/20 09:41:45', '', '2024/06/20 09:59:13', '2', '1', '2', '192.168.50.150', '38', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/20 09:59:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}}