📄 print.jsp

📁 运输模块代码
💻 JSP
字号:
<!--
* edit ruilei 2006-06-04
-->
<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>
<%@ page import="com.hexiesoft.are.sql.ASResultSet" %>
<%@ page import="com.hexiesoft.are.util.DataConvert" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%
    String PG_TITLE = "";

    String sCode = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Code"));
    //String sAccouStrinnt="";String sSubacct=""; String sInternal=""; String sIslbs=""; String weight="";String status="";String password="";String prod = "";String oship = ""; String crdflag = "";String tracking="";
    String sShipDt = "";
    String sGross = "";
    String sNet = "";
    String sWeight = "";
    String sName = "";
    ASResultSet rs1 = Sqlca.getASResultSet("select ShipDt,Islbs,[name],add1,add2 from shipment where blno='" + sCode + "'");
    if (rs1.next()) {
        sShipDt = rs1.getString("ShipDt");
        sName = rs1.getString("Name") + " "+rs1.getString("add1") + " " + rs1.getString("add2");
        if (rs1.getString("Islbs").equals("1")) {
            sWeight = (String) Configure.getConfigure(sIe_Language, "printShippingList").get("lbs");
        } else {
            sWeight = (String) Configure.getConfigure(sIe_Language, "printShippingList").get("kgs");
        }
    }
    rs1 = Sqlca.getASResultSet("select sum([gross])as sum_gross,sum([net]) as sum_net from packnote where blno='" + sCode + "'");
    if (rs1.next()) {
        sGross = rs1.getString("sum_gross");
        sNet = rs1.getString("sum_net");
    }
%>
<script language="javascript">

    function checkForm() {
        sCode = <%=sCode%>;

        OpenComp("ExportExcel==printShippingLis", "/ShippingManager/ShippingList/printShippingList/ExportExcel.jsp", "Code=" + sCode + "&rand=" + randomNumber(), "right");
        //alert(sCode);
        self.close();
    }
</script>
<body bgcolor="#DCDCDC">
<p align="center">Print PICKING LIST</p>
<table width=100% align="center">
    <tr>
        <td>PICK NO:<%=sCode%>
        </td>
        <td>
            <div align="center">Ship Dt:<%=sShipDt%>
            </div>
        </td>
        <td>&nbsp;</td>
    </tr>
    <%
        ASResultSet rs = Sqlca.getASResultSet("select worksno,[desc] as description,custpo,islbs,custprod,net,ShipDt from shipment where blno='" + sCode + "'");
        int i = 0;
        while (rs.next()) {
            String sCustpo=rs.getString("custpo");
            if(sCustpo!=null&&sCustpo.length()>15){
                sCustpo=sCustpo.substring(0,15);
            }
    %>
    <tr>
        <td><%if (i == 0) {%>Works:<%}%></td>
        <td><%=rs.getString("worksno") + " " +
               rs.getString("description") + " " +
                StringUtils.nullToEmpty(sCustpo) + " " +
                StringUtils.nullToEmpty(rs.getString("custprod"))%>
        </td>
        <%
            float sum_gross=0f;
            ASResultSet rs_sum = Sqlca.getASResultSet("select sum(gross) as sum_gross from packnote where blno='" + sCode + "' and worksno='" + rs.getString("worksno") + "'");
            if (rs_sum.next()) {
               sum_gross=rs_sum.getFloat("sum_gross");
            }
        %>
        <td><%=sum_gross%>
        </td>
    </tr>
    <%
            i++;
        }%>
</table>


<p>&nbsp;</p>
<table width=100% align="center">
    <tr>
        <td colspan="5">
            <%=sName%>
        </td>
    </tr>
    <tr>
        <td><%=(String) Configure.getConfigure(sIe_Language, "printShippingList").get("Gross")%>
        </td>
        <td><%=sGross%>
        </td>
        <td nowrap><%=(String) Configure.getConfigure(sIe_Language, "printShippingList").get("NET")%>
        </td>
        <td><%=sNet%>
        </td>
        <td width="13%"><%=sWeight%>
        </td>
    </tr>
    <tr>
        <td colspan="2"><%=(String) Configure.getConfigure(sIe_Language, "printShippingList").get("LOT")%>
        </td>
        <td colspan="2"><%=(String) Configure.getConfigure(sIe_Language, "printShippingList").get("NET")%>
        </td>
        <td></td>
    </tr>
    <%
        ASResultSet rs_packnote = Sqlca.getASResultSet("select pnno,[gross],[net] from packnote where blno='" + sCode + "'");
        while (rs_packnote.next()) {
    %>
    <tr>
        <td colspan="2"><%=rs_packnote.getString("pnno")%>
        </td>
        <td colspan="2"><%=rs_packnote.getString("net")%>
        </td>
        <td></td>
    </tr>
    <%}%>
</table>
<p><input name="button" type="button" onClick="javascript:checkForm();"
          value="<%=(String)Configure.getConfigure(sIe_Language,"printShippingList").get("prtbtn")%>"
          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'/></p>
</body>


<%@ include file="/IncludeEnd.jsp" %>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -