From 0b83163518f23e4571f3f510c38e9a25f46b6d07 Mon Sep 17 00:00:00 2001 From: clll <1320612696@qq.com> Date: 星期五, 08 九月 2023 17:06:00 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.150:10101/r/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java index c8dc1a5..b688705 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java +++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java @@ -40,7 +40,9 @@ //鍒ゆ柇璇ヨ皟鎷ㄧ殑绗煎瓙 @Select("select cage,cell,max(state)as shu from storage_cage where width>=#{width} and cage>#{cage1} and cage<#{cage2} GROUP BY cage,cell HAVING shu=0 order by abs(#{cage} - cage) limit 1;") StorageCage selectGlassCage(int cage,double width,int cage1,int cage2); - + //淇敼绗煎瓙淇℃伅(杩涚墖) +// @Update("update storage_cage set state=1,width=width #{width},glass_id=#{glassid},order_id=#{orderid},glasswidth=#{glasswidth} where cage=#{cage} and cell=#{cell} and tier=#{tier}"); + // @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})") // void insert (Spian spian); -- Gitblit v1.8.0