From 23855599412c4d61b38d78f0f3abd3430a48b5b1 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 25 六月 2025 11:51:38 +0800
Subject: [PATCH] Merge branch 'mdc_hyjs_master'
---
lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysDictMapper.java | 288 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 288 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysDictMapper.java b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysDictMapper.java
new file mode 100644
index 0000000..d3f1d93
--- /dev/null
+++ b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysDictMapper.java
@@ -0,0 +1,288 @@
+package org.jeecg.modules.system.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
+import org.jeecg.common.system.vo.DictModel;
+import org.jeecg.common.system.vo.DictModelMany;
+import org.jeecg.common.system.vo.DictQuery;
+import org.jeecg.modules.system.entity.SysDict;
+import org.jeecg.modules.system.model.DuplicateCheckVo;
+import org.jeecg.modules.system.model.TreeSelectModel;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+ * <p>
+ * 瀛楀吀琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @Author zhangweijian
+ * @since 2018-12-28
+ */
+public interface SysDictMapper extends BaseMapper<SysDict> {
+
+ /**
+ * 閲嶅妫�鏌QL
+ * @param duplicateCheckVo
+ * @return
+ */
+ @Deprecated
+ public Long duplicateCheckCountSql(DuplicateCheckVo duplicateCheckVo);
+
+ /**
+ * 閲嶅鏍￠獙 sql璇彞
+ * @param duplicateCheckVo
+ * @return
+ */
+ @Deprecated
+ public Long duplicateCheckCountSqlNoDataId(DuplicateCheckVo duplicateCheckVo);
+
+ /**
+ * 閫氳繃瀛楀吀code鑾峰彇瀛楀吀鏁版嵁
+ * @param code 瀛楀吀code
+ * @return List<DictModel>
+ */
+ public List<DictModel> queryDictItemsByCode(@Param("code") String code);
+
+ /**
+ * 鏌ヨ鏈夋晥鐨勬暟鎹瓧鍏搁」
+ * @param code
+ * @return
+ */
+ List<DictModel> queryEnableDictItemsByCode(@Param("code") String code);
+
+
+ /**
+ * 閫氳繃澶氫釜瀛楀吀code鑾峰彇瀛楀吀鏁版嵁
+ *
+ * @param dictCodeList
+ * @return
+ */
+ public List<DictModelMany> queryDictItemsByCodeList(@Param("dictCodeList") List<String> dictCodeList);
+
+ /**
+ * 閫氳繃鏌ヨ鎸囧畾table鐨� text code 鑾峰彇瀛楀吀
+ * @param table
+ * @param text
+ * @param code
+ * @return List<DictModel>
+ */
+ @Deprecated
+ public List<DictModel> queryTableDictItemsByCode(@Param("table") String table,@Param("text") String text,@Param("code") String code);
+
+ /**
+ * 閫氳繃鏌ヨ鎸囧畾table鐨� text code 鑾峰彇瀛楀吀锛堟寚瀹氭煡璇㈡潯浠讹級
+ * @param table
+ * @param text
+ * @param code
+ * @param filterSql
+ * @return List<DictModel>
+ */
+ @Deprecated
+ public List<DictModel> queryTableDictItemsByCodeAndFilter(@Param("table") String table,@Param("text") String text,@Param("code") String code,@Param("filterSql") String filterSql);
+
+ /**
+ * 閫氳繃鏌ヨ鎸囧畾table鐨� text code 鑾峰彇瀛楀吀
+ * @param table
+ * @param key
+ * @param value
+ * @return List<Map<String,String>>
+ */
+ @Deprecated
+ @Select("select ${key} as \"label\",${value} as \"value\" from ${table}")
+ public List<Map<String,String>> getDictByTableNgAlain(@Param("table") String table, @Param("key") String key, @Param("value") String value);
+
+ /**
+ * 閫氳繃瀛楀吀code鑾峰彇瀛楀吀鏁版嵁
+ * @param code
+ * @param key
+ * @return
+ */
+ public String queryDictTextByKey(@Param("code") String code,@Param("key") String key);
+
+ /**
+ * 鍙�氳繃澶氫釜瀛楀吀code鏌ヨ缈昏瘧鏂囨湰
+ * @param dictCodeList 澶氫釜瀛楀吀code
+ * @param keys 鏁版嵁鍒楄〃
+ * @return
+ */
+ List<DictModelMany> queryManyDictByKeys(@Param("dictCodeList") List<String> dictCodeList, @Param("keys") List<String> keys);
+
+ /**
+ * 閫氳繃鏌ヨ鎸囧畾table鐨� text code key 鑾峰彇瀛楀吀鍊�
+ * @param table
+ * @param text
+ * @param code
+ * @param key
+ * @return String
+ */
+ @Deprecated
+ public String queryTableDictTextByKey(@Param("table") String table,@Param("text") String text,@Param("code") String code,@Param("key") String key);
+
+// /**
+// * 閫氳繃鏌ヨ鎸囧畾table鐨� text code key 鑾峰彇瀛楀吀鍊硷紝鍙壒閲忔煡璇�
+// *
+// * @param table
+// * @param text
+// * @param code
+// * @param keys
+// * @return
+// */
+// @Deprecated
+// List<DictModel> queryTableDictTextByKeys(@Param("table") String table, @Param("text") String text, @Param("code") String code, @Param("keys") List<String> keys);
+
+// D /**
+//// * 閫氳繃鏌ヨ鎸囧畾table鐨� text code key 鑾峰彇瀛楀吀鍊硷紝鍖呭惈value
+//// * @param table
+//// * @param text
+//// * @param code
+//// * @param keyArray
+//// * @return List<DictModel>
+//// */
+//// @Deprecated
+//// public List<DictModel> queryTableictByKeys(@Param("table") String table, @Param("text") String text, @Param("code") String code, @Param("keyArray") String[] keyArray);
+
+ /**
+ * 鏌ヨ鎵�鏈夐儴闂� 浣滀负瀛楀吀淇℃伅 id -->value,departName -->text
+ * @return
+ */
+ public List<DictModel> queryAllDepartBackDictModel();
+
+ /**
+ * 鏌ヨ鎵�鏈夌敤鎴� 浣滀负瀛楀吀淇℃伅 username -->value,realname -->text
+ * @return
+ */
+ public List<DictModel> queryAllUserBackDictModel();
+
+// /**
+// * 閫氳繃鍏抽敭瀛楁煡璇㈠嚭瀛楀吀琛�
+// * @param table
+// * @param text
+// * @param code
+// * @param keyword
+// * @return
+// */
+// @Deprecated
+// public List<DictModel> queryTableDictItems(@Param("table") String table,@Param("text") String text,@Param("code") String code,@Param("keyword") String keyword);
+
+
+// /**
+// * 閫氳繃鍏抽敭瀛楁煡璇㈠嚭瀛楀吀琛�
+// * @param page
+// * @param table
+// * @param text
+// * @param code
+// * @param keyword
+// * @return
+// */
+// //IPage<DictModel> queryTableDictItems(Page<DictModel> page, @Param("table") String table, @Param("text") String text, @Param("code") String code, @Param("keyword") String keyword);
+
+ /**
+ * 鏍规嵁琛ㄥ悕銆佹樉绀哄瓧娈靛悕銆佸瓨鍌ㄥ瓧娈靛悕 鏌ヨ鏍�
+ * @param table
+ * @param text
+ * @param code
+ * @param pid
+ * @param hasChildField
+ * @param query
+ * @param pidField
+ * @return
+ */
+ @Deprecated
+ List<TreeSelectModel> queryTreeList(@Param("query") Map<String, String> query,@Param("table") String table,@Param("text") String text,@Param("code") String code,@Param("pidField") String pidField,@Param("pid") String pid,@Param("hasChildField") String hasChildField,@Param("converIsLeafVal") int converIsLeafVal);
+
+ /**
+ * 鍒犻櫎
+ * @param id
+ */
+ @Select("delete from sys_dict where id = #{id}")
+ public void deleteOneById(@Param("id") String id);
+
+ /**
+ * 鏌ヨ琚�昏緫鍒犻櫎鐨勬暟鎹�
+ * @return
+ */
+ @Select("select * from sys_dict where del_flag = 1")
+ public List<SysDict> queryDeleteList();
+
+ /**
+ * 淇敼鐘舵�佸��
+ * @param delFlag
+ * @param id
+ */
+ @Update("update sys_dict set del_flag = #{flag,jdbcType=INTEGER} where id = #{id,jdbcType=VARCHAR}")
+ public void updateDictDelFlag(@Param("flag") int delFlag, @Param("id") String id);
+
+
+ /**
+ * 鍒嗛〉鏌ヨ瀛楀吀琛ㄦ暟鎹�
+ * @param page
+ * @param query
+ * @return
+ */
+ @Deprecated
+ public Page<DictModel> queryDictTablePageList(Page page, @Param("query") DictQuery query);
+
+
+ /**
+ * 鏌ヨ 瀛楀吀琛ㄦ暟鎹� 鏀寔鏌ヨ鏉′欢 鍒嗛〉
+ * @param page
+ * @param table
+ * @param text
+ * @param code
+ * @param filterSql
+ * @return
+ */
+ @Deprecated
+ IPage<DictModel> queryTableDictWithFilter(Page<DictModel> page, @Param("table") String table, @Param("text") String text, @Param("code") String code, @Param("filterSql") String filterSql);
+
+ /**
+ * 鏌ヨ 瀛楀吀琛ㄦ暟鎹� 鏀寔鏌ヨ鏉′欢 鏌ヨ鎵�鏈�
+ * @param table
+ * @param text
+ * @param code
+ * @param filterSql
+ * @return
+ */
+ @Deprecated
+ List<DictModel> queryAllTableDictItems(@Param("table") String table, @Param("text") String text, @Param("code") String code, @Param("filterSql") String filterSql);
+
+ /**
+ * 鏌ヨ瀛楀吀琛ㄧ殑鏁版嵁
+ * @param table 琛ㄥ悕
+ * @param text 鏄剧ず瀛楁鍚�
+ * @param code 瀛樺偍瀛楁鍚�
+ * @param filterSql 鏉′欢sql
+ * @param codeValues 瀛樺偍瀛楁鍊� 浣滀负鏌ヨ鏉′欢in
+ * @return
+ */
+ @Deprecated
+ List<DictModel> queryTableDictByKeysAndFilterSql(@Param("table") String table, @Param("text") String text, @Param("code") String code, @Param("filterSql") String filterSql, @Param("codeValues") List<String> codeValues);
+
+ /**
+ * 浣跨敤瀛怱ql鏌ヨ瀛楀吀鏁版嵁
+ * @param table
+ * @param text
+ * @param subSql
+ * @return
+ */
+ String queryTableDictTextBySubSql(@Param("table") String table, @Param("text") String text, @Param("subSql") String subSql);
+
+ /**
+ * 鍗曡〃鎵归噺鏌ヨ
+ * @param queryTable
+ * @param columns
+ * @param paramName
+ * @param paramValues
+ * @return
+ */
+ List<Map> queryTableFieldByParams(@Param("table") String queryTable, @Param("columns") String columns, @Param("paramName") String paramName, @Param("paramValues") String[] paramValues);
+
+ List<DictModel> queryDictItemValueByCodeAndText(@Param("code")String code,@Param("itemText")String itemText);
+
+}
--
Gitblit v1.9.3