📄 addshippinglist.jsp
字号:
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%@ page contentType="text/html; charset=GBK" language="java" %>
<%@ include file="/IncludeBegin.jsp" %>
<html>
<head>
<title>addshippinglist</title>
</head>
<body class="pagebackground" text="#000000">
<%
String sWarehouse = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("warehouse"));
String sWorksno = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("worksno"));
String shipdt = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("shipdt"));
String label1 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_1");
String label2 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_2");
String label3 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_3");
String label4 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_4");
String label5 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_5");
String label6 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_6");
String label7 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_7");
String label8 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_8");
String label9 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("ENTERWORKSNO_LABEL_9");
String label10 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("LOT");
String label11 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("NET");
String buttonLable = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("BUTTON_LABLE");
String confirm3 = (String) Configure.getConfigure(sIe_Language, "AddShippingList").get("CONFIRM3");
%>
<%
int islbs = 0;
String blno = "";
String gblno = "";
//float worksno = Float.parseFloat(sWorksno);
String internal = "";
String millspec = "";
float width = 0.0f;
float gauge = 0.0f;
float ntotship = 0.0f;
String desc = "";
String sql = "";
String sWname = "";
String sAdd1 = "";
String sAdd2 = "";
String hscode = "";
String sOrdertype = "";
String sAccount = "";
String sSubacct = "";
String sCrdflag = "";
String sOvership = "";
String sServstatus = "";
String sLstatus = "";
String sStatus = "";
String alloy = "";
String temper = "";
String custpo = "";
String custprod = "";
ASResultSet ord_itemRs;
ASResultSet ord_hdrRs;
ASResultSet customerRs;
ASResultSet whouseRs;
ASResultSet promiseRs;
ASResultSet shipmentRs;
ASResultSet packnoteRs;
//检验ord_item
sql = "select * from ord_item where worksno='" + sWorksno+"'";
ord_itemRs = Sqlca.getASResultSet(sql);
if (ord_itemRs.next()) {
if (ord_itemRs.getString("islbs").equals("1")) {
islbs = 1;
}
millspec = ord_itemRs.getString("millspec");
alloy = ord_itemRs.getString("alloy");
temper = ord_itemRs.getString("temper");
gauge = ord_itemRs.getFloat("gauge");
width = ord_itemRs.getFloat("width");
custprod = ord_itemRs.getString("custprod");
internal = ord_itemRs.getString("internal");
sOvership = ord_itemRs.getString("overship");
sAccount = ord_itemRs.getString("account");
sSubacct = ord_itemRs.getString("subacct");
sServstatus = ord_itemRs.getString("servstatus");
sLstatus = ord_itemRs.getString("lstatus");
sStatus = ord_itemRs.getString("status");
desc = ord_itemRs.getString("alloy") + " " + ord_itemRs.getString("temper") + " " + String.valueOf(ord_itemRs.getFloat("width")) + " " + String.valueOf(ord_itemRs.getFloat("gauge"));
sql = "select * from ord_hdr where internal='" + internal+"'";
ord_hdrRs = Sqlca.getASResultSet(sql);
if (ord_hdrRs.next()) {
sOrdertype = ord_hdrRs.getString("ordertype");
custpo = ord_hdrRs.getString("custpo");
if (!sOrdertype.equals(sWarehouse)) {
sOrdertype = sWarehouse;
}//end if (sWarehouse.equals("sOrdertype") )
}
sql = "select * from customer where account='" + sAccount + "' and subacct='" + sSubacct + "'";
customerRs = Sqlca.getASResultSet(sql);
String customerTempShadd1 = "";
String customerTempShadd2 = "";
String customerTempShcity = "";
String customerTempShprovst = "";
String customerTempShcountry = "";
if (customerRs.next()) {
sCrdflag = customerRs.getString("crdflag");
customerTempShadd1 = customerRs.getString("shadd1");
customerTempShadd2 = customerRs.getString("shadd2");
customerTempShcity = customerRs.getString("shcity");
customerTempShprovst = customerRs.getString("shprovst");
customerTempShcountry = customerRs.getString("shcountry");
//if(!sWarehouse.equals("REG")) 从whouse得到shadd1，shadd2，shcity，shprovst，shcountry，wname，输出工厂信息
}
if (!sWarehouse.equals("REG")) {
sql = "select * from whouse where wcode='" + sWarehouse + "'";
whouseRs = Sqlca.getASResultSet(sql);
if (whouseRs.next()) {
sWname = whouseRs.getString("wname");
sAdd1 = StringUtils.nullToEmpty(whouseRs.getString("shadd1")) + ";" + StringUtils.nullToEmpty(whouseRs.getString("shadd2"));
sAdd2 = StringUtils.nullToEmpty(whouseRs.getString("shcity")) + ";" + StringUtils.nullToEmpty(whouseRs.getString("shprovst")) + ";" + StringUtils.nullToEmpty(whouseRs.getString("shcountry"));
}
} else {
sAdd1 = customerTempShadd1 + ";" + customerTempShadd2;
sAdd2 = customerTempShcity + ";" + customerTempShprovst + ";" + customerTempShcountry;
} // end if(!sWarehouse.equals("REG"))-else
}
String sCurpromqty = "";
sql = "select * from promise where worksno='" + sWorksno+"'";
promiseRs = Sqlca.getASResultSet(sql);
if (promiseRs.next()) {
sCurpromqty = promiseRs.getString("curpromqty");
}
sql = "select * from shipment where worksno='" + sWorksno+"'";
shipmentRs = Sqlca.getASResultSet(sql);
while (shipmentRs.next()) {
ntotship = ntotship + shipmentRs.getFloat("net");
}
//hscode,生成合金参数
if ((alloy.substring(0, 1)).equals("C") || (alloy.substring(0, 1)).equals("1")) {
if (gauge < 0.006f) {
hscode = "7410.11.0000";
} else if (gauge < 0.19689f && width >= 19.685f) {
hscode = "7409.11.5010";
} else if (gauge < 0.19689f && width < 19.685f) {
hscode = "7409.11.5050";
} else if (gauge >= 0.19689f) {
hscode = "7409.11.1000";
}
} else if (alloy.substring(0, 1).equals("2")) {
if (gauge < 0.006f) {
hscode = "7410.12.0030";
} else if (gauge < 0.19689f && width >= 19.685f) {
hscode = "7409.21.0050";
} else if (gauge < 0.06299f && width < 19.685f) {
hscode = "7409.21.0075";
} else if (gauge >= 0.006f) {
hscode = "7409.21.0010";
}
} else if (alloy.substring(0, 1).equals("7")) {
hscode = "7409.40";
} else {
hscode = "7409.21";
}
//packnote
int i = 0;
int nlen = 0;
boolean lsize = true;
String[] mzpn = new String[200];
float loaded = 0.0f;
float netwght = 0.0f;
float tnet = 0.0f;
float tcoils = 0.0f;
float tnotes = 0.0f;
float[] mzpngross = new float[200];
float[] mzpnnet = new float[200];
float[] mzpncoils = new float[200];
sql = "select * from packnote where blno is null and worksno='" + sWorksno+"'";
packnoteRs = Sqlca.getASResultSet(sql);
while (packnoteRs.next()) {
mzpn[i] = packnoteRs.getString("pnno");
mzpngross[i] = packnoteRs.getFloat("gross");
mzpnnet[i] = packnoteRs.getFloat("net");
mzpncoils[i] = packnoteRs.getFloat("coils");
loaded = loaded - packnoteRs.getFloat("gross");
netwght = netwght + packnoteRs.getFloat("net");
tnet = tnet + packnoteRs.getFloat("net");
tcoils = tcoils + packnoteRs.getFloat("coils");
if (mzpnnet[i] > 0) {
tnotes = tnotes + 1;
}
i++;
}
nlen = i;
//更新global表
String sPlant = "";
float ship_weight = 0.0f;
sql = "select * from global ";
ASResultSet globalRs = Sqlca.getASResultSet(sql);
globalRs.next();
sPlant = globalRs.getString("plant");
blno = String.valueOf(Float.parseFloat(globalRs.getString("blno")) + 1).substring(0,6);
gblno = blno;
%>
<script type="text/javascript">
function next()
{
var sBlno = "<%=blno%>";
var sWorskno = "<%=sWorksno%>";
var sOrdertype = "<%=sOrdertype%>";
var shipdt = "<%=shipdt%>";
var hscode = "<%=hscode%>";
var sPlant = "<%=sPlant%>" ;
if (confirm('<%=confirm3%>' + sBlno))
{
OpenComp("addshipppinglist", "/ShippingManager/ShippingList/addShippingList/doAdd.jsp", "ordertype=" + sOrdertype + "&plant=" + sPlant + "&hscode=" + hscode + "&blno=" + sBlno + "&worksno=" + sWorskno + "&shipdt=" + shipdt + "&rand=" + randomNumber(), "right", "");
self.returnValue = "OK";
self.close();
return;
}
else
{
document.all.next.focus();
return;
}
}
</script>
<table width="80%" border="0">
<tr>
<td width="23%"><strong><font color="#333300" size="5">O.I.S.M</font></strong></td>
<td width="51%"><strong><font color="#333300" size="5">HILL</font></strong></td>
<td width="26%"><strong><font color="#333300" size="5"><%=shipdt%></font></strong></td>
</tr>
</table>
<table width="80%" border="0">
<tr>
<td width="12%"><div align="right"><font color="#333300"><%=label1%></font></div></td>
<td width="24%"><%=gblno%></td>
<td colspan="2"><strong><font color="#333300"><%=label2%></font></strong></td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label3%></font></div></td>
<td><font color="#333300" onKeyDown="NumberInput()"><%=shipdt%></font></td>
<td colspan="2"> </td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label4%></font></div></td>
<td><%=sWorksno%></td>
<td colspan="2"><%=desc%></td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label5%></font></div></td>
<td><%=sAccount + "-" + sSubacct%></td>
<td> </td>
<td><%=StringUtils.nullToEmpty(sWname)%></td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label6%></font></div></td>
<td><%=StringUtils.nullToEmpty(custprod)%></td>
<td width="21%"> </td>
<td width="43%"><%=StringUtils.nullToEmpty(sAdd1)%></td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label7%></font></div></td>
<td><%=StringUtils.nullToEmpty(custpo)%></td>
<td> </td>
<td><%=StringUtils.nullToEmpty(sAdd2)%></td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label8%></font></div></td>
<td><%=sCurpromqty%></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="right"><font color="#333300"><%=label9%></font></div></td>
<td><%=ntotship%></td>
<td>GROSS:<%=loaded * (-1)%></td>
<td>NET: <%=netwght%> <%if (islbs == 1) {%>lbs<%} else {%>kgs<%}%></td>
</tr>
</table>
<table width="50%" border="0">
<tr>
<td width="49%"><font color="#333300"><%=label10%></font></td>
<td width="51%"><font color="#333300"><%=label11%></font></td>
</tr>
<%
for (i = 0; i < nlen; i++) {
if (mzpn[i] != null && (!mzpn[i].equals(""))) {
%>
<tr>
<td><%=mzpn[i]%></td>
<td><%=mzpnnet[i]%></td>
</tr>
<%
}
}
%>
<tr>
<td><input type="button" name="next"
value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>"
onClick="javascript:next()"
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="reedit" value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("REEDIT")%>" onClick="javascript:OpenPage('/ShippingManager/ShippingList/addShippingList/addShippingList.jsp', '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'>
<input type="button" name="cancel" value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("ABORT")%>" onClick="javascript:OpenPage('/Blank.jsp?TextToShow=', '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>
<td></td>
</tr>
</table>
</body>
<%@ include file="/IncludeEnd.jsp" %>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -