📄 existquery.jsp
字号:
<%--
Created by IntelliJ IDEA.
User: niekun
Date: 2006-10-27
Time: 14:02:47
To change this template use File | Settings | File Templates.
--%>
<%@ include file="/IncludeBeginMD.jsp" %>
<%@ page import="com.hexiesoft.config.language.Configure" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%
String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));
String title = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("TITLE");
String lable = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE");
String lable1 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE1");
String lable2 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE2");
String lable3 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE3");
String lable4 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE4");
String lable5 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE5");
String lable6 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE6");
String lable7 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE7");
String lable8 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE8");
String lable9 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE11");
String confirm1 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE9");
String confirm2 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("LABLE10");
String alert2 = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("ALERT_2");
String country = "";
String account = "";
String subacct = "";
String name = "";
String shadd1 = "";
String shadd2 = "";
String shadd3 = "";
String shadd4 = "";
String carrier = "";
float duty = 0;
float brokerage = 0;
String brokerinv = "";
String frwho = "";
String frdate = "";
float aa = 0;
int dutyaccpac = 0;
String sql = "select * from invoice,customer where invoice.account=customer.account and invoice.subacct=customer.subacct and blno='" + blno + "'";
ASResultSet rs = Sqlca.getASResultSet(sql);
if (rs.next()) {
account = StringUtils.nullToEmpty(rs.getString("account"));
subacct = StringUtils.nullToEmpty(rs.getString("subacct"));
name = StringUtils.nullToEmpty(rs.getString("name"));
shadd1 = StringUtils.nullToEmpty(rs.getString("shadd1"));
shadd2 = StringUtils.nullToEmpty(rs.getString("shadd2"));
shadd3 = StringUtils.nullToEmpty(rs.getString("shadd3"));
shadd4 = StringUtils.nullToEmpty(rs.getString("shadd4"));
carrier = StringUtils.nullToEmpty(rs.getString("carrier"));
country = rs.getString("country");
duty = Float.parseFloat(rs.getString("duty"));
brokerage = Float.parseFloat(rs.getString("brokerage"));
aa = duty + brokerage;
brokerinv = StringUtils.nullToEmpty(rs.getString("brokerinv"));
frwho = StringUtils.nullToEmpty(rs.getString("frwho"));
frdate = StringUtils.to_Date(rs.getString("frdate"));
dutyaccpac = rs.getInt("dutyaccpac");
}
%>
<html>
<head><title><%=title%>
</title></head>
<script type="text/javascript" src="<%=sResourcesPath%>/keyevent.js"></script>
<script type="text/javascript">
function Che_acc()
{
var dutyaccpac_js = '<%=dutyaccpac%>';
var blno = '<%=blno%>';
if (dutyaccpac_js == 1) {
if (!confirm('<%=confirm1%><%=frwho%><%=frdate%><%=confirm2%>'))
{
OpenPage('/Blank.jsp?TextToShow=please click on right', 'right', '');
return;
}
var duty = '<%=duty%>';
var brokerage = '<%=brokerage%>';
var brokerinv = '<%=brokerinv%>';
OpenComp("MatchCarrierInvoices", "/Billing/MatchBrokerInvoices/Do.jsp", "blno=" + blno + "&nchoice=1&brokerage=" + brokerage + "&duty=" + duty + "&brokerinv=" + brokerinv + "&rand=" + randomNumber(), "right", "");
} else {
var duty = '<%=duty%>';
var brokerage = '<%=brokerage%>';
var nchoice;
for (i = 0; i < document.all.mzcDesc.length; i++) {
if (document.all.mzcDesc[i].checked) {
nchoice = document.all.mzcDesc[i].value;
break;
}
}
if (nchoice == 3) {
duty = document.all.duty.value;
brokerage = document.all.brokerage.value;
}
var brokerinv = document.all.brokerinv.value;
OpenComp("MatchCarrierInvoices", "/Billing/MatchBrokerInvoices/Do.jsp", "blno=" + blno + "&nchoice=" + nchoice + "&brokerage=" + brokerage + "&duty=" + duty + "&brokerinv=" + brokerinv + "&rand=" + randomNumber(), "right", "");
}
}
function Che_acc3()
{
if (document.all.item("div1").style.display == "none")
{
document.all.item("div1").style.display = "block";
}
}
</script>
<body class="pagebackground" bgcolor="#DCDCDC">
<table border="0" width=100% align="center" bgcolor="#DCDCDC">
<tr>
<td width="35%" class="black9pt"><%= lable + " " + blno%>
</td>
<td > </td>
</tr>
<tr>
<td class="black9pt"><%=account + "-" + subacct + " " + name%>
</td class="black9pt">
<td class="black9pt"></td>
</tr>
<tr>
<td class="black9pt"><%=shadd1%>
</td>
<td class="black9pt"></td>
</tr>
<tr>
<td class="black9pt"><%=shadd2%>
</td>
<td class="black9pt"></td>
</tr>
<tr>
<td class="black9pt"><%=shadd3%>
</td>
<td class="black9pt"></td>
</tr>
<tr>
<td class="black9pt"><%=shadd4%>
</td>
<td class="black9pt"></td>
</tr>
<tr>
<td class="black9pt"><%=lable1 + " " + carrier%>
</td>
<td rowspan="3" class="black9pt">
<div id="div1" style="display:none">
<table border="0" width=100% align="center" bgcolor="#DCDCDC">
<tr>
<td><%=lable9%>
</td>
</tr>
<tr>
<td><input type="text" name="duty" value="0" size="10" maxlength="10" onkeydown="MoneyInput()">
</td>
</tr>
<tr>
<td>
<input type="text" name="brokerage" value="0" size="10" maxlength="10" onkeydown="MoneyInput()">
</td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="black9pt"><%=lable2+" "+duty%> </td>
</tr>
<tr>
<td class="black9pt"><%=lable3 + " " + brokerage%>
</td>
</tr>
<tr>
<td class="black9pt"><%=" "+aa %></td>
<td class="black9pt">
</td>
</tr>
<%if (dutyaccpac == 1) {%>
<tr>
<td><%=brokerinv%></td>
<td class="black9pt">
</td>
</tr>
<%
} else {
if ("C".equals(country)) {
%>
<script type="text/javascript">
alert('<%=alert2%>');
OpenPage('/Blank.jsp?TextToShow=please click on left', 'right', '');
</script>
<%}%>
<tr>
<td class="black9pt"><%=lable4%>
<input type="text" name="brokerinv" value="<%=brokerinv%>" size="10" maxlength="10">
</td>
<td class="black9pt"> </td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="1" checked>
</label><%=lable5%>
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="2">
</label><%=lable6%>
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="3" onclick="Che_acc3()">
</label><%=lable7%>
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="4"
onClick="javascript:OpenPage('/Blank.jsp?TextToShow=please click on left', 'right','');">
</label><%=lable8%>
</td>
</tr>
<%}%>
<tr>
<TD colspan="2"><input type="button" name="next"
value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>"
onclick="javascript:Che_acc();"
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=please click on left', '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'>
</TD>
</tr>
</table>
</body>
</html>
<%@ include file="/IncludeEnd.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -