@Override
public void delAftMonDate(String[] keyvalues,String company) {
String FLEET_CD="";
String FLEET_NM="";
if(company.equals("2c90e4b4407832750140784989a90002")){//散货
FLEET_CD="B00";
FLEET_NM="Bulk Carrier";
}else if(company.equals("2c90e4b44078327501407848fc290001")){//油轮
FLEET_CD="T00";
FLEET_NM="Oil Tanker";
}else{//所有
FLEET_CD="L00";
FLEET_NM="LNG VESSEL";
}
String sql1="delete from SH_STATE_APPROVAL where fileid='"+keyvalues[0]+"'";
String sql2="delete from SH_STATE_BACKUP where fleet_cd='"+FLEET_CD+"' AND to_char(state_time,'yyyy-MM')='"+getAfterDate().substring(0, 7)+"' and target_cd !='DailyTCE' and target_cd != 'OperationDay' ";
String sql3="delete from XT_Document where ReferenceID='"+keyvalues[0]+"'";
String sql4="delete from XT_FileAgent where FileID='"+keyvalues[0]+"'";
String sql5="delete from XT_FileAuth where FileID='"+keyvalues[0]+"'";
String sql6="delete from XT_FileFlowPassed where FileID='"+keyvalues[0]+"'";
String sql7="delete from XT_FileProperty where FileID='"+keyvalues[0]+"'";
String sql8="delete from XT_FileRead where FileID='"+keyvalues[0]+"'";
String sql9="delete from XT_FileReference where FileID='"+keyvalues[0]+"'";
String sql10="delete from XT_FolderRef where RefNo='"+keyvalues[0]+"'";
String sql11="delete from XT_Hurry where FileID='"+keyvalues[0]+"'";
String sql12="delete from XT_Notice where FileID='"+keyvalues[0]+"'";
String sql13="delete from XT_Trace where FileID='"+keyvalues[0]+"'";
super.updateData(sql1);
super.updateData(sql2);
super.updateData(sql3);
super.updateData(sql4);
super.updateData(sql5);
super.updateData(sql6);
super.updateData(sql7);
super.updateData(sql8);
super.updateData(sql9);
super.updateData(sql10);
super.updateData(sql11);
super.updateData(sql12);
super.updateData(sql13);
}
