<!--#include file="Access.asp"  -->
<!-- #include file="inc/functions.asp" -->
<!-- #include file="page_next.asp" -->

<% '搜索模块
act=request.querystring("act")
keywords=trim(request.form("keywords"))
if act="search" then
if keywords<>"" then
s_sql="select * from web_job  where [j_name] like '%"&keywords&"%' order by j_time desc"
else
s_sql="select * from web_job  order by j_time desc"
end if
else
s_sql="select * from web_job  order by j_time desc"
end if

%>

<script language="JavaScript">
<!--
function ask(msg) {
	if( msg=='' ) {
		msg='警告：删除后将不可恢复，可能造成意想不到后果？';
	}
	if (confirm(msg)) {
		return true;
	} else {
		return false;
	}
}
//-->
</script>
	<%
Call header()
%>

	<table cellpadding='3' cellspacing='1' border='0' class='tableBorder' align=center>
	<tr>
	  <th width="100%" height=25 class='tableHeaderText'>招聘信息列表</th>
	
	<tr><td height="400" valign="top"  class='forumRow'><table width="90%" border="0" align="center" cellpadding="0" cellspacing="2">
          <tr>
            <td width="4%" height="30" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">编号</div></td>
            <td width="16%" height="30" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">招聘职位</div></td>
            <td width="23%" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">招聘公司</div></td>
            <td width="9%" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">过期时间</div></td>
            <td width="9%" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">显示/隐藏</div></td>
            <td width="9%" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">ip/pv</div></td>
			<td width="17%" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">添加时间</div></td>
            <td width="13%" bgcolor="#A5C6FC"><div align="center" style="font-weight: bold">职位操作</div></td>
          </tr>
<% '文章列表模块
strFileName="job_list.asp" 
pageno=10000
set rs = server.CreateObject("adodb.recordset")
rs.Open (s_sql),cn,1,1
rscount=rs.recordcount
if not rs.eof and not rs.bof then
call showsql(pageno)
rs.move(rsno)
for p_i=1 to loopno
%>
<% if p_i mod 2 =0 then
class_style="forumRow"
else
class_style="forumRowHighLight"
end if%>
          <tr >
            <td   height="30" class='<%=class_style%>'><div align="center"><%=rs("id")%></div></td>
            <td class='<%=class_style%>' >&nbsp;<a href="<%=rs("file_path")%>" target="_blank"><%=rs("j_name")%></a>&nbsp;<%if rs("j_index_push")=1 then%>&nbsp;[<span style="color: #FF0000">荐</span>]<%end if%></td>
            <td class='<%=class_style%>' >&nbsp;<a href="<%=rs("file_path")%>" target="_blank"><%
			set rsp=server.createobject("adodb.recordset")
		   sql="select [name] from web_com where [id]="&rs("j_firm")&""
		   rsp.open(sql),cn,1,1
		   if not rsp.eof and not rsp.bof then
		   response.write left(rsp("name"),15)
		   end if
		   rsp.close
		   set rsp=nothing%></a></td>
            <td class='<%=class_style%>' ><div align="center"><%=rs("j_date")%></div></td>
            <td class='<%=class_style%>' ><div align="center"><a href="job_view_yes.asp?id=<%=rs("id")%>&page=<%=page%>&act=<%=act%>&keywords=<%=keywords%>"><%if rs("j_view_yes")=1 then%>已显示<%else%><span style="color: #FF0000">已隐藏</span><% end if%></a></div></td>
            <td class='<%=class_style%>' ><div align="center"><%=rs("ip")%>/<%=rs("hit")%></div></td>
			<td class='<%=class_style%>' ><div align="center"><%=rs("j_time")%></div></td>

			<td class='<%=class_style%>' >
            <div align="center"><a href="job_edit.asp?id=<%=rs("id")%>&page=<%=page%>&act=<%=act%>&keywords=<%=keywords%>">修改</a> | <a href="javascript:if(ask('警告：删除后将不可恢复，可能造成意想不到后果？')) location.href='job_del.asp?id=<%=rs("id")%>&page=<%=page%>&act=<%=act%>&keywords=<%=keywords%>';">删除</a></div>				</td>
          </tr>
		  		  <%
		  rs.movenext
		  next
		  else
response.write "<div align='center'><span style='color: #FF0000'>暂无职位！</span></div>"
		  end if 
		  rs.close
		  set rs=nothing
		  %>
		    <tr  >
              <td height="35"  colspan="8" ><div align="center">
                <%call showpage(strFileName,rscount,pageno,false,true,"")%>
           </div></td>
		    </tr>
      </table></td>
	</tr>
	</table>

<%
Call DbconnEnd()
 %>