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, "EditWarehousepackingNote").get("LABEL_1");
    String label2 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_2");
    String label3 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_3");
    String label4 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_4");
    String label5 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_5");
    String label6 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_6");
    String label7 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_7");
    String label8 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_8");
    String label9 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_9");
    String label10 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_10");
    String label11 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_11");
    String label12 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_12");
    String label13 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_13");
    String label14 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_14");
    String label15 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_15");
    String label16 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_16");
    String label17 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_17");
    String label18 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_18");
    String label19 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_19");
    String label20 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_20");
    String label21 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_21");
    String label22 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_22");
    String label23 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").get("LABEL_23");

    String alert5 = (String) Configure.getConfigure(sIe_Language, "EditWarehousepackingNote").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");
    }



%>

<script language="javascript" src="<%=sResourcesPath%>/keyevent.js"></script>
<script language="javascript">
    function check()
    {
        var pnno = '<%=pnno%>';
        var shname = '<%=shname%>';
        var net = document.all.net.value;
        OpenComp("EditWarehousepackingNote", "/Billing/EditWarehousepackingNote/Do.jsp", "pnno=" + pnno +
                "&shname=" + shname +  "&net=" + net + "&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">&nbsp;</div>
    </td>
    <td colspan="2">&nbsp;</td>
    <td width="13%">
        <div align="right"> &nbsp;</div>
    </td>
    <td width="24%">&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right"><%=label2%>
        </div>
    </td>
    <td><%=pnRs.getString("worksno")%>
    </td>
    <td>
        <div align="right"><%=label3%>
        </div>
    </td>
    <td colspan="2"><%=desc%>
    </td>
    <td>
        <div align="right"><%=label4%>
        </div>
    </td>
    <td>&nbsp;<%=pnRs.getString("custpo")%>
    </td>
</tr>
<tr>
    <td>
        <div align="right"><%=label5%>
        </div>
    </td>
    <td><%=pnRs.getString("account") + "-" + pnRs.getString("subacct")%>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td colspan="2" rowspan="2"><%=name%>&nbsp;<%=add1%>&nbsp;<%=add2%>
    </td>
    <td>
        <div align="right"><%=label6%>
        </div>
    </td>
    <td><%=pnRs.getFloat("gross")%>&nbsp;<%=wght%>
    </td>
</tr>
<tr>
    <td>
        <div align="right"><%=label7%>
        </div>
    </td>
    <td><%=pnRs.getString("blno")%>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right"><%=label8%>
        </div>
    </td>
    <td>&nbsp;<%=pnRs.getFloat("coils")%>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td colspan="2">&nbsp;</td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right"> &nbsp;</div>
    </td>
    <td>&nbsp;
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td width="15%">
        <div align="center"><%=label9%>
        </div>
    </td>
    <td width="15%">
        <div align="center"><%=label10%>
        </div>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
    <td>
        <div align="right"><%=label11%>
        </div>
    </td>
    <td>
        <div align="center">&nbsp;<%=StringUtils.nullToEmpty(pnRs.getString("standno"))%>
        </div>
    </td>
    <td>
        <div align="center"><%=pnRs.getFloat("standwgt")%>
        </div>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
    <td>
        <div align="right"><%=label12%>
        </div>
    </td>
    <td>
        <div align="center">&nbsp;</div>
    </td>
    <td>
        <div align="center"><%=pnRs.getFloat("insertwgt")%>
        </div>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
    <td>
        <div align="right"><%=label13%>
        </div>
    </td>
    <td>
        <div align="center">&nbsp;</div>
    </td>
    <td>
        <div align="center"><%=pnRs.getFloat("dividerwgt")%>
        </div>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
    <td>
        <div align="right"><%=label14%>
        </div>
    </td>
    <td>
        <div align="center">&nbsp;<%=StringUtils.nullToEmpty(pnRs.getString("ctrno"))%>
        </div>
    </td>
    <td>
        <div align="center"><%=pnRs.getFloat("ctrwgt")%>
        </div>
    </td>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
    <td>
        <div align="right"><%=label15%>
        </div>
    </td>
    <td>
        <div align="center">&nbsp;<%=StringUtils.nullToEmpty(pnRs.getString("paltno"))%>
        </div>
    </td>
    <td>
        <div align="center"><%=pnRs.getFloat("paltwgt")%>
        </div>
    </td>
    <td>
        <div align="right"><%=label17%>
        </div>
    </td>
    <td><%=pnRs.getFloat("tare")%>
    </td>
</tr>
<tr>
    <td>
        <div align="right">&nbsp;</div>
    </td>
    <td>&nbsp;</td>
    <td>
        <div align="right"><%=label16%>
        </div>
    </td>
    <td>
        <div align="center">&nbsp;<%=StringUtils.nullToEmpty(pnRs.getString("caseno"))%>
        </div>
    </td>
    <td>
        <div align="center"><%=pnRs.getFloat("casewgt")%>
        </div>
    </td>
    <td>
        <div align="right"><%=label18%>
        </div>
    </td>
    <td>
      <input name="net" type="text" id="net" value="<%=pnRs.getFloat("net")%>" size="10" maxlength="10">
      <%=wght%>
    </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" %>