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

【RetValue】:【{"channelSeqId":"zhijian17rn_22117165102439457038","orderNo":"2204273559400111608","mobile":"19506456271","updateTime":1651291449811,"activityTime":1651291446000,"status":1035,"statusDesc":"","shipmentNumber":"JDV006630898632","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV006630898632】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV006630898632',ExpressName='京东快递',ExpressTime='2022-04-30 12:04:10',UpdateTime=GETDATE() where JTOrderId='2204273559400111608' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-04-30 12:04:06',UpdateTime=GETDATE() where JTOrderId='2204273559400111608' 】
----------------------------------------------------------2022/4/30 12:04:10---------------------------------------------------



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

【RetValue】:【{"channelSeqId":"zhijian17rn_22117165102439457038","orderNo":"2204273559400111608","mobile":"19506456271","updateTime":1651291450911,"activityTime":1651291446000,"status":1035,"statusDesc":"","shipmentNumber":"JDV006630898632","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV006630898632】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV006630898632',ExpressName='京东快递',ExpressTime='2022-04-30 12:04:11',UpdateTime=GETDATE() where JTOrderId='2204273559400111608' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-04-30 12:04:06',UpdateTime=GETDATE() where JTOrderId='2204273559400111608' 】
----------------------------------------------------------2022/4/30 12:04:11---------------------------------------------------