From 0ec69e2b1479f42f02dfae587aee3fab7a648883 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期二, 27 二月 2024 11:30:58 +0800
Subject: [PATCH] zjh 本地 2024/02/27 -1
---
ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java
index 169db50..e510f0c 100644
--- a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java
+++ b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java
@@ -1,11 +1,15 @@
package com.ltkj.system.mapper;
+import java.sql.ResultSet;
import java.util.List;
+import java.util.Map;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.core.domain.TreeSelect;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import com.ltkj.common.core.domain.entity.SysDept;
+import org.apache.ibatis.annotations.Select;
/**
* 閮ㄩ棬绠＄悊 鏁版嵁灞�
@@ -21,6 +25,10 @@
* @return 閮ㄩ棬淇℃伅闆嗗悎
*/
public List<SysDept> selectDeptList(SysDept dept);
+
+
+ @Select("SELECT * FROM v_tj_deptpro")
+ public List<SysDept> selectDeptTreeList1();
/**
* 鏍规嵁瑙掕壊ID鏌ヨ閮ㄩ棬鏍戜俊鎭�
@@ -118,4 +126,20 @@
* @return 缁撴灉
*/
public int deleteDeptById(Long deptId);
+
+ @Select(" SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.dept_name like concat('%',#{deptName},'%')")
+ List<String> getSysDeptId(String deptName);
+
+
+ @Select("call pro_tjhzlb_list(#{deptid,mode=IN},#{tjname,mode=IN},#{tjNumber,mode=IN},#{type,mode=IN},#{page,mode=IN},#{pageSize,mode=IN})")
+ ResultSet getSysDeptYjWjCustomerList(@Param("deptid")String deptid, @Param("tjname") String tjname, @Param("tjNumber") String tjNumber,
+ @Param("type")int type, @Param("page") int page , @Param("pageSize") int pageSize);
+
+ List<Map<String, Object>> getSysDeptYjWjCustomerList1(Map<String,Object> map);
+
+ List<List<?>> getSysDeptYjWjCustomerList13(Map<String,Object> map);
+
+ List<List<?>> getSysDeptHyAndYxYjWjCustomerList13(Map<String,Object> map);
+
+ List<ResultSet> getSysDeptYjWjCustomerList2(Map<String,Object> map);
}
--
Gitblit v1.8.0