checkworksno.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 customerRs;
    ASResultSet packnoteRs;

    //检查worksno是否满足要求
    String sAccount = "";
    String sSubacct = "";
    String sServstatus = "";
    String sLstatus = "";
    String sStatus = "";
    String sCrdflag = "";
    String sOvership = "";
    String alertpart = "";

    //检验ord_item
    sql = "select * from ord_item where worksno='" + sWorksno + "'";
    System.out.println(sql);
    ord_itemRs = Sqlca.getASResultSet(sql);
    if (ord_itemRs == null || ord_itemRs.getRowCount() == 0) {
        errorType = "error2";
    } else if (ord_itemRs.next()) {

        sAccount = ord_itemRs.getString("account");
        sSubacct = ord_itemRs.getString("subacct");
        sServstatus = ord_itemRs.getString("servstatus");
        sLstatus = ord_itemRs.getString("lstatus");
        sStatus = ord_itemRs.getString("status");
        sOvership = ord_itemRs.getString("overship");
        if (sServstatus.equals("NO")) {
            errorType = "error3";

        }
        //foxpro源程序：
//        SELECT ord_item
//   SEEK m.worksno
//   IF servstatus= 'NO'
//      DO poperror WITH 'Customer Service has a hold on this order. Unable to ship.'
//      CLEAR
//      LOOP
//   ENDIF                                         (STATUS= 'CA') (lstatus= 'NO') (servstatus= 'NO')
//
//   IF lstatus= 'NO'
//      DO poperror WITH 'Laboratory has a hold on this order. Unable to ship.'
//      CLEAR
//      LOOP
//   ENDIF                                         (STATUS= 'CA') (lstatus= 'NO')
        //事实上根据源程序下面一段应该加上的 ，但是去掉了菜和原程序表现一致
//        if (sLstatus.equals("NO")) {
//                errorType = "error4";
//
//            }
        if (sStatus.equals("CA")) {
            errorType = "error5";

        }
        alertpart = sAccount + "  " + sSubacct + "  " + sWorksno;
        sql = "select * from customer where account='" + sAccount + "' and subacct='" + sSubacct + "'";
        customerRs = Sqlca.getASResultSet(sql);
        if (customerRs == null || customerRs.getRowCount() == 0) {
            errorType = "error1";

        } else {
            customerRs.next();
            sCrdflag = customerRs.getString("crdflag");
            sql = "select * from packnote where (blno IS NULL OR blno = '')  and worksno='" + sWorksno + "'";
            // sql = "select * from packnote where blno is null and worksno='" + sWorksno +"'";
            packnoteRs = Sqlca.getASResultSet(sql);
            if (!packnoteRs.next()) {
                errorType = "error6";

            }
            //检验表ord_item对应记录的状态是否为"CM"
            if (sOvership == null) {
                if (sCrdflag.equals("LC")) {
                    errorType = "alert1" + alertpart;
                } else if (sCrdflag.equals("CD")) {
                    errorType = "alert2" + alertpart;
                } else if (sCrdflag.equals("CA") || sCrdflag.equals("PD")) {
                    errorType = "alert3" + alertpart;
                } else if (sCrdflag.equals("NO") || sCrdflag.equals("CH") || sCrdflag.equals("NC")) {
                    errorType = "alert4" + alertpart;
                }
            }
//            else if (sStatus.equals("CM")) {
//                errorType = "confirm1";
//            }
//            else {
//                errorType = "confirm2";
//            }

        }
    }

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

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