| | |
|---|
| | | public List<TemperingGlassInfo> selectWaitingGlass() { |
|---|
| | | //获取等待进炉中的玻璃信息 |
|---|
| | | QueryWrapper<TemperingGlassInfo> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("Top 1 *").in("state",1,0); |
|---|
| | | wrapper.select("Top 1 *").in("state",1,0,-1); |
|---|
| | | TemperingGlassInfo glass=temperingMapper.selectOne(wrapper); |
|---|
| | | if(glass!=null) { |
|---|
| | | QueryWrapper<TemperingGlassInfo> glassinfo = new QueryWrapper<>(); |
|---|
| | |
|---|
| | | wrapper.select("tempering_layout_id,engineer_id,max(id) as id") |
|---|
| | | .eq("state",2) |
|---|
| | | .groupBy("tempering_layout_id,engineer_id") |
|---|
| | | .orderByDesc("id"); |
|---|
| | | .orderByAsc("id"); |
|---|
| | | return temperingMapper.selectList(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
