义乌项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
严智鑫
2024-06-14 6977fb42d5067f6c938ef3de559a6ad19b542a0b 
 hangzhoumesParent/moduleService/TemperingGlassModule/src/main/java/com/mes/temperingglass/mapper/TemperingMapper.java


@@ -1,33 +1,15 @@


package com.mes.temperingglass.mapper;




import com.baomidou.dynamic.datasource.annotation.DS;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;


import com.mes.temperingglass.entity.GlassInfo;


import com.mes.temperingglass.entity.TemperingGlassInfo;


import org.apache.ibatis.annotations.Mapper;


import org.apache.ibatis.annotations.Select;




import java.util.List;




import org.apache.ibatis.annotations.*;




@Mapper


@DS("salve_hangzhoumes")


public interface TemperingMapper extends BaseMapper<TemperingGlassInfo> {






//查询该玻璃的尺寸和坐标


@Select("select *from glass_info where id=#{glassid};")


GlassInfo SelectGlass(String glassid);


//是否可以发送进炉信号


@Select("select count(*) from glass_info where id=#{glassid};")


int SelectTempering(String glassid);


//查询等待中的钢化版图玻璃信息


@Select("select*from tempering_glass_info a left join (select flowcard_id,count(state)state from tempering_glass_info GROUP BY flowcard_id,state)b on a.flowcard_id=b.flowcard_id where b.state=2")


List<TemperingGlassInfo> SelectWaitingGlass();


//查询进炉中的钢化版图玻璃信息


@Select("select*from tempering_glass_info a left join (select flowcard_id,min(state)state1 from tempering_glass_info GROUP BY flowcard_id having state1=1)b on a.flowcard_id=b.flowcard_id where b.state1=1")


List<TemperingGlassInfo> SelectInGlass();


//查询钢化后的钢化版图信息


@Select("select*from tempering_glass_info a left join (select flowcard_id,min(state)state1 from tempering_glass_info GROUP BY flowcard_id having state1=2)b on a.flowcard_id=b.flowcard_id where b.state1=2")


List <TemperingGlassInfo> SelectOutGlass();








}