⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 customsdocdetail.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="customsdoc" class="src.wuyang.CustomsDoc" scope="page"/>
<jsp:useBean id="contract" class="src.wuyang.ImportContract" scope="page"/>
<jsp:useBean id="company" class="src.wuyang.Company" scope="page"/>
<jsp:useBean id="moneyflag" class="src.wuyang.MoneyFlag" scope="page"/>
<jsp:useBean id="customer" class="src.wuyang.Customer" scope="page"/>
<jsp:useBean id="employee" class="src.wuyang.Employee" scope="page"/>
<jsp:useBean id="product" class="src.wuyang.Production" scope="page"/>
<jsp:useBean id="account" class="src.wuyang.CompanyAccount" scope="page"/>
<jsp:useBean id="importproduct" class="src.wuyang.ImportProduct" scope="page"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>

<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<%	}
%>


<html>
<head>
<title></title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<%
	String commitDocId=request.getParameter("commitDocId");
	customsdoc.load(commitDocId);
	company.load(customsdoc.getCompanyId());
	contract.load(customsdoc.getContractId());
     	moneyflag.load(contract.getMoneyFlag());
	customer.load(customsdoc.getCommitedComId());
	employee.load(customsdoc.getEmployeeId());
	account.query("companyId='"+customsdoc.getCompanyId()+"' and bankAccount='"+customsdoc.getAccountId()+"'","");
	account.next();
	String trade;
	String drawback;
	if (customsdoc.getTradeCharacter()==0)
		trade="一般";
	else
		trade="其他";
	if (customsdoc.getIsDrawback()==0)
		drawback="否";
	else
		drawback="是";
%>



<body bgcolor="#949B93" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" height="90%" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" >
  <tr> 
    <td valign="top" > <br><br><blockquote>
	    <p align="center"><b class="textb">进出口货物代理报关委托</b></p>
        <table width="233" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" >
          <tr> 
            <td class="text" bgcolor="#949b93" width="29%"><b>编号: </b></td>
            <td class="textb" width="71%"><%=customsdoc.getCommitDocId() %></td>
          </tr>
        </table>
        <p>&nbsp;</p>
        <table  border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" width="469" >
          <tr> 
            <td width="15%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>委托单位</b></div>
            </td>
            <td width="35%" class="textb"><%=company.getCompanyName()%></td>
            <td width="14%" bgcolor="#949b93" class="text"><b>十位编码</b></td>
            <td width="36%" class="textb"><%=company.getCompanyId()%></td>
          </tr>
          <tr> 
            <td width="15%" bgcolor="#949b93" class="text" height="22"> 
              <div align="left"><b>地址</b></div>
            </td>
            <td width="35%" height="22" class="textb"><%=company.getAddress()%></td>
            <td width="14%" bgcolor="#949b93" class="text" height="22"><b>联系电话</b></td>
            <td width="36%" height="22" class="textb"><%=company.getTel()%></td>
          </tr>
          <tr> 
            <td width="15%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>经办人</b></div>
            </td>
            <td width="35%" class="textb"><%=employee.getEmpName()%></td>
            <td width="14%" bgcolor="#949b93" class="text"><b>身份证号</b></td>
            <td width="36%" class="textb"><%=employee.getEmpIdNumber()%></td>
          </tr>
          <tr> 
            <td width="15%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>合同编号</b></div>
            </td>
            <td width="35%" class="textb"><%=contract.getContractId() %></td>
            <td width="14%" bgcolor="#949b93" class="text"><b>币制</b></td>
            <td width="36%" class="textb"><%=moneyflag.getMoneyFlagDesc()%></td>
          </tr>
        </table>
        <p>&nbsp;</p>
        <table width="470" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" bgcolor="#4c7171" >
          <%
	int productNum=importproduct.query("contractId='"+contract.getContractId()+"'","");
	importproduct.next();
	for(int i=0;i<productNum;i++) 
	    {
		product.load(importproduct.getProductId());
		float subPrice=importproduct.getUnitPrice()*importproduct.getQuantity();
%>
          <tr> 
            <td width="15%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>货物名称</b></div>
            </td>
            <td width="21%" class="textb"><%=product.getProductName()%></td>
            <td width="14%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>商品编号</b></div>
            </td>
            <td width="17%" class="textb"><%=importproduct.getProductId()%></td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>件数</b></div>
            </td>
            <td width="20%" class="textb"><%=importproduct.getCustomsNum()%></td>
          </tr>
          <tr> 
            <td width="15%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>重量</b></div>
            </td>
            <td width="21%" class="textb"><%=importproduct.getQuantity()%></td>
            <td width="14%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>价值</b></div>
            </td>
            <td width="17%" class="textb"><%=subPrice%></td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>货物产地</b></div>
            </td>
            <td width="20%" class="textb"><%=product.getProductAddress()%></td>
          </tr>
          <%
    importproduct.next();
	    }
%>
        </table>
<p>&nbsp;</p>
        <table border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" bgcolor="#4c7171" width="495" >
          <tr> 
            <td width="11%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>贸易性质</b></div>
            </td>
            <td width="20%" class="textb"><%=trade%></td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>是否退税</b></div>
            </td>
            <td width="17%" class="textb"><%=drawback%></td>
            <td width="14%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>航名/航次</b></div>
            </td>
            <td width="25%" class="textb"><%=customsdoc.getFlight()%></td>
          </tr>
        </table>
        <p>&nbsp;</p>
        <table border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" width="446" >
          <tr> 
            <td width="25%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>委托单位开户银行</b></div>
            </td>
            <td width="44%" class="textb"><%=account.getBank()%></td>
            <td width="11%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>帐号</b></div>
            </td>
            <td width="20%" class="textb"><%=customsdoc.getAccountId()%></td>
          </tr>
        </table>
