【FromUrl】:【/YD_ZH/Notify.aspx】

【RetValue】:【{"channelSeqId":"zhijian17rn_21243163041294955594","orderNo":"2108317374900111784","mobile":"15093894901","updateTime":1633113418775,"activityTime":0,"status":1030,"shipmentNumber":"100603728820","shipmentCompanyName":"省公司自建物流"}】

【shipmentNumber】:【100603728820】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='100603728820',ExpressName='省公司自建物流',ExpressTime='2021-10-02 02:36:59',UpdateTime=GETDATE() where JTOrderId='2108317374900111784' 】
----------------------------------------------------------2021/10/2 2:36:59---------------------------------------------------



【FromUrl】:【/YD_ZH/Notify.aspx】

【RetValue】:【{"channelSeqId":"zhijian17rn_21245163058722220773","orderNo":"2109027522300111560","mobile":"19529806425","updateTime":1633132424003,"activityTime":0,"status":1030,"shipmentNumber":"JDV003854180581","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV003854180581】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV003854180581',ExpressName='京东快递',ExpressTime='2021-10-02 07:53:44',UpdateTime=GETDATE() where JTOrderId='2109027522300111560' 】
----------------------------------------------------------2021/10/2 7:53:44---------------------------------------------------



【FromUrl】:【/YD_ZH/Notify.aspx】

【RetValue】:【{"channelSeqId":"zhijian17rn_21274163305029333609","orderNo":"2110013269300111000","mobile":"17868142545","updateTime":1633144864612,"activityTime":1633144864000,"status":1035,"shipmentNumber":"JDV004167043730","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV004167043730】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV004167043730',ExpressName='京东快递',ExpressTime='2021-10-02 11:21:05',UpdateTime=GETDATE() where JTOrderId='2110013269300111000' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2021-10-02 11:21:04',UpdateTime=GETDATE() where JTOrderId='2110013269300111000' 】
----------------------------------------------------------2021/10/2 11:21:05---------------------------------------------------



【FromUrl】:【/YD_ZH/Notify.aspx】

【RetValue】:【{"channelSeqId":"zhijian17rn_21274163305029333609","orderNo":"2110013269300111000","mobile":"17868142545","updateTime":1633144920093,"activityTime":1633144864000,"status":1035,"shipmentNumber":"JDV004167043730","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV004167043730】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV004167043730',ExpressName='京东快递',ExpressTime='2021-10-02 11:22:00',UpdateTime=GETDATE() where JTOrderId='2110013269300111000' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2021-10-02 11:21:04',UpdateTime=GETDATE() where JTOrderId='2110013269300111000' 】
----------------------------------------------------------2021/10/2 11:22:00---------------------------------------------------