checkcode.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:lijun 2006-5-17
    * 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 rs = Sqlca.getASResultSet("select * from ord_item where worksno = '" + sCode + "'");
    ASResultSet rs1 = Sqlca.getASResultSet("select * from  packnote where worksno = '" + sCode + "' and (blno is null or blno='')");

    if (!rs.next()) {
        isEmpty = "error1";
    } else {
        ASResultSet rs2 = Sqlca.getASResultSet("select * from  customer where account = '" + rs.getString("account") + "' and subacct='"+rs.getString("subacct")+"'");
        if (!rs2.next()) {
            isEmpty = "error3";
        }
        else if("NO".equals(rs.getString("servstatus"))){
            isEmpty="error4";
        }
//        else if("NO".equals(rs.getString("lstatus"))){
//            isEmpty="error5";
//        }
        else if (!rs1.next()) {
            isEmpty = "error6";
        }
    }

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