check.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2006-11-1
  Time: 16:22:19
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%
    String pnno = DataConvert.toRealString(iPostChange, (String) request.getParameter("pnno"));
    String sql = "";
    //错误类型返回值
    String errorType = "";
    ASResultSet pnRs;
    ASResultSet oiRs;
    ASResultSet gloRs;
    int flag = 0;
    sql = "select * from packnote where pnno='" + pnno + "'";
    pnRs = Sqlca.getASResultSet(sql);
    while (flag == 0) {
        if (pnRs == null || pnRs.getRowCount() == 0) {
            errorType = "error1";
            break;
        }
        pnRs.next();
        if (pnRs.getString("ordertype")==null||pnRs.getString("ordertype").equals("REG")||pnRs.getString("ordertype").equals("")) {
            errorType = "error2";
            break;
        }
        sql = "select * from ord_item where worksno='" + pnRs.getString("worksno") + "'";
        oiRs = Sqlca.getASResultSet(sql);
        if (oiRs == null || oiRs.getRowCount() == 0) {
            errorType = "error3";
            break;
        }
        sql="select * from global";
        gloRs = Sqlca.getASResultSet(sql);
        gloRs.first();
        if(!gloRs.getString("plant").equals(pnRs.getString("plant"))){
              errorType = "error4";
            break;
        }
        flag = 1;
    }

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

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