<%@page import="com.northglass.Globel.mes"%> <%@page import="com.northglass.SqlHelper.*"%> <%@page import="org.json.*"%> <%@ page contentType="text/json;charset=UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <% //String yemian = request.getParameter("gongyi"); String line = request.getParameter("line"); String caozuo = request.getParameter("caozuo"); String leixing = request.getParameter("leixing"); String Id = request.getParameter("Id"); String gongyi = request.getParameter("gongyi"); DBSession sn = null; boolean ok = false; try { sn = mes.getMesDBHelper().createSession(false); String strSQL = ""; if ("获取列表".equals(caozuo)) { if ("钢化前".equals(gongyi)) { //strSQL = "select * from gmms_galss_task_2 where groups= " + line // + " and orders is not null and (work_procedure='钢化上片' or work_procedure='钢化前复合' or work_procedure='钢化前摆片' or work_procedure='钢化') and work_state<>'破损' order by furnace,orders"; strSQL = "select * from v_ghq_online_glass where groups = " + line; } if ("钢化后".equals(gongyi)) { //strSQL = "select * from gmms_galss_task_2 where groups=" + line // + " and orders is not null and ((work_procedure='钢化' and work_state<>'等待中' ) or (work_procedure='钢化后摆片' ) or (work_procedure='钢化后复合') or (work_procedure='钢化后下片' and work_state<>'已完成')) and work_state<>'破损' order by furnace,grouporder,fine_throwing"; strSQL = "select * from v_ghh_online_glass where groups = " + line; } if ("中空".equals(gongyi)) { } sn.createSql(strSQL); JSONArray a = sn.query().resultToJson(false); if (a != null) { out.print(a.toString()); } else { out.print("[]"); } } if ("人工拿走".equals(caozuo)) { if ("钢化前".equals(gongyi)) { } if ("钢化后".equals(gongyi)) { } if ("中空".equals(gongyi)) { } sn.createSql(strSQL); int s = sn.update();//括号内是参数，没有参数不输入 out.print(s); } if ("设置完成".equals(caozuo)) { if ("钢化前".equals(gongyi)) { } if ("钢化后".equals(gongyi)) { } if ("中空".equals(gongyi)) { } sn.createSql(strSQL); int s = sn.update();//括号内是参数，没有参数不输入 out.print(s); } if ("修改".equals(caozuo)) { if ("变更班组".equals(leixing)) { String bzinfo = request.getParameter("info"); strSQL = "update gmms_user_current set banzu = '" + bzinfo + "' where gongyi = '" + gongyi + "' and chanxian = " + line; } if ("重新上片".equals(leixing)) { /*galssTask.setWorkState("已优化"); galssTask.setWorkProcedure("钢化上片");*/ strSQL = "update gmms_galss_task_2 set work_state = '已优化',work_procedure='钢化上片' ,galss_id = 0 where id="+Id; } if ("重新摆片".equals(leixing)) { /* galssTask.setWorkState("等待中"); galssTask.setWorkProcedure("钢化前摆片"); */ strSQL = "update gmms_galss_task_2 set work_state = '等待中',work_procedure='钢化前摆片' where id="+Id; } if ("重新钢化".equals(leixing)) { /* galssTask.setWorkState("等待中"); galssTask.setWorkProcedure("钢化"); */ strSQL = "update gmms_galss_task_2 set work_state = '等待中',work_procedure='钢化' where id="+Id; } if ("重新复合".equals(leixing)) { if("钢化前".equals(gongyi)){ /* galssTask.setWorkState("等待中"); galssTask.setWorkProcedure("钢化前复合"); */ strSQL = "update gmms_galss_task_2 set work_state = '等待中',work_procedure='钢化前复合' where id="+Id; }else if ("钢化后".equals(gongyi)){ /* galssTask.setWorkState("待复合"); galssTask.setWorkProcedure("钢化后复合"); */ strSQL = "update gmms_galss_task_2 set work_state = '待复合',work_procedure='钢化后复合' where id="+Id; } } if ("下片完成".equals(leixing)) { /* galssTask.setWorkState("已完成"); galssTask.setWorkProcedure("钢化后下片"); */ //strSQL = "select count(1) from gmms_galss_task_2 where processcard_id = ( select processcard_id from gmms_galss_task_2 where id = '"+Id+"') and work_state = '已完成',work_procedure='钢化后下片'"; String snum ="select ( select count(1) from gmms_galss_task_2 where processcard_id = ( select processcard_id from gmms_galss_task_2 where id = '"+Id+"') and work_state = '已完成' and work_procedure='钢化后下片')+1"; sn.createSql(snum); JSONArray a = sn.query().resultToJson(false); //JSONArray a = sn.query(); if (a != null) { //num = a[0][0].toString(); String num = a.getJSONArray(0).getString(0); strSQL="update gmms_galss_task_2 as gt INNER join gmms_user_current as guc on gt.groups=guc.chanxian "+ "set gt.work_state='已完成',gt.work_procedure='钢化后下片',gt.fine_throwing=0,gt.stop_position=0,gt.stop_rank= '"+num+"',gt.finsh_time=NOW(),gt.banzu=guc.banzu "+ "where guc.gongyi='钢化' and gt.work_state!='人工拿走' and gt.work_state!='破损' and gt.id="+Id; //strSQL = "update gmms_galss_task_2 set work_state = '已完成',work_procedure='钢化后下片',stop_rank = '"+num+"',finsh_time = null,fine_throwing = 0 where id="+Id; } } if ("重新下片".equals(leixing)) { strSQL = "update gmms_galss_task_2 set work_state = '等待中',work_procedure='钢化后下片' where id="+Id; } if ("人工拿走".equals(leixing)) { String NazouSql = "update gmms_galss_task_2 set work_state = '破损' where id="+Id; sn.createSql(NazouSql); int s = sn.update(); strSQL ="INSERT INTO e_record_tempering(processcard_id, glass_id, width, height, thinkess, color, sequence, create_time, line, team_name, type_num, is_report,rank) "+ "select gt.processcard_id,gt.id,gt.edg_width,gt.edg_height,gt.thickness,gt.color,gt.stop_rank,NOW(),gt.groups,guc.banzu,gt.edg_speed2,1,0 from gmms_galss_task_2 as gt INNER join gmms_user_current as guc on gt.groups=guc.chanxian "+ "left join e_record_tempering as et on gt.id=et.glass_id "+ "where guc.gongyi='钢化' and gt.id='"+Id+"' and et.glass_id is null"; } //System.out.println(strSQL); sn.createSql(strSQL); int s = sn.update(); //System.out.println(s); out.print(s); } } catch (Exception e) { e.printStackTrace(); } finally { if (sn != null) sn.close(); } %>