📄 existshippinglist.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],add2 from shipment where blno='" + sCode + "'");
    if (rs1.next()) {
        sShipDt = rs1.getString("ShipDt");
        sName = rs1.getString("Name") + " " + 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");
    }
%>
<body bgcolor="#DCDCDC">
<p align="center">INQUIRE PICKING LIST</p>
<table width=100% align="center">
    <tr>
        <td>PICK NO:<%=sCode%></td>
        <td>
            <div align="center">Ship Dt:<%=sShipDt%></div>
        </td>
        <td>Net</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()) {
    %>
    <tr>
        <td><%if (i == 0) {%>Works:<%}%></td>
        <td><%=rs.getString("worksno") + " " +
                rs.getString("description") + " " +
                StringUtils.nullToEmpty(rs.getString("custpo")) + " " +
                StringUtils.nullToEmpty(rs.getString("custprod"))%></td>
        <td><%=rs.getString("net")%></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>
</body>

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

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