📄 goodsmanagemodify.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="com.logistic.business.GoodsManager"%>
<%@ page import="com.logistic.model.GoodsInfo" %>
<% request.setCharacterEncoding("gb2312");%>
<%
String gid=request.getParameter("gid");
if(gid==null){
session.setAttribute("errors","对不起您没有权限对goodsmanagemodify.jsp页面进行操作!");
response.sendRedirect("../../errors/errorpage.jsp");
}
GoodsManager gm=new GoodsManager();
GoodsInfo gi=null;
gi=gm.GoodsSearchById(gid);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<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/selectcity.js"></script>
<script language="javascript" src="<%=request.getContextPath()%>/cssjs/calendar.js"></script>
</head>
<body onLoad="onload()"><!-- 调用selectcity.js中的onload()方法给省下拉列表赋值-->
<!--以下script代码初始化日期控件-->
<script >
var oCalendarChs=new PopupCalendar("oCalendarChs"); //初始化控件时,请给出实例名称:oCalendarChs
oCalendarChs.weekDaySting=new Array("日","一","二","三","四","五","六");
oCalendarChs.monthSting=new Array("一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月");
oCalendarChs.oBtnTodayTitle="今天";
oCalendarChs.oBtnCancelTitle="取消";
oCalendarChs.Init();
</script>
<%
String success=(String)session.getAttribute("success");
if(success!=null){
%>
<script language="javascript">
alert("出库商品信息修改成功！");
location.href="<%=request.getContextPath()%>/viewpage/showpage/admingoods.jsp";
</script>
<%
session.removeAttribute("success");
}
%>
<table width="763" height="268" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#9999CC">
<tr>
<td width="41" height="25" align="center" class="style9">编号:</td>
<td width="65" align="center" class="code"><%=gid %></td>
<td width="352" align="center" valign="middle" class="style5"><span class="style11">(注意：填写下表，*标识的项必须填写)</span></td>
<td width="287" align="center" valign="middle" class="style5"> </td>
</tr>
<tr align="center">
<td height="241" colspan="4"><form name="goodsinfoform" method="post" action="/Logistic/goodsinfoupdate" onSubmit="return goodsinofcheck()">
<table width="740" height="198" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#CCCCFF">
<tr>
<td width="101" height="27" align="right" valign="middle" class="style9">商品名称:</td>
<td width="217" align="left"><input name="goodsname" type="text" class="style13" id="goodsname" size="20" maxlength="20" value="<%=gi.getGoodsname() %>">
<span class="style5">*
<input type="hidden" name="gid" value="<%=gid%>">
</span></td>
<td width="127" align="right" valign="middle" class="style9">商品分类:</td>
<td colspan="4" align="left"><select name="goodscate" class="style13" id="select">
<option value="">选择商品分类</option>
<%
String sqlcommo="select *from commcatetable";
Statement statcommo=dblink.getStmtread();
ResultSet rscommo=statcommo.executeQuery(sqlcommo);
while(rscommo.next()){
String commodityid=rscommo.getString("CommodityId");
String commodityname=rscommo.getString("CommodityName");
out.print("<option value="+commodityid);
if(gi.getGoodscateid().equals(commodityid)){
out.print(" selected ");
}
out.print(">"+commodityname+"</option>");
}
dblink.close();
%>
</select></td>
</tr>
<tr>
<td height="28" align="right" valign="middle" class="style9">供应商:</td>
<td align="left"><select name="goodssupply" class="style13" id="select2">
<option value="">请选择供应商</option>
<%
String sqlsupply="select *from supplytable";
Statement statsupply=dblink.getStmtread();
ResultSet rssupply=statsupply.executeQuery(sqlsupply);
while(rssupply.next()){
String supplyid=rssupply.getString("SupplyId");
String supplyname=rssupply.getString("SupplyName");
out.print("<option value="+supplyid);
if(gi.getGoodssupplyid().equals(supplyid)){
out.print(" selected ");
}
out.print(">"+supplyname+"</option>");
}
dblink.close();
%>
</select></td>
<td align="right" valign="middle" class="style9">商品ABC分类:</td>
<td colspan="2" align="left"><select name="goodsabc" class="style13" id="select3">
<option value="">ABC分类</option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select></td>
<td align="right" valign="middle" class="code"> 商品型号:</td>
<td align="left"><select name="goodstype" class="style13" id="select4">
<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(gi.getTypeid().equals(typeid)){
out.print(" selected ");
}
out.print(">"+typename+"</option>");
}
dblink.close();
%>
</select></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" class="style9">商品产地省:</td>
<td align="left"><label>
<input name="province" type="text" class="style13" id="province" size="20" maxlength="20" value="<%=gi.getGoodsprovince() %>">
<span class="style5">*</span> </label></td>
<td align="right" valign="middle" class="style9">商品产地市:</td>
<td colspan="4" align="left"><label>
<input name="city" type="text" class="style13" id="city" size="20" maxlength="20" value="<%=gi.getGoodscity() %>">
<span class="style5">*</span></label></td>
</tr>
<tr>
<td height="27" align="right" valign="middle" class="style9">商品储存地址:</td>
<td align="left"><select name="goodsstockadd" id="select7" class="style13">
<option value="">物储存地址</option>
<%
String sqlware="select *from warehouseinfotable";
Statement statware=dblink.getStmtread();
ResultSet rsware=statware.executeQuery(sqlware);
while(rsware.next()){
String warehouseid=rsware.getString("WareHouseId");
String warehousename=rsware.getString("WareHouseName");
out.print("<option value="+warehouseid);
if(gi.getGoodsstockid().equals(warehouseid)){
out.print(" selected ");
}
out.print(">"+warehousename+"</option>");
}
dblink.close();
%>
</select></td>
<td align="right" valign="middle" class="style9">商品单价:</td>
<td width="84" align="left"><input name="goodsprice" type="text" class="style13" id="goodsprice2" size="10" maxlength="10" value="<%=gi.getGoodsprice() %>"></td>
<td width="17" align="center" class="style5">元</td>
<td width="69" align="right" class="code">商品单位:</td>
<td width="95" align="left"><select name="goodsunit" class="style13" id="select8">
<option value="">商品单位</option>
<option value="箱">箱</option>
<option value="台">台</option>
<option value="件">件</option>
<option value="千克">千克</option>
</select></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" class="style9">商品定购日期:</td>
<td align="left"><input name="orderdate" type="text" class="style13" id="orderdate2" size="10" maxlength="10" value="<%=gi.getGoodsorderdate() %>" readonly onClick="getDateString(this,oCalendarChs)">
<span class="style5">*(单击选择日期)</span></td>
<td align="right" valign="middle" class="style9">商品入库量:</td>
<td colspan="4" align="left"><input name="stockinnumber" type="text" class="style13" id="stockinnumber2" size="10" maxlength="10" value="<%=gi.getGoodsstocknumber() %>">
<span class="style5">*</span> </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" class="style9">商品入库日期:</td>
<td align="left"><input name="stockindate" type="text" class="style13" id="stockindate2" size="10" maxlength="10" value="<%=gi.getGoodsstockindate() %>" readonly onClick="getDateString(this,oCalendarChs)">
<span class="style5">*(单击选择日期)</span></td>
<td align="right" valign="middle" class="style9"> 所处仓库中的位置:</td>
<td colspan="4" align="left"><select name="stockregion" class="style13" id="select9">
<option value="">库中位置</option>
<%
String sqlregion="select *from stockregioninfotable";
Statement statregion=dblink.getStmtread();
ResultSet rsregion=statregion.executeQuery(sqlregion);
while(rsregion.next()){
String stockregionid=rsregion.getString("StockRegionId");
String stockregionname=rsregion.getString("StockRegionName");
out.print("<option value="+stockregionid);
if(gi.getStockregionid().equals(stockregionid)){
out.print(" selected ");
}
out.print(">"+stockregionname+"</option>");
}
dblink.close();
%>
</select></td>
</tr>
<tr align="center" valign="middle">
<td height="39" colspan="7"><p>
<input name="Submit" type="submit" class="buttonstyle" value="提交数据">
<input name="cancle" type="reset" class="buttonstyle" id="cancle" value="重新填写">
</p></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -