删除流程数据

最新推荐文章于 2023-08-03 16:26:50 发布

fenyu8

最新推荐文章于 2023-08-03 16:26:50 发布

阅读量432

点赞数

分类专栏：公司平台学习

本文链接：https://blog.csdn.net/fenyu8/article/details/77749873

版权

公司平台学习专栏收录该内容

32 篇文章 0 订阅

订阅专栏

		@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);
		}