📄 jiaoyan_hjqk.asp
字号:
end sub
'添加学习简历
sub add()
%>
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table3">
<tr>
<td vAlign="top" height="50">
<ol style="line-height:150%">
<li>
添加教师的教研工作的获奖情况资料（包括成果、论文获奖以及其他教学获奖情况）</li>
<li>
要求必须输入真实的资料</li>
</td>
</tr>
<tr>
<td align="center" valign="top">
<input type="hidden" name="act" value="add" ID="Hidden2">
<table width="90%" border="0" cellpadding="4" cellspacing="1" bgcolor="#000000" align="center" ID="Table4">
<tr style="BACKGROUND-IMAGE: url('Images/title1.gif');">
<td colspan="2" align="center" bgcolor="#99A6BF" style="background-image: url('')"><b>教 研 工 作 的 获 奖 情 况 资 料 添 加</b></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" width="30%">
<b>获奖名称：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="name" class="text" ID="Text1" size="60"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" width="30%">
<b>获奖项目名称：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="lessonName" class="text" ID="Text7" size="60"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" width="30%">
<b>主持人：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="author" class="text" ID="Text8" size="60"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>合作者：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="worker" class="text" ID="Password1" size="60"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" valign="top">
<b>时 间：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="startendtime" class="text" ID="Password2" size="60"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>授予单位：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="unit" class="text" ID="Text2" size="60"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>备 注：</b></td>
<td bgcolor="#FFFFFF">
<textarea name="From" class="text" cols="50" rows="5" ID="Textarea1"></textarea></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>年 度：</b></td>
<td bgcolor="#FFFFFF">
<select name="yearInfo" ID="Select1">
<%
for iyear = year(now())-3 to year(now())
response.Write("<option value='"&iyear&"'>"&iyear&"年</option>")
next
%>
</select>
</td>
</tr>
<tr>
<td bgcolor="#99A6BF" align="middle" colspan="2">
<input type="submit" name="submit" value=" 添 加 " onMouseOver="this.className='button1_o';"
onMouseOut="this.className='button1';" class="button1" ID="Submit2">
<input type="reset" name="reset" value=" 重 置 " onMouseOver="this.className='button1_o';"
onMouseOut="this.className='button1';" class="button1" ID="Reset1"></td>
</tr>
</table>
</td>
</tr>
</table>
<%
end sub
'修改学习简历
sub change()
Set rs = Server.CreateObject("ADODB.RecordSet")
sql = "Select * From [jiaoyan] Where id = " & Request.QueryString("id")
rs.Open sql,conn,1,1
if rs.bof or rs.eof then
else
%>
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table5">
<tr>
<td vAlign="top" height="50">
<ol style="line-height:150%">
<li>
修改教师的教研工作的获奖情况资料（包括成果、论文获奖以及其他教学获奖情况）</li>
<li>
要求必须输入真实的资料</li>
</td>
</tr>
<tr>
<td align="center" valign="top">
<input type="hidden" name="act" value="change" ID="Hidden3"> <input type="hidden" name="id" value="<%=Request.QueryString("id")%>" ID="Hidden4">
<table width="90%" border="0" cellpadding="4" cellspacing="1" bgcolor="#000000" align="center"
ID="Table6">
<tr style="BACKGROUND-IMAGE: url('Images/title1.gif');">
<td colspan="2" align="center" bgcolor="#99A6BF" style="background-image: url('')"><b>教 研 工 作 的 获 奖 情 况 资 料 修 改</b></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" width="30%">
<b>获奖名称：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="name" class="text" ID="Text3" size="60" value="<%=rs("name")%>"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" width="30%">
<b>获奖项目名称：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="lessonName" class="text" ID="Text4" size="60" value="<%=rs("lessonName")%>"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" width="30%">
<b>主持人：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="author" class="text" ID="Text5" size="60" value="<%=rs("author")%>"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>合作者：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="worker" class="text" ID="Text6" size="60" value="<%=rs("worker")%>"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF" valign="top">
<b>时 间：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="startendtime" class="text" ID="Text9" size="60" value="<%=rs("startendTime")%>"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>授予单位：</b></td>
<td bgcolor="#FFFFFF">
<input type="text" name="unit" class="text" ID="Text10" size="60" value="<%=rs("unit")%>"></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>备 注：</b></td>
<td bgcolor="#FFFFFF">
<textarea name="From" class="text" cols="50" rows="5" ID="Textarea2"><%=rs("Froming")%></textarea></td>
</tr>
<tr>
<td bgcolor="#E7EAEF">
<b>年 度：</b></td>
<td bgcolor="#FFFFFF">
<select name="yearInfo" ID="Select2">
<%
for iyear = year(now())-3 to year(now())
response.Write("<option value='"&iyear&"' ")
if rs("yearInfo") = iyear then
response.Write(" selected")
end if
response.Write(">"&iyear&"年</option>")
next
%>
</select>
</td>
</tr>
<tr>
<td bgcolor="#99A6BF" align="middle" colspan="2">
<input type="submit" name="submit" value=" 修 改 " onMouseOver="this.className='button1_o';"
onMouseOut="this.className='button1';" class="button1" ID="Submit3">
<input type="reset" name="reset" value=" 重 置 " onMouseOver="this.className='button1_o';"
onMouseOut="this.className='button1';" class="button1" ID="Reset2"></td>
</tr>
</table>
</td>
</tr>
</table>
<%
end if
rs.close()
end sub
'修改操作
sub save()
if Request.Form("act") = "add" then
Response.Write("添加资料")
conn.execute("Insert into [jiaoyan] (name,lessonName,author,worker,Froming,startendTime,unit,type,owner,adder,yearInfo) Values ('"&Request.Form("name")&"','"&Request.Form("lessonName")&"','"&Request.Form("author")&"','"&Request.Form("worker")&"','"&Request.Form("From")&"','"&Request.Form("startendTime")&"','"&Request.Form("unit")&"',4,"&Session("UID")&",'"&Session("UserName")&"',"&Request.Form("yearInfo")&")")
Response.Write("<script>alert('成功添加资料！');location.href='?action=list';</script>")
elseif Request.Form("act") = "change" then
Response.Write("修改资料")
conn.execute("Update [jiaoyan] Set name = '"&Request.Form("name")&"',lessonName = '"&Request.Form("lessonName")&"',author = '"&Request.Form("author")&"',worker = '"&Request.Form("worker")&"',Froming = '"&Request.Form("From")&"',startendTime = '"&Request.Form("startendTime")&"',unit = '"&Request.Form("unit")&"',changer = '"&Session("UserName")&"',yearInfo = "&Request.Form("yearInfo")&" Where id = " & Request.Form("id"))
Response.Write("<script>alert('成功修改资料！');location.href='?action=list';</script>")
elseif Request.Form("act") = "delete" then
Response.Write("删除资料")
dim delid
delid = Request.Form("delid")
if delid = "" then
Response.Write("<script>alert('对不起，请选中要删除的资料！');window.history.back();</script>")
Response.End()
end if
conn.execute("Delete * From [jiaoyan] where id in ("&delid&")")
Response.Write("<script>alert('成功删除选定的资料！');location.href='?action=list';</script>")
end if
end sub
Set rs = nothing
CloseDataBase
%>
</form>
<script language="javascript" src="copyright.htm" type="text/javascript"></script>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -