From 1479f77b88e355ce2c7c073458d919c8e06baa18 Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期一, 04 十二月 2023 09:10:11 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java | 7 +++++-- 1 files changed, 5 insertions(+), 2 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 d64b361..75581e5 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 @@ -58,8 +58,11 @@ StorageCage selectGlassCage(int cage,double width,int cage1,int cage2); //鍒犻櫎绗煎瓙淇℃伅(鍑虹墖) - @Update("update storage_cage as a set state=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=0 where cage=#{cage} and cell=#{cell} and tier=#{tier};") - void UpdataGlassCage(String orderid,String glassid,double width,int cage,int cell,int tier,int state); + @Update("update storage_cage as a set state=#{state},glass_id=null,order_id=null,glasswidth=0,a.glassheight=null,a.glasswidthmm=null,a.glassheightmm=null,a.listid=null,a.boxid=null where glassid=#{glassid};") + void UpdataGlassCage(String glassid,int state); + //鏀瑰彉鐜荤拑鐘舵�佷负鍑虹墖涓� + @Update("update storage_cage as a set state=#{state} where glass_id=#{glassid};") + void UpdataGlassCageState(String glassid,int state); //淇敼绗煎瓙淇℃伅(杩涚墖) @Update("update storage_cage set state=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=#{width} where id=#{id};") -- Gitblit v1.8.0