From d2b45544842581d9f335f06dbad13da02ad5dd60 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期一, 23 三月 2026 18:20:44 +0800
Subject: [PATCH] 修改存储过程字段长度

---
 ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java |    4 ++--
 smartor/src/main/resources/mapper/smartor/PatMedOuthospMapper.xml     |    2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java
index d8cab10..e9655c3 100644
--- a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java
+++ b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java
@@ -220,11 +220,11 @@
                     // varchar / char / text 绛夊瓧绗︿覆绫诲瀷
                     if (dataType.contains("char") || dataType.contains("text") || dataType.contains("enum")) {
                         if (colName.equals("deptcode")) {
-                            activeParams.add(new Object[]{"p_" + colName, colName, "in", colType});
+                            activeParams.add(new Object[]{"p_" + colName, colName, "in", "TEXT"});
                             break;
                         }
                         if (colName.equals("hospitaldistrictcode")) {
-                            activeParams.add(new Object[]{"p_" + colName, colName, "in", colType});
+                            activeParams.add(new Object[]{"p_" + colName, colName, "in", "TEXT"});
                             break;
                         }
                         String kind = forceEqCols.contains(colName) ? "eq" : (eqPattern.matcher(colName).find() ? "eq" : "like");
diff --git a/smartor/src/main/resources/mapper/smartor/PatMedOuthospMapper.xml b/smartor/src/main/resources/mapper/smartor/PatMedOuthospMapper.xml
index 8a53951..39864b7 100644
--- a/smartor/src/main/resources/mapper/smartor/PatMedOuthospMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/PatMedOuthospMapper.xml
@@ -397,7 +397,7 @@
                 #{diagcheckFlag,          jdbcType=VARCHAR,  mode=IN},
                 #{fuflag,          jdbcType=VARCHAR,  mode=IN},
                 #{campusid,          jdbcType=VARCHAR,  mode=IN},
-                #{serverState,      jdbcType=VARCHAR,  mode=IN}
+                #{serverState,      jdbcType=VARCHAR,  mode=IN},
                 #{pageSize,      jdbcType=INTEGER,  mode=IN},
                 #{pageNum,       jdbcType=INTEGER,  mode=IN}
             )}

--
Gitblit v1.9.3