check.jsp

来自「财务说明的管理」· JSP 代码 · 共 35 行

<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%
    String sblno = DataConvert.toRealString(iPostChange, (String) request.getParameter("blno"));
    String sql = "";
    //错误类型返回值
    String errorType = "";
    ASResultSet invRs;
    ASResultSet shipRs;

    sql = "select * from invoice where blno='" + sblno + "'";
    invRs = Sqlca.getASResultSet(sql);
    if (invRs == null || invRs.getRowCount() == 0) {
        errorType = "error1";
    } else {
        invRs.first();
        if(invRs.getString("paydate")!=null&&invRs.getString("paydate").length() >=10) {
            errorType="confirm";
        }
        sql = "select * from shipment where blno='" + sblno + "'";
        shipRs = Sqlca.getASResultSet(sql);
        if (shipRs == null || shipRs.getRowCount() == 0) {
            errorType = "error2";

        }
    }

%>
<script language=javascript>
    self.returnValue = "<%=errorType%>";
    self.close();
</script>

<%@ include file="/IncludeEnd.jsp" %>