更新设备接口

whycxzp

2021-03-31 ef84750a244f338a523fe7924d585ffef9e720c5

更新设备接口

 src/main/java/com/whyc/service/DeviceManageService.java

@@ -9,6 +9,7 @@
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.DeviceManageMapper;
import com.whyc.pojo.DeviceMaintain;
import com.whyc.pojo.DeviceManage;
import org.springframework.stereotype.Service;


 src/main/resources/mapper/DeviceManageMapper.xml

@@ -43,7 +43,7 @@
        select manage.*,type.device_type_id,type.device_type_name from db_experiment.tb_device_manage manage,db_experiment.tb_device_type type
        where manage.device_type_id = type.device_type_id
        <if test="createTime!=null">
            and DATE_FORMAT(manage.create_time,'%Y-%m-%d')=#{createTime}
            and manage.create_time =DATE_FORMAT(#{createTime},'%Y-%m-%d')
        </if>
        <if test="deviceTypeId!=null and deviceTypeId!=0">
            and manage.device_type_id=#{deviceTypeId}