bookno_info.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 92 行
PHP
92 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>选择客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
include_once 'inc/menu_button.js';
echo '
';
echo '<s';
echo 'cript Language="JavaScript">
var parent_window = parent.dialogArguments;
function add_bookno(BOOK_NO,BOOK_NAME)
{
parent_window.form1.BOOK_NO.value="";
parent_window.form1.BOOK_NO.value=BOOK_NO;
parent.close();
}
</script>
</head>
<body class="bodycolor" onMouseover="borderize_on(event)" onMouseout="borderize_off(event)" onclick="borderize_on1(event)" topmargin="5">
';
$query1 = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW1['DEPT_ID'];
}
$query = (((((''.'SELECT * from BOOK_INFO where (BOOK_NO like \'%').$BOOK_NO).'%\') or (BOOK_NAME like \'%').$BOOK_NO).'%\') order by BOOK_NO');
$cursor = exequery ($connection, $query);
$BOOK_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$BOOK_ID = $ROW['BOOK_ID'];
$BOOK_NO = $ROW['BOOK_NO'];
$DEPT = $ROW['DEPT'];
$OPEN = $ROW['OPEN'];
$BOOK_NAME = $ROW['BOOK_NAME'];
if ((((($LEND_FLAG == 1) AND ($OPEN == 0)) AND ($DEPT != $DEPT_ID)) AND ($USER_ID != '')))
{
continue;
}
else
{
++$BOOK_COUNT;
if (($BOOK_COUNT == 1))
{
echo '
<table border="1" cellspacing="0" width="95%" class="small" cellpadding="3" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
';
}
echo '<tr class="TableControl">
<td class="menulines" align="center" onclick="javascript:add_bookno(\'';
echo $BOOK_NO;
echo '\',\'';
echo $BOOK_NAME;
echo '\')" style="cursor:hand">';
echo $BOOK_NO;
echo '(';
echo $BOOK_NAME;
echo ')</a></td>
</tr>
';
++$BOOK_COUNT;
if ((50 <= $BOOK_COUNT))
{
break;
}
continue;
}
}
if (($BOOK_COUNT == 0))
{
message ('提示', '没有图书信息');
}
else
{
echo '<thead class="TableControl">
<th bgcolor="#d6e7ef" align="center"><b>选择图书编号(最多显示50条)</b></th>
</thead>
</table>
';
}
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?