📄 stockoutmodify.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="com.logistic.business.StockOutManager"%>
<%@ page import="com.logistic.model.StockOutInfo" %>
<% request.setCharacterEncoding("gb2312");%>
<%
String soid=(String)request.getParameter("soid");
StockOutInfo soi=null;
if(soid==null){
session.setAttribute("errors","对不起您对stockoutmodify.jsp页面进行操作的权限!");
response.sendRedirect("../../errors/errorpage.jsp");
}
StockOutManager som=new StockOutManager();
soi=som.StockOutSearchById(soid);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title>出库单信息修改窗口</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
<link href="<%=request.getContextPath()%>/cssjs/comcss.css" rel="stylesheet" type="text/css">
<script language="javascript" src="<%=request.getContextPath()%>/cssjs/comjs.js"></script>
</head>
<body>
<%
String success=(String)session.getAttribute("success");
if(success!=null){
%>
<script language="javascript">
alert("商品出库信息修改成功！");
location.href="<%=request.getContextPath()%>/viewpage/datainput/adminstockoutinfos.jsp";
</script>
<%
session.removeAttribute("success");
}
%>
<table width="614" height="304" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FFCCCC">
<tr>
<td width="51" height="23" align="right" class="style9">编号：</td>
<td width="73" align="center" class="code"><%=soid %></td>
<td width="232" align="center"><span class="style5">*标识项必须填写</span></td>
<td width="240" align="center"></td>
</tr>
<tr>
<td height="279" colspan="4" align="center"><form name="stockoutform" method="post" action="/Logistic/stockoutsave">
<table width="556" height="235" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FFCCCC">
<tr>
<td width="103" height="29" align="right" class="style9">出库负责人:</td>
<td width="186" align="left"><select name="stockoutcharge" class="style13" id="stockoutcharge">
<option value="">负责人</option>
<%
String sqlemploy="select *from employeeinfotable";
Statement statemploy=dblink.getStmtread();
ResultSet rsemploy=statemploy.executeQuery(sqlemploy);
while(rsemploy.next()){
String employeeid=rsemploy.getString("EmployeeId");
String employeename=rsemploy.getString("EmployeeName");
out.print("<option value="+employeeid);
if(soi.getChargeid().equals(employeeid)){
out.print(" selected ");
}
out.print(">"+employeename+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*
<input type="hidden" name="soid" value="<%=soid %>">
</span></td>
<td width="68" align="right" class="style9">商品名称:</td>
<td width="181" align="left"><select name="outgoodsid" class="style13" id="outgoodsid">
<option value="">商品名称</option>
<%
String sqlgoods="select *from goodsinfotable";
Statement statgoods=dblink.getStmtread();
ResultSet rsgoods=statgoods.executeQuery(sqlgoods);
while(rsgoods.next()){
String goodsid=rsgoods.getString("GoodsId");
String goodsname=rsgoods.getString("GoodsName");
out.print("<option value="+goodsid);
if(soi.getGoodsid().equals(goodsid)){
out.print(" selected ");
}
out.print(">"+goodsname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="25" align="right" class="style9">商品出库数量:</td>
<td align="left"><input name="stockoutnum" type="text" class="style13" id="stockoutnum" size="8" maxlength="8" value="<%=soi.getGoodsoutnumber() %>">
<span class="style5">*</span></td>
<td align="right" class="style9">商品型号:</td>
<td align="left"><select name="goodstype" class="style13" id="goodstype">
<option value="">商品型号</option>
<%
String sqltype="select *from typetable";
Statement stattype=dblink.getStmtread();
ResultSet rstype=stattype.executeQuery(sqltype);
while(rstype.next()){
String typeid=rstype.getString("TypeId");
String typename=rstype.getString("TypeName");
out.print("<option value="+typeid);
if(soi.getTypeid().equals(typeid)){
out.print(" selected ");
}
out.print(">"+typename+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="28" align="right" class="style9">商品接受人:</td>
<td align="left"><select name="receiveid" class="style13" id="receiveid">
<option value="" selected>--选择--</option>
<%
String sqlemployinfo="select *from employeeinfotable";
Statement statemployinfo=dblink.getStmtread();
ResultSet rsemployinfo=statemployinfo.executeQuery(sqlemployinfo);
while(rsemployinfo.next()){
String employeeid=rsemployinfo.getString("EmployeeId");
String employeename=rsemployinfo.getString("EmployeeName");
out.print("<option value="+employeeid);
if(soi.getGoodsreceiveid().equals(employeeid)){
out.print(" selected ");
}
out.print(">"+employeename+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
<td align="right" class="style9">商品分类:</td>
<td align="left"><select name="commodityid" class="style13" id="commodityid">
<option value="">商品分类</option>
<%
String sqlcomm="select *from commcatetable";
Statement statcomm=dblink.getStmtread();
ResultSet rscomm=statcomm.executeQuery(sqlcomm);
while(rscomm.next()){
String commid=rscomm.getString("CommodityId");
String commname=rscomm.getString("CommodityName");
out.print("<option value="+commid);
if(soi.getCommodityid().equals(commid)){
out.print(" selected ");
}
out.print(">"+commname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="23" colspan="2" align="center" class="style9">出库商品备注信息如下:</td>
<td colspan="2" align="left" class="code"> </td>
</tr>
<tr>
<td height="80" colspan="4"><textarea cols="73" name="stockoutmemo" rows="6" class="style13" id="stockoutmemo" value="<%=soi.getGoodsoutmemo() %>"></textarea></td>
</tr>
<tr align="center">
<td height="26" colspan="4"><input name="Submit" type="submit" class="buttonstyle" value="提交数据">
<input name="cancel" type="reset" class="buttonstyle" id="cancel" value="重置数据"></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -