From 6659135780e718758417efde4c8c351c69e3755b Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期四, 11 十二月 2025 15:52:19 +0800
Subject: [PATCH] 代码提交
---
smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 50 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 c5e0a27..b80f83e 100644
--- a/smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/PatMedOuthospMapper.java
@@ -6,6 +6,7 @@
import com.smartor.domain.PatMedReq;
import com.smartor.domain.PatMedRes;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
/**
* 鎮ｈ�呴棬璇婅褰昅apper鎺ュ彛
@@ -39,6 +40,16 @@
*/
public int insertPatMedOuthosp(PatMedOuthosp patMedOuthosp);
+ public int batchPatMedOuthosp(List<PatMedOuthosp> patMedOuthosps);
+
+ /**
+ * 鎵归噺鎻掑叆锛屽拷鐣ラ噸澶嶏紙INSERT IGNORE锛�
+ *
+ * @param patMedOuthosps 闂ㄦ�ヨ瘖璁板綍鍒楄〃
+ * @return 瀹為檯鎻掑叆鏁伴噺
+ */
+ public int batchInsertIgnore(List<PatMedOuthosp> patMedOuthosps);
+
/**
* 淇敼鎮ｈ�呴棬璇婅褰�
*
@@ -64,4 +75,43 @@
public int deletePatMedOuthospByIds(Long[] ids);
PatMedRes selectPatMedOuthospCount(PatMedReq patMedReq);
+
+ public List<PatMedRes> getDeptRanking(PatMedReq patMedReq);
+
+ /**
+ * 鑾峰彇琛ㄧ殑鏁伴噺
+ *
+ * @return
+ */
+ int countPatMedOuthosp();
+
+ /**
+ * 淇敼琛ㄥ悕
+ *
+ * @return
+ */
+ void renameTable(@Param("oldName") String oldName, @Param("newName") String newName);
+
+ /**
+ * 鍒涘缓鏂拌〃
+ *
+ * @param templateName
+ * @param newName
+ */
+ void createPatMedOuthosp(@Param("templateName") String templateName, @Param("newName") String newName);
+
+ void createPatMedOuthospAutoAdd(@Param("newName") String newName);
+
+
+ void setAutoIncrement(@Param("tableName") String tableName, @Param("autoInc") long autoInc);
+
+ // 鏌ヨ鎵�鏈� pat_med_outhosp 寮�澶寸殑琛ㄥ悕
+ List<String> getAllOuthospTableNames();
+
+ // 鏌ヨ鎸囧畾琛ㄧ殑鏈�澶d
+ Long getMaxIdFromTable(@Param("tableName") String tableName);
+
+ void createOrReplaceView(@Param("viewSql") String viewSql);
}
+
+
--
Gitblit v1.9.3