📄 existquery.jsp
字号:
<%@ 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 lTitle = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("Title"); String lWHSEBLNO = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lWHSEBLNO"); String lWAREHOUSE = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lWAREHOUSE"); String lShipDt = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lShipDt"); String lBLNO = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lBLNO"); String lCustomer = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lCustomer"); String lLOT = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lLOT"); String lGROSS = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("lGROSS"); String save = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("save"); String abort = (String) Configure.getConfigure(sIe_Language, "WarehouseShipmentAndInvoice").get("abort"); String Submit = (String) Configure.getConfigure(sIe_Language, "EditVerifyBolAndInvoice").get("Submit"); String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno")); String warehouse = DataConvert.toRealString(iPostChange, CurPage.getParameter("warehouse")).toUpperCase(); String account = DataConvert.toRealString(iPostChange, CurPage.getParameter("account")).toUpperCase(); String subacct = DataConvert.toRealString(iPostChange, CurPage.getParameter("subacct")).toUpperCase(); String shipdt = DataConvert.toRealString(iPostChange, CurPage.getParameter("shipdt")); System.out.println("%%%%%%%" + blno + "&" + warehouse + "%" + account + "&" + account + "&" + subacct + "&&" + shipdt); boolean firsttime = true; String tblno = "NEW "; ASResultSet cus_rs = Sqlca.getASResultSet("select * from customer where account = '" + account + "' and subacct='" + subacct + "'"); cus_rs.next();%><html><head> <title><%=lTitle%> </title></head><script language=javascript> function Checktxt() { var mzpn = ""; var mzpns = new Array(40); for (i = 0; i < 40; i++) { mzpns[i] = document.all.item("mzpn[" + i + "]").value; mzpn = mzpn + mzpns[i] + "|"; } var account = '<%=account%>'; var subacct = '<%=subacct%>'; var invbin = '<%=warehouse%>'; var rrValue = PopPage("/Billing/WarehouseShipmentAndInvoice/CheckArrayTxt.jsp?mzpn=" + mzpn + "&invbin=" + invbin + "&subacct=" + subacct + "&account=" + account + "&rand=" + randomNumber(), "right", ""); var myarray = rrValue.toString().split("|"); document.all.gross.value = myarray[1]; document.all.net.value = myarray[2]; if (myarray[0] != "") { alert(myarray[0]); document.all.item("mzpn[0]").focus(); return; } if (myarray[0] == "") { if (document.all.item("dialog").style.display == "none") { document.all.item("dialog").style.display = "block"; } } } function saves() { var gblno; if ("<%=firsttime%>" == "true") { var returnValue = PopPage("/Billing/WarehouseShipmentAndInvoice/SaveGlobal.jsp?rand=" + randomNumber(), "right", ""); alert("Bill of Lading is:" + returnValue.toString().substring(0, 6)); gblno = returnValue.toString().substring(0, 6); } var mzpn = ""; var mzpns = new Array(40); for (var i = 0; i < 40; i++) { mzpns[i] = document.all.item("mzpn[" + i + "]").value; mzpn = mzpn + mzpns[i] + "|"; } var account = '<%=account%>'; var ShipDt = '<%=shipdt%>'; var add1 = '<%=cus_rs.getString("bladd1")%>'; var add2 = '<%=cus_rs.getString("bladd2")%>'; var whblno = '<%=blno%>'; var name = '<%=cus_rs.getString("name")%>'; var subacct = '<%=subacct%>'; var returnVr = PopPage("/Billing/WarehouseShipmentAndInvoice/Save.jsp?mzpn=" + mzpn + "&gblno=" + gblno + "&add2=" + add2 + "&add1=" + add1 + "&account=" + account + "&subacct=" + subacct + "&name=" + name + "&whblno=" + whblno + "&ShipDt=" + ShipDt + "&rand=" + randomNumber(), "right", ""); if (returnVr = "ok") { alert("success!"); OpenPage('/Blank.jsp?TextToShow=', '_self', ''); } }</script><body bgcolor="#DCDCDC"><table> <tr> <td align=left><%=lWHSEBLNO%> </td> <td><%=blno%> </td> </tr> <tr> <td><%=lWAREHOUSE%> </td> <td><%=warehouse%> </td> </tr></table><table> <tr> <td align=left><%=lShipDt%> </td> <% ASResultSet wh_rs = Sqlca.getASResultSet("select * from whouse where wcode = '" + warehouse + "' "); wh_rs.next(); %> <td><%=shipdt%> </td> <td><%=wh_rs.getString("wname")%> </td> </tr> <tr> <td align=left><%=lBLNO%> </td> <td><%=tblno%> </td> </tr> <tr> <td align=left valign=top><%=lCustomer%> </td> <td valign=top><%=account + "-" + subacct%> </td> <td> <table> <tr> <td><%= StringUtils.nullToEmpty(cus_rs.getString("name"))%> </td> </tr> <tr> <td><%= StringUtils.nullToEmpty(cus_rs.getString("bladd1"))%> </td> </tr> <tr> <td><%= StringUtils.nullToEmpty(cus_rs.getString("bladd2"))%> </td> </tr> <tr> <td><%= StringUtils.nullToEmpty(cus_rs.getString("shcity")) + "," + StringUtils.nullToEmpty(cus_rs.getString("shprovst")) + "," + StringUtils.nullToEmpty(cus_rs.getString("shcountry"))%> </td> </tr> <tr> <td align=left>Gross:<input name=gross type=text readOnly size=20>Net: <input name=net type=text readOnly size=20></td> </tr> <tr> </tr> </table> </td> </tr></table><table><tr> <td><%=lLOT%> </td> <td><%=lGROSS%> </td> <td><%=lLOT%> </td> <td><%=lGROSS%> </td> <td><%=lLOT%> </td> <td><%=lGROSS%> </td> <td><%=lLOT%> </td> <td><%=lGROSS%> </td> <td><%=lLOT%> </td> <td><%=lGROSS%> </td></tr><tr> <td><input name=mzpn[0] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[8] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[16] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[24] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[32] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[1] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[9] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[17] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[25] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[33] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[2] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[10] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[18] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[26] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[34] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[3] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[11] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[19] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[27] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[35] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[4] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[12] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[20] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[28] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[36] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[5] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[13] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[21] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[29] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[37] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[6] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[14] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[22] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[30] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[38] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <td><input name=mzpn[7] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[15] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[23] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[31] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td> <td></td> <td><input name=mzpn[39] type=text size=10 maxlength=10 onKeyPress="javascript:if(isNaN(this.value)){this.value =''}"></td></tr><tr> <TD> <input type="button" value="<%=Submit%>" onClick="Checktxt()" 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><div id=dialog style="display:none"> <table> <tr> <TD colspan="2"><input type="button" name="next" value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>" onclick="javascript:saves()" 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'> </TD> </tr> </table></div></body></html><%@ include file="/IncludeEnd.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -