checkcode.jsp

运输模块代码

<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-21
  Time: 16:38:11
  To change this template use File | Settings | File Templates.//
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
	String sReturn = null;
	String sWorksno = DataConvert.toRealString(iPostChange,request.getParameter("Worksno"));


    if ("0".equals(sWorksno)){
        sReturn = "FALSE";
    } else {
    String sSql = "select top 1 * from shipment where worksno ='"+sWorksno +"'";

    try{
        ASResultSet rs = Sqlca.getASResultSet( sSql );
        if(rs.next()){
            sSql = "select top 1 * from ord_item where worksno='"+sWorksno +"'";
            rs = Sqlca.getASResultSet( sSql );
            if(rs.next()){
                 sReturn = (String)rs.getString("Status");
                System.out.println("$$$$$$$$$$$$$$$$$$$$$$$$$"+sReturn);
            }

        } else {
        }
    } catch (Exception e){
        e.printStackTrace();
    }
    }
%>
<script language=javascript>
    //alert(sSql);alert(isEmpty);
    self.returnValue = "<%=sReturn%>";
	self.close();
</script>
<%@ include file="/IncludeEnd.jsp"%>