From 682a7f41ec41c3865312dc68e849f93f5387e7fc Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期四, 13 六月 2024 21:06:02 +0800 Subject: [PATCH] 提交【管理后台】订单管理相关接口 --- ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomGoodsMapper.xml | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomGoodsMapper.xml b/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomGoodsMapper.xml index b525c61..dab48d2 100644 --- a/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomGoodsMapper.xml +++ b/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomGoodsMapper.xml @@ -3,11 +3,17 @@ <mapper namespace="com.ruoyi.auction.mapper.AuctionSalesroomGoodsMapper"> <update id="updateBatchById" parameterType="java.util.List"> UPDATE t_auction_salesroom_goods - SET status = CASE + SET + backup_status = CASE + <foreach collection="param" item="item" index="index"> + WHEN id = #{item.id} THEN #{item.backupStatus} + </foreach> + ELSE status END, + status = CASE <foreach collection="param" item="item" index="index"> WHEN id = #{item.id} THEN #{item.status} </foreach> - END + ELSE status END WHERE id IN <foreach collection="param" index="index" item="item" open="(" separator="," close=")"> #{item.id} -- Gitblit v1.7.1