delete.php
来自「极限网络智能办公系统—MYOA26—100%—源程序。」· PHP 代码 · 共 38 行
PHP
38 行
<?php
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 );
}
return;
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>删除部门</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
tree_delete( $DEPT_ID );
add_log( 5, $DEPT_ID, $LOGIN_USER_ID );
message( "提示", "部门/成员单位已删除" );
echo "\r\n";
echo "<s";
echo "cript>\r\nparent.dept_list.location.reload();\r\n</script>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?