<%@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("yemian");
	if ("吊装管理".equals(yemian)) {
		String caozuo = request.getParameter("caozuo");
		String leixing = request.getParameter("leixing");
		String pLine = request.getParameter("line");
		DBSession sn = null;
		boolean ok = false;
		try {
			sn = mes.getMesDBHelper().createSession(false);
			String qSQL = "";

			if ("获取列表".equals(caozuo)) {
				qSQL = "select dr.id,dr.drop_groups,dr.stops,dr.stop_rank,dr.rank,sr.processcard_id,sr.orientation,dr.sign,dr.flag,dr.rankposition from gmms_drop_frame_5 as dr left join gmms_shelf_rack_2 as sr on dr.rank=sr.id"+
						" where groups_=5 order by stops asc";
			}

			if ("退库".equals(caozuo)) {
				String Id = request.getParameter("Id");
				//qSQL = "update gmms_drop_frame_4 set sign=4  where Id = " + Id;
				qSQL = "update gmms_drop_frame_5 set sign=6  where Id = " + Id;
			}
			if ("获取空架".equals(caozuo)) {
				qSQL = "select dr.*,sr.processcard_id from gmms_drop_frame_5 as dr left join gmms_shelf_rack_2 as sr on dr.rank=sr.id where groups_=100 and rank is not null and dr.sign=0 and dr.flag=1";
			}
			if ("料架状态".equals(caozuo)) {
				String Id = request.getParameter("Id");
				String flag = Integer.parseInt(request.getParameter("flag")) == 1 ? "0" : "1";
				//qSQL = "update gmms_drop_frame_4 set flag = "+flag+" where Id = "+Id;

				qSQL = "update gmms_drop_frame_5 set flag = " + flag + " where Id = " + Id;
			}
			if ("吸片模式切换".equals(caozuo)) {
				String zt = request.getParameter("xiPian");
				qSQL = "update gmms_machine set remarks = " + zt + " where work_id = " + pLine
						+ " and machine_name like '%中空机器手%'";
			}
			if ("吸片状态".equals(caozuo)) {

				qSQL = "select remarks from gmms_machine where work_id = " + pLine
						+ " and machine_name like '%中空机器手%'";
			}
			//System.out.println(qSQL);
			sn.createSql(qSQL);
			//System.out.print(qSQL);
			if ("修改".equals(leixing)) {
				String Id = request.getParameter("Id");
				if ("绑定料架".equals(caozuo)) {
					String liaoJiaId = request.getParameter("liaoJiaId");
					//qSQL = "update gmms_drop_frame_4 set rank = ?,sign=1  where Id = ?";
					qSQL = "update gmms_drop_frame_5 as dr left join gmms_drop_frame_5 as dr2 on dr.id="+Id+" and dr2.id="+liaoJiaId
							+" set dr.rank=dr2.rank,dr.sign=0,dr2.sign=10"
							+" where dr.id="+Id+" and dr2.id="+liaoJiaId+" and dr.rank is null and dr.sign=0 and dr2.sign=0";
					sn.createSql(qSQL);
					int s = sn.update();					
					out.print(s);
				} else if ("清空信息".equals(caozuo)) {
					qSQL = "update gmms_drop_frame_5 as dr left join gmms_drop_frame_5 as dr2 on dr.rank=dr2.rank"
							+" set dr.rank=null,dr.sign=0,dr2.sign=0"
							+" where dr.id="+Id+" and dr2.groups_=100 and dr.rank is not null";
					sn.createSql(qSQL);
					int s = sn.update();
					out.print(s);
				}else if ("清除流程卡".equals(caozuo)) {
					qSQL = "update gmms_drop_frame_5 as dr left join gmms_shelf_rack_2 as sr on dr.rank=sr.id"
							+" set sr.processcard_id=null"
							+" where dr.id="+Id+" and dr.rank is not null";
					sn.createSql(qSQL);
					int s = sn.update();
					out.print(s);
				}else if ("绑定流程卡".equals(caozuo)) {
					String liuchengka = request.getParameter("liuchengka");
					qSQL = "insert into gmms_galss_task_shelf" 
							+" (id,rank,type_id,galss_id,pattern_id,width,height,thickness,color,edg_width,edg_height,chamfer_size,"
							+" galss_type,edg_speed1,edg_speed2,fine_throwing,work_state,work_procedure,slicecage_rank,drop_frame,"
							+" slicecage_flag,out_rank,start_time,finsh_time,stop_position,processcard_id,engineering_id,broken_state,"
							+" stop_rank,work_procedure_number,gc_number,gc_width,gc_height,gc_stockid,marking_flag) "
							+" select gt.id,gt.rank,gt.type_id,gt.galss_id,gt.pattern_id,gt.width,gt.height,gt.thickness,gt.color,gt.edg_width,gt.edg_height,"
							+" gt.chamfer_size,gt.galss_type,gt.edg_speed1,gt.edg_speed2,gt.fine_throwing,'已完成','钢化后下片',gt.slicecage_rank,"
							+" gt.drop_frame,gt.slicecage_flag,gt.out_rank,gt.start_time,gt.finsh_time,0,gt.processcard_id,gt.engineering_id,"
							+" gt.broken_state,gt.stop_rank,gt.work_procedure_number,(select parent_liuchengka from gmms_liuchengka "
							+" 	where liuchengka='"+liuchengka+"'),gt.gc_width,gt.gc_height,gt.gc_stockid,gt.marking_flag "
							+" from gmms_galss_task_stock as gt left join gmms_galss_task_shelf as gs on gt.id=gs.id"
							+" where gt.processcard_id='"+liuchengka+"' and gs.id is null";
					sn.createSql(qSQL);
					int s = sn.update();
					System.out.println("绑定 流程卡1："+liuchengka+"    "+s+"   /n"+qSQL);
					qSQL = "update gmms_drop_frame_5 as dr left join gmms_shelf_rack_2 as sr on dr.rank=sr.id"
							+" set sr.processcard_id=(select processcard_id from gmms_galss_task_shelf where processcard_id='"+liuchengka+"' limit 0,1)"
							+" where dr.id="+Id+" and dr.rank is not null";
					sn.createSql(qSQL);
					int q = sn.update();				
					out.print(s);
					System.out.println("绑定 流程卡2："+liuchengka+"    "+q+"   /n"+qSQL);
				}
				else {
					sn.createSql(qSQL);
					int q = sn.update();
					out.print(q);
				}
			}
			if ("查询".equals(leixing)) {
				JSONArray a = sn.query().resultToJson(false);
				if (a != null) {
					out.print(a.toString());
				} else {
					out.print("[]");
				}
			}
			//sn.createStdCall("aaa",3);
			//String s= sn.stdCall(1,2,3).ResultMessage;

		} catch (Exception e) {
			e.printStackTrace();

		} finally {
			if (sn != null)
				sn.close();
		}
	}


%>