bigsearch.asp

东北农业大学教学管理系统

			</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>
			</tr>
			<%
				next
				end if
				%>
				<tr bgcolor="<%=TableLeftColor%>">
					<td colspan="11">
						<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table17">
							<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_fblz
	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="Table2">
			<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>
			</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>
			</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("startendTime")%>
				</td>
				<td>
					<%=rs("Froming")%>
				</td>
				<td>
					<%=rs("yearinfo")%>
				</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>
			</tr>
			<%
				next
				end if
				%>
				<tr bgcolor="<%=TableLeftColor%>">
					<td colspan="11">
						<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table16">
							<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_hjqk
	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="Table3">
			<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("lessonName")%>
				</td>
				<td>
					<%=rs("author")%>
				</td>
				<td>
					<%=rs("worker")%>
				</td>
				<td>
					<%=rs("startendTime")%>
				</td>
				<td>
					<%=rs("unit")%>
				</td>
				<td>
					<%=rs("Froming")%>
				</td>
				<td>
					<%=rs("yearinfo")%>
				</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="Table15">
							<tr>
								<td align="right">
									共有 <font color="red"><b>
											<%=total%>
										</b></font>条符合条件的资料
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<%
				end if
				%>
		</table>
		<%
	rs.Close()
	end sub
	'科研工作——在研课题
	sub research_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="Table5">
			<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>
			</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>
			</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("lessonName")%>
				</td>
				<td>
					<%=rs("startendtime")%>
				</td>
				<td>
					<%=rs("Froming")%>
				</td>
				<td>
					<%=rs("unit")%>
				</td>
				<td>
					<%=rs("yearinfo")%>
				</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>
			</tr>
			<%
				next
				end if
				%>
				<tr bgcolor="<%=TableLeftColor%>">
					<td colspan="11">
						<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table14">
							<tr>
								<td align="right">
									共有 <font color="red"><b>
											<%=total%>
										</b></font>条符合条件的资料
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<%
				end if
				%>
		</table>
		<%
			rs.Close()
	end sub
	'科研工作——发表论文
	sub research_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="Table6">
			<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>
			</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