通道查询排序输出，避免列表杂乱无章

Lawrence

2021-01-14 fede5969f9322191b50db3a1c81e0c1707310c0f

通道查询排序输出，避免列表杂乱无章

 src/main/java/com/genersoft/iot/vmp/storager/dao/PatformChannelMapper.java

@@ -18,7 +18,7 @@
     */
    @Select("<script> "+
            "SELECT deviceAndChannelId FROM platform_gb_channel WHERE platformId='${platformId}' AND deviceAndChannelId in" +
            "<foreach collection='deviceAndChannelIds' open='(' item='id_' separator=',' close=')'> '${id_}'</foreach>" +
            "<foreach collection='deviceAndChannelIds' open='(' item='id_' separator=',' close=')'> '${id_}'</foreach> ORDER BY deviceAndChannelId ASC" +
            "</script>")
    List<String> findChannelRelatedPlatform(String platformId, List<String> deviceAndChannelIds);