From cc0cbfc79a34e1b106fdb998450cd2ad03446126 Mon Sep 17 00:00:00 2001
From: Administrator <hbal>
Date: 星期五, 14 四月 2023 08:35:13 +0800
Subject: [PATCH] 明晟分屏展示
---
JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java b/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
index e90a38e..99687f6 100644
--- a/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
+++ b/JavaSource/com/mandi/fendan/mapper/Fd_XSTDMXMapper.java
@@ -157,4 +157,11 @@
@Update("update fd_xstdmx set tdmx_ggxh=#{tdmx_ggxh} where tdmx_tdfl=#{tdmx_tdfl}")
public int updateMXGG(Fd_XSTDMX mx);
+ @Select({"select hw.name tdmx_hwmc,mx.* from fd_xstdmx mx " ,
+ " left join nc_hw hw on mx.tdmx_hwbh=hw.pkid and hw.state=1 " ,
+ " join fd_bsheet on bsNo=tdmx_fdywbh and status='鍦ㄥ姙' and sdepartNo=#{sdepartNo} "
+ })
+ public List getHwList(String sdepartNo);
+
+
}
--
Gitblit v1.9.3