责任人管理列表sql修改

xieb

2023-05-31 b5dd4841100d8d5d34fb0ff91caa7c77396d4d29

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java

@@ -1,6 +1,8 @@
package cn.gistack.sm.sjztmd.mapper;

import cn.gistack.sm.sjztmd.dto.AttResBaseUserDTO;
import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.vo.ManagePersonVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
@@ -21,4 +23,25 @@
    List<AttResBase> getListByRegion(IPage<AttResBase> page,@Param("obj") Map<String, Object> obj);

   AttResBase getDetailByCode(@Param("code") String code);

   /**
    * 获取水库对应责任人分页数据
    * @param params 条件查询参数对象
    * @param ad_code 行政区like条件
    * @param page 分页查询参数对象
    * @return
    */
   List<AttResBaseUserDTO> getAttResBaseUserPage(IPage<AttResBaseUserDTO> page,
                                      @Param("ad_code") String ad_code,
                                      @Param("params") Map<String, Object> params);

   /**
    * 查询各类型责任人
    * @param guid 水库 guid
    * @return
    */
   List<ManagePersonVO> getUserByResBaseGuid(@Param("guid") String guid);

   Boolean updateResBaseByGuid(@Param("attResBase") AttResBase attResBase);

}