package cn.iocoder.yudao.module.mes.dal.mysql.wm.materialstock; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; @Mapper public interface MesWmMaterialStockFreezeClaimMapper { @Insert("INSERT IGNORE INTO mes_wm_material_stock_freeze_claim(stock_id, source_type, source_id) " + "VALUES(#{stockId}, #{sourceType}, #{sourceId})") int acquire(@Param("stockId") Long stockId, @Param("sourceType") String sourceType, @Param("sourceId") Long sourceId); @Delete("DELETE FROM mes_wm_material_stock_freeze_claim " + "WHERE stock_id = #{stockId} AND source_type = #{sourceType} AND source_id = #{sourceId}") int release(@Param("stockId") Long stockId, @Param("sourceType") String sourceType, @Param("sourceId") Long sourceId); @Select("SELECT COUNT(*) FROM mes_wm_material_stock_freeze_claim WHERE stock_id = #{stockId}") long countByStockId(@Param("stockId") Long stockId); }