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

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

<%
'*****************************************************************
  if session("tb_preview") <> 1  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 bgcolor="#CCCCCC"><td align=center><strong>���ʵ��ҧ���¹</td><td align=center><strong>��������Ե</td><td  ><div align="center"><strong>�Ҥ���¹���</td><td  ><div align="center"><strong>����Ԫ�</td><td align=center><strong>ŧ����¹(��)</td> <%
'027891000
sqlall="select * from course_schedule order by id_academic_year desc, id_academic_semeter desc"
set orsall=server.createobject("adodb.recordset")
orsall.open sqlall,conn,1,3
if not orsall.eof then
a=0
orsall.movefirst
do while not orsall.eof
a=a+1
if a mod 2 =0 then
bg1="#EAEAEA"
else
bg1="#FFFFFF"
end if
response.write "<tr bgcolor="&bg1&"><td>[<a href=add_schedule1.asp?id_schedule="&orsall("id_schedule")&">"&orsall("id_schedule")&"</a>]</td>"

'response.write "<td>"
'aaaaaaaaa
sqls="select * from student_group where id_stugroup='"&orsall("id_stugroup")&"'"
	set orss=server.createobject("adodb.recordset")
	orss.open sqls,conn,1,3
	if not orss.eof then

sqlc="select * from curriculum where id_curriculum='"&orss("id_curriculum")&"'"
	set orsc=server.createobject("adodb.recordset")
	orsc.open sqlc,conn,1,3
	if not orsc.eof then
           sqlt="select * from type_curriculum where id_type_curri='"&orss("id_type_curri")&"'"
		   set orst=server.createobject("adodb.recordset")
		   orst.open sqlt,conn,1,3
		   if not orst.eof then
	response.write"</td><td>"&orsc("curriculum_sum")&" "&orst("type_curri_th")&" ��� "&orss("no_stugroup")&"</td>"				
		   end if
end if
end if

'response.write orsall("id_stugroup")&"</td>"
		response.write "<td><div align=center>"&orsall("id_academic_semeter")&"/"&orsall("id_academic_year")&"</td>"	
		'response.write "<td><div align=center>"&orsall("id_academic_semeter")&"</td>"	
		sqlcc="select *  from course_schedule1 where id_schedule='"&orsall("id_schedule")&"'"
		set orscc=server.createobject("adodb.recordset")
		orscc.open sqlcc,conn,1,3
		if not orscc.eof then
		cc=0
		orscc.movefirst
		do while not orscc.eof
		cc=cc+1
		orscc.movenext
		loop
		response.write "<td align=center>"&cc
		end if
								sqlcr="select * from course_regis where id_schedule='"&orsall("id_schedule")&"'"
									set orscr=server.createobject("adodb.recordset")
									orscr.open sqlcr,conn,1,3
									if not orscr.eof then
									cr=0
									orscr.movefirst
									do while not orscr.eof
									cr=cr+1
									orscr.movenext
									loop
									response.write "<td align=center>[<a href=all_register_schedule.asp?id="&orsall("id_schedule")&">"&cr&"</a>]"
									end if

response.write "</tr>"

orsall.movenext
loop
conn.close

else
response.write "<tr><td colspan=2><br><div align=center>No Schedule</td></tr>"
end if
%>
	</tr>
	</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: index_schedule.asp