From 10c2ee4be4508c62b5980cc7059b1e8e95f7a3cc Mon Sep 17 00:00:00 2001 From: ludc Date: 星期二, 04 七月 2023 17:22:11 +0800 Subject: [PATCH] Merge branch 'master' of http://dev.vci-tech.com:1065/r/ubcs --- Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java | 41 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 41 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 1b80ffd..4db0ed5 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,8 +1,10 @@ package com.vci.ubcs.code.mapper; +import com.baomidou.mybatisplus.annotation.InterceptorIgnore; import org.apache.ibatis.annotations.MapKey; import org.apache.ibatis.annotations.Param; +import java.util.List; import java.util.Map; /** @@ -16,6 +18,45 @@ @MapKey("count") Map<String,String> selectByCount(@Param("tableName") String tableName,@Param("oid") String oid,@Param("btm") String btm); + List<String> selectById(@Param("inSql") String inSql); + int queryCountBySql(@Param("inSql") String inSql); + + 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); } -- Gitblit v1.9.3