📄 editaddbol.jsp
字号:
<%@ page contentType="text/html; charset=GBK"%>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
String sTitle = (String)Configure.getConfigure(sIe_Language, "AddBol").get("Title");
String vBol = DataConvert.toRealString(iPostChange,(String)request.getParameter("Bol"));
String vCurrency = DataConvert.toRealString(iPostChange,(String)request.getParameter("Currency"));
String vFrghtFrwd = DataConvert.toRealString(iPostChange,(String)request.getParameter("FrghtFrwd"));
String vShipDate = DataConvert.toRealString(iPostChange,(String)request.getParameter("ShipDate"));
String vBroker = DataConvert.toRealString(iPostChange,(String)request.getParameter("Broker"));
String vCountry = DataConvert.toRealString(iPostChange,(String)request.getParameter("Country"));
String vCarrier = DataConvert.toRealString(iPostChange,(String)request.getParameter("Carrier"));
String vPriceList = DataConvert.toRealString(iPostChange,(String)request.getParameter("PriceList"));
String vCustomer = DataConvert.toRealString(iPostChange,(String)request.getParameter("Customer"));
String vInvoiceDate = DataConvert.toRealString(iPostChange,(String)request.getParameter("InvoiceDate"));
String vRoute = DataConvert.toRealString(iPostChange,(String)request.getParameter("Route"));
String vInvoiceTo = DataConvert.toRealString(iPostChange,(String)request.getParameter("InvoiceTo"));
String vShipto = DataConvert.toRealString(iPostChange,(String)request.getParameter("Shipto"));
String sExitPoint = DataConvert.toRealString(iPostChange,(String)request.getParameter("ExitPoint"));
String sExitFreight = DataConvert.toRealString(iPostChange,(String)request.getParameter("ExitFreight"));
%>
<html>
<head>
<title><%=sTitle%></title>
</head>
<body bgcolor="#DCDCDC">
<br>
<table border="1" width=100% align="center" bordercolor='#999999' bordercolordark='#FFFFFF'>
<form name="AccountForm" >
</form>
</table>
<%
ASResultSet rs = null;
String m_shadd1="";
String m_shadd2="";
String m_shadd3="";
String m_shadd4="";
int edit=0;
String m_frght="";
String m_broker="";
String m_carrier="";
String m_invdate="";
String m_name="";
String m_bladd1="";
String m_bladd2="";
String m_bladd3="";
String m_bladd4="";
String m_currency="";
String m_country ="";
String m_pricelist="";
String m_route=""; //m_country
String sql="select ordertype,account,subacct,add1,add2,shipdt from "+
" shipment " +
" where blno ="+vBol +
" order by custpo,worksno";
rs=Sqlca.getASResultSet(sql);
if (rs != null && rs.next())
{
if(!rs.getString("ordertype").equals("REG"))
{
ASResultSet rsCustomer1=Sqlca.getASResultSet("select name from customer" +
" where account="+rs.getString("account")+
" and subacct="+rs.getString("subacct"));
if(rsCustomer1.next() )
{
m_name=rsCustomer1.getString("name");
}
}
m_shadd1=rs.getString("add1") ;
m_shadd2=rs.getString("add2");
ASResultSet rsCustomer=Sqlca.getASResultSet("select top 1 s.shipdt ,c.country ,c.bladd1 ," +
" c.bladd2 ,c.blcity,c.blprovst,c.blcountry,c.blpcode,c.CURRENCY,c.pricelist,c.route from " +
" shipment s left join customer c" +
" on s.account=c.account and s.subacct=c.subacct"+
" where account="+rs.getString("account")+
" and subacct="+rs.getString("subacct"));
if(rsCustomer.next() )
{
m_invdate=rsCustomer.getString("shipdt");
if(vShipDate.compareTo(m_invdate)<0 )
{
%>
<script type="text/javascript">
sBol=document.all.Bol.value;
sCurrency=document.all.Currency.value;
sFrghtFrwd=document.all.FrghtFrwd.value;
sBroker=document.all.Broker.value;
sCountry=document.all.Country.value;
sCarrier=document.all.Carrier.value;
sPriceList=document.all.PriceList.value;
sCustomer=document.all.Customer.value;
sInvoiceDate=document.all.InvoiceDate.value;
sRoute=document.all.Route.value;
sInvoiceTo=document.all.InvoiceTo.value;
sShipto=document.all.Shipto.value;
alert("Invoice date can not be earlier than ship date!");
OpenComp("ExistBol", "/Billing/addBol/addBol.jsp", "Bol=" + sBol
+"&Currency="+ sCurrency
+"&FrghtFrwd="+ sFrghtFrwd
+"&Broker="+ sBroker
+"&Country="+ sCountry
+"&Carrier="+ sCarrier
+"&PriceList="+ sPriceList
+"&Customer="+ sCustomer
+"&InvoiceDate="+ sInvoiceDate
+"&Route="+ sRoute
+"&InvoiceTo="+ sInvoiceTo
+"&Shipto="+ sShipto
+ "&rand=" + randomNumber(), "right", "");
</script>
<%
}
if("UO".indexOf(rsCustomer.getString("country"))>0)
{
m_broker="PBB GROUP";
}
if("O".indexOf(rsCustomer.getString("country"))>0)
{
%>
<tr>
<td nowarp align="right" class="black9pt" bgcolor="#D8D8AF" ><%=sExitPoint%></td>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="ExitPoint" size="40"></input> </td>
<td nowarp align="right" class="black9pt" bgcolor="#D8D8AF" ><%=sExitFreight%></td>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="ExitFreight" size="40"></input> </td>
</tr>
<%
}
}
if(rsCustomer.next() )
{
m_bladd1=rsCustomer.getString("bladd1");
m_bladd2=rsCustomer.getString("bladd2");
m_bladd3=rsCustomer.getString("blcity").trim() +","+rsCustomer.getString("blprovst");
m_bladd4=rsCustomer.getString("blcountry") +","+rsCustomer.getString("blpcode");
m_currency=rsCustomer.getString("CURRENCY") ;
m_country =rsCustomer.getString("country");
m_pricelist=rsCustomer.getString("pricelist");
if(m_country.equals("O"))
{
m_route="SHIP"; //+ rsCustomer.getString("route").length() -4
}
else
{
m_route= rsCustomer.getString("route") ;
}
}
// m_invdate
%>
<tr>
<td nowarp align="right" class="black9pt" bgcolor="#D8D8AF" ><%=m_currency%></td>
</tr>
<tr>
<td nowarp align="right" class="black9pt" bgcolor="#D8D8AF" ><%=m_country%></td>
</tr>
<tr>
<td nowarp align="right" class="black9pt" bgcolor="#D8D8AF" ><%=m_pricelist%></td>
</tr>
<tr>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="route" size="40"></input> </td>
</tr>
<tr>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="bladd1" size="40"></input> </td>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="shadd1" size="40"></input> </td>
</tr>
<tr>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="bladd2" size="40"></input> </td>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="shadd2" size="40"></input> </td>
</tr>
<tr>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="bladd3" size="40"></input> </td>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="shadd3" size="40"></input> </td>
</tr>
<tr>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="bladd4" size="40"></input> </td>
<td nowarp bgcolor="#F0F1DE" ><input type="text" name="shadd4" size="40"></input> </td>
</tr>
<%
}
%>
<form name="">
</form>
</body>
</html>
<%@ include file="/IncludeEnd.jsp"%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -