📄 xiaoshojia_modi.asp

📁 下了就能用不信你看一下一定能用的
💻 ASP
字号:
<!--#include file="../conn.asp"-->
<%
if request("action")="modi" then
Stockdetail_number=request.form("Stockdetail_number")
num1=int(request.form("num1"))
jinjia=int(request.form("jinjia"))
kongjia=int(request.form("kongjia"))
lujia=int(request.form("lujia"))
huodong=int(request.form("huodong"))
pifa=int(request.form("pifa"))
upquantity=int(request.form("upquantity"))
lowerquantity=int(request.form("lowerquantity"))
if  not (IsNumeric(num1) and  IsNumeric(jinjia) and IsNumeric(kongjia) and IsNumeric(lujia)  and IsNumeric(pifa) and IsNumeric(upquantity) and IsNumeric(lowerquantity)) then
response.write "<script>alert('参数不正确，价格要为数字');history.go(-1);</script>"
response.end()
end if
if int(upquantity)<int(lowerquantity) then
response.write "<script>alert('下限不能大于上限');history.go(-1);</script>"
response.end()
else 
conn.execute("update ht_Stockdetail set Stockdetail_number='"&Stockdetail_number&"',quantity="&num1&",inprice="&jinjia&",saleprice="&kongjia&",netprice="&lujia&",wholesaleprice="&pifa&",specialprice="&huodong&",upquantity="&upquantity&",lowerquantity="&lowerquantity&" where Stockdetail_number='"&Stockdetail_number&"'")
 response.write "<script language='javascript'>window.opener.location.href = window.opener.location.href;window.close();</script>"
 response.end
end if 
end if 
id=trim(request("id"))
set rs=conn.execute("select * from ht_Stockdetail where Stockdetail_number='"&id&"'")
if rs.eof then
response.write "<script>alert('找不到对应的明细单');history.go(-1);</script>"
else
%>
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/test.css" rel="stylesheet" type="text/css">
<link href="../css/body.css" rel="stylesheet" type="text/css">
<title>修改上限下限</title>
</head>
<script language = "JavaScript">
function check(){
if(document.form1.upquantity.value=="")
{
alert('上限不能为空');
document.form1.upquantity.focus();
return false;
}
if(document.form1.lowerquantity.value=="")
{
alert('下限不能为空');
document.form1.lowerquantity.focus();
return false;
}

}

</script>
<body>

<form name="form1" method="post" action="?action=modi" onSubmit="return check();">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="25" class="borderon">商品基本信息：</td>
  </tr>
</table>
<table width="500" border="1" align="center">
  <tr>
    <td><div align="right">进仓单号：</div></td>
    <td> &nbsp;<%=rs("stock_id")%> </td>
    <td><div align="right">明细编号：</div></td>
    <td> &nbsp;<%=rs("stockdetail_number")%> </td>
  </tr>
  <tr>
    <td><div align="right">品种：</div></td>
    <td> &nbsp;<%=rs("goodstype")%> </td>
    <td><div align="right">产地：</div></td>
    <td> &nbsp;<%=rs("wheremake")%> </td>
  </tr>
  <tr>
    <td><div align="right">品牌：</div></td>
    <td> &nbsp;<%=rs("trademark")%> </td>
    <td><div align="right">仓位：</div></td>
    <td>&nbsp; </td>
  </tr>
  <tr>
    <td><div align="right">型号：</div></td>
    <td> &nbsp;<%=rs("marktype")%> </td>
    <td><div align="right">串号：</div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">颜色：</div></td>
    <td> &nbsp;<%=rs("color")%> </td>
    <td><div align="right">&nbsp; </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">款式：</div></td>
    <td> &nbsp;<%=rs("appendant")%> </td>
    <td><div align="right">&nbsp; </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">数量：</div></td>
    <td> &nbsp;<%=rs("quantity")%> </td>
    <td><div align="right"> &nbsp;</div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">进货价：</div></td>
    <td> &nbsp;<%=rs("inprice")%></td>
    <td><div align="right">&nbsp; </div></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">进货价合计：</div></td>
    <td> &nbsp;<%=rs("quantity")*rs("inprice")%> </td>
    <td><div align="right">&nbsp; </div></td>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="25" class="borderon">价格输入：</td>
  </tr>
</table>
<table width="500" border="1" align="center">
  <tr>
    <td><div align="right">数量：</div></td>
    <td><input name="num1" type="text" id="num1" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("quantity")%>" size="10"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))">
      <input name="stockdetail_number" type="hidden" id="stockdetail_number" value="<%=rs("stockdetail_number")%>"></td>
    <td><div align="right">进货价：</div></td>
    <td><input name="jinjia" type="text" id="jinjia" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("inprice")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
  </tr>
  <tr>
    <td><div align="right">空机价：</div></td>
    <td><input name="kongjia" type="text" id="kongjia" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("saleprice")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
    <td><div align="right">入网价：</div></td>
    <td><input name="lujia" type="text" id="lujia" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("netprice")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
  </tr>
  <tr>
    <td><div align="right">批发价：</div></td>
    <td><input name="pifa" type="text" id="pifa" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("wholesaleprice")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
    <td><div align="right">活动价：</div></td>
    <td><input name="huodong" type="text" id="huodong" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("specialprice")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
  </tr>
  <tr>
    <td><div align="right">库存上限：</div></td>
    <td><input name="upquantity" type="text" id="upquantity" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("upquantity")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
    <td><div align="right">库存下限：</div></td>
    <td><input name="lowerquantity" type="text" id="lowerquantity" onKeyUp="value=value.replace(/[^\d]/g,'') " value="<%=rs("lowerquantity")%>" size="15"onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="4" cellpadding="2">
  <tr>
    <td height="30">
      <div align="center">
        <input type="submit" name="Submit" value="修 改">
        <input type="button" name="Submit2" value="退 出" onClick="javascript:window.close();">
      </div>
    
    </td>
  </tr>
</table>
</form>
<% end if %>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -