| | |
| | | pids.add("'" + me.getEventid() + "'"); |
| | | } |
| | | } |
| | | |
| | | if (pids.size() > 0) { |
| | | list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ","))); |
| | | } |
| | | |
| | | // 关联删除 |
| | | int i = 0, c = list.size(); |
| | | while (i < c) { |
| | | String str = list.get(i); |
| | | if (str.contains("bs.m_pipelinepoint")) { |
| | | list.add(str.replace("bs.m_pipelinepoint", "bs.m_pipesegment")); |
| | | list.add(str.replace("bs.m_pipelinepoint", "bs.m_pipeline")); |
| | | } |
| | | if (str.contains("bs.s_explorationpoint")) { |
| | | list.add(str.replace("bs.s_explorationpoint", "bs.s_surveyworksite")); |
| | | } |
| | | |
| | | i++; |
| | | } |
| | | |
| | | return StringHelper.join(list, ";"); |
| | | } |
| | | |