From fddf1c716af76c2968e08ce11895eaa1c26319a5 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期二, 26 十一月 2024 14:43:21 +0800 Subject: [PATCH] 增加翻译文件和bug解决 --- springboot-vue3/src/main/java/com/example/springboot/mapper/AlbaniaMapper.java | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/AlbaniaMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/AlbaniaMapper.java index b5faca2..0602273 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/mapper/AlbaniaMapper.java +++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/AlbaniaMapper.java @@ -18,7 +18,7 @@ @Select("select id from storage_cage where glasstype=#{glasstype} and width>=#{width}+#{widths} and disabled=0 order by id limit 1") StorageCage SelectCage(int glasstype,Double width,int widths); //鍒ゆ柇绗煎唴娌℃湁鐜荤拑鐨勭┖鏍� - @Select("select id from storage_cage where (number is null or number=0) and cage>#{cage} and cage<#{cage2} and disabled=0 order by id limit 1") + @Select("select id from storage_cage where (number is null) and cage>#{cage} and cage<#{cage2} and disabled=0 order by id limit 1") StorageCage SelectNewCell(int cage,int cage2); //澧炲姞鐜荤拑鏁� @Update("update storage_cage set number=number+1,width=width-glasswidth where id=#{id}") @@ -33,8 +33,8 @@ @Insert("INSERT INTO `albania`.`out_task`(`task_type`, `task_state`, `shelf_rack`, `load_rack`,start_time,glass_id,glasstype,flowcard,mateid,tier) VALUES (#{tasktype},#{taskstate},#{shelfrack},#{loadrack},now(),#{glassid},#{glasstype},#{flowcard},#{mateid},#{tier});") void InsertOutTask(int tasktype, int taskstate, int shelfrack, int loadrack, String glassid, int glasstype,String flowcard,int mateid,int tier); //鏂板涓�鏉$瀛愭暟鎹� - @Update("UPDATE `albania`.`storage_cage` SET `glass_id` =#{glassid}, `width` =width-#{glasswidth}, `glasswidth` =#{glasswidth}, `glassheight` =#{glassheight}, `glasswidthmm` =#{glasswidth}, `glassheightmm` = #{glassheight}, `state` = #{state}, `glasstype` = #{glasstype}, `number` = #{number},thickness=#{thickness},films=#{films},flowcard=#{flowcard},mateid=#{mateid} WHERE `id` =#{id};") - void AddCage(int id,String glassid,Double glasswidth,Double glassheight,int state,int glasstype,int number,Double thickness,String films,String flowcard,int mateid); + @Update("UPDATE `albania`.`storage_cage` SET `glass_id` =#{glassid}, `width` =width-#{glasswidth}, `glasswidth` =#{glasswidth}, `glassheight` =#{glassheight}, `glasswidthmm` =#{glasswidth}, `glassheightmm` = #{glassheight}, `state` = #{state}, `glasstype` = #{glasstype}, `number` = #{number},thickness=#{thickness},films=#{films},flowcard=#{flowcard},mateid=#{mateid},tier=#{tier} WHERE `id` =#{id};") + void AddCage(int id,String glassid,Double glasswidth,Double glassheight,int state,int glasstype,int number,Double thickness,String films,String flowcard,int mateid,int tier); //鑾峰彇杩涚墖鏁版嵁 @Select("select glassid,flowcard,glasswidth as width,glassheight as height,glasswidthmm,glassheightmm,glasstype,thickness from queue where state=1 limit 1") GlassInfo SelectGlass(); -- Gitblit v1.8.0