📄 showinfo.jsp
字号:
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2006-11-1
Time: 16:22:33
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>
<%@ page import="com.hexiesoft.are.sql.ASResultSet" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%
String pnno = DataConvert.toRealString(iPostChange, CurPage.getParameter("pnno"));
String label1 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_1");
String label2 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_2");
String label3 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_3");
String label4 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_4");
String label5 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_5");
String label6 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_6");
String label7 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_7");
String label8 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_8");
String label9 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_9");
String label10 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_10");
String label11 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_11");
String label12 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_12");
String label13 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_13");
String label14 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_14");
String label15 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_15");
String label16 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_16");
String label17 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_17");
String label18 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_18");
String label19 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_19");
String label20 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_20");
String label21 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_21");
String label22 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_22");
String label23 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("LABEL_23");
String alert5 = (String) Configure.getConfigure(sIe_Language, "SplitaWarehouseLog").get("ALERT_5");
%>
<%
ASResultSet pnRs;
ASResultSet shipRs;
ASResultSet oiRs;
ASResultSet whRs;
ASResultSet cusRs;
String wght = "";
String sql = "";
String shipdt = "";
String desc = "";
String name = "";
//String shname = "";
String add1 = "";
String add2 = "";
String newpnno = "";
sql = "select * from packnote where pnno='" + pnno + "'";
pnRs = Sqlca.getASResultSet(sql);
pnRs.first();
if (pnRs.getString("islbs").equals("1")) {
wght = "lbs";
} else {
wght = "kgs";
}
add1 = pnRs.getString("add1");
add2 = pnRs.getString("add2");
sql = "select * from ord_item where worksno='" + pnRs.getString("worksno") + "'";
oiRs = Sqlca.getASResultSet(sql);
oiRs.first();
desc = oiRs.getString("alloy") + " " + oiRs.getString("temper") + " " + oiRs.getFloat("width") + " " + oiRs.getFloat("gauge");
sql = "select * from whouse where wcode='" + pnRs.getString("ordertype") + "'";
whRs = Sqlca.getASResultSet(sql);
if (whRs.first()) {
name = whRs.getString("wname");
add1 = whRs.getString("shadd1") + whRs.getString("shadd2");
add2 = whRs.getString("shcity") + whRs.getString("shprovst") + whRs.getString("shcountry");
}
// sql = "select * from customer where account='" + pnRs.getString("account") + "' and subacct='" + pnRs.getString("subacct") + "'";
// cusRs=Sqlca.getASResultSet(sql);
// if(cusRs.first()){
// shname=cusRs.getString("shname");
// }
sql = "select * from shipment where blno='" + pnRs.getString("blno") + "'";
shipRs = Sqlca.getASResultSet(sql);
if (shipRs.first() && shipRs.getString("shipdt").length() >= 10) {
shipdt = shipRs.getString("shipdt").substring(0, 10);
}
DecimalFormat f = new DecimalFormat("##########");
double fpnno = Double.parseDouble(pnno);
while (true) {
fpnno = fpnno + 1;
sql = "select * from packnote where pnno='" + f.format(fpnno) + "'";
ASResultSet testRs;
testRs = Sqlca.getASResultSet(sql);
if (!testRs.next()) {
break;
}
}
newpnno = f.format(fpnno);
%>
<script language="javascript" src="<%=sResourcesPath%>/keyevent.js"></script>
<script language="javascript">
function check()
{
var pnno = '<%=pnno%>';
var newpnno = '<%=newpnno%>';
var desc = '<%=desc%>';
var name = '<%=name%>';
var add1 = '<%=add1%>';
var add2 = '<%=add2%>';
var newnet = document.all.newnet.value;
var net = '<%=pnRs.getFloat("net")%>';
var newlot = net - newnet;
if (!confirm('<%= label21%>' + " " + '<%=newpnno%>' + " " + '<%= label22%>' + " " + newlot)) {
alert('<%=alert5%>');
OpenPage('/Blank.jsp?TextToShow=blank', 'right', '');
self.close();
return;
}
OpenComp("SplitaWarehouseLog", "/Billing/SplitaWarehouseLog/Do.jsp", "pnno=" + pnno + "&newpnno=" + newpnno
+ "&newnet=" + newnet + "&newlot=" + newlot + "&desc=" + desc + "&name=" + name + "&add1=" + add1
+ "&add2=" + add2 + "&rand=" + randomNumber(), "right", "");
}
</script>
<body>
<table table border="1" width=100% align="center" bordercolor='#999999' bordercolordark='#FFFFFF'>
<tr>
<td width="9%">
<div align="right"><%=label1%>
</div>
</td>
<td width="12%"><%=pnno%>
</td>
<td width="12%">
<div align="right"> </div>
</td>
<td colspan="2"> </td>
<td width="13%">
<div align="right"><%=label2%>
</div>
</td>
<td width="24%"><%=pnRs.getString("pndate").substring(0,10)%>
</td>
</tr>
<tr>
<td>
<div align="right"><%=label3%>
</div>
</td>
<td><%=pnRs.getString("worksno")%>
</td>
<td>
<div align="right"><%=label4%>
</div>
</td>
<td colspan="2"><%=desc%>
</td>
<td>
<div align="right"><%=label5%>
</div>
</td>
<td><%=pnRs.getString("custpo")%>
</td>
</tr>
<tr>
<td>
<div align="right"><%=label6%>
</div>
</td>
<td><%=pnRs.getString("account") + "-" + pnRs.getString("subacct")%>
</td>
<td>
<div align="right"> </div>
</td>
<td colspan="2" rowspan="2"><%=name%> <%=add1%> <%=add2%>
</td>
<td>
<div align="right"><%=label7%>
</div>
</td>
<td><%=pnRs.getFloat("gross")%> <%=wght%>
</td>
</tr>
<tr>
<td>
<div align="right"><%=label8%>
</div>
</td>
<td><%=pnRs.getString("blno")%>
</td>
<td>
<div align="right"> </div>
</td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"><%=label9%>
</div>
</td>
<td><%=shipdt%>
</td>
<td>
<div align="right"> </div>
</td>
<td colspan="2"> </td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"><%=label11%>
</div>
</td>
<td><%=pnRs.getFloat("coils")%>
</td>
<td>
<div align="right"> </div>
</td>
<td width="15%">
<div align="center"><%=label10%>
</div>
</td>
<td width="15%">
<div align="center"><%=label23%>
</div>
</td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"><%=label12%>
</div>
</td>
<td>
<div align="center"> <%=StringUtils.nullToEmpty(pnRs.getString("standno"))%>
</div>
</td>
<td>
<div align="center"><%=pnRs.getFloat("standwgt")%>
</div>
</td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"><%=label13%>
</div>
</td>
<td>
<div align="center"> </div>
</td>
<td>
<div align="center"><%=pnRs.getFloat("insertwgt")%>
</div>
</td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"><%=label14%>
</div>
</td>
<td>
<div align="center"> </div>
</td>
<td>
<div align="center"><%=pnRs.getFloat("dividerwgt")%>
</div>
</td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"><%=label15%>
</div>
</td>
<td>
<div align="center"> <%=StringUtils.nullToEmpty(pnRs.getString("ctrno"))%>
</div>
</td>
<td>
<div align="center"><%=pnRs.getFloat("ctrwgt")%>
</div>
</td>
<td>
<div align="right"> </div>
</td>
<td> </td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"><%=label16%>
</div>
</td>
<td>
<div align="center"> <%=StringUtils.nullToEmpty(pnRs.getString("paltno"))%>
</div>
</td>
<td>
<div align="center"><%=pnRs.getFloat("paltwgt")%>
</div>
</td>
<td>
<div align="right"><%=label18%>
</div>
</td>
<td><%=pnRs.getFloat("tare")%>
</td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"><%=label17%>
</div>
</td>
<td>
<div align="center"> <%=StringUtils.nullToEmpty(pnRs.getString("caseno"))%>
</div>
</td>
<td>
<div align="center"><%=pnRs.getFloat("casewgt")%>
</div>
</td>
<td>
<div align="right"><%=label19%>
</div>
</td>
<td><%=pnRs.getFloat("net")%> <%=wght%>
</td>
</tr>
<tr>
<td>
<div align="right"> </div>
</td>
<td> </td>
<td>
<div align="right"> </div>
</td>
<td colspan="3">
<div align="right"><%=label20%>
</div>
</td>
<td><input name="newnet" type="text" id="newnet" size="10" maxlength="10"></td>
</tr>
</table>
<input type="button" name="next"
value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>"
onClick="javascript:check()"
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("CANCEL")%>"
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'>
</body>
<%@ include file="/IncludeEnd.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -