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">
<%
'*****************************************************************

session("tb_name")="lecturer"
%>

<%
'*****************************************************************
  if session("tb_preview") <> 1 or session("id_lecturer1") = id_lecturer then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

<tr>

<td width="892" align="left" valign="top"><div align="center">
	<%if session("tb_edit") = 2 then %>[ <a href="add_schedule1_form.asp">+���������ŵ��ҧ���¹+</a>]
	<%end if%><br><strong>��͡��������´����Ԫ�㹵��ҧ�͹<br><br>
	<table align=center border=0>
	<tr>
<%
id_schedule=request("id_schedule")
id_course=request("id_course")

session("id_schedule")=id_schedule
session("id_course")=id_course
sql_check="select * from course_schedule3 where id_schedule='"&id_schedule&"' and id_course='"&id_course&"'"
set ors_check=server.createobject("adodb.recordset")
ors_check.open sql_check,conn,1,3
if not ors_check.eof then
'response.write "�����ū������"
		sql_stu1="select * from course_schedule where id_schedule='"&id_schedule&"'"
		set ors_stu1=server.createobject("adodb.recordset")
		ors_stu1.open sql_stu1,conn,1,3
		if not ors_stu1.eof then
'�ʴ���ǵ��ҧ���¹
'��������Ե
	sql_stu="select * from student_group where id_stugroup='"&ors_stu1("id_stugroup")&"'"
	set ors_stu=server.createobject("adodb.recordset")
	ors_stu.open sql_stu,conn,1,3
		if not ors_stu.eof then
					ors_stu.movefirst
					do while not ors_stu.eof

