| | |
|---|
| | | String qSQL = ""; |
|---|
| | | |
|---|
| | | if ("鑾峰彇鍒楄〃".equals(caozuo)) { |
|---|
| | | qSQL = "select id,galss_id,width,height,thickness,processcard_id,stop_rank,stop_position,work_procedure,work_state,gc_number,null from gmms_galss_task_shelf where work_procedure!='涓┖涓婄墖' and processcard_id=(select liuchengka from gmms_liuchengka where current_status='姝ｅ湪宸ヤ綔' and current_work_position='鐞嗙墖' limit 0,1) order by processcard_id asc,stop_rank desc"; |
|---|
| | | qSQL = "select id,galss_id,width,height,thickness,processcard_id,stop_rank,stop_position,work_procedure,work_state,gc_number,null from gmms_galss_task_shelf " |
|---|
| | | + " where work_procedure!='涓┖涓婄墖' and processcard_id=(select lk.liuchengka from gmms_drop_frame_5 as dr5 " |
|---|
| | | + " left join gmms_shelf_rack_2 as sr on dr5.rank=sr.id " |
|---|
| | | + " left join gmms_liuchengka as lk on sr.processcard_id=lk.liuchengka " |
|---|
| | | + " where groups_=3 and drop_groups=1 and sr.id is not null and lk.liuchengka is not null and " |
|---|
| | | + " lk.current_status='姝ｅ湪宸ヤ綔' and lk.current_work_position='鐞嗙墖' limit 0,1) order by processcard_id asc,stop_rank desc"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //System.out.println(qSQL); |
|---|
