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 '">
</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 '">
</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 '">
</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 '">
</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 '">
</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 '">
<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 '"> 
</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 '">
</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 '">
</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>
</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 '">
</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">
<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 + -
显示快捷键?