File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>ʶҺѹ�Ԩ�¾ĵԡ�����ʵ�� ICT</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="bsri2006.css" rel="stylesheet" type="text/css">
</head>
	
<body>
<table width="100%" border="0" cellspacing="1">
  <tr> 
    <td><div align="right"><img src="Image/head1.gif" width="800" height="61"></div></td>
  </tr>
  <tr> 
    <td background="Image/bggreen.gif"><div align="center"><strong>��¡��ʶҹй��Ե�Ѩ�غѹ(��ԭ�ҹԾ���)</strong></div></td>
  </tr>
  <tr> 
    <td valign="top"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="1" bordercolor="#CCFFCC">
	  <tr><td colspan="8">[<a href=list_status_stu.asp?c1=1&t1=2>�-�����</a>][<a href=list_status_stu.asp?c1=1&t1=7>�-�͡����</a>][<a href=list_status_stu.asp?c1=2&t1=4>�͡���Ԩ��</a>][<a href=list_status_stu.asp?c1=2&t1=5>�͡������Ԫ�</a>] [<a href=list_status_stu.asp?c1=2&t1=9>�͡-�Ǻ�</a>][<a href=list_status_stu.asp?c1=2&t1=3>�͡-������ͧ</a>]
	  [<a href=search_status_stu.asp>����</a>]
	  [<a href=advisor_thesis2.asp>�Ҩ�������֡��</a>]�ѹ����ѹ=<%=now()%></td>
        </tr>
<table border="1" cellspacing="0" bordercolor="#FFffcc" align=center><tr><td>
<table align=center >
<tr><td colspan=3><strong><div align=center>��������´����繤�С�����äǺ�����ԭ�ҹԾ���</strong><br>
<%
id_lecturer=request("id_lecturer")
if id_lecturer="" then
id_lecturer=session("id_lecturer1")
end if
sqlall="select * from lecturer where id_lecturer="&id_lecturer&""
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		response.write orsall("name_lec")&"  "&orsall("sur_lec")
		end if
%>

<br><br></td></tr>
<tr bgcolor="#FFccCC"><td><div align="center"><strong>���ʹ��Ե<td><div align="center"><strong>����-ʡ�Ź��Ե<td><div align="center"><strong>������֡��<td><div align="center"><strong>���˹�<td><div align="center"><strong>�ͺ����ç<td><div align="center"><strong>�ͺ�ҡ����</tr>
<%

sql_="select * from student where id_status_edu=2 order by id_stu,f_edu desc"
	set ors_=server.createobject("adodb.recordset")
	ors_.open sql_,conn,1,3
	if not ors_.eof then
ors_.movefirst
a=1
do while not ors_.eof 
							bg1=a mod 2
					      if bg1=0 then
							bg="#d4d5d7"
							else bg="#ffffff"
						end if
sqlthesis="select * from advisor_thesis where id_lecturer='"&id_lecturer&"' and id_stu='"&ors_("id_stu")&"' and id_position_thesis=1"
set orsthesis=server.createobject("adodb.recordset")
orsthesis.open sqlthesis,conn,1,3
if not orsthesis.eof then			 
		response.write "<tr bgcolor="&bg&"><td>"&ors_("id_stu")&"<td>"&ors_("name_stu")&" "&ors_("sur_stu")&"<td align=center>"&ors_("f_edu_semeter")&"/"&ors_("f_edu_year")&"</td>"
			'sqlstu="select * from thesis where id_stu='"&ors_("id_stu")&"'"
			'set orsstu=server.createobject("adodb.recordset")
			'orsstu.open sqlstu,conn,1,3
			'if not orsstu.eof then

sqlpo="select * from position_thesis where id_position_thesis='"&orsthesis("id_position_thesis")&"'"
										set orspo=server.createobject("adodb.recordset")
										orspo.open sqlpo,conn,1,3
										if not orspo.eof then
						
'response.write "<tr><td>[<a href=add_advisor_thesis_form.asp?id_stu="&orsstu("id_stu")&"&id_thesis="&orsthesis("id_thesis")&">"&orsthesis("id_thesis")&"</a>]<td>"&ors_("name_stu")&" "&ors_("sur_stu")&"<td>"&orspo("position_thesis")&"<td>"&orsstu("id_course_eng")&"<td>"&orsstu("id_academic_semeter")&"/"&orsstu("academic_year")&"<td>"&orsstu("date_approve_oral")
response.write "<td>"&orspo("position_thesis")

sql5="select * from thesis_test where id_thesis='"&orsthesis("id_thesis")&"'and id_type_test=1"
						set ors5=server.createobject("adodb.recordset")
						ors5.open sql5,conn,1,3
							if not ors5.eof then

response.write "<td><div align=center>"&ors5("date1")&"-"&ors5("month1")&"-"&ors5("year1")
							else response.write "<td>-</td>"
							end if
						sql6="select * from thesis_test where id_thesis='"&orsthesis("id_thesis")&"' and id_type_test=2"
						set ors6=server.createobject("adodb.recordset")
						ors6.open sql6,conn,1,3
							if not ors6.eof then
									response.write "<td><div align=center>"&ors6("date1")&"-"&ors6("month1")&"-"&ors6("year1")
							else response.write "<td>-</td>"
							end if
										end if
							'end if
			end if
a=a+1
ors_.movenext

loop
else
response.write "<tr><td colspan=3><div align=center>No Student Advisor"
end if
%>

</td></tr></table></table>

</table> </td>
  </tr>
  <tr> 
    <td background="Image/bggreen.gif">&nbsp;</td>
  </tr>

</table>
</body>
</html>

File Manager

Editing: detail_advisor_thesis2.asp.bak