From 4c64dca2491f0ae298ee160c1e8df22448a588ae Mon Sep 17 00:00:00 2001
From: Administrator <hbal>
Date: 星期六, 15 四月 2023 12:44:37 +0800
Subject: [PATCH] 明晟webservice
---
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..d5abf32 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='鍦ㄥ姙' where SdepartNo=#{sdepartNo} "
+ })
+ public List<Map> getHwList(String sdepartNo);
+
+
}
--
Gitblit v1.9.3