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