📄 companydb.asp
字号:
<!--#include file="../conn.asp"-->
<!--#include file=cookies.asp-->
<html>
<head>
<link rel="stylesheet" type="text/css" href="IMG/jobcn.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>公司人才库</title>
<link rel="stylesheet" type="text/css" href="../1.css">
</head>
<SCRIPT language=JavaScript>
function showoperatealert(id)
{
if (id==1)
{
{
thisForm.target='_self';
thisForm.action="ijob.asp?oo=1";
thisForm.submit();
}
}
if (id==2)
{
{
thisForm.target='_self';
thisForm.action="ijob.asp?oo=2";
thisForm.submit();
}
}
if (id==3)
{
{
thisForm.target='_self';
thisForm.action="ijob.asp?oo=3";
thisForm.submit();
}
}
if (id==4)
{
{
thisForm.target='_self';
thisForm.action="ijob.asp?oo=4";
thisForm.submit();
}
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall' )
e.checked = form.chkall.checked;
}
}
//-->
</SCRIPT>
<body topmargin="0" leftmargin="0" style="text-align: center">
<!--#include file="top.asp"-->
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" height="146">
<tr>
<td width="171" height="146" valign="top">
<!--#include file="left.asp"--></td>
<td width="4" height="146"> </td>
<td width="599" height="146" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="1">
<tr>
<%
dim rs,sql,rs1,sql1,Pagesize,Allrecord,Allpage,ThisPage,id,msjl,username,k
set rs=server.createobject("adodb.recordset")
username=request.cookies("ijob")("comid")
sql="select * from [CompanyDB] where comid='"&username&"'"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align=center>对不起！没有找到任何记录</p>"
'response.end
else
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
rs.Pagesize=15
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
rs.move (ThisPage-1)*Pagesize
k=0
%>
<td width="100%" height="1" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="101%" height="122">
<tr>
<td width="100%" height="122" valign="top">
<div align="center">
<FORM name=thisForm action="" method=POST>
<center>
<table border="0" cellspacing="0" cellpadding="0" class="font_9_c_black" style="border-collapse: collapse" bordercolor="#111111" width="585" >
<tr>
<td width="50" bgcolor="#66CCFF" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LETTER-SPACING: 2px; LINE-HEIGHT: 17px">
<font style="FONT-SIZE: 9pt; font-weight:700">编号</font></td>
<td width="125" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px">
<span style="font-weight: 700">求职意向</span></td>
<td width="81" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px" align="center"><b><span style="font-size: 9pt">姓名</span></b></td>
<td width="75" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center">
<font style="FONT-SIZE: 12px">
<span style="font-family: 宋体; font-weight: 700">
地区</span></font></td>
<td width="35" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px" align="center">
<span style="font-size: 12px; font-weight: 700">学历</span></td>
<td width="49" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center">
<span style="font-weight: 700">性别</span></td>
<td width="128" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px">
<font style="FONT-SIZE: 12px"><span style="font-family: 宋体; font-weight: 700">
添加时间</span></font></td>
<td width="42" bgcolor="#66CCFF" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1">
<b><span style="font-size: 9pt">选择</span></b></td>
</tr>
<%
k=0
do while not rs.eof
set rs1=server.createobject("adodb.recordset")
sql1="select jobid,name,xueli,zcdata,xingbie,s_PWL1,selectedjob1 from person where jobid='"&rs("jobid")&"'"
rs1.open sql1,conn,1,1
%>
<tr>
<td width="49" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-left-style:solid; border-left-width:1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC"><font color="#384249"><b><%=k+1%></b></font></td>
<td width="125" bgcolor="#FFFFFF" height="25" align="left" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC" ><%=rs1("selectedjob1")%></td>
<td width="81" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC">
<a target="_blank" href="../person/listjobs.asp?jobid=<%=rs1("jobid")%>"><%=rs1("name")%></a></td>
<td width="75" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC"><%=rs1("s_PWL1")%></td>
<td width="35" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC">
<p>
<%
if rs1("xueli")=0 then
response.write "高中"
elseif rs1("xueli")=1 then
response.write "中专"
elseif rs1("xueli")=2 then
response.write "大专"
elseif rs1("xueli")=3 then
response.write "本科"
elseif rs1("xueli")=4 then
response.write "硕士"
elseif rs1("xueli")=5 then
response.write "博士"
end if
%>
</td>
<td width="49" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC">
<%if rs1("xingbie")<>0 then%>男<%else%>女<%end if%></td>
<td width="128" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC">
<p align="left"><%=rs("data")%></td>
<td width="41" bgcolor="#FFFFFF" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-right-style:solid; border-right-width:1; border-top-style:solid; border-top-width:1" bordercolor="#CCCCCC">
<INPUT type=checkbox value="<%=rs1("jobid")%>" name=selectedid></td>
</tr>
<%
k=k+1
if k>=Pagesize then exit do
rs.movenext
loop
rs1.close
set rs1=nothing
rs.close
set rs=nothing
closedb
%>
<tr>
<td width="585" bgcolor="#FFFFFF" height="29" align="center" style="border-style:none; border-width:medium; " colspan="8" valign="bottom">
<p align="right">
<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有人才信息</td>
</tr>
<tr>
<td width="585" bgcolor="#FFFFFF" height="26" align="center" style="border-bottom-style:none; border-bottom-width:medium; border-top-style:none; border-top-width:medium" colspan="8">
<img border="0" style="CURSOR: hand" onclick=javascript:showoperatealert(1) src="../IMG/WriteInterviews_But.gif"><img style="CURSOR: hand" onclick=javascript:showoperatealert(3) border="0" src="../IMG/PutRecyclebin_But.gif"><img style="CURSOR: hand" onclick=javascript:showoperatealert(4) border="0" src="../IMG/Delete_But.gif"></td>
</tr>
</table>
</center></form>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</td>
</tr>
<tr>
<td width="100%" height="19" valign="top">
<div align="center">
<center>
<table width="90%" border="0" cellspacing="0" cellpadding="0" class="font_9_c_black" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td width="10">
</td>
<td width="200">共
<b><font color="#FF0000"><%=Allpage%></font></b>
页</td>
<td>
<table border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<%
if ThisPage<2 then
response.write "<td width='10'><img name='link_r2_c1' src='../img/_1prev_.gif' width='22' height='18' border='0'></td><td width='10'><img name='link_r2_c1' src='../img/_prev_.gif' width='22' height='18' border='0'></td>"
else
response.write "<td width='10'><a href=?page=1><img name='_1prev' src='../img/_1prev.gif' width='22' height='18' border='0'></a></td>"
response.write "<td width='10'><a href=?page="&ThisPage-1&"><img name='_prev' src='../img/_prev.gif' width='22' height='18' border='0'></a></td>"
end if
%>
<td width="4">
<p align="right"> </td>
<td>
<div align="center">
<span style="font-size: 9pt">第<b><font color="#FF0000"> <%=ThisPage%> </font></b>页</span></div>
</td>
<td width="4"> </td>
<%
if Allpage-ThisPage<1 then
response.write "<td width='10'><img name='_next_' src='../img/_next_.gif' width='22' height='18' border='0'></td><td width='10'><img name='_next1_' src='../img/_next1_.gif' width='22' height='18' border='0'></td>"
else
response.write "<td width='10'><a href=?page="&(ThisPage+1)&"><img name='_prev' src='../img/_next.gif' width='22' height='18' border='0'></a></td>"
response.write "<td width='10'><a href=?page="&Allpage&"><img name='_next1' src='../img/_next1.gif' width='22' height='18' border='0'></a></td>"
end if
end if
%>
</tr>
</table>
</td>
</tr>
</table></center>
</div>
</td>
</tr>
</table>
</td>
<td width="4" height="146"> </td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778">
<tr>
<td width="100%">
<p align="center"><!--#include file="copyright.asp"--></td>
</tr>
</table>
</center>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -