diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml
index 618f499..26d0d55 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml
@@ -41,15 +41,6 @@
         CONCAT('%',#{keywords},'%')
     </sql>
 
-    <sql id="concat_sql" databaseId="oracle">
-         ${paramStr}
-    </sql>
-    <sql id="concat_sql" databaseId="mysql">
-        CONCAT(${paramStr})
-    </sql>
-    <sql id="concat_sql" databaseId="pgsql">
-        CONCAT(${paramStr})
-    </sql>
 
     <select id="getConfigList" resultType="map"
             parameterType="com.baomidou.mybatisplus.extension.plugins.pagination.Page">
@@ -62,19 +53,13 @@
         d.ID=c.DEVICE_ID LEFT JOIN base_device_type t ON
         d.DEVICE_TYPE=t.ID
         where d.VALID='1' AND b.VALID='1' AND a.VALID='1'
-        AND c.sensorid =
-        <include refid="concat_sql">
-            <property name="paramStr" value="#{sensorid}"/>
-        </include>
+        AND c.sensorid =#{sensorid}
         <if test="keywords != null and keywords !=''">
             and d.DEVCODE like
             <include refid="keywords_sql"/>
         </if>
         <if test="deptid != null and deptid !=''">
-            and s.ID =
-            <include refid="concat_sql">
-                <property name="paramStr" value="#{deptid}"/>
-            </include>
+            and s.ID =#{deptid}
         </if>
         ORDER by writetime DESC
     </select>
@@ -84,10 +69,7 @@
         b.CONCENCODE as "concenCode"
         FROM bus_concentrator b RIGHT JOIN bus_device_concentrator c ON b.id=c.CONCEN_ID
         where c.ACTIVE='1' and b.VALID='1'
-        and c.DEVICE_ID =
-        <include refid="concat_sql">
-            <property name="paramStr" value="#{devID}"/>
-        </include>
+        and c.DEVICE_ID =#{devID}
         limit 1
     </select>
 
@@ -96,10 +78,7 @@
         w.DEEP as "depth"
         FROM bus_well_info w RIGHT JOIN bus_device_well c ON w.id=c.WELL_ID
         WHERE c.VALID='1' AND w.VALID='1'
-        and c.DEVICE_ID =
-        <include refid="concat_sql">
-            <property name="paramStr" value="#{devID}"/>
-        </include>
+        and c.DEVICE_ID =#{devID}
         limit 1
     </select>
 

diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml
index 618f499..26d0d55 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusConfigMapper.xml
@@ -41,15 +41,6 @@
         CONCAT('%',#{keywords},'%')
     </sql>
 
-    <sql id="concat_sql" databaseId="oracle">
-         ${paramStr}
-    </sql>
-    <sql id="concat_sql" databaseId="mysql">
-        CONCAT(${paramStr})
-    </sql>
-    <sql id="concat_sql" databaseId="pgsql">
-        CONCAT(${paramStr})
-    </sql>
 
     <select id="getConfigList" resultType="map"
             parameterType="com.baomidou.mybatisplus.extension.plugins.pagination.Page">
@@ -62,19 +53,13 @@
         d.ID=c.DEVICE_ID LEFT JOIN base_device_type t ON
         d.DEVICE_TYPE=t.ID
         where d.VALID='1' AND b.VALID='1' AND a.VALID='1'
-        AND c.sensorid =
-        <include refid="concat_sql">
-            <property name="paramStr" value="#{sensorid}"/>
-        </include>
+        AND c.sensorid =#{sensorid}
         <if test="keywords != null and keywords !=''">
             and d.DEVCODE like
             <include refid="keywords_sql"/>
         </if>
         <if test="deptid != null and deptid !=''">
-            and s.ID =
-            <include refid="concat_sql">
-                <property name="paramStr" value="#{deptid}"/>
-            </include>
+            and s.ID =#{deptid}
         </if>
         ORDER by writetime DESC
     </select>
@@ -84,10 +69,7 @@
         b.CONCENCODE as "concenCode"
         FROM bus_concentrator b RIGHT JOIN bus_device_concentrator c ON b.id=c.CONCEN_ID
         where c.ACTIVE='1' and b.VALID='1'
-        and c.DEVICE_ID =
-        <include refid="concat_sql">
-            <property name="paramStr" value="#{devID}"/>
-        </include>
+        and c.DEVICE_ID =#{devID}
         limit 1
     </select>
 
@@ -96,10 +78,7 @@
         w.DEEP as "depth"
         FROM bus_well_info w RIGHT JOIN bus_device_well c ON w.id=c.WELL_ID
         WHERE c.VALID='1' AND w.VALID='1'
-        and c.DEVICE_ID =
-        <include refid="concat_sql">
-            <property name="paramStr" value="#{devID}"/>
-        </include>
+        and c.DEVICE_ID =#{devID}
         limit 1
     </select>
 
diff --git a/casic-server-support/src/main/java/com/casic/missiles/modular/system/model/BusConfig.java b/casic-server-support/src/main/java/com/casic/missiles/modular/system/model/BusConfig.java
index 4f496c4..245f54c 100644
--- a/casic-server-support/src/main/java/com/casic/missiles/modular/system/model/BusConfig.java
+++ b/casic-server-support/src/main/java/com/casic/missiles/modular/system/model/BusConfig.java
@@ -27,7 +27,7 @@
     /**
      * 主键
      */
-    @TableId(value = "ID", type = IdType.AUTO)
+    @TableId(value = "id", type = IdType.AUTO)
     private Long id;
     /**
      * 设备主键