| | |
|---|
| | | Integer SelectMaxTypes(String key); |
|---|
| | | |
|---|
| | | //查询所有玻璃膜系和厚度 |
|---|
| | | @Select("select films,thickness from glassinfo GROUP BY films,thickness") |
|---|
| | | @Select("select films,thickness from flowcard a left join glassinfo b on a.flowcard=b.flowcard where orderstate=1 GROUP BY films,thickness") |
|---|
| | | List<GlassInfo> SelectMeasure(); |
|---|
| | | @Select("select*from measuresetting") |
|---|
| | | MeasureSetting SelectMeasureSetting(); |
|---|
| | |
|---|
| | | @Select("SELECT a.id,a.flowcard,customer,a.mateid,a.tier,b.films,b.thickness,b.width,b.height,a.task_state as state FROM `out_task` a left join glassinfo b on a.glasstype=b.glasstype where task_state!=1 ORDER BY task_state") |
|---|
| | | List<Map>SelectOutTask(); |
|---|
| | | //查询出片记录数据 |
|---|
| | | @Select(" select a.id,a.flowcard,customer,a.mateid,a.tier,b.films,b.thickness,b.width,b.height,a.task_state,a.shelf_rack as cell from storage_task a left join glassinfo b on a.glasstype=b.glasstype where task_state=1 and task_type=1 ORDER BY a.id desc LIMIT 6;") |
|---|
| | | @Select(" select a.id,a.flowcard,customer,a.mateid,a.tier,b.films,b.thickness,b.width,b.height,a.task_state as state,a.shelf_rack as cell from storage_task a left join glassinfo b on a.glasstype=b.glasstype where task_type=1 ORDER BY a.id desc LIMIT 6;") |
|---|
| | | List<Map>SelectOutLog(); |
|---|
| | | } |
|---|
