📄 new.asp
字号:
<!--#include file="../conn.asp"-->
<%
dim rs,sql,Pagesize,Allrecord,Allpage,ThisPage,id,rs1,sql1,zt,degree,dysp
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
%>
<title>最新职位</title>
<script language="javaScript">
<!--
function mOvr(src,clrOver){
if (!src.contains(event.fromElement)) {
src.style.cursor = 'hand';
src.bgColor = clrOver;
}
}
function mOut(src,clrIn) {
if (!src.contains(event.toElement)) {
src.style.cursor = 'default';
src.bgColor = clrIn;
}
}
//-->
</script>
<SCRIPT language=JavaScript>
function showoperatealert(id)
{
if (id==1)
{
{
thisForm.target='_self';
thisForm.action="../person/ijob.asp?oo=2";
thisForm.submit();
}
}
if (id==2)
{
{
thisForm.target='_self';
thisForm.action="../company/listalljob.asp";
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><link rel="stylesheet" type="text/css" href="../index.files/jobcn.css">
<link rel="stylesheet" type="text/css" href="../1.css">
<body topmargin="0" leftmargin="0" style="text-align: center">
<!--#include file="top.asp"-->
<div align="center">
<table width="770" border="0" cellspacing="0" cellpadding="0" bordercolor="#111111">
<tr>
<td width="76%">
</td>
<%
dim workplace1,searchday,key1
if trim(request("key"))="" then
key1=" "
else
key1="(selectedjob like '%"&request("key")&"%' or jobs like '%"&request("key")&"%' ) and "
end if
if trim(request("workplace"))="0" then
workplace1=""
else
workplace1=" s_WorkLocation='"&request("workplace")&"' and "
end if
if request("registerdate")="99999" then
searchday=""
else
searchday=" datediff(d,tjsj,getdate()) < "&request("registerdate")&" and "
end if
dim cmdTemp
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs = server.CreateObject ("adodb.recordset")
if request("workplace")="" or request("registerdate")="" or request("key")="输入职位关键字" then
sql="select id,comid,jobs,dysp,s_WorkLocation,renshu,degree,tjsj,zt from [jobs] where (len(selectedjob)>1 and len(jobs)>1 and zt<>1) order by id desc"
else
sql="select id,comid,jobs,dysp,s_WorkLocation,renshu,degree,tjsj,zt from [jobs] where "&workplace1&" "&searchday&" "&key1&" (len(selectedjob)>1 and len(jobs)>1 and zt<>1) order by id desc"
end if
cmdTemp.CommandText = sql
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs.Open cmdTemp, , 1, 1
set cmdTemp=nothing
if rs.eof and rs.bof then
response.write "<table border=0 width=100% height=100 cellpadding=0><tr><td width='100%'><p align=center>对不起！没有找到任何职位</td></tr></table>"
else
rs.Pagesize=20
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
rs.move (ThisPage-1)*Pagesize
dim k
k=0
%>
<td >职位总数：<b><font size="2" color="#FF6600"><%=AllRecord%></font></b></td>
</tr>
</table>
</div>
<div align="center">
<FORM name=thisForm action="" method=POST>
<center>
<table width="770" border="0" cellspacing="0" cellpadding="0" class="font_9_c_black" style="border-collapse: collapse" bordercolor="#111111" height="46">
<tr>
<td bgcolor="#66CCFF" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-left-style:solid; border-left-width:1" width="38">
<p style="LETTER-SPACING: 2px; LINE-HEIGHT: 17px">
<font style="FONT-SIZE: 9pt; ">编号</font></td>
<td width="114" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px">招聘职位</td>
<td width="209" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px">公司名称</td>
<td width="68" 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: 宋体; ">
工作地区</span></font></td>
<td width="55" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px" align="center">招聘人数</td>
<td width="58" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p style="LINE-HEIGHT: 17px" align="center">
要求学历</td>
<td width="73" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center">工资待遇</td>
<td width="119" bgcolor="#66CCFF" height="20" align="left" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center">
<span style="font-size: 12px; ">发布时间</span></td>
<td width="34" bgcolor="#66CCFF" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-right-style:solid; border-right-width:1">
选择</td>
</tr>
<%
do while not rs.eof
zt=rs("zt")
degree=rs("degree")
dysp=rs("dysp")
On Error Resume Next
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs1 = server.CreateObject ("adodb.recordset")
sql="select id,comid,companyName from [company] where comid='"&rs("comid")&"'"
cmdTemp.CommandText = sql
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs1.Open cmdTemp, , 1, 1
%>
<tr bgcolor="#f7f7f7" onmouseout="mOut(this,'#f7f7f7');" onmouseover="mOvr(this,'#E5F6CC');">
<td width="38" 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="#E0E0E0"><font color="#384249"><b><%=k+1%></b></font></td>
<td width="114" height="25" align="left" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0"><%if zt=1 then%><font color="#ff0000"><%=rs("jobs")%></font><%else%><a target="_blank" href="../company/listalljob.asp?selectedid=<%=rs("id")%>"><%=rs("jobs")%></a><%end if%></td>
<td width="209" height="25" align="left" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0" ><%if zt=1 then%><font color="#ff0000"><%=rs1("companyname")%></font><%else%><a target="_blank" href="../company/listcompany.asp?comid=<%=rs1("comid")%>"><%=rs1("companyname")%></a><%end if%></td>
<td width="68" height="25" align="left" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<p align="center"><%=rs("s_WorkLocation")%></td>
<td width="55" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<p><%=rs("renshu")%>人</td>
<td width="58" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<%
if degree=0 then
response.write "高中"
elseif degree=1 then
response.write "中专"
elseif degree=2 then
response.write "大专"
elseif degree=3 then
response.write "本科"
elseif degree=4 then
response.write "硕士"
elseif degree=5 then
response.write "博士"
end if
%> </td>
<td width="73" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<%if dysp=0 then %>面议<%else%><%=dysp%>元<%end if%></td>
<td width="119" height="25" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-top-style:solid; border-top-width:1" bordercolor="#E0E0E0">
<%=rs("tjsj")%></td>
<td width="34" 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="#E0E0E0">
<INPUT type=checkbox value="<%=rs("id")%>" name=selectedid></td>
</tr>
<%
rs1.close
set cmdTemp=nothing
set rs1=nothing
k=k+1
if k>=Pagesize then exit do
rs.movenext
loop %>
<tr>
<td width="735" bgcolor="#FFFFFF" height="29" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-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="735" bgcolor="#FFFFFF" height="26" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style:none; border-bottom-width:medium" colspan="8">
<img style="CURSOR: hand" onclick=javascript:showoperatealert(1) border="0" src="../img/putfavorite_But.gif"><img style="CURSOR: hand" onclick=javascript:showoperatealert(2) border="0" src="../img/list.gif"></td>
</tr>
</table>
</center></form>
</div>
<div align="center">
<center>
<table width="770" 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=new.asp?page=1&key="&request("key")&"&workplace="&request("workplace")&"®isterdate="&request("registerdate")&"><img name='_1prev' src='../img/_1prev.gif' width='22' height='18' border='0'></a></td>"
response.write "<td width='10'><a href=new.asp?page="&ThisPage-1&"&key="&request("key")&"&workplace="&request("workplace")&"®isterdate="&request("registerdate")&"><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=new.asp?page="&(ThisPage+1)&"&key="&request("key")&"&workplace="&request("workplace")&"®isterdate="&request("registerdate")&"><img name='_prev' src='../img/_next.gif' width='22' height='18' border='0'></a></td>"
response.write "<td width='10'><a href=new.asp?page="&Allpage&"&key="&request("key")&"&workplace="&request("workplace")&"®isterdate="&request("registerdate")&"><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>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="770">
<tr>
<td width="100%" height="10">
<p align="center"></td>
</tr>
<tr>
<td width="100%" height="10">
<p align="center"><!--#include file="copyright.asp"--></td>
</tr>
</table>
</center>
</div>
<%
rs.close
set rs=nothing
set cmdTemp=nothing
call closedb
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -