📄 existquery.jsp
字号:
<%--
Created by IntelliJ IDEA.
User: niekun
Date: 2006-10-26
Time: 11:47:56
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, "BillingMatchCarrierInvoices").get("TITLE");
String lable = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable");
String lable1 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable1");
String lable2 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable2");
String lable3 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable3");
String lable4 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable4");
String lable5 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable5");
String lable6 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("Lable6");
String confirm1 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("CONFIRM_1");
String confirm2 = (String) Configure.getConfigure(sIe_Language, "BillingMatchCarrierInvoices").get("CONFIRM_2");
System.out.println("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%" + confirm1);
String account = "";
String subacct = "";
String name = "";
String shadd1 = "";
String shadd2 = "";
String shadd3 = "";
String shadd4 = "";
String carrier = "";
String frins = "";
String CarInvoice = "";
String frwho = "";
String frdate = "";
int fraccpac = 0;
String sql = "select * from invoice where 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"));
frins = rs.getString("frins");
CarInvoice = StringUtils.nullToEmpty(rs.getString("CarInvoice"));
frwho = StringUtils.nullToEmpty(rs.getString("frwho"));
frdate = StringUtils.to_Date(rs.getString("frdate"));
fraccpac = rs.getInt("fraccpac");
}
%>
<html>
<head><title><%=title%>
</title></head>
<script type="text/javascript" src="<%=sResourcesPath%>/keyevent.js"></script>
<script type="text/javascript">
function Che_acc()
{
var fraccpac_js = '<%=fraccpac%>';
var blno = '<%=blno%>';
if (fraccpac_js == 1) {
if (!confirm('<%=confirm1%><%=frwho%><%=frdate%><%=confirm2%>'))
{
OpenPage('/Blank.jsp?TextToShow=please click on right', 'right', '');
return;
}
var carinv = '<%=CarInvoice%>';
var frins = '<%=frins%>';
OpenComp("MatchCarrierInvoices", "/Billing/MatchCarrierInvoices/Do.jsp", "blno=" + blno + "&nchoice=3&frins=" + frins + "&carinv=" + carinv + "&rand=" + randomNumber(), "right", "");
} else {
var frins = '<%=frins%>';
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) {
frins = document.all.txt3.value;
}
var carinv = document.all.txt2.value;
OpenComp("MatchCarrierInvoices", "/Billing/MatchCarrierInvoices/Do.jsp", "blno=" + blno + "&nchoice=" + nchoice + "&frins=" + frins + "&carinv=" + carinv + "&rand=" + randomNumber(), "right", "");
}
}
function Che_acc3()
{
if (document.all.item("txt3").style.display == "none")
{
document.all.item("txt3").style.display = "block";
}
}
</script>
<body class="pagebackground" bgcolor="#DCDCDC">
<table>
<tr>
<td><%= lable + " " + blno%>
</td>
</tr>
<tr>
<td><%=account + "-" + subacct + " " + name%>
</td>
</tr>
<tr>
<td><%=shadd1%>
</td>
</tr>
<tr>
<td><%=shadd2%>
</td>
</tr>
<tr>
<td><%=shadd3%>
</td>
</tr>
<tr>
<td><%=shadd4%>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><%=lable1 + " " + carrier%>
</td>
</tr>
<tr>
<td><%=frins%>
</td>
</tr>
<%if (fraccpac == 1) {%>
<tr>
<td>
<table>
<tr>
<td><%=CarInvoice%>
</td>
</tr>
</table>
</td>
</tr>
<%} else {%>
<tr>
<td>
<table>
<tr>
<td width="640"><%=lable2%>
<input type="text" name="txt2" value="<%=CarInvoice%>" size="10" maxlength="10">
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="1" checked>
</label>
<%=lable3%>
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="2">
</label>
<%=lable4%>
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="3" onClick="Che_acc3()">
</label>
<%=lable5%>
<input type="text" name="txt3" value="0" size="10" maxlength="10" style="display:none" onkeydown="MoneyInput()">
</td>
</tr>
<tr>
<td><label>
<input name="mzcDesc" type="radio" value="4"
onClick="javascript:OpenPage('/Blank.jsp?TextToShow=please click on left', 'right','');">
</label>
<%=lable6%>
</td>
</tr>
</table>
</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 + -