📄 display14300schedule.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 = "";
    float cuBookx = 0.0f;
    float cuShipx = 0.0f;
    float cudevlbs = 0.0f;
    float brBookx = 0.0f;
    float brShipx = 0.0f;
    float brdevlbs = 0.0f;
    float totlbs = 0.0f;
    float c300devlbs = 0.0f;

    //schedule表的字段
    float etpBook = 0.0f;
    float c420Book = 0.0f;
    float c300Book = 0.0f;
    float c200Book = 0.0f;
    float etpShip = 0.0f;
    float c420Ship = 0.0f;
    float c300Ship = 0.0f;
    float c200Ship = 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  Book = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BOOK14300");
        String  Ship = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("SHIP");
        String  LBS = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("LBS");
        String  CuBook = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("CUBOOK");
        String  CuShip = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("CUSHIP");
        String  CuLBS = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("CULBS");
       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><%=Book%></td>
			<td><%=Ship%></td>
			<td><%=LBS%></td>
			<td><%=CuBook%></td>
			<td><%=CuShip%></td>
			<td><%=CuLBS%></td>
	  </tr>
    <%
          while(scheduleRs.next())
          {
              //从数据库里取数据
              schedule = scheduleRs.getString("schedule");
              ddue = scheduleRs.getString("week_date");
              etpBook = scheduleRs.getFloat("etpbook");
              c420Book = scheduleRs.getFloat("c420book");
              c300Book = scheduleRs.getFloat("c300book");
              c200Book = scheduleRs.getFloat("c200book");
              etpShip = scheduleRs.getFloat("etpship");
              c420Ship = scheduleRs.getFloat("c420ship");
              c300Ship = scheduleRs.getFloat("c300ship");
              c200Ship = scheduleRs.getFloat("c200ship");
              regBook = scheduleRs.getFloat("regbook");
              wtbBook = scheduleRs.getFloat("wtbbook");
              regShip = scheduleRs.getFloat("regship");
              wtbShip = scheduleRs.getFloat("wtbship");

              //页面显示数据
              c300devlbs = c300Ship - c300Book ;
              cuBookx = etpBook + c420Book + c300Book + c200Book;
              cuShipx = etpShip + c420Ship + c300Ship + c200Ship;
              cudevlbs = (etpShip+c420Ship+c300Ship+c200Ship) - (etpBook+c420Book+c300Book+c200Ship);

      %>
      <tr>
	         <td><%=schedule%></td>
			 <td><%=ddue%></td>
			 <td><%=c300Book%></td>
			 <td><%=c300Ship %></td>
			 <td><%=c300devlbs%></td>
			 <td><%=cuBookx%></td>
			 <td><%=cuShipx%></td>
			 <td><%=cudevlbs%></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 + -