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

📄 purchdetail.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="Purch" class="src.wuyang.Purch" 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="PurchProduct" class="src.wuyang.PurchProduct" scope="page"/>
<jsp:useBean id="product" class="src.wuyang.Production" 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>
<%	}
%>

<%
String state[] = {"要求部门经理审核","部门经理通过","采购部登记","高层审核通过","审核不通过","出入库","发票","完成","完成"};
String jsfs[] = {"现金","汇票","转帐"};
String purchId = request.getParameter("purchId");
Purch.load(purchId);
customer.load(Purch.getCustomerId());
%>
<link rel="stylesheet" href="css.css" type="text/css">
<body bgcolor=#949b93><table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top">
      <blockquote><br>
        <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0" class="textb">
                  <tr> 
                    
            <td width="18%" height="19" class="text" bgcolor="#949b93"> 
              <div align="left"><font color="#000000"><b class="text">采购单编号:</b></font></div>
                    </td>
                    
            <td width="32%" height="19" class="textb"> <%=Purch.getPurchId()%>&nbsp; 
            </td>
                    
            <td width="18%" height="19" class="text" bgcolor="#949b93"> 
              <div align="left"><font color="#000000"><b>采购单状态:</b></font></div>
                    </td>
                    
            <td width="32%" height="19" class="textb"> <%=state[Purch.getPurchState()]%>&nbsp;</td>
                  </tr>
                  <tr> 
                    
            <td width="18%" height="17" class="text" bgcolor="#949b93"> 
              <div align="left"><font color="#000000"><b>用途:</b></font></div>
                    </td>
                    
            <td width="32%" height="17" class="textb"> <%=Purch.getUseFor()%></td>
                    
            <td width="18%" height="17" class="text" bgcolor="#949b93"> 
              <div align="left"><font color="#000000"><b>申请金额:</b></font></div>
                    </td>
                    
            <td width="32%" height="17" class="textb"> <%=Purch.doubleFormat(Purch.getAppMoney(),2)%></td>
                  </tr>
                  <tr> 
                    
            <td width="18%" height="8" class="text" bgcolor="#949b93"> 
              <div align="left"><font color="#000000"><b>合同编号:</b></font></div>
                    </td>
                    
            <td width="32%" height="8" class="textb"> <a href="ContractDetail.jsp?contractId=<%=Purch.getContractId()%>"><%=Purch.getContractId()%></a></td>
            <td width="18%" height="8" class="text" bgcolor="#949b93"> 
              <div align="left"><font color="#000000"><b>用款方式:</b></font></div>
                    </td>
                    
            <td width="32%" height="8" class="textb"> <%=jsfs[Purch.getUseWay()]%></td>
                  </tr>
                </table>
        <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr> 
                    
            <td width="18%" height="21" bgcolor="#949b93"> 
              <div align="left"><b class="text">客户名称:</b></div>
                    </td>
                    
            <td width="82%" height="21" class="textb"><%=customer.getCustomerName()%> 
              &nbsp;</td>
          </tr>
        </table>
                <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
                  <tr> 
                    
            <td width="18%" height="20" bgcolor="#949b93"> 
              <div align="left"><b class="text">帐号:</b></div>
                    </td>
                    
            <td width="32%" height="20" class="textb"><%=customer.getBankAccount()%>&nbsp;</td>
                    
            <td width="18%" height="20" bgcolor="#949b93"> 
              <div align="left"><b class="text">用款时间:</b></div>
                    </td>
            <td width="32%" height="20" class="textb"> <%=Purch.getStringDate(Purch.getNeedDate(),0)%>&nbsp;</td>
                  </tr>
                </table>
                <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td width="18%" bgcolor="#949b93" height="19"> 
                      <div align="left"><b class="text">开户银行:</b></div>
                    </td>
                    <td width="82%" height="19" class="textb"><%=customer.getBank()%> &nbsp;
                      </td>
                  </tr>
                </table>
                <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td width="18%" bgcolor="#949b93" class="text"> 
                      <div align="left"><b>预计发货期:</b></div>
                    </td>
                    <td width="32%" class="textb"> <%=Purch.getStringDate(Purch.getPerdictDate(),0)%>&nbsp; 
                    </td>
                    <td width="18%" class="text" bgcolor="#949b93"> 
                      <div align="left"><b>申请人:</b></div>
                    </td>
                    <td width="32%" class="textb"> 
                      <% employee.load(Purch.getProposer());%>
                      <%=employee.getEmpName()%> &nbsp;</td>
                  </tr>
                  <tr> 
                    <td width="18%" bgcolor="#949b93" class="text"> 
                      <div align="left"><b>部门经理:</b></div>
                    </td>
                    <td width="32%" class="textb"> 
                      <% employee.setEmpName("");employee.load(Purch.getDeptManager());%>
                      <%=employee.getEmpName()%> &nbsp;</td>
                    <td width="18%" class="text" bgcolor="#949b93"> 
                      <div align="left"><b>批准人:</b></div>
                    </td>
                    <td width="32%" class="textb"> 
                      <% employee.setEmpName("");employee.load(Purch.getCeoId());%>
                      <%=employee.getEmpName()%> &nbsp;</td>
                  </tr>
                </table>
                <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td width="18%" class="text" bgcolor="#949b93"> 
                      <div align="left"><b>备注:</b></div>
                    </td>
                    <td width="82%" class="textb"><%=Purch.getComment()%> 
                      &nbsp;</td>
                  </tr>
                </table>
        <span class="textb"> 产品列表 <%
	int productNumP=PurchProduct.query("purchId='"+purchId+"'","");
	String flag[] = {"卖","买"};
	String pack[] = {"带包装","净水"};
%> </span> 
        <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr bgcolor="#949b93"> 
            <td class="text"> 
              <div align="center"><b>申请单编号 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品编号 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品名称 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>规格/型号 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产地 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>数量 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>单价 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>包装 </b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>总金额 </b></div>
            </td>
          </tr>
          <%
float totalPrice=0;
PurchProduct.next();
for(int i=0;i<productNumP;i++) 
    {
%>
          <td class="textb"><%=PurchProduct.getPurchId()%>&nbsp;</td>
          <td class="textb"><%=PurchProduct.getProductId()%>&nbsp;</td>
          <%     	product.load(PurchProduct.getProductId());
%>
          <td class="textb"><%=product.getProductName()%>&nbsp;</td>
          <td class="textb"><%=product.getProductDesc()%>&nbsp;</td>
          <td class="textb"><%=PurchProduct.getProductAdd()%>&nbsp;</td>
          <td class="textb" align="right"><%=PurchProduct.doubleFormat(PurchProduct.getQuantity(),2)%></td>
          <td class="textb" align="right"><%=PurchProduct.doubleFormat(PurchProduct.getUnitPrice(),2)%></td>
          <td class="textb"><%=pack[PurchProduct.getPack()]%></td>
          <td class="textb" align="right"> 
            <%   float subPrice=PurchProduct.getUnitPrice()*PurchProduct.getQuantity();
%>
            <%=PurchProduct.doubleFormat(subPrice,2)%></td>
          </tr>
          <%
    PurchProduct.next();
    totalPrice = totalPrice + subPrice;
    }
%>
        </table>
        <span class="textb">总计:<%=PurchProduct.doubleFormat(totalPrice,2)%> </span></blockquote>
    </td>
  </tr>
</table>
</body>

⌨️ 快捷键说明

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