📄 viewpackorders.jsp

📁 运输模块代码
💻 JSP
字号:
<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-26
  Time: 23:30:16
  To change this template use File | Settings | File Templates.//
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
	String Ttitle_01 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_01");//"Customer";
	String Ttitle_02 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_02");//"Worksno";
	String Ttitle_03 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_03");//"Pnno";
	String Ttitle_04 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_04");//"Desc";
	String Ttitle_05 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_05");//"Lbs";
	String Ttitle_06 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_06");//"Pndate";
	String Ttitle_07 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_07");//"Blno";
	String Ttitle_08 = (String)Configure.getConfigure(sIe_Language,"Shipping_ViewPO").get("Ttitle_08");//"Millspec";

    String sLocation  =  DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("Location"));
	String sStratDate =  DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("StratDate"));
	String sEnddate   =  DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("Enddate"));
	String sAccount   =  DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("Account"));
	String sSubacct   =  DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("Subacct"));
%>

<%

%>

<html>
  <head><title><%=Ttitle_01%></title>
      
  </head>
  <body class="pagebackground"   text="#000000">
 

<%////Customer,Worksno,Pnno,Desc,Lbs,Pndate,Blno,Millspec%>
<table width=100%  border="1" align="center" bordercolor='#999999' >
  <tr>
	<td width="15%" align="center"><%=Ttitle_01%></td>
	<td width="10%" align="center"><%=Ttitle_02%></td>
	<td width="15%" align="center"><%=Ttitle_03%></td>
	<td width="20%" align="center"><%=Ttitle_04%></td>
	<td width="10%" align="center"><%=Ttitle_05%></td>
	<td width="10%" align="center"><%=Ttitle_06%></td>
	<td width="10%" align="center"><%=Ttitle_07%></td>
	<td width="10%" align="center"><%=Ttitle_08%></td>
  </tr>
<%


	String sSql = "select p.account + '-' + p.subacct Customer ,p.worksno Works ";
		sSql += ",p.pnno Pnno,p.[desc] 'Desc',p.islbs,p.net * 1 Lbs1,p.net * 2.2046 Lbs2 ";
		sSql += ",p.pndate Pndate,p.blno Blno,o.millspec Millspec ";
		sSql += " from packnote p join ord_item o" ;
        sSql += " on o.worksno = p.worksno ";

		sSql += "where p.pndate between '" + sStratDate + "' and '" + sEnddate + "' ";
		sSql += " and p.plant = '" + sLocation + "'";
        if (sAccount!=null && sAccount.length() > 0) {

            sSql += " and p.account ='" + sAccount + "'";
        }
        if (sSubacct!=null && sSubacct.length() > 0) {

            sSql += " and p.subacct ='" + sSubacct + "'";
        }
        
    //out.println(sSql);

     ASResultSet rs = null;

		rs = Sqlca.getASResultSet(sSql);
		//isEmpty = !rs.next();

    while (rs != null && rs.next()) {
	String sCustomer = StringUtils.nullToEmpty((String)rs.getString("Customer"));//"Customer";
	String sWorksno = StringUtils.nullToEmpty((String)rs.getString("Works"));//"Worksno";
	String sPnno = StringUtils.nullToEmpty((String)rs.getString("Pnno"));//"Pnno";
	String sDesc = StringUtils.nullToEmpty((String)rs.getString("Desc"));//"Desc";

	String sisbs1 = StringUtils.nullToEmpty((String)rs.getString("islbs"));//"Lbs1";
	double sLbs1 = StringUtils.formatdouble((double)rs.getDouble("Lbs1"),3);//"Lbs1";
	double sLbs2 = StringUtils.formatdouble((double)rs.getDouble("Lbs2"),3);//"Lbs1";

    String sPndate = StringUtils.nullToEmpty((String)rs.getString("Pndate"));//"Pndate";
    sPndate = sPndate.substring(0,10);
    String sBlno = StringUtils.nullToEmpty((String)rs.getString("Blno"));//"Blno";
	String sMillspec = StringUtils.nullToEmpty((String)rs.getString("Millspec"));//"Millspec";

%>	
  <tr>
	<td width="15%" align="right"><%=sCustomer%></td>
	<td width="10%" align="right"><%=sWorksno%></td>
	<td width="15%" align="right"><%=sPnno%></td>
	<td width="20%" align="right"><%=sDesc%></td>

	<td width="10%" align="right">
	<% if (sisbs1 == "1") {%>
		<%=sLbs1%>
	<% } else { %>
		<%=sLbs2%>
	<% }%>
	</td>
	<td width="10%" align="right"><%=sPndate%></td>
	<td width="10%" align="right"><%=sBlno%></td>
	<td width="10%" align="right"><%=sMillspec%></td>
  </tr>
<%

        }
rs.close();

%>
</table>

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

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