ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
@@ -3,7 +3,6 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.system.model.TBigGiftPackage; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Update; /** * <p> @@ -22,7 +21,6 @@ * @param quantity 扣减数量 * @return 更新行数(0表示库存不足或并发冲突) */ @Update("UPDATE t_big_gift_package SET inventory = inventory - #{quantity} WHERE id = #{id} AND inventory >= #{quantity} AND status = 1") int deductInventory(@Param("id") Integer id, @Param("quantity") Integer quantity); }