checkstatus.jsp

运输模块代码

<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%
    String sWorksno = DataConvert.toRealString(iPostChange, (String) request.getParameter("worksno"));
    String sWarehouse = DataConvert.toRealString(iPostChange, (String) request.getParameter("warehouse"));

    //String worksno = Float.parseFloat(sWorksno);
    String sql = "";
    //错误类型返回值
    String errorType = "";
    ASResultSet ord_itemRs;
    ASResultSet shRs;
    String sStatus = "";
    System.out.println("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$" + sWarehouse);

    //检验ord_item
    sql = "SELECT ord_hdr.ordertype FROM ord_hdr INNER JOIN ord_item ON ord_hdr.internal = ord_item.internal WHERE (ord_item.worksno = '" + sWorksno + "')";
    shRs = Sqlca.getASResultSet(sql);
    if (shRs.next() && !sWarehouse.equals(shRs.getString("ordertype"))) {
        if (sWarehouse.equals("REG")) {
            errorType = "confirm2";
        } else {
            errorType = "confirm3";
        }
    }
    sql = "select * from ord_item where worksno='" + sWorksno + "'";
    ord_itemRs = Sqlca.getASResultSet(sql);
    if (ord_itemRs.next()) {
        sStatus = ord_itemRs.getString("status");
        if (sStatus.equals("CM")) {
            errorType = errorType + "confirm1";
        }
//            else {
//                errorType = "confirm2";
//            }


    }

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

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