📄 update.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.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\">\r\n";
$COUNT = 0;
$query = "select count(*) from OFFICE_PRODUCTS where OFFICE_PROTYPE='".$OFFICE_PROTYPE."' and PRO_NAME='{$PRO_NAME}' and PRO_ID<>'{$PRO_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$COUNT = $ROW[0];
}
if ( 0 < $COUNT )
{
message( "提示", "同类别下已有相同名称的办公用品!" );
echo "<div align=\"center\">\r\n\t<input type=\"button\" value=\"确定\" class=\"BigButton\" onClick=\"location='edit.php?PRO_ID=";
echo $PRO_ID;
echo "'\">\r\n</div>\r\n";
}
else
{
$query = "update OFFICE_PRODUCTS set \t\tPRO_NAME='".$PRO_NAME."',PRO_DESC='{$PPRO_DESC}',PRO_UNIT='{$PRO_UNIT}',PRO_CODE='{$PRO_CODE}',PRO_SUPPLIER='{$PRO_SUPPLIER}',PRO_LOWSTOCK='{$PRO_LOWSTOCK}',PRO_PRICE='{$PRO_PRICE}',PRO_MAXSTOCK='{$PRO_MAXSTOCK}',PRO_STOCK='{$PRO_STOCK}',PRO_DEPT='{$TO_ID}',PRO_MANAGER='{$COPY_TO_ID}',PRO_CREATOR='{$PRO_CREATOR}',OFFICE_PROTYPE='{$OFFICE_PROTYPE}' where PRO_ID='{$PRO_ID}'";
exequery( $connection, $query );
if ( $iExpand == 1 )
{
message( "提示", "办公用品修改成功!" );
echo " <br>\r\n\t\t<div align=\"center\">\r\n \t\t\t<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\">\r\n\t\t</div>\r\n ";
}
else
{
echo "\t\t\r\n\t\t<script language=javascript>\r\n\t\t\tparent.PRO_LIST.xtree1.redrawNode(\"";
echo $OFFICE_PROTYPE;
echo "\",\"share\",\"\");\r\n\t\t\tparent.PRO_LIST.xtree1.redrawNode(\"";
echo $OLD_TYPE;
echo "\",\"share\",\"\");\r\n\t\t\twindow.location=\"edit.php?PRO_ID=";
echo $PRO_ID;
echo "\"; \r\n\t\t\talert(\"办公用品修改成功!\");\r\n\t\t</script>\r\n ";
}
}
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -