📄 employeeadd.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=DataBase/conn.asp-->
<!--#include file=yan.asp-->
<!--#include file=purview.asp-->
<%
call tianjiayuangong
if request("post")<>"" then
if request("nameid")="" then
response.Write("<script language=javascript>alert('没有员工不能添加');location='javascript:history.go(-1)'</script>")
response.End()
end if
set rs=server.CreateObject("adodb.recordset")
sql="select * from tb_Jobbase where id="&request("nameid")
rs.open sql,conn,1,1
set rsd=server.CreateObject("adodb.recordset")
sqld="select * from tb_Employee"
rsd.open sqld,conn,1,3
rsd.addnew
rsd("name")=rs("name")
rsd("ename")=rs("ename")
rsd("mianmao")=rs("mianmao")
rsd("hun")=rs("hun")
rsd("email")=rs("email")
rsd("xueli")=rs("xueli")
rsd("school")=rs("school")
rsd("age")=rs("age")
rsd("zhuanye")=rs("zhuanye")
rsd("sex")=rs("sex")
rsd("jiguan")=rs("jiguan")
rsd("xianzhi")=rs("xianzhi")
rsd("tel")=rs("tel")
rsd("hander")=rs("hander")
rsd("chusheng")=rs("chusheng")
rsd("work")=rs("work")
rsd("jingongsi")=request("jyear")&"-"&request("jmonth")&"-"&request("jday")
rsd("kong")=0
rsd.update
rsd.close
set rsy=server.CreateObject("adodb.recordset")
sqly="select * from tb_Jobbase where id="&request("nameid")
rsy.open sqly,conn,1,3
rsy("yi")=1
rsy.update
rsy.close
response.Write("<script language=javascript>alert('提交成功');location='employeeadd.asp'</script>")
end if
'显示员工
set rsx=server.CreateObject("adodb.recordset")
sqlx="select * from tb_Jobbase where yi=0"
rsx.open sqlx,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
<link href="CSS/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {color: #FF0000}
.style3 {color: #0000FF}
-->
</style>
<script language="javascript">
function more()
{
var id=form1.nameid.value;
window.open("jobdaoopen.asp?id="+id,"","width=550,height=600,toolbar=no,location=no,status=no,menubar=no");
}
</script>
</head>
<body topmargin="0">
<form name="form1" method="post" action="">
<table width="550" border="0" align="center">
<tr>
<td width="55%" height="30"> - <span class="style2">人事管理</span>→<span class="style3">人力规划</span>→<font color="#FF0000">添加员工</font></td>
</tr>
</table>
<table width="550" border="0" align="center" cellspacing="1" bgcolor="#000000">
<tr>
<td bgcolor="#FFFFFF"><table width="550" border="0" align="center" cellspacing="0" bordercolorlight="#FFFFFF" bordercolordark="#666699" bgcolor="#FFFFFF">
<tr >
<td height="28" colspan="2" background="images/index_24.gif"><div align="center" ><span class="style2"><strong>添加员工信息</strong></span>
<input name="post" type="hidden" id="post" value="true">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="131" height="33" align="right">姓名：</td>
<td bgcolor="#FFFFFF">
<% if not rsx.eof then %>
<select name="nameid">
<%
do while not rsx.eof %>
<option value="<%=rsx("id")%>"><%=rsx("name")%></option>
<%
rsx.movenext
loop
%>
</select>
<input name="Submit3" type="button" class="botton" value=" 详细资料 " onClick="more()">
<%else%>
没有员工
<%end if%>
</td>
</tr>
<tr bgcolor="#FFFFFF" >
<td height="33" align="right">进公司时间：</td>
<td bgcolor="#FFFFFF">
<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>
日</td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2"><div align="center">
<input name="Submit" type="submit" class="botton" value=" 提 交 ">
<input name="Submit2" type="reset" class="botton" value=" 重 置 ">
<br>
<span class="style2">注意：带*的必须填写</span></div></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -