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

📄 slipproductupdate.jsp

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

<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>
<%! String url;%>
<%! int rtcode;%>
<%
	String slipId = request.getParameter("slipId");
	String mode = request.getParameter("mode");
	String pack[] = {"带包装","净水"};

	if (mode == null || mode.equals("ok") ){
			slipProduct.query("slipId='" + slipId +"'","");
			
	} else { 
%>
<jsp:setProperty name="slipProduct" property="*" />
<%
		if (request.getParameter("insert")!=null && mode.equals("insert") ){ 
			rtcode = slipProduct.insert();
		}else if (request.getParameter("update")!=null && mode.equals("update")){
			rtcode = slipProduct.update();
		}
		
		if (rtcode >=0){
%>
<jsp:forward page="SlipProductUpdate.jsp" >
 	<jsp:param name="mode" value="ok" />
 	<jsp:param name="slipId" value="<%=slipId%>" />
</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 border="1" width="100%" class="text" cellpadding="0" cellspacing="0" borderColorLight=#666666 borderColorDark=#cccccc>
          <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>&nbsp;</b></div>
            </td>
          </tr>
          <%
        float totalPrice = 0;
	while(slipProduct.next()>0){
		product.load(slipProduct.getProductId());
		float subPrice = slipProduct.getQuantity() * slipProduct.getUnitPrice();
		totalPrice = totalPrice + subPrice;
%>
          <tr> 
            <form method="post" action="SlipProductUpdate.jsp">
              <input type="hidden" name="slipId" value="<%=slipId%>">
              <input type="hidden" name="mode" value="update"/>
              <input type="hidden" name="productId" value="<%=slipProduct.getProductId()%>" />
              <td class="textb"> 
                <%=slipProduct.getProductId()%>
              </td>
              <td class="textb"> <%=product.getProductName()%> </td>
              <td class="textb"> <%=product.getProductDesc()%> </td>
              <td> 
                <input type="text" size="10" name="quantity" value="<%=slipProduct.doubleFormat(slipProduct.getQuantity(),2)%>" />
              </td>
              <td> 
            <select name="pack">
              <% for(int j=0;j<2;j++) { %>
              <option value="<%=j%>" <% if(slipProduct.getPack()==j){%>selected<%}%>><%=pack[j]%></option>
              <%}%>
            </select>
              </td>
              <td> 
                <input type="text" size="10" name="unitPrice" value="<%=slipProduct.doubleFormat(slipProduct.getUnitPrice(),2)%>" />
              </td>
              <td class="textb"> <%=slipProduct.doubleFormat(subPrice,2)%> </td>
              <td> 
                <input type="submit" name="update" value="修改" />
              </td>
            </form>
          </tr>
          <%
	}
%>
          <tr> 
            <form method="post" name="insert" action="SlipProductUpdate.jsp">
              <input type="hidden" name="mode" value="insert" />
              <input type="hidden" name="slipId" value="<%=slipId%>" />
              <td> 
                <input type="text" size="10" name="productId"><input type="button" value=">>" onclick="AddProduct()"/>
              </td>
              <td>&nbsp; 
              </td>
              <td>&nbsp; 
              </td>
              <td> 
                <input type="text" size="10" name="quantity">
              </td>
              <td> 
            <select name="pack">
              <% for(int j=0;j<2;j++) { %>
              <option value="<%=j%>" <% if(slipProduct.getPack()==j){%>selected<%}%>><%=pack[j]%></option>
              <%}%>
            </select>
              </td>
              <td> 
                <input type="text" size="10" name="unitPrice">
              </td>
              <td class="textb"> <%=slipProduct.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 + -