From 0184bf471382f9328df9bdd47acf451e4e2c5cb0 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期三, 11 六月 2025 13:57:37 +0800
Subject: [PATCH] 达梦数据库及数据库脚本

---
 medicalWaste-system/src/main/java/com/sinata/system/mapper/SysDepartmentMapper.java |   66 +++++++++++++++++++++++++++++++--
 1 files changed, 62 insertions(+), 4 deletions(-)

diff --git a/medicalWaste-system/src/main/java/com/sinata/system/mapper/SysDepartmentMapper.java b/medicalWaste-system/src/main/java/com/sinata/system/mapper/SysDepartmentMapper.java
index 40b01f1..efd72b8 100644
--- a/medicalWaste-system/src/main/java/com/sinata/system/mapper/SysDepartmentMapper.java
+++ b/medicalWaste-system/src/main/java/com/sinata/system/mapper/SysDepartmentMapper.java
@@ -1,7 +1,10 @@
 package com.sinata.system.mapper;
 
-import com.sinata.system.domain.SysDepartment;
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.sinata.system.domain.SysDepartment;
+import com.sinata.system.domain.vo.DisposalUnitVO;
+import com.sinata.system.domain.vo.MedicalInstitutionVO;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
@@ -18,10 +21,65 @@
 @Mapper
 public interface SysDepartmentMapper extends BaseMapper<SysDepartment> {
     /**
-     * 根据类型查询用户区域列表
+     * 查询用户区域列表
      * @param userId
-     * @param type
      * @return
      */
-    List<SysDepartment> getDepartmentListByType(@Param("userId") Long userId, @Param("type") Integer type);
+    SysDepartment getDepartmentByUserId(@Param("userId") Long userId);
+
+    /**
+     * 根据类型查询机构列表
+     *
+     * @param medicalInstitutionVOPage
+     * @param departmentName
+     * @param contactPerson
+     * @param contactPhone
+     * @param treeCode
+     * @return
+     */
+    Page<MedicalInstitutionVO> pageMedicalList(Page<MedicalInstitutionVO> medicalInstitutionVOPage, @Param("departmentName") String departmentName, @Param("contactPerson") String contactPerson, @Param("contactPhone") String contactPhone, @Param("treeCode") String treeCode);
+
+    /**
+     * 查询医疗机构详情
+     *
+     * @param id
+     * @return
+     */
+    MedicalInstitutionVO getMedicalDetailById(Long id);
+
+    /**
+     * 根据treeCode查询处置单位列表
+     *
+     * @param treeCode
+     * @return
+     */
+    List<DisposalUnitVO> getDisposalUnitListByTreeCode(String treeCode);
+
+    /**
+     * 处置单位分页列表
+     *
+     * @param page
+     * @param departmentName
+     * @param contactPerson
+     * @param contactPhone
+     * @param treeCode
+     * @return
+     */
+    Page<DisposalUnitVO> pageRegulatoryUnitList(Page<DisposalUnitVO> page, @Param("departmentId") Long departmentId, @Param("departmentName") String departmentName, @Param("contactPerson") String contactPerson, @Param("contactPhone") String contactPhone, @Param("treeCode") String treeCode);
+
+    /**
+     * 处置单位详情
+     *
+     * @param id
+     * @return
+     */
+    DisposalUnitVO getDisposalUnitDetailById(@Param("id") Long id);
+
+    /**
+     * 路线关联医院列表
+     *
+     * @param id
+     * @return
+     */
+    List<MedicalInstitutionVO> getHospitalListByRouteId(@Param("id") Long id);
 }

--
Gitblit v1.7.1