|  |  | 
 |  |  |  | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.Device; | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.DeviceChannel; | 
 |  |  | import com.genersoft.iot.vmp.vmanager.platform.bean.ChannelReduce; | 
 |  |  | import com.genersoft.iot.vmp.vmanager.gb28181.platform.bean.ChannelReduce; | 
 |  |  | import org.apache.ibatis.annotations.Delete; | 
 |  |  | import org.apache.ibatis.annotations.Insert; | 
 |  |  | import org.apache.ibatis.annotations.Mapper; | 
 |  |  | 
 |  |  |     int delChannelForGB(String platformId, List<ChannelReduce> channelReducesToDel); | 
 |  |  |  | 
 |  |  |     @Delete("<script> "+ | 
 |  |  |             "DELETE FROM platform_gb_channel WHERE deviceId='${deviceId}' " + | 
 |  |  |             "</script>") | 
 |  |  |     int delChannelForDeviceId(String deviceId); | 
 |  |  |  | 
 |  |  |     @Delete("<script> "+ | 
 |  |  |             "DELETE FROM platform_gb_channel WHERE platformId='${platformId}'"  + | 
 |  |  |             "</script>") | 
 |  |  |     int cleanChannelForGB(String platformId); |