<%@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();
|
}
|
}
|
|
|
|
%>
|
