| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | */ |
| | | public Integer deletes(List<Integer> list) { |
| | | String ids = StringHelper.join(list, ","); |
| | | |
| | | String sql = null; |
| | | List<MetaEntity> metas = selectByIdsForTab(ids); |
| | | if (null != metas && metas.size() > 0) { |
| | | sql = getDelTabsSql(metas); |
| | | } |
| | | |
| | | return deletes(sql, ids); |
| | | } |
| | | |
| | | /** |
| | | * 获取删除表记录SQL |
| | | */ |
| | | private String getDelTabsSql(List<MetaEntity> metas) { |
| | | List<String> list = new ArrayList<>(); |
| | | for (MetaEntity me : metas) { |
| | | list.add(String.format("delete from %s where parentid='%s'", me.getTab(), me.getEventid())); |
| | | } |
| | | |
| | | return StringHelper.join(list, ";"); |
| | | } |
| | | } |