edit.php

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

PHP
296
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>图书编辑 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function CheckForm()
{
   if(document.form1.BOOK_NAME.value=="")
   {
   	alert("书名不能为空!");
     	return (false);
   }
   if(document.form1.BOOK_NO.value=="")
   { alert("编号不能为空!");
     return (false);
   }
}
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollT';
  echo 'op+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
';
  $query = ((''.'SELECT * from BOOK_INFO where BOOK_ID=').$BOOK_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $BOOK_NAME1 = $ROW['BOOK_NAME'];
    $TYPE_ID1 = $ROW['TYPE_ID'];
    $AUTHOR1 = $ROW['AUTHOR'];
    $ISBN1 = $ROW['ISBN'];
    $PUB_HOUSE1 = $ROW['PUB_HOUSE'];
    $PUB_DATE1 = $ROW['PUB_DATE'];
    $AREA1 = $ROW['AREA'];
    $AMT1 = $ROW['AMT'];
    $PRICE1 = $ROW['PRICE'];
    $BRIEF1 = $ROW['BRIEF'];
    $OPEN1 = $ROW['OPEN'];
    $LEND1 = $ROW['LEND'];
    $BORR_PERSON1 = $ROW['BORR_PERSON'];
    $MEMO1 = $ROW['MEMO'];
    $DEPT1 = $ROW['DEPT'];
    $BOOK_NO = $ROW['BOOK_NO'];
  }
  echo '
<body class="bodycolor" topmargin="5" onload="document.form1.BOOK_NAME.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"> 图书信息编辑 </span>
    </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="500" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="update.php"  method="post" name="form1" onsubmit="return CheckForm();">
   <tr>
    <td nowrap class="TableData">部门:</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="DEPT_ID" class="BigSelect">
';
  echo my_dept_tree (0, $DEPT1, 0);
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">书名:</td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NAME" class="BigInput" size="33" maxlength="100" value="';
  echo $BOOK_NAME1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">编号:</td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NO" class="BigInput" size="33" maxlength="100" value="';
  echo $BOOK_NO;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">图书类别:</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="TYPE_ID" class="BigSelect">
';
  $query = 'SELECT * from BOOK_TYPE order by TYPE_ID';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $TYPE_ID2 = $ROW['TYPE_ID'];
    $TYPE_NAME = $ROW['TYPE_NAME'];
    echo '          <option value="';
    echo $TYPE_ID2;
    echo '" ';
    if (($TYPE_ID2 == $TYPE_ID1))
    {
      echo 'selected';
    }
    echo '>';
    echo $TYPE_NAME;
    echo '</option>
';
  }
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">作者:</td>
    <td nowrap class="TableData">
        <input type="text" name="AUTHOR" class="BigInput" size="33" maxlength="100" value="';
  echo $AUTHOR1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">ISBN号:</td>
    <td nowrap class="TableData">
        <input type="text" name="ISBN" class="BigInput" size="33" maxlength="100" value="';
  echo $ISBN1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版社:</td>
    <td nowrap class="TableData">
        <input type="text" name="PUB_HOUSE" class="BigInput" size="33" maxlength="100" value="';
  echo $PUB_HOUSE1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版日期:</td>
    <td nowrap class="TableData">
        <input type="text" name="PUB_DATE" class="BigInput" size="30" maxlength="10" value="';
  echo $PUB_DATE1;
  echo '">&nbsp;
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.PUB_DATE\');">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">存放地点:</td>
    <td nowrap class="TableData">
        <input type="text" name="AREA" class="BigInput" size="33" maxlength="100" value="';
  echo $AREA1;
  echo '">&nbsp
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">数量:</td>
    <td nowrap class="TableData">
        <input type="text" name="AMT" class="BigInput" size="25" maxlength="11" value="';
  echo $AMT1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">价格:</td>
    <td nowrap class="TableData">
        <input type="text" name="PRICE" class="BigInput" size="25" maxlength="10" value="';
  echo $PRICE1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">内容简介:</td>
    <td nowrap class="TableData">
      	<textarea cols=37 rows=3 name="BRIEF" class="BigInput" wrap="yes">';
  echo $BRIEF1;
  echo '</textarea>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅范围:</td>
    <td nowrap class="TableData">
      ';
  echo '<s';
  echo 'elect name="OPEN" class="BigSelect">
        <option value="0" ';
  if (($OPEN1 == '0'))
  {
    echo 'selected';
  }
  echo '>本部门 </option>
        <option value="1" ';
  if (($OPEN1 == '1'))
  {
    echo 'selected';
  }
  echo '>全体 </option>
      </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅状态:</td>
    <td nowrap class="TableData">
      ';
  echo '<s';
  echo 'elect name="LEND" class="BigSelect">
        <option value="0" ';
  if (($LEND1 == '0'))
  {
    echo 'selected';
  }
  echo '>未借出 </option>
        <option value="1" ';
  if (($LEND1 == '1'))
  {
    echo 'selected';
  }
  echo '>已借出 </option>
      </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">录入人:</td>
    <td nowrap class="TableData">
        <input type="text" name="BORR_PERSON" class="BigStatic" size="33" maxlength="100" value="';
  echo $BORR_PERSON1;
  echo '" readonly>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">备注:</td>
    <td nowrap class="TableData">
        <input type="text" name="MEMO" class="BigInput" size="33" maxlength="100" value="';
  echo $MEMO1;
  echo '">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
        <input type="hidden" value="';
  echo $BOOK_ID;
  echo '" name="BOOK_ID">
        <input type="hidden" value="TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '" name="QUERY_LIST">
        <input type="submit" value="确定" class="BigButton">&nbsp;&nbsp;
        <input type="button" value="返回" class="BigButton" onclick="location=\'list.php?TYPE_ID=';
  echo $TYPE_ID;
  echo '&BOOK_NAME=';
  echo $BOOK_NAME;
  echo '&AUTHOR=';
  echo $AUTHOR;
  echo '&ISBN=';
  echo $ISBN;
  echo '&PUB_HOUSE=';
  echo $PUB_HOUSE;
  echo '&AREA=';
  echo $AREA;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '&ORDER_FIELD=';
  echo $ORDER_FIELD;
  echo '&PAGE_START=';
  echo $PAGE_START;
  echo '\'">
    </td>
  </form>
</table>
</body>
</html>';
?>

⌨️ 快捷键说明

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