📄 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 desc = "";
    String sql = "";
    ASResultSet rs;
    String curpromdt = "";
    String sWorksno = "";
    float curpromqty = 0.0f;
    int i=1;

    sql = "select * from ord_item,promise where promise.worksno=ord_item.worksno  and promise.worksno>=100000  ";
    if (sAccount != null && sAccount.length() > 0) {
        sql = sql + "  and promise.account='" + sAccount + "'";
    }
    if (sSubacct != null && sSubacct.length() > 0) {
        sql = sql + "  and promise.subacct='" + sSubacct + "'";
    }
    if (sDate != null && sDate.length() > 0) {
        //起始日期条件
        sql = sql + "  and curpromdt >= '" + sDate + "'";
    }
    if (eDate != null && eDate.length() > 0) {
        //截至日期条件
        sql = sql + " and curpromdt <= '" + eDate + "'";
    }
    sql = sql + "  order by promise.worksno desc";
    System.out.println("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&sql="+sql);
    rs = Sqlca.getASResultSet(sql);
    if (rs.getRowCount() == 0) {
%>
没有记录
<%
} else {
%>
<table width="80%" border="1" cellspacing="0">
    <tr>
        <td>Number</td>
        <td>Account</td>
        <td>Subacct</td>
        <td>Works</td>
        <td>Desc</td>
        <td>Date</td>
        <td>Lbs</td>
    </tr>
    <% while (rs.next()) {
        desc = rs.getString("alloy") + "  " + rs.getString("temper") + "  " + String.valueOf(rs.getFloat("width")) + "  " + String.valueOf(rs.getFloat("gauge"));
        sWorksno = (String.valueOf(rs.getFloat("worksno"))).substring(0, 6);
        curpromdt = rs.getString("curpromdt").substring(0, 10);
        if (rs.getInt("islbs") == 1) {
            curpromqty = rs.getFloat("curpromqty");
        } else {
            curpromqty = rs.getFloat("curpromqty") * 2.2046f;
        }
    %>
    <tr>
        <td><%=i%></td>
        <td><%=rs.getString("account")%></td>
        <td><%=rs.getString("subacct")%></td>
        <td><%=sWorksno%></td>
        <td><%=desc%></td>
        <td><%=curpromdt%></td>
        <td><%=curpromqty%></td>
    </tr>

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

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