⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 ku_add.asp

📁 某公司的进销存软件的设计与开发
💻 ASP
字号:
<%
if session("username")="" then
%>
<script language="javascript">
top.location.href="../login.asp"
</script>
<%  
  response.end
end if
%>
<!-- #include file="../conn2.asp" -->
<!-- #include file="../const.asp" -->

<html>
<head>
<title><%=dianming%> - 基本信息设置</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style2.css" rel="stylesheet" type="text/css">
</HEAD>

<BODY>
<%
if fla5="0" then
%>
<br><center><font color="#FF0000">你不具备此权限,请与管理员联系!</font></center>
<%  
  response.end
end if
%>
<%if request("hid1")="" then%>
<script language="javascript">
function check()
{
if (document.form1.ku.value=="")
{
alert("有*号的必须填写!");
return false;
}
}
</script>
<form name="form1">
<table width="98%" border="0" cellpadding="0" cellspacing="2" align="center">
  <tr> 
    <td height="21">&nbsp;<img src="../Images/ico/ico50.gif" width="32" height="32" hspace="2" vspace="2" align="absmiddle"><font size="+1"><strong> 添加仓库</strong></font></td>
  </tr>
</table>
<table width="98%" border="0" cellspacing="1" cellpadding="2" align="center" class="TableMenu">
  <tr class="a1" style="color:#ffffff;font-size:12px;">
    <th height="30" style="color:#ffffff;font-size:14px" colspan="2"><img src="../images/add.gif" border="0" hspace="2" align="absmiddle">添加仓库<font size="-1"> (带*号的为必填项)</font></th>
  </tr>
  <tr bgcolor="#ffffff">
    <td width="28%" height="30" align="right"><b>仓库名称:</b> </td>
    <td width="72%">&nbsp;&nbsp;
        <input type="text" name="ku" style="width:200px">
        &nbsp;<font color="#ff0000">*</font></td>
  </tr>
  <tr class="a3">
    <td width="28%" height="30" align="right"><b>负责人:</b> </td>
    <td width="72%">&nbsp;&nbsp;
		  <%
		  sql="select * from login order by id"
		  set rs_login=conn.execute(sql)
		  if rs_login.eof then
		  %>
		    <a href="user_add.asp">先添加员工</a>
		  <%
		  else
		  %>
		  <select name="login">
		  <%
		  do while rs_login.eof=false
		  %>
		    <option value="<%=rs_login("username")%>"<%if rs_login("username")=session("username") then%> selected="selected"<%end if%>><%=rs_login("username")%></option>
		  <%
		    rs_login.movenext
		  loop
		  %>
		  </select>
		  <%
		  end if
		  %>
		  </td>
  </tr>
  <tr bgcolor="#ffffff">
    <td width="28%" height="30" align="right"><b>联系电话:</b> </td>
    <td width="72%">&nbsp;&nbsp;
        <input type="text" name="tel" style="width:200px">
        &nbsp;</td>
  </tr>   
  <tr class="a3">
    <td width="28%" height="30" align="right"><b>仓库地址:</b> </td>
    <td width="72%">&nbsp;&nbsp;
        <input type="text" name="address" style="width:300px">
        &nbsp;</td>
  </tr>  
  <tr bgcolor="#ffffff">
    <td width="28%" height="30" align="right"><b>仓库备注:</b> </td>
    <td width="72%">&nbsp;&nbsp;
        <input type="text" name="beizhu" style="width:400px">
        &nbsp;</td>
  </tr>  
  <tr class="a3">
    <td width="28%" height="30" align="right"><b>默认仓库:</b> </td>
    <td width="72%">&nbsp;&nbsp;
        <input type="checkbox" name="moren" value="1"></td>
  </tr>  
  <tr bgcolor="#ffffff">
    <td height="30">&nbsp;</td>
    <td>&nbsp;&nbsp;
        <input name="submit" type="submit" onClick="return check()" value=" 确 认 ">
      &nbsp;&nbsp;&nbsp;&nbsp;
        <input type="hidden" name="hid1" value="ok">
        <input name="reset" type="reset" value=" 重新填写 ">
    </td>
  </tr>
</table>
</form>
<%
else
nowku=request("ku")
nowlogin=request("login")
nowtel=request("tel")
nowaddress=request("address")
nowbeizhu=request("beizhu")
nowmoren=request("moren")
sql="select * from ku where ku='"&nowku&"'"
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("您输入的仓库名已经存在!")
window.history.go(-1)
</script> 
<%
  response.end
end if
set rs=server.createobject("ADODB.RecordSet")
sql="select * from ku where 1=2"
rs.open sql,conn,1,3
rs.addnew
rs("ku")=nowku
rs("login")=nowlogin
rs("tel")=nowtel
rs("address")=nowaddress
rs("beizhu")=nowbeizhu
if nowmoren="1" then
  sql="update ku set moren=false"
  conn.execute(sql)
  rs("moren")=true
end if
rs.update
%>
<script language="javascript">
alert("仓库添加成功!")
window.location.href="ku.asp"
</script> 
<%
end if
%>
</body>
</html>

⌨️ 快捷键说明

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