📄 query.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
echo "\r\n<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\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n return (true);\r\n}\r\n\r\nfunction sendForm(publish)\r\n{\r\n if(CheckForm())\r\n document.form1.submit();\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 案卷查询</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableBlock\" width=\"95%\" align=\"center\">\r\n <form action=\"search.php\" method=\"post\" name=\"form1\">\r\n <TR>\r\n <TD class=\"TableData\">案 卷 号：</TD>\r\n <TD class=\"TableData\">\r\n <INPUT name=\"ROLL_CODE\" id=\"ROLL_CODE\" size=20 maxlength=\"100\" dataType=\"Require\" require=\"true\" msg=\"文件号不能为空！\" class=\"BigInput\">\r\n </TD>\r\n <TD class=\"TableData\">案卷名称：</TD>\r\n <TD class=\"TableData\">\r\n <INPUT name=\"ROLL_NAME\" id=\"ROLL_NAME\" size=30 maxlength=\"100\" class=\"BigInput\">\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">所属卷库：</TD>\r\n <TD class=\"TableData\">\r\n\t<select name=\"ROOM_ID\" class=\"BigSelect\">\r\n\t<option value=\"\" ></option>\r\n";
$query = "SELECT * FROM RMS_ROLL_ROOM";
$cursor = exequery( $connection, $query );
$RMS_ROLL_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ROOM_ID = $ROW['ROOM_ID'];
$ROOM_NAME = $ROW['ROOM_NAME'];
echo "\t\r\n\t<option value=\"";
echo $ROOM_ID;
echo "\" >";
echo $ROOM_NAME;
echo "</option>\r\n";
}
echo "\t</select>\r\n </TD>\r\n <TD class=\"TableData\">归卷年代：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"YEARS\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">起始日期：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"BEGIN_DATE0\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BEGIN_DATE0');\">\r\n\t\t-\r\n <input type=\"text\" name=\"BEGIN_DATE1\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BEGIN_DATE1');\">\r\n </TD>\r\n <TD class=\"TableData\">终止日期：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"END_DATE0\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.END_DATE0');\">\r\n -\r\n\t\t<input type=\"text\" name=\"END_DATE1s\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.END_DATE1');\">\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">保管期限：</TD>\r\n <TD class=\"TableData\">\r\n <INPUT name=\"DEADLINE0\" id=\"DEADLINE0\" size=10 class=\"BigInput\">\r\n\t -\r\n <INPUT name=\"DEADLINE1\" id=\"DEADLINE1\" size=10 class=\"BigInput\">\r\n </TD>\r\n <TD class=\"TableData\">案卷密级：</TD>\r\n <TD class=\"TableData\">\r\n\t<select name=\"SECRET\" class=\"BigSelect\">\r\n\t <option value=\"\"";
if ( $SECRET == "" )
{
echo " selected";
}
echo "></option>\r\n\t ";
echo code_list( "RMS_SECRET", $SECRET );
echo "\t</select>\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD class=\"TableData\">全 宗 号：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"CATEGORY_NO\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n <TD class=\"TableData\">目 录 号：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"CATALOG_NO\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">档案馆号：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"ARCHIVE_NO\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n <TD class=\"TableData\">保险箱号：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"BOX_NO\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">缩 微 号：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"MICRO_NO\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n <TD class=\"TableData\">凭证类别：</TD>\r\n <TD class=\"TableData\">\r\n\t<select name=\"CERTIFICATE_KIND\" class=\"BigSelect\">\r\n\t <option value=\"\"";
if ( $CERTIFICATE_KIND == "" )
{
echo " selected";
}
echo "></option>\r\n\t ";
echo code_list( "RMS_CERTIFICATE_KIND", $CERTIFICATE_KIND );
echo "\t</select>\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">凭证编号(起)：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"CERTIFICATE_START0\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n -\r\n\t\t<input type=\"text\" name=\"CERTIFICATE_START1\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n <TD class=\"TableData\">凭证编号(止)：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"CERTIFICATE_END0\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n\t\t-\r\n\t\t<input type=\"text\" name=\"CERTIFICATE_END1\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\">\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">页 数：</TD>\r\n <TD class=\"TableData\">\r\n <input type=\"text\" name=\"ROLL_PAGE0\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\" dataType=\"Number\" require=\"false\" msg=\"页数必须是数字！\">\r\n -\r\n\t\t<input type=\"text\" name=\"ROLL_PAGE1\" value=\"\" size=\"10\" maxlength=\"50\" class=\"BigInput\" dataType=\"Number\" require=\"false\" msg=\"页数必须是数字！\">\r\n </TD>\r\n <TD class=\"TableData\">所属部门：</TD>\r\n <TD class=\"TableData\">\r\n\t<select name=\"DEPT_ID\" class=\"BigSelect\">\r\n\t<option value=\"\" ></option>\r\n";
echo my_dept_tree( 0, $DEPT_ID, 1 );
echo "\t</select>\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD nowrap class=\"TableData\">备注：</TD>\r\n <TD class=\"TableData\" colSpan=3><input type=\"text\" name=\"REMARK\" value=\"\" size=\"50\" maxlength=\"100\" class=\"BigInput\"></TD>\r\n </TR>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"4\" nowrap>\r\n <input type=\"button\" value=\"查询\" class=\"BigButton\" onclick=\"sendForm();\"> \r\n </td>\r\n </tr>\r\n </table>\r\n</form>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -