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 | 30 +++++++++++++++++++++++++++++-
1 files changed, 29 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 e2f6a78..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
@@ -20,6 +20,12 @@
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);
@@ -31,7 +37,9 @@
* @param mapList 闇�瑕佹彃鍏ョ殑鎵�鏈夎褰�
* @return 鎻掑叆鎴愬姛鐨勬潯鏁�
*/
- Integer insertByBaseModel(String tableName,Map<String,String> columnMap,List<Map<String,String>> mapList);/**
+ Integer insertByBaseModel(String tableName,Map<String,String> columnMap,List<Map<String,String>> mapList);
+
+ /**
* 浼犲叆琛ㄥ悕锛宮ap锛宭ist<map>瀹屾垚鎵归噺鏇存柊鎿嶄綔
* @param tableName 琛ㄥ悕
* @param mapList 闇�瑕佹洿鏂扮殑鎵�鏈夎褰�
@@ -40,4 +48,24 @@
@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