ard-inspection/src/main/java/com/ard/inspection/mapper/ArdPointCloudMapper.java
@@ -61,9 +61,9 @@ public ArdPointCloud selectArdPointCloudByFileName(String fileName); // /** // * 根据航线ID,查询航线名称 // */ // public int selectCloudIdByRouteName(ArdPointCloud ardPointCloud); /** * 根据航线ID,查询航线名称 */ public List<ArdPointCloud> selectArdPointCloudNotList(String[] ids); } ard-inspection/src/main/java/com/ard/inspection/service/IArdPointCloudService.java
@@ -61,4 +61,6 @@ public ArdPointCloud selectArdPointCloudByFileName(String filename); public List<ArdPointCloud> selectArdPointCloudNotList(String[] ids); } ard-inspection/src/main/java/com/ard/inspection/service/impl/ArdPointCloudServiceImpl.java
@@ -113,4 +113,9 @@ return ardPointCloudMapper.selectArdPointCloudByFileName(filename); } @Override public List<ArdPointCloud> selectArdPointCloudNotList(String[] ids) { return ardPointCloudMapper.selectArdPointCloudNotList(ids); } } ard-inspection/src/main/resources/mapper/ArdPointCloudMapper.xml
@@ -162,9 +162,12 @@ where file_name = #{fileName} </select> <!-- <select id="selectCloudIdByRouteName" parameterType="String" resultMap="ArdPointCloudResult">--> <!-- <include refid="selectArdPointCloudRouteName"/>--> <!-- where file_name = #{fileName}--> <!-- </select>--> <select id="selectArdPointCloudNotList" parameterType="String" resultMap="ArdPointCloudResult"> <include refid="selectArdPointCloudVo"/> where id NOT IN <foreach item="id" collection="array" open="(" separator="," close=")"> #{id} </foreach> </select> </mapper>