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

【RetValue】:【{"channelSeqId":"zhijian17rn_22050164523951896141","orderNo":"2202193951800111928","mobile":"19525194568","updateTime":1647831543668,"activityTime":0,"status":1030,"statusDesc":"H05-超过省公司期限未激活关闭","shipmentNumber":"JDV005778205243","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV005778205243】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV005778205243',ExpressName='京东快递',ExpressTime='2022-03-21 10:59:04',UpdateTime=GETDATE() where JTOrderId='2202193951800111928' 】
----------------------------------------------------------2022/3/21 10:59:04---------------------------------------------------



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

【RetValue】:【{"channelSeqId":"zhijian17rn_22079164771825386261","orderNo":"2203201265400111128","mobile":"19526539729","updateTime":1647865037453,"activityTime":1647865037000,"status":1035,"statusDesc":"","shipmentNumber":"JDV006132750066","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV006132750066】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV006132750066',ExpressName='京东快递',ExpressTime='2022-03-21 20:17:17',UpdateTime=GETDATE() where JTOrderId='2203201265400111128' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-03-21 20:17:17',UpdateTime=GETDATE() where JTOrderId='2203201265400111128' 】
----------------------------------------------------------2022/3/21 20:17:18---------------------------------------------------



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

【RetValue】:【{"channelSeqId":"zhijian17rn_22079164771825386261","orderNo":"2203201265400111128","mobile":"19526539729","updateTime":1647865045810,"activityTime":1647865037000,"status":1035,"statusDesc":"","shipmentNumber":"JDV006132750066","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV006132750066】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV006132750066',ExpressName='京东快递',ExpressTime='2022-03-21 20:17:26',UpdateTime=GETDATE() where JTOrderId='2203201265400111128' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-03-21 20:17:17',UpdateTime=GETDATE() where JTOrderId='2203201265400111128' 】
----------------------------------------------------------2022/3/21 20:17:26---------------------------------------------------