skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml
@@ -8,4 +8,8 @@ SET "res_guid" = #{attWmstBase.resGuid} where "guid" = #{attWmstBase.guid} </update> <select id="getPage" resultType="cn.gistack.sm.sjztmd.vo.AttWmstBaseVO"> select awb.*,arb."name" as resName from sjzt_md."att_wmst_base" awb left join sjzt_md."att_res_base" arb on arb.."guid" = awb."res_guid" </select> </mapper> skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java
@@ -5,4 +5,5 @@ @Data public class AttWmstBaseVO extends AttWmstBase { private String resName; }
