2024/07/17 18:00: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 = 'NEL8385' AND EntryDatetime = '2024/07/17 17:16:19')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 17:55:58', ExitDatetime = '2024/07/17 18:00:39', 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 = 'NEL8385' AND EntryDatetime = '2024/07/17 17:16:19'\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', 'NEL8385', '2024/07/17 17:16:19', '2024/07/17 17:55:58', '2024/07/17 18:00:39', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:00:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:00:40 - 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 = 'MZL5890' AND EntryDatetime = '2024/07/17 17:16:35')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 17:55:37', ExitDatetime = '2024/07/17 18:00:47', 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 = 'MZL5890' AND EntryDatetime = '2024/07/17 17:16:35'\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', 'MZL5890', '2024/07/17 17:16:35', '2024/07/17 17:55:37', '2024/07/17 18:00:47', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:00:40 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:01: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('20003', 'E64007', '2024/07/17 18:01:03', '', '2024/07/17 18:01:03', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:01:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:01:05 - 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 = 'E64007' AND EntryDatetime = '2024/07/17 18:01:03')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/17 18:01:03', 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 = 'E64007' AND EntryDatetime = '2024/07/17 18:01:03'\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', 'E64007', '2024/07/17 18:01:03', '', '2024/07/17 18:01:03', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:01:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:01: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', 'E64007', '2024/07/17 18:01:07', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:01:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:01: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', 'RAG3885', '2024/07/17 18:01:23', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:01:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:02:22 - 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 = 'RBY3183' AND EntryDatetime = '2024/07/17 15:27:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:01:39', 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 = '20002' AND CarPlate = 'RBY3183' AND EntryDatetime = '2024/07/17 15:27: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', 'RBY3183', '2024/07/17 15:27:28', '2024/07/17 18:01:39', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:02:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:02:23 - 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', '40', '0', '0', '2024/07/17 18:01:39', '10', '0', '2024/07/17 15:27:28', '0', '0', 'RBY3183', '0', '0', '66980703006RBY3183', '40', '')"}} 2024/07/17 18:02:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:02:30 - 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', 'RBY3183', '40', '2024/07/17 15:27:28', '2024/07/17 18:01:39', '2024/07/17 18:01:39', '113', '7', 'DN', '03752115', '0', '0', '3', '0', '0', 'Y', '0544', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:02:28', '0', '66980703006RBY3183')"}} 2024/07/17 18:02:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:02:32 - 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 = 'NEL1081' AND EntryDatetime = '2024/07/17 17:44:04')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 17:58:17', ExitDatetime = '2024/07/17 18:02:40', 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 = 'NEL1081' AND EntryDatetime = '2024/07/17 17:44: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', 'NEL1081', '2024/07/17 17:44:04', '2024/07/17 17:58:17', '2024/07/17 18:02:40', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:02:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:02:32 - 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/17 18:01:39', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '9', '49', '351', '12', '0', '66980703006RBY3183')"}} 2024/07/17 18:02:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:02:51 - 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 = 'NEL1076' AND EntryDatetime = '2024/07/17 17:44:29')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 17:57:12', ExitDatetime = '2024/07/17 18:03:02', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1076' AND EntryDatetime = '2024/07/17 17:44:29'\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', 'NEL1076', '2024/07/17 17:44:29', '2024/07/17 17:57:12', '2024/07/17 18:03:02', '2', '3', '4', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:02:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03:13 - 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/17 08:15:58')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/17 18:03:11', 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 = '2116EJ' AND EntryDatetime = '2024/07/17 08:15: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('20002', '2116EJ', '2024/07/17 08:15:58', '', '2024/07/17 18:03:11', '2', '1', '2', '192.168.50.150', '38', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:03:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03: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 = '9017SJ' AND EntryDatetime = '2024/07/17 15:48:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 17:20:25', ExitDatetime = '2024/07/17 18:03:11', 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 = '9017SJ' AND EntryDatetime = '2024/07/17 15:48:00'\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', '9017SJ', '2024/07/17 15:48:00', '2024/07/17 17:20:25', '2024/07/17 18:03:11', '2', '1', '2', '192.168.50.150', '0', '1', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:03:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03:29 - 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 = 'NEL1073' AND EntryDatetime = '2024/07/17 17:44:19')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 17:57:06', ExitDatetime = '2024/07/17 18:03: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 = 'NEL1073' AND EntryDatetime = '2024/07/17 17:44:19'\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', 'NEL1073', '2024/07/17 17:44:19', '2024/07/17 17:57:06', '2024/07/17 18:03:35', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:03:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03:33 - 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', 'RAV3835', '2024/07/17 18:03:25', '', '', '0', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')"}} 2024/07/17 18:03:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03:47 - 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', '6', '2024/07/17 18:03:45', '', '2024/07/17 18:03:45', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:03:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03:47 - 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', '92176NAF', '2024/07/17 18:03:46', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:03:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:03: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 = '20003' AND CarPlate = '6' AND EntryDatetime = '2024/07/17 18:03:45')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/17 18:03:45', 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 = '6' AND EntryDatetime = '2024/07/17 18:03: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('20003', '6', '2024/07/17 18:03:45', '', '2024/07/17 18:03:45', '2', '2', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:03:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:04:05 - 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', 'APJ9221', '2024/07/17 18:04:06', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:04:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:04:06 - 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 = 'APJ9221' AND EntryDatetime = '2024/06/23 12:18:19')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/06/23 12:18:19', 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 = 'APJ9221' AND EntryDatetime = '2024/06/23 12:18:19'\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', 'APJ9221', '2024/06/23 12:18:19', '', '2024/06/23 12:18:19', '2', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:04:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05:13 - 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', 'RAV3652', '2024/07/17 18:05:12', '', '2024/07/17 18:05:14', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:05:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05: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 = '20003' AND CarPlate = 'RAV3652' AND EntryDatetime = '2024/07/17 18:05:12')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/17 18:05:14', 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 = 'RAV3652' AND EntryDatetime = '2024/07/17 18:05:12'\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', 'RAV3652', '2024/07/17 18:05:12', '', '2024/07/17 18:05:14', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:05:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05:30 - 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 = 'RBY3183' AND EntryDatetime = '2024/07/17 15:27:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:01:39', ExitDatetime = '2024/07/17 18:05:26', 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 = 'RBY3183' AND EntryDatetime = '2024/07/17 15:27: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', 'RBY3183', '2024/07/17 15:27:28', '2024/07/17 18:01:39', '2024/07/17 18:05:26', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:05:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05:31 - 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', 'KKG3232', '2024/07/17 18:05:32', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:05:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05:44 - 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', 'RDV0371', '2024/07/17 18:05:43', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:05:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05:58 - 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', '5575RW', '2024/07/17 18:05:59', '', '2024/07/17 18:06:01', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:05:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:05:59 - 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 = '5575RW' AND EntryDatetime = '2024/07/17 18:05:59')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '2024/07/17 18:06:01', 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 = '5575RW' AND EntryDatetime = '2024/07/17 18:05:59'\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', '5575RW', '2024/07/17 18:05:59', '', '2024/07/17 18:06:01', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:05:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:06:03 - 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', '7N0229', '2024/07/17 18:06:05', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:06:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:10:26 - 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 = 'RBY3137' AND EntryDatetime = '2024/07/17 17:23:07')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:09:55', 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 = 'RBY3137' AND EntryDatetime = '2024/07/17 17:23:07'\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', 'RBY3137', '2024/07/17 17:23:07', '2024/07/17 18:09:55', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:10:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:10:26 - 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/17 18:09:55', '10', '0', '2024/07/17 17:23:07', '0', '0', 'RBY3137', '0', '0', '669808F3008RBY3137', '40', '')"}} 2024/07/17 18:10:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:10:43 - 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', 'RBY3137', '40', '2024/07/17 17:23:07', '2024/07/17 18:09:55', '2024/07/17 18:09:55', '113', '7', 'DL', '21347945', '0', '0', '3', '0', '0', 'Y', '1873', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:10:15', '0', '669808F3008RBY3137')"}} 2024/07/17 18:10:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:10:45 - 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/17 18:09:55', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '37', '52', '398', '44', '0', '669808F3008RBY3137')"}} 2024/07/17 18:10:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:12:14 - 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 = 'RBY3137' AND EntryDatetime = '2024/07/17 17:23:07')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:09:55', ExitDatetime = '2024/07/17 18:12:13', 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 = 'RBY3137' AND EntryDatetime = '2024/07/17 17:23:07'\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', 'RBY3137', '2024/07/17 17:23:07', '2024/07/17 18:09:55', '2024/07/17 18:12:13', '2', '1', '2', '192.168.50.150', '0', '0', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:12:14 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:12: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 = 'RBY3137' AND EntryDatetime = '2024/07/17 17:23:07')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:09:55', ExitDatetime = '2024/07/17 18:12:13', 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 = 'RBY3137' AND EntryDatetime = '2024/07/17 17:23:07'\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', 'RBY3137', '2024/07/17 17:23:07', '2024/07/17 18:09:55', '2024/07/17 18:12:13', '2', '1', '2', '192.168.50.150', '0', '1', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:12:19 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:13: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', 'NKG1839', '2024/07/17 18:13:50', '', '', '0', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')"}} 2024/07/17 18:13:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:13:53 - 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 = 'NEL2928' AND EntryDatetime = '2024/07/17 17:26:51')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:13:03', 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 = 'NEL2928' AND EntryDatetime = '2024/07/17 17:26: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('20001', 'NEL2928', '2024/07/17 17:26:51', '2024/07/17 18:13:03', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:13:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:13:53 - 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/17 18:13:03', '10', '0', '2024/07/17 17:26:51', '0', '1', 'NEL2928', '0', '0', '669809AF008NEL2928', '20', '')"}} 2024/07/17 18:13:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:13:57 - 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 = 'MZL5911' AND EntryDatetime = '2024/07/17 17:29:29')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:13:41', 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 = 'MZL5911' AND EntryDatetime = '2024/07/17 17:29:29'\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', 'MZL5911', '2024/07/17 17:29:29', '2024/07/17 18:13:41', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:13:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:13:58 - 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/07/17 18:13:41', '10', '0', '2024/07/17 17:29:29', '0', '1', 'MZL5911', '0', '0', '669809D5007MZL5911', '20', '')"}} 2024/07/17 18:13:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:01 - 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', 'NEL2928', '20', '2024/07/17 17:26:51', '2024/07/17 18:13:03', '2024/07/17 18:13:03', '113', '7', 'DL', '21347946', '0', '0', '3', '0', '0', 'Y', '8355', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:13:35', '0', '669809AF008NEL2928')"}} 2024/07/17 18:14:01 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:03 - 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/17 18:13:03', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '37', '52', '400', '44', '0', '669809AF008NEL2928')"}} 2024/07/17 18:14:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:10 - 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', 'MZL5911', '20', '2024/07/17 17:29:29', '2024/07/17 18:13:41', '2024/07/17 18:13:41', '113', '7', 'DL', '21347666', '0', '0', '3', '0', '0', 'Y', '3902', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:14:20', '0', '669809D5007MZL5911')"}} 2024/07/17 18:14:10 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14: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', '7', '0', '20', '2024/07/17 18:13:41', '50', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '39', '41', '312', '62', '0', '669809D5007MZL5911')"}} 2024/07/17 18:14:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14: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', 'AUZ3178', '2024/07/17 18:14:21', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:14:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:31 - 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 = 'MZL5337' AND EntryDatetime = '2024/07/17 17:26:43')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:14:02', 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 = 'MZL5337' AND EntryDatetime = '2024/07/17 17:26: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', 'MZL5337', '2024/07/17 17:26:43', '2024/07/17 18:14:02', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:14:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:31 - 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/17 18:14:02', '10', '0', '2024/07/17 17:26:43', '0', '1', 'MZL5337', '0', '0', '669809EA008MZL5337', '20', '')"}} 2024/07/17 18:14:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:38 - 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', 'MZL5337', '20', '2024/07/17 17:26:43', '2024/07/17 18:14:02', '2024/07/17 18:14:02', '113', '7', 'DL', '21347947', '0', '0', '3', '0', '0', 'Y', '4402', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:14:12', '0', '669809EA008MZL5337')"}} 2024/07/17 18:14:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14: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 = 'MZL5783' AND EntryDatetime = '2024/07/17 17:29:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:14:39', 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 = 'MZL5783' AND EntryDatetime = '2024/07/17 17:29: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', 'MZL5783', '2024/07/17 17:29:38', '2024/07/17 18:14:39', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:14:40 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:40 - 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/07/17 18:14:39', '10', '0', '2024/07/17 17:29:38', '0', '1', 'MZL5783', '0', '0', '66980A0F007MZL5783', '20', '')"}} 2024/07/17 18:14:40 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:41 - 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/17 18:14:02', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '37', '52', '402', '44', '0', '669809EA008MZL5337')"}} 2024/07/17 18:14:41 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14:53 - 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', 'MZL5783', '20', '2024/07/17 17:29:38', '2024/07/17 18:14:39', '2024/07/17 18:14:39', '113', '7', 'DL', '21347667', '0', '0', '3', '0', '0', 'Y', '3744', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:14:58', '0', '66980A0F007MZL5783')"}} 2024/07/17 18:14:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:14: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', '7', '0', '20', '2024/07/17 18:14:39', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '39', '41', '314', '62', '0', '66980A0F007MZL5783')"}} 2024/07/17 18:14:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15: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 = '138PQY' AND EntryDatetime = '2024/07/17 17:50:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:14:37', 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 = '138PQY' AND EntryDatetime = '2024/07/17 17:50: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', '138PQY', '2024/07/17 17:50:53', '2024/07/17 18:14:37', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:15:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15:23 - 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/17 18:14:37', '10', '0', '2024/07/17 17:50:53', '0', '1', '138PQY', '0', '0', '66980A0D008138PQY', '20', '')"}} 2024/07/17 18:15:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15: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', '8', '89052070', '138PQY', '20', '2024/07/17 17:50:53', '2024/07/17 18:14:37', '2024/07/17 18:14:37', '113', '7', 'DL', '21347948', '0', '0', '3', '0', '0', 'Y', '8309', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:15:12', '0', '66980A0D008138PQY')"}} 2024/07/17 18:15:40 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15:41 - 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 = '228PQY' AND EntryDatetime = '2024/07/17 17:50:41')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:15:33', 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 = '228PQY' AND EntryDatetime = '2024/07/17 17:50:41'\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', '228PQY', '2024/07/17 17:50:41', '2024/07/17 18:15:33', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:15:41 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15:42 - 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/07/17 18:15:33', '10', '0', '2024/07/17 17:50:41', '0', '1', '228PQY', '0', '0', '66980A45007228PQY', '20', '')"}} 2024/07/17 18:15:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15:42 - 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/17 18:14:37', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '37', '52', '404', '44', '0', '66980A0D008138PQY')"}} 2024/07/17 18:15:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15:49 - 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', '228PQY', '20', '2024/07/17 17:50:41', '2024/07/17 18:15:33', '2024/07/17 18:15:33', '113', '7', 'DL', '21347668', '0', '0', '3', '0', '0', 'Y', '7122', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:15:58', '0', '66980A45007228PQY')"}} 2024/07/17 18:15:49 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:15:51 - 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/07/17 18:15:33', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '39', '41', '316', '62', '0', '66980A45007228PQY')"}} 2024/07/17 18:15:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:05 - 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 = '508PQS' AND EntryDatetime = '2024/07/17 17:50:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:15:35', 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 = '508PQS' AND EntryDatetime = '2024/07/17 17:50: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', '508PQS', '2024/07/17 17:50:32', '2024/07/17 18:15:35', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:16:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:05 - 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/17 18:15:35', '10', '0', '2024/07/17 17:50:32', '0', '1', '508PQS', '0', '0', '66980A47008508PQS', '20', '')"}} 2024/07/17 18:16:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16: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', '508PQS', '20', '2024/07/17 17:50:32', '2024/07/17 18:15:35', '2024/07/17 18:15:35', '113', '7', 'DL', '21347949', '0', '0', '3', '0', '0', 'Y', '6242', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:15:47', '0', '66980A47008508PQS')"}} 2024/07/17 18:16:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16: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/17 18:15:35', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '37', '52', '406', '44', '0', '66980A47008508PQS')"}} 2024/07/17 18:16:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:38 - 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 = 'RAV3367' AND EntryDatetime = '2024/07/17 15:13:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:16:19', 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 = '20002' AND CarPlate = 'RAV3367' AND EntryDatetime = '2024/07/17 15:13: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', 'RAV3367', '2024/07/17 15:13:28', '2024/07/17 18:16:19', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:16:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:38 - 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', '60', '0', '0', '2024/07/17 18:16:19', '10', '0', '2024/07/17 15:13:28', '0', '0', 'RAV3367', '0', '0', '66980A73006RAV3367', '60', '')"}} 2024/07/17 18:16:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:45 - 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', 'RAV3367', '60', '2024/07/17 15:13:28', '2024/07/17 18:16:19', '2024/07/17 18:16:19', '113', '7', 'DN', '03752116', '0', '0', '3', '0', '0', 'Y', '2759', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:16:40', '0', '66980A73006RAV3367')"}} 2024/07/17 18:16:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:48 - 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', '60', '2024/07/17 18:16:19', '60', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '9', '50', '352', '12', '0', '66980A73006RAV3367')"}} 2024/07/17 18:16:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:52 - 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 = '583PQZ' AND EntryDatetime = '2024/07/17 17:51:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:16:24', 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 = '583PQZ' AND EntryDatetime = '2024/07/17 17:51:00'\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', '583PQZ', '2024/07/17 17:51:00', '2024/07/17 18:16:24', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:16:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:52 - 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/17 18:16:24', '10', '0', '2024/07/17 17:51:00', '0', '1', '583PQZ', '0', '0', '66980A78008583PQZ', '20', '')"}} 2024/07/17 18:16:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:16:55 - 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', '583PQZ', '20', '2024/07/17 17:51:00', '2024/07/17 18:16:24', '2024/07/17 18:16:24', '113', '7', 'DL', '21347950', '0', '0', '3', '0', '0', 'Y', '6771', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:16:31', '0', '66980A78008583PQZ')"}} 2024/07/17 18:16:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:02 - 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/17 18:16:24', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '37', '52', '408', '44', '0', '66980A78008583PQZ')"}} 2024/07/17 18:17:02 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:05 - 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 = 'RAL0057' AND EntryDatetime = '2024/07/17 17:26:02')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:16:55', 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 = '20002' AND CarPlate = 'RAL0057' AND EntryDatetime = '2024/07/17 17:26: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('20002', 'RAL0057', '2024/07/17 17:26:02', '2024/07/17 18:16:55', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:17:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:06 - 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', '40', '0', '0', '2024/07/17 18:16:55', '10', '0', '2024/07/17 17:26:02', '0', '0', 'RAL0057', '0', '0', '66980A97006RAL0057', '40', '')"}} 2024/07/17 18:17:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:13 - 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', 'RAL0057', '40', '2024/07/17 17:26:02', '2024/07/17 18:16:55', '2024/07/17 18:16:55', '113', '7', 'DN', '03752117', '0', '0', '3', '0', '0', 'Y', '7813', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:17:12', '0', '66980A97006RAL0057')"}} 2024/07/17 18:17:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:20 - 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/17 18:16:55', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '9', '51', '351', '12', '0', '66980A97006RAL0057')"}} 2024/07/17 18:17:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:20 - 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 = 'NEL2928' AND EntryDatetime = '2024/07/17 17:26:51')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:13:03', ExitDatetime = '2024/07/17 18:17:29', 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 = 'NEL2928' AND EntryDatetime = '2024/07/17 17:26: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('20001', 'NEL2928', '2024/07/17 17:26:51', '2024/07/17 18:13:03', '2024/07/17 18:17:29', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:17:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17: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 = 'MZL5337' AND EntryDatetime = '2024/07/17 17:26:43')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:14:02', ExitDatetime = '2024/07/17 18:17:39', 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/17 17:26: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', 'MZL5337', '2024/07/17 17:26:43', '2024/07/17 18:14:02', '2024/07/17 18:17:39', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:17:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:39 - 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/17 17:29:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:14:39', ExitDatetime = '2024/07/17 18:17:48', 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/17 17:29: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', 'MZL5783', '2024/07/17 17:29:38', '2024/07/17 18:14:39', '2024/07/17 18:17:48', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:17:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:17:48 - 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 = 'MZL5911' AND EntryDatetime = '2024/07/17 17:29:29')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:13:41', ExitDatetime = '2024/07/17 18:17:57', 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 = 'MZL5911' AND EntryDatetime = '2024/07/17 17:29:29'\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', 'MZL5911', '2024/07/17 17:29:29', '2024/07/17 18:13:41', '2024/07/17 18:17:57', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:17:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:18:28 - 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', 'RAV3268', '2024/07/17 18:18:23', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:18:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:19:32 - 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 = 'RAL0057' AND EntryDatetime = '2024/07/17 17:26:02')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:16:55', ExitDatetime = '2024/07/17 18:19:30', 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 = 'RAL0057' AND EntryDatetime = '2024/07/17 17:26: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('20002', 'RAL0057', '2024/07/17 17:26:02', '2024/07/17 18:16:55', '2024/07/17 18:19:30', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:19:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:20:55 - 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 = 'RAV3367' AND EntryDatetime = '2024/07/17 15:13:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:16:19', ExitDatetime = '2024/07/17 18:20:54', 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 = 'RAV3367' AND EntryDatetime = '2024/07/17 15:13: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', 'RAV3367', '2024/07/17 15:13:28', '2024/07/17 18:16:19', '2024/07/17 18:20:54', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:20:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:21:31 - 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', 'RBK1610', '2024/07/17 18:21:28', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:21:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:21:34 - 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 = '228PQY' AND EntryDatetime = '2024/07/17 17:50:41')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:15:33', ExitDatetime = '2024/07/17 18:21:44', 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 = '228PQY' AND EntryDatetime = '2024/07/17 17:50:41'\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', '228PQY', '2024/07/17 17:50:41', '2024/07/17 18:15:33', '2024/07/17 18:21:44', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:21:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:22: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 = '583PQZ' AND EntryDatetime = '2024/07/17 17:51:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:16:24', ExitDatetime = '2024/07/17 18:22:28', 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 = '583PQZ' AND EntryDatetime = '2024/07/17 17:51:00'\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', '583PQZ', '2024/07/17 17:51:00', '2024/07/17 18:16:24', '2024/07/17 18:22:28', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:22:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:22: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 = '138PQY' AND EntryDatetime = '2024/07/17 17:50:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:14:37', ExitDatetime = '2024/07/17 18:22:52', 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 = '138PQY' AND EntryDatetime = '2024/07/17 17:50: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', '138PQY', '2024/07/17 17:50:53', '2024/07/17 18:14:37', '2024/07/17 18:22:52', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:22:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:22:49 - 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 = '508PQS' AND EntryDatetime = '2024/07/17 17:50:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:15:35', ExitDatetime = '2024/07/17 18:22:59', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '508PQS' AND EntryDatetime = '2024/07/17 17:50: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', '508PQS', '2024/07/17 17:50:32', '2024/07/17 18:15:35', '2024/07/17 18:22:59', '2', '3', '4', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:22:49 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:23: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', 'RAV3597', '2024/07/17 18:23:00', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:23:02 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:24:43 - 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 = 'RAV3973' AND EntryDatetime = '2024/07/17 16:49:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:24:12', 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 = '20002' AND CarPlate = 'RAV3973' AND EntryDatetime = '2024/07/17 16:49: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('20002', 'RAV3973', '2024/07/17 16:49:53', '2024/07/17 18:24:12', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:24:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:24:44 - 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', '40', '0', '0', '2024/07/17 18:24:12', '10', '0', '2024/07/17 16:49:53', '0', '0', 'RAV3973', '0', '0', '66980C4D006RAV3973', '40', '')"}} 2024/07/17 18:24:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:24:56 - 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', 'RAV3973', '40', '2024/07/17 16:49:53', '2024/07/17 18:24:12', '2024/07/17 18:24:12', '113', '7', 'DN', '03752118', '0', '0', '3', '0', '0', 'N', '5970', '3J0002', '/875SP5W', '/875SP5W', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:24:53', '0', '66980C4D006RAV3973')"}} 2024/07/17 18:24:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:02 - 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/17 18:24:12', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '10', '50', '350', '12', '0', '66980C4D006RAV3973')"}} 2024/07/17 18:25:02 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:29 - 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 = 'AUZ3178' AND EntryDatetime = '2024/07/17 18:14:21')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:25:18', 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 = '20002' AND CarPlate = 'AUZ3178' AND EntryDatetime = '2024/07/17 18:14: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', 'AUZ3178', '2024/07/17 18:14:21', '2024/07/17 18:25:18', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:25:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:30 - 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 = 'RAV3973' AND EntryDatetime = '2024/07/17 16:49:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:24:12', ExitDatetime = '2024/07/17 18:25:28', 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 = 'RAV3973' AND EntryDatetime = '2024/07/17 16:49: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('20002', 'RAV3973', '2024/07/17 16:49:53', '2024/07/17 18:24:12', '2024/07/17 18:25:28', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:25:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:30 - 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', '40', '0', '0', '2024/07/17 18:25:18', '10', '0', '2024/07/17 18:14:21', '0', '0', 'AUZ3178', '0', '0', '66980C8E006AUZ3178', '40', '')"}} 2024/07/17 18:25:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:39 - 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', 'RDP2529', '2024/07/17 18:25:37', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:25:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25: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 = 'RDP2529' AND EntryDatetime = '2024/06/25 14:58:01')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '', ExitDatetime = '', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RDP2529' AND EntryDatetime = '2024/06/25 14:58:01'\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', 'RDP2529', '2024/06/25 14:58:01', '', '', '2', '1', '', '192.168.50.150', '0', '0', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:25:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:42 - 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', 'AUZ3178', '40', '2024/07/17 18:14:21', '2024/07/17 18:25:18', '2024/07/17 18:25:18', '113', '7', 'DN', '03752119', '0', '0', '3', '0', '0', 'Y', '9412', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:25:36', '0', '66980C8E006AUZ3178')"}} 2024/07/17 18:25:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:25:44 - 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/17 18:25:18', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10', '50', '354', '12', '0', '66980C8E006AUZ3178')"}} 2024/07/17 18:25:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:26:30 - 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', '7500', '-1', '2024/07/17 18:23:03', '2024/07/16 18:17:05', '4941', '296', '0')"}} 2024/07/17 18:26:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:27:29 - 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 = 'AUZ3178' AND EntryDatetime = '2024/07/17 18:14:21')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:25:18', ExitDatetime = '2024/07/17 18:27:27', 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 = 'AUZ3178' AND EntryDatetime = '2024/07/17 18:14: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', 'AUZ3178', '2024/07/17 18:14:21', '2024/07/17 18:25:18', '2024/07/17 18:27:27', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:27:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:29:55 - 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 = 'RAG3999' AND EntryDatetime = '2024/07/17 17:58:57')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:29:05', 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 = '20002' AND CarPlate = 'RAG3999' AND EntryDatetime = '2024/07/17 17:58: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', 'RAG3999', '2024/07/17 17:58:57', '2024/07/17 18:29:05', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:29:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:29:56 - 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', '40', '0', '0', '2024/07/17 18:29:05', '10', '0', '2024/07/17 17:58:57', '0', '0', 'RAG3999', '0', '0', '66980D71006RAG3999', '40', '')"}} 2024/07/17 18:29:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:30:08 - 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', 'RAG3999', '40', '2024/07/17 17:58:57', '2024/07/17 18:29:05', '2024/07/17 18:29:05', '113', '7', 'DN', '03752120', '0', '0', '3', '0', '0', 'Y', '9330', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:30:07', '0', '66980D71006RAG3999')"}} 2024/07/17 18:30:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:30:14 - 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/17 18:29:05', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10', '50', '358', '12', '0', '66980D71006RAG3999')"}} 2024/07/17 18:30:14 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:31:27 - 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 = 'RCE2923' AND EntryDatetime = '2024/07/17 14:25:26')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:31:13', 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 = '20002' AND CarPlate = 'RCE2923' AND EntryDatetime = '2024/07/17 14:25:26'\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', 'RCE2923', '2024/07/17 14:25:26', '2024/07/17 18:31:13', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:31:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:31:28 - 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', '100', '0', '0', '2024/07/17 18:31:13', '10', '0', '2024/07/17 14:25:26', '0', '0', 'RCE2923', '0', '0', '66980DF1006RCE2923', '100', '')"}} 2024/07/17 18:31:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:31:35 - 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', 'RCE2923', '100', '2024/07/17 14:25:26', '2024/07/17 18:31:13', '2024/07/17 18:31:13', '113', '7', 'DN', '03752121', '0', '0', '3', '0', '0', 'Y', '1469', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:31:30', '0', '66980DF1006RCE2923')"}} 2024/07/17 18:31:35 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:31:37 - 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', '100', '2024/07/17 18:31:13', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '11', '50', '358', '12', '0', '66980DF1006RCE2923')"}} 2024/07/17 18:31:37 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:31:59 - 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', '6320', '-1', '2024/07/17 18:29:34', '2024/07/16 18:24:28', '4941', '287', '0')"}} 2024/07/17 18:31:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:32:13 - 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 = 'RCE2923' AND EntryDatetime = '2024/07/17 14:25:26')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:31:13', ExitDatetime = '2024/07/17 18:32:13', 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 = 'RCE2923' AND EntryDatetime = '2024/07/17 14:25:26'\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', 'RCE2923', '2024/07/17 14:25:26', '2024/07/17 18:31:13', '2024/07/17 18:32:13', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:32:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:32:27 - 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 = 'RAG3999' AND EntryDatetime = '2024/07/17 17:58:57')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:29:05', ExitDatetime = '2024/07/17 18:32:23', 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 = 'RAG3999' AND EntryDatetime = '2024/07/17 17:58: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', 'RAG3999', '2024/07/17 17:58:57', '2024/07/17 18:29:05', '2024/07/17 18:32:23', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:32:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:34:03 - 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 = 'RBK1655' AND EntryDatetime = '2024/07/17 17:41:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:33:48', 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 = '20002' AND CarPlate = 'RBK1655' AND EntryDatetime = '2024/07/17 17:41: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', 'RBK1655', '2024/07/17 17:41:32', '2024/07/17 18:33:48', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:34:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:34:03 - 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', '40', '0', '0', '2024/07/17 18:33:48', '10', '0', '2024/07/17 17:41:32', '0', '0', 'RBK1655', '0', '0', '66980E8C006RBK1655', '40', '')"}} 2024/07/17 18:34:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:34:11 - 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', 'RBK1655', '40', '2024/07/17 17:41:32', '2024/07/17 18:33:48', '2024/07/17 18:33:48', '113', '7', 'DN', '03752122', '0', '0', '3', '0', '0', 'Y', '3258', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:34:09', '0', '66980E8C006RBK1655')"}} 2024/07/17 18:34:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:34:22 - 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/17 18:33:48', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '12', '49', '357', '12', '0', '66980E8C006RBK1655')"}} 2024/07/17 18:34:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:36: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 = 'RBK1655' AND EntryDatetime = '2024/07/17 17:41:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:33:48', ExitDatetime = '2024/07/17 18:36:36', 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 = 'RBK1655' AND EntryDatetime = '2024/07/17 17:41: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', 'RBK1655', '2024/07/17 17:41:32', '2024/07/17 18:33:48', '2024/07/17 18:36:36', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:36:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:37:38 - 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 = '1137WM' AND EntryDatetime = '2024/07/17 16:50:11')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:37:25', 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 = '20002' AND CarPlate = '1137WM' AND EntryDatetime = '2024/07/17 16:50: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', '1137WM', '2024/07/17 16:50:11', '2024/07/17 18:37:25', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:37:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:37:38 - 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', '40', '0', '0', '2024/07/17 18:37:25', '10', '0', '2024/07/17 16:50:11', '0', '0', '1137WM', '0', '0', '66980F650061137WM', '40', '')"}} 2024/07/17 18:37:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:37:50 - 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', '1137WM', '40', '2024/07/17 16:50:11', '2024/07/17 18:37:25', '2024/07/17 18:37:25', '113', '7', 'DN', '03752123', '0', '0', '3', '0', '0', 'N', '5819', '3J0002', '/SFMUSN4', '/SFMUSN4', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:37:51', '0', '66980F650061137WM')"}} 2024/07/17 18:37:50 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:37:57 - 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/17 18:37:25', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '12', '50', '356', '12', '0', '66980F650061137WM')"}} 2024/07/17 18:37:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:39:10 - 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 = '1137WM' AND EntryDatetime = '2024/07/17 16:50:11')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:37:25', ExitDatetime = '2024/07/17 18:39:06', 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 = '1137WM' AND EntryDatetime = '2024/07/17 16:50: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', '1137WM', '2024/07/17 16:50:11', '2024/07/17 18:37:25', '2024/07/17 18:39:06', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:39:10 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:39:28 - 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', 'RAG3769', '2024/07/17 18:39:24', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/17 18:39:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:40: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', 'APJ9221', '2024/07/17 18:40:54', '', '', '0', '1', '', '192.168.50.150', '38', '0', '0', '0', '', '0')"}} 2024/07/17 18:40:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:43: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 = 'NKG1839' AND EntryDatetime = '2024/07/17 18:13:50')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:43:04', 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 = 'NKG1839' AND EntryDatetime = '2024/07/17 18:13:50'\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', 'NKG1839', '2024/07/17 18:13:50', '2024/07/17 18:43:04', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:43:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:43: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', '1078042053', '0', '20', '0', '1', '2024/07/17 18:43:04', '10', '0', '2024/07/17 18:13:50', '0', '1', 'NKG1839', '0', '0', '669810B8014NKG1839', '20', '')"}} 2024/07/17 18:43:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:43: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', '669810B8014NKG1839', '606104', '1078042053', 'NKG1839', '2024/07/17 18:13:50', '2024/07/17 18:43:04', '2024/07/17 18:43:18', '20', '0', '456', '436', '24071704', '', '0', '0')"}} 2024/07/17 18:43:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:43:29 - 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', 'NKG1839', '20', '2024/07/17 18:13:50', '2024/07/17 18:43:04', '2024/07/17 18:43:04', '113', '7', 'DL', '21346256', '0', '0', '3', '0', '0', 'Y', '0222', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:43:24', '0', '669810B8014NKG1839')"}} 2024/07/17 18:43:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:47:05 - 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 = 'RDM9309' AND EntryDatetime = '2024/07/17 17:23:55')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:46:49', 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 = '20002' AND CarPlate = 'RDM9309' AND EntryDatetime = '2024/07/17 17:23:55'\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', 'RDM9309', '2024/07/17 17:23:55', '2024/07/17 18:46:49', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:47:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:47:06 - 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', '40', '0', '0', '2024/07/17 18:46:49', '10', '0', '2024/07/17 17:23:55', '0', '0', 'RDM9309', '0', '0', '66981199006RDM9309', '40', '')"}} 2024/07/17 18:47:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:47:13 - 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', 'RDM9309', '40', '2024/07/17 17:23:55', '2024/07/17 18:46:49', '2024/07/17 18:46:49', '113', '7', 'DN', '03752124', '0', '0', '3', '0', '0', 'Y', '9247', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:47:09', '0', '66981199006RDM9309')"}} 2024/07/17 18:47:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:47:15 - 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/17 18:46:49', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12', '50', '360', '12', '0', '66981199006RDM9309')"}} 2024/07/17 18:47:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:48:27 - 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', '669811F5007RAV3835', '606104', '4043925938', 'RAV3835', '2024/07/17 18:03:25', '2024/07/17 18:48:21', '2024/07/17 18:48:40', '40', '0', '311', '271', '24071703', '', '0', '0')"}} 2024/07/17 18:48:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:48:30 - 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 = 'RAV3835' AND EntryDatetime = '2024/07/17 18:03:25')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:48:21', 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 = 'RAV3835' AND EntryDatetime = '2024/07/17 18:03:25'\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', 'RAV3835', '2024/07/17 18:03:25', '2024/07/17 18:48:21', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:48:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:49:10 - 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 = 'RDM9309' AND EntryDatetime = '2024/07/17 17:23:55')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:46:49', ExitDatetime = '2024/07/17 18:49:07', 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 = 'RDM9309' AND EntryDatetime = '2024/07/17 17:23:55'\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', 'RDM9309', '2024/07/17 17:23:55', '2024/07/17 18:46:49', '2024/07/17 18:49:07', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:49:10 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:49: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 = 'NKG1839' AND EntryDatetime = '2024/07/17 18:13:50')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:43:04', ExitDatetime = '2024/07/17 18:49:20', 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 = 'NKG1839' AND EntryDatetime = '2024/07/17 18:13:50'\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', 'NKG1839', '2024/07/17 18:13:50', '2024/07/17 18:43:04', '2024/07/17 18:49:20', '2', '3', '4', '192.168.50.149', '0', '1', '1', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:49:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:49:32 - 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', '4043925938', '0', '40', '0', '1', '2024/07/17 18:48:21', '10', '0', '2024/07/17 18:03:25', '0', '0', 'RAV3835', '0', '0', '669811F5007RAV3835', '40', '')"}} 2024/07/17 18:49:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:49:35 - 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', 'RAV3835', '40', '2024/07/17 18:03:25', '2024/07/17 18:48:21', '2024/07/17 18:48:21', '113', '7', 'DL', '21347669', '0', '0', '3', '0', '70800032', 'Y', '5638', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:48:49', '0', '669811F5007RAV3835')"}} 2024/07/17 18:49:35 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:54:27 - 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 = 'RAV3835' AND EntryDatetime = '2024/07/17 18:03:25')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:48:21', ExitDatetime = '2024/07/17 18:54:26', 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 = 'RAV3835' AND EntryDatetime = '2024/07/17 18:03:25'\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', 'RAV3835', '2024/07/17 18:03:25', '2024/07/17 18:48:21', '2024/07/17 18:54:26', '2', '1', '2', '192.168.50.150', '0', '0', '0', '1', '', '0')\r\nEND\r\n"}} 2024/07/17 18:54:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:55:47 - 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 = 'RAV3597' AND EntryDatetime = '2024/07/17 18:23:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:55:36', 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 = '20002' AND CarPlate = 'RAV3597' AND EntryDatetime = '2024/07/17 18:23:00'\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', 'RAV3597', '2024/07/17 18:23:00', '2024/07/17 18:55:36', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:55:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:55:48 - 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', '40', '0', '0', '2024/07/17 18:55:36', '10', '0', '2024/07/17 18:23:00', '0', '0', 'RAV3597', '0', '0', '669813A8006RAV3597', '40', '')"}} 2024/07/17 18:55:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:55:50 - 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', 'RAV3597', '40', '2024/07/17 18:23:00', '2024/07/17 18:55:36', '2024/07/17 18:55:36', '113', '7', 'DN', '03752125', '0', '0', '3', '0', '0', 'Y', '5549', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:55:50', '0', '669813A8006RAV3597')"}} 2024/07/17 18:55:50 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:55:57 - 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/17 18:55:36', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '12', '51', '359', '12', '0', '669813A8006RAV3597')"}} 2024/07/17 18:55:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:59:22 - 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 = 'RBK1610' AND EntryDatetime = '2024/07/17 18:21:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:59:01', 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 = '20002' AND CarPlate = 'RBK1610' AND EntryDatetime = '2024/07/17 18:21: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', 'RBK1610', '2024/07/17 18:21:28', '2024/07/17 18:59:01', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:59:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:59:23 - 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', '40', '0', '0', '2024/07/17 18:59:01', '10', '0', '2024/07/17 18:21:28', '0', '0', 'RBK1610', '0', '0', '66981475006RBK1610', '40', '')"}} 2024/07/17 18:59:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:59:26 - 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', 'RBK1610', '40', '2024/07/17 18:21:28', '2024/07/17 18:59:01', '2024/07/17 18:59:01', '113', '7', 'DN', '03752126', '0', '0', '3', '0', '0', 'Y', '8545', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/17 18:59:24', '0', '66981475006RBK1610')"}} 2024/07/17 18:59:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:59:32 - 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/17 18:59:01', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12', '51', '363', '12', '0', '66981475006RBK1610')"}} 2024/07/17 18:59:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/17 18:59:37 - 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 = 'RAV3597' AND EntryDatetime = '2024/07/17 18:23:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/17 18:55:36', ExitDatetime = '2024/07/17 18:59:34', 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 = 'RAV3597' AND EntryDatetime = '2024/07/17 18:23:00'\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', 'RAV3597', '2024/07/17 18:23:00', '2024/07/17 18:55:36', '2024/07/17 18:59:34', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/17 18:59:37 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}}