📄 inquiry.jsp

📁 运输模块代码
💻 JSP
字号:
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%@ page contentType="text/html; charset=GBK" language="java" %>
<%@ include file="/IncludeBegin.jsp" %>
<html><head><title>PromiseInquiry</title></head>
<body class="pagebackground"   text="#000000">
<%
    //检索的起始日期
    String sDate = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("sdate"));
    //检索截至日期
    String eDate = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("edate"));
    //检索界面传递过来的account,subacct
    String sAccount = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("account"));
    String sSubacct = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("subacct"));


%>

<%
    String sql = "";
    ASResultSet rs;
    String shipdt = "";
    String sWorksno = "";
    float nnet = 0.0f;
    int i=1;


    sql = "select * from shipment where  worksno>=100000  ";
    if (sAccount != null && sAccount.length() > 0) {
        sql = sql + "  and account='" + sAccount + "'";
    }
    if (sSubacct != null && sSubacct.length() > 0) {
        sql = sql + "  and subacct='" + sSubacct + "'";
    }
    if (sDate != null && sDate.length() > 0) {
        //起始日期条件
        sql = sql + "  and shipdt >= '" + sDate + "'";
    }
    if (eDate != null && eDate.length() > 0) {
        //截至日期条件
        sql = sql + " and shipdt <= '" + eDate + "'";
    }
    sql = sql + "  order by shipdt desc";
    System.out.println("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&sql="+sql);
    rs = Sqlca.getASResultSet(sql);

%>
<table width="80%" border="1" cellspacing="0">
    <tr>
        <td>Number</td>
        <td>Account</td>
        <td>Subacct</td>
        <td>Works</td>
        <td>Desc</td>
        <td>Blno</td>
        <td>Date</td>
        <td>Lbs</td>
    </tr>
    <% while (rs.next()) {
        sWorksno = (String.valueOf(rs.getFloat("worksno"))).substring(0, 6);
        shipdt = rs.getString("shipdt").substring(0, 10);
        if (rs.getInt("islbs") == 1) {
            nnet = rs.getFloat("net");
        } else {
            nnet = rs.getFloat("net") * 2.2046f;
        }
    %>
    <tr>
        <td><%=i%></td>
        <td><%=rs.getString("account")%></td>
        <td><%=rs.getString("subacct")%></td>
        <td><%=sWorksno%></td>
        <td><%=rs.getString("desc")%></td>
        <td><%=shipdt%></td>
        <td><%=rs.getString("blno")%></td>
        <td><%=nnet%></td>
    </tr>

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

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