📄 companyall.asp

📁 人才招聘系统,用asp做的
💻 ASP
字号:
	<!--#include file=../conn.asp-->
	<!--#include file=cookies.asp-->
	<!--#include file=top.asp-->
	<%
	dim sql
	dim rs,sql1
	dim username,today
	dim comid,i,rs1
	comid=request.cookies("ijob")("comid")
	set rs=server.createobject("adodb.recordset")
	if request("xianshi")="" or request("xianshi")=0 then
	sql="select id,comid,bmmc from [bumen] where comid='"&comid&"'"
	else
	sql="select id,comid,bmmc from [bumen] where comid='"&comid&"' and id='"&cstr(request("xianshi"))&"'"
	end if
	rs.open sql,conn,1,1
	if rs.eof or rs.bof then
	response.write "对不起还没有部门！<br> "
	response.end
	end if
	if search_jav="" or search_aoo="" then
	response.write "参数错误！"
	response.end
	end if
	if search_jav<>search_aoo then
	response.write "参数错误！"
	response.end
	end if
	%>
<link rel="stylesheet" type="text/css" href="../1.css">
<title>企业招聘管理器</title>
<body topmargin="0" leftmargin="0">
<div align="center">
  <center>

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="770" height="236">
  <tr>
    <td width="147" height="236" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
      <tr>
        <td width="100%"><!--#include file=left.asp--></td>
      </tr>
    </table>
    </td>
    <td width="27" height="236" valign="top">　</td>
    <td width="580" height="236" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
      <tr>
        <td width="100%" colspan="5" height="20"><form action="companyall.asp" name="order" method="POST">
<%
set rs1=server.createobject("adodb.recordset")
sql1="select id,comid,bmmc from [bumen] where comid='"&request.cookies("ijob")("comid")&"'"
rs1.open sql1,conn,1,1
if rs1.eof or rs1.bof then
response.write "<select onChange='submit();' name=""xianshi"">"
response.write "<option value=""0"">没有部门</option>"
response.write "</select>"
end if
response.write "<p align=""left""><font color=""#FF0000"">显示<select onChange='submit();' name=""xianshi"" size=""1"" style=""font-size: 9pt"">"
response.write "<option selected>选择..</option>"
response.write "<option value=""0"">所有部门</option>"
Do while not rs1.eof
response.write "<option value='" +  Cstr(rs1("id")) + "'>"+rs1("bmmc")+ "</option>"
rs1.MoveNext
Loop
response.write "</select>的信息</font>"
rs1.close
set rs1=nothing
%></form></td>
      </tr>
      <%
      do while not rs.eof
      %>
      <tr>
        <td width="100%" colspan="5" style="border-bottom-style: none; border-bottom-width: medium" background="../img/bj.gif" height="25">
        <p align="left">【<a href="companyall.asp?xianshi=<%=rs("id")%>"><%=rs("bmmc")%></a>】&nbsp;&nbsp;<font face="宋体">△<a href="AdminDeptedit.asp?id=<%=rs("id")%>">编辑</a>△<a onclick='{if(confirm("此操作将删除【<%=rs("bmmc")%>】下的所有招聘信息！")){return true;}return false;}' href="AdminDeptdel.asp?id=<%=rs("id")%>">删除</a></font></td>
      </tr>
	<%
	set rs1=server.createobject("adodb.recordset")
	sql="select id,comid,bmid,jobs,llcs,ypcs from [jobs] where bmid='"&rs("id")&"' and comid='"&comid&"'"
	rs1.open sql,conn,1,1
	if rs1.eof or rs1.bof then
	response.write "<tr><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color=""#ff0000"">没有发布职位！</font></td></tr> "
	else
	do while not rs1.eof
	%>
      <tr>
        <td width="42%" style="border-top-style: none; border-top-width: medium" height="20">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <a href="listalljob.asp?selectedid=<%=rs1("id")%>"><%=rs1("jobs")%></a>
        </td>
        <td width="18%" style="border-top-style: none; border-top-width: medium" height="20">浏览次数:<%=rs1("llcs")%></td>
        <td width="24%" style="border-top-style: none; border-top-width: medium" height="20">应聘次数:<%=rs1("ypcs")%></td>
        <td width="8%" style="border-top-style: none; border-top-width: medium" height="20">
            <a href="Adminjobsedit.asp?id=<%=rs1("id")%>">修</a></td>
        <td width="8%" style="border-top-style: none; border-top-width: medium" height="20">
            <a onclick='{if(confirm("此操作将删除招聘职位是【<%=rs1("jobs")%>】的资料！你确认吗?")){return true;}return false;}' href="Adminjobsdel.asp?id=<%=rs1("id")%>">删</a></td>
      </tr>
      <%
      rs1.movenext
      loop
	  end if
	  rs1.close
	  set rs1=nothing 
      rs.movenext
      loop
      rs.close
      set rs=nothing
      call closedb
      %>
    </table>
    </td>
    <td width="16" height="236" valign="top">　</td>
  </tr>
</table>

  </center>
</div>
<!--#include file=copyright.asp-->
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -