From 34981c30a78e8bbd7791131059a9210f9928b62c Mon Sep 17 00:00:00 2001
From: 刘光辉 <347230014@qq.com>
Date: 星期四, 17 九月 2026 09:24:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master

---
 jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsSxtQingyanXiangmuZixiangMapper.java |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsSxtQingyanXiangmuZixiangMapper.java b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsSxtQingyanXiangmuZixiangMapper.java
new file mode 100644
index 0000000..0bf2a80
--- /dev/null
+++ b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsSxtQingyanXiangmuZixiangMapper.java
@@ -0,0 +1,25 @@
+package jnpf.limsMapper;
+
+import jnpf.base.mapper.SuperMapper;
+import jnpf.limsEntity.LimsSxtQingyanXiangmuZixiangEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
+import org.springframework.data.repository.query.Param;
+
+import java.util.List;
+
+@Mapper
+public interface LimsSxtQingyanXiangmuZixiangMapper extends SuperMapper<LimsSxtQingyanXiangmuZixiangEntity> {
+
+
+
+    /**
+     * 鏍规嵁澶栭敭鏌ヨ椤圭洰ID鍒楄〃锛堟湭鍒犻櫎锛�
+     */
+    @Select("SELECT xiangmu_id "
+            + "FROM lims_sxt_qingyan_xiangmu_zixiang "
+            + "WHERE f_foreign_id = #{foreignId} "
+            + "AND f_delete_mark IS NULL")
+    List<String> selectXiangmuIdsByForeignId(@Param("foreignId") String foreignId);
+
+}

--
Gitblit v1.8.0