puzhibing
4 天以前 3650ce7f5d42d1bef58abea9693f20d1f209d3b0
ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/mapper/TChargingCardMapper.java
@@ -31,4 +31,37 @@
                            @Param("amount") BigDecimal amount,
                            @Param("remark") String remark,
                            @Param("createBy") Long createBy);
    /**
     * 锁定卡片为充电中(条件更新:仅空闲卡可锁定,用于防止同卡并发多单)
     */
    int lockCardForCharging(@Param("cardId") Long cardId, @Param("orderCode") String orderCode);
    /**
     * 解锁卡片(带订单号比对,防止误释放其他订单)
     */
    int unlockCardForCharging(@Param("cardId") Long cardId, @Param("orderCode") String orderCode);
    /**
     * 订单结算原子扣款:仅按卡 ID 扣减,不限制余额下限,允许扣成负数(V0.2 定稿)
     */
    int deductBalanceByCardId(@Param("cardId") Long cardId, @Param("amount") BigDecimal amount);
    /**
     * 写入订单结算扣款流水并占用幂等键(charging_order_code 唯一索引)
     */
    int insertOrderDeductRecord(@Param("cardId") Long cardId,
                                @Param("amount") BigDecimal amount,
                                @Param("orderCode") String orderCode,
                                @Param("createBy") Long createBy);
    /**
     * 批量查询已存在的充电扣款流水订单号。
     */
    List<String> selectDeductedOrderCodes(@Param("orderCodes") List<String> orderCodes);
    /**
     * 原子清零余额(账户模式切换回收专用:仅当余额>0时清零,返回受影响行数,天然幂等)
     */
    int clearBalance(@Param("id") Long id, @Param("updateBy") Long updateBy);
}