save.jsp

财务说明的管理

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

    String mzpn = DataConvert.toRealString(iPostChange, request.getParameter("mzpn"));
    String ShipDt = DataConvert.toRealString(iPostChange, request.getParameter("ShipDt"));
    String add1 = DataConvert.toRealString(iPostChange, request.getParameter("add1"));
    String add2 = DataConvert.toRealString(iPostChange, request.getParameter("add2"));
    String gblno = DataConvert.toRealString(iPostChange, request.getParameter("gblno"));
    System.out.println("%%%%%%%%%%%%%%%%%%%%" + gblno);
    String whblno = DataConvert.toRealString(iPostChange, request.getParameter("whblno"));
    String name = DataConvert.toRealString(iPostChange, request.getParameter("name"));
    String account = DataConvert.toRealString(iPostChange, request.getParameter("account"));
    String subacct = DataConvert.toRealString(iPostChange, request.getParameter("subacct"));
    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;
    int NNOTES = 0;
    int tnotes = 0;
    boolean pnreject = false;
    //ASResultSet  rs = Sqlca.getASResultSet("select * from whouse where wcode = '"+mzpn+"' ");
    System.out.println(mzpn);
    System.out.println(myarray.length);
    System.out.println(myarray);
    for (int i = 0; i < myarray.length; i++) {
        if ((!"".equals(myarray[i])) && myarray[i] != null) {
            System.out.println("&^&^&^&^&^&^&^&^&^");
            ASResultSet rs = Sqlca.getASResultSet("select * from packnote where pnno = '" + myarray[i] + "' ");
            if (rs.next()) {
                Sqlca.executeSQL("update packnote set finblno ='" + gblno + "' where pnno = '" + myarray[i] + "'");
                // Sqlca.conn.commit();
                if (rs.getString("account").equals(account) && rs.getString("subacct").equals(subacct)) {
                    myarray[i] = rs.getString("pnno");
                    mzgross[i] = rs.getString("gross");     //
                    mzpnnet[i] = rs.getString("net");        //
                    mzpncoils[i] = rs.getString("coils");     //
                    tloaded = tloaded - rs.getDouble("gross");
                    tbalance = tbalance - rs.getDouble("gross");
                    tnet = tnet + rs.getDouble("net");
                    if (rs.getDouble("net") > 0) {
                        tnotes = tnotes + 1;
                        System.out.println("%%%%%%%%%%%" + tnotes);
                    }
                }

            }
// else
//       {
//            NNOTES=i-1;
//           if(NNOTES<0)
//           {
//               NNOTES=0;
//           }
//
//       }
            NNOTES = i;
        }
        System.out.println("%%%%%%%%%%%" + NNOTES);

    }
    for (int j = 0; j <= NNOTES; j++) {
        ASResultSet rsp = Sqlca.getASResultSet("select * from packnote where pnno = '" + myarray[j] + "' ");
        rsp.next();
        ASResultSet rss = Sqlca.getASResultSet("select * from shipment where blno = '" + rsp.getString("blno") + "' and [desc]='" + rsp.getString("desc") + "'");
        rss.next();
        System.out.println("%%%%%%%%%%%%%%%%%%%%%%%%");
        Sqlca.executeSQL("update shipment set blno ='" + rsp.getString("finblno") + "'," +
                "net='" + rsp.getString("net") + "',notes=1,coils='" + rsp.getString("coils") + "',shiptype='w'," +
                "loaded='" + rsp.getDouble("gross") * (-1) + "',shipdt='" + ShipDt + "',wblno='" + whblno + "',name='" + name + "'," +
                "plant='HILL',add1='" + add1 + "',add2='" + add2 + "'  " +
                "where blno = '" + rsp.getString("blno") + "' and [desc]='" + rsp.getString("desc") + "'");
        System.out.println("%%%%%%%%%%%%%%%%%%%%%%%%");
        Sqlca.conn.commit();
        ASResultSet rs = Sqlca.getASResultSet("select * from customer where account = '" + account + "' and subacct='" + subacct + "'");
        rs.next();
        Sqlca.executeSQL("update invoice set blno='" + rsp.getString("finblno") + "',account='" + rsp.getString("account") + "'," +
                "subacct='" + rsp.getString("subacct") + "',invdate='" + ShipDt + "',carrier='',forward='',route=''," +
                "gross=" + rsp.getDouble("gross") * (-1) + ",net=" + tnet + ",notes=" + tnotes + ",prepaid =0,frins =0,duty=0,totfrduty =0," +
                "accpaced =0,plant ='HILL',name='" + name + "',bladd1='" + add1 + "',bladd2='" + add2 + "',bladd3='" + rs.getString("blcity") + "," +
                "" + rs.getString("blprovst") + "',bladd4='" + rs.getString("blcountry") + " " + rs.getString("blpcode") + "'," +
                "currency='" + rs.getString("currency") + "',shadd1='" + rs.getString("shadd1") + "',shadd2='" + rs.getString("shadd2") + "'," +
                "shadd3='" + rs.getString("shcity") + "," + rs.getString("shprovst") + "',shadd4='" + rs.getString("shcountry") + " " + rs.getString("shpcode") + "'," +
                " fsurrate=" + rs.getFloat("fsurrate") + " where blno = '" + rsp.getString("blno") + "'");

        Sqlca.conn.commit();

    }

%>
<script language=javascript>
    self.returnValue = "ok";
    self.close();
</script>
<%@ include file="/IncludeEnd.jsp" %>