From 43727df73e52cc00a1f1aee3c20a1aec8db1b92f Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 27 二月 2025 08:45:25 +0800
Subject: [PATCH] 修改查询

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java |   39 +++++++++++++++++++++++++++++++++++++++
 1 files changed, 39 insertions(+), 0 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
index 2ef8bbd..a45d2e8 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
@@ -2,6 +2,7 @@
 
 import java.math.BigDecimal;
 import java.util.List;
+import java.util.Map;
 
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.ltkj.hosp.domain.TjProject;
@@ -103,4 +104,42 @@
 
     List<TjProject> getProBySqlAndName(String proName,String checkType,String deptId);
 
+    List<TjProject> getTjProListByPacIdAndDeptId(String pacId);
+
+    List<TjProject> getAllChildListById(String proId);
+
+    List<TjProject> getTjProjectList();
+    List<TjProject> getDxTjProjectList();
+
+    List<TjProject> getOpenDxTjProjectList(String nr);
+
+    List<TjProject> getPacTjProjectList();
+
+
+    List<Long> getHuaYanProId();
+
+    List<Long> getYingXiangProId();
+
+    List<Long> getHuaYanKsProId(String ksId);
+
+    List<Long> getNotCcCtXdtProId();
+
+
+    List<Long> getNneedReprotProId();
+
+
+    List<TjProject> getTjProjectListByTbTransition(String proParentId, String tjNumber);
+
+    //鏍规嵁椤圭洰鍚嶆ā绯婃悳绱綋妫�鍙�
+    List<String> getTjNumLIstByXmmx(String xmmc);
+
+    List<Map<String,Object>> tjCsXmjgcx(String tjNum, String proId);
+
+    List<Map<String,Object>> getTjproGzJy(String tjNum, String proId,String gzz,int cgorjyjc);
+
+
+    Map<String,Object> getTjHyBgList(Integer page,Integer pageSize,String pname,String pid,String pym,String checktype);
+
+    List<Map<String, Object>> zdysqlcx(String sql);
+    void zdysqlxg(String sql);
 }

--
Gitblit v1.8.0