<p>&nbsp;</p>
        <table width="448" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" >
          <tr> 
            <td width="42%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>随附单证名称、份数及编号:</b></div>
            </td>
            <td width="58%" class="textb">&nbsp;</td>
          </tr>
        </table>
<p>&nbsp;</p>
        <table border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" width="492" >
          <tr> 
            <td width="3%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>1.</b></div>
            </td>
            <td width="12%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>合同</b></div>
            </td>
            <td width="9%" class="textb"> 
              <div align="right"><%=customsdoc.getContractNum()%> 份</div>
            </td>
            <td width="7%" class="textb"><b></b></td>
            <td width="19%" class="textb">&nbsp;</td>
            <td width="4%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>6.</b></div>
            </td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>机电证明</b></div>
            </td>
            <td width="7%" class="textb"> 
              <div align="right"><%=customsdoc.getProvementNum()%> 份</div>
            </td>
            <td width="8%" class="textb"><b>编号</b></td>
            <td width="18%" class="textb"><%=contract.getProvementId()%></td>
          </tr>
          <tr> 
            <td width="3%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>2.</b></div>
            </td>
            <td width="12%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>发票</b></div>
            </td>
            <td width="9%" class="textb"> 
              <div align="right"><%=customsdoc.getInvoiceNum()%> 份</div>
            </td>
            <td width="7%" class="textb"><b></b></td>
            <td width="19%" class="textb">&nbsp;</td>
            <td width="4%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>7.</b></div>
            </td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>商检证</b></div>
            </td>
            <td width="7%" class="textb"> 
              <div align="right"><%=customsdoc.getCheckDocNum()%> 份</div>
            </td>
            <td width="8%" class="textb"><b></b></td>
            <td width="18%" class="textb">&nbsp;</td>
          </tr>
          <tr> 
            <td width="3%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>3.</b></div>
            </td>
            <td width="12%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>装箱清单</b></div>
            </td>
            <td width="9%" class="textb"> 
              <div align="right"><%=customsdoc.getIncaseNum()%> 份</div>
            </td>
            <td width="7%" class="textb"><b></b></td>
            <td width="19%" class="textb">&nbsp;</td>
            <td width="4%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>8.</b></div>
            </td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b></b></div>
            </td>
            <td width="7%" class="textb"> 
              <div align="right">&nbsp;</div>
            </td>
            <td width="8%" class="textb"><b></b></td>
            <td width="18%" class="textb">&nbsp;</td>
          </tr>
          <tr> 
            <td width="3%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>4.</b></div>
            </td>
            <td width="12%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>登记手册</b></div>
            </td>
            <td width="9%" class="textb"> 
              <div align="right"><%=customsdoc.getLiberNum()%> 本</div>
            </td>
            <td width="7%" class="textb"><b>编号</b></td>
            <td width="19%" class="textb"><%=contract.getLiberId()%></td>
            <td width="4%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>9.</b></div>
            </td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b></b></div>
            </td>
            <td width="7%" class="textb"> 
              <div align="right">&nbsp;</div>
            </td>
            <td width="8%" class="textb"><b></b></td>
            <td width="18%" class="textb">&nbsp;</td>
          </tr>
          <tr> 
            <td width="3%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>5.</b></div>
            </td>
            <td width="12%" bgcolor="#949b93" class="text"> 
              <div align="left"><b>许可证</b></div>
            </td>
            <td width="9%" class="textb"> 
              <div align="right"><%=customsdoc.getLinenceNum()%> 份</div>
            </td>
            <td width="7%" class="textb"><b>编号</b></td>
            <td width="19%" class="textb"><%=contract.getLiceniceId()%></td>
            <td width="4%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>10.</b></div>
            </td>
            <td width="13%" class="text" bgcolor="#949b93"> 
              <div align="left"><b></b></div>
            </td>
            <td width="7%" class="textb"> 
              <div align="right">&nbsp;</div>
            </td>
            <td width="8%" class="textb"><b></b></td>
            <td width="18%" class="textb">&nbsp;</td>
          </tr>
        </table>
<p>&nbsp;</p>
        <table width="477" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#CCCCCC" >
          <tr> 
            <td width="15%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>被委托单位</b></div>
            </td>
            <td width="35%" class="textb"><%=customer.getCustomerName()%></td>
            <td width="14%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>十位编码</b></div>
            </td>
            <td width="36%" class="textb"><%=customer.getCustomerId()%></td>
          </tr>
          <tr> 
            <td width="15%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>地址</b></div>
            </td>
            <td width="35%" class="textb"><%=customer.getAddress()%></td>
            <td width="14%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>联系电话</b></div>
            </td>
            <td width="36%" class="textb"><%=customer.getTelephone()%></td>
          </tr>
          <tr> 
            <td width="15%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>经办人</b></div>
            </td>
            <td width="35%" class="textb"><%=customsdoc.getCommitedAccountId()%></td>
            <td width="14%" class="text" bgcolor="#949b93"> 
              <div align="left"><b>身份证号</b></div>
            </td>
            <td width="36%" class="textb"><%=customsdoc.getCommitedIdNum()%></td>
          </tr>
        </table>
      </blockquote>
</td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -