myprofile.asp

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

					<b>主 编</b></td>
				<td bgcolor="#99A6BF">
					<b>合作者</b></td>
				<td bgcolor="#99A6BF">
					<b>发表时间</b></td>
				<td bgcolor="#99A6BF">
					<b>备 注</b></td>
				<td bgcolor="#99A6BF">
					<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

				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
				end if
				%>
		</table>
		<%
	rs.Close()
	end sub
	'教研研工作——获奖情况
	sub jiaoyan_hjqk
		j = 0
		i = 0
	sql = "Select * From [jiaoyan] Where type = 4 and owner = "&uid
	rs.Open sql,conn,1,1
	%>
		<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center">
			<tr>
				<td bgcolor="#99A6BF">
					<b>获奖名称</b></td>
				<td bgcolor="#99A6BF">
					<b>获奖项目名称</b></td>
				<td bgcolor="#99A6BF">
					<b>主持人</b></td>
				<td bgcolor="#99A6BF">
					<b>合作者</b></td>
				<td bgcolor="#99A6BF">
					<b>时 间</b></td>
				<td bgcolor="#99A6BF">
					<b>授予单位</b></td>
				<td bgcolor="#99A6BF">
					<b>备 注</b></td>
				<td bgcolor="#99A6BF">
					<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

				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
				end if
				%>
		</table>
		<%
	rs.Close()
	end sub
	'科研工作——在研课题
	sub research_zykt
		j = 0
		i = 0
	sql = "Select * From [research] Where type = 1 and owner = "&uid
	rs.Open sql,conn,1,1
	%>
		<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center">
			<tr>
				<td bgcolor="#99A6BF">
					<b>项目名称</b></td>
				<td bgcolor="#99A6BF">
					<b>起止年月</b></td>
				<td bgcolor="#99A6BF">
					<b>项目来源</b></td>
				<td bgcolor="#99A6BF">
					<b>资助金额</b></td>
				<td bgcolor="#99A6BF">
					<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
				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
				end if
				%>
		</table>
		<%
			rs.Close()
	end sub
	'科研工作——发表论文
	sub research_fblw
		j = 0
		i = 0
	sql = "Select * From [research] Where type = 2 and owner = "&uid
	rs.Open sql,conn,1,1
	%>
		<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center">
			<tr>
				<td bgcolor="#99A6BF">
					<b>论文题目</b></td>
				<td bgcolor="#99A6BF">
					<b>发表刊物</b></td>
				<td bgcolor="#99A6BF">
					<b>第一作者</b></td>
				<td bgcolor="#99A6BF">
					<b>合作者</b></td>
				<td bgcolor="#99A6BF">
					<b>年.卷.期.页码</b></td>
				<td bgcolor="#99A6BF">
					<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

				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>
			</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
				end if
				%>
		</table>
		<%
			rs.Close()
	end sub
	'科研工作——论著情况
	sub research_lzqk
		j = 0
		i = 0
	sql = "Select * From [research] Where type = 3 and owner = "&uid
	rs.Open sql,conn,1,1
	%>
		<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center"
			ID="Table9">
			<tr>
				<td bgcolor="#99A6BF">
					<b>论著名称</b></td>
				<td bgcolor="#99A6BF">
					<b>出版社</b></td>
				<td bgcolor="#99A6BF">
					<b>主 编</b></td>
				<td bgcolor="#99A6BF">
					<b>合作者</b></td>
				<td bgcolor="#99A6BF">
					<b>出版时间</b></td>
				<td bgcolor="#99A6BF">
					<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

				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("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>
			</tr>
			<%
				next
				end if
				end if
				%>
		</table>
		<%
	rs.Close()
	end sub
	'科研工作——获奖情况
	sub research_hjqk
		j = 0
		i = 0
	sql = "Select * From [research] Where type = 4 and owner = "&uid
	rs.Open sql,conn,1,1
	%>
		<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center">
			<tr>
				<td bgcolor="#99A6BF">
					<b>获奖名称</b></td>
				<td bgcolor="#99A6BF">
					<b>获奖项目名称</b></td>
				<td bgcolor="#99A6BF">
					<b>主持人</b></td>
				<td bgcolor="#99A6BF">
					<b>合作者</b></td>
				<td bgcolor="#99A6BF">
					<b>时 间</b></td>
				<td bgcolor="#99A6BF">
					<b>授予单位</b></td>
				<td bgcolor="#99A6BF">
					<b>备 注</b></td>
				<td bgcolor="#99A6BF">
					<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

				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
				end if
				%>
		</table>
		<%
			rs.Close()
	end sub
	'出版教材情况
	
	Set rs = Nothing
	
	CloseDataBase
	%>
		<script language="javascript" src="copyright.htm" type="text/javascript"></script>
	</body>
</HTML>