2024/07/13 18:00:03 - 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 = 'RAV3332' AND EntryDatetime = '2024/07/13 17:50:09')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 17:59:33', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3332' AND EntryDatetime = '2024/07/13 17:50: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', 'RAV3332', '2024/07/13 17:50:09', '2024/07/13 17:59:33', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:00:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00:03 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '15', '2049399281', '0', '40', '0', '1', '2024/07/13 17:59:33', '10', '0', '2024/07/13 17:50:09', '0', '0', 'RAV3332', '0', '1', '6692C086015RAV3332', '40', '')"}} 2024/07/13 18:00:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00:04 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '15', '6692C086015RAV3332', '606104', '2049399281', 'RAV3332', '2024/07/13 17:50:09', '2024/07/13 17:59:33', '2024/07/13 18:00:00', '40', '0', '344', '304', '24071303', '', '0', '0')"}} 2024/07/13 18:00:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00:11 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '15', '89052070', 'RAV3332', '40', '2024/07/13 17:50:09', '2024/07/13 17:59:33', '2024/07/13 17:59:33', '113', '7', 'DL', '21342033', '0', '0', '3', '0', '0', 'Y', '0627', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:00:06', '0', '6692C086015RAV3332')"}} 2024/07/13 18:00:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00: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 = 'RAV3550' AND EntryDatetime = '2024/07/13 17:46:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:00:24', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3550' AND EntryDatetime = '2024/07/13 17:46: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', 'RAV3550', '2024/07/13 17:46:32', '2024/07/13 18:00:24', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:00:41 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00: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', '15', '2049399281', '0', '40', '0', '1', '2024/07/13 18:00:24', '10', '0', '2024/07/13 17:46:32', '0', '0', 'RAV3550', '0', '0', '6692C0B8015RAV3550', '40', '')"}} 2024/07/13 18:00:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00:42 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '15', '6692C0B8015RAV3550', '606104', '2049399281', 'RAV3550', '2024/07/13 17:46:32', '2024/07/13 18:00:24', '2024/07/13 18:00:40', '40', '0', '304', '264', '24071303', '', '0', '0')"}} 2024/07/13 18:00:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:00: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', '15', '89052070', 'RAV3550', '40', '2024/07/13 17:46:32', '2024/07/13 18:00:24', '2024/07/13 18:00:24', '113', '7', 'DL', '21342034', '0', '0', '3', '0', '0', 'Y', '6914', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:00:44', '0', '6692C0B8015RAV3550')"}} 2024/07/13 18:00:49 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:01: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', '10', '0', '2024/07/13 18:01:40', '10', '0', '2024/07/13 16:17:29', '1128', '0', 'RBY3666', '0', '0', '6692C104006RBY3666', '40', '')"}} 2024/07/13 18:01:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:01:48 - 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', '5216TG', '2024/07/13 18:01:40', '', '', '0', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')"}} 2024/07/13 18:01:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:01: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', 'RBY3666', '40', '2024/07/13 16:17:29', '2024/07/13 18:01:40', '2024/07/13 18:01:40', '113', '7', 'DN', '03751778', '0', '0', '3', '0', '0', 'Y', '0122', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:01:50', '0', '6692C104006RBY3666')"}} 2024/07/13 18:01:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:01: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', '40', '2024/07/13 18:01:40', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120', '38', '698', '56', '0', '6692C104006RBY3666')"}} 2024/07/13 18:01:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:03: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 = 'RAV3332' AND EntryDatetime = '2024/07/13 17:50:09')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 17:59:33', ExitDatetime = '2024/07/13 18:02:58', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3332' AND EntryDatetime = '2024/07/13 17:50: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', 'RAV3332', '2024/07/13 17:50:09', '2024/07/13 17:59:33', '2024/07/13 18:02:58', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:03:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:03: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 = 'RAV3550' AND EntryDatetime = '2024/07/13 17:46:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:00:24', ExitDatetime = '2024/07/13 18:03:05', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3550' AND EntryDatetime = '2024/07/13 17:46: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', 'RAV3550', '2024/07/13 17:46:32', '2024/07/13 18:00:24', '2024/07/13 18:03:05', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:03:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:03:11 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RBY3666' AND EntryDatetime = '2024/07/13 16:17:29')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:01:40', ExitDatetime = '2024/07/13 18:03: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 = 'RBY3666' AND EntryDatetime = '2024/07/13 16:17: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('20002', 'RBY3666', '2024/07/13 16:17:29', '2024/07/13 18:01:40', '2024/07/13 18:03:07', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:03:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:03:21 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20002', 'RDM0726', '2024/07/13 18:03:18', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/13 18:03:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:12:09 - 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', 'RDS9220', '2024/07/13 18:12:06', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/13 18:12:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:18:17 - 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', 'NKG8698', '2024/07/13 18:18:26', '', '', '0', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')"}} 2024/07/13 18:18:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:18: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('20001', 'NKG8919', '2024/07/13 18:18:32', '', '', '0', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')"}} 2024/07/13 18:18:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:19:23 - 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 = '5651UD' AND EntryDatetime = '2024/07/13 16:50:03')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:19:07', 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 = '5651UD' AND EntryDatetime = '2024/07/13 16:50: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('20002', '5651UD', '2024/07/13 16:50:03', '2024/07/13 18:19:07', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:19:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:19:24 - 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/13 18:19:07', '10', '0', '2024/07/13 16:50:03', '0', '0', '5651UD', '0', '0', '6692C51B0065651UD', '40', '')"}} 2024/07/13 18:19:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:19:37 - 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', '5651UD', '40', '2024/07/13 16:50:03', '2024/07/13 18:19:07', '2024/07/13 18:19:07', '113', '7', 'DN', '03751779', '0', '0', '3', '0', '0', 'N', '6796', '3J0002', '/2L2HCK8', '/2L2HCK8', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:19:38', '0', '6692C51B0065651UD')"}} 2024/07/13 18:19:37 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:19:39 - 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/13 18:19:07', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120', '38', '702', '56', '0', '6692C51B0065651UD')"}} 2024/07/13 18:19:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:21:59 - 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 = '5651UD' AND EntryDatetime = '2024/07/13 16:50:03')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:19:07', ExitDatetime = '2024/07/13 18:21:55', 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 = '5651UD' AND EntryDatetime = '2024/07/13 16:50: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('20002', '5651UD', '2024/07/13 16:50:03', '2024/07/13 18:19:07', '2024/07/13 18:21:55', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:21:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23: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 = 'RBY3061' AND EntryDatetime = '2024/07/13 17:39:44')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:22:28', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3061' AND EntryDatetime = '2024/07/13 17:39:44'\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', 'RBY3061', '2024/07/13 17:39:44', '2024/07/13 18:22:28', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:23:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:00 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '0', '0', '40', '0', '0', '2024/07/13 18:22:28', '10', '0', '2024/07/13 17:39:44', '0', '0', 'RBY3061', '0', '0', '6692C5E4008RBY3061', '40', '')"}} 2024/07/13 18:23:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:08 - 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', 'RBY3061', '40', '2024/07/13 17:39:44', '2024/07/13 18:22:28', '2024/07/13 18:22:28', '113', '7', 'DL', '21344449', '0', '0', '3', '0', '0', 'Y', '3599', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:22:47', '0', '6692C5E4008RBY3061')"}} 2024/07/13 18:23:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:20 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '8', '0', '40', '2024/07/13 18:22:28', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '1', '40', '100', '20', '0', '6692C5E4008RBY3061')"}} 2024/07/13 18:23:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23: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 = 'FCS6963' AND EntryDatetime = '2024/07/13 17:39:34')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:23:08', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'FCS6963' AND EntryDatetime = '2024/07/13 17:39:34'\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', 'FCS6963', '2024/07/13 17:39:34', '2024/07/13 18:23:08', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:23:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23: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', '0', '0', '40', '0', '0', '2024/07/13 18:23:08', '10', '0', '2024/07/13 17:39:34', '0', '0', 'FCS6963', '0', '1', '6692C60C008FCS6963', '40', '')"}} 2024/07/13 18:23:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:41 - 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', 'FCS6963', '40', '2024/07/13 17:39:34', '2024/07/13 18:23:08', '2024/07/13 18:23:08', '113', '7', 'DL', '21344450', '0', '0', '3', '0', '0', 'Y', '9625', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:23:19', '0', '6692C60C008FCS6963')"}} 2024/07/13 18:23:41 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:49 - 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/13 18:23:08', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '1', '41', '99', '20', '0', '6692C60C008FCS6963')"}} 2024/07/13 18:23:49 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:51 - 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 = 'RBH5332' AND EntryDatetime = '2024/07/13 15:14:10')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:23:17', 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 = 'RBH5332' AND EntryDatetime = '2024/07/13 15:14:10'\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', 'RBH5332', '2024/07/13 15:14:10', '2024/07/13 18:23:17', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:23:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:23:52 - 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/13 18:23:17', '10', '0', '2024/07/13 15:14:10', '0', '0', 'RBH5332', '0', '0', '6692C615006RBH5332', '60', '')"}} 2024/07/13 18:23:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:24: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', 'RBH5332', '60', '2024/07/13 15:14:10', '2024/07/13 18:23:17', '2024/07/13 18:23:17', '113', '7', 'DN', '03751780', '0', '0', '3', '0', '0', 'N', '1634', '3J0002', '/TLH0ZPQ', '/TLH0ZPQ', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:24:11', '0', '6692C615006RBH5332')"}} 2024/07/13 18:24:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:24: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', '60', '2024/07/13 18:23:17', '110', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '121', '38', '698', '56', '0', '6692C615006RBH5332')"}} 2024/07/13 18:24:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:24:17 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'FCS6963' AND EntryDatetime = '2024/07/13 17:39:34')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:23:08', ExitDatetime = '2024/07/13 18:24:14', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'FCS6963' AND EntryDatetime = '2024/07/13 17:39:34'\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', 'FCS6963', '2024/07/13 17:39:34', '2024/07/13 18:23:08', '2024/07/13 18:24:14', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:24:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:24:26 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3061' AND EntryDatetime = '2024/07/13 17:39:44')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:22:28', ExitDatetime = '2024/07/13 18:24:22', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3061' AND EntryDatetime = '2024/07/13 17:39:44'\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', 'RBY3061', '2024/07/13 17:39:44', '2024/07/13 18:22:28', '2024/07/13 18:24:22', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:24:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:26:34 - 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 = 'RBH5332' AND EntryDatetime = '2024/07/13 15:14:10')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:23:17', ExitDatetime = '2024/07/13 18:26:31', 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 = 'RBH5332' AND EntryDatetime = '2024/07/13 15:14:10'\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', 'RBH5332', '2024/07/13 15:14:10', '2024/07/13 18:23:17', '2024/07/13 18:26:31', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:26:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:28:15 - 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', 'RAV3909', '2024/07/13 18:28:07', '', '', '0', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')"}} 2024/07/13 18:28:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:30:15 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8919' AND EntryDatetime = '2024/07/13 18:18:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:29:48', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8919' AND EntryDatetime = '2024/07/13 18:18: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', 'NKG8919', '2024/07/13 18:18:32', '2024/07/13 18:29:48', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:30:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:30:15 - 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/13 18:29:48', '10', '0', '2024/07/13 18:18:32', '0', '1', 'NKG8919', '0', '0', '6692C79C008NKG8919', '20', '')"}} 2024/07/13 18:30:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:30:23 - 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', 'NKG8919', '20', '2024/07/13 18:18:32', '2024/07/13 18:29:48', '2024/07/13 18:29:48', '113', '7', 'DL', '21344451', '0', '0', '3', '0', '0', 'Y', '3657', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:30:02', '0', '6692C79C008NKG8919')"}} 2024/07/13 18:30:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:30: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/07/13 18:29:48', '100', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '2', '40', '96', '20', '0', '6692C79C008NKG8919')"}} 2024/07/13 18:30:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:30:58 - 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 = 'NKG8698' AND EntryDatetime = '2024/07/13 18:18:26')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:30:34', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8698' AND EntryDatetime = '2024/07/13 18:18: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('20001', 'NKG8698', '2024/07/13 18:18:26', '2024/07/13 18:30:34', '', '1', '3', '', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:30:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:30: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', '8', '0', '0', '20', '0', '0', '2024/07/13 18:30:34', '10', '0', '2024/07/13 18:18:26', '0', '1', 'NKG8698', '0', '0', '6692C7CA008NKG8698', '20', '')"}} 2024/07/13 18:30:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:31:06 - 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', 'NKG8698', '20', '2024/07/13 18:18:26', '2024/07/13 18:30:34', '2024/07/13 18:30:34', '113', '7', 'DL', '21344452', '0', '0', '3', '0', '0', 'Y', '0533', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:30:42', '0', '6692C7CA008NKG8698')"}} 2024/07/13 18:31:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:31:08 - 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/13 18:30:34', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '40', '98', '20', '1', '6692C7CA008NKG8698')"}} 2024/07/13 18:31:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:32:57 - 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 = 'NKG8919' AND EntryDatetime = '2024/07/13 18:18:32')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:29:48', ExitDatetime = '2024/07/13 18:33:05', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8919' AND EntryDatetime = '2024/07/13 18:18: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', 'NKG8919', '2024/07/13 18:18:32', '2024/07/13 18:29:48', '2024/07/13 18:33:05', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:32:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:33:12 - 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 = 'NKG8698' AND EntryDatetime = '2024/07/13 18:18:26')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:30:34', ExitDatetime = '2024/07/13 18:33:20', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '1', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8698' AND EntryDatetime = '2024/07/13 18:18: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('20001', 'NKG8698', '2024/07/13 18:18:26', '2024/07/13 18:30:34', '2024/07/13 18:33:20', '2', '3', '4', '192.168.50.149', '0', '1', '1', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:33:12 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:33: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 = '6593XZ' AND EntryDatetime = '2024/07/13 17:02:22')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:32: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 = '6593XZ' AND EntryDatetime = '2024/07/13 17:02:22'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', '6593XZ', '2024/07/13 17:02:22', '2024/07/13 18:32:39', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:33:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:33: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/13 18:32:39', '10', '0', '2024/07/13 17:02:22', '0', '0', '6593XZ', '0', '0', '6692C8470066593XZ', '40', '')"}} 2024/07/13 18:33:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:33:33 - 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', '6593XZ', '40', '2024/07/13 17:02:22', '2024/07/13 18:32:39', '2024/07/13 18:32:39', '113', '7', 'DN', '03751781', '0', '0', '3', '0', '0', 'Y', '5596', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:33:35', '0', '6692C8470066593XZ')"}} 2024/07/13 18:33:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:33:39 - 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/13 18:32:39', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '121', '38', '701', '58', '0', '6692C8470066593XZ')"}} 2024/07/13 18:33:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:35:32 - 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 = 'RDM0726' AND EntryDatetime = '2024/07/13 18:03:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:35:26', 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 = 'RDM0726' AND EntryDatetime = '2024/07/13 18:03: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', 'RDM0726', '2024/07/13 18:03:18', '2024/07/13 18:35:26', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:35:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:35: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', '40', '0', '0', '2024/07/13 18:35:26', '10', '0', '2024/07/13 18:03:18', '0', '0', 'RDM0726', '0', '0', '6692C8EE006RDM0726', '40', '')"}} 2024/07/13 18:35:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:35:44 - 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', 'RDM0726', '40', '2024/07/13 18:03:18', '2024/07/13 18:35:26', '2024/07/13 18:35:26', '113', '7', 'DN', '03751782', '0', '0', '3', '0', '0', 'N', '2409', '3J0002', '/PLY45U2', '/PLY45U2', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:35:46', '0', '6692C8EE006RDM0726')"}} 2024/07/13 18:35:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:35: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', '40', '2024/07/13 18:35:26', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '121', '38', '705', '58', '0', '6692C8EE006RDM0726')"}} 2024/07/13 18:35:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:36:54 - 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 = '6593XZ' AND EntryDatetime = '2024/07/13 17:02:22')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:32:39', ExitDatetime = '2024/07/13 18:36:48', 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 = '6593XZ' AND EntryDatetime = '2024/07/13 17:02:22'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', '6593XZ', '2024/07/13 17:02:22', '2024/07/13 18:32:39', '2024/07/13 18:36:48', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:36:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:37: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 = 'RDM0726' AND EntryDatetime = '2024/07/13 18:03:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:35:26', ExitDatetime = '2024/07/13 18:37:24', 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 = 'RDM0726' AND EntryDatetime = '2024/07/13 18:03: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', 'RDM0726', '2024/07/13 18:03:18', '2024/07/13 18:35:26', '2024/07/13 18:37:24', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:37:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:41:24 - 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/13 15:25:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:41:16', 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/13 15:25: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/13 15:25:28', '2024/07/13 18:41:16', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:41:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:41:25 - 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/13 18:41:16', '10', '0', '2024/07/13 15:25:28', '0', '0', 'RAV3367', '0', '0', '6692CA4C006RAV3367', '60', '')"}} 2024/07/13 18:41:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:41:32 - 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/13 15:25:28', '2024/07/13 18:41:16', '2024/07/13 18:41:16', '113', '7', 'DN', '03751783', '0', '0', '3', '0', '0', 'Y', '5425', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:41:32', '0', '6692CA4C006RAV3367')"}} 2024/07/13 18:41:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:41:39 - 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/13 18:41:16', '100', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0', '122', '38', '701', '58', '0', '6692CA4C006RAV3367')"}} 2024/07/13 18:41:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42: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 = 'BTV6363' AND EntryDatetime = '2024/07/13 17:09:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:41: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 = '20002' AND CarPlate = 'BTV6363' AND EntryDatetime = '2024/07/13 17:09: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('20002', 'BTV6363', '2024/07/13 17:09:38', '2024/07/13 18:41:51', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:42:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42: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/13 18:41:51', '10', '0', '2024/07/13 17:09:38', '0', '0', 'BTV6363', '0', '0', '6692CA6F006BTV6363', '40', '')"}} 2024/07/13 18:42:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42:18 - 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', 'BTV6363', '40', '2024/07/13 17:09:38', '2024/07/13 18:41:51', '2024/07/13 18:41:51', '113', '7', 'DN', '03751784', '0', '0', '3', '0', '0', 'Y', '8703', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:42:18', '0', '6692CA6F006BTV6363')"}} 2024/07/13 18:42:18 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42:25 - 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/13 18:41:51', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '122', '39', '700', '58', '0', '6692CA6F006BTV6363')"}} 2024/07/13 18:42:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42: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 = 'AUJ1888' AND EntryDatetime = '2024/07/13 17:09:20')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:42:35', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'AUJ1888' AND EntryDatetime = '2024/07/13 17:09:20'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'AUJ1888', '2024/07/13 17:09:20', '2024/07/13 18:42:35', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:42:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42: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/13 18:42:35', '10', '0', '2024/07/13 17:09:20', '0', '0', 'AUJ1888', '0', '0', '6692CA9B006AUJ1888', '40', '')"}} 2024/07/13 18:42:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42: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', 'AUJ1888', '40', '2024/07/13 17:09:20', '2024/07/13 18:42:35', '2024/07/13 18:42:35', '113', '7', 'DN', '03751785', '0', '0', '3', '0', '0', 'Y', '2381', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:42:43', '0', '6692CA9B006AUJ1888')"}} 2024/07/13 18:42:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:42:49 - 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/13 18:42:35', '100', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '123', '39', '694', '58', '0', '6692CA9B006AUJ1888')"}} 2024/07/13 18:42:49 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:43:15 - 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 = 'BCK8856' AND EntryDatetime = '2024/07/13 16:17:46')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:43:11', 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 = 'BCK8856' AND EntryDatetime = '2024/07/13 16:17:46'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'BCK8856', '2024/07/13 16:17:46', '2024/07/13 18:43:11', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:43:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:43:16 - 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/13 18:43:11', '10', '0', '2024/07/13 16:17:46', '0', '0', 'BCK8856', '0', '0', '6692CABF006BCK8856', '40', '')"}} 2024/07/13 18:43:16 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:43:59 - 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', 'BCK8856', '40', '2024/07/13 16:17:46', '2024/07/13 18:43:11', '2024/07/13 18:43:11', '113', '7', 'DN', '03751786', '0', '0', '3', '0', '0', 'Y', '3210', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:43:57', '0', '6692CABF006BCK8856')"}} 2024/07/13 18:43:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:44:03 - 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/13 18:43:11', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '123', '39', '698', '58', '0', '6692CABF006BCK8856')"}} 2024/07/13 18:44:03 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:44:07 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20002' AND CarPlate = 'RAV3367' AND EntryDatetime = '2024/07/13 15:25:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:41:16', ExitDatetime = '2024/07/13 18:44: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 = '20002' AND CarPlate = 'RAV3367' AND EntryDatetime = '2024/07/13 15:25: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/13 15:25:28', '2024/07/13 18:41:16', '2024/07/13 18:44:05', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:44:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:44: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 = '6305EJ' AND EntryDatetime = '2024/07/13 16:36:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:44:37', 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 = '6305EJ' AND EntryDatetime = '2024/07/13 16:36: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', '6305EJ', '2024/07/13 16:36:00', '2024/07/13 18:44:37', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:44:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:44: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/13 18:44:37', '10', '0', '2024/07/13 16:36:00', '0', '0', '6305EJ', '0', '0', '6692CB150066305EJ', '40', '')"}} 2024/07/13 18:44:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:44: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', '6305EJ', '40', '2024/07/13 16:36:00', '2024/07/13 18:44:37', '2024/07/13 18:44:37', '113', '7', 'DN', '03751787', '0', '0', '3', '0', '0', 'N', '0078', '3J0002', '/VW9F5UY', '/VW9F5UY', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:45:00', '0', '6692CB150066305EJ')"}} 2024/07/13 18:44:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:45:07 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '40', '2024/07/13 18:44:37', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '124', '38', '697', '58', '0', '6692CB150066305EJ')"}} 2024/07/13 18:45:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:46: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 = '6305EJ' AND EntryDatetime = '2024/07/13 16:36:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:44:37', ExitDatetime = '2024/07/13 18:46:53', 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 = '6305EJ' AND EntryDatetime = '2024/07/13 16:36: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', '6305EJ', '2024/07/13 16:36:00', '2024/07/13 18:44:37', '2024/07/13 18:46:53', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:46:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:47: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 = 'AUJ1888' AND EntryDatetime = '2024/07/13 17:09:20')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:42:35', ExitDatetime = '2024/07/13 18:47:08', 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 = 'AUJ1888' AND EntryDatetime = '2024/07/13 17:09:20'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'AUJ1888', '2024/07/13 17:09:20', '2024/07/13 18:42:35', '2024/07/13 18:47:08', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:47:10 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:47:19 - 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 = 'BTV6363' AND EntryDatetime = '2024/07/13 17:09:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:41:51', ExitDatetime = '2024/07/13 18:47:17', 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 = 'BTV6363' AND EntryDatetime = '2024/07/13 17:09: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('20002', 'BTV6363', '2024/07/13 17:09:38', '2024/07/13 18:41:51', '2024/07/13 18:47:17', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:47:19 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:47: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 = 'BCK8856' AND EntryDatetime = '2024/07/13 16:17:46')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:43:11', ExitDatetime = '2024/07/13 18:47: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 = 'BCK8856' AND EntryDatetime = '2024/07/13 16:17:46'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20002', 'BCK8856', '2024/07/13 16:17:46', '2024/07/13 18:43:11', '2024/07/13 18:47:27', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:47:33 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:48:44 - 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', '6692CBE0014RAV3909', '606104', '503998261', 'RAV3909', '2024/07/13 18:28:07', '2024/07/13 18:47:59', '2024/07/13 18:48:43', '0', '500', '0', '500', '24071304', '', '0', '0')"}} 2024/07/13 18:48:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49: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 = 'RAV3909' AND EntryDatetime = '2024/07/13 18:28:07')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:48:38', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3909' AND EntryDatetime = '2024/07/13 18:28: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', 'RAV3909', '2024/07/13 18:28:07', '2024/07/13 18:48:38', '', '1', '1', '', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:49:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49:08 - 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/13 18:48:38', '10', '0', '2024/07/13 18:28:07', '0', '0', 'RAV3909', '0', '0', '6692CC06008RAV3909', '40', '')"}} 2024/07/13 18:49:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49:15 - 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', 'RAV3909', '40', '2024/07/13 18:28:07', '2024/07/13 18:48:38', '2024/07/13 18:48:38', '113', '7', 'DL', '21344453', '0', '0', '3', '0', '0', 'Y', '7813', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:48:53', '0', '6692CC06008RAV3909')"}} 2024/07/13 18:49:15 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49:18 - 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/13 18:48:38', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '2', '41', '97', '20', '0', '6692CC06008RAV3909')"}} 2024/07/13 18:49:18 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49: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 = 'BHL9082' AND EntryDatetime = '2024/07/13 16:48:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:49:00', 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 = 'BHL9082' AND EntryDatetime = '2024/07/13 16:48: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', 'BHL9082', '2024/07/13 16:48:18', '2024/07/13 18:49:00', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:49:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49: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/13 18:49:00', '10', '0', '2024/07/13 16:48:18', '0', '0', 'BHL9082', '0', '0', '6692CC1C006BHL9082', '40', '')"}} 2024/07/13 18:49:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49:34 - 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', 'BHL9082', '40', '2024/07/13 16:48:18', '2024/07/13 18:49:00', '2024/07/13 18:49:00', '113', '7', 'DN', '03751788', '0', '0', '3', '0', '0', 'Y', '6944', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/07/13 18:49:36', '0', '6692CC1C006BHL9082')"}} 2024/07/13 18:49:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:49: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', '40', '2024/07/13 18:49:00', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '125', '37', '696', '58', '0', '6692CC1C006BHL9082')"}} 2024/07/13 18:49:46 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:50:48 - 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 = 'BHL9082' AND EntryDatetime = '2024/07/13 16:48:18')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:49:00', ExitDatetime = '2024/07/13 18:50:46', 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 = 'BHL9082' AND EntryDatetime = '2024/07/13 16:48: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', 'BHL9082', '2024/07/13 16:48:18', '2024/07/13 18:49:00', '2024/07/13 18:50:46', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:50:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:51:12 - 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 = 'RAV3909' AND EntryDatetime = '2024/07/13 18:28:07')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/07/13 18:48:38', ExitDatetime = '2024/07/13 18:51:11', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '1', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3909' AND EntryDatetime = '2024/07/13 18:28: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', 'RAV3909', '2024/07/13 18:28:07', '2024/07/13 18:48:38', '2024/07/13 18:51:11', '2', '1', '2', '192.168.50.150', '0', '1', '0', '0', '', '0')\r\nEND\r\n"}} 2024/07/13 18:51:12 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/07/13 18:55:51 - 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', 'RDM1903', '2024/07/13 18:55:46', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/07/13 18:55:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}}