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); }