From 99f528e235f11126fea44480c6e8888a9e463f2f Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期六, 08 十一月 2025 21:09:53 +0800
Subject: [PATCH] feat:任务附件上传和同步
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysDeptMapper.java | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysDeptMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysDeptMapper.java
index 384a9b6..df69912 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysDeptMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysDeptMapper.java
@@ -115,4 +115,39 @@
* @return 缁撴灉
*/
public int deleteDeptById(Long deptId);
+
+ /**
+ * 鏍规嵁departmentId鏌ヨ閮ㄩ棬
+ *
+ * @param departmentId SQL Server涓殑閮ㄩ棬ID
+ * @return 閮ㄩ棬淇℃伅
+ */
+ public SysDept selectDeptByDepartmentId(@Param("departmentId") Integer departmentId);
+
+ /**
+ * 鏍规嵁departmentId鍜岀埗閮ㄩ棬ID鏌ヨ閮ㄩ棬
+ *
+ * @param departmentId SQL Server涓殑閮ㄩ棬ID
+ * @param parentId 鐖堕儴闂↖D
+ * @return 閮ㄩ棬淇℃伅
+ */
+ public SysDept selectDeptByDepartmentIdAndParentId(@Param("departmentId") Integer departmentId, @Param("parentId") Long parentId);
+
+ /**
+ * 鑾峰彇鎸囧畾閮ㄩ棬ID鐨勫垎鍏徃ID锛坧arent_id=100鐨勯儴闂級
+ * 濡傛灉浼犲叆鐨勫氨鏄垎鍏徃锛岀洿鎺ヨ繑鍥烇紱鍚﹀垯浠巃ncestors涓煡鎵惧垎鍏徃ID
+ *
+ * @param deptId 閮ㄩ棬ID
+ * @return 鍒嗗叕鍙窱D锛屽鏋滄壘涓嶅埌鍒欒繑鍥瀗ull
+ */
+ public Long selectBranchCompanyIdByDeptId(@Param("deptId") Long deptId);
+
+ /**
+ * 鏍规嵁缂栫爜鍒楄〃鏌ヨ鍒嗗叕鍙�
+ * 鍦╯ervice_order_class鎴杁ispatch_order_class涓尮閰�
+ *
+ * @param orderCodes 缂栫爜鍒楄〃
+ * @return 鍒嗗叕鍙稿垪琛�
+ */
+ public List<SysDept> selectBranchCompaniesByOrderCodes(@Param("orderCodes") List<String> orderCodes);
}
--
Gitblit v1.9.1