From 094a9290c836827bc1f45fd3549e7cd2ea1e1e45 Mon Sep 17 00:00:00 2001
From: qushaowei <qushaowei@163.com>
Date: 星期二, 07 十一月 2023 09:45:36 +0800
Subject: [PATCH] Merge branch 'master' of http://117.34.109.166:18448/r/mdc_430 into develop
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/SysFileNameMapper.java | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/SysFileNameMapper.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/SysFileNameMapper.java
new file mode 100644
index 0000000..a331e6f
--- /dev/null
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/SysFileNameMapper.java
@@ -0,0 +1,28 @@
+package org.jeecg.modules.eam.mapper;
+
+import java.util.List;
+
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.jeecg.modules.eam.entity.SysFileName;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.jeecg.modules.eam.model.DepartVo;
+import org.jeecg.modules.eam.vo.SysFileNameVo;
+
+/**
+ * @Description: 鏂囦欢鍚嶇О绠＄悊
+ * @Author: jeecg-boot
+ * @Date: 2023-11-03
+ * @Version: V1.0
+ */
+public interface SysFileNameMapper extends BaseMapper<SysFileName> {
+
+
+ /**
+ * 閫氳繃鍗曟嵁绫诲瀷鑾峰彇鍗曟嵁缂栫爜
+ * qsw 2023-11-3
+ */
+ @Select("select t1.id as receipts,t1.id as maintenanceOrderUda3,t1.num as receiptsNum,t2.item_text as receiptsName,t1.num as receiptsNum2,t2.item_text as receiptsName2 from sys_file_name t1 left join (SELECT * FROM v_sys_dict WHERE dict_code = 'sys_file_name') t2 on t2.item_value = t1.name where t1.version_status = '2' and t1.name =#{name}")
+ List<SysFileNameVo> getSysFileName(@Param("name")String name);
+
+}
--
Gitblit v1.9.3