From 76266d7e5779d1cd3256f63840ac78bbd7755c13 Mon Sep 17 00:00:00 2001
From: lsh <lsh@163.com>
Date: 星期三, 02 四月 2025 16:59:35 +0800
Subject: [PATCH] *
---
src/main/resources/mapper/DataResourceMapper.xml | 6 +++---
src/main/resources/mapper/DeviceErrorMapper.xml | 8 ++++----
src/main/resources/mapper/LocDetlMapper.xml | 10 +++++-----
src/main/resources/mapper/ConfigMapper.xml | 4 ++--
src/main/resources/mapper/BasDevpMapper.xml | 20 ++++++++++----------
src/main/resources/mapper/CommandInfoMapper.xml | 12 ++++++------
6 files changed, 30 insertions(+), 30 deletions(-)
diff --git a/src/main/resources/mapper/BasDevpMapper.xml b/src/main/resources/mapper/BasDevpMapper.xml
index 8b76c3e..acfe853 100644
--- a/src/main/resources/mapper/BasDevpMapper.xml
+++ b/src/main/resources/mapper/BasDevpMapper.xml
@@ -47,24 +47,24 @@
<select id="getAvailableInSite" resultType="java.lang.Integer">
select
- abd."dev_no"
+ abd."DEV_NO"
from "SOURCE"."asr_bas_devp" abd
- left join "SOURCE"."asr_sta_desc" asd on abd."dev_no" = asd."stn_no"
+ left join "SOURCE"."asr_sta_desc" asd on abd."DEV_NO" = asd."STN_NO"
where 1=1
- and asd."type_no" = #{typeNo}
- and abd."in_enable" = 'Y'
- group by abd."dev_no"
+ and asd."TYPE_NO" = #{typeNo}
+ and abd."IN_ENABLE" = 'Y'
+ group by abd."DEV_NO"
</select>
<select id="getAvailableOutSite" resultType="java.lang.Integer">
select
- abd."dev_no"
+ abd."DEV_NO"
from "SOURCE"."asr_bas_devp" abd
- left join "SOURCE"."asr_sta_desc" asd on abd."dev_no" = asd."stn_no"
+ left join "SOURCE"."asr_sta_desc" asd on abd."DEV_NO" = asd."STN_NO"
where 1=1
- and asd."type_no" = #{typeNo}
- and abd."out_enable" = 'Y'
- group by abd."dev_no"
+ and asd."TYPE_NO" = #{typeNo}
+ and abd."OUT_ENABLE" = 'Y'
+ group by abd."DEV_NO"
</select>
</mapper>
diff --git a/src/main/resources/mapper/CommandInfoMapper.xml b/src/main/resources/mapper/CommandInfoMapper.xml
index d9bbc7b..1aa9bcb 100644
--- a/src/main/resources/mapper/CommandInfoMapper.xml
+++ b/src/main/resources/mapper/CommandInfoMapper.xml
@@ -20,24 +20,24 @@
<select id="selectByTaskNoAndWrkNo" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_command_info"
- where "wrk_no" = #{wrkNo}
- and "task_no" = #{taskNo}
+ where "WRK_NO" = #{wrkNo}
+ and "TASK_NO" = #{taskNo}
</select>
<select id="selectByWrkNo" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_command_info"
- where "wrk_no" = #{wrkNo}
+ where "WRK_NO" = #{wrkNo}
</select>
<select id="selectByTaskNo" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_command_info"
- where "task_no" = #{taskNo}
+ where "TASK_NO" = #{taskNo}
</select>
<select id="selectCompleteManualCommand" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_command_info"
- where "command_type" = 2
- and "command_status" = 3
+ where "COMMAND_TYPE" = 2
+ and "COMMAND_STATUS" = 3
</select>
</mapper>
diff --git a/src/main/resources/mapper/ConfigMapper.xml b/src/main/resources/mapper/ConfigMapper.xml
index 4da171e..6642ad4 100644
--- a/src/main/resources/mapper/ConfigMapper.xml
+++ b/src/main/resources/mapper/ConfigMapper.xml
@@ -15,12 +15,12 @@
<select id="selectByCode" resultMap="BaseResultMap">
select top 1 * from "SOURCE"."sys_config"
- where "code" = #{code}
+ where "CODE" = #{code}
</select>
<select id="selectByCodes" resultMap="BaseResultMap">
select * from "SOURCE"."sys_config"
- where "code" in
+ where "CODE" in
<foreach item="item" collection="codes" index="index" separator="," open="(" close=")">
#{item}
</foreach>
diff --git a/src/main/resources/mapper/DataResourceMapper.xml b/src/main/resources/mapper/DataResourceMapper.xml
index c348641..21b98a8 100644
--- a/src/main/resources/mapper/DataResourceMapper.xml
+++ b/src/main/resources/mapper/DataResourceMapper.xml
@@ -15,17 +15,17 @@
<select id="selectRootData" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_data_resource"
- where "resource_id" is null
+ where "RESOURCE_ID" is null
</select>
<select id="selectByResourceId" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_data_resource"
- where "resource_id" = #{resourceId}
+ where "RESOURCE_ID" = #{resourceId}
</select>
<select id="selectAll" resultMap="BaseResultMap">
select * from "SOURCE"."wcs_data_resource"
- order by "name"
+ order by "NAME"
</select>
</mapper>
diff --git a/src/main/resources/mapper/DeviceErrorMapper.xml b/src/main/resources/mapper/DeviceErrorMapper.xml
index 2644995..a3759d3 100644
--- a/src/main/resources/mapper/DeviceErrorMapper.xml
+++ b/src/main/resources/mapper/DeviceErrorMapper.xml
@@ -14,14 +14,14 @@
<select id="selectByDeviceAndDeviceId" resultMap="BaseResultMap">
select top 1 * from "SOURCE"."wcs_device_error"
- where "device" = #{device}
- and "device_id" = #{deviceId}
+ where "DEVICE" = #{device}
+ and "DEVICE_ID" = #{deviceId}
</select>
<delete id="deleteByDeviceAndDeviceId">
delete from "SOURCE"."wcs_device_error"
- where "device" = #{device}
- and "device_id" = #{deviceId}
+ where "DEVICE" = #{device}
+ and "CREATE_TIME" = #{deviceId}
</delete>
</mapper>
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 589caee..d08cbe6 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -51,19 +51,19 @@
and a."LOC_NO" like '%' + #{loc_no} + '%'
</if>
<if test="matNo!=null and matNo!='' ">
- and a."matnr" like '%' + #{matNo} + '%'
+ and a."MATNR" like '%' + #{matNo} + '%'
</if>
<if test="matName!=null and matName!='' ">
- and a."maktx" like '%' + #{matName} + '%'
+ and a."MAKTX" like '%' + #{matName} + '%'
</if>
<if test="anfme!=null and anfme!='' ">
- and a."anfme" like '%' + #{anfme} + '%'
+ and a."ANFME" like '%' + #{anfme} + '%'
</if>
<if test="altme!=null and altme!='' ">
- and a."altme" like '%' + #{altme} + '%'
+ and a."ALTME" like '%' + #{altme} + '%'
</if>
<if test="startTime!=null and endTime!=null">
- and a."modi_time" between #{startTime} and #{endTime}
+ and a."MODI_TIME" between #{startTime} and #{endTime}
</if>
</sql>
--
Gitblit v1.9.1