📄 displayweldedtubeschedule.jsp

📁 运输模块代码
💻 JSP
字号:
<%--
  Created by IntelliJ IDEA.
  User: Ligang Wu
  Date: 2006-5-30
  Time: 22:00:22
  To change this template use File | Settings | File Templates.
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@ include file="/IncludeBegin.jsp"%>
<%
    //所用的全局变量
    String schedule = "";
    String ddue = "";
    String spacer = "";
    String spacer1 = "";
    float brBookx = 0.0f;
    float brShipx = 0.0f;
    float brdevlbs = 0.0f;
    float wtbdevlbs = 0.0f;

    //schedule表的字段
    float corBook = 0.0f;
    float corShip = 0.0f;
    float regBook = 0.0f;
    float wtbBook = 0.0f;
    float regShip = 0.0f;
    float wtbShip = 0.0f;
%>
<body class="pagebackground" >
   <%
        String  Week = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("WEEK");
        String  Due = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("DUE");
        String  BrBook = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BRBOOK");
        String  BrShip = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BRSHIP");
        String  BrLBS = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BRLBS");
        String  WTBBook = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("WTBBOOK");
        String  WTBShip = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("WTBSHIP");
        String  WTBLBS = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("WTBLBS");
       try
       {
       //存储检索schedule表的结果
        ASResultSet scheduleRs;
       String sql = " select * from schedule  order by week_date";
       scheduleRs = Sqlca.getASResultSet(sql);
       if(scheduleRs.getRowCount() > 0)
       {
   %>
<table border="1" cellpadding="1" cellspacing="1" >
      <tr >
	        <td ><%=Week%></td>
			<td><%=Due%></td>
			<td width="15"></td>
            <td><%=WTBBook%></td>
            <td><%=WTBShip%></td>
            <td><%=WTBLBS%></td>
			<td width="15"></td>
			<td><%=BrBook%></td>
			<td><%=BrShip%></td>
			<td><%=BrLBS%></td>
	  </tr>
    <%
          while(scheduleRs.next())
          {
              //从数据库里取数据
              schedule = scheduleRs.getString("schedule");
              ddue = scheduleRs.getString("week_date");
              corBook = scheduleRs.getFloat("corbook");
              corShip = scheduleRs.getFloat("corship");
              regBook = scheduleRs.getFloat("regbook");
              wtbBook = scheduleRs.getFloat("wtbbook");
              regShip = scheduleRs.getFloat("regship");
              wtbShip = scheduleRs.getFloat("wtbship");

              //页面显示数据
              spacer = " ";
              wtbdevlbs = wtbShip - wtbBook;
              spacer1 = " ";
              brBookx = regBook +corBook + wtbBook;
              brShipx = regShip + corShip + wtbShip;
              brdevlbs = (regShip+corShip+wtbShip) - (regBook+corBook+wtbBook);

      %>
      <tr>
	         <td><%=schedule%></td>
			 <td><%=ddue%></td>
			 <td><%=spacer%></td>
			 <td><%=wtbBook %></td>
			 <td><%=wtbShip%></td>
			 <td><%=wtbdevlbs%></td>
			 <td><%=spacer1%></td>
			 <td><%=brBookx%></td>
			 <td><%=brShipx%></td>
			 <td><%=brdevlbs%></td>
	  </tr>
	 <%
           }//while(scheduleRs.next())
      %>

	</table>
<%
       }//if(scheduleRs.getRowCount() > 0)
    }//try
    catch (Exception e) {
           e.printStackTrace();
   }
%>
</body>
<%@ include file="/IncludeEnd.jsp" %>
⌨️ 快捷键说明

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