response.write "<tr><td>���ҧ���¹ - �ͺ  �дѺ  "
		
					id_curriculum=ors_stu("id_curriculum")
					sql_curri="select * from curriculum where id_curriculum='"&id_curriculum&"'"
					set ors_curri=server.createobject("adodb.recordset")
					ors_curri.open sql_curri,conn,1,3
					response.write  ors_curri("curriculum_full")&"</td><td>"
					id_major=ors_stu("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
					response.write ors_major("major_th")&"</td>"

response.write "<td>Ẻ</td><td>"
					id_type_curr=ors_stu("id_type_curri")

set ors_tc=server.createobject("adodb.recordset")
					sqlmark_tc="select * from type_curriculum where id_type_curri='"&id_type_curr&"'"
					ors_tc.open sqlmark_tc,Conn,1,3

response.write ors_tc("type_curri_th")&"</td><td>�Ҥ���¹���  "&ors_stu1("id_academic_semeter")&"  (�Ҥ"
					sql_end="select * from academic_semeter where id_academic_semeter ='"&ors_stu1("id_academic_semeter")&"'"
					set ors_end=server.createobject("adodb.recordset")
					ors_end.open sql_end,conn,1,3
					response.write ors_end("academic_semeter")&")</td><td>�ա���֡��  "
					response.write ors_stu1("id_academic_year")&"</td></tr>"
					ors_stu.movenext
			loop

end if
		end if '�ͧ sql_stu1
		response.write "<tr><td colspan=6>����Ԫ� "&id_course_eng&"</td></tr>"
		response.write "</table>"
		
'�ա���֡��
'����ش�ʴ���ǵ��ҧ���¹
'response.write "<tr ><td colspan=6>"
						response.write "<table border=0>"	
						response.write "<tr><td colspan=5><div align=center><strong>��������´�Ԫ�㹵��ҧ�͹</td></tr>"
sql_course="select * from course where id_course='"&id_course&"'"
					   set ors_course=server.createobject("adodb.recordset")
					   ors_course.open sql_course,conn,1,3
									if not ors_course.eof then		
									'ors_course.movefirst
									'do while not ors_course.eof
	
									
									response.write "<tr>"
									response.write  "<td colspan=3> <strong> "&ors_course("id_course_th")
									response.write"  <strong>"&ors_course("course_th")
									response.write " <strong> "&ors_course("credit")&"</td></tr>"
									
						'ors_course.movenext
						'loop
				end if
				%>
<form name="frm1" method="post" action="edit_course_schedule.asp"><%
response.write "<tr><td colspan=2><div align=center><strong>***���������ä**</td></tr>"
response.write "<tr><td><div align=right>�͹</td><td><input type=text name=sec_tion value="&ors_check("sec_tion")&" style=font-size=16px></td></tr>"
response.write "<tr><td><div align=right>�ѹ</td><td><input type=text name=id_date value="&ors_check("id_date")&" style=font-size=16px></td></tr>"
response.write "<tr><td><div align=right>����</td><td><input type=text name=time_learn value="&ors_check("time_learn")&" style=font-size=16px></td></tr>"
response.write "<tr><td><div align=right>��ͧ���¹</td><td><input type=text name=room_learn value="&ors_check("room_learn")&" style=font-size=16px></td></tr>"
response.write "<tr><td><div align=right>�����ͺ / ��ͧ�ͺ</td><td><input type=text name=room_test value="&ors_check("room_test")&" style=font-size=16px></td></tr>"
response.write "<tr><td><div align=right>�ӡѴ �����������¹</td><td><input type=text name=stu_learn value="&ors_check("stu_learn")&" style=font-size=16px></td></tr>"
				
					response.write "</table><br><table border=0>"

response.write "<tr><td colspan=2 ><div align=center><input type=submit name=Submit value=Submit ></td></tr>"
response.write "</form>"
else
'response.write "�ѹ�֡��"%>
<form name="frm2" method="post" action="add_course_schedule.asp">
<%
sql_stu1="select * from course_schedule where id_schedule='"&id_schedule&"'"
		set ors_stu1=server.createobject("adodb.recordset")
		ors_stu1.open sql_stu1,conn,1,3
		if not ors_stu1.eof then
'�ʴ���ǵ��ҧ���¹
'��������Ե
	sql_stu="select * from student_group where id_stugroup='"&ors_stu1("id_stugroup")&"'"
	set ors_stu=server.createobject("adodb.recordset")
	ors_stu.open sql_stu,conn,1,3
		if not ors_stu.eof then
					ors_stu.movefirst
					do while not ors_stu.eof

response.write "<td>Ẻ</td><td>"
					id_type_curr=ors_stu("id_type_curri")

set ors_tc=server.createobject("adodb.recordset")
					sqlmark_tc="select * from type_curriculum where id_type_curri='"&id_type_curr&"'"
					ors_tc.open sqlmark_tc,Conn,1,3

response.write "<tr><td><div align=right>�͹</td><td><input type=text name=sec_tion></td></tr>"
response.write "<tr><td><div align=right>�ѹ</td><td>"
response.write "<select name=id_date>"
response.write "<option value=ARR>ARR</option>"
response.write "<option value=�ѹ���>�ѹ���</option>"
response.write "<option value=�ѧ���>�ѧ���</option>"
response.write "<option value=�ظ>�ظ</option>"
response.write "<option value=����ʺ��>����ʺ��</option>"
response.write "<option value=�ء��>�ء��</option>"
response.write "<option value=�����>�����</option>"
response.write "<option value=�ҷԵ��>�ҷԵ��</option>"
response.write "</select>"
response.write "</td></tr>"
response.write "<tr><td><div align=right>����</td><td><input type=text name=time_learn ></td></tr>"
response.write "<tr><td><div align=right>��ͧ���¹</td><td><input type=text name=room_learn ></td></tr>"
response.write "<tr><td><div align=right>�����ͺ / ��ͧ�ͺ</td><td><input type=text name=room_test ></td></tr>"
response.write "<tr><td><div align=right>�ӡѴ �����������¹</td><td><input type=text name=stu_learn ></td></tr>"

response.write "<tr><td colspan=2 ><div align=center><input type=submit name=Submit value=Submit ></td></tr>"
response.write "</form>"

end if
		'response.write "</table>"%>

</form>
	</div></td>
    </table>
 <%	else '���Է�
	response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է�
	end if '���Է�
%>

</table>

</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_course_schedule.asp.bak