forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsprkth.jsp
More file actions
168 lines (145 loc) · 7.02 KB
/
sprkth.jsp
File metadata and controls
168 lines (145 loc) · 7.02 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.io.*"%>
<jsp:useBean id="rst" scope="page" class="com.mingri.dbconn.DBResult"/>
<jsp:useBean id="calendar" scope="page" class="com.mingri.showtime.ShowTime"/>
<html>
<title>商品入库退货</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet" type="text/css">
<body>
<%
request.setCharacterEncoding("gb2312");//对字符串统一编码解决表单提交中的中文乱玛问题
String strSql="select * from tb_brand";
String maxCount="select max(id) from tb_rukuth";//在入库退货表中查找出最大的id号
ResultSet rs=rst.getResult(strSql);//在下拉列表中显示商品名称
String jc=""; String gg="";String bz="";String spid="";String spname="";
String gysname="";String cd="";String dw="";String theMax="";
String rkspname=(String)request.getParameter("rkspname");//获得用户所选商品的简称
String rkStr="select * from tb_brand where spname='"+rkspname+"'";
ResultSet rs1=rst.getResult(rkStr);//根据商品名称查询出用户所选商品
if(rs1.next()){
jc=rs1.getString("jc");gg=rs1.getString("gg");bz=rs1.getString("bz");
gysname=rs1.getString("gysname"); cd=rs1.getString("cd");dw=rs1.getString("dw");
spid=rs1.getString("ID");spname=rs1.getString("spname");
}
ResultSet rs2=rst.getResult(maxCount);//获得tb_rukuth表中字段"id"最大的记录
if(rs2.next()){
theMax=rs2.getString(1);
}
//将最大的字段加1
String rkbh="TH"+calendar.getDateString()+(Integer.parseInt(theMax.substring(10))+1);
%>
<table width="584" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="27" colspan="6" bgcolor="#EEEEEE" class="tableBorder_gray">
<span class="word_deepgrey"> 当前位置：库存管理 > </span>入库退货 >>></td>
</tr>
<tr>
<td valign="top" height="83"><br>
<table width="550" height="112" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F2F2F2">
<form name="form1" method="post" action="sprkth.jsp" >
<tr><td> <select name="rkspname" onChange="spchange()">
<option selected="selected">请选择需要退货的商品名称</option>
<%while(rs.next()){%>
<option value=<%=rs.getString("spname")%>> <%=rs.getString("spname")%> </option>
<%}%>
</select></td><td width="276"> <font color="#585858">注:带*号为必填项 </font></td></tr>
<tr><td height="25"> 入库退货编号:<font color="#585858"><%=rkbh%></font></td></tr>
<tr><td height="25"> 商品名称:<font color="#585858"><%=spname%></font></td>
<td> 简 称:<font color="#585858"><%=jc%></font></td>
</tr>
<tr><td height="25"> 规 格:<font color="#585858"><%=gg%></font></td>
<td> 包 装:<font color="#585858"><%=bz%></font></td>
</tr>
<tr><td height="25"> 供应商全称:<font color="#585858"><%=gysname%></font></td>
<td> 产 地:<font color="#585858"><%=cd%></font></td>
</tr>
</form>
<form name="form2" method="post" action="sprkthChange.jsp" >
<%
session.setAttribute("jc",jc); session.setAttribute("spname",spname);
session.setAttribute("gg",gg); session.setAttribute("bz",bz);
session.setAttribute("cd",cd); session.setAttribute("rkbh",rkbh);
session.setAttribute("dw",dw); session.setAttribute("spid",spid);
session.setAttribute("gysname",gysname);
%>
<tr><td height="25"> 数 量:<input type="text" name="sl" onBlur="autoje()">
(<%=dw%>)*</td>
<td> 金 额:<input type="text" name="je" readonly></td>
</tr>
<tr><td height="25"> 单 价:<input type="text" name="dj" onBlur="autoje()">
(元)*</td>
<td> 应 付:<input type="text" name="yf" readonly></td>
</tr>
<tr><td height="25"> 实 付:<input type="text" name="sf" onBlur="autoje()">
(元)*</td>
<td> 未 付:<input type="text" name="wf" readonly></td>
</tr>
<tr><td height="25"> 操作员:<input type="text" name="czy" readonly value="<%=session.getAttribute("username")%>">
</td>
<td> 经手人:<input type="text" name="jsr">*</td>
</tr>
<tr><td height="25"> 退货日期:<input type="text" name="rkdate" readonly value="<%=calendar.getDate()%>">
</td>
<td> 结算方式:<select name="jsfs">
<option value="现金" selected>现金</option>
<option value="yf" >预付</option>
<option value="zp" >支票</option>
<option value="gz" >挂账</option></select></td>
</tr>
<input type="hidden" name="hjc" value=<%=jc%>></form>
<tr><td height="36" colspan="2" align="center">
<input name="mySubmit" type="button" class="btn_grey" onclick="check()" value="保存信息">
<input name="myreset"type="reset" class="btn_grey" value="清除重置" onClick="myreset()"></td>
</tr>
</form>
</table>
</td></tr></table>
</body>
</html>
<script language='JavaScript'>
function spchange()
{
form1.submit();
}
function autoje()
{
str=form2.sl.value;
if(isNaN(str)){//判断输入是否为数字
form2.sl.value=0;
alert("输入错误,请输入数字");form2.sl.focus();retrun;}
str=form2.dj.value;
if(isNaN(str)){
form2.dj.value=0;
alert("输入错误,请输入数字");form2.dj.focus();retrun;}
str=form2.sf.value;
if(isNaN(str)){
form2.sf.value=0;
alert("输入错误,请输入数字");form2.sf.focus();retrun;}
//自动计算金额、应收及未收款
form2.je.value=form2.dj.value*form2.sl.value;
form2.yf.value=form2.je.value;
form2.wf.value=form2.yf.value-form2.sf.value;
if(form2.sf.value-form2.yf.value>0){
form2.sf.value=0;
form2.wf.value=form2.yf.value;
alert("实付金额不应大于应付金额!");form2.sf.focus();return;
}
}
function check()
{
if(form2.sl.value==0){
alert("请输入数量");form2.sl.focus();return;}
if(form2.dj.value==0){
alert("请输入单价");form2.dj.focus();return;}
if(form2.sf.value==0){
alert("请输入实付");form2.sf.focus();return;}
if(form2.jsr.value==""){
alert("请输入经手人姓名");form2.jsr.focus();return;}
form2.submit();
}
function myreset()
{
form2.reset();
}
</script>