check.jsp

运输模块代码

<%
    /* Copyright 2006-2009 Hexiesoft, Inc. All Rights Reserved.
    * This software is the proprietary information of Hexiesoft, Inc.
    * Use is subject to license terms.
    * Author:sz 2006-5-20
    * Tester:
    *
    * Content:
    * Input Param:
    *
    *
    *
    * Output param:
    *
    */
%>
<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%
    String isEmpty = "";
    String sCode = DataConvert.toRealString(iPostChange, (String) request.getParameter("Code"));
    ASResultSet shipmentRs = Sqlca.getASResultSet("select Blno from Shipment where Blno = '" + sCode + "'");
    ASResultSet packnoteRs = Sqlca.getASResultSet("select Blno from packnote where Blno = '" + sCode + "'");
    ASResultSet invoiceRs = Sqlca.getASResultSet("select * from invoice where blno='" + sCode + "'");
    if (!shipmentRs.next()) {
        isEmpty = "sh";
    } else if (!packnoteRs.next()) {
        isEmpty = "pa";
    } else if (invoiceRs.next()) {
        if (!(invoiceRs.getString("verifyby").equals("PROFORMA"))) {
            isEmpty = "in";
        }

    }
%>
<script language=javascript>
    self.returnValue = "<%=isEmpty%>";
    self.close();
</script>
<%@ include file="/IncludeEnd.jsp" %>
</html>