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

【RetValue】:【{"channelSeqId":"zhijian17rn_21302163551963805599","orderNo":"2110298283800111400","mobile":"19537385462","updateTime":1635563659875,"activityTime":1635563658000,"status":1035,"statusDesc":"","shipmentNumber":"JDV004463582821","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV004463582821】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV004463582821',ExpressName='京东快递',ExpressTime='2021-10-30 11:14:20',UpdateTime=GETDATE() where JTOrderId='2110298283800111400' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2021-10-30 11:14:18',UpdateTime=GETDATE() where JTOrderId='2110298283800111400' 】
----------------------------------------------------------2021/10/30 11:14:20---------------------------------------------------



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

【RetValue】:【{"channelSeqId":"zhijian17rn_21302163551963805599","orderNo":"2110298283800111400","mobile":"19537385462","updateTime":1635563670415,"activityTime":1635563658000,"status":1035,"statusDesc":"","shipmentNumber":"JDV004463582821","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV004463582821】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV004463582821',ExpressName='京东快递',ExpressTime='2021-10-30 11:14:30',UpdateTime=GETDATE() where JTOrderId='2110298283800111400' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2021-10-30 11:14:18',UpdateTime=GETDATE() where JTOrderId='2110298283800111400' 】
----------------------------------------------------------2021/10/30 11:14:30---------------------------------------------------