电磁锁根据三一车辆主键删除提交

zhangnaisong

2024-07-02 d85713cca5443547a7d4646d4e80abfce136eff8

电磁锁根据三一车辆主键删除提交

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

@@ -162,6 +162,16 @@
    }

    /**
     * 根据car_id删除电磁锁
     */
    @ApiOperation("根据car_id删除电磁锁")
    @PreAuthorize("@ss.hasPermi('sy:lock:deleteLockByCarId')")
    @PostMapping("/deleteLockByCarId")
    public AjaxResult deleteLockByCarId(@RequestBody ArdTankLock ardTankLock) {
        return toAjax(ardTankLockService.deleteLockByCarId(ardTankLock.getCarId()));
    }

    /**
     * 新增电子围栏
     */
    @ApiOperation("新增电子围栏")

 ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLockMapper.java

@@ -65,4 +65,6 @@
    public int insertArdTankLocks(@Param("ardTankLocks") List<ArdTankLock> ardTankLocks);

    public List<ArdTankLock> getLockByCarId(String carId);

    public int deleteLockByCarId(String carId);
}

 ard-work/src/main/java/com/ruoyi/sy/service/IArdTankLockService.java

@@ -67,4 +67,6 @@
    public List<Map<String,Object>> getAll(String usersId);

    public Map<String, Object> getLockByCarId(String carId,String usersId);

    public int deleteLockByCarId(String carId);
}

 ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankLockServiceImpl.java

@@ -272,4 +272,10 @@
        resultMap.put("lockList",result);
        return resultMap;
    }

    @Override
    public int deleteLockByCarId(String carId) {
        int result = ardTankLockMapper.deleteLockByCarId(carId);
        return result;
    }
}

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

@@ -111,4 +111,8 @@
    <select id="getLockByCarId" resultMap="ArdTankLockResult" parameterType="java.lang.String">
        select * from ard_tank_lock atl where car_id = #{carId} order by atl.lock_num
    </select>

    <delete id="deleteLockByCarId" parameterType="java.lang.String">
        delete from ard_tank_lock where car_id = #{carId}
    </delete>
</mapper>