2024/05/30 16:01: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', '20', '0', '0', '2024/05/30 16:00:50', '10', '0', '2024/05/30 14:07:30', '0', '1', 'MNX7910', '0', '0', '6658A2B2006MNX7910', '20', '')"}} 2024/05/30 16:01:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:01:36 - 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', 'MNX7910', '20', '2024/05/30 14:07:30', '2024/05/30 16:00:50', '2024/05/30 16:00:50', '113', '5', 'BP', '17122334', '0', '0', '3', '0', '0', 'Y', '9032', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:01:05', '0', '6658A2B2006MNX7910')"}} 2024/05/30 16:01:36 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:01: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', '20', '0', '0', '2024/05/30 16:01:21', '10', '0', '2024/05/30 14:07:26', '0', '1', 'MNX7906', '0', '0', '6658A2D1006MNX7906', '20', '')"}} 2024/05/30 16:01:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:01:38 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:00:50', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '30', '48', '388', '8', '0', '6658A2B2006MNX7910')"}} 2024/05/30 16:01:38 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:02:08 - 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', 'RAV3228', '2024/05/30 16:02:00', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:02:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:02:09 - 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', 'MNX7906', '20', '2024/05/30 14:07:26', '2024/05/30 16:01:21', '2024/05/30 16:01:21', '113', '5', 'BP', '17122335', '0', '0', '3', '0', '0', 'N', '6431', '3J0002', '/IE7RIN2', '/IE7RIN2', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:01:42', '0', '6658A2D1006MNX7906')"}} 2024/05/30 16:02:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:02:11 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:01:21', '50', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '30', '49', '385', '8', '0', '6658A2D1006MNX7906')"}} 2024/05/30 16:02:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:05: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/05/30 16:05:07', '10', '0', '2024/05/30 13:10:11', '0', '0', 'RCZ8681', '0', '0', '6658A3B3006RCZ8681', '40', '')"}} 2024/05/30 16:05:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:05:54 - 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', 'RCZ8681', '40', '2024/05/30 13:10:11', '2024/05/30 16:05:07', '2024/05/30 16:05:07', '113', '5', 'BP', '17122336', '0', '0', '3', '0', '0', 'N', '7141', '3J0002', '/BYU3R4X', '/BYU3R4X', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:05:38', '0', '6658A3B3006RCZ8681')"}} 2024/05/30 16:05:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:05:56 - 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/05/30 16:05:07', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '31', '48', '384', '8', '0', '6658A3B3006RCZ8681')"}} 2024/05/30 16:05:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:24 - 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 = 'NKG2501' AND EntryDatetime = '2024/05/30 15:45:39')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:06:16', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2501' AND EntryDatetime = '2024/05/30 15:45:39'\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', 'NKG2501', '2024/05/30 15:45:39', '2024/05/30 16:06:16', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:06:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:25 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '0', '0', '20', '0', '0', '2024/05/30 16:06:16', '10', '0', '2024/05/30 15:45:39', '0', '1', 'NKG2501', '0', '0', '6658A3F8007NKG2501', '20', '')"}} 2024/05/30 16:06:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:29 - 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 = 'NKG8052' AND EntryDatetime = '2024/05/30 15:45:50')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:06:10', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8052' AND EntryDatetime = '2024/05/30 15:45:50'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NKG8052', '2024/05/30 15:45:50', '2024/05/30 16:06:10', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:06:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:29 - 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', '1607421841', '0', '20', '0', '1', '2024/05/30 16:06:10', '10', '0', '2024/05/30 15:45:50', '0', '1', 'NKG8052', '0', '0', '6658A3F2008NKG8052', '20', '')"}} 2024/05/30 16:06:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '8', '6658A3F2008NKG8052', '606104', '1607421841', 'NKG8052', '2024/05/30 15:45:50', '2024/05/30 16:06:10', '2024/05/30 16:06:14', '20', '0', '425', '405', '24053003', '', '0', '0')"}} 2024/05/30 16:06:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:32 - 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', 'NKG8052', '20', '2024/05/30 15:45:50', '2024/05/30 16:06:10', '2024/05/30 16:06:10', '113', '5', 'BM', '27290058', '0', '0', '3', '0', '0', 'N', '0036', '1K0001', '', '1607421841', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:06:19', '0', '6658A3F2008NKG8052')"}} 2024/05/30 16:06:32 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:37 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'NKG2501', '20', '2024/05/30 15:45:39', '2024/05/30 16:06:16', '2024/05/30 16:06:16', '113', '5', 'BM', '27289869', '0', '0', '3', '0', '0', 'Y', '4166', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:06:41', '0', '6658A3F8007NKG2501')"}} 2024/05/30 16:06:37 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:06:39 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '7', '0', '20', '2024/05/30 16:06:16', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '35', '41', '282', '42', '0', '6658A3F8007NKG2501')"}} 2024/05/30 16:06:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:07:22 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '6658A43F007NEL1772', '606104', '94098433', 'NEL1772', '2024/05/30 15:50:04', '2024/05/30 16:07:27', '2024/05/30 16:07:33', '20', '0', '492', '472', '24053003', '', '0', '0')"}} 2024/05/30 16:07:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:07:26 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1772' AND EntryDatetime = '2024/05/30 15:50:04')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:07:27', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1772' AND EntryDatetime = '2024/05/30 15:50:04'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL1772', '2024/05/30 15:50:04', '2024/05/30 16:07:27', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:07:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:07:26 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '94098433', '0', '20', '0', '1', '2024/05/30 16:07:27', '10', '0', '2024/05/30 15:50:04', '0', '1', 'NEL1772', '0', '0', '6658A43F007NEL1772', '20', '')"}} 2024/05/30 16:07:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:07:34 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'NEL1772', '20', '2024/05/30 15:50:04', '2024/05/30 16:07:27', '2024/05/30 16:07:27', '113', '5', 'BM', '27289870', '0', '0', '3', '0', '0', 'Y', '9703', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:07:41', '0', '6658A43F007NEL1772')"}} 2024/05/30 16:07:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:09:48 - 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 = 'RAV3228' AND EntryDatetime = '2024/05/30 16:02:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:08:55', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3228' AND EntryDatetime = '2024/05/30 16:02:00'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3228', '2024/05/30 16:02:00', '2024/05/30 16:08:55', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:09:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:09:49 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '0', '0', '40', '0', '0', '2024/05/30 16:08:55', '10', '0', '2024/05/30 16:02:00', '0', '0', 'RAV3228', '0', '1', '6658A497007RAV3228', '40', '')"}} 2024/05/30 16:09:49 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:09:56 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'RAV3228', '40', '2024/05/30 16:02:00', '2024/05/30 16:08:55', '2024/05/30 16:08:55', '113', '5', 'BM', '27289871', '0', '0', '3', '0', '0', 'Y', '4511', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:09:59', '0', '6658A497007RAV3228')"}} 2024/05/30 16:09:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:09:58 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20001', '7', '0', '40', '2024/05/30 16:08:55', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '35', '41', '286', '42', '0', '6658A497007RAV3228')"}} 2024/05/30 16:09:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:10:14 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:09:32', '10', '0', '2024/05/30 12:49:34', '0', '1', 'MZL6113', '0', '0', '6658A4BC006MZL6113', '20', '')"}} 2024/05/30 16:10:14 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:10: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 = 'NEL1772' AND EntryDatetime = '2024/05/30 15:50:04')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:07:27', ExitDatetime = '2024/05/30 16:10:32', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NEL1772' AND EntryDatetime = '2024/05/30 15:50:04'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NEL1772', '2024/05/30 15:50:04', '2024/05/30 16:07:27', '2024/05/30 16:10:32', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:10:26 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:10:45 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20002', '6', '93500846', 'MZL6113', '20', '2024/05/30 12:49:34', '2024/05/30 16:09:32', '2024/05/30 16:09:32', '113', '5', 'BP', '17122337', '0', '0', '3', '0', '0', 'Y', '4597', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:10:28', '0', '6658A4BC006MZL6113')"}} 2024/05/30 16:10:45 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:10:47 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:09:32', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31', '48', '386', '8', '0', '6658A4BC006MZL6113')"}} 2024/05/30 16:10:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:11:17 - 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', 'MFL9688', '20', '2024/05/30 12:49:40', '2024/05/30 16:10:45', '2024/05/30 16:10:45', '113', '5', 'BP', '17122338', '0', '0', '3', '0', '0', 'Y', '1166', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:10:52', '0', '6658A505006MFL9688')"}} 2024/05/30 16:11:17 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:11:19 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:10:45', '10', '0', '2024/05/30 12:49:40', '0', '1', 'MFL9688', '0', '0', '6658A505006MFL9688', '20', '')"}} 2024/05/30 16:11:19 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:11:19 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:10:45', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31', '48', '388', '8', '0', '6658A505006MFL9688')"}} 2024/05/30 16:11:19 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:11:47 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2501' AND EntryDatetime = '2024/05/30 15:45:39')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:06:16', ExitDatetime = '2024/05/30 16:11:55', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG2501' AND EntryDatetime = '2024/05/30 15:45:39'\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', 'NKG2501', '2024/05/30 15:45:39', '2024/05/30 16:06:16', '2024/05/30 16:11:55', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:11:47 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12:06 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8052' AND EntryDatetime = '2024/05/30 15:45:50')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:06:10', ExitDatetime = '2024/05/30 16:12:10', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'NKG8052' AND EntryDatetime = '2024/05/30 15:45:50'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'NKG8052', '2024/05/30 15:45:50', '2024/05/30 16:06:10', '2024/05/30 16:12:10', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:12:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12:22 - 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', 'NKG7865', '20', '2024/05/30 11:23:42', '2024/05/30 16:11:54', '2024/05/30 16:11:54', '113', '5', 'BP', '17122339', '0', '0', '3', '0', '0', 'Y', '7850', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:12:06', '0', '6658A54A006NKG7865')"}} 2024/05/30 16:12:22 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12: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', '20', '0', '0', '2024/05/30 16:11:54', '10', '0', '2024/05/30 11:23:42', '0', '1', 'NKG7865', '0', '0', '6658A54A006NKG7865', '20', '')"}} 2024/05/30 16:12:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12:24 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:11:54', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31', '48', '390', '8', '0', '6658A54A006NKG7865')"}} 2024/05/30 16:12:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12:44 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'BGX3523', '2024/05/30 16:12:38', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:12:44 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12:55 - 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', 'NEL9627', '20', '2024/05/30 11:23:51', '2024/05/30 16:12:36', '2024/05/30 16:12:36', '113', '5', 'BP', '17122340', '0', '0', '3', '0', '0', 'Y', '0528', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:12:50', '0', '6658A574006NEL9627')"}} 2024/05/30 16:12:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:12:56 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:12:36', '10', '0', '2024/05/30 11:23:51', '0', '1', 'NEL9627', '0', '0', '6658A574006NEL9627', '20', '')"}} 2024/05/30 16:12:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:13:27 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3228' AND EntryDatetime = '2024/05/30 16:02:00')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:08:55', ExitDatetime = '2024/05/30 16:13: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 = '20001' AND CarPlate = 'RAV3228' AND EntryDatetime = '2024/05/30 16:02:00'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3228', '2024/05/30 16:02:00', '2024/05/30 16:08:55', '2024/05/30 16:13:24', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:13:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:13:28 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:13:14', '10', '0', '2024/05/30 11:27:23', '0', '1', 'NEL9581', '0', '0', '6658A59A006NEL9581', '20', '')"}} 2024/05/30 16:13:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:13:29 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:12:36', '100', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '32', '47', '387', '8', '0', '6658A574006NEL9627')"}} 2024/05/30 16:13:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:14:00 - 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', 'NEL9581', '20', '2024/05/30 11:27:23', '2024/05/30 16:13:14', '2024/05/30 16:13:14', '113', '5', 'BP', '17122341', '0', '0', '3', '0', '0', 'Y', '2148', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:13:28', '0', '6658A59A006NEL9581')"}} 2024/05/30 16:14:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:14:01 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:13:14', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32', '47', '389', '8', '0', '6658A59A006NEL9581')"}} 2024/05/30 16:14:01 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:16:42 - 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', 'RAV3736', '2024/05/30 16:16:32', '', '', '0', '1', '', '192.168.50.150', '38', '0', '0', '0', '', '0')"}} 2024/05/30 16:16:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:18:54 - 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 = 'MZL6913' AND EntryDatetime = '2024/05/30 15:39:34')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:18:39', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL6913' AND EntryDatetime = '2024/05/30 15: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', 'MZL6913', '2024/05/30 15:39:34', '2024/05/30 16:18:39', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:18:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:18:54 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '15', '899574705', '0', '20', '0', '1', '2024/05/30 16:18:39', '10', '0', '2024/05/30 15:39:34', '0', '1', 'MZL6913', '0', '0', '6658A6DF015MZL6913', '20', '')"}} 2024/05/30 16:18:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:18:55 - 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', '6658A6DF015MZL6913', '606104', '899574705', 'MZL6913', '2024/05/30 15:39:34', '2024/05/30 16:18:39', '2024/05/30 16:18:54', '20', '0', '113', '93', '24053003', '', '0', '0')"}} 2024/05/30 16:18:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:19:07 - 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', 'MZL6913', '20', '2024/05/30 15:39:34', '2024/05/30 16:18:39', '2024/05/30 16:18:39', '113', '5', 'BM', '27288779', '0', '0', '3', '0', '0', 'Y', '5573', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:19:02', '0', '6658A6DF015MZL6913')"}} 2024/05/30 16:19:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:19:55 - 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', '5891TG', '2024/05/30 16:19:24', '', '', '0', '1', '', '192.168.50.150', '38', '0', '0', '0', '', '0')"}} 2024/05/30 16:19:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:05 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL7105' AND EntryDatetime = '2024/05/30 15:40:02')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:19:18', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL7105' AND EntryDatetime = '2024/05/30 15:40:02'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MZL7105', '2024/05/30 15:40:02', '2024/05/30 16:19:18', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:20:05 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:06 - 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', '899574705', '0', '20', '0', '1', '2024/05/30 16:19:18', '10', '0', '2024/05/30 15:40:02', '0', '1', 'MZL7105', '0', '0', '6658A706015MZL7105', '20', '')"}} 2024/05/30 16:20:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:06 - 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', '6658A706015MZL7105', '606104', '899574705', 'MZL7105', '2024/05/30 15:40:02', '2024/05/30 16:19:18', '2024/05/30 16:20:03', '20', '0', '93', '73', '24053003', '', '0', '0')"}} 2024/05/30 16:20:06 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:09 - 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', 'MZL7105', '20', '2024/05/30 15:40:02', '2024/05/30 16:19:18', '2024/05/30 16:19:18', '113', '5', 'BM', '27288780', '0', '0', '3', '0', '0', 'Y', '8712', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:20:06', '0', '6658A706015MZL7105')"}} 2024/05/30 16:20:09 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:20 - 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 = 'AED3350' AND EntryDatetime = '2024/05/30 15:39:40')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:20:22', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED3350' AND EntryDatetime = '2024/05/30 15:39:40'\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', 'AED3350', '2024/05/30 15:39:40', '2024/05/30 16:20:22', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:20:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:25 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '0', '0', '20', '0', '0', '2024/05/30 16:20:22', '10', '0', '2024/05/30 15:39:40', '0', '1', 'AED3350', '0', '0', '6658A746007AED3350', '20', '')"}} 2024/05/30 16:20:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:28 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'AED3350', '20', '2024/05/30 15:39:40', '2024/05/30 16:20:22', '2024/05/30 16:20:22', '113', '5', 'BM', '27289872', '0', '0', '3', '0', '0', 'Y', '9683', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:20:35', '0', '6658A746007AED3350')"}} 2024/05/30 16:20:28 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20: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', '7', '0', '20', '2024/05/30 16:20:22', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '35', '41', '288', '42', '0', '6658A746007AED3350')"}} 2024/05/30 16:20:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:39 - 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', 'RAV3163', '2024/05/30 16:20:28', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:20:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:53 - 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', 'RAV3155', '2024/05/30 16:20:47', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:20:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20: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 = 'MZL6910' AND EntryDatetime = '2024/05/30 15:40:17')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:20:53', ExitDatetime = '', TransStatus = '1', EntryEmqID = '3', ExitEmqID = '', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL6910' AND EntryDatetime = '2024/05/30 15:40:17'\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', 'MZL6910', '2024/05/30 15:40:17', '2024/05/30 16:20:53', '', '1', '3', '', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:20:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:20:58 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '0', '0', '20', '0', '0', '2024/05/30 16:20:53', '10', '0', '2024/05/30 15:40:17', '0', '1', 'MZL6910', '0', '0', '6658A765007MZL6910', '20', '')"}} 2024/05/30 16:20:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:21:00 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20002', 'ZW7850', '2024/05/30 16:20:34', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:21:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:21: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', '7', '89052070', 'MZL6910', '20', '2024/05/30 15:40:17', '2024/05/30 16:20:53', '2024/05/30 16:20:53', '113', '5', 'BM', '27289873', '0', '0', '3', '0', '0', 'Y', '9602', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:21:16', '0', '6658A765007MZL6910')"}} 2024/05/30 16:21:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:21: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', '7', '0', '20', '2024/05/30 16:20:53', '100', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '36', '40', '285', '42', '0', '6658A765007MZL6910')"}} 2024/05/30 16:21:18 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:23:11 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL6913' AND EntryDatetime = '2024/05/30 15:39:34')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:18:39', ExitDatetime = '2024/05/30 16:23:15', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL6913' AND EntryDatetime = '2024/05/30 15: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', 'MZL6913', '2024/05/30 15:39:34', '2024/05/30 16:18:39', '2024/05/30 16:23:15', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:23:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:25:24 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL7105' AND EntryDatetime = '2024/05/30 15:40:02')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:19:18', ExitDatetime = '2024/05/30 16:25:29', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL7105' AND EntryDatetime = '2024/05/30 15:40:02'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'MZL7105', '2024/05/30 15:40:02', '2024/05/30 16:19:18', '2024/05/30 16:25:29', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:25:24 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:25:43 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED3350' AND EntryDatetime = '2024/05/30 15:39:40')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:20:22', ExitDatetime = '2024/05/30 16:25:47', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'AED3350' AND EntryDatetime = '2024/05/30 15:39:40'\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', 'AED3350', '2024/05/30 15:39:40', '2024/05/30 16:20:22', '2024/05/30 16:25:47', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:25:43 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:25:48 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL6910' AND EntryDatetime = '2024/05/30 15:40:17')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:20:53', ExitDatetime = '2024/05/30 16:25:55', TransStatus = '2', EntryEmqID = '3', ExitEmqID = '4', ServerIP = '192.168.50.149', TicketID = '0', CHK_SYN = '0', VehicleType = '1', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'MZL6910' AND EntryDatetime = '2024/05/30 15:40:17'\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', 'MZL6910', '2024/05/30 15:40:17', '2024/05/30 16:20:53', '2024/05/30 16:25:55', '2', '3', '4', '192.168.50.149', '0', '0', '1', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:25:48 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:25:52 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20001', 'RBY3082', '2024/05/30 16:25:45', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:25:52 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:26:54 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:26:23', '10', '0', '2024/05/30 14:08:39', '0', '1', 'NKG2570', '0', '0', '6658A8AF006NKG2570', '20', '')"}} 2024/05/30 16:26:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:27:25 - 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', 'NKG2570', '20', '2024/05/30 14:08:39', '2024/05/30 16:26:23', '2024/05/30 16:26:23', '113', '5', 'BP', '17122342', '0', '0', '3', '0', '0', 'Y', '9308', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:26:54', '0', '6658A8AF006NKG2570')"}} 2024/05/30 16:27:25 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:27:27 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:26:23', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32', '47', '391', '8', '0', '6658A8AF006NKG2570')"}} 2024/05/30 16:27:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:31:19 - 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 = 'BGX3523' AND EntryDatetime = '2024/05/30 16:12:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:30:56', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BGX3523' AND EntryDatetime = '2024/05/30 16:12:38'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'BGX3523', '2024/05/30 16:12:38', '2024/05/30 16:30:56', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:31:19 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:31:20 - 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/05/30 16:30:56', '10', '0', '2024/05/30 16:12:38', '0', '0', 'BGX3523', '0', '0', '6658A9C1008BGX3523', '40', '')"}} 2024/05/30 16:31:20 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:31:27 - 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', 'BGX3523', '40', '2024/05/30 16:12:38', '2024/05/30 16:30:56', '2024/05/30 16:30:56', '113', '5', 'BM', '27290059', '0', '0', '3', '0', '0', 'Y', '9648', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:31:09', '0', '6658A9C1008BGX3523')"}} 2024/05/30 16:31:27 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:31:34 - 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/05/30 16:30:56', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '53', '31', '313', '36', '0', '6658A9C1008BGX3523')"}} 2024/05/30 16:31:34 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:32:21 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BGX3523' AND EntryDatetime = '2024/05/30 16:12:38')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:30:56', ExitDatetime = '2024/05/30 16:32:16', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'BGX3523' AND EntryDatetime = '2024/05/30 16:12:38'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'BGX3523', '2024/05/30 16:12:38', '2024/05/30 16:30:56', '2024/05/30 16:32:16', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:32:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:33:53 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n\t\t\t\t\t\t\t\t\t\t\t('20002', 'MNX7586', '2024/05/30 16:33:19', '', '', '0', '3', '', '192.168.50.150', '0', '0', '1', '0', '', '0')"}} 2024/05/30 16:33:53 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:34:29 - 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 = 'RAV3155' AND EntryDatetime = '2024/05/30 16:20:47')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:34:25', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3155' AND EntryDatetime = '2024/05/30 16:20:47'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3155', '2024/05/30 16:20:47', '2024/05/30 16:34:25', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:34:29 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:34:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '1825447381', '0', '40', '0', '1', '2024/05/30 16:34:25', '10', '0', '2024/05/30 16:20:47', '0', '0', 'RAV3155', '0', '0', '6658AA91007RAV3155', '40', '')"}} 2024/05/30 16:34:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:34:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_CMAS_Deduction (CLOUD_LOC_ID, CLOUD_EQP_ID, OrderID, CmdType, CardID, CarPlateNumber, EntryDateTime, TransDateTime, TransDateTime_CMAS, TransAmount, AutoloadAmt, EV_Before, EV_After, BatchNo, TransXmlString, IsSettle, CHK_SYN) VALUES \r\n\t\t\t\t\t\t\t('20001', '7', '6658AA91007RAV3155', '606104', '1825447381', 'RAV3155', '2024/05/30 16:20:47', '2024/05/30 16:34:25', '2024/05/30 16:34:38', '40', '0', '263', '223', '24053003', '', '0', '0')"}} 2024/05/30 16:34:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:34:37 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '7', '89052070', 'RAV3155', '40', '2024/05/30 16:20:47', '2024/05/30 16:34:25', '2024/05/30 16:34:25', '113', '5', 'BM', '27289874', '0', '0', '3', '0', '0', 'N', '9947', '1K0001', '', '1825447381', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:34:47', '0', '6658AA91007RAV3155')"}} 2024/05/30 16:34:37 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:37:16 - 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 = 'RAV3155' AND EntryDatetime = '2024/05/30 16:20:47')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:34:25', ExitDatetime = '2024/05/30 16:37:12', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3155' AND EntryDatetime = '2024/05/30 16:20:47'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3155', '2024/05/30 16:20:47', '2024/05/30 16:34:25', '2024/05/30 16:37:12', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:37:16 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:38:12 - 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', 'RAG3878', '2024/05/30 16:38:05', '', '', '0', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')"}} 2024/05/30 16:38:12 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:41:55 - 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 = 'RBY3082' AND EntryDatetime = '2024/05/30 16:25:45')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:41:21', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3082' AND EntryDatetime = '2024/05/30 16:25:45'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RBY3082', '2024/05/30 16:25:45', '2024/05/30 16:41:21', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:41:55 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:41:56 - 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/05/30 16:41:21', '10', '0', '2024/05/30 16:25:45', '0', '0', 'RBY3082', '0', '0', '6658AC31008RBY3082', '40', '')"}} 2024/05/30 16:41:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:42:04 - 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', 'RBY3082', '40', '2024/05/30 16:25:45', '2024/05/30 16:41:21', '2024/05/30 16:41:21', '113', '5', 'BM', '27290060', '0', '0', '3', '0', '0', 'Y', '3287', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:41:47', '0', '6658AC31008RBY3082')"}} 2024/05/30 16:42:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:42:11 - 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/05/30 16:41:21', '50', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '53', '32', '312', '36', '0', '6658AC31008RBY3082')"}} 2024/05/30 16:42:11 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:44:04 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3082' AND EntryDatetime = '2024/05/30 16:25:45')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:41:21', ExitDatetime = '2024/05/30 16:43:59', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RBY3082' AND EntryDatetime = '2024/05/30 16:25:45'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RBY3082', '2024/05/30 16:25:45', '2024/05/30 16:41:21', '2024/05/30 16:43:59', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:44:04 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:47:50 - 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/05/30 16:47:22', '10', '0', '2024/05/30 15:54:33', '0', '0', 'BSJ3717', '0', '0', '6658AD9A006BSJ3717', '40', '')"}} 2024/05/30 16:47:50 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:48:21 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20002', '6', '93500846', 'BSJ3717', '40', '2024/05/30 15:54:33', '2024/05/30 16:47:22', '2024/05/30 16:47:22', '113', '5', 'BP', '17122343', '0', '0', '3', '0', '0', 'Y', '4286', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:47:50', '0', '6658AD9A006BSJ3717')"}} 2024/05/30 16:48:21 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:48:23 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '40', '2024/05/30 16:47:22', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32', '47', '395', '8', '0', '6658AD9A006BSJ3717')"}} 2024/05/30 16:48:23 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:49:42 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"\r\n\r\nIF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3163' AND EntryDatetime = '2024/05/30 16:20:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:49: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 = '20001' AND CarPlate = 'RAV3163' AND EntryDatetime = '2024/05/30 16:20:28'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3163', '2024/05/30 16:20:28', '2024/05/30 16:49:07', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:49:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:49: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', '8', '0', '0', '40', '0', '0', '2024/05/30 16:49:07', '10', '0', '2024/05/30 16:20:28', '0', '0', 'RAV3163', '0', '0', '6658AE03008RAV3163', '40', '')"}} 2024/05/30 16:49:42 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:49:54 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'RAV3163', '40', '2024/05/30 16:20:28', '2024/05/30 16:49:07', '2024/05/30 16:49:07', '113', '5', 'BM', '27290061', '0', '0', '3', '0', '0', 'Y', '0089', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:49:39', '0', '6658AE03008RAV3163')"}} 2024/05/30 16:49:54 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:50:01 - 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/05/30 16:49:07', '40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '53', '32', '316', '36', '0', '6658AE03008RAV3163')"}} 2024/05/30 16:50:01 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52: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 = 'RAV3163' AND EntryDatetime = '2024/05/30 16:20:28')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:49:07', ExitDatetime = '2024/05/30 16:51:54', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAV3163' AND EntryDatetime = '2024/05/30 16:20:28'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAV3163', '2024/05/30 16:20:28', '2024/05/30 16:49:07', '2024/05/30 16:51:54', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:52:00 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52:07 - 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', 'MZL6961', '20', '2024/05/30 15:35:45', '2024/05/30 16:51:30', '2024/05/30 16:51:30', '113', '5', 'BP', '17122344', '0', '0', '3', '0', '0', 'Y', '4723', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:51:49', '0', '6658AE92006MZL6961')"}} 2024/05/30 16:52:07 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52:08 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:51:30', '10', '0', '2024/05/30 15:35:45', '0', '1', 'MZL6961', '0', '0', '6658AE92006MZL6961', '20', '')"}} 2024/05/30 16:52:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52:08 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:51:30', '100', '0', '0', '0', '0', '1', '3', '0', '0', '0', '0', '33', '46', '392', '8', '0', '6658AE92006MZL6961')"}} 2024/05/30 16:52:08 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52:39 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20002', '6', '93500846', 'MZL6959', '20', '2024/05/30 15:35:56', '2024/05/30 16:52:11', '2024/05/30 16:52:11', '113', '5', 'BP', '17122345', '0', '0', '3', '0', '0', 'Y', '6724', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:52:25', '0', '6658AEBB006MZL6959')"}} 2024/05/30 16:52:39 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52:41 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:52:11', '10', '0', '2024/05/30 15:35:56', '0', '1', 'MZL6959', '0', '0', '6658AEBB006MZL6959', '20', '')"}} 2024/05/30 16:52:41 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:52:41 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:52:11', '50', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '33', '47', '389', '8', '0', '6658AEBB006MZL6959')"}} 2024/05/30 16:52:41 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:53:12 - 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', 'NEL3201', '20', '2024/05/30 15:36:02', '2024/05/30 16:52:48', '2024/05/30 16:52:48', '113', '5', 'BP', '17122346', '0', '0', '3', '0', '0', 'Y', '3043', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:53:02', '0', '6658AEE0006NEL3201')"}} 2024/05/30 16:53:12 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:53:13 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:52:48', '10', '0', '2024/05/30 15:36:02', '0', '1', 'NEL3201', '0', '0', '6658AEE0006NEL3201', '20', '')"}} 2024/05/30 16:53:13 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:53:14 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:52:48', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33', '47', '391', '8', '0', '6658AEE0006NEL3201')"}} 2024/05/30 16:53:14 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:54:56 - 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 = 'RAG3878' AND EntryDatetime = '2024/05/30 16:38:05')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:53:57', ExitDatetime = '', TransStatus = '1', EntryEmqID = '1', ExitEmqID = '', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAG3878' AND EntryDatetime = '2024/05/30 16:38:05'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAG3878', '2024/05/30 16:38:05', '2024/05/30 16:53:57', '', '1', '1', '', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:54:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:54:56 - 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/05/30 16:53:57', '10', '0', '2024/05/30 16:38:05', '0', '0', 'RAG3878', '0', '0', '6658AF25008RAG3878', '40', '')"}} 2024/05/30 16:54:56 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:55:51 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20001', '8', '89052070', 'RAG3878', '40', '2024/05/30 16:38:05', '2024/05/30 16:53:57', '2024/05/30 16:53:57', '113', '5', 'BM', '27290062', '0', '0', '3', '0', '0', 'Y', '1969', ' ', '', '', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:55:33', '0', '6658AF25008RAG3878')"}} 2024/05/30 16:55:51 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:55:58 - 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/05/30 16:53:57', '100', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '54', '31', '315', '36', '0', '6658AF25008RAG3878')"}} 2024/05/30 16:55:58 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:56:57 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO EI_C0401_CLOUD (CLOUD_LOC_ID, CLOUD_EQP_ID, Identifier, CARD_PHYSICAL_ID, TXN_AMT, ENTRY_DATETIME, TXN_TIMESTAMP, InvoiceDate, InvoiceYear, InvoiceMonth, InvoiceEnglish, InvoiceNum, FreeTaxSalesAmount, ZeroTaxSalesAmount, TaxType, TaxAmount, BuyerIdentifier, PrintMark, RandomNumber, CarrierType, CarrierId1, CarrierId2, NPOBAN, BatchNumber, IPAddress, AgentNum, CHK_SYN, InvalidYN, UpdateTime, UpdateStatus, OrderID) VALUES ('20002', '6', '93500846', '600PQS', '20', '2024/05/30 15:02:05', '2024/05/30 16:56:28', '2024/05/30 16:56:28', '113', '5', 'BP', '17122347', '0', '0', '3', '0', '0', 'N', '2673', '3J0002', '/02BUFP2', '/02BUFP2', '', '', '127.0.0.1', '', '0', '0', '2024/05/30 16:56:58', '0', '6658AFBC006600PQS')"}} 2024/05/30 16:56:57 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:56:59 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_Payment (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransSeqNumber, TransAmount, Subtype, PaymentType, TransDateTime, TransType, TicketID, EntryDateTime, ExcessTime, VehicleType, CarPlateNumber, IsCheckOut, CHK_SYN, OrderID, TransAmount_Org, FeeMemo) VALUES \r\n\t\t\t\t\t\t\t('20002', '6', '0', '0', '20', '0', '0', '2024/05/30 16:56:28', '10', '0', '2024/05/30 15:02:05', '0', '1', '600PQS', '0', '0', '6658AFBC006600PQS', '20', '')"}} 2024/05/30 16:56:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:56:59 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"20002","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"INSERT INTO FA_PaymentDetail_Cash (CLOUD_LOC_ID, CLOUD_EQP_ID, CardID, TransAmount, TransDateTime, PutInMoney, ChangeAmount, ReturnCountBill_500, ReturnCountBill_200, ReturnCountBill_100, ReturnCountCoin_50, ReturnCountCoin_10, ReturnCountCoin_5, RemainCountBill_1000, RemainCountBill_500, RemainCountBill_200, RemainCountBill_100, RemainCountCoin_50, RemainCountCoin_10, RemainCountCoin_5, CHK_SYN, OrderID) VALUES \r\n\t\t\t\t\t\t\t\t('20002', '6', '0', '20', '2024/05/30 16:56:28', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33', '47', '393', '8', '0', '6658AFBC006600PQS')"}} 2024/05/30 16:56:59 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}} 2024/05/30 16:58:30 - Loc20_UploadData Receive:{"CLOUD_LOC_ID":"127.0.0.1","CLOUD_EQP_ID":"0","apiToken":"VYHyatfGUlFWHgnAVMEc40nL1rn7s+l190vtgMjCx3c=","paramData":{"Tsql":"IF EXISTS (SELECT 1 FROM NF_CloudLprStatus WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAG3878' AND EntryDatetime = '2024/05/30 16:38:05')\r\nBEGIN\r\nUPDATE NF_CloudLprStatus SET TransDatetime = '2024/05/30 16:53:57', ExitDatetime = '2024/05/30 16:58:26', TransStatus = '2', EntryEmqID = '1', ExitEmqID = '2', ServerIP = '192.168.50.150', TicketID = '0', CHK_SYN = '0', VehicleType = '0', CheckStatus = '0', eTagID = '', MemberType = '0' WHERE CLOUD_LOC_ID = '20001' AND CarPlate = 'RAG3878' AND EntryDatetime = '2024/05/30 16:38:05'\r\nEND\r\nELSE\r\nBEGIN\r\nINSERT INTO NF_CloudLprStatus (CLOUD_LOC_ID, CarPlate, EntryDatetime, TransDatetime, ExitDatetime, TransStatus, EntryEmqID, ExitEmqID, ServerIP, TicketID, CHK_SYN, VehicleType, CheckStatus, eTagID, MemberType) VALUES \r\n('20001', 'RAG3878', '2024/05/30 16:38:05', '2024/05/30 16:53:57', '2024/05/30 16:58:26', '2', '1', '2', '192.168.50.150', '0', '0', '0', '0', '', '0')\r\nEND\r\n"}} 2024/05/30 16:58:30 - Loc20_UploadData Response:{"errCode":"000000","errMsg":"正常","responseData":{}}