From 865c5d54ca63ed7a5bda4a92d27ea0b7c6e61b04 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期三, 17 十二月 2025 18:02:56 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/jiashida
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
index c2b16b2..0ff7398 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
@@ -1,7 +1,9 @@
package com.ruoyi.system.mapper;
-import com.ruoyi.system.model.TBigGiftPackage;
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>
@@ -13,4 +15,14 @@
*/
public interface TBigGiftPackageMapper extends BaseMapper<TBigGiftPackage> {
+ /**
+ * 使用乐观锁扣减库存
+ *
+ * @param id 商品ID
+ * @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);
+
}
--
Gitblit v1.7.1