bjtom 发表于 2019-9-17 11:55:45

E3_订单管理_订单管理_销售订单列表,当当订单现在是问题单初始状态,需要重新下载...

需要删除以下几个表的订单数据,然后重新下载即可
DELETE FROM order_info WHERE deal_code='交易号';
DELETE FROM order_goods where deal_code='交易号';
DELETE FROM order_info_ex WHERE deal_code='交易号';
DELETE FROM order_deal_code WHERE deal_code='交易号';
DELETE FROM fms_opm_lsjsd WHERE dtdh=(select order_sn from order_info where deal_code='交易号');
DELETE FROM dangdang_trade WHERE deal_code='交易号';
DELETE FROM dangdang_items WHERE deal_code='交易号'
页: [1]
查看完整版本: E3_订单管理_订单管理_销售订单列表,当当订单现在是问题单初始状态,需要重新下载...