📄 add.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码

💻 PHP

字号:

<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>

<html>
<head>
<title>增加合同明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor">
<?
if($BOM_ID=="")
 {
	$query="SELECT * FROM PRODUCT_BOM WHERE PRODUCT_ID='$PRO_ID' AND PRODUCT_PARENT='$PRODUCT_PARENT'";
	$cursor= exequery($connection,$query);
	if($ROW=mysql_fetch_array($cursor))
	{
		Message("错误","产品 ".$PRO_NAME." 已存在");
		Button_Back();
		exit;
	}
 	$query="INSERT into PRODUCT_BOM (PRODUCT_ID,AMT,PRODUCT_PARENT)
        values('$PRO_ID','$AMT','$PRODUCT_PARENT')";
  }
else
{
	$query="SELECT * FROM PRODUCT_BOM WHERE PRODUCT_ID='$PRO_ID' AND PRODUCT_PARENT='$PRODUCT_PARENT' AND BOM_ID<>$BOM_ID";
	$cursor= exequery($connection,$query);
	if($ROW=mysql_fetch_array($cursor))
	{
		Message("错误","产品 ".$PRO_NAME." 已存在");
		Button_Back();
		exit;
	}

	$query="update PRODUCT_BOM set PRODUCT_ID='$PRO_ID',AMT='$AMT' where BOM_ID='$BOM_ID'";
}

exequery($connection,$query);
?>
</body>
</html>
<script>
location="index.php?PRODUCT_PARENT=<?=$PRODUCT_PARENT?>&<?=$QUERY_LIST?>";
</script>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -