From 455c3fc88f870fdb1f8ef48b4f9ff3c0cefac6ad Mon Sep 17 00:00:00 2001
From: lsh <lsh@163.com>
Date: 星期三, 02 四月 2025 17:01:23 +0800
Subject: [PATCH] *
---
src/main/resources/mapper/LocDetlMapper.xml | 12 ++++++------
src/main/resources/mapper/LocMastMapper.xml | 18 +++++++++---------
2 files changed, 15 insertions(+), 15 deletions(-)
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index d08cbe6..739632c 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -71,23 +71,23 @@
select * from
(
select
- ROW_NUMBER() over (order by a."appe_time",a."matnr",a."loc_no") as row,
+ ROW_NUMBER() over (order by a."appe_time",a."MATNR",a."LOC_NO") as ROW,
a.*
from "SOURCE"."asr_loc_detl" a
- left join "SOURCE"."asr_loc_mast" b on a."loc_no" = b."loc_no"
+ left join "SOURCE"."asr_loc_mast" b on a."LOC_NO" = b."LOC_NO"
where 1=1
- and b."loc_sts" = 'F'
+ and b."LOC_STS" = 'F'
<include refid="stockOutCondition"></include>
- ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
+ ) t where t.ROW between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
</select>
<select id="getStockOutPageCount" parameterType="java.util.Map" resultType="java.lang.Integer">
select
count(1)
from "SOURCE"."asr_loc_detl" a
- left join "SOURCE"."asr_loc_mast" b on a."loc_no" = b."loc_no"
+ left join "SOURCE"."asr_loc_mast" b on a."LOC_NO" = b."LOC_NO"
where 1=1
- and b."loc_sts" = 'F'
+ and b."LOC_STS" = 'F'
<include refid="stockOutCondition"></include>
</select>
</mapper>
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 7f2c42e..2c70150 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -45,31 +45,31 @@
<select id="queryFreeLocMast" resultMap="BaseResultMap">
select top 1 *
from "SOURCE"."asr_loc_mast"
- where "row1"=#{row}
- and "loc_sts"='O'
+ where "ROW1"=#{row}
+ and "LOC_STS"='O'
<if test="locType1 != null">
- and "loc_type1" = #{locType1}
+ and "LOC_TYPE1" = #{locType1}
</if>
- order by NEWID(),"lev1" asc,"bay1" asc
+ order by NEWID(),"LEV1" asc,"BAY1" asc
</select>
<select id="queryDemoSourceLoc" resultMap="BaseResultMap">
- select top 1 * from "SOURCE"."asr_loc_mast" where "crn_no" = #{crnNo}
- and "loc_sts"='D'
+ select top 1 * from "SOURCE"."asr_loc_mast" where "CRN_NO" = #{crnNo}
+ and "LOC_STS"='D'
ORDER BY NEWID()
</select>
<select id="queryDemoLoc" resultMap="BaseResultMap">
- select top 1 * from "SOURCE"."asr_loc_mast" where "crn_no" = #{crnNo} and "loc_sts" = 'O'
+ select top 1 * from "SOURCE"."asr_loc_mast" where "CRN_NO" = #{crnNo} and "LOC_STS" = 'O'
ORDER BY NEWID()
</select>
<select id="selectByLocNo" resultMap="BaseResultMap">
select * from "SOURCE"."asr_loc_mast"
- where "loc_no" = #{locNo}
+ where "LOC_NO" = #{locNo}
</select>
<select id="selectLocByLev" resultMap="BaseResultMap">
- SELECT * FROM "SOURCE"."asr_loc_mast" WHERE "lev1" = #{lev}
+ SELECT * FROM "SOURCE"."asr_loc_mast" WHERE "LEV1" = #{lev}
</select>
</mapper>
--
Gitblit v1.9.1