📄 employeeadde.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=DataBase/conn.asp-->
<%
if request("post")<>"" then
if request("name")<>"" and request("ename")<>"" and request("age")<>"" and request("sex")<>"" and request("jiguan")<>"" and request("xianzhi")<>"" and request("tel")<>"" and request("hander")<>"" and request("email")<>"" and request("xueli")<>"" and request("school")<>"" and request("zhuanye")<>"" then
set rszw=server.CreateObject("adodb.recordset")
sqlzw="select * from tb_Zhiwei where id="&request("zhiwei")
rszw.open sqlzw,conn,1,1
suo=rszw("suoshu")
set rs=server.CreateObject("adodb.recordset")
sql="select * from tb_Employee where id="&request("id")
rs.open sql,conn,1,3
rs("name")=request("name")
rs("ename")=request("ename")
rs("age")=request("age")
rs("sex")=request("sex")
rs("jiguan")=request("jiguan")
rs("xianzhi")=request("xianzhi")
rs("tel")=request("tel")
rs("hander")=request("hander")
rs("chusheng")=request("year")&"-"&request("month")&"-"&request("day")
rs("jingongsi")=request("jyear")&"-"&request("jmonth")&"-"&request("jday")
rs("zhiwei")=request("zhiwei")
rs("mianmao")=request("mianmao")
rs("hun")=request("hun")
rs("email")=request("email")
rs("xueli")=request("xueli")
rs("school")=request("school")
rs("zhuanye")=request("zhuanye")
rs("suoshu")=suo
rs.update
rs.close
response.Write("<script language=javascript>alert('提交成功');window.close()</script>")
else
response.Write("<script language=javascript>alert('请把信息填写完整');location='javascript:history.go(-1)'</script>")
end if
end if
'显示人员信息
set rsr=server.CreateObject("adodb.recordset")
sqlr="select * from tb_Employee where id="&request("id")
rsr.open sqlr,conn,1,3
'部门
set rsb=server.CreateObject("adodb.recordset")
sqlb="Select * from tb_dept order by up"
rsb.Open sqlb,conn,1,3
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
.style1 {
color: #FF0000;
font-size: 16px;
font-weight: bold;
}
-->
</style>
<link href="CSS/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {color: #FF0000}
body {
background-color: #efefef;
}
-->
</style>
</head>
<body topmargin="0">
<form name="form1" method="post" action="">
<table width="430" height="389" border="0" align="center" cellspacing="1">
<tr>
<td height="34" colspan="4"><div align="center" class="style1">修改员工信息
<input name="post" type="hidden" id="post" value="true">
</div></td>
</tr>
<tr>
<td width="97"><div align="right">姓名：</div></td>
<td width="201"> <input name="name" type="text" class="wenben" id="name" value="<%=rsr("name")%>" size="20">
<span class="style2">*</span></td>
<td width="41"><div align="center">年龄：</div></td>
<td width="101"> <input name="age" type="text" class="wenben" id="age" value="<%=rsr("age")%>" size="4" maxlength="2">
岁<span class="style2">*</span></td>
</tr>
<tr>
<td><div align="right">英文名</div></td>
<td width="201"> <input name="ename" type="text" class="wenben" id="ename" value="<%=rsr("ename")%>" size="20">
<span class="style2">*</span></td>
<td width="41"><div align="center">性别：</div></td>
<td width="101"> <select name="sex" id="sex">
<option value="男">男</option>
<option value="女">女</option>
</select>
<span class="style2">*</span></td>
</tr>
<tr>
<td align="right">政治面貌：</td>
<td> <select name="mianmao" id="mianmao">
<option value="群众" <%if rsr("mianmao")="群众" then%>selected<%end if%>>群众</option>
<option value="团员" <%if rsr("mianmao")="团员" then%>selected<%end if%>>团员</option>
<option value="党员" <%if rsr("mianmao")="党员" then%>selected<%end if%>>党员</option>
</select>
</td>
<td width="41">婚否：</td>
<td width="101"><select name="hun" id="hun">
<option value="已婚" <%if rsr("hun")="已婚" then%>selected<%end if%>>已婚</option>
<option value="未婚" <%if rsr("hun")="未婚" then%>selected<%end if%>>未婚</option>
</select></td>
</tr>
<tr>
<td> <div align="right">出生年月日：</div></td>
<td colspan="3">
<select name="year" id="year">
<%for i=1900 to 2000%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
年
<select name="month" id="month">
<%for i=1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月
<select name="day" id="day">
<%for i=1 to 31%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
日<span class="style2">*</span></td>
</tr>
<tr>
<td align="right">电子邮件：</td>
<td colspan="3">
<input name="email" type="text" class="wenben" id="email" value="<%=rsr("email")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td align="right">学历：</td>
<td colspan="3">
<select name="xueli" id="xueli">
<option value="初中" <%if rsr("xueli")="初中" then%>selected<%end if%>>初中</option>
<option value="高中" <%if rsr("xueli")="高中" then%>selected<%end if%>>高中</option>
<option value="中专" <%if rsr("xueli")="中专" then%>selected<%end if%>>中专</option>
<option value="大专" <%if rsr("xueli")="大专" then%>selected<%end if%>>大专</option>
<option value="本科" <%if rsr("xueli")="本科" then%>selected<%end if%>>本科</option>
<option value="研究生" <%if rsr("xueli")="研究生" then%>selected<%end if%>>研究生</option>
<option value="硕士" <%if rsr("xueli")="硕士" then%>selected<%end if%>>硕士</option>
<option value="博士" <%if rsr("xueli")="博士" then%>selected<%end if%>>博士</option>
<option value="博士后" <%if rsr("xueli")="博士后" then%>selected<%end if%>>博士后</option>
</select>
<span class="style2">*</span></td>
</tr>
<tr>
<td align="right">毕业学校：</td>
<td colspan="3">
<input name="school" type="text" class="wenben" id="school" value="<%=rsr("school")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td align="right">专业：</td>
<td colspan="3">
<input name="zhuanye" type="text" class="wenben" id="zhuanye" value="<%=rsr("zhuanye")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td><div align="right">籍贯：</div></td>
<td colspan="3"> <input name="jiguan" type="text" class="wenben" id="jiguan" value="<%=rsr("jiguan")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td><div align="right">现在住址：</div></td>
<td colspan="3"> <input name="xianzhi" type="text" class="wenben" id="xianzhi" value="<%=rsr("xianzhi")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td><div align="right">联系电话：</div></td>
<td colspan="3"> <input name="tel" type="text" class="wenben" id="tel" value="<%=rsr("tel")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td><div align="right">手机：</div></td>
<td colspan="3"> <input name="hander" type="text" class="wenben" id="hander" value="<%=rsr("hander")%>" size="30">
<span class="style2">*</span></td>
</tr>
<tr>
<td><div align="right">进公司时间</div></td>
<td colspan="3">
<select name="jyear" id="jyear">
<%for i=2000 to 2050%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
年
<select name="jmonth" id="jmonth">
<%for i=1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月
<select name="jday" id="jday">
<%for i=1 to 31%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
日<span class="style2">*</span></td>
</tr>
<tr>
<td height="31" align="right">职位：</td>
<td colspan="3">
<select name="zhiwei" id="select3">
<%
do while not rsb.EOF
set rsz=server.CreateObject("adodb.recordset")
sqlz="select * from tb_ZhiWei where suoshu="&rsb("id")
rsz.open sqlz,conn,1,1
xian=""
for i=1 to rsb("level")-1
xian= xian&"├"
next
xian = xian&"〖"&trim(rsb("title"))&"〗"
do while not rsz.eof
%>
<option value="<%=rsz("id")%>" <% if rsz("id")= clng(rsr("zhiwei")) then %>selected<% End If %>><%=xian&rsz("zhiwei")%> </option>
<%
rsz.movenext
loop
rsb.movenext
loop
%>
</select></td>
</tr>
<tr>
<td colspan="4"><div align="center">
<input name="Submit" type="submit" class="botton" value=" 提 交 ">
<input name="Submit2" type="reset" class="botton" value=" 重 置 ">
<input name="Submit3" type="submit" class="botton" value=" 关 闭 " onClick="window.close()">
<br>
<span class="style2">注意：带*的必须填写</span></div></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -