📄 bigsearch.asp
字号:
<!--#include file="Conn.asp"-->
<!--#include file="Inc/CheckUser.asp"-->
<%
if Session("isSearch") = 1 or Session("Admin") = true then
else
Response.Write("<script>alert('对不起，当前强力搜索功能不对外开放！');window.close();</script>")
Response.End()
end if
dim i,j
dim total
Set rs = Server.CreateObject("ADODB.RecordSet")
%>
<HTML>
<HEAD>
<title>工程学院教学管理系统 —— 强力搜索 </title>
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Expires" content="0">
<meta http-equiv="Pragma" content="no-cache">
<LINK href="../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Style/style.css" rel="stylesheet">
<script language="javascript" type="text/javascript">
<!--
document.write("<BASE onmouseover='window.status=\"欢迎使用 工程学院教学管理系统系统\";return'>");
index.xl.disabled=1
function checkData()
{
if(document.index.first.value == "")
{
alert("请选择第一条件进行搜索！");
return false;
}
}
function change(str,val)
{
document.index.second.value = str;
document.index.Scondition.value = val;
}
//-->
</script>
</HEAD>
<body background="../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Images/bg.jpg" topmargin="5" leftmargin="0">
<form name="index" method="post" action="" ID="Form1" onsubmit="return checkData()">
<table cellSpacing="0" cellPadding="0" border="0" width="95%" align="center">
<tr>
<td align="center" style="FONT-WEIGHT: bold; FONT-SIZE: 16px;" height="40">
教 师 档 案 强 力 搜 索
</td>
</tr>
<%if Request.Form("Fcondition") = "" then%>
<tr>
<td height="20">
请选择您要搜索的条件：
</td>
</tr>
<%else
dim college,Fcondition,Scondition,keywords
college = Request.Form("college")
Fcondition = Request.Form("Fcondition")
Scondition = Request.Form("Scondition")
keywords = Request.Form("keywords")
xl = Request.Form("xl")
sql = "Select userinfo.*,"&Fcondition&".* From [userinfo],["&Fcondition&"] Where userinfo.id = "&Fcondition&".owner "
if college <> "" then
sql = sql & " And userinfo.college = '"&college&"'"
end if
if Scondition <> "" then
sql = sql & " And "&Fcondition&".type = "&Scondition&" "
end if
if keywords <> "" then
'sql = sql & " And "&Fcondition&".type = "&Scondition&" "
end if
%>
<tr>
<td height="30">
您选择的搜索对象是： <font color=blue style="font-size:14px"><%if Request.Form("college") = "" then:Response.Write "全校范围内 ":else:Response.Write Request.Form("college"):end if%></font> 的 <font color=blue style="font-size:14px"><%=Request.Form("first")%></font>
<%if Request.Form("second") <> "" then Response.Write " 中的 <font color=blue style='font-size:14px'>"&Request.Form("second")&"</font>"%>
<%if Request.Form("keywords") <> "" then Response.Write " 关键字为 <font color=red style='font-size:14px'>"&Request.Form("keywords")&"</font>"%>
的档案资料， 以下是搜索到的结果集
</td>
</tr>
<tr>
<td align="center">
<%
'教学研究工作
if Fcondition = "jiaoyan" and Scondition = "1" then
if keywords <> "" then
sql = sql & " And (jiaoyan.name like '%"&keywords&"%' Or jiaoyan.lessonName like '%"&keywords&"%' Or jiaoyan.Froming like '%"&keywords&"%' Or jiaoyan.author like '%"&keywords&"%' Or jiaoyan.startendTime like '%"&keywords&"%') And type = 1 "
end if
call jiaoyan_zykt()
elseif Fcondition = "jiaoyan" and Scondition = "2" then
if keywords <> "" then
sql = sql & " And (jiaoyan.name like '%"&keywords&"%' Or jiaoyan.lessonName like '%"&keywords&"%' Or jiaoyan.Froming like '%"&keywords&"%' Or jiaoyan.author like '%"&keywords&"%') And type = 2 "
end if
call jiaoyan_fblw()
elseif Fcondition = "jiaoyan" and Scondition = "3" then
if keywords <> "" then
sql = sql & " And (jiaoyan.name like '%"&keywords&"%' Or jiaoyan.lessonName like '%"&keywords&"%' Or jiaoyan.Froming like '%"&keywords&"%' Or jiaoyan.author like '%"&keywords&"%') And type = 3 "
end if
call jiaoyan_fblz()
elseif Fcondition = "jiaoyan" and Scondition = "4" then
if keywords <> "" then
sql = sql & " And (jiaoyan.name like '%"&keywords&"%' Or jiaoyan.lessonName like '%"&keywords&"%' Or jiaoyan.unit like '%"&keywords&"%' Or jiaoyan.author like '%"&keywords&"%' Or jiaoyan.startendTime like '%"&keywords&"%') And type = 4 "
end if
call jiaoyan_hjqk()
'科研工作
elseif Fcondition = "research" and Scondition = "1" then
if keywords <> "" then
sql = sql & " And (research.Froming like '%"&keywords&"%' Or research.lessonName like '%"&keywords&"%' Or research.unit like '%"&keywords&"%' Or research.startendTime like '%"&keywords&"%') And type = 1 "
end if
call research_zykt()
elseif Fcondition = "research" and Scondition = "2" then
if keywords <> "" then
sql = sql & " And (research.name like '%"&keywords&"%' Or research.lessonName like '%"&keywords&"%' Or research.author like '%"&keywords&"%' Or research.Froming like '%"&keywords&"%') And type = 2 "
end if
call research_fblw()
elseif Fcondition = "research" and Scondition = "3" then
if keywords <> "" then
sql = sql & " And (research.name like '%"&keywords&"%' Or research.lessonName like '%"&keywords&"%' Or research.author like '%"&keywords&"%' Or research.startendTime like '%"&keywords&"%') And type = 3 "
end if
call research_lzqk()
elseif Fcondition = "research" and Scondition = "4" then
if keywords <> "" then
sql = sql & " And (research.name like '%"&keywords&"%' Or research.lessonName like '%"&keywords&"%' Or research.unit like '%"&keywords&"%' Or research.author like '%"&keywords&"%' Or research.startendTime like '%"&keywords&"%') And type = 4 "
end if
call research_hjqk()
'教师情况
elseif Fcondition = "js" then
call js()
end if
Response.Write sql
%>
<br><br>
<input type="button" name="button" value=" 重 新 搜 索 " onMouseOver="this.className='button_o';"
onMouseOut="this.className='button';" class="button" onclick="javascript:self.location.href='BigSearch.asp';">
</td>
</tr>
<%end if%>
</table>
<%if Request.Form("Fcondition") = "" then%>
<input type="hidden" name="first" value="">
<input type="hidden" name="second" value="" ID="1">
<input type="hidden" name="Scondition" value="" ID="2">
<table cellSpacing="1" cellPadding="4" border="0" height="150" width="95%" align="center" bgcolor="<%=TableBackColor%>">
<tr bgcolor="<%=TableBodyColor%>">
<td rowspan="3" align="center" bgcolor="#DDE1EA">
<select name="college">
<option value="" selected>全 校</option>
<%
sql = "Select DistInct college From [userinfo]"
rs.Open sql,conn,1,1
do while not (rs.BOF or rs.EOF)
Response.Write "<option value='"&rs(0)&"'>"&rs(0)&"</option>"
rs.MoveNext
loop
rs.Close()
%>
</select>
</td>
<td width="334" align="center" bgcolor="#ECEEF2">
<input type="radio" name="Fcondition" value="jiaoyan" ID="Radio1" onclick="onclick="this.form.xl.disabled=1;this.form.jiaoyan_Scondition.disabled=0;this.form.research_Scondition.disabled=1;this.form.first.value='教学研究工作';change(this.form.jiaoyan_Scondition.options[this.form.jiaoyan_Scondition.selectedIndex].text,this.form.jiaoyan_Scondition.options[this.form.jiaoyan_Scondition.selectedIndex].value);">
<label for="Radio1">教学研究</label>
</td>
<td width="151" bgcolor="#DDE1EA" align="center">
<select name="jiaoyan_Scondition" style="COLOR: #0000ff; BACKGROUND-COLOR: #ffffcc" disabled onchange="change(this.form.jiaoyan_Scondition.options[this.form.jiaoyan_Scondition.selectedIndex].text,this.form.jiaoyan_Scondition.options[this.form.jiaoyan_Scondition.selectedIndex].value)">
<option value="1">在研课题</option>
<option value="2">发表论文</option>
<option value="3">发表论著</option>
<option value="4">获奖情况</option>
</select>
</td>
<td rowspan="3" width="120">关键字：<input type="text" name="keywords" value="" class="text" size="10"></td>
<td rowspan="3" align="center" width="60" bgcolor="#DDE1EA"><input type="submit" name="submit" value=" 搜 索 " onMouseOver="this.className='button1_o';"
onMouseOut="this.className='button1';" class="button1"></td>
</tr>
<tr bgcolor="<%=TableBodyColor%>">
<td align="center">
<input type="radio" name="Fcondition" value="research" ID="Radio2" onclick="this.form.jiaoyan_Scondition.disabled=1;this.form.xl.disabled=1;this.form.research_Scondition.disabled=0;this.form.first.value='科研工作';change(this.form.research_Scondition.options[this.form.research_Scondition.selectedIndex].text,this.form.research_Scondition.options[this.form.research_Scondition.selectedIndex].value)">
<label for="Radio2">科</label><label for="Radio1">学研究</label>
</td>
<td bgcolor="#ECEEF2" align="center">
<select name="research_Scondition" style="COLOR: #0000ff; BACKGROUND-COLOR: #ffffcc" disabled onchange="change(this.form.research_Scondition.options[this.form.research_Scondition.selectedIndex].text,this.form.research_Scondition.options[this.form.research_Scondition.selectedIndex].value)">
<option value="1">在研课题</option>
<option value="2">发表论文</option>
<option value="3">发表论著</option>
<option value="4">获奖情况</option>
</select>
</td>
</tr>
<tr bgcolor="<%=TableBodyColor%>">
<td align="center" bgcolor="#ECEEF2">
<input type="radio" name="Fcondition" value="js" ID="Radio3" onclick="this.form.xl.disabled=0;this.form.jiaoyan_Scondition.disabled=1;this.form.research_Scondition.disabled=1;this.form.first.value='教师查询';change(this.form.xl.options[this.form.xl.selectedIndex].text,this.form.xl.options[this.form.xl.selectedIndex].value)">教师查询</td>
<td bgcolor="#FFFFFF" align="center">
<select style="COLOR: #0000ff; BACKGROUND-COLOR: #ffffcc" size="1" name="xl">
<option value="教授">教授</option>
<option value="副教授">副教授</option>
<option value="博士">博士</option>
<option value="硕士">硕士</option>
<option value="学士">学士</option>
<option value="大专">大专</option>
</select></td>
</tr>
</table>
<%end if%>
</form>
<%
'教研研工作——在研课题
sub jiaoyan_zykt
total = 0
j = 0
i = 0
rs.Open sql,conn,1,1
%>
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center"
ID="Table4">
<tr style="BACKGROUND-IMAGE: url('../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Images/title1.gif');">
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>课题名称</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>起止年月</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>经 费</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>项目来源</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>主持人</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>合作人</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>年 度</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>添加人</b></td>
</tr>
<%
if rs.BOF or rs.EOF then
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
else
total = rs.RecordCount
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs("name")%>
</td>
<td>
<%=rs("startendTime")%>
</td>
<td>
<%=rs("lessonName")%>
</td>
<td>
<%=rs("Froming")%>
</td>
<td>
<%=rs("worker")%>
</td>
<td>
<%=rs("worker")%>
</td>
<td>
<%=rs("yearinfo")%>
</td>
<td>
<a href="MyProfile.asp?id=<%=rs("owner")%>" target="_blank" title="查看该教师的档案资料"><%=rs("adder")%></a>
</td>
</tr>
<%
i = i + 1
rs.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="11">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table18">
<tr>
<td align="right">
共有 <font color="red"><b>
<%=total%>
</b></font>条符合条件的资料
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
<%
rs.Close()
end sub
'教研研工作——发表论文
sub jiaoyan_fblw
total = 0
j = 0
i = 0
rs.Open sql,conn,1,1
%>
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center" ID="Table1">
<tr style="BACKGROUND-IMAGE: url('../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Images/title1.gif');">
<td style="background-image: url('')" bgcolor="#BEC7D6">
<b>论文题目</b></td>
<td style="background-image: url('')" bgcolor="#BEC7D6">
<b>发表刊物</b></td>
<td style="background-image: url('')" bgcolor="#BEC7D6">
<b>第一作者</b></td>
<td style="background-image: url('')" bgcolor="#BEC7D6">
<b>合作者</b></td>
<td style="background-image: url('')" bgcolor="#BEC7D6">
<b>年.卷.期.页码</b></td>
<td style="background-image: url('')" bgcolor="#BEC7D6">
<b>年 度</b></td>
</tr>
<%
if rs.BOF or rs.EOF then
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
else
total = rs.RecordCount
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs("name")%>
</td>
<td>
<%=rs("lessonName")%>
</td>
<td>
<%=rs("author")%>
</td>
<td>
<%=rs("worker")%>
</td>
<td>
<%=rs("Froming")%>
</td>
<td>
<%=rs("yearinfo")%>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -