From e8d3676793d4194485afec7940aaf355af594901 Mon Sep 17 00:00:00 2001 From: wuyouming666 <2265557248@qq.com> Date: 星期四, 18 四月 2024 14:24:52 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/mapper/HangzhouMesMapper.java | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/mapper/HangzhouMesMapper.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/mapper/HangzhouMesMapper.java index 3839bd5..ab38e20 100644 --- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/mapper/HangzhouMesMapper.java +++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/mapper/HangzhouMesMapper.java @@ -1,21 +1,21 @@ package com.mes.taskcache.mapper; - -import java.util.List; -import java.util.Map; - import com.mes.edgstoragecage.entity.EdgStorageCageDetails; import com.mes.glassinfo.entity.GlassInfo; import com.mes.taskcache.entity.TaskCache; import org.apache.ibatis.annotations.*; +import java.util.List; +import java.util.Map; + @Mapper public interface HangzhouMesMapper { - + // 鐜荤拑淇℃伅 鎸塈D鏌ヨ @Select("select * from `glass_info` where id=#{id}") GlassInfo selectGlassId(String id); + // 鏌ヨ纾ㄨ竟淇℃伅 @Select("select * from task_cache where task_type='2' and task_stauts='2' and end_cell=#{EndCell}") List<Map> selectEdgInfo(String EndCell); @@ -34,7 +34,7 @@ // 鏌ヨ鍙繘姝ょ墖鐜荤拑鐨勬爡鏍煎彿 @Select("select escd.* from edg_storage_cage as esc LEFT JOIN edg_storage_cage_details as escd on esc.slot=escd.slot where escd.slot is not null escd.tempering_layout_id=#{tempering_layout_id} and escd.tempering_feed_sequence<#{tempering_feed_sequence} and esc.remain_width-#{width}>0 order by escd.tempering_feed_sequence") - List<EdgStorageCageDetails> selectIsExistIntoCache(Integer tempering_layout_id, Integer tempering_feed_sequence,double width); + List<EdgStorageCageDetails> selectIsExistIntoCache(Integer tempering_layout_id, Integer tempering_feed_sequence, double width); // 鏌ヨ鍙繘姝ょ墖鐜荤拑鐨勬爡鏍煎彿 @Select("select escd.* from edg_storage_cage as esc LEFT JOIN edg_storage_cage_details as escd on esc.slot=escd.slot where escd.slot is not null escd.tempering_layout_id<#{tempering_layout_id} and esc.remain_width-#{width}>0 order by escd.tempering_layout_id desc,escd.tempering_feed_sequence") -- Gitblit v1.8.0