From 3eced65b14a858329fd2b7f4c8bc6c5d66710c78 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期三, 06 九月 2023 16:57:01 +0800 Subject: [PATCH] Merge branch 'master' of ssh://10.153.19.150:29418/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java index 112af50..85d809a 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java +++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java @@ -36,9 +36,14 @@ short SelectOrder(@Param("orderid") String orderid); // @Insert("insert into order_out(orderid) values('#{orderid}')") - @Insert("INSERT INTO `canadames`.`order_out`( `orderid`,`mod_time`) VALUES ( #{orderid},now())") + @Insert("INSERT INTO `canadames`.`order_out`( `order_id`,`mod_time`) VALUES ( #{orderid},now())") void InsertOrder(String orderid); + //鍋滄鎸夊綋鍓嶈鍗曞嚭鐗� @Update("update order_out set state=1 where state=0") void updateOrder(); + + //鏌ヨ鏄惁瀛樺湪姝e湪涓婄墖鐨勪换鍔� + @Select("select count(*) from storage_task where task_state=0 and task_type=1") + short SelectOutTask(); } -- Gitblit v1.8.0