| | |
| | | |
| | | List<DeviceConfigDtoPage> selectDataConfigList(Integer deviceId); |
| | | |
| | | List<DataConfig> deleteDataConfig(); |
| | | List<Integer> deleteDataConfig(); |
| | | } |
| | |
| | | |
| | | List<DeviceConfigDtoPage> selectDataConfigList(Integer deviceId); |
| | | |
| | | List<DataConfig> deleteDataConfig(); |
| | | void deleteDataConfig(); |
| | | } |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<DataConfig> deleteDataConfig() { |
| | | return dataConfigMapper.deleteDataConfig(); |
| | | public void deleteDataConfig() { |
| | | List<Integer> integers = dataConfigMapper.deleteDataConfig(); |
| | | if (!integers.isEmpty()) { |
| | | dataConfigMapper.deleteBatchIds(integers); |
| | | } |
| | | } |
| | | } |
| | |
| | | where d.id = #{deviceId} |
| | | </select> |
| | | |
| | | <select id="deleteDataConfig" resultType="com.yuanchu.mom.pojo.DataConfig"> |
| | | SELECT ddc.* |
| | | <select id="deleteDataConfig" resultType="integer"> |
| | | SELECT ddc.id |
| | | FROM device d |
| | | left join structure_item_parameter ip on not FIND_IN_SET(ip.id, d.ins_product_ids) |
| | | inner join device_data_config ddc on ddc.device_id = d.id and ddc.structure_item_parameter_id = ip.id |