From 336eb77c1a07ca3e3ead4482b51f848fa16ab3b7 Mon Sep 17 00:00:00 2001
From: xiejun <xj@2023>
Date: 星期日, 12 十一月 2023 20:15:38 +0800
Subject: [PATCH] 自定义流水相关开发
---
Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java | 47 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 47 insertions(+), 0 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 e0354b9..3c18978 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
@@ -1,5 +1,6 @@
package com.vci.ubcs.code.mapper;
+import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;
@@ -19,6 +20,52 @@
List<String> selectById(@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);
+ List<Map<String,String>> queryByOnlySqlForMap(@Param("inSql") String inSql);
+
+ /**
+ * 浼犲叆琛ㄥ悕锛宮ap锛宭ist<map>瀹屾垚鎵归噺鏇存柊鎿嶄綔
+ * @param tableName 琛ㄥ悕
+ * @param columnMap 鍗曟潯map鐢ㄤ簬鑾峰彇key浣滀负瀛楁
+ * @param mapList 闇�瑕佹彃鍏ョ殑鎵�鏈夎褰�
+ * @return 鎻掑叆鎴愬姛鐨勬潯鏁�
+ */
+ Integer insertByBaseModel(String tableName,Map<String,String> columnMap,List<Map<String,String>> mapList);
+
+ /**
+ * 浼犲叆琛ㄥ悕锛宮ap锛宭ist<map>瀹屾垚鎵归噺鏇存柊鎿嶄綔
+ * @param tableName 琛ㄥ悕
+ * @param mapList 闇�瑕佹洿鏂扮殑鎵�鏈夎褰�
+ * @return 鎻掑叆鎴愬姛鐨勬潯鏁�
+ */
+ @InterceptorIgnore(tenantLine = "true")
+ Integer updateBatchByBaseModel(String tableName,List<Map<String,String>> mapList);
+
+ /**
+ * 浼犲叆琛ㄥ悕锛宮ap锛宱ids瀹屾垚鎵归噺鍒犻櫎鎿嶄綔
+ * @param tableName 琛ㄥ悕
+ * @param oids 闇�瑕佸垹闄ょ殑鎵�鏈夎褰�
+ * @return 鍒犻櫎鎴愬姛鐨勬潯鏁�
+ */
+ 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