/*更新机票订单的订单号 wenyue_chi*/
update T_ER_PLANEBILL set fordernum = fparentOrderNum ||'-'|| ftravelername ||'-'|| ftoCityName ||'-'|| forderType ,FTOTALAMOUNT=0 where fisreconciliation=0 and FSERVER='XIECHENG';
/*更新机票订单对应订单总表的订单号 wenyue_chi*/
UPDATE t_er_allorderbill a set FORDERNUM =(select FORDERNUM  from T_ER_PLANEBILL p where  fisreconciliation=0 and FSERVER='XIECHENG' and p.fid=a.FORDERID) ,FTOTALAMOUNT=0 where  FORDERID in (select fid from t_er_planebill where fisreconciliation=0 and FSERVER='XIECHENG');