delete.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 38 行
PHP
38 行
<?
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">
';
if (($SERVICE_ID != ''))
{
$query = (((''.'delete SERVICE,CONTRACT_LINE,SALE_HISTORY from SERVICE a
LEFT OUTER JOIN CONTRACT_LINE b ON a.SERVICE_ID = b.SERVICE_ID
LEFT OUTER JOIN SALE_HISTORY d ON a.SERVICE_ID =d.SERVICE_ID
LEFT OUTER JOIN SALE_HISTORY e ON e.LINE_ID=b.LINE_ID
where a.SERVICE_ID=\'').$SERVICE_ID).'\'');
del_field_data ('SERVICE', $SERVICE_ID);
}
else
{
$delete_str = (('\''.str_replace (',', '\',\'', substr ($delete_str, 0, -1))).'\'');
$query = (((''.'delete SERVICE,CONTRACT_LINE,SALE_HISTORY from SERVICE a
LEFT OUTER JOIN CONTRACT_LINE b ON a.SERVICE_ID = b.SERVICE_ID
LEFT OUTER JOIN SALE_HISTORY d ON a.SERVICE_ID =d.SERVICE_ID
LEFT OUTER JOIN SALE_HISTORY e ON e.LINE_ID=b.LINE_ID
where a.SERVICE_ID in (').$delete_str).')');
del_field_datastr ('SERVICE', $delete_str);
}
exequery ($connection, $query);
header (((((((((''.'location: index.php?SERVICE_NAME=').$SERVICE_NAME).'&SERVICE_DESC=').$SERVICE_DESC).'&PROVIDER_NAME=').$PROVIDER_NAME).'&CUR_PAGE=').$CUR_PAGE));
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?