From b5dd4841100d8d5d34fb0ff91caa7c77396d4d29 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Wed, 31 May 2023 16:36:46 +0800
Subject: [PATCH] 责任人管理列表sql修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java | 23 +++++++++++++++++++++++
1 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
index cf79edd..caf020e 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
+++ b/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);
+
}
--
Gitblit v1.9.3