//修改付款处理为变更中的数据 未确认
update T_CAS_PaymentBill_e set fchangestatus='changing' where fchangestatus='unchange' and fid in (select  fsourcebillid from t_cas_paychgbill where fsourcetype='cas_paybill' and fiscashconfirm='0')

//修改付款处理为变更中的数据 已确认
update T_CAS_PaymentBill_e set fchangestatus='changed' where fchangestatus='unchange' and fid in (select  fsourcebillid from t_cas_paychgbill where fsourcetype='cas_paybill' and fiscashconfirm='1') and
 fid not in (select  fsourcebillid from t_cas_paychgbill where fsourcetype='cas_paybill' and fiscashconfirm='0')

//修改代发单为变更中的数据 未确认
update T_CAS_AgentPayBill_e set fchangestatus='changing' where fchangestatus='unchange' and fid in (select  fsourcebillid from t_cas_paychgbill where fsourcetype='cas_agentpaybill' and fiscashconfirm='0')

//修改代发单为变更中的数据 已确认
update T_CAS_AgentPayBill_e set fchangestatus='changed' where fchangestatus='unchange' and fid in (select  fsourcebillid from t_cas_paychgbill where fsourcetype='cas_agentpaybill' and fiscashconfirm='1') and
fid not in (select  fsourcebillid from t_cas_paychgbill where fsourcetype='cas_agentpaybill' and fiscashconfirm='0')
