📄 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">
<title>教员列表 - <%=webname%></title>
<style type="text/css">
<!--
.STYLE1 {color: #006666}
.STYLE14 {color: #FF3399}
-->
</style>
</head>
<body>
<!--#include file="top.asp"-->
<div align="center">
<table border="0" width="811" cellspacing="0" cellpadding="0" id="table1" height="106">
<tr>
<td width="760" valign="top" bgcolor="#FFFFFF" style="border-left: 1px solid #ffc6bf; border-right: 1px solid #ffc6bf; border-top: 1px solid #ffc6bf">
<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="800" cellspacing="0" cellpadding="0" id="table4" height="31">
<tr>
<td width="127" height="40"> </td>
<form method="POST" action="grqz2.asp">
<td width="587">
<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="7">一星期内</OPTION>
<OPTION VALUE="30">一个月内</OPTION> <OPTION VALUE="183">六个月内</OPTION>
</SELECT>
<% if Request.Cookies("sjob")="ok" then %> <input type="submit" value="筛选" name="B2">
<%else
response.write "<font color=#FF0000>登录后搜索,仅供学员用户(资料完整者)使用</font>"
end if %>
</td>
</form>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" align="center">
<%
sql="select * from en_user where lock=false "
if request("job")<>"0" and request("job")<>"" then sql=sql+" and cxz='"&request("job")&"'"
if request("date")<>"不限" and request("date")<>"" then sql=sql+" and datediff('d',rdate,Now())<"&request("date")
sql=sql+" order by rdate desc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
rs.close
response.write "暂时没有相关教员！"
else
rs.pagesize=15
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 width="100%" height="92" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" id="table5">
<tr>
<td width="119" height="30" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; "><strong>教员姓名</strong></td>
<td width="100" height="30" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
<b>擅长科目</b></td>
<td width="201" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; "><b>服务区域</b></td>
<td width="72" height="30" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
<b>教员身份</b></td>
<td width="64" height="30" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
<b>性别 </b></td>
<td width="109" height="30" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
<b>每小时价格[元]</b></td>
<td width="99" height="30" align="center" background="imagen/web_01_05.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
<b>注册日期</b></td>
</tr>
<%
for ii=1 to 15
%>
<tr>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="119" height="30" align="center" background="images/bg9.gif"><a target =_blank href="teacher.asp?id=<%=rs("id")%>">
<%=left(rs("name"),1)%>教员</a><%if rs("vip")=true then response.write "<font color='#FF0000'>[荐]</font>"%></td>
<td width="100" height="30" align="center" background="images/bg9.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
『<font color=#ff0000><%=rs("cxz")%></font>』</td>
<td width="201" height="30" align="center" background="images/bg9.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; "><%
set rss=server.createobject("adodb.recordset")
sqls="select * from province where shengNo="&int(rs("province"))
rss.open sqls,conn,1,1
if rss.eof then
end if
if rs("province") =0 then
response.write "不详"
end if
shengid=rss("id")
sheng=rss("shengname")
rss.close
set rss=nothing
%>
<%
set rss=server.createobject("adodb.recordset")
sqls="select * from city where Shengid="&shengid&" and shino="&int(rs("city"))
rss.open sqls,conn,1,1
if rss.eof then
end if
shi=rss("shiname")
rss.close
set rss=nothing
%>
<%=sheng%><%=shi%><%=rs("xian")%></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="72" height="30" align="center" background="images/bg9.gif">
<p align="center"><%=rs("trade")%></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="64" height="30" align="center" background="images/bg9.gif">
[<%=rs("yuangong")%>]</td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="109" height="30" align="center" background="images/bg9.gif">
<%=rs("fund")%></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="99" height="30" align="center" background="images/bg9.gif">
<%
if (date()-rs("rdate"))<=10 then
a=instr(rs("rdate"),chr(32))-1
response.write "<font color =#FF0000>"
response.write Mid(rs("rdate"),6,a-4)
response.write "<img alt='最新加入招聘职位' src=images/hot.gif>"
end if
if (date()-rs("rdate"))>10 then
a=instr(rs("rdate"),chr(32))-1
response.write Mid(rs("rdate"),1,a)
end if
%> </td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
%>
<tr>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " height="42" align="center" colspan="7"><table width="650" border="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td><div align="center">
</div></td>
</tr>
</table>
<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 + -