台账增加设备类型查询参数

yangys

2024-01-24 32babad4205b76b3a8983a262155c49ad4e30bf6

台账增加设备类型查询参数

 mdc-parent/mdc-show/src/main/java/com/qianwen/mdc/controller/account/MachineAccountQueryController.java

@@ -13,7 +13,6 @@
import org.springframework.web.bind.annotation.RequestBody;

import org.springframework.web.bind.annotation.RequestHeader;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.bind.annotation.RestController;



import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


 mdc-parent/mdc-show/src/main/java/com/qianwen/mdc/dto/account/MachineAccountQueryDTO.java

@@ -49,6 +49,10 @@
    

    private String remark;



    /**

     * 设备类型

     */

    private Long deviceTypeId;

    

    public String getUuid() {

        return uuid;

@@ -130,6 +134,14 @@
    public void setSpecification(String specification) {

        this.specification = specification;

    }



    public Long getDeviceTypeId() {

        return deviceTypeId;

    }



    public void setDeviceTypeId(Long deviceTypeId) {

        this.deviceTypeId = deviceTypeId;

    }

    

    




 mdc-parent/mdc-showdb-mysql/src/main/resources/mapper/MachineAccountMapper.xml

@@ -96,6 +96,9 @@
         <if test="dto.manageType != null and dto.manageType != ''">

            and a.manage_type = #{dto.manageType}

         </if>

         <if test="dto.deviceTypeId != null">

            and a.device_type_id = #{dto.deviceTypeId}

         </if>

         

        </where>

    </select>