<%@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 id,groups,stops,rank,flag,sign,processcard_id,zongshu,kuneishu,quepianshu,wanchengshu,shengyushu,orientation,stop_rank from v_zk_shangpianwei where groups="
|
+ pLine;
|
}
|
|
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=4 where Id = " + Id;
|
}
|
if ("获取空架".equals(caozuo)) {
|
String aOrb = Integer.parseInt(request.getParameter("AB")) == 1 ? "A" : "B";
|
qSQL = "select id,state,processcard_id from gmms_shelf_rack_2 where state != '正在使用' and falg ='启用' and orientation ='"
|
+ aOrb + "'";
|
}
|
if ("料架状态".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
String flag = Integer.parseInt(request.getParameter("flag")) == 1 ? "2" : "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 '%中空机器手%'";
|
}
|
|
if ("领取模式状态".equals(caozuo)) {
|
qSQL = "select IF(mode_type='自动',0,1) from y_mode_type where number='ZKXZ0001' and groups="+pLine;
|
}
|
if ("领取模式切换".equals(caozuo)) {
|
String Ms = request.getParameter("moshi");
|
if("0".equals(Ms)){
|
qSQL = "update y_mode_type set mode_type='自动' where number='ZKXZ0001' and groups="+pLine;
|
}else{
|
qSQL = "update y_mode_type set mode_type='手动' where number='ZKXZ0001' and groups="+pLine;
|
}
|
|
}
|
//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 set rank = ?,sign=1 where Id = ?";
|
sn.createSql(qSQL);
|
int s = sn.update(liaoJiaId, Id);
|
qSQL = "update gmms_shelf_rack_2 set state='正在使用' where Id=?";
|
sn.createSql(qSQL);
|
int q = sn.update(liaoJiaId);
|
out.print(s + "_" + q);
|
} else if ("清空信息".equals(caozuo)) {
|
|
qSQL = "update gmms_shelf_rack_2 set state='使用中' where Id = (select rank from gmms_drop_frame_5 where Id = "
|
+ Id + ")";
|
sn.createSql(qSQL);
|
int s = sn.update();
|
qSQL = "update gmms_drop_frame_5 set sign= 0,rank = null where Id = " + Id;
|
sn.createSql(qSQL);
|
int q = sn.update();
|
out.print(s + "_" + q);
|
}
|
|
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();
|
}
|
}
|
|
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)) {
|
qSQL = "select id,stops,rank,flag,sign,processcard_id,zongshu,kuneishu,posunshu,quepianshu,yishangpian,jiazishengyushu,orientation,stop_rank from v_zklp_shangpianwei";
|
}
|
/* if ("清空信息".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
qSQL = "update gmms_drop_frame_4 set sign= 0,rank = null where Id = " + Id;
|
} */
|
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=4 where Id = " + Id;
|
}
|
if ("出库".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
//qSQL = "update gmms_drop_frame_4 set sign=4 where Id = " + Id;
|
qSQL = "update gmms_liuchengka set ischu='待出库' where liuchengka='"+Id+"' and ischu is null;";
|
}
|
if ("获取空架".equals(caozuo)) {
|
String aOrb = Integer.parseInt(request.getParameter("AB")) == 1 ? "A" : "B";
|
qSQL = "select id,state,processcard_id from gmms_shelf_rack_2 where state != '正在使用' and falg ='启用' and orientation ='"
|
+ aOrb + "'";
|
}
|
if ("料架状态".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
String flag = Integer.parseInt(request.getParameter("flag")) == 1 ? "2" : "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 id = 47";
|
}
|
if ("吸片状态".equals(caozuo)) {
|
|
qSQL = "select remarks from gmms_machine where id = 47 ";
|
}
|
//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_5 set rank = ?,sign=1 where Id = ?";
|
sn.createSql(qSQL);
|
int s = sn.update(liaoJiaId, Id);
|
qSQL = "update gmms_shelf_rack_2 set state='正在使用' where Id=?";
|
sn.createSql(qSQL);
|
int q = sn.update(liaoJiaId);
|
out.print(s + "_" + q);
|
} else if ("清空信息".equals(caozuo)) {
|
|
qSQL = "update gmms_shelf_rack_2 set state='使用中' where Id = (select rank from gmms_drop_frame_5 where Id = "
|
+ Id + ")";
|
sn.createSql(qSQL);
|
int s = sn.update();
|
qSQL = "update gmms_drop_frame_5 set sign= 0,rank = null where Id = " + Id;
|
sn.createSql(qSQL);
|
int q = sn.update();
|
out.print(s + "_" + q);
|
} 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();
|
}
|
}
|
|
|
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)) {
|
qSQL = "select xuhao,zkliuchengka,liuchengkas,zongshu,kuneishu from y_parent_liuchengka";
|
}
|
if ("获取详情".equals(caozuo)) {
|
String zklck_i = request.getParameter("lck");
|
//qSQL ="select xuhao,liuchengka,id,orientation,taskid,stop_rank,stop_position,width,height,thickness,color,work_state,work_procedure from y_shelfgalsss where parent_liuchengka = '"+zklck_i+"' order by work_procedure, stop_rank,liuchengka";
|
qSQL = "select xuhao,liuchengka,taskid,width,height,thickness,color,id,orientation,stop_rank,stop_position,work_state,work_procedure from y_shelfgalsss where parent_liuchengka = '"
|
+ zklck_i + "' order by work_procedure, stop_rank,liuchengka";
|
|
}
|
|
if ("获取缺片详情".equals(caozuo)) {
|
String zklck_i = request.getParameter("lck");
|
//qSQL ="select xuhao,liuchengka,id,orientation,taskid,stop_rank,stop_position,width,height,thickness,color,work_state,work_procedure from y_shelfgalsss where parent_liuchengka = '"+zklck_i+"' and id is null order by work_procedure, stop_rank,liuchengka";
|
qSQL = "select xuhao,liuchengka,taskid,width,height,thickness,color,id,orientation,stop_rank,stop_position,work_state,work_procedure from y_shelfgalsss where parent_liuchengka = '"
|
+ zklck_i + "' and (stop_rank is null or work_state='破损') order by work_procedure, stop_rank,liuchengka";
|
}
|
sn.createSql(qSQL);
|
if ("修改".equals(leixing)) {
|
if ("绑定料架".equals(caozuo)) {
|
String Id = request.getParameter("Id");
|
String liaoJiaId = request.getParameter("liaoJiaId");
|
qSQL = "update gmms_drop_frame_4 set rank = ?,sign=1 where Id = ?";
|
sn.createSql(qSQL);
|
int s = sn.update(liaoJiaId, Id);
|
qSQL = "update gmms_shelf_rack_2 set state='正在使用' where Id=?";
|
sn.createSql(qSQL);
|
int q = sn.update(liaoJiaId);
|
out.print(s + "_" + q);
|
} 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("[]");
|
}
|
}
|
|
if ("存储过程".equals(leixing)) {
|
|
if ("理片".equals(caozuo)) {
|
String moshi = request.getParameter("moshi");
|
String lck = request.getParameter("lck");
|
sn.createStdCall("y_optimize_GAI", 2);
|
|
String s = sn.stdCall(lck, moshi).ResultMessage;
|
//int s=1;
|
System.out.println("操作时间：" + new java.util.Date() + " 当前操作：" + caozuo + " 流程卡：" + lck
|
+ " 模式：" + moshi + " 返回结果：" + s);
|
out.print(s);
|
}
|
}
|
|
//sn.createStdCall("aaa",3);
|
//String s= sn.stdCall(1,2,3).ResultMessage;
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
|
} finally {
|
if (sn != null)
|
sn.close();
|
}
|
}
|
%>
|
