📄 d_del.asp
字号:
<!-- #include File=../../showsort/showsort(man).asp -->
<%if sort<=2 then%>
<script language="JavaScript">
alert("对不起，您没有权限！！");
window.history.back();
</script>
<%end if%>
<%
set rs=server.createobject("ADODB.Recordset")
newdept=request("newdept")
for i=1 to request("del").count
if request("del")(i)=newdept then
newdept=0
end if
next
if request("pagename")="" then
for i=1 to request("del").count
set rs_d1=server.createobject("ADODB.Recordset")
rs_d1.Open "Select * from manage_dept where id="&request("del")(i),source,3,3
set rs_dd=server.createobject("ADODB.Recordset")
rs_dd.Open "Select * from manage_dept where parent='"&rs_d1("id")&"' ",source,3,3
do while not rs_dd.eof
rs_dd("parent")=request("parent")
rs_dd.update
rs_dd.movenext
loop
rs.Open "delete from manage_dept where id="&request("del")(i),source,3,3
sql1= "Select * from manage_user where deptid="&request("del")(i)
set rs1=server.createobject("ADODB.Recordset")
rs1.open sql1,source,3,3
do while not rs1.eof
rs1("deptid")=newdept
rs1.update
rs1.movenext
loop
rs1.close
next
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>PMIS</title>
<LINK href="../../<%=session("color")%>.css" rel=stylesheet type=text/css>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<center>
<!-- #include File=../../include/title2.asp -->
</center>
</div>
<div align="center">
<center>
<table width="100%" cellspacing cellpadding>
<tr>
<td width="20%" class="Titletd1" height="365" valign="top">
<table width="158" cellspacing cellpadding class="L2">
<tr>
<td height="10" colspan="3" class="bgcolor4"></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font><font color="#FFFFFF">部门管理</font></td>
</tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../dept/d_list.asp"><font color="#FFFFFF">>
部门一览</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../dept/d_input.asp"><font color="#FFFFFF">> 新增部门</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../dept/d_del.asp"><font color="#FFFFFF">> 删除部门</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../dept/d_list4.asp"><font color="#FFFFFF">> 部门人员</font></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font><font color="#FFFFFF">员工管理</font></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_modify.asp"><font color="#FFFFFF">> 员工一览</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_addnewuser.asp"><font color="#FFFFFF">>
新增员工</font></a></td>
</tr> <tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_del.asp"><font color="#FFFFFF">> 删除员工</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_leave.asp"><font color="#FFFFFF">> 离职员工</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_wagemonth.asp"><font color="#FFFFFF">>
工资报表</font></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::日常人事管理</font></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="d_list-tj.asp"><font color="#FFFFFF">> 添加申请</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="d_list-sp.asp"><font color="#FFFFFF">> 人事审批</font></a></td>
</tr>
<tr class="bgcolor2"> <td></td> <td></td> <td><a href="d_list-pz.asp"><font color="#FFFFFF">> 人事配置</font></a></td> </tr> <tr class="bgcolor2"> <td></td> <td></td> <td><a href="d_list-lcsz.asp"><font color="#FFFFFF">> 人事流程设置</font></a></td> </tr>
<tr class="bgcolor4">
<td colspan="3" height="200"></td>
</tr>
</table>
</td>
<td width="1%" bgcolor="#FFFFFF"></td>
<td width="79%" bgcolor="#FFFFFF" valign="top">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%" height="10"></td>
</tr>
<tr>
<td width="100%">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%" height="25" style="background-image: url('../../images/<%=session("color")%>/hrm.gif'); background-repeat: no-repeat">
<font color="#000080"> 员工管理</font>
删除部门</td>
</tr>
<tr>
<td width="100%" height="10"></td>
</tr>
<tr>
<td width="100%" height="10">
<form method="post" action="d_del.asp" name="form1">
<table width="100%" border="0" class="L2">
<tr>
<td width="20%"> </td>
<td width="80%"> </td>
</tr>
<tr>
<td width="20%"> </td>
<td width="80%"> <%
rs.Open "Select * from manage_dept",source,3,3
%> <b>请选择要删除的部门</b>
<p>
<select name="del" class="box" size="12" multiple>
<%while not rs.eof%>
<option value="<%=rs("id")%>"><%=rs("deptname")%></option>
<%rs.movenext%> <%wend%>
</select>
</p>
</td>
</tr>
<tr>
<td width="20%"> </td>
<td width="80%"><b>删除部门的员工自动转到以下部门</b></td>
</tr>
<tr>
<td width="20%"> </td>
<td width="80%"> <%if rs.recordcount>0 then rs.movefirst%>
<select name="newdept" class="box">
<option value="0">不属于任何部门</option>
<%while not rs.eof%>
<option value="<%=rs("id")%>"><%=rs("deptname")%></option>
<%rs.movenext%> <%wend%>
</select>
</td>
</tr>
<tr>
<td width="20%"> </td>
<td width="80%"><b>删除部门的下级部门自动转到以下部门</b></td>
</tr>
<tr>
<td width="20%"> </td>
<td width="80%"><%if rs.recordcount>0 then rs.movefirst%>
<select name="parent" class="box">
<option value="0">不属于任何部门</option>
<%while not rs.eof%>
<option value="<%=rs("id")%>"><%=rs("deptname")%></option>
<%rs.movenext%> <%wend%>
</select>
</td>
</tr>
<tr>
<td width="20%"> </td>
<td width="80%">
<table width="188" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="right">
<input type="image" border="0" name="Submit" src="../../images/i_button_6.gif" width="37" height="18">
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<!-- #include File=../../include/last2.asp -->
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -