File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>�к����ʹ�����͡�ú�����</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<link href="bsri2006.css" rel="stylesheet" type="text/css">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0">
  <tr> 
    <td colspan="2"><div align="right"><img src="Image/head1.gif" width="800" height="61"></div></td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif"><div align="right"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong>| 
        <a href="http://www.swu.ac.th" target=_blank>SWU</a> | <a href="http://bsri.swu.ac.th" target=_blank>BSRI</a> 
        |<a href="chaPW.asp"><strong>Change 
        Password</strong></a>|<a href="log_out.asp">Log Out </a></strong></font>|</div></td>
  </tr>
  <tr> 
    <td width="20%" align="left" valign="top" bgcolor="#FFCCCC"></td>
    <td width="77%" align="left" valign="top">
<table width="100%" border="0" cellspacing="0">
  <tr> 	<%	
	session("tb_name")="lecturer"%>

	<%
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

'if session("tb_preview") <> 1 or session("id_lecturer1") = orsall("id_lecturer") then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ
 %>
 <td width="892" align="left" valign="top" ><div align="center"><font size=2>
 <% 
 if session("tb_edit")=2 then
%>
<strong>[<a href=add_lec_form.asp>+�����������Ҩ����+</a>][<a href=all_lecturer.asp>�ʴ��������Ҩ���������</a>]<br>

<%
end if
%>
<br> <br><br><strong>�������Ҩ����</strong><br><br>
[<a href=detail_lec.asp?id_lecturer=<%=id_lecturer%>>˹���á <%=id_lecturer%></a>] <br><br>
	<table border=0>
	<%
	response.write "<tr><td>"&id_lecturer&" "&orsall("name_lec")&" "&orsall("sur_lec")
	%>

</table></div></td><%
'����ش����ʴ���������ǹ���
'�ʴ������š���֡��

set ors_vita=server.createobject("adodb.recordset")
							sql_vita="select * from education_vita where id_staff="&id_lecturer&" order by id_curriculum desc"
							ors_vita.open sql_vita,conn,1,3
							'2
				response.write "<table align=center border=0>"
				if session("tb_edit")=2 or session("id_lecturer1")=id_lecturer then
				response.write "<tr><td colspan=7><div align=center><strong><br><br>[<a href=add_lec_edu_vita_form.asp?id_lecturer="&id_lecturer&">����ѵԡ���֡��</a>]"
				else
				response.write "<tr><td colspan=7><div align=center><strong><br><br>����ѵԡ���֡��</a>"

end if

response.write "<tr bgcolor=#F2F2F2><td><strong>�շ�診<td><strong>�дѺ<td><strong>�زԡ���֡��<td><strong>�Ң�<td><strong>ʶҺѹ<td><strong>�����"
							if not ors_vita.eof then
							'�����
										if session("tb_edit")=2 or session("id_lecturer1")=orsall("id_lecturer") then
										id_=orsall("id_lecturer")
										response.write "<td><strong>Action</tr>"
										end if
							
ors_vita.movefirst
									do while not ors_vita.eof
								response.write "<tr>"
									response.write "<td>"&ors_vita("finish_edu_year")

id_curriculum=ors_vita("id_curriculum")
									 set ors_cu=server.createobject("adodb.recordset")
									 sql_cu="select * from curriculum where id_curriculum="&id_curriculum&""
									 ors_cu.open sql_cu,conn,1,3
									 if not ors_cu.eof then
											response.write "<td>"&ors_cu("curriculum_full")
									end if
									'set ors_edu=server.createobject("adodb.recordset")
									'sql_edu="select * from education_bg where id_edu_bg_t="&ors_vita("id_edu_bg_t")&""
									'ors_edu.open sql_edu,conn,1,3
									'if not ors_edu.eof then
									'response.write "<td>"&ors_edu("edu_th_full")&"("&ors_edu("edu_th")&")"
									response.write "<td>"&ors_vita("id_edu_bg_t")&"("&ors_vita("id_edu_bg_t_sub")&")"
											
									'end if

'set ors_ma=server.createobject("adodb.recordset")
									'		sql_ma="select * from major where id_major="&ors_vita("id_edu_major")&""
									'		ors_ma.open sql_ma,conn,1,3
									'		if not ors_ma.eof then
									'response.write "<td>"&ors_ma("major_th")&"<br>("&ors_ma("major_eng")&")"
									response.write "<td>"&ors_vita("id_major_t")&"<br>("&ors_vita("id_major_e")&")"
									'end if
									'set ors_cam=server.createobject("adodb.recordset")
									'sql_cam="select * from campus where id_campus="&ors_vita("id_campus")&""
									'ors_cam.open sql_cam,conn,1,3
									'if not ors_cam.eof then

response.write "<td>"&ors_vita("id_campus_t")
									response.write "<td>"&ors_vita("country_e")'&""&orsall("id_lecturer")&""&session("id_lecturer1")
									'end if

if session("tb_edit")=2 or session("id_lecturer1")=orsall("id_lecturer") then
										'response.write "<td>[<a href=edit_lec_edu_vita_form.asp?id_lecturer="&id_lecturer&"&id_curriculum="&id_curriculum&"&id_edu_bg="&ors_vita("id_edu_bg")&"&id_edu_major="&ors_vita("id_edu_bg")&">Edit</a>]"
										response.write "<td>[<a href=edit_lec_edu_vita_form.asp?id_edu_vita="&ors_vita("id_edu_vita")&"&id_lecturer="&id_lecturer&">Edit</a>] /"%>
										[<a href=del_lec_edu_vita.asp?id_edu_vita=<%=ors_vita("id_edu_vita")%>&id_lecturer=<%=id_lecturer%> onClick="return confirm('Are you sure');">Del</a>]
									<%

end if
										response.write "</tr>"
								ors_vita.movenext
									loop
						
							'2
							else
							response.write "<tr><td colspan= 7><div align=center>No Data"
							
							'2
							end if
							'if session("tb_edit")=2 or session("id_lecturer1")=id_lecturer then
				'response.write "<tr><td colspan=7><div align=center><strong>[<a href=add_lec_edu_vita_form.asp?id_lecturer="&id_lecturer&">�ҹ�Ԩ��</a>]"
				'else
				response.write "</table>"
				'response.write "<br>"
				'response.write "<div align=center><strong>�ҹ�Ԩ��</strong>"
				
				
	end if
	%>

</td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif">Contact Admin:: wassanaw@swu.ac.th 
      tel.02-649-5000 ext 17600</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: edu_lec.asp