Editing: save_report_thesis_progress_student.asp

<!--#include file="inc_cache_control.asp"--> <!--#include file="inc_access_control.asp"--> <!--#include file="chk_login.asp"--> <% '***************************************************************** session("tb_name")="student" %> <!--#include file="chk_permission.asp"--> <% '***************************************************************** ' if session("tb_edit") <> 1 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ if session("tb_edit")=2 or session("id_stu1") = id_stu then %> <form name="form1" Action = "report_thesis_progress_student_form.asp" method="post"> <% id_progress_report=request.form("id_progress_report") id_thesis=request.form("id") id_stu=request.form("id_stu") id_activity=request.form("id_activity") activity_result=request.form("activity_result") id_table=request.form("id_table") advisor_name1=request.form("advisor_name1") advisor_name2=request.form("advisor_name2") thesis_name=request.form("thesis_name") id_result=request.form("id_result") activity_problem=request.form("activity_problem") id_activity_r=request.form("id_activity_r") activity_hand=request.form("activity_hand") 'id_softskill_type=request.form("id_softskill_type") activity_name=request.form("activity_name") date_attend_begin=request.form("date_attend_begin") date_attend_end=request.form("date_attend_end") activity_hours=request.form("activity_hours") organizer_name=request.form("organizer_name") score_get=request.form("score_get") id_attend_num=request.form("id_attend_num") con_name=request.form("con_name") 'organizer_name=request.form("organizer_name") vanue=request.form("vanue") city=request.form("city") country=request.form("country") date_begin=request.form("date_begin") date_end=request.form("date_end") summary_sitin=request.form("summary_sitin") url_article=request.form("url_article") page_end=request.form("page_end") page_begin=request.form("page_begin") journal_issue=request.form("journal_issue") journal_year=request.form("journal_year") journal_name=request.form("journal_name") title_article=request.form("title_article") title_article_eng=request.form("title_article_eng") date_present=request.form("date_present") id_grade=request.form("id_grade") 'date_create=Date %> <!--#include file="fdate.asp"--> <% 'd_report=day(Now()) 'm_report=month(Now()) 'y_report=year(Now())+543 'year_end=request.form("year_end") 'year_begin=request.form("year_begin") 'month_begin=request.form("month_begin") 'month_end=Request.form("month_end") 'id_activity_r=request.form("id_activity_r") id_status="1" 'activity_name=request.form("activity_name") 'expect_result=request.form("expect_result") 'activity_problem=request.form("activity_problem") 'date_save=Date 'year_begin2=right(year_begin,2) 'year_end2=Right(year_end,2) 'date_begin=year_begin2+month_begin 'date_end=year_end2+month_end id_staff=session("id_staff1") 'Response.write date_save 'datebegincheck=request.form("datebegincheck") 'dateendcheck=request.form("dateendcheck") 'Response.write "<br>aaa"&id_activity&"bbb"&thesis_name sql_c="select * from thesis_plan_activity where id_activity='"&id_activity&"'" Set ors_c=server.createobject("adodb.recordset") ors_c.open sql_c,conn,1,3 If not ors_c.eof then sqldata="update thesis_plan_activity set activity_result='"&activity_result&"', activity_hand='"&activity_hand&"', activity_problem='"&activity_problem&"', id_result='"&id_result&"' where id_activity='"&id_activity&"'" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 'response.write sqldata 'Response.write date_create&"date" If id_table=11 Then %> <!--#include file="add_rp_thesis_progress.asp"--> <% ElseIf id_table=3 Then %> <!--#include file="rp_add_qe.asp"--> <% Elseif id_table=4 Then %> <!--#include file="rp_add_exitexam.asp"--> <% ElseIf id_table=6 Then '������������Ъ���Ԫҡ�� attend �ѧ�����ӹ� ' %> <!--#include file="rp_add_conattend.asp"--> <% ElseIf id_table=5 Then '��ù��ʹͼŧҹ�ҧ�Ԫҡ�� rp_conference %> <!--#include file="rp_add_conferrence.asp"--> <% ElseIf id_table=7 Then '�觺������վ���� %> <!--#include file="rp_add_article.asp"--> <% ElseIf id_table=8 Or id_table=15 Then 'rp_softskill %> <!--#include file="rp_add_softskill.asp"--> <% ElseIf id_table=12 Then 'rp_sitin ����֡��������� (Sit in) ' %> <!--#include file="rp_add_sitin.asp"--> <% ElseIf id_table=13 Then 'rp_softskill %> <!--#include file="rp_add_parcurri.asp"--> <% ElseIf id_table=14 Then 'rp_softskill %> <!--#include file="rp_add_grd.asp"--> <% End if 'sqldata="update thesis_plan_activity set activity_name='"&activity_name&"', id_activity_r='"&id_activity_r&"' where id_activity='"&id_activity&"'" Else End If 'response.write "<meta http-equiv='refresh' content ='0;url=report_thesis_progress_student_form.asp'>" ' %> <input type="hidden" name="id_activity" value=<%=id_activity%>> <script type="text/javascript"> document.form1.submit(); </script> </FORM> <% else '���Է� response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��" response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է� end if '���Է� %>