📄 exsitquery.jsp
字号:
<%--
Created by IntelliJ IDEA.
User: niekun
Date: 2006-11-1
Time: 13:33:04
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, "BillinginquiryBOL").get("Title");
String lable = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table");
String lable1 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table1");
String lable2 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table2");
String lable3 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table3");
String lable4 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table4");
String lable5 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table5");
String lable6 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table6");
String lable7 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table7");
String lable8 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table8");
String lable9 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table9");
String lable10 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table10");
String lable11 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table11");
String lable12 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table12");
String lable13 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table13");
String lable14 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table14");
String lable15 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table15");
String lable16 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table16");
String lable17 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table17");
String lable18 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table18");
String lable19 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table19");
String lable20 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table20");
String lable21 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table21");
String lable22 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table22");
String lable23 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table23");
String lable24 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table24");
String lable25 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table25");
String lable26 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table26");
String lable27 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table27");
String lable28 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table28");
String lable29 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table29");
String lable30 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table30");
String lable31 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table31");
String lable32 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table32");
String lable33 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table33");
String lable34 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table34");
String lable35 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table35");
String lable36 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table36");
String lable37 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table37");
String lable38 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table38");
String lable39 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table39");
String lable40 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table40");
String lable41 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table41");
String lable42 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table42");
String lable43 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table43");
String lable44 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table44");
String lable45 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table45");
String lable46 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table46");
String lable47 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table47");
String lable48 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table48");
String lable49 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table49");
String lable50 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table50");
String lable51 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table51");
String lable52 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table52");
String lable53 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table53");
String lable54 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table54");
String lable55 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table55");
String lable56 = (String) Configure.getConfigure(sIe_Language, "BillinginquiryBOL").get("Table56");
String blno1 = "";
String account = "";
String subacct = "";
String currency = "";
String country = "";
String pricelist = "";
String invdate = "";
String forward = "";
String broker = "";
String carrier = "";
String name = "";
String invoiceby = "";
String verifyby = "";
String route = "";
String bladd1 = "";
String bladd2 = "";
String bladd3 = "";
String bladd4 = "";
String shadd1 = "";
String shadd2 = "";
String shadd3 = "";
String shadd4 = "";
String gross = "";
String invextend = "";
String prepaid = "";
String collect = "";
String net = "";
String otherfees = "";
String sundry = "";
String freight = "";
String fsurrate = "";
String fsurcharge = "";
String subtot = "";
String invgst = "";
String invamt = "";
String frins = "";
String insurance = "";
String declarins = "";
String brokerage = "";
String duty = "";
float totfrduty = 0f;
int isimperial = 0;
int lbs=0;
String tsundry = "";
String totherfees = "";
System.out.println("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%" + lable44);
String sql = "select * FROM invoice LEFT OUTER JOIN customer ON invoice.account+invoice.subacct= customer.account+customer.subacct WHERE invoice.blno='" + blno + "'";
ASResultSet rs = Sqlca.getASResultSet(sql);
if (rs.next()) {
blno1 = StringUtils.nullToEmpty(rs.getString("blno"));
account = StringUtils.nullToEmpty(rs.getString("account"));
subacct = StringUtils.nullToEmpty(rs.getString("subacct"));
currency = StringUtils.nullToEmpty(rs.getString("currency"));
country = StringUtils.nullToEmpty(rs.getString("country"));
pricelist = StringUtils.nullToEmpty(rs.getString("pricelist"));
invdate = StringUtils.nullToEmpty(rs.getString("invdate"));
forward = StringUtils.nullToEmpty(rs.getString("forward"));
broker = StringUtils.nullToEmpty(rs.getString("broker"));
carrier = StringUtils.nullToEmpty(rs.getString("carrier"));
isimperial = rs.getInt("isimperial");
name = StringUtils.nullToEmpty(rs.getString("name"));
invoiceby = StringUtils.nullToEmpty(rs.getString("invoiceby"));
verifyby = StringUtils.nullToEmpty(rs.getString("verifyby"));
route = StringUtils.nullToEmpty(rs.getString("route"));
bladd1 = StringUtils.nullToEmpty(rs.getString("bladd1"));
bladd2 = StringUtils.nullToEmpty(rs.getString("bladd2"));
bladd3 = StringUtils.nullToEmpty(rs.getString("bladd3"));
bladd4 = StringUtils.nullToEmpty(rs.getString("bladd4"));
shadd1 = StringUtils.nullToEmpty(rs.getString("shadd1"));
shadd2 = StringUtils.nullToEmpty(rs.getString("shadd2"));
shadd3 = StringUtils.nullToEmpty(rs.getString("shadd3"));
shadd4 = StringUtils.nullToEmpty(rs.getString("shadd4"));
gross = rs.getString("gross");
invextend = rs.getString("invextend");
prepaid = rs.getString("prepaid");
collect = rs.getString("collect");
net = rs.getString("net");
otherfees = rs.getString("otherfees");
totherfees = otherfees;
sundry = rs.getString("sundry");
tsundry = sundry;
freight = rs.getString("freight");
fsurrate = rs.getString("fsurrate");
fsurcharge = rs.getString("fsurcharge");
subtot = rs.getString("subtot");
invgst = rs.getString("invgst");
invamt = rs.getString("invamt");
frins = rs.getString("frins");
insurance = rs.getString("insurance");
declarins = rs.getString("declarins");
brokerage = rs.getString("brokerage");
duty = rs.getString("duty");
totfrduty = Float.parseFloat(frins) + Float.parseFloat(insurance) + Float.parseFloat(brokerage) + Float.parseFloat(duty);
}
%>
<html>
<head><title><%=title%>
</title></head>
<body class="pagebackground" bgcolor="#DCDCDC">
<table border="0" width=100% align="center" bgcolor="#DCDCDC">
<tr>
<td width="16%"><%= lable %>
</td>
<td width="39%"><%=blno1%>
</td>
<td width="24%"> </td>
<td width="21%"> </td>
</tr>
<tr>
<td class="black9pt"><%=lable1%>
</td>
<td class="black9pt"><%=account%>-<%=subacct%>
</td>
<td class="black9pt"><%= lable2 %>
</td>
<td class="black9pt"><%=currency%>
</td>
</tr>
<tr>
<td class="black9pt"><%= lable3 %>
</td>
<td class="black9pt"><%=forward%>
</td>
<td class="black9pt"><%= lable4 %>
</td>
<td class="black9pt"><%=StringUtils.to_Date(invdate)%>
</td>
</tr>
<tr>
<td class="black9pt"><%= lable5 %>
</td>
<td class="black9pt"><%=broker%>
</td>
<td class="black9pt"><%= lable6 %>
</td>
<td class="black9pt"><%=country%>
</td>
</tr>
<tr>
<td class="black9pt"><%= lable7 %>
</td>
<td class="black9pt"><%=carrier%>
</td>
<td class="black9pt"><%= lable8 %>
</td>
<td class="black9pt"><%=pricelist%>
</td>
</tr>
<tr>
<td class="black9pt"><%= lable9 %>
</td>
<td class="black9pt"><%=name%>
</td>
<td class="black9pt"><%= lable10%>
</td>
<td class="black9pt"><%=StringUtils.to_Date(invdate)%>
</td>
</tr>
<tr>
<td class="black9pt"><%= lable11 %>
</td>
<td><%=invoiceby%>
</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td class="black9pt"><%= lable12 %>
</td>
<td><%=verifyby%>
</td>
<td class="black9pt"><%= lable13 %>
</td>
<td><%=route%>
</td>
</tr>
<tr>
<td class="black9pt"><%= lable14 %>
</td>
<td> </td>
<td class="black9pt"><%= lable15 %>
</td>
<td> </td>
</tr>
<tr>
<td class="black9pt"><%= bladd1 %>
</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td class="black9pt"><%= bladd2 %>
</td>
<td> </td>
<td class="black9pt"><%= shadd1 %>
</td>
<td> </td>
</tr>
<tr>
<td class="black9pt"><%= bladd3 %>
</td>
<td> </td>
<td class="black9pt"><%= shadd2 %>
</td>
<td> </td>
</tr>
<tr>
<td class="black9pt"><%= bladd4 %>
</td>
<td> </td>
<td class="black9pt"><%= shadd3 %>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><%=shadd4%>
</td>
<td> </td>
</tr>
<tr>
<td colspan="4">
<hr>
</td>
</tr>
</table>
<%
sql = "select * from shipment,ord_item where shipment.worksno=ord_item.worksno and shipment.blno='" + blno + "'";
ASResultSet shRs = Sqlca.getASResultSet(sql);
while (shRs.next()) {
lbs=shRs.getInt("islbs");
if ("XXXX".equals(pricelist)) {%>
<table border="0" width=100% align="center" bgcolor="#DCDCDC">
<tr>
<td width="13%" class="black9pt">
<div align="right"><%=lable16%>
</div>
</td>
<td width="13%"><%=shRs.getString("worksno")%>
</td>
<td width="12%" class="black9pt"><%=lable17%>
</td>
<td width="15%" class="black9pt"><%=StringUtils.nullToEmpty(shRs.getString("custpo"))%>
</td>
<td colspan="2" class="black9pt">
<div align="center"><%=StringUtils.nullToEmpty(shRs.getString("desc"))%>
</div>
</td>
</tr>
<tr>
<td>
<div align="right"><span class="black9pt"><%=lable18%></span></div>
</td>
<td><%=StringUtils.nullToEmpty(shRs.getString("coils"))%>
</td>
<td><span class="black9pt"><%=lable19%></span></td>
<td><%=StringUtils.nullToEmpty(shRs.getString("contract"))%>
</td>
<td width="28%">
<div align="right"><%if (isimperial == 0) {%><%=StringUtils.nullToEmpty(shRs.getString("mt_width"))%><%}%></div>
</td>
<td width="19%"><%if (isimperial == 0) {%><%=StringUtils.nullToEmpty(shRs.getString("mt_gauge"))%><%}%></td>
</tr>
<tr>
<td class="black9pt">
<div align="right"><%=lable20%>
</div>
</td>
<td><%=StringUtils.nullToEmpty(shRs.getString("notes"))%>
</td>
<td class="black9pt"><%=lable21%>
</td>
<td class="black9pt"><%=StringUtils.nullToEmpty(shRs.getString("custprod"))%>
</td>
<td>
<div align="right"><span class="black9pt"><%=lable26%></span></div>
</td>
<td><%=shRs.getFloat("fabpr")%>
</td>
</tr>
<tr>
<td class="black9pt">
<div align="right"><%=lable23%>
</div>
</td>
<td><%=shRs.getFloat("net")%><%if (shRs.getInt("islbs") == 1) {%>lbs<%} else {%>kgs<%}%></td>
<td class="black9pt"><%=lable22%>
</td>
<td class="black9pt"><%=StringUtils.nullToEmpty(shRs.getString("custspec"))%>
</td>
<td>
<div align="right"><span class="black9pt"><%=lable27%></span></div>
</td>
<td><%=shRs.getFloat("metalpr")%>
</td>
</tr>
<tr>
<td class="black9pt">
<div align="right"><%=lable24%>
</div>
</td>
<td><%=shRs.getFloat("loaded") * (-1)%>
</td>
<td class="black9pt"> </td>
<td class="black9pt"> </td>
<td>
<div align="right"><span class="black9pt"><%=lable28%></span></div>
</td>
<td><%=shRs.getFloat("premiumpr")%>
</td>
</tr>
<tr>
<td class="black9pt"> </td>
<td> </td>
<td class="black9pt"> </td>
<td class="black9pt"> </td>
<td>
<div align="right"><span class="black9pt"><%=lable29%></span></div>
</td>
<td><%=shRs.getFloat("tinningpr")%>
</td>
</tr>
<tr>
<td class="black9pt"> </td>
<td class="black9pt"> </td>
<td class="black9pt"> </td>
<td class="black9pt"> </td>
<td>
<div align="right"><span class="black9pt"><%=lable30%></span></div>
</td>
<td><%=shRs.getFloat("unitdutypr")%>
</td>
</tr>
<tr>
<td class="black9pt"> </td>
<td> </td>
<td bgcolor="#DCDCDC"> </td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -