enterdate.jsp

财务说明的管理

<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%
    String lTitle = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("Title");
    String lInvBLNo = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lInvBLNo");
    String lExitpt = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lExitpt");
    String lCurrency = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lCurrency");

    String lFrghtFrwd = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lFrghtFrwd");
    String lExitFreight = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lExitFreight");
    String lShipDate = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lShipDate");

    String lBroker = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lBroker");
    String lCountry = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lCountry");

    String lCarrier = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lCarrier");
    String lPriceList = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lPriceList");

    String lCustomer = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lCustomer");
    String lInvoiceDate = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lInvoiceDate");
    String Submit = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("Submit");
    String lRoute = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lRoute");

    String lInvoiceTo = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lInvoiceTo");
    String lShipto = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("lShipto");

    String Reedit = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("Reedit");
    String Abort = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("Abort");


    String txtInvBLNo = DataConvert.toRealString(iPostChange, CurPage.getParameter("txtInvBLNo"));
%>
<%
    String m_shipdt = "";
    String m_name = "";
    String forward = "";
    String broker = "";
    String carrier = "";
    String customer = "";
    String m_bladd1 = "";
    String m_bladd2 = "";
    String m_bladd3 = "";
    String m_bladd4 = "";
    String m_shadd1 = "";
    String m_shadd2 = "";
    String m_shadd3 = "";
    String m_shadd4 = "";
    String currency = "";
    String country = "";
    String pricelist = "";
    String route = "";
    String exitpt = "";
    String exitfr = "";
    String worksno = "";
    String custpo = "";
    String desc = "";
    String coils = "";
    String contract = "";
    String width = "";
    String gauge = "";
    String notes = "";
    String custprod = "";
    String custspec = "";
    String net = "";
    double gross = 0;
    double valeocu = 0;
    double valeozinc = 0;
    double modinecu = 0;
    double modinezinc = 0;
    double modcancu = 0;
    double modcanzinc = 0;
    double copper = 0;
    double zinc = 0;
    double uscopper = 0;
    double uszinc = 0;
    double millspec = 0;
    String plant = "";
    boolean IsTinning = true;

    double fabpr = 0;
    double metalpr = 0;
    double premiumpr = 0;
    double tinningpr = 0;
    double unitdutypr = 0;
    boolean islbs = true;
    double totorder = 0;
    double nvalue = 0;
    double invunit = 0;
    double nett = 0;
    double invextend = 0;
    double prepaid = 0;
    double collect = 0;
    double duty = 0;
    double declared = 0;
    double tcopper = 0;
    double otherfees = 0;
    double frins = 0;
    double t1 = 0;
    double t2 = 0;
    double t3 = 0;
    double valueunder = 0;
    double dutyunder = 0;
    double tbrass_under = 0;
    double tbrass_over = 0;
    double usrate = 0;
    double insurance = 0;
    double brokerage = 0;
    double totfrduty = 0;
    double sunreason2 = 0;
    double subtot = 0;
    double freight = 0;
    double sundry = 0;
    double fsurcharge = 0;


    ASResultSet rsGlobal = Sqlca.getASResultSet("select  * from global");
    if (rsGlobal.next()) {
        valeocu = rsGlobal.getDouble("valeocu");
        valeozinc = rsGlobal.getDouble("valeozinc");
        modinecu = rsGlobal.getDouble("modinecu");
        modinezinc = rsGlobal.getDouble("modinezinc");
        modcancu = rsGlobal.getDouble("modcancu");
        modcanzinc = rsGlobal.getDouble("modcanzinc");
        copper = rsGlobal.getDouble("copper");
        zinc = rsGlobal.getDouble("zinc");
        uscopper = rsGlobal.getDouble("uscopper");
        uszinc = rsGlobal.getDouble("uszinc");
        millspec = rsGlobal.getDouble("millspec");
        valueunder = rsGlobal.getDouble("valueunder");
        dutyunder = rsGlobal.getDouble("dutyunder");
        usrate = rsGlobal.getDouble("usrate");
        plant = rsGlobal.getString("plant");
        if (rsGlobal.getString("plant").equals("FERG")) {
            IsTinning = true;
        } else {
            IsTinning = false;
        }
    }
%>    <!-- For Show-->
<%
    String sql = "select * from " +
            " shipment " +
            " where blno =" + txtInvBLNo +
            " order by custpo,worksno";
    ASResultSet rs = Sqlca.getASResultSet(sql);
    if (rs.next()) {
        worksno = rs.getString("worksno");
        m_shipdt = rs.getString("shipdt");
        m_shadd1 = rs.getString("add1");
        m_shadd2 = rs.getString("add2");

        worksno = rs.getString("worksno");
        custpo = rs.getString("custpo");
        desc = rs.getString("desc");
        coils = rs.getString("coils");
        /* if(rs.getString("contract").trim().equals("FERGUS-T"))
        {
             contract=rs.getString("contract").trim() + "  TOLL";
        }*/
        width = rs.getString("width") + "mm";
        gauge = rs.getString("gauge") + "mm";
        notes = rs.getString("notes");
        custprod = rs.getString("custprod");

        if (rs.getString("islbs").equals("0")) {
            net = rs.getString("net") + "lbs";
        } else {
            net = rs.getString("net") + "kgs";
        }
        gross = rs.getDouble("loaded") * (-1);
        fabpr = rs.getDouble("fabpr");
        metalpr = rs.getDouble("metalpr");
        premiumpr = rs.getDouble("premiumpr");
        tinningpr = rs.getDouble("tinningpr");
        unitdutypr = rs.getDouble("unitdutypr");
        invunit = rs.getDouble("invunit");


    }
    ASResultSet rspacknote = Sqlca.getASResultSet("select * from packnote where blno=" + txtInvBLNo);
    if (rspacknote.next()) {
        nett = rspacknote.getDouble("net");
    }
    ASResultSet rs1 = Sqlca.getASResultSet("select * from invoice where blno=" + txtInvBLNo);
    if (rs1.next()) {
        sunreason2 = rs1.getDouble("sunreason2");
        freight = rs1.getDouble("freight");
        sundry = rs1.getDouble("sundry");
        fsurcharge = rs1.getDouble("fsurcharge");
        forward = rs1.getString("forward");
        broker = rs1.getString("broker");
        carrier = rs1.getString("carrier");
        customer = rs1.getString("name");
        exitpt = rs1.getString("exitpt");
        exitfr = rs1.getString("exitfr");
        invextend = rs1.getDouble("invextend");
        prepaid = rs1.getDouble("prepaid");
        collect = invextend - prepaid;
        declared = rs1.getDouble("declared");
        tcopper = invextend;
        if (tcopper > 0) {
            t1 = t1 - tcopper / declared * frins + tcopper / declared * otherfees;
            t1 = t1 / valueunder * dutyunder;
        }
        if (tbrass_under > 0) {
            t2 = t2 - tbrass_under / declared * frins + tbrass_under / declared * otherfees;
            t2 = t2 / valueunder * dutyunder;
        }
        if (tbrass_over > 0) {
            t3 = t3 - tbrass_over / declared * frins + tbrass_over / declared * otherfees;
            t3 = t3 / valueunder * dutyunder;
        }
        otherfees = rs1.getDouble("otherfees");
        frins = rs1.getDouble("frins");
        if (currency.equals("CA")) {
            duty = (t1 + t2 + t3) * usrate;
        } else {
            duty = (t1 + t2 + t3);
        }

        insurance = rs1.getDouble("insurance");
        brokerage = rs1.getDouble("brokerage");
        totfrduty = frins + insurance + duty + brokerage;


    }
    ASResultSet rs2 = Sqlca.getASResultSet("select * from customer where account='" + rs.getString("account") + "' and subacct='" + rs.getString("subacct") + "'");
    if (rs2.next()) {
        m_bladd1 = rs2.getString("bladd1");
        m_bladd2 = rs2.getString("bladd2");
        m_bladd3 = rs2.getString("blcity").trim() + "," + rs2.getString("blprovst").trim();
        m_bladd4 = rs2.getString("blcountry") + "  " + rs2.getString("blpcode");
        currency = rs2.getString("currency");
        country = rs2.getString("country");
        pricelist = rs2.getString("pricelist");
        route = rs2.getString("route");

    }
    ASResultSet rs3 = Sqlca.getASResultSet("select * from ord_item where account='" + rs.getString("account") + "' and subacct='" + rs.getString("subacct") + "'");
    if (rs3.next()) {
        custspec = rs3.getString("custspec");

    }

    ASResultSet rsOrditem = Sqlca.getASResultSet("select * from ord_item where worksno=" + rs.getString("worksno"));
    if (rsOrditem.next()) {
        String dw = "";
        if (rsOrditem.getString("islbs").equals("0")) {
            dw = "lbs";
        } else {
            dw = "kgs";
        }
        if (islbs == true) {
            totorder = rsOrditem.getDouble("lbs") * rsOrditem.getDouble("priceprem") + rsOrditem.getDouble("lbs") * rsOrditem.getDouble("pricemetal") + rsOrditem.getDouble("lbs") * rsOrditem.getDouble("pricefab");
        } else {