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

【RetValue】:【{"channelSeqId":"zhijian17rn_22048164505192425174","orderNo":"2202172472700111640","mobile":"19536379586","updateTime":1645151406937,"activityTime":1645151406000,"status":1035,"statusDesc":"","shipmentNumber":"JDV005757261631","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV005757261631】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV005757261631',ExpressName='京东快递',ExpressTime='2022-02-18 10:30:07',UpdateTime=GETDATE() where JTOrderId='2202172472700111640' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-02-18 10:30:06',UpdateTime=GETDATE() where JTOrderId='2202172472700111640' 】
----------------------------------------------------------2022/2/18 10:30:07---------------------------------------------------



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

【RetValue】:【{"channelSeqId":"zhijian17rn_22048164505192425174","orderNo":"2202172472700111640","mobile":"19536379586","updateTime":1645151437810,"activityTime":1645151406000,"status":1035,"statusDesc":"","shipmentNumber":"JDV005757261631","shipmentCompanyName":"京东快递"}】

【shipmentNumber】:【JDV005757261631】

【sql_1】:【 update [HaoKa].[Orders] set ExpressNo='JDV005757261631',ExpressName='京东快递',ExpressTime='2022-02-18 10:30:38',UpdateTime=GETDATE() where JTOrderId='2202172472700111640' 】

【sql_2】:【 update [HaoKa].[Orders] set IsActive=1,ActiveTime='2022-02-18 10:30:06',UpdateTime=GETDATE() where JTOrderId='2202172472700111640' 】
----------------------------------------------------------2022/2/18 10:30:38---------------------------------------------------