📄 sprkth.jsp
字号:
<%@ 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()){
spid=rs1.getString("ID");
spname=rs1.getString("spname");
jc=rs1.getString("jc");
cd=rs1.getString("cd");
dw=rs1.getString("dw");
gg=rs1.getString("gg");
bz=rs1.getString("bz");
gysname=rs1.getString("gysname");
}
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);
%>
<center><img src="../KCM/sprk.gif"></center>
<table width="557" height="112" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#F2F2F2">
<tr><td width="274" >
<form name="form1" method="post" action="sprkth.jsp" >
<tr><td> <select name="rkspname" onChange="spchange()">
<option selected="selected">请选择需要退货的商品名称</option>
<%String s1 = null;%>
<%
while(rs.next()){
s1 = rs.getString("spname");
%>
<option value=<%=s1%>> <%=s1%> </option>
<%}%>
</select></td><td width="276"> <font color="#585858">注:带*号为必填项 </font></td></tr>
<tr><td> 入库退货编号:<font color="#585858"><%=rkbh%></font></td></tr>
<tr><td> 商品名称:<font color="#585858"><%=spname%></font></td>
<td> 简 称:<font color="#585858"><%=jc%></font></td>
</tr>
<tr><td> 规 格:<font color="#585858"><%=gg%></font></td>
<td> 包 装:<font color="#585858"><%=bz%></font></td>
</tr>
<tr><td> 供应商全称:<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> 数 量:<input type="text" name="sl" onBlur="autoje()">
<font color="#585858">(<%=dw%>)*</font></td>
<td> 金 额:<input type="text" name="je" readonly></td>
</tr>
<tr><td> 单 价:<input type="text" name="dj" onBlur="autoje()">
<font color="#585858">(元)*</font></td>
<td> 应 付:<input type="text" name="yf" readonly></td>
</tr>
<tr><td> 实 付:<input type="text" name="sf" onBlur="autoje()">
<font color="#585858">(元)*</font></td>
<td> 未 付:<input type="text" name="wf" readonly></td>
</tr>
<tr><td> 操作员:<input type="text" name="czy" readonly value="<%=session.getAttribute("username")%>">
<font color="#585858"></font></td>
<td> 经手人:<input type="text" name="jsr">*</td>
</tr>
<tr><td> 退货日期:<input type="text" name="rkdate" readonly value="<%=calendar.getDate()%>">
<font color="#585858"></font></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><div align="center">
<input name="mySubmit" type="button" value="保存信息" onclick="check()">
</div></td>
<td><input name="myreset"type="reset" class="btn_grey" value="清除重置" onClick="myreset()"></td></tr>
</form>
</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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -