📄 purchproductinsert.jsp
字号:
<jsp:useBean id="PurchProduct" class="src.wuyang.PurchProduct" scope="page"/>
<jsp:useBean id="contractproduct" class="src.wuyang.ContractProduct" 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 pageName = request.getParameter("pageName");
String contractId = request.getParameter("contractId");
String purchId = request.getParameter("purchId");
int productNumP=PurchProduct.query("purchId='"+purchId+"'","");
int productNumC=contractproduct.query("contractId='"+contractId+"'","");
String flag[] = {"卖","买"};
String pack[] = {"带包装","净水"};
%>
<html>
<head>
<link rel="stylesheet" href="css.css" type="text/css">
<script language ="javascript" src='../pub/pub.js' type=text/javascript></script>
</head>
<script language="JavaScript">
function AddProduct() {
open("ProductId.jsp","ProductList","scrollbars=yes,width=250,height=200")
}
function VerifyInput(e)
{
if(isEmpty(e.productId.value))
{
alert("请输入产品编号");
e.productId.focus();
return false;
}
if(noFloat(e.quantity.value))
{
alert("输入数据无效");
e.quantity.focus();
return false;
}
if(noFloat(e.unitPrice.value))
{
alert("输入数据无效");
e.unitPrice.focus();
return false;
}
}
</script>
<body bgcolor="#949B93" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="105%" border="1" height="90%" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" >
<tr>
<td valign="top" > <br>
<b class="textb">相关合同产品</b>
<table width="100%" 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>
</tr>
<tr>
<%
float totalPrice1=0;
contractproduct.next();
for(int i=0;i<productNumC;i++)
{
%>
<td class="textb"><%=contractId %></td>
<td class="textb"><%=contractproduct.getProductId()%></td>
<%
product.load(contractproduct.getProductId());
%>
<td class="textb"><%=product.getProductName()%></td>
<td class="textb"><%=product.getProductDesc()%></td>
<td class="textb"><%=flag[contractproduct.getSalesFlag()]%></td>
<td class="textb" ><%=contractproduct.doubleFormat(contractproduct.getUnitPrice(),2)%></td>
<td class="textb" ><%=contractproduct.doubleFormat(contractproduct.getQuantity(),2)%></td>
<%
float subPrice=contractproduct.getUnitPrice()*contractproduct.getQuantity();
if(contractproduct.getSalesFlag() == 1)
subPrice=subPrice*(-1);
%>
<td class="textb" ><%=contractproduct.doubleFormat(subPrice,2)%></td>
</tr>
<%
contractproduct.next();
totalPrice1 = totalPrice1 + subPrice;
}
%>
</table>
<table width="100%" border="0">
<tr>
<td width="66%"><b class="textb">申请单产品 </b></td>
<td width="16%"><b class="textb">申请单编号：</b></td>
<td width="18%"><b class="textb"><%=purchId%></b></td>
</tr>
</table>
<table width="100%" 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>
<td class="text">
<div align="center"><b> </b></div>
</td>
</tr>
<%
float totalPrice=0;
PurchProduct.next();
for(int i=0;i<productNumP;i++)
{
%><form method="post" name="PurchProduct" action="UpdatePurchProduct.jsp?contractId=<%= contractId%>&pageName=<%=request.getParameter("pageName")%>" onsubmit="return VerifyInput(this);" >
<input type="hidden" name="purchId" value="<%=PurchProduct.getPurchId()%>" >
<input type="hidden" name="productId" value="<%=PurchProduct.getProductId()%>" >
<td class="textb">
<%=PurchProduct.getProductId()%> </td>
<% product.load(PurchProduct.getProductId());
%>
<td class="textb"><%=product.getProductName()%></td>
<td class="textb"><%=product.getProductDesc()%></td>
<td class="textb">
<input type="text" name="productAdd" value="<%=PurchProduct.getProductAdd()%>" size="8" >
</td>
<td class="textb" >
<input type="text" name="quantity" value="<%=PurchProduct.doubleFormat(PurchProduct.getQuantity(),2)%>" size="8" maxlength="12">
</td>
<td class="textb" >
<input type="text" name="unitPrice" value="<%=PurchProduct.doubleFormat(PurchProduct.getUnitPrice(),2)%>" size="8" maxlength="12" >
</td>
<td class="textb" >
<select name="pack">
<% for(int j=0;j<2;j++) { %>
<option value="<%=j%>" <% if(PurchProduct.getPack()==j){%> selected <%}%>><%=pack[j]%></option>
<%}%>
</select>
</td>
<td class="textb" >
<% float subPrice=PurchProduct.getUnitPrice()*PurchProduct.getQuantity();
%>
<%=PurchProduct.doubleFormat(subPrice,2)%> </td>
<td class="textb">
<input type="submit" name="update" value="修改" />
</td>
<td class="textb">
<input type="submit" name="delete" value="删除" />
</td>
</tr>
</form>
<%
PurchProduct.next();
totalPrice = totalPrice + subPrice;
}
%>
<form method="post" name="insert" action="UpdatePurchProduct.jsp?contractId=<%= contractId %>&pageName=<%=request.getParameter("pageName")%>" onsubmit="return VerifyInput(this);" >
<input type="hidden" name="purchId" value="<%= purchId %>" >
<tr>
<td class="textb">
<input type="text" name="productId" value="" size="10" maxlength="10" ><input type="button" value=">>" onclick="AddProduct()"/>
</td>
<td class="textb"> </td>
<td class="textb"> </td>
<td class="textb">
<input type="text" name="productAdd" size="8" >
</td>
<td class="textb">
<input type="text" name="quantity" value="" size="8" maxlength="12" >
</td>
<td class="textb">
<input type="text" name="unitPrice" value="" size="8" maxlength="12" >
</td>
<td class="textb">
<select name="pack">
<% for(int j=0;j<2;j++) { %>
<option value="<%=j%>" ><%=pack[j]%></option>
<%}%>
</select>
</td>
<td class="textb"><%=PurchProduct.doubleFormat(totalPrice,2)%></td>
<td class="textb">
<input type="submit" name="insert" value="增加" >
</td>
<td class="textb"> </td>
</form>
</table>
<form method="post" name="PurchProduct0" action="<%=pageName%>?purchId=<%= purchId %>" >
<div align="center">
<input type="submit" name="return" value="返回" >
</div>
</form>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -