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

【RetValue】:【{"channelSeqId":"zhijian17rn_22027164327448998881","orderNo":"2201276168900111168","mobile":"15954548990","updateTime":1643423135926,"activityTime":1643423133000,"status":1035,"statusDesc":"","shipmentNumber":"JDV005586122977","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV005586122977】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV005586122977',ExpressName='京东快递',ExpressTime='2022-01-29 10:25:36',UpdateTime=GETDATE() where JTOrderId='2201276168900111168' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-01-29 10:25:33',UpdateTime=GETDATE() where JTOrderId='2201276168900111168' 】
----------------------------------------------------------2022/1/29 10:25:36---------------------------------------------------



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

【RetValue】:【{"channelSeqId":"zhijian17rn_22027164327448998881","orderNo":"2201276168900111168","mobile":"15954548990","updateTime":1643423135977,"activityTime":1643423133000,"status":1035,"statusDesc":"","shipmentNumber":"JDV005586122977","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV005586122977】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV005586122977',ExpressName='京东快递',ExpressTime='2022-01-29 10:25:36',UpdateTime=GETDATE() where JTOrderId='2201276168900111168' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-01-29 10:25:33',UpdateTime=GETDATE() where JTOrderId='2201276168900111168' 】
----------------------------------------------------------2022/1/29 10:25:36---------------------------------------------------