?? stockinsave.jsp
字號:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GB2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<% request.setCharacterEncoding("gb2312");%>
<%
String loginname=(String)session.getAttribute("loginname");
String ok=(String)session.getAttribute("ok");
if(ok==null&&loginname==null)
{
session.setAttribute("errors","對不起您還沒有登陸，請先登陸!");
response.sendRedirect("../../errors/errorpage.jsp");
}
%>
<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>
<table width="598" height="222" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr>
<td width="131" height="20" align="center" class="style11">*標識項必須填寫</td>
<td width="457" align="center" class="style14">
<%
String success=(String)session.getAttribute("success");
if(success!=null){
%>
<script language="javascript">
alert("入庫商品信息添加成功！");
location.href="<%=request.getContextPath()%>/viewpage/datainput/stockinsave.jsp";
</script>
<%
session.removeAttribute("success");
}
%></td>
</tr>
<tr>
<td height="198" colspan="2" align="center" valign="middle"><form name="stockinform" method="post" action="/Logistic/stockinsave">
<table width="515" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#666699">
<tr>
<td width="83" height="25" align="right" class="code">入庫負責人:</td>
<td width="153" align="left"><select name="stockincharge" class="style13" id="select3">
<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);
out.print(">"+employeename+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">* </span></td>
<td width="102" align="right" class="code">商品名稱:</td>
<td width="159" align="left"><select name="stockinname" class="style13" id="stockinname">
<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);
out.print(">"+goodsname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="25" align="right" class="code">入庫數量:</td>
<td align="left"><input name="stockinnum" type="text" class="style13" id="stockinnum" size="8" maxlength="8">
<span class="style5">*</span></td>
<td align="right" class="code">商品類別:</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);
out.print(">"+commname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="26" align="right" class="code">商品型號:</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);
out.print(">"+typename+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
<td colspan="2" align="left" class="code">商品入庫單備注信息如下:</td>
</tr>
<tr>
<td colspan="4" align="center" class="code"><textarea cols="75" name="stockinmemo" rows="6" class="style13" id="stockinmemo"></textarea></td>
</tr>
<tr align="center">
<td height="31" colspan="4"><p>
<input name="Submit" type="submit" class="buttonstyle" id="Submit" onClick="return stockinsave_check()" value="提交數據">
<input name="cancel" type="reset" class="buttonstyle" id="cancel" value="重新填寫">
</p></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -