<%@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 caozuoName = request.getParameter("name");
	String pLine = request.getParameter("line");
	String yemian = request.getParameter("yemian");
	//System.out.println("操作时间："+new java.util.Date()+"  当前操作："+caozuoName+";  当前生产线："+pLine);
	if ("钢化后下片位管理".equals(yemian)) {
		String caozuo = request.getParameter("caozuo");
		String leixing = request.getParameter("leixing");
		DBSession sn = null;
		boolean ok = false;
		try {
			sn = mes.getMesDBHelper().createSession(false);
			String qSQL = "";
			if ("钢化前摆片状态切换".equals(caozuo)) {
				//String zt = request.getParameter("xiPian");
				//qSQL = "update gmms_machine set remarks = " + zt + " where work_id = " + pLine+ " and machine_name like '%中空机器手%'";
				
				
				qSQL = "update gmms_machine set state =If(state='正常','暂停','正常') where work_id="+pLine +" and machine_name like '%摆片台___1%'";
			}
			if ("钢化前摆片状态".equals(caozuo)) {

				qSQL = "select state from gmms_machine where work_id = '" + pLine +"' and machine_name like '%摆片台___1%'";
			}
			sn.createSql(qSQL);
			if ("修改".equals(leixing)) {
				//String Id = request.getParameter("Id");
					sn.createSql(qSQL);
					int q = sn.update();
					System.out.println(q);
					out.print(q);
					

			}
			if ("查询".equals(leixing)) {
				JSONArray a = sn.query().resultToJson(false);
				if (a != null) {
					out.print(a.toString());
				} else {
					out.print("[]");
				}
			}
		} catch (Exception e) {
			e.printStackTrace();

		} finally {
			if (sn != null)
				sn.close();
		}
	}
	if ("钢化后下片位信息".equals(caozuoName)) {

		DBSession sn = null;
		boolean ok = false;
		try {
			sn = mes.getMesDBHelper().createSession(false);
			String qSQL = "select id,stops,flag,rank,sign,processcard_id,wanchengshu,posunshu,zongshu,weiwanchegnshu,orientation,stop_rank from v_gh_xiapianwei where groups="
					+ pLine;
			sn.createSql(qSQL);
			//System.out.print(qSQL);
			//sn.createStdCall("aaa",3);
			//String s= sn.stdCall(1,2,3).ResultMessage;
			JSONArray a = sn.query().resultToJson(false);
			if (a != null) {
				out.print(a.toString());
			} else {
				out.print("[]");
			}
			//out.print(pLine);
			ok = true;
		} catch (Exception e) {
			e.printStackTrace();

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

	}

	//更新数据
	if ("钢化后下片位退库".equals(caozuoName)) {
		String tkId = request.getParameter("Id");
		DBSession sn = null;
		try {

			sn = mes.getMesDBHelper().createSession(false);
			String qSQL = "update gmms_drop_frame_5 set sign=4  where Id = " + tkId;
			sn.createSql(qSQL);
			int s = sn.update();
			out.print(s);

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

		} finally {

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

	}

	if ("钢化后下片位清空信息".equals(caozuoName)) {
		String qkId = request.getParameter("Id");
		DBSession sn = null;
		try {

			sn = mes.getMesDBHelper().createSession(false);
			
			String qSQL = "update gmms_shelf_rack_2 set processcard_id=null where Id = (select rank from gmms_drop_frame_5 where Id = "+qkId+")";
			sn.createSql(qSQL);
			int s = sn.update();
			
			out.print(s);

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

		} finally {

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

	if ("钢化后绑定料架".equals(caozuoName)) {
		String xiaPianWeiId = request.getParameter("Id");
		String liaoJiaId = request.getParameter("LJId");
		DBSession sn = null;
		try {

			sn = mes.getMesDBHelper().createSession(false);
			//String qSQL = "update gmms_drop_frame_3 set rank = ?,flag=1  where Id = ?";
			String qSQL = "update gmms_drop_frame_5 set rank = ?,sign=1  where Id = ?";
			sn.createSql(qSQL);
			int s = sn.update(liaoJiaId,xiaPianWeiId);
			qSQL = "update gmms_shelf_rack_2 set state='正在使用' where Id=?";
			sn.createSql(qSQL);
			int q = sn.update(liaoJiaId);
			
			out.print(s+"_"+q);

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

		} finally {

			if (sn != null) {
				sn.close();
			}
		}
	}
	
	
	if("钢化后空架列表".equals(caozuoName)){
		String ABMian = request.getParameter("AB");
		String aOrb =Integer.parseInt(ABMian)==1?"A":"B";
		//System.out.println("ABMian"+ABMian+";"+aOrb);
		DBSession sn = null;
		boolean ok = false;
		try {
			sn = mes.getMesDBHelper().createSession(false);
			String qSQL = "select id,state,processcard_id from v_cc_liaojia where  state != '正在使用' and falg ='启用' and orientation ='"+aOrb+"'";
			sn.createSql(qSQL);
			//System.out.println(qSQL);
			//sn.createStdCall("aaa",3);
			//String s= sn.stdCall(1,2,3).ResultMessage;
			JSONArray a = sn.query().resultToJson(false);
			if (a != null) {
				out.print(a.toString());
			} else {
				out.print("[]");
			}
			//out.print(pLine);
			ok = true;
		} catch (Exception e) {
			e.printStackTrace();

		} finally {
			if (sn != null)
				sn.close();
		}
	}
	if("工位状态变更".equals(caozuoName)){
		String s = request.getParameter("State");
		String id = request.getParameter("Id");
		DBSession sn = null;
		try {
			sn = mes.getMesDBHelper().createSession(false);
			String qSQL = "Update gmms_drop_frame_5 set flag = if(flag=1,0,1) where Id="+id;
			sn.createSql(qSQL);
			int a = sn.update();
			//System.out.println(qSQL+"  "+a);
			out.print(a);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (sn != null)
				sn.close();
		}
		
	}
	
	
	//System.out.println("操作时间："+new java.util.Date()+"  操作结束");
%>