From e282b39a750d245f86a08194a6f4d02d545232ef Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期五, 01 十一月 2024 10:47:36 +0800
Subject: [PATCH] 历史数据导入码值查重条件加上版次条件
---
Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java
index c99ba21..4129fb2 100644
--- a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java
+++ b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java
@@ -20,8 +20,13 @@
List<String> selectById(@Param("inSql") String inSql);
+ List<String> selectList(@Param("inSql") String inSql);
- int queryCountBySql(@Param("inSql") String inSql);
+ int queryCountBySql(@Param("inSql") String inSql);
+
+ String queryCountStringBySql(@Param("inSql") String inSql);
+
+ String selectCountByTableName(@Param("tableName") String tableName);
List<Map> selectBySql(@Param("inSql") String inSql);
@@ -35,6 +40,7 @@
* @return 鎻掑叆鎴愬姛鐨勬潯鏁�
*/
Integer insertByBaseModel(String tableName,Map<String,String> columnMap,List<Map<String,String>> mapList);
+
/**
* 浼犲叆琛ㄥ悕锛宮ap锛宭ist<map>瀹屾垚鎵归噺鏇存柊鎿嶄綔
* @param tableName 琛ㄥ悕
@@ -52,4 +58,16 @@
*/
Integer deleteByTaleAndOid(String tableName,String oids);
+ /**
+ * 浼犲叆琛ㄥ悕锛宯ameoid鑾峰彇鏂扮殑鐗堟湰鍙风瓑
+ * @param tableName
+ * @param nameoid
+ * @return
+ */
+ Map<String,Object> getNextRevision(@Param("tableName")String tableName,@Param("nameoid") String nameoid);
+
+ Map<String,Object> getCurrentRevision(@Param("tableName")String tableName,@Param("nameoid") String nameoid);
+
+ // Integer updateByTaleAndOid(@Param("tableName")String tableName, @Param("nameoid") String nameoid, @Param("lcStatus") String lcStatus);
+
}
--
Gitblit v1.9.3