📄 updateunorder.jsp
字号:
<%--
Created by IntelliJ IDEA.
User: jtgao
Date: 2006-5-19
Time: 11:25:14
To change this template use File | Settings | File Templates.//
--%>
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
//label
String sTitle = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Title");
String sLabel1 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_1");
String sLabel2 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_2");
String sLabel3 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_3");
String sLabel4 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_4");
String sLabel5 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_5");
String sLabel6 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_6");
String sLabel7 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_7");
String sLabel8 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_8");
String sLabel9 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_9");
String sLabel10 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_10");
String sLabel11 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_11");
String sLabel12 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_12");
String sLabel13 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_13");
String sLabel14 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_14");
String sLabel15 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_15");
String sLabel16 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_16");
String sLabel17 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_17");
String sLabel18 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_18");
String sLabel19 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_19");
String sLabel20 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("Label_20");
//button
String sLabel21 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("ButLabel_1");
String sLabel22 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("ButLabel_2");
String sLabel23 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("ButLabel_3");
//alert
String alert_5 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("ALERT_5");
String alert_6 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("ALERT_6");
String alert_7 = (String)Configure.getConfigure(sIe_Language,"Shipping_UnCompOrder").get("ALERT_7");
String sWorksno = DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("Worksno"));
%>
<script language=javascript>
//按下 save
function pressSubmit() {
sWorksno = document.all.Worksno.value;
sStatus = document.all.Status.value.toUpperCase();
ssTitle = document.all.Title.value;
if ( sStatus== "CM" || sStatus == "EN" || sStatus == "IP" ) {
sReturn_isEmpty = PopPage("/ShippingManager/unOrder/UpdateUnOrderOption.jsp?Worksno="
+sWorksno
+"&Status="+sStatus
+"&rand="+randomNumber(),"","");
/*
OpenComp("","/ShippingManager/unOrder/UpdateUnOrderOption.jsp","Worksno="
+sWorksno
+"&Status="+sStatus
+"&rand="+randomNumber(),"right","");
*/
} else {
alert('<%=sLabel18 + alert_7 + "CM EN IP"%>');
return;
}
//alert(sReturn_isEmpty);
if(sReturn_isEmpty == "true")
{
alert('<%=alert_5%>');
// OpenComp("","/ShippingManager/TurckingRoutes/blank.jsp","&rand="+randomNumber(),"right","");
OpenPage('/Blank.jsp?TextToShow=Please click the list on left','right','');
self.close();
return;
}else{
alert('<%=alert_6%>');
OpenComp(sTitle,"/ShippingManager/unOrder/UpdateUnOrder.jsp","Worksno="+sWorksno+"&rand="+randomNumber(),"right","");
return;
}
}
//press abort button
//按下 Re Edit 按钮
function pressReedit(){
sWorksno = document.all.Worksno.value;
sTitle = document.all.Title.value;
OpenComp(sTitle,"/ShippingManager/unOrder/UpdateUnOrder.jsp","Worksno="+sWorksno+"&rand="+randomNumber(),"right","");
}
//press abort button
function pressAbort(){
OpenComp("","/ShippingManager/unOrder/blank.jsp","&rand="+randomNumber(),"right","");
//PopPage("/ShippingManager/TurckingRoutes/EnterCode.jsp?rand="+randomNumber(),"","dialogWidth=30;dialogHeight=8;center:yes;status:no;statusbar:no");
}
</script>
<%
//ord_item
String sAccount="";
String sSubacct="";
String sInternal="";
String sStatus="";
String sCustprod="";
// customer
String sName="";
String sbladd1="";
String sbladd2="";
String shpadd1="";
String shpadd2="";
String sblcity="";
String sblprovst="";
String sblcountry="";
String sshcity="";
String sshprovst="";
String sshcountry="";
String sspecinstr = "";
String sothrinstr = "";
//float sworksno = 0.0f; //PICTURE '99999'
String sordertype = "";
String scustpo = "";
String spodate = "";
int flbs=0; //PICTURE '99999'
String smillspec = ""; //PICTURE '99999' &&5
String salloy = "";
String stemper= "";
float sgauge= 0.0f; //PICTURE 'String s99999'
float swidth = 0.0f; //PICTURE '99String s9999'
String scustspec= "";
String scustprod = "";
String sqlstatement = "select * from ord_item where worksno = '"+sWorksno +"'";
System.out.println("sqlstatement = " + sqlstatement);
ASResultSet rs = Sqlca.getASResultSet(sqlstatement);
if(rs.next()){
sAccount = StringUtils.nullToEmpty((String)rs.getString("account"));
sSubacct = StringUtils.nullToEmpty((String)rs.getString("subacct"));
sInternal = StringUtils.nullToEmpty((String)rs.getString("Internal"));
sStatus = StringUtils.nullToEmpty((String)rs.getString("Status"));
sCustprod=StringUtils.nullToEmpty((String)rs.getString("Custprod"));
rs.close();
// customer table
sqlstatement = "select * from customer where Account = '"+sAccount+"' and Subacct ='" + sSubacct +"'" ;
rs = Sqlca.getASResultSet(sqlstatement);
if (rs.next()){
sName = StringUtils.nullToEmpty((String)rs.getString("name"));
sbladd1 = StringUtils.nullToEmpty((String)rs.getString("bladd1"));
sbladd2 = StringUtils.nullToEmpty((String)rs.getString("bladd2"));
shpadd1 = StringUtils.nullToEmpty((String)rs.getString("shadd1"));
shpadd2 = StringUtils.nullToEmpty((String)rs.getString("shadd2"));
sblcity=StringUtils.nullToEmpty((String)rs.getString("blcity"));
sblprovst=StringUtils.nullToEmpty((String)rs.getString("blprovst"));
sblcountry=StringUtils.nullToEmpty((String)rs.getString("blcountry"));
sshcity=StringUtils.nullToEmpty((String)rs.getString("shcity"));
sshprovst=StringUtils.nullToEmpty((String)rs.getString("shprovst"));
sshcountry=StringUtils.nullToEmpty((String)rs.getString("shcountry"));
sspecinstr = StringUtils.nullToEmpty((String)rs.getString("specinstr"));
sothrinstr = StringUtils.nullToEmpty((String)rs.getString("othrinstr"));
//sWorksno = StringUtils.nullToEmpty((String)rs.getString("worksno"));
sordertype = StringUtils.nullToEmpty((String)rs.getString("ordertype"));
}
// packnote
sqlstatement = "select * from packnote where worksno = '"+sWorksno +"'" ;
rs = Sqlca.getASResultSet(sqlstatement);
if (rs.next()){
scustpo = StringUtils.nullToEmpty((String)rs.getString("custpo"));
}
// ord_hdr
sqlstatement = "select left(podate ,10) as 'podate' from ord_hdr where Internal = '"+sInternal +"'" ;
rs = Sqlca.getASResultSet(sqlstatement);
if (rs.next()){
spodate = StringUtils.nullToEmpty((String)rs.getString("podate"));
}
// ord_item table
sqlstatement = "select * from ord_item where Internal = '"+sInternal +"'";
System.out.println("sqlstatement = " + sqlstatement);
rs = Sqlca.getASResultSet(sqlstatement);
if (rs.next()){
flbs = rs.getInt("lbs");
smillspec = rs.getString("millspec");
salloy = StringUtils.nullToEmpty((String)rs.getString("alloy"));
stemper= StringUtils.nullToEmpty((String)rs.getString("temper"));
sgauge= rs.getFloat("gauge");
swidth = rs.getFloat("width");
scustspec= StringUtils.nullToEmpty((String)rs.getString("custspec"));
scustprod = StringUtils.nullToEmpty((String)rs.getString("custprod"));
}
}
%>
<html>
<head>
<title><%=sTitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="pagebackground" text="#000000">
<p align="center"><%=sTitle%></p>
<table width="83%" border="0">
<tr>
<td width="25%"> <%=sLabel1%> </td>
<td width="25%"> <%=sAccount%> <%=sSubacct%></td>
<td width="50%" colspan="3"><%=sLabel2%> <%=sName%></td>
</tr>
<tr>
<td colspan="2"> </td>
<td colspan="3"> <input type="hidden" name="Worksno" value="<%=sWorksno%>">
<input type="hidden" name="Title" value="<%=sTitle%>"></td>
</tr>
<tr>
<td height="26" colspan="2"><%=sLabel3%></td>
<td colspan="3"><%=sLabel4%></td>
</tr>
<tr>
<td colspan="2"><%=sbladd1 + " " + sbladd2 %>,</td>
<td colspan="3"><%=shpadd1 + " " + shpadd2 %>,</td>
</tr>
<tr>
<td colspan="2"><%=sblcity%>,<%=sblprovst%>,<%=sblcountry%></td>
<td colspan="3"><%=sshcity%>,<%=sshprovst%>,<%=sshcountry%></td>
</tr>
<tr>
<td colspan="2"> </td>
<td colspan="3"></td>
</tr>
<tr>
<td colspan="2"><%=sLabel5%> : <%=sspecinstr%></td>
<td colspan="3"></td>
</tr>
<tr>
<td><%=sLabel6%> </td>
<td><%=sothrinstr%></td>
<td colspan="2"><%=sLabel7%> </td>
<td><%=sWorksno%></td>
</tr>
<tr>
<td><%=sLabel8%></td>
<td><%=sordertype%></td>
<td><%=sLabel9%> </td>
<td><%=scustpo%></td>
<td><%=spodate%></td>
</tr>
<tr>
<td colspan="5"><table width="100%" border="0" align="center">
<tr>
<td><%=sLabel11%></td>
<td><%=sLabel12%></td>
<td><%=sLabel13%></td>
<td><%=sLabel14%></td>
<td><%=sLabel15%></td>
<td><%=sLabel16%></td>
<td><%=sLabel17%></td>
<td><%=sLabel18%></td>
</tr>
<tr>
<td><%= flbs %>lbs</td>
<td><%= smillspec %></td>
<td><%= salloy %></td>
<td><%= stemper %></td>
<td><%= sgauge %></td>
<td><%= swidth %></td>
<td><%= scustspec %></td>
<td><%= scustprod %></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"> </td>
<td colspan="3"></td>
</tr>
<tr>
<td colspan="2"><%=sLabel19%></td>
<td colspan="3"><input type="text" name="Status" size="3" value="<%=sStatus%>"></td>
</tr>
<tr>
<td colspan="5" align="center">
<input type="button" name="submit" onClick="pressSubmit();" value="<%=sLabel21%>" style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC; border-style: outset; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px" border='1'>
<input type="button" name="submit" onClick="pressReedit();" value="<%=sLabel22%>" style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC; border-style: outset; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px" border='1'>
<input name="Abort" type="button" id="Abort" value="<%=sLabel23%>" onclick="javascript:OpenPage('/Blank.jsp?TextToShow=Please click the list on left','right','');" style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC; border-style: outset; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px" border='1'>
</td>
</tr>
</table>
</body>
</html>
<%@ include file="/IncludeEnd.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -