DELETE FROM t_er_invoicedatapre WHERE FID = 1294966791646394368;
INSERT INTO t_er_invoicedatapre(FID,FINVOICEJSON,FCREATETIME,FMODIFIERID,FENABLE,FINVOICEJSON_TAG,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER,FNAME) VALUES (1294966791646394368,'{"errcode":"0000","description":"操作成功","data":[{"passengerName":"","stationGetOn":"泰安","salerName":"","downloadUrl":"https://api.kingdee.com/kdrive/user/file/public?client_id\\u003d200242\\u0026file_id\\u003d205071460\\u0026scode\\u003dQWNOb1Q5SE50R1ph...',{ts'2021-11-22  00:00:00'},1160063587109202944,'1','{"errcode":"0000","description":"操作成功","data":[{"passengerName":"","stationGetOn":"泰安","salerName":"","downloadUrl":"https://api.kingdee.com/kdrive/user/file/public?client_id\\u003d200242\\u0026file_id\\u003d205071460\\u0026scode\\u003dQWNOb1Q5SE50R1phRjd3V2grSEs5\\u0026sign\\u003d7949f0fbe1a27831779a5532b38fe3001eca3621","personFlag":"true","authenticateFlag":1,"billCreateTime":"2019-08-15 15:56:29","departurePosition":{"area":"岱岳区","province":"山东省","city":"泰安市"},"trainNum":"G1844","checkStatus":3,"trainTime":"13:56","trip":"泰安 - 淄博","stationGetOff":"淄博","salerTaxNo":"","invoiceType":"9","invoiceNo":"F083537","pixel":"419,262","buyerAddressPhone":"","salerAccount":"","originalGraphUrl":"https://api.kingdee.com/kdrive/user/file/public?client_id\\u003d200242\\u0026file_id\\u003d205071460\\u0026scode\\u003dQWNOb1Q5SE50R1phRjd3V2grSEs5\\u0026sign\\u003d7949f0fbe1a27831779a5532b38fe3001eca3621","amount":"59.17","buyerTaxNo":"","validateMessage":"发票已在报销中","buyerName":"","invoiceDate":"2019-06-15","invoiceCode":"20190615","serialNo":"82c2e40c8cf8451a864fbbefd750707c0","errorLevel":"0","checkFlag":1,"totalAmount":"64.50","taxRate":"0.090000","seatGrade":"二等座","salerAddressPhone":"","checkTime":"","buyerAccount":"","authenticateTime":"","rotationAngle":"0","snapshotUrl":"https://api.kingdee.com/kdrive/user/file/thumbnail?client_id\\u003d200242\\u0026file_id\\u003d205071460\\u0026quality\\u003d100\\u0026scode\\u003daHdlLXZBazdULWQ1L3oxYjVHOE5U\\u0026sign\\u003daf60eb91001940927d8b716a1b06c16df488cf5c\\u0026width\\u003d800","isRevise":"1","destinationPosition":{"area":"张店区","province":"山东省","city":"淄博市"},"printingSequenceNo":"F083537","taxAmount":"5.33","totalAmountCn":"","region":"[0,0,419,262]","expenseStatus":"30"},{"passengerName":"鲁文涛","stationGetOn":"深圳北","salerName":"","downloadUrl":"https://api.kingdee.com/kdrive/user/file/public?client_id\\u003d200242\\u0026file_id\\u003d205071461\\u0026scode\\u003dbStTejJRSDZQNTZlR3hOanpkdGtZ\\u0026sign\\u003d0cc6c04712871901366e26262b9db696b97f672b","personFlag":"true","authenticateFlag":1,"billCreateTime":"2018-12-04 16:31:00","departurePosition":{"area":"龙华区","province":"广东省","city":"深圳市"},"trainNum":"D2284","checkStatus":3,"trainTime":"08:47","trip":"深圳北 - 潮汕","stationGetOff":"潮汕","salerTaxNo":"","invoiceType":"9","invoiceNo":"G010204","pixel":"1080,1440","buyerAddressPhone":"","salerAccount":"","originalGraphUrl":"https://api.kingdee.com/kdrive/user/file/public?client_id\\u003d200242\\u0026file_id\\u003d205071461\\u0026scode\\u003dbStTejJRSDZQNTZlR3hOanpkdGtZ\\u0026sign\\u003d0cc6c04712871901366e26262b9db696b97f672b","amount":"107.00","buyerTaxNo":"","validateMessage":"发票已在报销中","buyerName":"","invoiceDate":"2017-05-20","invoiceCode":"20170520","serialNo":"d44881a501d941c2a64c8b07153b630a3","errorLevel":"0","checkFlag":1,"totalAmount":"107.00","taxRate":"0","seatGrade":"二等座","salerAddressPhone":"","checkTime":"","buyerAccount":"","authenticateTime":"","rotationAngle":"0","snapshotUrl":"https://api.kingdee.com/kdrive/user/file/thumbnail?client_id\\u003d200242\\u0026file_id\\u003d205071461\\u0026quality\\u003d100\\u0026scode\\u003dYmZIWERhWjJEaXNPRmpUazVnZnVX\\u0026sign\\u003dc39c6d6d60231d0577574df682364e2461298ed1\\u0026width\\u003d800","isRevise":"1","destinationPosition":{"area":"潮安县","province":"广东省","city":"潮州市"},"printingSequenceNo":"G010204","taxAmount":"0","totalAmountCn":"","region":"[11,72,1344,1017]","expenseStatus":"30"}]}',{ts'2021-11-22  00:00:00'},1294966791646394368,'A',1160063587109202944,' ','两张火车票');


DELETE FROM t_er_invoicedatapre_l WHERE FPKID = '2110ZV4IQ9WX';
INSERT INTO t_er_invoicedatapre_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1294966791646394368,'2110ZV4IQ9WX','zh_CN','两张火车票');
DELETE FROM t_er_invoicedatapre_l WHERE FPKID = '2110ZV4IQ9WY';
INSERT INTO t_er_invoicedatapre_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1294966791646394368,'2110ZV4IQ9WY','zh_TW','兩張火車票');
