From ed8c7a5effd0d423ce1118b680ecdca6fe732609 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 02 七月 2025 16:43:13 +0800
Subject: [PATCH] Merge branch 'master' of http://192.168.11.205:9000/r/P2022036_Service
---
src/main/java/com/lf/server/mapper/all/BasicMapper.java | 36 +++++++++++++++++++++++++++++++++---
1 files changed, 33 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/lf/server/mapper/all/BasicMapper.java b/src/main/java/com/lf/server/mapper/all/BasicMapper.java
index 75b3ff4..478a315 100644
--- a/src/main/java/com/lf/server/mapper/all/BasicMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/BasicMapper.java
@@ -1,6 +1,8 @@
package com.lf.server.mapper.all;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.lf.server.entity.sys.AttachEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -13,13 +15,41 @@
*/
public interface BasicMapper<T> extends BaseMapper<T> {
/**
- * 妯＄硦鎼滅储
+ * 妯＄硦鎼滅储瀛楁
*
* @param tab 琛ㄥ悕
* @param field 瀛楁
* @param value 鍊�
* @return 缁撴灉鍒楄〃
*/
- @Select("select ${field} from ${tab} where ${field} like #{value} order by ${field} limit 10")
- public List<String> selectFuzzy(@Param("tab") String tab, @Param("field") String field, @Param("value") String value);
+ @Select("select ${field} from ${tab} where upper(${field}) like #{value} order by ${field} limit 10")
+ public List<String> selectFieldFuzzy(@Param("tab") String tab, @Param("field") String field, @Param("value") String value);
+
+ /**
+ * 鑷畾涔夋壒閲忔彃鍏�
+ * 濡傛灉瑕佽嚜鍔ㄥ～鍏咃紝@Param(xx) xx鍙傛暟鍚嶅繀椤绘槸 list/collection/array 3涓殑鍏朵腑涔嬩竴
+ *
+ * @param list
+ * @return
+ */
+ public int insertBatch(@Param("list") List<T> list);
+
+ /**
+ * 鑷畾涔夋壒閲忔洿鏂帮紝鏉′欢涓轰富閿�
+ * 濡傛灉瑕佽嚜鍔ㄥ～鍏咃紝@Param(xx) xx鍙傛暟鍚嶅繀椤绘槸 list/collection/array 3涓殑鍏朵腑涔嬩竴
+ *
+ * @param list
+ * @return
+ */
+ public int updateBatch(@Param("list") List<T> list);
+
+ /**
+ * 鏌ヨ闄勪欢
+ *
+ * @param tab 琛ㄥ悕
+ * @param wrapper 鏌ヨ鍖呰鍣�
+ * @return
+ */
+ @Select("select * from lf.sys_attach where tab = #{tab} and tab_guid in (select eventid from ${tab} ${ew.customSqlSegment})")
+ public List<AttachEntity> selectAnnex(@Param("tab") String tab, @Param("ew") QueryWrapper wrapper);
}
--
Gitblit v1.9.3