checkcode.jsp

运输模块代码

<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-27
  Time: 09:49:17
  To change this template use File | Settings | File Templates.//
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
	String isEmpty = "0";
	//String sCode = DataConvert.toRealString(iPostChange,(String)request.getParameter("Code"));//
    //String sWorksno = DataConvert.toRealString(iPostChange,request.getParameter("Worksno"));
    String sLocation  =  DataConvert.toRealString(iPostChange,(String)request.getParameter("Location"));
	String sStratDate =  DataConvert.toRealString(iPostChange,(String)request.getParameter("StratDate"));
	String sEnddate   =  DataConvert.toRealString(iPostChange,(String)request.getParameter("Enddate"));
	String sAccount   =  DataConvert.toRealString(iPostChange,(String)request.getParameter("Account"));
	String sSubacct   =  DataConvert.toRealString(iPostChange,(String)request.getParameter("Subacct"));
    //String sWorksno = DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("Worksno"));
    //ord_item packnote
	//Customer(Account - Subacct),Worksno,Pnno,Desc,Lbs,Pndate,Blno,Millspec

	String sSql = "select p.account + '-' + p.subacct Customer ,p.worksno Works ";
		sSql += ",p.pnno Pnno,p.[desc] 'Desc',p.net * 1 Lbs1,p.net * 2.2046 Lbs2 ";
		sSql += ",p.pndate Pndate,p.blno Blno,o.millspec Millspec ";
		sSql += " from ord_item o,packnote p where o.plant = p.plant ";
		sSql += " and o.account = p.account and o.subacct = p.subacct ";
		sSql += " and p.pndate between '" + sStratDate + "' and '" + sEnddate + "' ";
		sSql += " and p.plant = '" + sLocation + "'";
	       if (sAccount!=null && sAccount.length() > 0) {

            sSql += " and p.account ='" + sAccount + "'";
        }
        if (sSubacct!=null && sSubacct.length() > 0) {

            sSql += " and p.subacct ='" + sSubacct + "'";
        }
	
	out.println(sSql);
	try{
		ASResultSet rs = Sqlca.getASResultSet(sSql);
		if(rs.next())
            isEmpty = "1";
    }
	catch (Exception e) {
		e.printStackTrace();
        isEmpty = null;
    }
    
%>
<script language=javascript>
	self.returnValue = "<%=isEmpty%>";
	self.close();
</script>
<%@ include file="/IncludeEnd.jsp"%>