From 47f1f14d7788b0baf4578d3aaa5b9f989ee65210 Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期三, 31 一月 2024 16:36:52 +0800
Subject: [PATCH] 首页统计功能查询判断为空增加
---
Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/mapper/CommonsMapper.java | 21 +++++++++++++++++++++
1 files changed, 21 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 1de1374..2f22a7a 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,14 @@
List<String> selectById(@Param("inSql") String inSql);
+ List<String> selectList(@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);
@@ -32,6 +40,7 @@
* @return 鎻掑叆鎴愬姛鐨勬潯鏁�
*/
Integer insertByBaseModel(String tableName,Map<String,String> columnMap,List<Map<String,String>> mapList);
+
/**
* 浼犲叆琛ㄥ悕锛宮ap锛宭ist<map>瀹屾垚鎵归噺鏇存柊鎿嶄綔
* @param tableName 琛ㄥ悕
@@ -49,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