📄 search_files.asp
字号:
</table>
<%
end if
pactd.close:set pactd=nothing
pact.close:set pact=nothing
end if
'---------------------------------------------------------------------------------------------------
if sel="学习档案" then
set pstudy=server.CreateObject("adodb.recordset")
pstudy.open "select * from pstudy where like '%"&txt&"%' or personnel_id like '%"&txt&"%' or study_ename like '%"&txt&"%' or study_sdate like '%"&txt&"%' or study_ldate like '%"&txt&"%' or study_realize like '%"&txt&"%' or study_remark like '%"&txt&"%'",conn,1,1
response.Write("<div align='center'><font color='#0099FF'>学习档案</font></div>")
if pstudy.bof and pstudy.eof then
response.Write "<script>alert('对不起！没有您要的资料！');window.location.href('Search_file.asp');</script>"
else
%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td width="18%"><div align="center">员工编号</div></td>
<td width="15%"><div align="center">培训机构名称</div></td>
<td width="12%"><div align="center">开始培训时间</div></td>
<td width="12%"><div align="center">毕业时间</div></td>
<td width="12%"><div align="center">培训情况</div></td>
<td><div align="center">备注</div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not pstudy.eof%>
<tr>
<td><div align="center"><%=pstudy("personnel_id")%></div></td>
<td><div align="center"><%=pstudy("study_ename")%></div></td>
<td><div align="center"><%=pstudy("study_sdate")%></div></td>
<td><div align="center"><%=pstudy("study_ldate")%></div></td>
<td><div align="center"><%=pstudy("study_realize")%></div></td>
<td><div align="center"><%=pstudy("study_remark")%></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%pstudy.movenext:wend%>
</table>
<%
pstudy.close
set pstudy=nothing
end if
end if
'2<完>----------------------------------------------------------------------------------------------
end if
else
if txt<>"" then
'部门名称
set dept=server.CreateObject("adodb.recordset")
dept.open "select * from dept where dept_name like '%"&txt&"%'",conn,1,1
'岗位名称
set post=server.CreateObject("adodb.recordset")
post.open "select * from post where post_name like '%"&txt&"%'",conn,1,1
'行政级别名称
set level=server.CreateObject("adodb.recordset")
level.open "select * from plevel where plevel_name like '%"&txt&"%'",conn,1,1
if dept.bof and dept.eof then
deptid=txt
else
deptid=dept("dept_id")
end if
if post.bof and post.eof then
postid=txt
else
postid=post("post_id")
end if
if level.bof and level.eof then
levelid=txt
else
levelid=level("plevel_id")
end if
set rs=server.CreateObject("adodb.recordset")'基本信息档案
rs.open "select * from personnel where personnel_id like '%"&txt&"%' or dept_id like '%"&deptid&"%' or post_id like '%"&postid&"%' or personnel_name like '%"&txt&"%' or personnel_state like '%"&txt&"%' or personnel_nation like '%"&txt&"%' or personnel_sex like '%"&txt&"%' or personnel_birthday like '%"&txt&"%' or personnel_educ like '%"&txt&"%' or personnel_marry like '%"&txt&"%' or personnel_idcode like '%"&txt&"%' or personnel_political like '%"&txt&"%' or personnel_hometown like '%"&txt&"%' or personnel_address like '%"&txt&"%' or personnel_postcode like '%"&txt&"%' or personnel_mphone like '%"&txt&"%' or personnel_fphone like '%"&txt&"%' or personnel_email like '%"&txt&"%' or resume_id like '%"&txt&"%' or personnel_level like '%"&txt&"%' or personnel_skill like '%"&txt&"%' or personnel_sdate like '%"&txt&"%' or personnel_ldate like '%"&txt&"%' or personnel_descript like '%"&txt&"%' or personnel_graduate like '%"&txt&"%' or plevel_id like '%"&levelid&"%' or work_property like '%"&txt&"%' or personnel_major like '%"&txt&"%' and personnel_state!='离职'",conn,1,1
set card=server.CreateObject("adodb.recordset")'证照档案
card.open "select * from card where personnel_id like '%"&txt&"%' or certificate_id like '%"&txt&"%' or card_time like '%"&txt&"%' or card_number like '%"&txt&"%' or card_place like '%"&txt&"%' or card_remark like '%"&txt&"%'",conn,1,1
set work=server.CreateObject("adodb.recordset")'工作档案
work.open "select * from work where personnel_id like '%"&txt&"%' or work_cpname like '%"&txt&"%' or work_sdate like '%"&txt&"%' or work_ldate like '%"&txt&"%' or work_lreason like '%"&txt&"%' or cast(work_money as varchar(20)) like '%"&txt&"%' or work_remark like '%"&txt&"%'",conn,1,1
set skill=server.CreateObject("adodb.recordset")'技能档案
skill.open "select * from skill where personnel_id like '%"&txt&"%' or skill_technic like '%"&txt&"%' or skill_level like '%"&txt&"%' or skill_descript like '%"&txt&"%' or skill_remark like '%"&txt&"%'",conn,1,1
set pact=server.CreateObject("adodb.recordset")'合同档案
pact.open "select * from pact where personnel_id like '%"&txt&"%' or pactdata_id like '%"&txt&"%' or pact_sdate like '%"&txt&"%' or pact_ldate like '%"&txt&"%' or pact_remark like '%"&txt&"%'",conn,1,1
set pstudy=server.CreateObject("adodb.recordset")'学习档案
pstudy.open "select * from pstudy where personnel_id like '%"&txt&"%' or study_ename like '%"&txt&"%' or study_sdate like '%"&txt&"%' or study_ldate like '%"&txt&"%' or study_realize like '%"&txt&"%' or study_remark like '%"&txt&"%'",conn,1,1
if rs.bof and rs.eof and card.bof and card.eof and work.bof and work.eof and skill.bof and skill.eof and pact.bof and pact.eof and pstudy.bof and pstudy.eof then
response.Write "<script>alert('对不起！没有您要的资料！');window.location.href('Search_file.asp');</script>"
else
response.Write("<div align='center'><font color='#0099FF'>基本信息档案</font></div>")
%>
<table width="90%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td><div align="center">员工编号</div></td>
<td><div align="center">部门编号</div></td>
<td><div align="center">岗位</div></td>
<td><div align="center">行政级别</div></td>
<td><div align="center">员工姓名</div></td>
<td><div align="center">性别</div></td>
<td><div align="center">出身日期</div></td>
<td><div align="center">学历</div></td>
<td><div align="center"> </div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not rs.eof%>
<tr>
<td><div align="center"><%=rs("personnel_id")%></div></td>
<td><div align="center">
<%
deptid=rs("dept_id")'部门名称
if deptid<>"" then
set dept=server.CreateObject("adodb.recordset")
dept.open "select * from dept where dept_id="&deptid&"",conn,1,1
response.Write dept("dept_name")
else
response.Write " "
end if
%>
</div></td>
<td><div align="center">
<%
postid=rs("post_id")'岗位名称
if postid<>"" then
set post=server.CreateObject("adodb.recordset")
post.open "select * from post where post_id="&postid&"",conn,1,1
response.Write post("post_name")
else
response.Write " "
end if
%>
</div></td>
<td><div align="center">
<%
levelid=rs("plevel_id")'行政级别名称
if levelid<>"" then
set level=server.CreateObject("adodb.recordset")
level.open "select * from plevel where plevel_id="&levelid&"",conn,1,1
response.Write level("plevel_name")
else
response.Write " "
end if
%>
</div></td>
<td><div align="center"><%=rs("personnel_name")%></div></td>
<td><div align="center"><%=rs("personnel_sex")%></div></td>
<td><div align="center"><%=rs("personnel_birthday")%></div></td>
<td><div align="center"><%=rs("personnel_educ")%></div></td>
<td><div align="center"><a href="Show_emly.asp?id=<%=rs("personnel_id")%>">查看详细</a></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%rs.movenext:wend%>
</table>
<%response.Write("<br><div align='center'><font color='#0099FF'>证照档案</font></div>")%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td width="18%"><div align="center">员工编号</div></td>
<td width="18%"><div align="center">证件名称</div></td>
<td width="18%"><div align="center">有效期</div></td>
<td width="18%"><div align="center">证件编号</div></td>
<td width="18%"><div align="center">发证机构</div></td>
<td width="18%"><div align="center">备注</div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not card.eof%>
<tr>
<td><div align="center"><%=card("personnel_id")%></div></td>
<td><div align="center">
<%
certid=card("certificate_id")
set cert=server.CreateObject("adodb.recordset")
cert.open "select * from certificate where certificate_id="&certid&"",conn,1,1
response.Write cert("certificate_name")
%>
</div></td>
<td><div align="center"><%=card("card_time")%></div></td>
<td><div align="center"><%=card("card_number")%></div></td>
<td><div align="center"><%=card("card_place")%></div></td>
<td><div align="center"><%=card("card_remark")%></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%card.movenext:wend%>
</table>
<%response.Write("<br><div align='center'><font color='#0099FF'>工作档案</font></div>")%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td width="8%"><div align="center">员工编号</div></td>
<td width="15%"><div align="center">公司名称</div></td>
<td width="12%"><div align="center">开始工作时间</div></td>
<td width="12%"><div align="center">离职时间</div></td>
<td width="12%"><div align="center">离职原因</div></td>
<td width="10%"><div align="center">薪酬待遇</div></td>
<td><div align="center">备注</div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not work.eof%>
<tr>
<td><div align="center"><%=work("personnel_id")%></div></td>
<td><div align="center"><%=work("work_cpname")%></div></td>
<td><div align="center"><%=work("work_sdate")%></div></td>
<td><div align="center"><%=work("work_ldate")%></div></td>
<td><div align="center"><%=work("work_lreason")%></div></td>
<td><div align="center"><%=work("work_money")%></div></td>
<td><div align="center"><%=work("work_remark")%></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%work.movenext:wend%>
</table>
<%response.Write("<br><div align='center'><font color='#0099FF'>技能档案</font></div>")%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td width="18%"><div align="center">员工编号</div></td>
<td width="18%"><div align="center">技能名称</div></td>
<td width="18%"><div align="center">技能职称</div></td>
<td width="18%"><div align="center">技能描述</div></td>
<td><div align="center">备注</div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not skill.eof%>
<tr>
<td><div align="center"><%=skill("personnel_id")%></div></td>
<td><div align="center"><%=skill("skill_technic")%></div></td>
<td><div align="center"><%=skill("skill_level")%></div></td>
<td><div align="center"><%=skill("skill_descript")%></div></td>
<td><div align="center"><%=skill("skill_remark")%></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%skill.movenext:wend%>
</table>
<%response.Write("<br><div align='center'><font color='#0099FF'>合同档案</font></div>")%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td><div align="center">员工编号</div></td>
<td><div align="center">合同编号</div></td>
<td><div align="center">签署时间</div></td>
<td><div align="center">解除时间</div></td>
<td><div align="center">备注</div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not pact.eof%>
<tr>
<td><div align="center"><%=pact("personnel_id")%></div></td>
<td><div align="center">
<%
pactdata=pact("pactdata_id")
set pactd=server.CreateObject("adodb.recordset")
pactd.open "select * from pactdata where pactdata_id="&pactdata&"",conn,1,1
response.Write pactd("pact_name")
%>
</div></td>
<td><div align="center"><%=pact("pact_sdate")%></div></td>
<td><div align="center"><%=pact("pact_ldate")%></div></td>
<td><div align="center"><%=pact("pact_remark")%></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%pact.movenext:wend%>
</table>
<%response.Write("<br><div align='center'><font color='#0099FF'>学习档案</font></div>")%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3" colspan="9" background="../images/Table_bj/t-lin.gif"></td>
</tr>
<tr>
<td width="18%"><div align="center">员工编号</div></td>
<td width="15%"><div align="center">培训机构名称</div></td>
<td width="12%"><div align="center">开始培训时间</div></td>
<td width="12%"><div align="center">毕业时间</div></td>
<td width="12%"><div align="center">培训情况</div></td>
<td><div align="center">备注</div></td>
</tr>
<tr class="tr1">
<td height="3" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%while not pstudy.eof%>
<tr>
<td><div align="center"><%=pstudy("personnel_id")%></div></td>
<td><div align="center"><%=pstudy("study_ename")%></div></td>
<td><div align="center"><%=pstudy("study_sdate")%></div></td>
<td><div align="center"><%=pstudy("study_ldate")%></div></td>
<td><div align="center"><%=pstudy("study_realize")%></div></td>
<td><div align="center"><%=pstudy("study_remark")%></div></td>
</tr>
<tr>
<td height="1" colspan="9" bgcolor="#EEEEEE"></td>
</tr>
<%pstudy.movenext:wend%>
</table>
<%
set card=nothing:set cert=nothing:set work=nothing:set skill=nothing:set pactd=nothing:set pact=nothing:set pstudy=nothing
end if
else
response.Redirect("Search_file.asp")
end if
end if
%>
</td>
</tr>
</table>
<!--内容结束-->
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -