From 9b47c5ea47ea861b9dfc6cee1df966ebf42fbdab Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Sun, 28 Apr 2024 18:49:29 +0800
Subject: [PATCH] 查询视频站列表

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java        |    1 +
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml |    4 ++++
 2 files changed, 5 insertions(+), 0 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml
index 32a8d5c..ef836be 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttWmstBaseMapper.xml
+++ b/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>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java
index ee8012f..0d63cb9 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttWmstBaseVO.java
+++ b/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;
 }

--
Gitblit v1.9.3