📄 pro_edit.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_ID = $ROW['CODE_ID'];
$CODE_NAME = $ROW['CODE_NAME'];
if ( $CODE_ID == $GETVALUE )
{
echo "<option value='".$CODE_NO."' selected>".$CODE_NAME."</option>";
}
else
{
echo "<option value='".$CODE_NO."'>".$CODE_NAME."</option>";
}
}
}
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
echo "<html>\r\n<head>\r\n<title>办公用品类别</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><script src=\"/inc/js/module.js\"></script>\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.PRO_NAME.value==\"\")\r\n {\r\n alert(\"办公用名称不能为空！\");\r\n form1.PRO_NAME.focus()\r\n return (false);\r\n }\r\n\r\n if(document.form1.PRO_UNIT.value==\"\")\r\n {\r\n alert(\"计量单位不能为空！\");\r\n \tform1.PRO_UNIT.focus()\r\n return (false);\r\n }\r\n}\r\n\r\nfunction CheckTypeForm()\r\n{\r\n if(document.TypeForm.CODE_ORDER.value==\"\")\r\n {\r\n alert(\"类别排序号不能为空！\");\r\n TypeForm.CODE_ORDER.focus()\r\n return (false);\r\n }\r\n\r\n if(document.TypeForm.CODE_NAME.value==\"\")\r\n {\r\n alert(\"类别名称不能为空！\");\r\n TypeForm.CODE_NAME.focus()\r\n return (false);\r\n }\r\n}\r\n</script>\r\n</head>\r\n";
$query = "SELECT * from SYS_CODE where CODE_ID='".$CODE_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_ORDER = $ROW['CODE_ORDER'];
$CODE_NAME = $ROW['CODE_NAME'];
}
echo "<body class=\"bodycolor\" topmargin=\"5\" >\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 办公用品类别编辑 </span><font color=\"red\">(办公用品类别的删除在系统管理的系统代码设置中)</font>\r\n </td>\r\n </tr>\r\n</table>\r\n<table width=\"70%\" class=\"TableBlock\" align=\"center\" >\r\n <form action=\"updateType.php\" method=\"post\" name=\"TypeForm\" onSubmit=\"return CheckTypeForm();\">\r\n \t<tr>\r\n <td nowrap class=\"TableContent\">编号： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" readonly=\"true\" name=\"CODE_NO\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"";
echo $CODE_NO;
echo "\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">排序号： </td>\r\n <td nowrap class=\"TableData\">\r\n\t\t<input type=\"text\" name=\"CODE_ORDER\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"";
echo $CODE_ORDER;
echo "\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">类别名称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CODE_NAME\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"";
echo htmlspecialchars( $CODE_NAME );
echo "\"> \r\n </td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" align=\"center\">\r\n\t\t<input type=\"hidden\" name=\"CODE_ID\" value=\"";
echo $CODE_ID;
echo "\">\r\n <input type=\"hidden\" name=\"OLD_ORDER\" value=\"";
echo $CODE_ORDER;
echo "\">\r\n <input type=\"submit\" value=\"确定\" class=\"BigButton\"> \r\n </td>\r\n\t</tfoot>\r\n </form>\r\n</table>\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 新建办公用品 </span>\r\n </td>\r\n </tr>\r\n</table>\r\n<table width=\"70%\" class=\"TableBlock\" align=\"center\" >\r\n <form action=\"add.php\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n <tr>\r\n <td nowrap class=\"TableContent\">办公用品名称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_NAME\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">办公用品描述： </td>\r\n <td nowrap class=\"TableData\">\r\n \t <textarea cols=37 name=\"PRO_DESC\" rows=\"2\" class=\"BigInput\" wrap=\"yes\"></textarea>\r\n\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">办公用品类别： </td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"OFFICE_PROTYPE\" class=\"BigSelect\">\r\n";
getalldate( "OFFICE_PROTYPE", $CODE_ID );
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">办公用品编码： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_CODE\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">计量单位： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_UNIT\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">单价： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_PRICE\" class=\"BigInput\" size=\"30\" maxlength=\"100\" value=\"\">(元) \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">供应商： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_SUPPLIER\" class=\"BigInput\" size=\"33\" maxlength=\"25\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">最低警戒库存： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_LOWSTOCK\" class=\"BigInput\" size=\"33\" maxlength=\"25\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">最高警戒库存： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_MAXSTOCK\" class=\"BigInput\" size=\"33\" maxlength=\"25\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">当前库存： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRO_STOCK\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">创建人：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"hidden\" name=\"PRO_CREATOR\" value=\"";
echo $LOGIN_USER_ID;
echo "\" >\r\n";
$query2 = "select USER_NAME from USER where USER_ID='".$LOGIN_USER_ID."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$SELLER1_NAME = $ROW['USER_NAME'];
}
echo " <input type=\"text\" name=\"PRO_CREATORNAME\" class=\"BigStatic\" readonly size=\"10\" maxlength=\"100\" value=\"";
echo $SELLER1_NAME;
echo "\"> 创建人可以修改自己创建的办公用品信息。\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">登记权限（用户）：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"hidden\" name=\"COPY_TO_ID\" value=\"\">\r\n <textarea cols=37 name=\"COPY_TO_NAME\" rows=2 class=\"BigStatic\" wrap=\"yes\" readonly></textarea> \r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUser('','COPY_TO_ID', 'COPY_TO_NAME')\">选择</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('COPY_TO_ID', 'COPY_TO_NAME')\">清空</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">登记权限（部门）：</td>\r\n <td class=\"TableData\" >\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"\">\r\n <textarea cols=37 name=TO_NAME rows=2 class=\"BigStatic\" wrap=\"yes\" readonly></textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDept()\">添加</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser()\">清空</a>\r\n <br>有登记权限的用户或部门，可以申请领用、借用该办公用品，都不填写，表示所有部门均有权限。\r\n </td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" align=\"center\">\r\n <input type=\"submit\" value=\"新建办公用品\" class=\"BigButton\" name=\"button\">\r\n </td>\r\n </tfoot>\r\n </form>\r\n</table>\r\n</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -