exsitquery.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: niekun
  Date: 2006-10-17
  Time: 11:18:20
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ include file="/IncludeBeginMD.jsp" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%
    String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));
    String lable = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE");
    String lable1 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE1");
    String lable2 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE2");
    String lable3 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE3");
    String lable4 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE4");
    String lable5 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE5");
    String lable6 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE6");
    String lable7 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE7");
    String lable8 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE8");
    String lable9 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE9");
    String lable10 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE10");
    String lable11 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE11");
    String lable12 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE12");
    String lable13 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE13");
    String lable14 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE14");
    String lable15 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE15");
    String lable16 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE16");
    String lable17 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE17");
    String lable18 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE18");
    String lable19 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE19");
    String lable20 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE20");
    String lable21 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("LABLE21");
    String alert3 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("ALERT_3");
    String alert4 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("ALERT_4");
    String confirm1 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("CONFIRM_1");
    String confirm2 = (String) Configure.getConfigure(sIe_Language, "BillingcancelBOL").get("CONFIRM_2");
    String currency = "";
    String forward = "";
    String invdate = "";
    String broker = "";
    String carrier = "";
    String name = "";
    String gross = "";
    String net = "";
    String invamt = "";
    String prepaid = "";
    String frins = "";
    String collect = "";
    String insurance = "";
    String brokerage = "";
    String freight = "";
    String duty = "";
    String subtot = "";
    float totfrduty = 0f;
    String invgst = "";
    String declared = "";
    String shipdt = "";
    int accpaced = 0;
    int tranpflag = 0;

    String sql = "select * from invoice where blno='" + blno + "'";
    ASResultSet rs = Sqlca.getASResultSet(sql);
    if (rs.next()) {
        currency = rs.getString("currency");
        forward = rs.getString("forward");
        invdate = rs.getString("invdate");
        broker = rs.getString("broker");
        carrier = rs.getString("carrier");
        name = rs.getString("name");
        gross = rs.getString("gross");
        net = rs.getString("net");
        invamt = rs.getString("invamt");
        prepaid = rs.getString("prepaid");
        frins = rs.getString("frins");
        collect = rs.getString("collect");
        insurance = rs.getString("insurance");
        brokerage = rs.getString("brokerage");
        freight = rs.getString("freight");
        duty = rs.getString("duty");
        subtot = rs.getString("subtot");
        totfrduty = Float.parseFloat(frins) + Float.parseFloat(insurance) + Float.parseFloat(brokerage) + Float.parseFloat(duty);
        invgst = rs.getString("invgst");
        declared = rs.getString("declared");
        tranpflag = rs.getInt("tranpflag");
        accpaced = rs.getInt("accpaced");
    }
    sql = "select * from shipment where blno='" + blno + "'";
    ASResultSet rs1 = Sqlca.getASResultSet(sql);
    if (rs.next()) {
        shipdt = rs1.getString("shipdt");
    }

%>
<head><title></title></head>
<script type="text/javascript">
    function check()
    {
        var blno='<%=blno%>';
        var tran = '<%=tranpflag%>';
        var accp = '<%=accpaced%>';
        if (!confirm('<%=confirm1%>')) {
            OpenComp("ExistOrder", "/Billing/cancelBOL/Blank.jsp", "rand=" + randomNumber(), "right", "");
            self.close();
            self.returnValue = "OK";
            return;
        }
        if (!confirm('<%=confirm2%>')) {
            OpenComp("ExistOrder", "/Billing/cancelBOL/Blank.jsp", "rand=" + randomNumber(), "right", "");
            self.close();
            self.returnValue = "OK";
            return;
        }
        if (tran == 1 || accp == 1) {
            alert('<%=alert3%>');
            OpenComp("ExistOrder", "/Billing/cancelBOL/Blank.jsp", "rand=" + randomNumber(), "right", "");
            self.close();
            self.returnValue = "OK";
            return;
        }
        var sReturn = PopPage("/Billing/cancelBOL/EnterReason.jsp?blno=" + blno + "&rand=" + randomNumber(), "", "dialogWidth=30;dialogHeight=8;center:yes;status:no;statusbar:no");
        return;
    }
</script>
<body bgcolor="#DCDCDC">
<table>
<tr>
    <td align="left"><%= lable %>
    </td>
    <td><%=blno%>
    </td>
</tr>
<tr>
    <td></td>
    <td></td>
    <td align="right"><%=lable1%>
    </td>
    <td><%=currency%>
    </td>
</tr>
<tr>
    <td align="left"><%= lable2 %>
    </td>
    <td><%=StringUtils.nullToEmpty(forward)%>
    </td>
    <td align="right"><%= lable3 %>
    </td>
    <td><%= StringUtils.to_Date(shipdt)%>
    </td>
</tr>
<tr>
    <td align="left"><%=lable4%>
    </td>
    <td><%= broker%>
    </td>
</tr>
<tr>
    <td align="left"><%=lable5%>
    </td>
    <td><%=carrier%>
    </td>
</tr>
<tr>
    <td align="left"><%=lable6%>
    </td>
    <td><%=name%>
    </td>
    <td><%= lable7%>
    </td>
    <td><%= StringUtils.to_Date(invdate)%>
    </td>
</tr>
<tr>
</tr>
<tr>
    <td><%=lable8%>
    </td>
    <td><%=gross%>
    </td>
    <td><%= lable9%>
    </td>
    <td><%=net%>
    </td>
    <td><%=lable10%>
    </td>
    <td><%=invamt%>
    </td>
</tr>
<tr>
    <td></td>
    <td></td>
    <td><%=lable11%>
    </td>
    <td><%=prepaid%> CR</td>
</tr>
<tr>
    <td><%=lable18%>
    </td>
    <td><%=frins%>
    </td>
    <td><%=lable12%>
    </td>
    <td><%=collect%>
    </td>
</tr>
<tr>
    <td><%=lable19 %>
    </td>
    <td><%=insurance %>
    </td>
</tr>
<tr>
    <td><%=lable20%>
    </td>
    <td><%=brokerage%>
    </td>
    <td align="right"><%=lable13%>
    </td>
    <td><%= freight%> CR</td>
</tr>
<tr>
    <td><%=lable21%>
    </td>
    <td><%=duty%>
    </td>
    <td><%=lable14%>
    </td>
    <td><%=subtot%>
    </td>
</tr>
<tr>
    <td></td>
    <td><%= totfrduty%>
    </td>
    <td><%=lable15%>
    </td>
    <td><%=invgst%>
    </td>
</tr>
<tr>
    <td></td>
    <td></td>
    <td><%=lable16%>
    </td>
    <td><%=invamt%>
    </td>
</tr>
<tr>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
</tr>
<tr>
    <td></td>
    <td></td>
    <td><%=lable17%>
    </td>
    <td><%=declared%>
    </td>
</tr>

</table>

<input type="button" name="next"
       value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>"
       onClick="javascript:check()"
       style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC;  border-style: outset; border-top-width: 1px; border-right-width: 1px;  border-bottom-width: 1px; border-left-width: 1px"
       border='1'>
<input type="button" name="Cancel"
       value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("CANCEL")%>"
       onClick="javascript:OpenPage('/Blank.jsp?TextToShow=', 'right','');"
       style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC;  border-style: outset; border-top-width: 1px; border-right-width: 1px;  border-bottom-width: 1px; border-left-width: 1px"
       border='1'>
</body>
<%@ include file="/IncludeEnd.jsp" %>