数据库批量操作锁定和释放库存

type类型：1锁定，2释放

实现思路：利用【case when and then end】来判断锁定和释放是否超过库存限制，若是超过则sql不成立，执行后会报错，表示锁定或释放库存失败

    update        stock_real_time                                                                                    whenerp_stock_code = #{item.erpStockCode}                        and dd_code = #{item.ddCode}                                                and channel_id = #{item.channelId}                                                and channel_code = #{item.channelCode}                                                and erp_sku_code = #{item.erpSkuCode}                                                andbatch_code = #{item.batchCode}                        andstock_count >= (preempt_count + #{item.preemptCount})                        thenpreempt_count + #{item.preemptCount}                                                                whenerp_stock_code = #{item.erpStockCode}                        and dd_code = #{item.ddCode}                                                and channel_id = #{item.channelId}                                                and channel_code = #{item.channelCode}                                                and erp_sku_code = #{item.erpSkuCode}                                                andbatch_code = #{item.batchCode}                        thenpreempt_count - #{item.preemptCount}                                                                where        is_deleted = 0    and    (                        erp_stock_code = #{item.erpStockCode}                            and dd_code = #{item.ddCode}                                        and channel_id = #{item.channelId}                                        and channel_code = #{item.channelCode}                                        and erp_sku_code = #{item.erpSkuCode}                        and                batch_code = #{item.batchCode}            )

来源地址：https://blog.csdn.net/a443892091/article/details/124269374