delete.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 44 行
PHP
44 行
<?
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">
';
$query = ((''.'SELECT LINE_ID from SALE_HISTORY where HISTORY_ID=').$HISTORY_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$LINE_ID = $ROW['LINE_ID'];
}
$query = (((''.'delete SALE_HISTORY from SALE_HISTORY where HISTORY_ID=\'').$HISTORY_ID).'\'');
exequery ($connection, $query);
$query = ((''.'SELECT sum(IFNULL(TOTAL_PRICE, 0)) as PAYMENT from SALE_HISTORY where LINE_ID=').$LINE_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PAYMENT = $ROW['PAYMENT'];
}
if (($PAYMENT == ''))
{
$PAYMENT = 0;
}
$query = ((((''.'update CONTRACT_LINE set PAYMENT=').$PAYMENT).' where LINE_ID=').$LINE_ID);
$cursor = exequery ($connection, $query);
if (($querstr != ''))
{
header (((((((((((''.'location: index.php?querstr=').$querstr).'&CONTRACT_ID=').$CONTRACT_ID).'&CUR_PAGE=').$CUR_PAGE).'&ORDERFIELD=').$ORDERFIELD).'&ORDERTYPE=').$ORDERTYPE));
}
else
{
header (((((((((((((((((((((((((((((((((''.'location: index.php?CUSTOMER_NAME=').$CUSTOMER_NAME).'&KIND=').$KIND).'&SELLMODE=').$SELLMODE).'&CONTRACT_TYPE=').$CONTRACT_TYPE).'&DATE_TYPE=').$DATE_TYPE).'&CONTRACT_NO=').$CONTRACT_NO).'&CONTRACT_NAME=').$CONTRACT_NAME).'&CONTRACT_LINKMAN1=').$CONTRACT_LINKMAN1).'&CONTRACT_LINKMAN2=').$CONTRACT_LINKMAN2).'&DATE1=').$DATE1).'&DATE2=').$DATE2).'&SIGN=').$SIGN).'&CONTRACT_ID=').$CONTRACT_ID).'&CUR_PAGE=').$CUR_PAGE).'&ORDERFIELD=').$ORDERFIELD).'&ORDERTYPE=').$ORDERTYPE));
}
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?