⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 x_company.asp

📁 人才招聘系统,用asp做的
💻 ASP
字号:
🔍 
<!--#include file=../conn.asp-->
<!--#include file=usercookies.asp-->
<!--#include file=onlinerz.asp-->
<%
dim rs,sql,Pagesize,k,Allrecord,Allpage,ThisPage,usersize,taller,sql1
dim diqu,quanxian
if request("page")="" then
  ThisPage=1		
else
  ThisPage=request("page")
end if
diqu=request.cookies("quyu")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>企业用户管理</title>
<link rel="stylesheet" type="text/css" href="../1.css">
</head>
<body>
<%
dim cmdTemp
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs = server.CreateObject ("adodb.recordset")
if request("username1")="" then
sql="select id,username,comid,companyName,dlcs,dlsj,city,contactPerson,vip from [company] where city like '%"&diqu&"%'"
else
sql="select id,username,comid,companyName,dlcs,dlsj,city,contactPerson,vip from [company] where and city like '%"&diqu&"%' and UserName like '%"&request("UserName1")&"%'or companyName like  '%"&request("UserName1")&"%'"
end if
cmdTemp.CommandText = sql
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn   
rs.Open cmdTemp,,1,1
set cmdTemp=nothing
If rs.eof or rs.bof Then
response.write "<br>没有找到企业！"
response.end
end if
if request("usersize")="" then
rs.Pagesize=50
else
rs.Pagesize=trim(request("usersize"))
end if
  Pagesize=rs.Pagesize
  Allrecord=rs.Recordcount
  Allpage=rs.Pagecount
  if ThisPage<1 then                           
  ThisPage=1                           
  end if   
  rs.move  (ThisPage-1)*Pagesize
%><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-top-width: 0" bordercolor="#111111" width="100%">
  <tr>
    <td width="100%" style="border-top-style: none; border-top-width: medium" height="20" bgcolor="#C6AD94">
    <p align="right"><font color="#FFFFFF"><b>记录总数：</b></font><b><font color="#22446A"><%=Allrecord%></font></b></td>
  </tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-width:0; border-right-width:0; border-top-width:0" bordercolor="#111111" width="100%">
  <tr>
    <td width="100%" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1" height="20" bgcolor="#FFFFFF" colspan="7">
<%call fenye%></td>
  </tr>
  <tr>
    <td width="5%" height="20" bgcolor="#5B6C77" align="center" style="border-style: none; border-width: medium">
    <font color="#FFFFFF">用户名</font></td>
    <td width="22%" height="20" bgcolor="#5B6C77" align="center" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom-style:none; border-bottom-width:medium">
    <font color="#FFFFFF">公司名称</font></td>
    <td width="16%" height="20" bgcolor="#5B6C77" align="center" style="border-style: none; border-width: medium">
    <font color="#FFFFFF">发布职位数</font></td>
    <td width="2%" height="20" bgcolor="#5B6C77" align="center" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom-style: none; border-bottom-width: medium">
    <font color="#FFFFFF">登陆次数</font></td>
    <td width="6%" height="20" bgcolor="#5B6C77" align="center" style="border-style: none; border-width: medium">
    <font color="#FFFFFF">联系人</font></td>
    <td width="5%" height="20" bgcolor="#5B6C77" align="center" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom-style: none; border-bottom-width: medium">
    <font color="#FFFFFF">所在地区</font></td>
    <td width="44%" height="20" bgcolor="#5B6C77" align="center" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom-style: none; border-bottom-width: medium">
    <font color="#FFFFFF">最后登陆时间</font></td>
  </tr>
  <%do while not rs.eof%>
<%
sql1="select count(id) from [jobs] where comid='"&rs("comid")&"'"
taller=conn.execute(sql1)(0)
%>
  <tr>
    <td width="10%" height="20" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#E1E1E1"><%=rs("username")%></td>
    <td width="13%" height="20" align="center" style="border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium" bgcolor="#E1E1E1">
    <a target="_blank" href="../company/listcompany.asp?comid=<%=rs("comid")%>"><%=rs("companyName")%></a></td>
    <td width="20%" height="20" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#E1E1E1">发布了<b><font color="#FF0000"><%=taller%></font></b>条招聘信息</td>
    <td width="7%" height="20" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#E1E1E1"><%=rs("dlcs")%></td>
    <td width="11%" height="20" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#E1E1E1"><%=rs("contactPerson")%></td>
    <td width="10%" height="20" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#E1E1E1"><%=rs("city")%></td>
    <td width="29%" height="20" align="center" style="border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1; border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium" bgcolor="#E1E1E1"><%=rs("dlsj")%></td>
  </tr>
  <tr>
    <td width="10%" height="20" align="center" bordercolor="#666666" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1">　</td>
    <td width="13%" height="20" align="center" bordercolor="#666666" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom: 1px solid #111111">　</td>
    <td width="20%" height="20" align="center" bordercolor="#666666" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom: 1px solid #111111">　</td>
    <td width="7%" height="20" align="center" bordercolor="#666666" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom: 1px solid #111111">　</td>
    <td width="11%" height="20" align="center" bordercolor="#666666" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom: 1px solid #111111">　</td>
    <td width="39%" height="20" align="center" bordercolor="#666666" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom: 1px solid #111111" colspan="2">
        <p><font color="#666666">
        &nbsp;&nbsp;&nbsp;</font><a href="adminqunfa.asp?username=<%=rs("username")%>&oo=company"><img border="0" src="images/email.gif" alt="发送邮件"></a>
        </td>
  </tr>
<%
k=k+1
if k>=Pagesize then exit do
rs.movenext
loop 
%>
</table>

</body>

</html>
<%call fenye%><%sub fenye%><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
  <tr>
    <td width="28%" height="20"><form method="POST" action="">每页显示的记录数：<input type="text" name="usersize" size="3" value="80">
      <input border="0" src="../img/x_1.gif" name="I1" type="image"></form></td>
    <td width="72%" height="20"><form method="POST" action="">快速查找用户：<input type="text" name="username1" size="10">
      <input border="0" src="../img/x_1.gif" name="I1" type="image">（输入<font color="#FF0000">用户名</font>或<font color="#FF0000">企业名称</font>）</form>
    </td>
  </tr>
  </table>
<p align="left">每页显示<b><font color="#F06000"><%=Pagesize%></font></b>条记录&nbsp;总共<font color="#F06000"><b><%=Allpage%></b></font>页&nbsp; 目前第<b><font color="#F06000"><%=ThisPage%></font></b>页&nbsp; 
    <a href=?page=1&usersize=<%=request("usersize")%>&username1=<%=request("UserName1")%>>首页</a>&nbsp; <%if ThisPage<2 then%>上一页<%else%><a href=?page=<%=ThisPage-1%>&usersize=<%=request("usersize")%>&username1=<%=request("UserName1")%>>上一页</a><%end if%>&nbsp; <%if Allpage-ThisPage<1 then%>下一页<%else%><a href=?page=<%=ThisPage+1%>&usersize=<%=request("usersize")%>&username1=<%=request("UserName1")%>>下一页<%end if%></a>
    &nbsp; <a href=?page=<%=Allpage%>&usersize=<%=request("usersize")%>&username1=<%=request("UserName1")%>>尾页</a></p><%end sub
rs.close
set rs=nothing
conn.close
set conn=nothing
%>

⌨️ 快捷键说明

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