📄 insertcontractproduct.jsp
字号:
<jsp:useBean id="contractproduct" class="src.wuyang.ContractProduct" scope="page"/>
<jsp:useBean id="instalment" class="src.wuyang.ContractInstalment" scope="page"/>
<jsp:useBean id="product" class="src.wuyang.Production" scope="page"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>
<jsp:setProperty name="contractproduct" property="*" />
<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" >
<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<% }
%>
<%! String contractId;%>
<%! String pageName;%>
<%! int productNum;%>
<%! int instalmentNum;%>
<%
pageName = request.getParameter("pageName");
contractId = request.getParameter("contractId");
productNum = contractproduct.query("contractId='"+contractId+"'","");
instalmentNum = instalment.query("contractId='"+contractId+"'","");
String flag[] = {"卖","买"};
%>
<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> </td>
<td> </td>
</tr>
<%
float totalPrice1=0;
contractproduct.next();
for(int i=0;i<productNum;i++)
{
%>
<form method="post" name="contractProduct" action="ContractProductUpdate.jsp?contractId=<%= contractId %>&pageName=<%=pageName%>" onsubmit="return VerifyInput(this);" >
<input type="hidden" name="contractId" value="<%= contractId %>" >
<tr>
<td><%=contractId %></td>
<td>
<input type="hidden" name="productId" value="<%=contractproduct.getProductId()%>" > <%=contractproduct.getProductId()%>
</td>
<% product.load(contractproduct.getProductId());
%>
<td><%=product.getProductName()%></td>
<td><%=product.getProductDesc()%></td>
<td>
<select name="salesFlag">
<% for(int j=0;j<2;j++) { %>
<option value="<%=j%>" <% if(contractproduct.getSalesFlag()==j){%> selected <%}%>><%=flag[j]%></option>
<%}%>
</select>
</td>
<td >
<input type="text" name="unitPrice" value="<%=contractproduct.getUnitPrice()%>" size="12" maxlength="12" >
</td>
<td >
<input type="text" name="quantity" value="<%=contractproduct.getQuantity()%>" size="12" maxlength="12">
</td>
<td >
<% float subPrice=contractproduct.getUnitPrice()*contractproduct.getQuantity();
if(contractproduct.getSalesFlag() == 1)
subPrice=subPrice*(-1);
%>
<%=subPrice%>
</td>
<td>
<input type="submit" name="update" value="修改" />
</td>
<td>
<input type="submit" name="delete" value="删除" />
</td>
</tr>
</form>
<%
contractproduct.next();
totalPrice1 = totalPrice1 + subPrice;
}
%>
<form method="post" name="contractProduct0" action="ContractProductUpdate.jsp?contractId=<%= contractId %>&pageName=<%=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>
<select name="salesFlag">
<% for(int j=0;j<2;j++) { %>
<option value="<%=j%>"><%=flag[j]%></option>
<%}%>
</select>
</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><%=totalPrice1%></td>
<td>
<input type="submit" name="insert" value="增加" >
</td>
<td>
</td>
</form>
</table>
<table border="1">
<tr bgcolor="#9cc1c1">
<td>合同编码</td>
<td>交货数量</td>
<td>结算期限</td>
<td>付款金额</td>
<td>备注 </td>
<td>总金额 </td>
<td> </td>
<td> </td>
</tr>
<%
float totalPrice2=0;
float subPrice2=0;
instalment.next();
for(int i=0;i<instalmentNum;i++)
{
%>
<form method="post" name="contractInstalment" action="ContractInstalmentUpdate.jsp?contractId=<%= contractId %>&pageName=<%=pageName%>" onsubmit="return VerifyInput(this);" >
<input type="hidden" name="no" value="<%=instalment.getNo()%>" >
<input type="hidden" name="contractId" value="<%= contractId %>" >
<tr>
<td><%=contractId %></td>
<td><input type="text" name="deliverNum" value="<%=instalment.getDeliverNum()%>"></td>
<td>
<input type="text" name="endTimeYear" value="<%=instalment.getStringDate(instalment.getEndTime(),1)%>" size="4" maxlength="4">
年
<input type="text" name="endTimeMonth" value="<%=instalment.getStringDate(instalment.getEndTime(),2)%>" size="2" maxlength="2">
月
<input type="text" name="endTimeDay" value="<%=instalment.getStringDate(instalment.getEndTime(),3)%>" size="2" maxlength="2">
日
</td>
<td >
<input type="text" name="paymentNum" value="<%=instalment.getPaymentNum()%>" >
</td>
<td >
<input type="text" name="comment" value="<%=instalment.getComment()%>" >
</td>
<td></td>
<td>
<input type="submit" name="update" value="修改" />
</td>
<td>
<input type="submit" name="delete" value="删除" />
</td>
</tr>
</form>
<%
subPrice2=subPrice2+instalment.getPaymentNum();
instalment.next();
totalPrice2 = totalPrice2 + subPrice2;
}
%>
<form method="post" name="contractInstalment0" action="ContractInstalmentUpdate.jsp?contractId=<%= contractId %>&pageName=<%=pageName%>" onsubmit="return VerifyInput(this);" >
<input type="hidden" name="contractId" value="<%= contractId %>" >
<tr>
<td><%=contractId %></td>
<td><input type="text" name="deliverNum"></td>
<td>
<input type="text" name="endTimeYear" size="4" maxlength="4">
年
<input type="text" name="endTimeMonth" size="2" maxlength="2">
月
<input type="text" name="endTimeDay" size="2" maxlength="2">
日
</td>
<td >
<input type="text" name="paymentNum" >
</td>
<td >
<input type="text" name="comment" >
</td>
<td><%=totalPrice2%></td>
<td>
<input type="submit" name="insert" value="增加" >
</td>
<td>
</td>
</form>
</table>
合同金额： <%=totalPrice1%> <br>
付款金额： <%=totalPrice2%> <br>
<form method="post" name="contractProduct0" action="<%=pageName%>?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 + -