From 22b207e59644a4f7228dbdd9c7bd2bc8428a4ec4 Mon Sep 17 00:00:00 2001
From: 邱宇豪 <qyh123230312>
Date: 星期二, 10 十月 2023 16:36:58 +0800
Subject: [PATCH] 20231010_qiuyh_调整管片明细sql
---
hd/pipe/materialsManage/src/main/resources/mapping/TSteelNeedYearMapper.xml | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/hd/pipe/materialsManage/src/main/resources/mapping/TSteelNeedYearMapper.xml b/hd/pipe/materialsManage/src/main/resources/mapping/TSteelNeedYearMapper.xml
index 36bd77e..3da3639 100644
--- a/hd/pipe/materialsManage/src/main/resources/mapping/TSteelNeedYearMapper.xml
+++ b/hd/pipe/materialsManage/src/main/resources/mapping/TSteelNeedYearMapper.xml
@@ -272,8 +272,8 @@
</select>
<select id="selectPipeInfo" resultType="java.util.Map" parameterType="java.util.Map">
SELECT
- tpi.ring_num,
- tpi.pipe_num,
+ tpi.ring_num ringNum,
+ tpi.pipe_num pipeNum,
sd1.dict_name turn,
sd2.dict_name reinforcement,
sd3.dict_name groutingHoles,
@@ -283,7 +283,7 @@
IFNULL(tpi.pouring_time,' ') pouringTime,
tpi.check_time checkTime,
IFNULL(sg.group_name,'无') groupName,
- sp.pro_name,
+ sp.pro_name proName,
CASE tpi.check_result
WHEN 1 THEN '合格'
WHEN 2 THEN '不合格'
--
Gitblit v1.9.3