checkcode.jsp

运输模块代码

<%
    /**
     * @ author: RuiLei
     * @ date:   2006-5-20
     */
%>
<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%
    String checkType = DataConvert.toRealString(iPostChange, request.getParameter("CheckType"));
    String code = DataConvert.toRealString(iPostChange, request.getParameter("Code"));

    boolean isEmpty = true;
    String queryStr = "";

    if (checkType != null && checkType.equals(Consts.LOTNO_EMPTY)) {
        // Check the lot number is exist
        queryStr = "select top 1 pnno from packnote where rtrim(pnno) = '" + code + "'";
        ASResultSet rs = Sqlca.getASResultSet(queryStr);
        isEmpty = !rs.next();
    } else if (checkType != null && checkType.equals(Consts.LOTNO_IN_SHIPPING_LIST)) {
        // Check the lot number is on shipping list
        String blno = DataConvert.toRealString(iPostChange, request.getParameter("Blno"));
        queryStr = "select top 1 blno from packnote where rtrim(pnno) = '" + code + "'";
        ASResultSet rs = Sqlca.getASResultSet(queryStr);
        rs.next();
        if (rs.getString("blno") == null || rs.getString("blno").equals("")) {
            isEmpty = true;
        } else {
            isEmpty = false;
        }
    }
%>
<script language=javascript>
    self.returnValue = "<%=isEmpty%>";
    self.close();
</script>
<%@ include file="/IncludeEnd.jsp" %>