checkarraytxt.jsp

财务说明的管理

<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%

    String mzpn = DataConvert.toRealString(iPostChange, request.getParameter("mzpn"));
    String account = DataConvert.toRealString(iPostChange, request.getParameter("account"));
    String subacct = DataConvert.toRealString(iPostChange, request.getParameter("subacct"));
    String invbin = DataConvert.toRealString(iPostChange, request.getParameter("invbin"));
    System.out.println(mzpn);
    String[] myarray = mzpn.split("\\|");
    String[] mzgross = new String[40];
    String[] mzpnnet = new String[40];
    String[] mzpncoils = new String[40];
    double tloaded = 0;
    double tbalance = 0;
    double tnet = 0;
    double gross = 0;
    double net = 0;
    String rValue = "";
    int j=0;
    for (int i = 0; i < myarray.length; i++) {
        if (myarray[i].equals("")) {
            continue;
        }
        ASResultSet rs = Sqlca.getASResultSet("select * from packnote where pnno = '" + myarray[i] + "'");
        if (!rs.next()) {
            rValue = rValue + "   Lot number not found " + myarray[i];
        }
       else {
            myarray[i] = rs.getString("pnno");
            mzgross[i] = rs.getString("gross");     //
            mzpnnet[i] = rs.getString("net");        //
            mzpncoils[i] = rs.getString("coils");
            ASResultSet rs1 = Sqlca.getASResultSet("select * from packnote where pnno = '" + myarray[i] + "' and account='" + account + "' and subacct='" + subacct + "'");
            if (rs1.next()) {
                tloaded = tloaded - rs.getDouble("gross");
                tbalance = tbalance - rs.getDouble("gross");
                tnet = tnet + rs.getDouble("net");
            } else {
                rValue = rValue + "    Lot number: " + myarray[i] + "is for another customer." + rs.getString("account") + "-" + rs.getString("subacct");
            }
           System.out.println(invbin);
            if (!invbin.equals(rs.getString("ordertype"))) {
                rValue = rValue + "    Lot number: " + myarray[i] + " is in " + rs.getString("ordertype") + "warehouse";
            }
            if (rs.getString("finblno") != null && (!"".equals(rs.getString("finblno")))) {
                rValue = rValue + "    Lot number: " + myarray[i] + "  has been shipped via B/L " + rs.getString("finblno");
            }
        }
        System.out.println(j++);
    }
    gross = tloaded * (-1);
    if (gross < 0) {
        gross = 0;
    }
    net = tnet;
%>
<script language=javascript>
    self.returnValue = "<%=rValue%>" + "|" + "<%=gross %>" + "|" + "<%=net%>";
    self.close();
</script>
<%@ include file="/IncludeEnd.jsp" %>