codedefine.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 299 行

PHP
299 行
字号 
<?
  include_once 'inc/auth.php';
  $query = (((''.'SELECT CODE_NAME from SYS_CODE where CODE_NO=\'').$codeid).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $ShowName = $ROW[0];
  }
  if ((($OP == 'edit') AND ($flag != '1')))
  {
    $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_NAME = $ROW['CODE_NAME'];
      $CODE_ORDER = $ROW['CODE_ORDER'];
      $PARENT_NO = $ROW['PARENT_NO'];
      $CODE_FLAG = $ROW['CODE_FLAG'];
    }
  }
  echo '<html>
<head>
<title>';
  echo $ShowName;
  echo '定义</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
var parent_window =window.opener;
function CheckForm(optext,opvalue)
{
   if(document.form1.CODE_NO.value=="")
   { alert("编号不能为空！");
     return (false);
   }
    if(document.form1.CODE_NAME.value=="")
   { alert("名称不能为空！");
     return (false);
   }
}
function delete_code(CODE_ID,FUNC_NAME)
{
 msg=\'确认要删除代码项 \\\'\'+FUNC_NAME+\'\\\' 么？\'';
  echo ';
 if(window.confirm(msg))
 {
  URL="codedefine.php?flag=1&OP=delete&kname=';
  echo $kname;
  echo '&codeid=';
  echo $codeid;
  echo '&CODE_ID=" + CODE_ID;
  location=URL;
 }
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="document.form1.CODE_NO.focus();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3">&nbsp;&nbsp;';
  echo $ShowName;
  echo '定义</span>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="codedefine.php?flag=1&codeid=';
  echo $codeid;
  echo '&kname=';
  echo $kname;
  echo '"  method="post" name="form1" onsubmit="return CheckForm();">
   <tr>
    <td nowrap class="TableData" width="120">编号：</td>
    <td nowrap class="TableData">
        <input type="text" name="CODE_NO" class="';
  if (($CODE_FLAG == '0'))
  {
    echo 'BigStatic';
  }
  else
  {
    echo 'BigInput';
  }
  echo '" size="20" maxlength="100" value="';
  echo $CODE_NO;
  echo '"';
  if (($CODE_FLAG == '0'))
  {
    echo ' readonly';
  }
  echo '>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">排序号：</td>
    <td nowrap class="TableData">
        <input type="text" name="CODE_ORDER" class="BigInput" size="20" maxlength="100" value="';
  echo $CODE_ORDER;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">名称：</td>
    <td nowrap class="TableData">
        <input type="text" name="CODE_NAME" class="BigInput" size="20" maxlength="100" value="';
  echo $CODE_NAME;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
        <input type="hidden" name="CODE_ID" value="';
  echo $codeid;
  echo '">
        <input type="hidden" name="CODE_ID1" value="';
  echo $CODE_ID;
  echo '">
        <input type="hidden" name="K_Name" value="';
  echo $kname;
  echo '">
        <input type="hidden" name="OP" value="';
  echo $OP;
  echo '">
        <input type="submit" value="确定" class="BigButton">&nbsp;&nbsp;
        <input type="button" value="关闭" class="BigButton"  onclick="window.close();">
';
  if ((($OP == 'edit') AND ($flag != '1')))
  {
    echo ' 
       &nbsp;&nbsp;<input type="button" value="取消" class="BigButton"  onclick="location=\'codedefine.php?kname=';
    echo $kname;
    echo '&codeid=';
    echo $codeid;
    echo '\';"> 
';
  }
  echo '      
    </td>
  </form>
</table>
';
  if (($flag == '1'))
  {
    if (($OP == 'edit'))
    {
      $query = ((((((''.'update SYS_CODE set CODE_NAME=\'').$CODE_NAME).'\',CODE_ORDER=\'').$CODE_ORDER).'\' where CODE_ID=').$CODE_ID1);
      exequery ($connection, $query);
      message ('', '修改成功！');
    }
    else
    {
      if (($OP == 'delete'))
      {
        $query = ((''.'delete from SYS_CODE where CODE_ID=').$CODE_ID);
        exequery ($connection, $query);
      }
      else
      {
        $query = (((((''.'SELECT * from SYS_CODE where CODE_NO=\'').$CODE_NO).'\' and PARENT_NO=\'').$CODE_ID).'\'');
        $cursor = exequery ($connection, $query);
        if ($ROW = mysql_fetch_array ($cursor))
        {
          message ('提示', (('代码编号'.$CODE_NO).'已存在！'));
          exit ();
        }
        $query = (((((((((''.'insert into SYS_CODE (CODE_NO,CODE_NAME,CODE_ORDER,PARENT_NO) values (\'').$CODE_NO).'\',\'').$CODE_NAME).'\',\'').$CODE_ORDER).'\',\'').$CODE_ID).'\')');
        exequery ($connection, $query);
        message ('', '增加成功！');
      }
    }
    echo '<s';
    echo 'cript language=javascript>
var parent_window =window.opener;
var OPTION_LIST=[
';
    $query = (((''.'SELECT CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO=\'').$codeid).'\' order by CODE_ORDER');
    $cursor = exequery ($connection, $query);
    $VOTE_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $CODE_NO = $ROW['CODE_NO'];
      $CODE_NAME = $ROW['CODE_NAME'];
      $STR_PRONAME1 = (((($STR_PRONAME1.'"').$CODE_NAME).'"').',');
      $STR_PROID1 = (((($STR_PROID1.'"').$CODE_NO).'"').',');
    }
    $CODE_NO = '';
    $CODE_NAME = '';
    $STR_PRONAME1 = substr ($STR_PRONAME1, 0, (strlen ($STR_PRONAME1) - 1));
    $STR_PROID1 = substr ($STR_PROID1, 0, (strlen ($STR_PROID1) - 1));
    $STR_TEMP = (((((($STR_TEMP.'[').$STR_PRONAME1).'],').'[').$STR_PROID1).'],');
    $STR_TEMP = substr ($STR_TEMP, 0, (strlen ($STR_TEMP) - 1));
    echo $STR_TEMP;
    echo '];
function setvalue(kname)
{
 var PRO_ID= parent_window.document.all(kname);
 var PRODUCT_NAME=OPTION_LIST[0];
 var PRODUCT_VALUE=OPTION_LIST[1];
 PRO_ID.length=0;
 for(var i=0;i<PRODUCT_NAME.length;i++)
 {
  //alert(PRODUCT_NAME[i]);alert(PRODUCT_VALUE[i]);
  var my_option =parent_window.document.createElement("OPTION");
  my_option.text=PRODUCT_NAME[i];
  my_option.value=PRODUCT_VA';
    echo 'LUE[i];
  parent_window.document.all(kname).add(my_option,i);
  parent_window.document.all(kname).selectedIndex=0;
  parent_window.document.all(kname).selected;
 }
}
   setvalue(\'';
    echo $kname;
    echo '\');
   document.form1.CODE_NO.value="";
   document.form1.CODE_NAME.value="";
   document.form1.CODE_ID1.value="";
   document.form1.OP.value="";
 </script>
';
  }
  echo '<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3">&nbsp;&nbsp;';
  echo $ShowName;
  echo '代码管理</span>
    </td>
  </tr>
</table>
<table border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
 <tr class="TableHeader" align="center">
   <td nowrap>
       <b>名称</b>
    </td>
    <td nowrap>
      <b>操作</b>
    </td>
 </tr>
';
  $query1 = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$codeid).'\' order by CODE_ORDER');
  $cursor1 = exequery ($connection, $query1);
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    $CODE_ID = $ROW['CODE_ID'];
    $CODE_NO = $ROW['CODE_NO'];
    $CODE_NAME = $ROW['CODE_NAME'];
    $CODE_FLAG = $ROW['CODE_FLAG'];
    echo '        <tr class="TableData" align="center">
          <td nowrap title="';
    echo $CODE_NAME;
    echo '" >
            &nbsp;<b>';
    echo $CODE_NO;
    echo '&nbsp;&nbsp;';
    echo $CODE_NAME;
    echo '</b>&nbsp;
          </td>
          <td nowrap>&nbsp;
           <a href="codedefine.php?OP=edit&CODE_ID=';
    echo $CODE_ID;
    echo '&kname=';
    echo $kname;
    echo '&codeid=';
    echo $codeid;
    echo '"> 编辑</a>&nbsp;&nbsp;
';
    if (($CODE_FLAG != '0'))
    {
      echo '           <a href="javascript:delete_code(';
      echo $CODE_ID;
      echo ',\'';
      echo $CODE_NAME;
      echo '\');"> 删除</a>
';
    }
    echo '          </td>
        </tr>
';
  }
  echo '    </table>
</body>
</html>
';
?>

codedefine.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 codedefine.php 源码文件，采用 PHP 编程语言编写，共 299 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?