📄 contractproductupdate.jsp
字号:
<jsp:useBean id="contractProduct" class="src.wuyang.ContractProduct" scope="page"/>
<jsp:useBean id="product" class="src.wuyang.Production" scope="page"/>
<jsp:setProperty name="contractProduct" property="*" />
<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>
<script language="JavaScript">
<!--
function AddProduct() {
open("ProductId.jsp","ProductList","scrollbars=yes,width=250,height=200")
}
// -->
</script>
<%! int rtcode;%>
<%
String contractId = request.getParameter("contractId");
String mode = request.getParameter("mode");
String[] str={"卖","买"};
if (mode == null || mode.equals("ok") ){
contractProduct.query("contractId='" + contractId +"'","");
} else {
if (request.getParameter("insert")!=null && mode.equals("insert") ){
rtcode = contractProduct.insert();
}else if (request.getParameter("update")!=null && mode.equals("update")){
rtcode = contractProduct.update();
}
if (rtcode >=0){
%>
<jsp:forward page="ContractProductUpdate.jsp" >
<jsp:param name="mode" value="ok" />
<jsp:param name="contractId" value="<%=contractId%>" />
</jsp:forward>
<%
} else {
%>
<jsp:forward page="../pub/DBErr.jsp" >
<jsp:param name="rtcode" value="<%=rtcode %>" />
</jsp:forward>
<%
}
}
%>
<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" >
<table width="100%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
<tr class="text">
<td class="text" bgcolor="#949b93">
<div align="center"><b>产品编号</b></div>
</td>
<td class="text" bgcolor="#949b93">
<div align="center"><b>产品名称</b></div>
</td>
<td class="text" bgcolor="#949b93">
<div align="center"><b>规格/型号</b></div>
</td>
<td class="text" bgcolor="#949b93">
<div align="center"><b>产品数量</b></div>
</td>
<td class="text" bgcolor="#949b93">
<div align="center"><b>单价</b></div>
</td>
<td class="text" bgcolor="#949b93">
<div align="center"><b class="text">买卖标记</b></div>
</td>
<td class="text" bgcolor="#949b93">
<div align="center"><b class="text">总价</b></div>
</td>
<td class="text" bgcolor="#949b93"> </td>
</tr>
<%
float totalPrice = 0;
while(contractProduct.next()>0){
product.load(contractProduct.getProductId());
float subPrice = contractProduct.getQuantity() * contractProduct.getUnitPrice();
totalPrice = totalPrice + subPrice;
%>
<tr>
<form method="post" action="ContractProductUpdate.jsp">
<input type="hidden" name="contractId" value="<%=contractId%>">
<input type="hidden" name="mode" value="update"/>
<input type="hidden" name="productId" value="<%=contractProduct.getProductId()%>" />
<td class="textb"> <%=contractProduct.getProductId()%> </td>
<td class="textb"> <%=product.getProductName()%> </td>
<td class="textb"> <%=product.getProductDesc()%> </td>
<td>
<input type="text" size="10" name="quantity" value="<%=contractProduct.doubleFormat(contractProduct.getQuantity(),2)%>" />
</td>
<td>
<input type="text" size="10" name="unitPrice" value="<%=contractProduct.doubleFormat(contractProduct.getUnitPrice(),2)%>" />
</td>
<td>
<select name="salesFlag">
<option value="0" <%if(contractProduct.getSalesFlag()==0){%>selected<%}%>><%=str[0]%></option>
<option value="1" <%if(contractProduct.getSalesFlag()==1){%>selected<%}%>><%=str[1]%></option>
</select>
</td>
<td class="textb"> <%=contractProduct.doubleFormat(subPrice,2)%></td>
<td>
<input type="submit" name="update" value="修改" />
</td>
</form>
</tr>
<%
}
%>
<tr>
<form method="post" name="insert" action="ContractProductUpdate.jsp">
<input type="hidden" name="mode" value="insert" />
<input type="hidden" name="contractId" value="<%=contractId%>" />
<td>
<input type="text" size="10" name="productId"><input type="button" value=">>" onclick="AddProduct()"/>
</td>
<td>
</td>
<td>
</td>
<td>
<input type="text" size="10" name="quantity">
</td>
<td>
<input type="text" size="10" name="unitPrice">
</td>
<td>
<select name="salesFlag">
<option value="0"><%=str[0]%></option>
<option value="1"><%=str[1]%></option>
</select>
</td>
<td class="textb"> <%=contractProduct.doubleFormat(totalPrice,2)%> </td>
<td>
<input type="submit" name="insert" value="新增" />
</td>
</form>
</tr>
</table>
</td>
</tr>
</table>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -