delete.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 48 行

PHP
48
字号
<?
  function tree_delete ($DEPT_ID)
  {
    global $connection;
    $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);
    }
    return null;
  }
  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">
';
  tree_delete ($DEPT_ID);
  add_log (5, $DEPT_ID, $LOGIN_USER_ID);
  message ('提示', '部门/成员单位已删除');
  echo '
';
  echo '<s';
  echo 'cript>
parent.dept_list.location.reload();
</script>
</body>
</html>
';
?>

⌨️ 快捷键说明

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