2024/3/18 14:04:07 {"Head":{"relevantOrder":"2700986000418521925","orignalTotal":"71.00","ORDERSN":"MT202403151725223778","USERID":"","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"天润公馆一期-13号楼 (天润公馆一期13号楼2单元202)","CONSIGNEE":"陈蕊(**)","PHONE":"18416720908_7182","CREATETIME":"2024-03-15 17:20:35","FTYPE":"送货","NOTES":"收货人隐私号 18416720908_7182,手机号 150****8672 ,备用隐私号码: [\"18416708163_2394\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700986000418521925","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1031286","HYJ":"5.78","QUANTITY":"1","PRICE":"5.78","LSJ":"0.00"},{"HH":"DYY1011509043","HYJ":"24.59","QUANTITY":"1","PRICE":"24.59","LSJ":"0.00"},{"HH":"DYY11150113","HYJ":"13.50","QUANTITY":"1","PRICE":"13.50","LSJ":"0.00"},{"HH":"DYY11000461","HYJ":"17.72","QUANTITY":"1","PRICE":"17.72","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:08 {"Head":{"relevantOrder":"2700985611622146280","orignalTotal":"29.24","ORDERSN":"MT202403151054397049","USERID":"","STOREGUID":"hzhzk433","SUBPHONE":"","ADDRESS":"月星家居(曹县店) (月星家具南门车美汇)","CONSIGNEE":"王茜(**)","PHONE":"18416708148_0791","CREATETIME":"2024-03-15 10:54:25","FTYPE":"送货","NOTES":"收货人隐私号 18416708148_0791,手机号 158****9249 ,备用隐私号码: [\"17854133196_6925\"]","CSNOTES":"已发货","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700985611622146280","SPARE3":"hzhzk433"},"Entry":[{"HH":"DYY1010101039","HYJ":"25.42","QUANTITY":"1","PRICE":"25.42","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:08 {"Head":{"relevantOrder":"300987001099144415","orignalTotal":"50.00","ORDERSN":"MT202403161009024521","USERID":"","STOREGUID":"hzhzk328","SUBPHONE":"","ADDRESS":"翰林苑-3号楼 (801)","CONSIGNEE":"张慧敏(**)","PHONE":"17854132314_6990","CREATETIME":"2024-03-16 10:08:18","FTYPE":"送货","NOTES":"收货人隐私号 17854132314_6990,手机号 158****5696 ,备用隐私号码: [\"18416703272_1726\"]","CSNOTES":"已发货","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"300987001099144415","SPARE3":"hzhzk328"},"Entry":[{"HH":"DYY1050530","HYJ":"20.52","QUANTITY":"2","PRICE":"41.04","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403151725223778', 'MT202403151725223778', '', '', '', '', '432', '', '天润公馆一期-13号楼 (天润公馆一期13号楼2单元202)', '陈蕊(**)', '18416720908_7182', '2024-03-15 17:20:35', '送货', '收货人隐私号 18416720908_7182,手机号 150****8672 ,备用隐私号码: ["18416708163_2394"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700986000418521925',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403151054397049', 'MT202403151054397049', '', '', '', '', '433', '', '月星家居(曹县店) (月星家具南门车美汇)', '王茜(**)', '18416708148_0791', '2024-03-15 10:54:25', '送货', '收货人隐私号 18416708148_0791,手机号 158****9249 ,备用隐私号码: ["17854133196_6925"]', '已发货', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700985611622146280',getdate(),'HYBRIS', '','hzhzk433','','','','','','', '','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('c02984b7e59c479a8aef3e9e2cdd6bc3', 'MT202403151725223778', '', 'DYY1031286', '0.00', '5.78', '1', '5.78', '','','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('934765baff3c4dce92997d5cfba19276', 'MT202403161009024521', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('8b102cf758ca45a9a1c0992fd3a5ac3c', 'MT202403151725223778', '', 'DYY1011509043', '0.00', '24.59', '1', '24.59', '','','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7d8424bd054c4390b348d838d1265dc1', 'MT202403151725223778', '', 'DYY11150113', '0.00', '13.50', '1', '13.50', '','','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('c584bf8fe751461a96ddedc17e879402', 'MT202403151725223778', '', 'DYY11000461', '0.00', '17.72', '1', '17.72', '','','','','','','','','','','') 2024/3/18 14:04:12 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7a4729a57bee4393baeb6a3cc59e6a38', 'MT202403151725223778', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 14:04:17 O2O订单接口异常:事务(进程 ID 78)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 2024/3/18 14:04:22 O2O订单接口异常:事务(进程 ID 110)与另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。 2024/3/18 14:04:23 {"Head":{"relevantOrder":"2700985871919215619","orignalTotal":"24.78","ORDERSN":"MT202403151514425329","USERID":"","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"金座国际商贸城 (金座国际商贸城 金座B栋三楼迪浩电商)","CONSIGNEE":"张(**)","PHONE":"18416703544_8603","CREATETIME":"2024-03-15 15:11:15","FTYPE":"送货","NOTES":"收货人隐私号 18416703544_8603,手机号 155****5436 ,备用隐私号码: [\"18416713139_1626\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700985871919215619","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY10100509","HYJ":"13.57","QUANTITY":"1","PRICE":"13.57","LSJ":"0.00"},{"HH":"DYY1010116","HYJ":"7.67","QUANTITY":"1","PRICE":"7.67","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403151514425329', 'MT202403151514425329', '', '', '', '', '340', '', '金座国际商贸城 (金座国际商贸城 金座B栋三楼迪浩电商)', '张(**)', '18416703544_8603', '2024-03-15 15:11:15', '送货', '收货人隐私号 18416703544_8603,手机号 155****5436 ,备用隐私号码: ["18416713139_1626"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700985871919215619',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('8ce08c79cc704a198d3f5909f48847d6', 'MT202403151514425329', '', 'DYY10100509', '0.00', '13.57', '1', '13.57', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('ab8ac7a37ed947469ae75712e7d9b751', 'MT202403151514425329', '', 'DYY1010116', '0.00', '7.67', '1', '7.67', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7e3f7bb7b47f475da0ccf7adb20b04f3', 'MT202403151514425329', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 14:04:23 {"Head":{"relevantOrder":"2700986023400878542","orignalTotal":"52.80","ORDERSN":"MT202403151749513717","USERID":"","STOREGUID":"hzhzk360","SUBPHONE":"","ADDRESS":"大地烧烤地锅炖 (乐仕后门,大地旁边)","CONSIGNEE":"娜娜(**)","PHONE":"17854131676_7242","CREATETIME":"2024-03-15 17:49:38","FTYPE":"送货","NOTES":"收货人隐私号 17854131676_7242,手机号 176****8996 ,备用隐私号码: [\"18416708152_2483\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700986023400878542","SPARE3":"hzhzk360"},"Entry":[{"HH":"DYY1011101002","HYJ":"44.47","QUANTITY":"1","PRICE":"44.47","LSJ":"0.00"},{"HH":"DYY1030145","HYJ":"3.85","QUANTITY":"1","PRICE":"3.85","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403151749513717', 'MT202403151749513717', '', '', '', '', '360', '', '大地烧烤地锅炖 (乐仕后门,大地旁边)', '娜娜(**)', '17854131676_7242', '2024-03-15 17:49:38', '送货', '收货人隐私号 17854131676_7242,手机号 176****8996 ,备用隐私号码: ["18416708152_2483"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700986023400878542',getdate(),'HYBRIS', '','hzhzk360','','','','','','', '','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('0db07a73f27044f2a709ebe83eb1ae33', 'MT202403151749513717', '', 'DYY1011101002', '0.00', '44.47', '1', '44.47', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('6479b2a3e6bc4f4db21906da2d11c518', 'MT202403151749513717', '', 'DYY1030145', '0.00', '3.85', '1', '3.85', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('4f92b979662f4ccf980c0e350a0431b2', 'MT202403151749513717', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 14:04:23 {"Head":{"relevantOrder":"2700985884019983570","orignalTotal":"41.16","ORDERSN":"MT202403151525184653","USERID":"","STOREGUID":"hzhzk382","SUBPHONE":"","ADDRESS":"德嘉绿城-20号楼 (1-401)","CONSIGNEE":"吴(**)","PHONE":"18416708290_1893","CREATETIME":"2024-03-15 15:21:34","FTYPE":"送货","NOTES":"收货人隐私号 18416708290_1893,手机号 158****5834 ,备用隐私号码: [\"17854132364_8177\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700985884019983570","SPARE3":"hzhzk382"},"Entry":[{"HH":"DYY10119711","HYJ":"11.45","QUANTITY":"1","PRICE":"11.45","LSJ":"0.00"},{"HH":"DYY1010602052","HYJ":"16.21","QUANTITY":"1","PRICE":"16.21","LSJ":"0.00"},{"HH":"DYY1011728","HYJ":"9.55","QUANTITY":"1","PRICE":"9.55","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403151525184653', 'MT202403151525184653', '', '', '', '', '382', '', '德嘉绿城-20号楼 (1-401)', '吴(**)', '18416708290_1893', '2024-03-15 15:21:34', '送货', '收货人隐私号 18416708290_1893,手机号 158****5834 ,备用隐私号码: ["17854132364_8177"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700985884019983570',getdate(),'HYBRIS', '','hzhzk382','','','','','','', '','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('fb37e1bb148a456c8e963613d950b510', 'MT202403151525184653', '', 'DYY10119711', '0.00', '11.45', '1', '11.45', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('68aa72a491844508b4dcd7c4c6bd2e32', 'MT202403151525184653', '', 'DYY1010602052', '0.00', '16.21', '1', '16.21', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('af9ae31086334070a37a8d4d27ff3735', 'MT202403151525184653', '', 'DYY1011728', '0.00', '9.55', '1', '9.55', '','','','','','','','','','','') 2024/3/18 14:04:23 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('f05f8606477c46cba2e91d2992407380', 'MT202403151525184653', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 14:04:23 {"Head":{"relevantOrder":"300987001099144415","orignalTotal":"50.00","ORDERSN":"MT202403161009024521","USERID":"","STOREGUID":"hzhzk328","SUBPHONE":"","ADDRESS":"翰林苑-3号楼 (801)","CONSIGNEE":"张慧敏(**)","PHONE":"17854132314_6990","CREATETIME":"2024-03-16 10:08:18","FTYPE":"送货","NOTES":"收货人隐私号 17854132314_6990,手机号 158****5696 ,备用隐私号码: [\"18416703272_1726\"]","CSNOTES":"已发货","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"300987001099144415","SPARE3":"hzhzk328"},"Entry":[{"HH":"DYY1050530","HYJ":"20.52","QUANTITY":"2","PRICE":"41.04","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:23 O2O订单接口异常:O2O订单号:MT202403161009024521已存在 2024/3/18 14:04:24 {"Head":{"relevantOrder":"700986002844730294","orignalTotal":"27.00","ORDERSN":"MT202403151721438555","USERID":"","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"水云间养生会馆(许单路店) (水云间和月子中心的中间胡同,西边第十家黑色大铁门)","CONSIGNEE":"梁(**)","PHONE":"18416713057_2097","CREATETIME":"2024-03-15 17:21:33","FTYPE":"送货","NOTES":"收货人隐私号 18416713057_2097,手机号 177****6722 ,备用隐私号码: [\"17854132575_8763\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"700986002844730294","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1010039","HYJ":"23.50","QUANTITY":"1","PRICE":"23.50","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:04:24 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403151721438555', 'MT202403151721438555', '', '', '', '', '432', '', '水云间养生会馆(许单路店) (水云间和月子中心的中间胡同,西边第十家黑色大铁门)', '梁(**)', '18416713057_2097', '2024-03-15 17:21:33', '送货', '收货人隐私号 18416713057_2097,手机号 177****6722 ,备用隐私号码: ["17854132575_8763"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','700986002844730294',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/18 14:04:24 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('72be2806f0224013b86a536113839aea', 'MT202403151721438555', '', 'DYY1010039', '0.00', '23.50', '1', '23.50', '','','','','','','','','','','') 2024/3/18 14:04:24 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('ad2a52dbb3674e58b2f38a1097ba8830', 'MT202403151721438555', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 14:05:04 {"Head":{"relevantOrder":"2700985611622146280","orignalTotal":"29.24","ORDERSN":"MT202403151054397049","USERID":"","STOREGUID":"hzhzk433","SUBPHONE":"","ADDRESS":"月星家居(曹县店) (月星家具南门车美汇)","CONSIGNEE":"王茜(**)","PHONE":"18416708148_0791","CREATETIME":"2024-03-15 10:54:25","FTYPE":"送货","NOTES":"收货人隐私号 18416708148_0791,手机号 158****9249 ,备用隐私号码: [\"17854133196_6925\"]","CSNOTES":"已发货","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700985611622146280","SPARE3":"hzhzk433"},"Entry":[{"HH":"DYY1010101039","HYJ":"25.42","QUANTITY":"1","PRICE":"25.42","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:05:04 O2O订单接口异常:O2O订单号:MT202403151054397049已存在 2024/3/18 14:43:50 {"Head":{"relevantOrder":"2700985611622146280","orignalTotal":"29.24","ORDERSN":"FZ202403181443423136","STOREGUID":"hzhzk433","SUBPHONE":"","ADDRESS":"月星家居(曹县店) (月星家具南门车美汇)","CONSIGNEE":"王茜(**)","PHONE":"18416708148_0791","CREATETIME":"2024-03-18 14:43:43","FTYPE":"送货","NOTES":"收货人隐私号 18416708148_0791,手机号 158****9249 ,备用隐私号码: [\"17854133196_6925\"]","CSNOTES":"已发货","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700985611622146280","SPARE3":"hzhzk433"},"Entry":[{"HH":"DYY1010101039","HYJ":"25.42","QUANTITY":"1","PRICE":"25.42","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 14:43:50 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('FZ202403181443423136', 'FZ202403181443423136', '', '', '', '', '433', '', '月星家居(曹县店) (月星家具南门车美汇)', '王茜(**)', '18416708148_0791', '2024-03-18 14:43:43', '送货', '收货人隐私号 18416708148_0791,手机号 158****9249 ,备用隐私号码: ["17854133196_6925"]', '已发货', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700985611622146280',getdate(),'HYBRIS', '','hzhzk433','','','','','','', '','','','','','','','','','') 2024/3/18 14:43:50 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('b20d226f13b943028eaf64a2cde73b45', 'FZ202403181443423136', '', 'DYY1010101039', '0.00', '25.42', '1', '25.42', '','','','','','','','','','','') 2024/3/18 14:43:50 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('439027079fc245dfb2ecf456acc413b3', 'FZ202403181443423136', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 16:07:22 {"Head":{"relevantOrder":"2700990241178067858","orignalTotal":"27.32","ORDERSN":"MT202403181607094337","STOREGUID":"hzhzk382","SUBPHONE":"","ADDRESS":"天惠医院","CONSIGNEE":"赵(**)","PHONE":"18854192354_7180","CREATETIME":"2024-03-18 16:06:55","FTYPE":"送货","NOTES":"收货人隐私号 18854192354_7180,手机号 158****8489 ,备用隐私号码: [\"17854132312_0359\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700990241178067858","SPARE3":"hzhzk382"},"Entry":[{"HH":"DYY1030037","HYJ":"14.10","QUANTITY":"1","PRICE":"14.10","LSJ":"0.00"},{"HH":"DYY1040082","HYJ":"9.61","QUANTITY":"1","PRICE":"9.61","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 16:07:22 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403181607094337', 'MT202403181607094337', '', '', '', '', '382', '', '天惠医院', '赵(**)', '18854192354_7180', '2024-03-18 16:06:55', '送货', '收货人隐私号 18854192354_7180,手机号 158****8489 ,备用隐私号码: ["17854132312_0359"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700990241178067858',getdate(),'HYBRIS', '','hzhzk382','','','','','','', '','','','','','','','','','') 2024/3/18 16:07:22 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('4072aff3fbdd4f0886011a7915d23fb6', 'MT202403181607094337', '', 'DYY1030037', '0.00', '14.10', '1', '14.10', '','','','','','','','','','','') 2024/3/18 16:07:22 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('6378f3dc28fa4f7a8570eea9a72e72dd', 'MT202403181607094337', '', 'DYY1040082', '0.00', '9.61', '1', '9.61', '','','','','','','','','','','') 2024/3/18 16:07:22 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('68a1c2ad7c7541d2964de20139d248b1', 'MT202403181607094337', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 17:49:44 {"Head":{"relevantOrder":"2700990343396864423","orignalTotal":"55.00","ORDERSN":"MT202403181749324798","STOREGUID":"hzhzk382","SUBPHONE":"","ADDRESS":"环岛花园 (牡丹园23号楼三单元401)","CONSIGNEE":"武艳梅(**)","PHONE":"17854133237_7107","CREATETIME":"2024-03-18 17:47:44","FTYPE":"送货","NOTES":"收货人隐私号 17854133237_7107,手机号 138****1844 ,备用隐私号码: [\"18416719110_3659\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700990343396864423","SPARE3":"hzhzk382"},"Entry":[{"HH":"DYY1031422","HYJ":"14.41","QUANTITY":"1","PRICE":"14.41","LSJ":"0.00"},{"HH":"DYY1030254","HYJ":"11.41","QUANTITY":"1","PRICE":"11.41","LSJ":"0.00"},{"HH":"DYY10100126","HYJ":"3.84","QUANTITY":"2","PRICE":"7.68","LSJ":"0.00"},{"HH":"DYY1011203038","HYJ":"17.32","QUANTITY":"1","PRICE":"17.32","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 17:49:44 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403181749324798', 'MT202403181749324798', '', '', '', '', '382', '', '环岛花园 (牡丹园23号楼三单元401)', '武艳梅(**)', '17854133237_7107', '2024-03-18 17:47:44', '送货', '收货人隐私号 17854133237_7107,手机号 138****1844 ,备用隐私号码: ["18416719110_3659"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700990343396864423',getdate(),'HYBRIS', '','hzhzk382','','','','','','', '','','','','','','','','','') 2024/3/18 17:49:44 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('1bbb7bef4ae24825ace973632f232a99', 'MT202403181749324798', '', 'DYY1031422', '0.00', '14.41', '1', '14.41', '','','','','','','','','','','') 2024/3/18 17:49:44 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('e3cd8a915ead4de0a36d75288b033a0e', 'MT202403181749324798', '', 'DYY1030254', '0.00', '11.41', '1', '11.41', '','','','','','','','','','','') 2024/3/18 17:49:44 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('23200041596d4660bee8af46019640f0', 'MT202403181749324798', '', 'DYY10100126', '0.00', '3.84', '2', '7.68', '','','','','','','','','','','') 2024/3/18 17:49:44 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('67657141761e46a698093e4266b7496e', 'MT202403181749324798', '', 'DYY1011203038', '0.00', '17.32', '1', '17.32', '','','','','','','','','','','') 2024/3/18 17:49:44 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('9d7556b7159d44e5b4bdedeb187122b3', 'MT202403181749324798', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 18:12:09 {"Head":{"relevantOrder":"2700990370360607202","orignalTotal":"29.00","ORDERSN":"MT202403181811563797","STOREGUID":"hzhzk402","SUBPHONE":"","ADDRESS":"颐江南-2号楼 (2-2-2104)","CONSIGNEE":"王**(**)","PHONE":"17854132482_7737","CREATETIME":"2024-03-18 18:11:44","FTYPE":"送货","NOTES":"收货人隐私号 17854132482_7737,手机号 134****9796 ,备用隐私号码: [\"18416708045_4429\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700990370360607202","SPARE3":"hzhzk402"},"Entry":[{"HH":"DYY10400153","HYJ":"11.31","QUANTITY":"1","PRICE":"11.31","LSJ":"0.00"},{"HH":"DYY10400067","HYJ":"14.15","QUANTITY":"1","PRICE":"14.15","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 18:12:09 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403181811563797', 'MT202403181811563797', '', '', '', '', '402', '', '颐江南-2号楼 (2-2-2104)', '王**(**)', '17854132482_7737', '2024-03-18 18:11:44', '送货', '收货人隐私号 17854132482_7737,手机号 134****9796 ,备用隐私号码: ["18416708045_4429"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700990370360607202',getdate(),'HYBRIS', '','hzhzk402','','','','','','', '','','','','','','','','','') 2024/3/18 18:12:09 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('c0c72e5add154f88a7502da8a8c8fbc6', 'MT202403181811563797', '', 'DYY10400153', '0.00', '11.31', '1', '11.31', '','','','','','','','','','','') 2024/3/18 18:12:09 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('26630587b035491988987a2d789a1d5d', 'MT202403181811563797', '', 'DYY10400067', '0.00', '14.15', '1', '14.15', '','','','','','','','','','','') 2024/3/18 18:12:09 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('9023f01a661a4a95849171743614bf62', 'MT202403181811563797', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 19:24:19 {"Head":{"relevantOrder":"2700990441517891425","orignalTotal":"37.00","ORDERSN":"MT202403181924079383","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"御景天下小区 (御景天下E区2号楼一单元1001)","CONSIGNEE":"伊(**)","PHONE":"18416721182_7675","CREATETIME":"2024-03-18 19:23:23","FTYPE":"送货","NOTES":"收货人隐私号 18416721182_7675,手机号 195****2222 ,备用隐私号码: [\"18416708967_4472\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700990441517891425","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY10112010050","HYJ":"33.30","QUANTITY":"1","PRICE":"33.30","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 19:24:19 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403181924079383', 'MT202403181924079383', '', '', '', '', '324', '', '御景天下小区 (御景天下E区2号楼一单元1001)', '伊(**)', '18416721182_7675', '2024-03-18 19:23:23', '送货', '收货人隐私号 18416721182_7675,手机号 195****2222 ,备用隐私号码: ["18416708967_4472"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700990441517891425',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/18 19:24:19 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('cdeb5dbae51346b19cf322893567df78', 'MT202403181924079383', '', 'DYY10112010050', '0.00', '33.30', '1', '33.30', '','','','','','','','','','','') 2024/3/18 19:24:19 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('1e6a652f5eac4ffcb19e11f055c89e8b', 'MT202403181924079383', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 19:32:28 {"Head":{"relevantOrder":"2700990452221006138","orignalTotal":"50.00","ORDERSN":"MT202403181932166234","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"康地君佳-C6栋 (c6 304)","CONSIGNEE":"秦(**)","PHONE":"17854131626_7503","CREATETIME":"2024-03-18 19:32:06","FTYPE":"送货","NOTES":"收货人隐私号 17854131626_7503,手机号 137****3117 ,备用隐私号码: [\"18416708120_4799\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700990452221006138","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1010191","HYJ":"41.04","QUANTITY":"1","PRICE":"41.04","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 19:32:28 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403181932166234', 'MT202403181932166234', '', '', '', '', '432', '', '康地君佳-C6栋 (c6 304)', '秦(**)', '17854131626_7503', '2024-03-18 19:32:06', '送货', '收货人隐私号 17854131626_7503,手机号 137****3117 ,备用隐私号码: ["18416708120_4799"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700990452221006138',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/18 19:32:28 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('0ecaa78eae05446e94814a4742e01ada', 'MT202403181932166234', '', 'DYY1010191', '0.00', '41.04', '1', '41.04', '','','','','','','','','','','') 2024/3/18 19:32:28 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('c87a9ae02319492089cf1736fbf94287', 'MT202403181932166234', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 19:49:24 {"Head":{"relevantOrder":"3800990460817796152","orignalTotal":"70.00","ORDERSN":"MT202403181949122077","STOREGUID":"hzhzk434","SUBPHONE":"","ADDRESS":"德嘉绿城 (15号楼二单元1602)","CONSIGNEE":"小姐姐(**)","PHONE":"18416708265_4760","CREATETIME":"2024-03-18 19:49:09","FTYPE":"送货","NOTES":"收货人隐私号 18416708265_4760,手机号 186****8000 ,备用隐私号码: [\"18416721201_4394\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"3800990460817796152","SPARE3":"hzhzk434"},"Entry":[{"HH":"DYY11150219","HYJ":"60.64","QUANTITY":"1","PRICE":"60.64","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 19:49:24 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403181949122077', 'MT202403181949122077', '', '', '', '', '434', '', '德嘉绿城 (15号楼二单元1602)', '小姐姐(**)', '18416708265_4760', '2024-03-18 19:49:09', '送货', '收货人隐私号 18416708265_4760,手机号 186****8000 ,备用隐私号码: ["18416721201_4394"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','3800990460817796152',getdate(),'HYBRIS', '','hzhzk434','','','','','','', '','','','','','','','','','') 2024/3/18 19:49:24 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7552b16541b34e7797bcbcb032c9b2e8', 'MT202403181949122077', '', 'DYY11150219', '0.00', '60.64', '1', '60.64', '','','','','','','','','','','') 2024/3/18 19:49:24 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('3c085229f54f4eb9a7cc05149e0d0c47', 'MT202403181949122077', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/18 20:19:57 {"Head":{"relevantOrder":"2900990491671112940","orignalTotal":"28.00","ORDERSN":"MT202403182019444105","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"环岛花园 (环岛花园紫竹院21号楼2单元402室)","CONSIGNEE":"彭雪冰(**)","PHONE":"17854132586_4086","CREATETIME":"2024-03-18 20:19:35","FTYPE":"送货","NOTES":"收货人隐私号 17854132586_4086,手机号 157****2131 ,备用隐私号码: [\"18416713120_4683\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2900990491671112940","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY1050199","HYJ":"12.24","QUANTITY":"2","PRICE":"24.48","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/18 20:19:57 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403182019444105', 'MT202403182019444105', '', '', '', '', '340', '', '环岛花园 (环岛花园紫竹院21号楼2单元402室)', '彭雪冰(**)', '17854132586_4086', '2024-03-18 20:19:35', '送货', '收货人隐私号 17854132586_4086,手机号 157****2131 ,备用隐私号码: ["18416713120_4683"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2900990491671112940',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/18 20:19:57 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('774d8b4abaa449c39e601262db1d2fb5', 'MT202403182019444105', '', 'DYY1050199', '0.00', '12.24', '2', '24.48', '','','','','','','','','','','') 2024/3/18 20:19:57 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('9d9033c87fb64b04b953eaf22a3e5482', 'MT202403182019444105', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','')