delete.php
来自「极限网络智能办公系统 Office Automation V3.0官方100%源」· PHP 代码 · 共 46 行
PHP
46 行
<?
function tree_delete ($DEPT_ID)
{
$connection = openconnection ();
$query = 'delete from DEPARTMENT where DEPT_ID=' . $DEPT_ID;
exequery ($connection, $query);
$query = 'select * from USER where DEPT_ID=' . $DEPT_ID . ' and USER_ID=\'admin\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$query = 'update USER set DEPT_ID=0 where USER_ID=\'admin\'';
exequery ($connection, $query);
}
$query = 'delete from USER where DEPT_ID=' . $DEPT_ID;
exequery ($connection, $query);
$query = 'select * from DEPARTMENT where DEPT_PARENT=' . $DEPT_ID;
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$DEPT_ID = $ROW['DEPT_ID'];
tree_delete ($DEPT_ID);
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>删除部门</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$connection = openconnection ();
tree_delete ($DEPT_ID);
add_log (5, $DEPT_ID, $LOGIN_USER_ID);
message ('提示', '部门/成员单位已删除');
echo '
<script>
parent.dept_list.location.reload();
</script>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?