2024/3/28 9:40:08 {"Head":{"relevantOrder":"2601004250393423264","orignalTotal":"35.80","ORDERSN":"MT202403280939537044","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"江山名郡-6号楼-2单元 (404)","CONSIGNEE":"王超(**)","PHONE":"18416708227_9156","CREATETIME":"2024-03-28 09:37:04","FTYPE":"送货","NOTES":"收货人隐私号 18416708227_9156,手机号 156****2111 ,备用隐私号码: [\"17854133451_9309\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2601004250393423264","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY11150736","HYJ":"32.76","QUANTITY":"1","PRICE":"32.76","LSJ":"0.00"},{"HH":"440012","HYJ":"1.00","QUANTITY":"1","PRICE":"1.00","LSJ":"1.00"}]} 2024/3/28 9:40: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 ('MT202403280939537044', 'MT202403280939537044', '', '', '', '', '324', '', '江山名郡-6号楼-2单元 (404)', '王超(**)', '18416708227_9156', '2024-03-28 09:37:04', '送货', '收货人隐私号 18416708227_9156,手机号 156****2111 ,备用隐私号码: ["17854133451_9309"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2601004250393423264',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/28 9:40: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 ('01f068f5e73b453187da91c6c5ce455d', 'MT202403280939537044', '', 'DYY11150736', '0.00', '32.76', '1', '32.76', '','','','','','','','','','','') 2024/3/28 9:40: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 ('eed54a757123477a9c1691ce27a4c107', 'MT202403280939537044', '', '440012', '1.00', '1.00', '1', '1.00', '','','','','','','','','','','') 2024/3/28 9:44:30 {"Head":{"relevantOrder":"2701004264259957262","orignalTotal":"34.64","ORDERSN":"MT202403280944111316","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"曹县实验中学 (曹县实验中学)","CONSIGNEE":"秦(**)","PHONE":"18854104604_1248","CREATETIME":"2024-03-28 09:43:40","FTYPE":"送货","NOTES":"收货人隐私号 18854104604_1248,手机号 178****8556 ,备用隐私号码: [\"17854131579_9363\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2701004264259957262","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY1010408044","HYJ":"29.10","QUANTITY":"1","PRICE":"29.10","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 9:44:31 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 ('MT202403280944111316', 'MT202403280944111316', '', '', '', '', '324', '', '曹县实验中学 (曹县实验中学)', '秦(**)', '18854104604_1248', '2024-03-28 09:43:40', '送货', '收货人隐私号 18854104604_1248,手机号 178****8556 ,备用隐私号码: ["17854131579_9363"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2701004264259957262',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/28 9:44:31 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 ('da56ffcf915e437c9777b2b9f0630371', 'MT202403280944111316', '', 'DYY1010408044', '0.00', '29.10', '1', '29.10', '','','','','','','','','','','') 2024/3/28 9:44:31 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 ('e17bca87006a4c45afeaa43d22082264', 'MT202403280944111316', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 9:59:40 {"Head":{"relevantOrder":"2701004273808865435","orignalTotal":"25.16","ORDERSN":"MT202403280959288249","STOREGUID":"hzhzk386","SUBPHONE":"","ADDRESS":"银座商城(曹县店) (四楼小飞天舞蹈艺术学校办公室)","CONSIGNEE":"李冲(**)","PHONE":"18416721220_2418","CREATETIME":"2024-03-28 09:59:23","FTYPE":"送货","NOTES":"收货人隐私号 18416721220_2418,手机号 155****7333 ,备用隐私号码: [\"18416708151_9296\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2701004273808865435","SPARE3":"hzhzk386"},"Entry":[{"HH":"DYY11150403","HYJ":"20.14","QUANTITY":"1","PRICE":"20.14","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 9:59:41 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 ('MT202403280959288249', 'MT202403280959288249', '', '', '', '', '386', '', '银座商城(曹县店) (四楼小飞天舞蹈艺术学校办公室)', '李冲(**)', '18416721220_2418', '2024-03-28 09:59:23', '送货', '收货人隐私号 18416721220_2418,手机号 155****7333 ,备用隐私号码: ["18416708151_9296"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2701004273808865435',getdate(),'HYBRIS', '','hzhzk386','','','','','','', '','','','','','','','','','') 2024/3/28 9:59:41 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 ('63d3f191e12a4c55b683e996dbed50f1', 'MT202403280959288249', '', 'DYY11150403', '0.00', '20.14', '1', '20.14', '','','','','','','','','','','') 2024/3/28 9:59:41 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 ('41a4793e9f174560bb8f3a9e0353eaef', 'MT202403280959288249', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 10:56:01 {"Head":{"relevantOrder":"2701004330617736214","orignalTotal":"30.00","ORDERSN":"MT202403281055495705","STOREGUID":"hzhzk403","SUBPHONE":"","ADDRESS":"香河社区 (12号楼一单元502)","CONSIGNEE":"李佳(**)","PHONE":"17854131580_3401","CREATETIME":"2024-03-28 10:53:48","FTYPE":"送货","NOTES":"收货人隐私号 17854131580_3401,手机号 184****3681 ,备用隐私号码: [\"18416717951_8894\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2701004330617736214","SPARE3":"hzhzk403"},"Entry":[{"HH":"DYY1041125","HYJ":"15.10","QUANTITY":"1","PRICE":"15.10","LSJ":"0.00"},{"HH":"DYY1040928","HYJ":"11.34","QUANTITY":"1","PRICE":"11.34","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 10:56:02 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 ('MT202403281055495705', 'MT202403281055495705', '', '', '', '', '403', '', '香河社区 (12号楼一单元502)', '李佳(**)', '17854131580_3401', '2024-03-28 10:53:48', '送货', '收货人隐私号 17854131580_3401,手机号 184****3681 ,备用隐私号码: ["18416717951_8894"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2701004330617736214',getdate(),'HYBRIS', '','hzhzk403','','','','','','', '','','','','','','','','','') 2024/3/28 10:56:02 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 ('7b323219dff24316a18377ba994f3258', 'MT202403281055495705', '', 'DYY1041125', '0.00', '15.10', '1', '15.10', '','','','','','','','','','','') 2024/3/28 10:56:02 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 ('1c912868c1de413597c70d99bbfbc645', 'MT202403281055495705', '', 'DYY1040928', '0.00', '11.34', '1', '11.34', '','','','','','','','','','','') 2024/3/28 10:56:02 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 ('9958b440865b40dd87bb0a2ac1120340', 'MT202403281055495705', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 11:34:06 {"Head":{"relevantOrder":"2601004371776240113","orignalTotal":"23.80","ORDERSN":"MT202403281133535038","STOREGUID":"hzhzk360","SUBPHONE":"","ADDRESS":"曹县第二实验小学","CONSIGNEE":"苗春(**)","PHONE":"17854132371_0712","CREATETIME":"2024-03-28 11:33:43","FTYPE":"送货","NOTES":"收货人隐私号 17854132371_0712,手机号 157****4630 ,备用隐私号码: [\"18854152954_2063\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2601004371776240113","SPARE3":"hzhzk360"},"Entry":[{"HH":"DYY30104055","HYJ":"1.86","QUANTITY":"1","PRICE":"1.86","LSJ":"0.00"},{"HH":"DYY1011246","HYJ":"18.31","QUANTITY":"1","PRICE":"18.31","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 11:34:06 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 ('MT202403281133535038', 'MT202403281133535038', '', '', '', '', '360', '', '曹县第二实验小学', '苗春(**)', '17854132371_0712', '2024-03-28 11:33:43', '送货', '收货人隐私号 17854132371_0712,手机号 157****4630 ,备用隐私号码: ["18854152954_2063"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2601004371776240113',getdate(),'HYBRIS', '','hzhzk360','','','','','','', '','','','','','','','','','') 2024/3/28 11:34:06 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 ('3a540594c3e34db3b301e444bc360d73', 'MT202403281133535038', '', 'DYY30104055', '0.00', '1.86', '1', '1.86', '','','','','','','','','','','') 2024/3/28 11:34:06 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 ('9d649c557a0a4757a53ff64c9568a2a8', 'MT202403281133535038', '', 'DYY1011246', '0.00', '18.31', '1', '18.31', '','','','','','','','','','','') 2024/3/28 11:34:06 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 ('30d086b1f7584395bdccf0b24b4772c4', 'MT202403281133535038', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 13:15:09 {"Head":{"relevantOrder":"2601004472366443377","orignalTotal":"25.52","ORDERSN":"MT202403281314454553","USERID":"","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"北京空间榜样装饰公司 (青岛路南路西嘉华大厦三楼北京空间榜样装饰)","CONSIGNEE":"孙露奚(**)","PHONE":"18865943834_2797","CREATETIME":"2024-03-28 13:14:35","FTYPE":"送货","NOTES":"收货人隐私号 18865943834_2797,手机号 173****1807 ,备用隐私号码: [\"17854131598_5002\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2601004472366443377","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1010218","HYJ":"11.09","QUANTITY":"2","PRICE":"22.17","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 13:15:10 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 ('MT202403281314454553', 'MT202403281314454553', '', '', '', '', '432', '', '北京空间榜样装饰公司 (青岛路南路西嘉华大厦三楼北京空间榜样装饰)', '孙露奚(**)', '18865943834_2797', '2024-03-28 13:14:35', '送货', '收货人隐私号 18865943834_2797,手机号 173****1807 ,备用隐私号码: ["17854131598_5002"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2601004472366443377',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/28 13:15:10 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 ('bf37e66e712c4bc395b7b11693872648', 'MT202403281314454553', '', 'DYY1010218', '0.00', '11.09', '2', '22.17', '','','','','','','','','','','') 2024/3/28 13:15:10 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 ('af5ce8812fc54c8abe67bd032df6a9e0', 'MT202403281314454553', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 13:15:10 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 ('MT202403281314454553', 'MT202403281314454553', '', '', '', '', '432', '', '北京空间榜样装饰公司 (青岛路南路西嘉华大厦三楼北京空间榜样装饰)', '孙露奚(**)', '18865943834_2797', '2024-03-28 13:14:35', '送货', '收货人隐私号 18865943834_2797,手机号 173****1807 ,备用隐私号码: ["17854131598_5002"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2601004472366443377',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/28 13:15:10 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 ('d24c7c07a1304b7bbbcffbb2ea0b4c20', 'MT202403281314454553', '', 'DYY1010218', '0.00', '11.09', '2', '22.17', '','','','','','','','','','','') 2024/3/28 13:15:10 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 ('d7f77e4efae348b2857a742e3af854ac', 'MT202403281314454553', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 13:15:10 O2O订单接口异常:G3数据库操作失败违反了 PRIMARY KEY 约束“PK_WX_SY_ORDER”。不能在对象“dbo.WX_SY_ORDER”中插入重复键。重复键值为 (MT202403281314454553)。 语句已终止。 2024/3/28 14:25:10 {"Head":{"relevantOrder":"2701004531989309444","orignalTotal":"27.00","ORDERSN":"MT202403281424571881","STOREGUID":"hzhzk403","SUBPHONE":"","ADDRESS":"天润城2期-65号楼 (二单元2203)","CONSIGNEE":"杨(**)","PHONE":"17854133285_5438","CREATETIME":"2024-03-28 14:19:23","FTYPE":"送货","NOTES":"收货人隐私号 17854133285_5438,手机号 187****6556 ,备用隐私号码: [\"18416719985_9342\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2701004531989309444","SPARE3":"hzhzk403"},"Entry":[{"HH":"DYY1010904017","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/28 14:25:10 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 ('MT202403281424571881', 'MT202403281424571881', '', '', '', '', '403', '', '天润城2期-65号楼 (二单元2203)', '杨(**)', '17854133285_5438', '2024-03-28 14:19:23', '送货', '收货人隐私号 17854133285_5438,手机号 187****6556 ,备用隐私号码: ["18416719985_9342"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2701004531989309444',getdate(),'HYBRIS', '','hzhzk403','','','','','','', '','','','','','','','','','') 2024/3/28 14:25:10 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 ('090993fe813245549084e32e0973027b', 'MT202403281424571881', '', 'DYY1010904017', '0.00', '23.50', '1', '23.50', '','','','','','','','','','','') 2024/3/28 14:25:10 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 ('fdbb08906b4c43be97b3b0285f4af220', 'MT202403281424571881', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 15:01:42 {"Head":{"relevantOrder":"4701004580965795238","orignalTotal":"292.00","ORDERSN":"MT202403281501307642","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"曹县青荷卫生院","CONSIGNEE":"孙玉英(**)","PHONE":"17854132447_0288","CREATETIME":"2024-03-28 15:00:59","FTYPE":"送货","NOTES":"收货人隐私号 17854132447_0288,手机号 182****9102 ,备用隐私号码: [\"18854105014_3155\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"4701004580965795238","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY1040337","HYJ":"283.20","QUANTITY":"1","PRICE":"283.20","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 15:01:43 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 ('MT202403281501307642', 'MT202403281501307642', '', '', '', '', '340', '', '曹县青荷卫生院', '孙玉英(**)', '17854132447_0288', '2024-03-28 15:00:59', '送货', '收货人隐私号 17854132447_0288,手机号 182****9102 ,备用隐私号码: ["18854105014_3155"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','4701004580965795238',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/28 15:01:43 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 ('e87500ad0c794fe7ae8c9fb46b64e77f', 'MT202403281501307642', '', 'DYY1040337', '0.00', '283.20', '1', '283.20', '','','','','','','','','','','') 2024/3/28 15:01:43 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 ('8c5c145b8e22484c88713ae22d0e4084', 'MT202403281501307642', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 15:07:42 {"Head":{"relevantOrder":"2701004580954462812","orignalTotal":"38.00","ORDERSN":"MT202403281507303419","STOREGUID":"hzhzk403","SUBPHONE":"","ADDRESS":"曹县一中新校区-东门 (运动场主席台运字下面)","CONSIGNEE":"小姚(**)","PHONE":"18416721217_5182","CREATETIME":"2024-03-28 15:07:13","FTYPE":"送货","NOTES":"送到指定地点不用打电话,送到主席台栏杆处放哪就可以了 收货人隐私号 18416721217_5182,手机号 150****9458 ,备用隐私号码: [\"18854117435_3174\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2701004580954462812","SPARE3":"hzhzk403"},"Entry":[{"HH":"DYY1011334","HYJ":"17.14","QUANTITY":"1","PRICE":"17.14","LSJ":"0.00"},{"HH":"DYY1011198","HYJ":"17.14","QUANTITY":"1","PRICE":"17.14","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 15:07:42 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 ('MT202403281507303419', 'MT202403281507303419', '', '', '', '', '403', '', '曹县一中新校区-东门 (运动场主席台运字下面)', '小姚(**)', '18416721217_5182', '2024-03-28 15:07:13', '送货', '送到指定地点不用打电话,送到主席台栏杆处放哪就可以了 收货人隐私号 18416721217_5182,手机号 150****9458 ,备用隐私号码: ["18854117435_3174"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2701004580954462812',getdate(),'HYBRIS', '','hzhzk403','','','','','','', '','','','','','','','','','') 2024/3/28 15:07:42 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 ('2180f591c35d44aa89ae64394fa3b40e', 'MT202403281507303419', '', 'DYY1011334', '0.00', '17.14', '1', '17.14', '','','','','','','','','','','') 2024/3/28 15:07:42 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 ('d57a0bf30ea6470aa40645370846aa3b', 'MT202403281507303419', '', 'DYY1011198', '0.00', '17.14', '1', '17.14', '','','','','','','','','','','') 2024/3/28 15:07:42 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 ('9013b3d35db94e82894e0d499beb6bf9', 'MT202403281507303419', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/28 18:15:29 {"Head":{"relevantOrder":"501004773812774262","orignalTotal":"31.00","ORDERSN":"MT202403281815140821","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"一中家园 (6号楼)","CONSIGNEE":"韩(**)","PHONE":"18416708186_0168","CREATETIME":"2024-03-28 18:14:54","FTYPE":"送货","NOTES":"一单元,9楼901。到了打个电话放门口 收货人隐私号 18416708186_0168,手机号 182****6159 ,备用隐私号码: [\"17854132564_5113\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"501004773812774262","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY1031673","HYJ":"4.73","QUANTITY":"1","PRICE":"4.73","LSJ":"0.00"},{"HH":"DYY1040482","HYJ":"23.67","QUANTITY":"1","PRICE":"23.67","LSJ":"0.00"},{"HH":"440012","HYJ":"1.00","QUANTITY":"1","PRICE":"1.00","LSJ":"1.00"}]} 2024/3/28 18:15:29 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 ('MT202403281815140821', 'MT202403281815140821', '', '', '', '', '324', '', '一中家园 (6号楼)', '韩(**)', '18416708186_0168', '2024-03-28 18:14:54', '送货', '一单元,9楼901。到了打个电话放门口 收货人隐私号 18416708186_0168,手机号 182****6159 ,备用隐私号码: ["17854132564_5113"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','501004773812774262',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/28 18:15:29 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 ('9a6143e4547c4284a00433b362c06600', 'MT202403281815140821', '', 'DYY1031673', '0.00', '4.73', '1', '4.73', '','','','','','','','','','','') 2024/3/28 18:15:29 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 ('a486be30b98f47928016efdada4e8345', 'MT202403281815140821', '', 'DYY1040482', '0.00', '23.67', '1', '23.67', '','','','','','','','','','','') 2024/3/28 18:15:29 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 ('b0cc5d24226943868b56cd196c978268', 'MT202403281815140821', '', '440012', '1.00', '1.00', '1', '1.00', '','','','','','','','','','','') 2024/3/28 20:48:16 {"Head":{"relevantOrder":"2001004922354647375","orignalTotal":"29.00","ORDERSN":"MT202403282047584186","STOREGUID":"hzhzk341","SUBPHONE":"","ADDRESS":"皇庭别苑酒店(环岛公园店) (606房间)","CONSIGNEE":"史(**)","PHONE":"18854189594_5025","CREATETIME":"2024-03-28 20:45:17","FTYPE":"送货","NOTES":"收货人隐私号 18854189594_5025,手机号 150****6744 ,备用隐私号码: [\"18416721118_9937\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2001004922354647375","SPARE3":"hzhzk341"},"Entry":[{"HH":"DYY10118020006","HYJ":"25.19","QUANTITY":"1","PRICE":"25.19","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/28 20:48:17 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 ('MT202403282047584186', 'MT202403282047584186', '', '', '', '', '341', '', '皇庭别苑酒店(环岛公园店) (606房间)', '史(**)', '18854189594_5025', '2024-03-28 20:45:17', '送货', '收货人隐私号 18854189594_5025,手机号 150****6744 ,备用隐私号码: ["18416721118_9937"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2001004922354647375',getdate(),'HYBRIS', '','hzhzk341','','','','','','', '','','','','','','','','','') 2024/3/28 20:48:17 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 ('ffc166cdf1854de78dc409ebc4530723', 'MT202403282047584186', '', 'DYY10118020006', '0.00', '25.19', '1', '25.19', '','','','','','','','','','','') 2024/3/28 20:48:17 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 ('95cf443166584f389b110997db217fd6', 'MT202403282047584186', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','')