📄 printshippinglist.jsp

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

<%
	//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"><%=(String)Configure.getConfigure(sIe_Language,"printShippingList").get("title")%></p>
<table width=100% align="center" >
  <tr> 
    <td ><%=(String)Configure.getConfigure(sIe_Language,"printShippingList").get("PICKNo")%><%=sCode%></td>
    <td >
      <div align="center"><%=(String)Configure.getConfigure(sIe_Language,"printShippingList").get("ShipDt")%><%=sShipDt%></div>
    </td>
    <td ></td>
  </tr>
  <%
      ASResultSet rs = Sqlca.getASResultSet("select worksno,[desc] as description,custpo,islbs,custprod,loaded*-1 as net,ShipDt from shipment where blno='"+sCode+"'");
	  int i=0;
      while(rs.next()){%>
  <tr> 
    <td >
      <%if(i==0){%>
      <%=(String)Configure.getConfigure(sIe_Language,"printShippingList").get("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" nowrap> <%=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 + -