📄 per_education_add.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Public/Person_Cookies.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim Param,Perid,Username,Action
Param = Request.QueryString("param")
Action = Request.QueryString("action")
Perid = Session("Person")(2)
Username = Session("Person")(0)
If Action<>"" Then
Select Case Action
Case "edus_submit"
Call Edus_Submit()
Case "trains_submit"
Call Trains_Submit()
End Select
End if
'//关闭数据库连接
CloseDB
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../Css/Style.css" type=text/css rel=stylesheet>
<title><%= Cls_WebName %> -- 个人会员管理中心 -- 添加教育/培训经历</title>
</head>
<script language="JavaScript" src="../js/Person_education_add.js"></script>
<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<!--#include file="../Include/Header.asp" -->
</td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="4"></td>
</tr>
<tr>
<td height="1" bgcolor="#eeeeee"></td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="175">
<!--#include file="../Public/Person_Left.asp" -->
</td>
<td width="5"> </td>
<td valign="top">
<%
Select Case Param
Case "addedus"
Call AddEdus_Sub()
Case "addtrains"
Call AddTrains_Sub()
End Select
Sub AddEdus_Sub()
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form action="?action=edus_submit" name="edus" method="post" onSubmit="return edus_check();">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td bgcolor="#FFFFFF"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f5f5f5"><b><font color="#000000"> 添加教育经历</font></b></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="18%" height="25" align="right"><STRONG><FONT
color=#ff6600>* </FONT></STRONG>起止时间：</td>
<td height="25"><input name="begin_year" type="text" id="begin_year" size="4" maxlength="4" >
年<span style="FONT-FAMILY: 宋体; FONT-SIZE: 12px"><font>
<select name=begin_month id="begin_month">
<%for i=1 to 12%>
<option <%if i=9 then response.write "selected"%> value="<%=i%>"><%=i%></option>
<%next%>
</select>
</font></span>月 --
<input name="end_year" type="text" id="end_year" size="4" maxlength="4">
年<span style="FONT-FAMILY: 宋体; FONT-SIZE: 12px"><font>
<select name=end_month id="end_month">
<%for i=1 to 12%>
<option <%if i=7 then response.write "selected"%> value="<%=i%>"><%=i%></option>
<%next%>
</select>
</font></span>月</td>
</tr>
<tr>
<td width="18%" height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT
color=#ff6600>* </FONT></STRONG>毕业学校：</td>
<td height="25" bgcolor="f9f9f9"><input name="schoolname" type="text" id="schoolname" size="35" maxlength="25" style="width:220px;">
</td>
</tr>
<tr>
<td height="25" align="right"><STRONG><FONT
color=#ff6600>* </FONT></STRONG>学 历：</td>
<td height="25"><select name="edus" id="edus" style="width:100px;">
<option value="10">小学</option>
<option value="20">初中</option>
<option value="30">高中</option>
<option value="40">中专</option>
<option value="50">专科</option>
<option value="60">本科</option>
<option value="70">硕士</option>
<option value="80">博士</option>
<option value="90">博士后</option>
</select> </td>
</tr>
<tr>
<td height="25" align="right" bgcolor="f9f9f9">专
业：</td>
<td height="25" bgcolor="f9f9f9"><input name="speciality" type="text" id="speciality" size="35" maxlength="25" style="width:220px;"></td>
</tr>
<tr>
<td height="25" align="right">所获证书：</td>
<td height="25"><input name="certname" type="text" size="35" maxlength="25" style="width:220px;"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="40" align="center"><input name="perid" type="hidden" id="perid" value="<%= Perid %>">
<input name="username" type="hidden" value="<%= Username %>">
<input type="submit" name="Submit" value=" 保存教育经历数据 " style="height:35px;">
</td>
</tr>
</form>
</table>
<%
End Sub
Sub AddTrains_Sub()
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form action="?action=trains_submit" name="edus" method="post" onSubmit="return trains_check();">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td bgcolor="#FFFFFF"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f5f5f5"><b><font color="#000000"> 添加培训经历</font></b></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="18%" height="25" align="right"><STRONG><FONT
color=#ff6600>* </FONT></STRONG>起止时间：</td>
<td height="25"><input name="begin_year" type="text" id="begin_year" size="4" maxlength="4" >
年<span style="FONT-FAMILY: 宋体; FONT-SIZE: 12px"><font>
<select name=begin_month id="begin_month">
<%for i=1 to 12%>
<option <%if i=9 then response.write "selected"%> value="<%=i%>"><%=i%></option>
<%next%>
</select>
</font></span>月 --
<input name="end_year" type="text" id="end_year" size="4" maxlength="4">
年<span style="FONT-FAMILY: 宋体; FONT-SIZE: 12px"><font>
<select name=end_month id="end_month">
<%for i=1 to 12%>
<option <%if i=7 then response.write "selected"%> value="<%=i%>"><%=i%></option>
<%next%>
</select>
</font></span>月</td>
</tr>
<tr>
<td width="18%" height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT
color=#ff6600>* </FONT></STRONG>培训机构：</td>
<td height="25" bgcolor="f9f9f9"><input name="schoolname" type="text" id="schoolname" size="35" maxlength="25" style="width:220px;">
</td>
</tr>
<tr>
<td height="25" align="right"><STRONG><FONT
color=#ff6600>* </FONT></STRONG>课 程：</td>
<td height="25"><input name="speciality" type="text" id="speciality3" size="35" maxlength="25" style="width:220px;">
</td>
</tr>
<tr>
<td height="25" align="right" bgcolor="f9f9f9">所获证书：</td>
<td height="25" bgcolor="f9f9f9"><input name="certname" type="text" id="certname" style="width:220px;" size="35" maxlength="25"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="40" align="center"><input name="perid" type="hidden" id="perid" value="<%= Perid %>">
<input name="username" type="hidden" value="<%= Username %>">
<input type="submit" name="Submit" value=" 保存教育经历数据 " style="height:35px;">
</td>
</tr>
</form>
</table>
<% End Sub %>
</td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" bgcolor="#eeeeee"></td>
</tr>
</table>
<!--#include file="../Include/Footer.asp" -->
</td>
</tr>
</table>
</body>
</html>
<%
Sub Edus_Submit() '//添加教育经历
Call Check_url() '防止外部站点提交数据
'//提交数据
Perid = Session("Person")(2)
Username = Replace_Text(Request.Form("Username"))
Begin_Year = Replace_Text(Request.Form("Begin_Year"))
Begin_Month = Replace_Text(Request.Form("Begin_Month"))
End_Year = Replace_Text(Request.Form("End_Year"))
End_Month = Replace_Text(Request.Form("End_Month"))
SchoolName = Replace_Text(Request.Form("SchoolName"))
Speciality = Replace_Text(Request.Form("Speciality"))
Edus = Replace_Text(Request.Form("Edus"))
CertName = Replace_Text(Request.Form("CertName"))
SQL = "Insert Into [pH_Person_Education] (Perid,Username,Begin_Year,Begin_Month,End_Year,End_Month,SchoolName,Speciality,Edus,CertName,Type) Values ('"&Perid&"','"&UserName&"',"&Begin_Year&","&Begin_Month&","&End_Year&","&End_Month&",'"&SchoolName&"','"&Speciality&"',"&Edus&",'"&CertName&"',1)"
Conn.Execute(SQL)
'//更改最后修改时间
SQL = "Update [pH_Person_Base] Set LastUpdate_Time='"&Now()&"' Where Perid='"&Perid&"'"
Conn.Execute(SQL)
CloseDB
Response.redirect "Per_Education.asp"
End Sub
Sub Trains_Submit() '//添加培训经历
Call Check_url() '防止外部站点提交数据
'//提交数据
Perid = Session("Person")(2)
Username = Replace_Text(Request.Form("Username"))
Begin_Year = Replace_Text(Request.Form("Begin_Year"))
Begin_Month = Replace_Text(Request.Form("Begin_Month"))
End_Year = Replace_Text(Request.Form("End_Year"))
End_Month = Replace_Text(Request.Form("End_Month"))
SchoolName = Replace_Text(Request.Form("SchoolName"))
Speciality = Replace_Text(Request.Form("Speciality"))
CertName = Replace_Text(Request.Form("CertName"))
SQL = "Insert Into [pH_Person_Education] (Perid,Username,Begin_Year,Begin_Month,End_Year,End_Month,SchoolName,Speciality,CertName,Type) Values ('"&Perid&"','"&UserName&"',"&Begin_Year&","&Begin_Month&","&End_Year&","&End_Month&",'"&SchoolName&"','"&Speciality&"','"&CertName&"',2)"
Conn.Execute(SQL)
'//更改最后修改时间
SQL = "Update [pH_Person_Base] Set LastUpdate_Time='"&Now()&"' Where Perid='"&Perid&"'"
Conn.Execute(SQL)
CloseDB
Response.redirect "Per_Education.asp"
End Sub
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -