?? grqz2.asp
字號:
<!--#include file="info.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
<title>職位列表 - <%=webname%></title>
</head>
<body>
<!--#include file="top.asp"-->
<div align="center">
<table border="0" width="760" cellspacing="0" cellpadding="0" id="table1" height="106">
<tr>
<td style="border-left: 1px solid #0086DF; border-right: 1px solid #0086DF" width="760" valign="top">
<div align="center">
<table border="0" width="98%" cellspacing="0" cellpadding="0" id="table2" height="164">
<tr>
<td style="border: 1px solid #C0C0C0" valign="top">
<div align="center">
<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table3" height="147">
<tr>
<td height="40" width="740" background="images/bg10.gif">
<table border="0" width="740" cellspacing="0" cellpadding="0" id="table4" height="31">
<tr>
<td width="127"> </td>
<form method="POST" action="grqz2.asp">
<td width="587">
<p align="center"><SELECT SIZE=1 NAME=gzdd STYLE="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF">
<OPTION value="0" selected>請選擇工作省份</OPTION>
<option value="0">不限</option>
<%
call listarea("")
%>
</SELECT>
<SELECT SIZE="1" NAME="job" STYLE="border: 1px solid #333333; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF">
<OPTION VALUE="0" selected>::請選擇職位類別::</OPTION>
<option value="0">不限</option>
<%
call listjob("")
%>
</SELECT>
<SELECT ID=create_date NAME=date size="1">
<option selected value="不限">請選擇發布時間</option>
<OPTION VALUE="不限">不限</OPTION> <OPTION VALUE="1">一天內</OPTION>
<OPTION VALUE="2">二天內</OPTION> <OPTION VALUE="3">三天內</OPTION> <OPTION VALUE="7">一星期內</OPTION>
<OPTION VALUE="14">二星期內</OPTION> <OPTION VALUE="30">一個月內</OPTION> <OPTION VALUE="91">三個月內</OPTION>
<OPTION VALUE="183">六個月內</OPTION> <OPTION VALUE="365">一年內</OPTION> </SELECT>
<input type="submit" value="篩選" name="B2"></td>
</form>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" align="center">
<%
sql="select id,enid,jtzw,hka,city,addtime,sexs,edus from job where enid in (select id from en_user where lock=false and name<>'')"
if request("gzdd")<>"0" and request("gzdd")<>"" then sql=sql+" and hka='"&request("gzdd")&"'"
if request("job")<>"0" and request("job")<>"" then sql=sql+" and job='"&request("job")&"'"
if request("date")<>"不限" and request("date")<>"" then sql=sql+" and datediff('d',addtime,Now())<"&request("date")
sql=sql+" order by id desc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
rs.close
response.write "暫時沒有相關職位！"
else
rs.pagesize=20
if request("action")="n" then
session("page")=session("page")+1
else
if request("action")="p" then
session("page")=session("page")-1
else
if request("action")="f" then
session("page")=1
else
if request("action")="l" then
session("page")=rs.pagecount
else
if isnumeric(request("page1"))=true then
session("page")=clng(request("page1"))
else
session("page")=1
end if
end if
end if
end if
end if
if session("page")>rs.pagecount then session("page")=rs.pagecount
if session("page")<1 then session("page")=1
rs.absolutepage=session("page")
%>
<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table5" height="92">
<tr>
<td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="166" align="center">
<b>招 聘 職 位</b></td>
<td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="189" align="center">
<b>招 聘 公 司</b></td>
<td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="127" align="center">
<b>城 市</b></td>
<td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="60" align="center">
<b>性別要求</b></td>
<td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="60" align="center">
<b>學歷要求</b></td>
<td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="100" align="center">
<b>日 期</b></td>
</tr>
<%
set rs2=server.createobject("adodb.recordset")
for ii=1 to 20
sql2="select id,name from en_user where id="&rs("enid")
rs2.open sql2,conn,1,1
%>
<tr>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="166" height="30" align="center" background="images/bg9.gif"><a target =_blank href="job.asp?id=<%=rs("id")%>">
<%=rs("jtzw")%></a></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="189" height="30" align="center" background="images/bg9.gif"><a target =_blank href="company.asp?id=<%=rs2("id")%>">
<%=rs2("name")%></a></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="127" height="30" align="center" background="images/bg9.gif">
<p align="center"><%=rs("hka")%>·<%=rs("city")%></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="60" height="30" align="center" background="images/bg9.gif">
[<%=rs("sexs")%>]</td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="60" height="30" align="center" background="images/bg9.gif">
[<%=rs("edus")%>]</td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="100" height="30" align="center" background="images/bg9.gif">
<%
a=instr(rs("addtime"),chr(32))-1
response.write Mid(rs("addtime"),1,a)
%>
</td>
</tr>
<%
rs.movenext
if rs.eof then exit for
rs2.close
next
%>
<tr>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="734" height="42" align="center" colspan="6"><table border="0" width="504" cellspacing="0" cellpadding="0" height="31">
<tr>
<td width="120">
<p align="center">當前頁碼:<font color="#FF0000"><%=session("page")%></font>/<%=rs.pagecount%></td>
<td width="225">
<p align="center">< <a href="grqz2.asp?action=f&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>">首頁</a>
<a href="grqz2.asp?action=p&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>">上一頁</a>
<a href="grqz2.asp?action=n&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>">下一頁</a>
<a href="grqz2.asp?action=l&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>">尾頁</a> ></td>
<form method="POST" action="grqz2.asp?gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>">
<td width="159">
<p>跳轉到
<input type="text" name="page1" size="4" style="border: 1px solid #000000"> 頁
<input type="submit" value="提交" name="B1"></p>
</td>
</form>
</tr>
</table>
</td>
</tr>
</table>
<%
rs.close
end if
%>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
<%
set rs2=nothing
set rs=nothing
set conn=nothing
%>
<!--#include file="base.asp"-->
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -