From 46444efb4a1995b31aa0196ce193887a400198ce Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 26 三月 2025 10:50:49 +0800
Subject: [PATCH] zjh20250326

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java |    7 +++++--
 1 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
index e9e0070..494690f 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
@@ -234,9 +234,9 @@
 
 
     @Select("SELECT \n" +
-            "    '1' AS xh, " +
+            "    ROW_NUMBER() OVER (ORDER BY d.djd_num) AS xh, " +
             "    REPLACE(d.dept_name, '闂ㄨ瘖', '') AS ksmc,\n" +
-            "    d.official_web AS ksdz,\n" +
+            "    ifnull(d.official_web,'') AS ksdz,\n" +
             "    e.tjxm,\n" +
             "    e.tjjg\n" +
             "FROM sys_dept d\n" +
@@ -386,4 +386,7 @@
             "  a.deleted = 0 \n" +
             "  AND b.org_type = 2 \n")
     List<String> getJianChaTjNum();
+
+
+    List<List<?>> getYxJcList(Map<String,Object> map);
 }

--
Gitblit v1.8.0