From 60ade5154522a042c816abaa1840751011ae0371 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 29 九月 2026 19:15:03 +0800
Subject: [PATCH] 1.省立同德满度问题处理 2.门急诊数据采集优化
---
smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java b/smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java
index bf12d7c..90bb456 100644
--- a/smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java
@@ -1,5 +1,6 @@
package com.smartor.mapper;
+import java.util.Collection;
import java.util.List;
import java.util.Map;
@@ -38,6 +39,11 @@
* 鍒ゆ柇鎸囧畾鍒嗚〃涓槸鍚﹀瓨鍦ㄨ id
*/
int existsInTable(@Param("tableName") String tableName, @Param("id") Long id);
+
+ /**
+ * 鎸� serialnum 鏌ヨ鎸囧畾鍒嗚〃涓槸鍚﹀凡瀛樺湪璇ヨ褰曪紝鐢ㄤ簬鎻掑叆鍓嶅幓閲�
+ */
+ int countBySerialnum(@Param("tableName") String tableName, @Param("serialnum") String serialnum);
/**
* 鏇存柊鍒版寚瀹氬垎琛紙鐢ㄤ簬璺敱鍒版纭垎琛級
@@ -85,6 +91,15 @@
// 鏌ヨ鎵�鏈� pat_med_outhosp 寮�澶寸殑琛ㄥ悕
List<String> getAllOuthospTableNames();
+ /**
+ * 鎵归噺鏌ヨ鎸囧畾鍒嗚〃涓凡瀛樺湪鐨� serialnum锛堜竴娆� SQL 浠ｆ浛閫愭潯 countBySerialnum锛�
+ *
+ * @param tableName 鍒嗚〃鍚�
+ * @param serialnums 寰呮煡璇㈢殑璇婄枟璁板綍鍙�
+ * @return 宸插瓨鍦ㄧ殑 serialnum 闆嗗悎
+ */
+ List<String> selectExistingSerialnums(@Param("tableName") String tableName, @Param("serialnums") Collection<String> serialnums);
+
// 鏌ヨ鎸囧畾琛ㄧ殑瀛楁鍒楄〃锛堟寜 ordinal_position 鎺掑簭锛�
List<String> getTableColumns(@Param("tableName") String tableName);
--
Gitblit v1.9.3