电磁锁电子围栏分页查询及根据主键查询提交

zhangnaisong

2024-07-04 4b8bdee03a2469a0260611f4f06d26ef16c5383c

电磁锁电子围栏分页查询及根据主键查询提交

 ard-work/src/main/java/com/ruoyi/sy/controller/ArdTankLockController.java

@@ -212,11 +212,27 @@
        return toAjax(ardTankWallService.deleteArdTankWallById(id));
    }

    @ApiOperation("查询全部电子围栏")
    /*@ApiOperation("查询全部电子围栏")
    @PreAuthorize("@ss.hasPermi('sy:lock:getAllArdTankWall')")
    @GetMapping("/getAllArdTankWall")
    public Results getAllArdTankWall() {
        List<ArdTankWall> result = ardTankWallService.getAllArdTankWall();
        return Results.succeed(result);
    }*/

    @ApiOperation("查询全部电子围栏")
    @PreAuthorize("@ss.hasPermi('sy:lock:getAllArdTankWall')")
    @PostMapping("/getAllArdTankWall")
    public TableDataInfo getAllArdTankWall(@RequestBody ArdTankWall ardTankWall) {
        startPage();
        List<ArdTankWall> list = ardTankWallService.selectArdTankWallList(ardTankWall);
        return getDataTable(list);
    }

    @ApiOperation("根据主键获取电磁锁电子围栏")
    @PreAuthorize("@ss.hasPermi('sy:tankWall:getArdTankWallById')")
    @GetMapping(value = "/getArdTankWallById/{id}")
    public AjaxResult getArdTankWallById(@PathVariable String id) {
        return success(ardTankWallService.selectArdTankWallById(id));
    }
}

 ard-work/src/main/resources/mapper/sy/ArdTankWallMapper.xml

@@ -20,6 +20,7 @@
            <if test="wallName != null  and wallName != ''"> and wall_name like '%'||#{wallName}||'%'</if>
            <if test="wallPoi != null  and wallPoi != ''"> and wall_poi = #{wallPoi}</if>
        </where>
        order by wall_name
    </select>
    
    <select id="selectArdTankWallById" parameterType="String" resultMap="ArdTankWallResult">