| | |
|---|
| | | package com.mes.uppattenusage.mapper; |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import com.mes.downglassinfo.entity.DownGlassInfo; |
|---|
| | | import com.mes.uppattenusage.entity.GlassInfo; |
|---|
| | | import org.apache.ibatis.annotations.Delete; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.apache.ibatis.annotations.Update; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * <p> |
|---|
| | |
|---|
| | | */ |
|---|
| | | public interface GlassInfoMapper extends BaseMapper<GlassInfo> { |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT COUNT(*) FROM glass_info WHERE flowcard_id = #{flowCardId}") |
|---|
| | | int getGlassInfoCountByFlowCardId(@Param("flowCardId") String flowCardId); |
|---|
| | | |
|---|
| | | @Update("UPDATE down_workstation SET total_quantity = #{glassInfoCount},flow_card_id=#{flowCardId} WHERE workstation_id = #{workstationId}") |
|---|
| | | int updateFlowCardIdAndCount(@Param("flowCardId") String flowCardId, @Param("glassInfoCount") int glassInfoCount,@Param("workstationId")int workstationId); |
|---|
| | | |
|---|
| | | } |
|---|
