diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
index 2705256..d974fcd 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
@@ -195,13 +195,13 @@
         SELECT id,
                devcode,
                deviceName,
-               device_Type,
+               deviceType,
                deviceTypeName,
                wellId,
                deptid,
                wellCode,
                POSITION,
-               CASE WHEN 	bds.ONLINE_STATE ='1' THEN 1 ELSE 0 END  AS "onlineState",
+               CASE WHEN 	bds.ONLINE_STATE <![CDATA[ <> ]]> '0' THEN 1 ELSE 0 END  AS "onlineState",
                coordinateX,
                coordinateY,
                latBaidu,
@@ -217,14 +217,14 @@
         SELECT id,
                devcode,
                deviceName,
-               device_type,
+               devicetype,
                deviceTypeName,
                wellId,
                deptid,
                deptName,
                wellCode,
                POSITION as position,
-              CASE WHEN 	bds.ONLINE_STATE ='1' THEN 1 ELSE 0 END  AS "onlineState",
+              CASE WHEN 	bds.ONLINE_STATE  <![CDATA[ <> ]]> '0' THEN 1 ELSE 0 END  AS "onlineState",
                coordinateX,
                coordinateY,
                latBaidu,