| | |
| | | import com.zy.entity.BasDevp; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Update; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.util.List; |
| | |
| | | List<Integer> getAvailableInSite(@Param("typeNo") Integer typeNo); |
| | | |
| | | List<Integer> getAvailableOutSite(@Param("typeNo") Integer typeNo); |
| | | |
| | | @Update("UPDATE asr_bas_devp SET in_qty = in_qty - 1 WHERE dev_no = #{site} AND in_qty > 0") |
| | | void decrementInQty(@Param("site") int sourceStaNo); |
| | | } |