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=edu_lec.asp?id_lecturer=<%=id_lecturer%>>����ѵԡ���֡��</a>] [<a href=finish_res_lec.asp?id_lecturer=<%=id_lecturer%>>�ҹ�Ԩ�·����Թ����������</a>] [<a href=inpro_res_lec.asp?id_lecturer=<%=id_lecturer%>>�ҹ�Ԩ�·����ѧ���Թ���</a>] [<a href=distri_res_lec.asp?id_lecturer=<%=id_lecturer%>>��������ҹ�Ԩ��</a>] [<a href=getreward_lec.asp?id_lecturer=<%=id_lecturer%>>�ҹ�Ԩ�·�����Ѻ�ҧ���</a>][<a href="letins_sum.asp?ids=<%=id_lecturer%>">˹ѧ������</a><br>[ <a href="detail_advisor_thesis.asp?id_lecturer=<%=id_lecturer%>">��ä����ԭ�ҹԾ���</a> ]
<%
editor_journal=orsall("editor_journal")
if editor_journal="1" then
'response.write "[<a href=editor_journal.asp?id_editor="&id_lecturer&">�����þĵԡ�����ʵ��</a>]"
response.write "[<a href=journal/editor_journal.asp>�����þĵԡ�����ʵ��</a>]"
session("editorj")=editor_journal
end if
%>
<br>
<br>
	<table border=0>
	<%
	response.write "<tr><td>���ʻ�Шӵ�� </td><td>"&id_lecturer&"</td>"

response.write "<td colspan=2 rowspan=10><div align=center><img src=pic_lec/"&orsall("picture_lec")&"  width=150></td></tr>"

sql_admin="select * from administrator_position where id_administor ="&orsall("id_administor")&""
	  set ors_admin=server.createobject("adodb.recordset")
	  ors_admin.open sql_admin,conn,1,3
response.write "<tr><td>���˹觷ҧ������</td><td>"&ors_admin("administor")&"</td></tr>"
	  sql_academic="select * from academic_position where id_academic ="&orsall("id_academic")&""
	  set ors_academic=server.createobject("adodb.recordset")
	  ors_academic.open sql_academic,conn,1,3
response.write "<tr><td>���˹觷ҧ�Ԫҡ��</td><td>"&ors_academic("academic")&"</td></tr>"
   '   sql_o_po="select * from other_position where id_other_position="&orsall("id_other_position")&""
	 ' set ors_o_po=server.createobject("adodb.recordset")
	 ' ors_o_po.open sql_o_po,conn,1,3
response.write "<tr><td>���˹���� �</td><td>"&orsall("id_other_position")&"</td></tr>"
      sql_pre="select * from preface where id_preface="&orsall("id_preface")&""
	  set ors_pre=server.createobject("adodb.recordset")
	  ors_pre.open sql_pre,conn,1,3
response.write "<tr><td>�ӹ�˹��</td><td>"&ors_pre("preface")&"</td></tr>"
response.write "<tr><td>����</td><td>"&orsall("name_lec")&"</td></tr>"
response.write "<tr><td>���ʡ��</td><td>"&orsall("sur_lec")&"</td></tr>"
response.write "<tr><td>�ѹ��͹���Դ</td><td>"&orsall("bdate_lec")&"</td></tr>"
response.write "<tr><td>�ѹ��͹�շ���è�</td><td>"&orsall("date_entrance")&"</td></tr>"
response.write "<tr><td>�շ�����³</td><td>"&orsall("year_retire")&"</td></tr>"
      sql_sta="select * from status_lec where id_status_lec="&orsall("id_status_lec")&""
	  set ors_sta=server.createobject("adodb.recordset")
	  ors_sta.open sql_sta,conn,1,3
response.write "<tr><td>ʶҹ�</td><td>"&ors_sta("status_lec")&"</td></tr>"
		sql_ad="select * from advisor_student where id_lecturer="&orsall("id_lecturer")&" order by id_year"
		set ors_ad=server.createobject("adodb.recordset")
		ors_ad.open sql_ad,conn,1,3
		if not ors_ad.eof then
		ors_ad.movefirst
		do while not ors_ad.eof
		';;;;;;;;;;;;;;;
		sql_all="select * from student_group where id_stugroup='"&ors_ad("id_stugroup")&"' "
		set ors_all=server.createobject("adodb.recordset")
		ors_all.open  sql_all,Conn,1,3
		if not ors_all.eof then
		response.write "<tr><td>����繷���֡���Ԫҡ��</td>"

sql_curri="select * from curriculum where id_curriculum='"&ors_all("id_curriculum")&"'"
		set ors_curri=server.createobject("adodb.recordset")
		ors_curri.open sql_curri,conn,1,3
		if not ors_curri.eof then
		response.write  "<td>���Ե�дѺ "&ors_curri("curriculum_full")&"</td><td>"
		end if
sqlt="select * from type_curriculum where id_type_curri='"&ors_all("id_type_curri")&"'"
		   set orst=server.createobject("adodb.recordset")
		   orst.open sqlt,conn,1,3
		   if not orst.eof then
		response.write orst("type_curri_th")
			end if
		response.write  "  ��� "&ors_all("no_stugroup")&"</td>"
		id_major=ors_all("id_major")
		sql_major="select * from major  where id_major='"&id_major&"'"
		set ors_major=server.createobject("adodb.recordset")
		ors_major.open sql_major,conn,1,3
		if not ors_major.eof then
		response.write "<td>"&ors_major("major_th")&"</td>"
		end if
		end if
		';;;;
		ors_ad.movenext
		loop
		end if
if session("tb_edit")=2 or session("id_lecturer1")=id_lecturer then
response.write "<tr><td>[<a href=upload_lec_pic_form.asp?id_lecturer="&id_lecturer&">����ٻ�Ҿ </a>]<br>(��Ҵ�Ҿ 150x150 )</td><td>"&orsall("picture_lec")&"</td></tr>"	
response.write "<td><div align=right>[<a href=edit_lec_form.asp?id_lecturer="&orsall("id_lecturer")&">Edit</a>]</td></tr>"
end if
	%>

</table></div></td><%
				''''''''''''''''''
				response.write "</table>"

'end if
				'response.write "<tr bgcolor=#F2F2F2><td><strong>�Ţ����ѭ��<td><strong>����ͧ<td><strong>��м���Ԩ��"
			'
			'response.write "</table>"
			'response.write "</table>"
		'else '���Է�
	'response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
'response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է�
	'end if '���Է�
	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: detail_lec.asp.bak