📄 dept_add.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="const.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="img/Style.css" rel="stylesheet" type="text/css" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<%
action=Request("action")
if action="add" then
dept_name=safeChar(Request("dept_name"))
dept_mng=safeChar(Request("dept_mng"))
dept_mngpwd=safeChar(Request("pwd"))
truename=safeChar(Request("truename"))
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = dbconn
rs.Source = "SELECT dept_id FROM dept where dept_name='"&dept_name&"' or dept_mng='"&dept_mng&"'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()
if not rs.eof then
Response.Write("<script language='javascript'>alert('部门名称名或负责人帐号已被占用');history.go(-1);</script>")
response.End()
else
set c = Server.CreateObject("ADODB.Command")
c.ActiveConnection = dbconn
c.CommandText = "INSERT INTO dept (dept_name, dept_mng, dept_mngpwd, truename) VALUES ('"&dept_name&"','"&dept_mng&"','"&dept_mngpwd&"','"&truename&"' ) "
c.CommandType = 1
c.CommandTimeout = 0
c.Prepared = true
c.Execute()
Response.Write("<script language='javascript'>alert('部门:"&dept_name&" 添加成功');location=('dept.asp');</script>")
end if
rs.Close()
Set rs = Nothing
%>
<%else %>
<script language="javascript">
function chk()
{
if(document.form.dept_name.value=="")
{alert('部门名称不能为空');return false;}
if(document.form.dept_mng.value=="")
{alert('负责人帐号不能为空');return false;}
else
return true;
}
</script>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<form name="form" action="" method="post" onsubmit="return chk()">
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="0" class="atable1">
<tr>
<td colspan="6" bgcolor="#333"><span class="STYLE1"> 添加部门</span></td>
</tr>
<tr>
<td width="13%" height="30" class="tdmenu"><div align="center"></div></td>
<td width="31%" class="tdmenu"><div align="center"></div></td>
<td width="13%" class="tdmenu"><div align="center"></div></td>
<td width="15%" class="tdmenu"><div align="center"></div></td>
<td width="13%" class="tdmenu"><div align="center"></div></td>
<td width="15%" class="tdmenu"><div align="center"></div></td>
</tr>
<tr>
<td class="tdmenu"><div align="center">部门名称:</div></td>
<td class="tdmenu">
<div align="left">
<input name="dept_name" type="text" class="atable1" id="dept_name" size="30" />
</div></td>
<td class="tdmenu"><div align="center"> 负责人帐号：</div></td>
<td class="tdmenu"><div align="center">
<input name="dept_mng" type="text" class="atable1" id="dept_mng" size="14" maxlength="14" />
</div></td>
<td class="tdmenu"><div align="center"> 负责人姓名：</div></td>
<td class="tdmenu"><div align="center">
<input name="truename" type="text" class="atable1" id="truename" size="10" maxlength="10" />
</div></td>
</tr>
<tr>
<td height="30" colspan="4" class="tdmenu"><div align="left"> 备注：部门负责人的初始密码为：<span class="red">123456</span><input type="hidden" name="action" value="add" />
<input type="hidden" name="pwd" value="123456" /></div>
<div align="center"></div> <div align="center"></div> <div align="center"></div></td>
<td class="tdmenu"><div align="center"><input name="提交" type="submit" class="tdmenu" id="提交" value="提交" />
</div></td>
<td class="tdmenu">
<div align="left">
<input name="重填" type="reset" class="tdmenu" id="重填" value="重填" />
</div></td>
</tr>
</table>
</form>
<%end if%>
</body>
</html>
<%dbconn.close%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -