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

📄 insertimportproduct.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="importcontract" class="src.wuyang.ImportContract" scope="page"/>
<jsp:useBean id="account" class="src.wuyang.Account" scope="page"/>
<jsp:useBean id="importproduct" class="src.wuyang.ImportProduct" 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 contractId;%> 
<%! int productNum;%>
<%
	contractId = request.getParameter("contractId");

	importcontract.load(contractId);
	account.load(global.loginName);
	if((account.getEmployeeId()).equals(importcontract.getProposer()) == false)
		{
%>
		<jsp:forward page="UpdateImportProduct.jsp" > 
			<jsp:param name="errorName" value="无权限修改" />
			<jsp:param name="contractId" value="" />
		</jsp:forward>
<%		}

	productNum=importproduct.query("contractId='"+contractId+"'","");
%>

<html>
<head>
<link rel="stylesheet" href="../pub/style.css">
<script language ="javascript" src='../pub/pub.js' type=text/javascript></script>
</head>
<body>

<script language="JavaScript">
function VerifyInput(e)
	{
	if(isEmpty(e.productId.value))
		{    
		alert("请输入产品编码");
		e.productId.focus();  
		return false;
		}  
	if(noFloat(e.unitPrice.value))	
		{    
		alert("输入数据无效");
		e.unitPrice.focus();  
		return false;
		}  	
	if(noFloat(e.quantity.value))	
		{    
		alert("输入数据无效");
		e.quantity.focus();  
		return false;
		}  	
	}
</script>

<table border="1">
  <tr bgcolor="#9cc1c1">
       <td>合同编码 </td>
       <td>产品编码 </td>
       <td>产品名称 </td>
       <td>英文名称 </td>
       <td>规格/型号 </td>
       <td>单价     </td>
       <td>产品数量 </td>
       <td>总金额   </td>
       <td>&nbsp;</td>
       <td>&nbsp;&nbsp; </td>
    </tr>
<%
float totalPrice=0;
importproduct.next();
for(int i=0;i<productNum;i++) 
    {
%>
    <form method="post" name="contractProduct" action="ImportProductUpdate.jsp?contractId=<%= contractId %>&pageName=<%=request.getParameter("pageName")%>" onsubmit="return VerifyInput(this);" >
     <input type="hidden"  name="contractId" value="<%= contractId %>" >
    <tr>	 
    <td><%=contractId %></td>
    <td>
        <input type="hidden"  name="productId" value="<%=importproduct.getProductId()%>" > <%=importproduct.getProductId()%>
    </td>
<%     	product.load(importproduct.getProductId());
%>
     <td><%=product.getProductName()%></td>
     <td><%=product.getProductEName()%></td>
     <td><%=product.getProductDesc()%></td>
    <td >
        <input type="text"  name="unitPrice" value="<%=importproduct.getUnitPrice()%>" size="12" maxlength="12" >
    </td>
    <td >
        <input type="text"  name="quantity" value="<%=importproduct.getQuantity()%>" size="12" maxlength="12">
    </td>
    <td >
<%   float subPrice=importproduct.getUnitPrice()*importproduct.getQuantity();
%>
     <%=subPrice%>
    </td>
    
    <td>
     <input type="submit" name="update"  value="修改"  />
    </td>
    <td>
      <input type="submit" name="delete" value="删除" />
    </td>
   </tr>
  </form>
<%
    importproduct.next();
    totalPrice = totalPrice + subPrice;
    }
%>
    <form method="post" name="contractProduct0" action="ImportProductUpdate.jsp?contractId=<%= contractId %>&pageName=<%=request.getParameter("pageName")%>" onsubmit="return VerifyInput(this);" >
     <input type="hidden"  name="contractId" value="<%= contractId %>" >
    <tr>	 
    <td><%=contractId %></td>
    <td>
        <input type="text"  name="productId" value="" size="10" maxlength="10" >
    </td>
    <td>
    </td>
    <td>
    </td>
    <td>
    </td>
    <td>
        <input type="text"  name="unitPrice" value="" size="12" maxlength="12" >
    </td>
    <td>
        <input type="text"  name="quantity" value="" size="12" maxlength="12" >
    </td>
    <td><%=totalPrice%></td>
    <td>
     <input type="submit" name="insert" value="增加" >
    </td>
    <td>&nbsp;
    </td>
   </form>
  </table>
    <form method="post" name="contractProduct0" action="ImportProductUpdate.jsp?contractId=<%= contractId %>&pageName=<%=request.getParameter("pageName")%>" >
     <input type="submit" name="return" value="返回" >
    </form>
</body>
</html>

⌨️ 快捷键说明

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