From d3334bbb98a1524e67bd50aee1078a7eec40a55f Mon Sep 17 00:00:00 2001 From: xing <xingjs@qq.com> Date: 星期日, 26 二月 2023 13:05:55 +0800 Subject: [PATCH] 20230226@xingjs@提交官网一张图相关内容接口(优化完善sql--修改数据存储sql) --- src/main/java/com/lf/server/mapper/data/MetaMapper.java | 61 +++++++++++++++++++----------- 1 files changed, 38 insertions(+), 23 deletions(-) diff --git a/src/main/java/com/lf/server/mapper/data/MetaMapper.java b/src/main/java/com/lf/server/mapper/data/MetaMapper.java index 6b42201..129db33 100644 --- a/src/main/java/com/lf/server/mapper/data/MetaMapper.java +++ b/src/main/java/com/lf/server/mapper/data/MetaMapper.java @@ -7,7 +7,7 @@ import java.util.List; /** - * 鍏冩暟鎹� + * 婧愭暟鎹� * @author WWW */ @Mapper @@ -16,46 +16,48 @@ /** * 鏌ヨ璁板綍鏁� * - * @param depid 鍗曚綅ID - * @param dirid 鐩綍ID - * @param name 鍚嶇О + * @param depcode 鍗曚綅缂栫爜 + * @param dircode 鐩綍缂栫爜 + * @param verid 鐗堟湰ID + * @param name 鍚嶇О * @return 璁板綍鏁� */ - public Integer selectCount(Integer depid, Integer dirid, String name); + public Integer selectCount(String depcode, String dircode, Integer verid, String name); /** * 鍒嗛〉鏌ヨ * - * @param depid 鍗曚綅ID - * @param dirid 鐩綍ID - * @param name 鍚嶇О - * @param limit 璁板綍鏁� - * @param offset 鍋忕Щ閲� + * @param depcode 鍗曚綅缂栫爜 + * @param dircode 鐩綍缂栫爜 + * @param verid 鐗堟湰ID + * @param name 鍚嶇О + * @param limit 璁板綍鏁� + * @param offset 鍋忕Щ閲� * @return 鍒楄〃 */ - public List<MetaEntity> selectByPage(Integer depid, Integer dirid, String name, Integer limit, Integer offset); + public List<MetaEntity> selectByPage(String depcode, String dircode, Integer verid, String name, Integer limit, Integer offset); /** * 鏌ヨ璁板綍鏁� * - * @param depid + * @param depcode * @param dirs * @param name * @return */ - public Integer selectMetasForCount(Integer depid, String dirs, String name); + public Integer selectMetasForCount(String depcode, String dirs, String name); /** * 鍒嗛〉鏌ヨ * - * @param depid + * @param depcode * @param dirs * @param name * @param limit * @param offset * @return */ - public List<MetaEntity> selectMetasForPage(Integer depid, String dirs, String name, Integer limit, Integer offset); + public List<MetaEntity> selectMetasForPage(String depcode, String dirs, String name, Integer limit, Integer offset); /** * 鏌ヨ涓婁紶璁板綍鏁� @@ -80,11 +82,24 @@ public List<MetaEntity> selectByPageForUpload(String name, Integer createUser, String types, Integer limit, Integer offset); /** - * 鏌ヨ鎵�鏈� + * 鏍规嵁鐖禝D鏌ヨ璁板綍鏁� * + * @param metaid + * @param name * @return */ - public List<MetaEntity> selectAll(); + public Integer selectCountByPid(Integer metaid, String name); + + /** + * 鏍规嵁鐖禝D鍒嗛〉鏌ヨ + * + * @param metaid + * @param name + * @param limit + * @param offset + * @return + */ + public List<MetaEntity> selectPageByPid(Integer metaid, String name, Integer limit, Integer offset); /** * 鏍规嵁ID鏌ヨ @@ -104,19 +119,19 @@ public MetaEntity selectByGuid(String guid, String tab); /** - * 鏌ヨ鍏冩暟鎹枃浠� + * 鏌ヨ婧愭暟鎹枃浠� * - * @param ids 鍏冩暟鎹甀D闆嗗悎 - * @return 鍏冩暟鎹枃浠堕泦鍚� + * @param ids 婧愭暟鎹甀D闆嗗悎 + * @return 婧愭暟鎹枃浠堕泦鍚� */ public List<MetaEntity> selectMetaFiles(List<Integer> ids); /** - * 鏌ヨExcel鍏冩暟鎹� + * 鏌ヨExcel婧愭暟鎹� * - * @param ids 鍏冩暟鎹甀D闆嗗悎 + * @param ids 婧愭暟鎹甀D闆嗗悎 * @param tabs 琛ㄥ悕瀛楃涓� - * @return 鍏冩暟鎹枃浠堕泦鍚� + * @return 婧愭暟鎹枃浠堕泦鍚� */ public List<MetaEntity> selectXlsAnnex(Integer[] ids, String tabs); -- Gitblit v1.9.3