2024/06/19 18:01:08 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2063' AND EntryDatetime = '2024/06/19 16:50:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 17:57:01', ExitDatetime = '2024/06/19 18:01:18', 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 = 'NKG2063' AND EntryDatetime = '2024/06/19 16: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', 'NKG2063', '2024/06/19 16:50:53', '2024/06/19 17:57:01', '2024/06/19 18:01:18', '2', '3', '4', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/19 18:01:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:01:33 - 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 = 'NEL2023' AND EntryDatetime = '2024/06/19 17:24:07')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 17:59:37', ExitDatetime = '2024/06/19 18:01:33', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'NEL2023' AND EntryDatetime = '2024/06/19 17:24: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('20002', 'NEL2023', '2024/06/19 17:24:07', '2024/06/19 17:59:37', '2024/06/19 18:01:33', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:01:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:03:12 - 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 = 'AED6505' AND EntryDatetime = '2024/06/19 17:47:15')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:03:03', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED6505' AND EntryDatetime = '2024/06/19 17:47:15'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'AED6505', '2024/06/19 17:47:15', '2024/06/19 18:03:03', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:03:12 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:03:13 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/06/19 18:03:03', '10', '0', '2024/06/19 17:47:15', '0', '1', 'AED6505', '0', '0', '66731D57008AED6505', '20', '')"}} 2024/06/19 18:03:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:03:20 - 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', 'AED6505', '20', '2024/06/19 17:47:15', '2024/06/19 18:03:03', '2024/06/19 18:03:03', '113', '5', 'BM', '27301141', '0', '0', '3', '0', '0', 'Y', '0883', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:03:19', '0', '66731D57008AED6505')"}} 2024/06/19 18:03:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:03:23 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/06/19 18:03:03', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '63', '371', '36', '0', '66731D57008AED6505')"}} 2024/06/19 18:03:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:06: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', 'RAV3878', '2024/06/19 18:06:28', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:06:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:08:43 - 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', '8', '66731E9F008RCG3297', '606104', '2102983281', 'RCG3297', '2024/06/19 17:56:54', '2024/06/19 18:08:31', '2024/06/19 18:08:48', '40', '500', '24', '484', '24061903', '', '0', '0')"}} 2024/06/19 18:08:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:08:47 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RCG3297' AND EntryDatetime = '2024/06/19 17:56:54')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:08:31', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RCG3297' AND EntryDatetime = '2024/06/19 17:56:54'\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', 'RCG3297', '2024/06/19 17:56:54', '2024/06/19 18:08:31', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:08:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:08:47 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '2102983281', '0', '40', '0', '1', '2024/06/19 18:08:31', '10', '0', '2024/06/19 17:56:54', '0', '0', 'RCG3297', '0', '0', '66731E9F008RCG3297', '40', '')"}} 2024/06/19 18:08:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:09:05 - 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', 'RCG3297', '40', '2024/06/19 17:56:54', '2024/06/19 18:08:31', '2024/06/19 18:08:31', '113', '5', 'BM', '27301142', '0', '0', '3', '0', '29225838', 'Y', '7344', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:09:03', '0', '66731E9F008RCG3297')"}} 2024/06/19 18:09:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:09:25 - 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', 'BNV5006', '2024/06/19 18:09:19', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:09:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:09:44 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'E65456', '2024/06/19 18:09:37', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:09:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:11:00 - 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', 'RAP8372', '2024/06/19 18:10:56', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:11:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:11: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 = '20001' AND CarPlate = 'AED6505' AND EntryDatetime = '2024/06/19 17:47:15')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:03:03', ExitDatetime = '2024/06/19 18:11:18', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED6505' AND EntryDatetime = '2024/06/19 17:47:15'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'AED6505', '2024/06/19 17:47:15', '2024/06/19 18:03:03', '2024/06/19 18:11:18', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:11:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:12: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 = 'RCG3297' AND EntryDatetime = '2024/06/19 17:56:54')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:08:31', ExitDatetime = '2024/06/19 18:12:51', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RCG3297' AND EntryDatetime = '2024/06/19 17:56:54'\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', 'RCG3297', '2024/06/19 17:56:54', '2024/06/19 18:08:31', '2024/06/19 18:12:51', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:12:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:13: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 = 'RAV3975' AND EntryDatetime = '2024/06/19 17:50:50')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:12:46', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3975' AND EntryDatetime = '2024/06/19 17:50: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', 'RAV3975', '2024/06/19 17:50:50', '2024/06/19 18:12:46', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:13:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:13: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', '40', '0', '0', '2024/06/19 18:12:46', '10', '0', '2024/06/19 17:50:50', '0', '0', 'RAV3975', '0', '0', '66731F9E008RAV3975', '40', '')"}} 2024/06/19 18:13:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:13:22 - 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', 'RAV3975', '40', '2024/06/19 17:50:50', '2024/06/19 18:12:46', '2024/06/19 18:12:46', '113', '5', 'BM', '27301143', '0', '0', '3', '0', '0', 'Y', '7479', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:13:22', '0', '66731F9E008RAV3975')"}} 2024/06/19 18:13:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:13:25 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '40', '2024/06/19 18:12:46', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '63', '375', '36', '0', '66731F9E008RAV3975')"}} 2024/06/19 18:13:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:14: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', 'RAV3978', '2024/06/19 18:14:53', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:14:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:15:04 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3975' AND EntryDatetime = '2024/06/19 17:50:50')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:12:46', ExitDatetime = '2024/06/19 18:15:05', 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 = '20001' AND CarPlate = 'RAV3975' AND EntryDatetime = '2024/06/19 17:50: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', 'RAV3975', '2024/06/19 17:50:50', '2024/06/19 18:12:46', '2024/06/19 18:15:05', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:15:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:21: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 = 'E65456' AND EntryDatetime = '2024/06/19 18:09:37')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:21:04', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'E65456' AND EntryDatetime = '2024/06/19 18:09:37'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'E65456', '2024/06/19 18:09:37', '2024/06/19 18:21:04', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:21:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:21: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', '8', '0', '0', '40', '0', '0', '2024/06/19 18:21:04', '10', '0', '2024/06/19 18:09:37', '0', '0', 'E65456', '0', '1', '66732190008E65456', '40', '')"}} 2024/06/19 18:21:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:21:44 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'E65456', '40', '2024/06/19 18:09:37', '2024/06/19 18:21:04', '2024/06/19 18:21:04', '113', '5', 'BM', '27301144', '0', '0', '3', '0', '0', 'Y', '8795', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:21:45', '0', '66732190008E65456')"}} 2024/06/19 18:21:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:21:46 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '40', '2024/06/19 18:21:04', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '63', '379', '36', '0', '66732190008E65456')"}} 2024/06/19 18:21:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:23:07 - 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 = 'RAV3978' AND EntryDatetime = '2024/06/19 18:14:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:22:51', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3978' AND EntryDatetime = '2024/06/19 18:14: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', 'RAV3978', '2024/06/19 18:14:53', '2024/06/19 18:22:51', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:23:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:23:07 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '40', '0', '0', '2024/06/19 18:22:51', '10', '0', '2024/06/19 18:14:53', '0', '0', 'RAV3978', '0', '0', '667321FB008RAV3978', '40', '')"}} 2024/06/19 18:23:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:23: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', '8', '89052070', 'RAV3978', '40', '2024/06/19 18:14:53', '2024/06/19 18:22:51', '2024/06/19 18:22:51', '113', '5', 'BM', '27301145', '0', '0', '3', '0', '0', 'Y', '3628', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:23:13', '0', '667321FB008RAV3978')"}} 2024/06/19 18:23:10 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:23:17 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '40', '2024/06/19 18:22:51', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '63', '383', '36', '0', '667321FB008RAV3978')"}} 2024/06/19 18:23:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:23:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3978' AND EntryDatetime = '2024/06/19 18:14:53')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:22:51', ExitDatetime = '2024/06/19 18:23:43', 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 = '20001' AND CarPlate = 'RAV3978' AND EntryDatetime = '2024/06/19 18:14: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', 'RAV3978', '2024/06/19 18:14:53', '2024/06/19 18:22:51', '2024/06/19 18:23:43', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:23:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:23:55 - 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 = 'E65456' AND EntryDatetime = '2024/06/19 18:09:37')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:21:04', ExitDatetime = '2024/06/19 18:23:56', 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 = '20001' AND CarPlate = 'E65456' AND EntryDatetime = '2024/06/19 18:09:37'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'E65456', '2024/06/19 18:09:37', '2024/06/19 18:21:04', '2024/06/19 18:23:56', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:23:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:27:31 - 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 = 'MNX1616' AND EntryDatetime = '2024/06/19 12:56:55')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:26:49', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MNX1616' AND EntryDatetime = '2024/06/19 12:56: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', 'MNX1616', '2024/06/19 12:56:55', '2024/06/19 18:26:49', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:27:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:27:32 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/06/19 18:26:49', '10', '0', '2024/06/19 12:56:55', '0', '1', 'MNX1616', '0', '0', '667322E9006MNX1616', '20', '')"}} 2024/06/19 18:27:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:27:39 - 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', 'MNX1616', '20', '2024/06/19 12:56:55', '2024/06/19 18:26:49', '2024/06/19 18:26:49', '113', '5', 'BP', '17123704', '0', '0', '3', '0', '0', 'Y', '8548', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:27:39', '0', '667322E9006MNX1616')"}} 2024/06/19 18:27:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:27:46 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/06/19 18:26:49', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '54', '417', '10', '0', '667322E9006MNX1616')"}} 2024/06/19 18:27:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:29:30 - 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 = 'MZL5371' AND EntryDatetime = '2024/06/19 12:57:12')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:29:24', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL5371' AND EntryDatetime = '2024/06/19 12:57: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('20002', 'MZL5371', '2024/06/19 12:57:12', '2024/06/19 18:29:24', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:29:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:29:31 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/06/19 18:29:24', '10', '0', '2024/06/19 12:57:12', '0', '1', 'MZL5371', '0', '0', '66732384006MZL5371', '20', '')"}} 2024/06/19 18:29:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:29:43 - 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', 'MZL5371', '20', '2024/06/19 12:57:12', '2024/06/19 18:29:24', '2024/06/19 18:29:24', '113', '5', 'BP', '17123705', '0', '0', '3', '0', '0', 'N', '4476', '3J0002', '/G992Z36', '/G992Z36', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:29:44', '0', '66732384006MZL5371')"}} 2024/06/19 18:29:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:29:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/06/19 18:29:24', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '54', '419', '10', '0', '66732384006MZL5371')"}} 2024/06/19 18:29:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30: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 = 'MZL3359' AND EntryDatetime = '2024/06/19 12:59:01')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:29:59', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL3359' AND EntryDatetime = '2024/06/19 12:59: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', 'MZL3359', '2024/06/19 12:59:01', '2024/06/19 18:29:59', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:30:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30: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', '20', '0', '0', '2024/06/19 18:29:59', '10', '0', '2024/06/19 12:59:01', '0', '1', 'MZL3359', '0', '0', '667323A7006MZL3359', '20', '')"}} 2024/06/19 18:30:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30: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', 'MZL3359', '20', '2024/06/19 12:59:01', '2024/06/19 18:29:59', '2024/06/19 18:29:59', '113', '5', 'BP', '17123706', '0', '0', '3', '0', '0', 'Y', '7947', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:30:09', '0', '667323A7006MZL3359')"}} 2024/06/19 18:30:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30:13 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/06/19 18:29:59', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '54', '421', '10', '0', '667323A7006MZL3359')"}} 2024/06/19 18:30:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30:35 - 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 = 'MZL6735' AND EntryDatetime = '2024/06/19 12:57:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:30:34', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL6735' AND EntryDatetime = '2024/06/19 12:57:18'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'MZL6735', '2024/06/19 12:57:18', '2024/06/19 18:30:34', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:30:35 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30:36 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/06/19 18:30:34', '10', '0', '2024/06/19 12:57:18', '0', '1', 'MZL6735', '0', '0', '667323CA006MZL6735', '20', '')"}} 2024/06/19 18:30:36 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30:43 - 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', 'MZL6735', '20', '2024/06/19 12:57:18', '2024/06/19 18:30:34', '2024/06/19 18:30:34', '113', '5', 'BP', '17123707', '0', '0', '3', '0', '0', 'Y', '7919', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:30:43', '0', '667323CA006MZL6735')"}} 2024/06/19 18:30:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:30:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/06/19 18:30:34', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '54', '423', '10', '0', '667323CA006MZL6735')"}} 2024/06/19 18:30:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31: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 = 'MZL3362' AND EntryDatetime = '2024/06/19 12:57:23')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:31:03', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL3362' AND EntryDatetime = '2024/06/19 12:57:23'\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', 'MZL3362', '2024/06/19 12:57:23', '2024/06/19 18:31:03', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:31:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31: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', '20', '0', '0', '2024/06/19 18:31:03', '10', '0', '2024/06/19 12:57:23', '0', '1', 'MZL3362', '0', '0', '667323E7006MZL3362', '20', '')"}} 2024/06/19 18:31:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31: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', 'MZL3362', '20', '2024/06/19 12:57:23', '2024/06/19 18:31:03', '2024/06/19 18:31:03', '113', '5', 'BP', '17123708', '0', '0', '3', '0', '0', 'Y', '9930', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:31:09', '0', '667323E7006MZL3362')"}} 2024/06/19 18:31:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31:17 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MNX1616' AND EntryDatetime = '2024/06/19 12:56:55')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:26:49', ExitDatetime = '2024/06/19 18:31:17', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MNX1616' AND EntryDatetime = '2024/06/19 12:56: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', 'MNX1616', '2024/06/19 12:56:55', '2024/06/19 18:26:49', '2024/06/19 18:31:17', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:31:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31:18 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/06/19 18:31:03', '50', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '17', '55', '420', '10', '0', '667323E7006MZL3362')"}} 2024/06/19 18:31:18 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31:44 - 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 = ' MZL3638' AND EntryDatetime = '2024/06/19 12:57:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:31:38', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = ' MZL3638' AND EntryDatetime = '2024/06/19 12:57: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', ' MZL3638', '2024/06/19 12:57:00', '2024/06/19 18:31:38', '', '1', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:31:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/06/19 18:31:38', '10', '0', '2024/06/19 12:57:00', '0', '1', ' MZL3638', '0', '0', '6673240A006 MZL3638', '20', '')"}} 2024/06/19 18:31:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31:52 - 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', ' MZL3638', '20', '2024/06/19 12:57:00', '2024/06/19 18:31:38', '2024/06/19 18:31:38', '113', '5', 'BP', '17123709', '0', '0', '3', '0', '0', 'Y', '9467', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:31:51', '0', '6673240A006 MZL3638')"}} 2024/06/19 18:31:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:31:54 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/06/19 18:31:38', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '55', '422', '10', '0', '6673240A006 MZL3638')"}} 2024/06/19 18:31:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:32:31 - 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 = 'MZL6735' AND EntryDatetime = '2024/06/19 12:57:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:30:34', ExitDatetime = '2024/06/19 18:32:29', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL6735' AND EntryDatetime = '2024/06/19 12:57:18'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'MZL6735', '2024/06/19 12:57:18', '2024/06/19 18:30:34', '2024/06/19 18:32:29', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:32:31 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:32:58 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL5371' AND EntryDatetime = '2024/06/19 12:57:12')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:29:24', ExitDatetime = '2024/06/19 18:32:55', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL5371' AND EntryDatetime = '2024/06/19 12:57: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('20002', 'MZL5371', '2024/06/19 12:57:12', '2024/06/19 18:29:24', '2024/06/19 18:32:55', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:32:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:33: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 = 'MZL3362' AND EntryDatetime = '2024/06/19 12:57:23')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:31:03', ExitDatetime = '2024/06/19 18:33:36', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL3362' AND EntryDatetime = '2024/06/19 12:57:23'\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', 'MZL3362', '2024/06/19 12:57:23', '2024/06/19 18:31:03', '2024/06/19 18:33:36', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:33:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:34:52 - 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', 'RAV3259', '2024/06/19 18:34:48', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:34:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:35:01 - 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 = 'MZL3359' AND EntryDatetime = '2024/06/19 12:59:01')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:29:59', ExitDatetime = '2024/06/19 18:34:58', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'MZL3359' AND EntryDatetime = '2024/06/19 12:59: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', 'MZL3359', '2024/06/19 12:59:01', '2024/06/19 18:29:59', '2024/06/19 18:34:58', '2', '3', '4', '192.168.50.150', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:35:01 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:38:32 - 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 = 'BNV5006' AND EntryDatetime = '2024/06/19 18:09:19')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:38:33', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BNV5006' AND EntryDatetime = '2024/06/19 18:09: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', 'BNV5006', '2024/06/19 18:09:19', '2024/06/19 18:38:33', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:38:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:38: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', '0', '0', '40', '0', '0', '2024/06/19 18:38:33', '10', '0', '2024/06/19 18:09:19', '0', '0', 'BNV5006', '0', '1', '667325A9007BNV5006', '40', '')"}} 2024/06/19 18:38:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:38: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', 'BNV5006', '40', '2024/06/19 18:09:19', '2024/06/19 18:38:33', '2024/06/19 18:38:33', '113', '5', 'BM', '27301316', '0', '0', '3', '0', '0', 'Y', '9188', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:38:45', '0', '667325A9007BNV5006')"}} 2024/06/19 18:38:35 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:38: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', '7', '0', '40', '2024/06/19 18:38:33', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '41', '24', '220', '36', '0', '667325A9007BNV5006')"}} 2024/06/19 18:38:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:40:08 - 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', '4060', '-1', '2024/06/19 18:37:04', '2024/06/18 18:14:15', '4941', '183', '0')"}} 2024/06/19 18:40:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:41:00 - 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 = 'BNV5006' AND EntryDatetime = '2024/06/19 18:09:19')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:38:33', ExitDatetime = '2024/06/19 18:41:00', 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 = '20001' AND CarPlate = 'BNV5006' AND EntryDatetime = '2024/06/19 18:09: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', 'BNV5006', '2024/06/19 18:09:19', '2024/06/19 18:38:33', '2024/06/19 18:41:00', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:41:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:42:36 - 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', '4580', '-1', '2024/06/19 18:41:15', '2024/06/18 18:22:23', '4941', '181', '0')"}} 2024/06/19 18:42:36 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:43:56 - 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', 'RAG2571', '2024/06/19 18:43:52', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/06/19 18:43:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:46:00 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '506PQS' AND EntryDatetime = '2024/06/19 14:34:09')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:45:59', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '506PQS' AND EntryDatetime = '2024/06/19 14:34:09'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', '506PQS', '2024/06/19 14:34:09', '2024/06/19 18:45:59', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/19 18:46:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:46:25 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '20', '0', '0', '2024/06/19 18:45:59', '10', '0', '2024/06/19 14:34:09', '0', '1', '506PQS', '0', '0', '66732767008506PQS', '20', '')"}} 2024/06/19 18:46:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:46:28 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', '506PQS', '20', '2024/06/19 14:34:09', '2024/06/19 18:45:59', '2024/06/19 18:45:59', '113', '5', 'BM', '27301146', '0', '0', '3', '0', '0', 'Y', '2123', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:46:10', '0', '66732767008506PQS')"}} 2024/06/19 18:46:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:46:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '20', '2024/06/19 18:45:59', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '102', '20', '0', '66732767008506PQS')"}} 2024/06/19 18:46:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:47:17 - 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 = '598PQN' AND EntryDatetime = '2024/06/19 14:34:03')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:47:00', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '1', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '598PQN' AND EntryDatetime = '2024/06/19 14:34: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('20001', '598PQN', '2024/06/19 14:34:03', '2024/06/19 18:47:00', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/19 18:47:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:47:51 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '0', '0', '20', '0', '0', '2024/06/19 18:47:00', '10', '0', '2024/06/19 14:34:03', '0', '1', '598PQN', '0', '0', '667327A4007598PQN', '20', '')"}} 2024/06/19 18:47:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:47: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/06/19 18:47:00', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '102', '20', '0', '667327A4007598PQN')"}} 2024/06/19 18:47:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:47: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', '598PQN', '20', '2024/06/19 14:34:03', '2024/06/19 18:47:00', '2024/06/19 18:47:00', '113', '5', 'BM', '27301317', '0', '0', '3', '0', '0', 'Y', '1880', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:47:31', '0', '667327A4007598PQN')"}} 2024/06/19 18:47:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:48:33 - 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 = 'RAP8372' AND EntryDatetime = '2024/06/19 18:10:56')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:48:27', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAP8372' AND EntryDatetime = '2024/06/19 18:10:56'\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', 'RAP8372', '2024/06/19 18:10:56', '2024/06/19 18:48:27', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:48:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:48:34 - 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', '1648990757', '0', '40', '0', '1', '2024/06/19 18:48:27', '10', '0', '2024/06/19 18:10:56', '0', '0', 'RAP8372', '0', '0', '667327FB008RAP8372', '40', '')"}} 2024/06/19 18:48:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:48:34 - 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', '8', '667327FB008RAP8372', '606104', '1648990757', 'RAP8372', '2024/06/19 18:10:56', '2024/06/19 18:48:27', '2024/06/19 18:48:37', '40', '0', '360', '320', '24061904', '', '0', '0')"}} 2024/06/19 18:48:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:48:46 - 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', 'RAP8372', '40', '2024/06/19 18:10:56', '2024/06/19 18:48:27', '2024/06/19 18:48:27', '113', '5', 'BM', '27301147', '0', '0', '3', '0', '0', 'Y', '9790', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:48:44', '0', '667327FB008RAP8372')"}} 2024/06/19 18:48:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:50:09 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '506PQS' AND EntryDatetime = '2024/06/19 14:34:09')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:45:59', ExitDatetime = '2024/06/19 18:50:19', 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 = '506PQS' AND EntryDatetime = '2024/06/19 14:34:09'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', '506PQS', '2024/06/19 14:34:09', '2024/06/19 18:45:59', '2024/06/19 18:50:19', '2', '3', '4', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/19 18:50:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:50:23 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = '598PQN' AND EntryDatetime = '2024/06/19 14:34:03')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:47:00', ExitDatetime = '2024/06/19 18:50:32', 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 = '598PQN' AND EntryDatetime = '2024/06/19 14:34: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('20001', '598PQN', '2024/06/19 14:34:03', '2024/06/19 18:47:00', '2024/06/19 18:50:32', '2', '3', '4', '192.168.50.149', '0', '0', '1', '1', '', '0')\r\nEND\r\n"}} 2024/06/19 18:50:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:51: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 = '20001' AND CarPlate = 'RAP8372' AND EntryDatetime = '2024/06/19 18:10:56')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:48:27', ExitDatetime = '2024/06/19 18:51:04', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAP8372' AND EntryDatetime = '2024/06/19 18:10:56'\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', 'RAP8372', '2024/06/19 18:10:56', '2024/06/19 18:48:27', '2024/06/19 18:51:04', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:51:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:55:47 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3259' AND EntryDatetime = '2024/06/19 18:34:48')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:55:34', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3259' AND EntryDatetime = '2024/06/19 18:34:48'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3259', '2024/06/19 18:34:48', '2024/06/19 18:55:34', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:55:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:55:47 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '40', '0', '0', '2024/06/19 18:55:34', '10', '0', '2024/06/19 18:34:48', '0', '0', 'RAV3259', '0', '0', '667329A6008RAV3259', '40', '')"}} 2024/06/19 18:55:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:56:00 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'RAV3259', '40', '2024/06/19 18:34:48', '2024/06/19 18:55:34', '2024/06/19 18:55:34', '113', '5', 'BM', '27301148', '0', '0', '3', '0', '0', 'Y', '7115', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:55:58', '0', '667329A6008RAV3259')"}} 2024/06/19 18:56:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:56: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', '40', '2024/06/19 18:55:34', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '106', '20', '0', '667329A6008RAV3259')"}} 2024/06/19 18:56:02 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:57:46 - 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 = 'RAV3878' AND EntryDatetime = '2024/06/19 18:06:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:57: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 = '20001' AND CarPlate = 'RAV3878' AND EntryDatetime = '2024/06/19 18:06: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('20001', 'RAV3878', '2024/06/19 18:06:28', '2024/06/19 18:57:39', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:57:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:57:46 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '40', '0', '0', '2024/06/19 18:57:39', '10', '0', '2024/06/19 18:06:28', '0', '0', 'RAV3878', '0', '0', '66732A23008RAV3878', '40', '')"}} 2024/06/19 18:57:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:57:54 - 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', 'RAV3878', '40', '2024/06/19 18:06:28', '2024/06/19 18:57:39', '2024/06/19 18:57:39', '113', '5', 'BM', '27301149', '0', '0', '3', '0', '0', 'Y', '3652', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/06/19 18:57:55', '0', '66732A23008RAV3878')"}} 2024/06/19 18:57:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:57:56 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '40', '2024/06/19 18:57:39', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40', '110', '20', '0', '66732A23008RAV3878')"}} 2024/06/19 18:57:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:58:43 - 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 = 'RAV3259' AND EntryDatetime = '2024/06/19 18:34:48')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:55:34', ExitDatetime = '2024/06/19 18:58:43', 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 = '20001' AND CarPlate = 'RAV3259' AND EntryDatetime = '2024/06/19 18:34:48'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3259', '2024/06/19 18:34:48', '2024/06/19 18:55:34', '2024/06/19 18:58:43', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:58:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/06/19 18:59:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3878' AND EntryDatetime = '2024/06/19 18:06:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/06/19 18:57:39', ExitDatetime = '2024/06/19 18:59:45', 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 = '20001' AND CarPlate = 'RAV3878' AND EntryDatetime = '2024/06/19 18:06: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('20001', 'RAV3878', '2024/06/19 18:06:28', '2024/06/19 18:57:39', '2024/06/19 18:59:45', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/06/19 18:59:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}}