package com.mes.mapper;
|
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
@Mapper
|
public interface GlassInfoMapper {
|
|
@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);
|
|
// 这里可以添加其他 SQL 语句
|
}
|
