📄 deptadd.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=DataBase/conn.asp-->
<!--#include file=yan.asp-->
<!--#include file=purview.asp-->
<%
call bumenshezhi
'上级部门id
set rs=server.CreateObject("adodb.recordset")
sql="select * from tb_Dept order by up "
rs.open sql,conn,1,1
'添加部门
if request("post")<>"" then
if request("title")<>"" then
'判断同一级别下是否有重复
set rsc=server.CreateObject("adodb.recordset")
sqlc="select * from tb_Dept where shangji="&request("up")&" and title='"&request("title")&"'"
rsc.open sqlc,conn,1,1
if not rsc.eof then
response.Write("<script language=javascript>alert('同一级别下的部门不能重名');location='javascript:history.go(-1)'</script>")
response.End()
end if
'上级部门级别
set rsj=server.CreateObject("adodb.recordset")
sqlj="select * from tb_Dept where id="&request("up")
rsj.open sqlj,conn,1,1
up=rsj("up")
set rsa=server.CreateObject("adodb.recordset")
sqla="Select * from tb_Dept where id is null"
rsa.Open sqla,conn,1,3
rsa.addnew
rsa("title")=request("title")
rsa("level")=rsj("level")+1
rsa("up")=request("up")
rsa("shangji")=request("up")
rsa.update
rsa.close
'获取id
set rsa=server.CreateObject("adodb.recordset")
sqla="Select * from tb_Dept order by id desc"
rsa.Open sqla,conn,1,3
id=rsa("id")
'添加排序
set rsa1=server.CreateObject("adodb.recordset")
sqla1="Select * from tb_Dept "
rsa1.Open sqla,conn,1,3
rsa1("up")=up&","&id
rsa1.update
rsa1.close
set rsc=nothing
response.Write("<script language=javascript>alert('添加成功');parent.location.reload()</script>")
else
response.Write("<script language=javascript>alert('请填写部门名称 ');location='javascript:history.go(-1)'</script>")
end if
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
<link href="CSS/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<form name="form1" method="post" action="">
<p> </p>
<table width="221" height="106" border="0" align="center" cellspacing="0">
<tr>
<td colspan="2"><input name="post" type="hidden" id="post" value="true"></td>
</tr>
<tr>
<td width="44%" height="36"><div align="center">添加部门名称：</div></td>
<td width="56%"><input name="title" type="text" class="wenben" id="title" size="16">
</td>
</tr>
<tr>
<td><div align="center">选择上级部门：</div></td>
<td><select name="up" id="select2">
<%
do while not rs.EOF
tempcataStr=""
for i=1 to rs("level")-1
tempcataStr = tempcataStr&"├"
next
tempcataStr = tempcataStr&"〖"&trim(rs("title"))&"〗"
%>
<option value="<%=rs("id")%>"><%=tempcataStr%></option>
<%
rs.movenext
loop
%>
</select></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="Submit" type="submit" class="botton" value=" 添 加 ">
<input name="Submit2" type="reset" class="botton" value=" 重 置 ">
</div></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -