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

📄 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
if request("page")="" then
  ThisPage=1		
else
  ThisPage=request("page")
end if
%>
<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>
<div align="center">
  <center>
<table border="1" cellPadding="3" cellSpacing="0" class="tableBorder" width="100%" style="border-collapse: collapse" bordercolor="#111111">
    <tr>
 <form action="delperson.asp" method="post">
      <th align="left" height="23" width="30%" style="border-right-style: solid; border-right-width: 1" bgcolor="#FFFFFF">
      <span style="font-size: 9pt; font-weight:400">删除<font color="#FF0000">指定企业</font>的资料</span></th>
      <th align="left" height="23" width="30%" bgcolor="#FFFFFF">
      <span style="font-size: 9pt">
      <span style="font-weight: 400">用户名：</span><input name="username" size="11" maxlength="20"></span></th>
      <th align="left" height="23" width="10%" bgcolor="#FFFFFF">
      <input border="0" src="../img/x_1.gif" name="I1" type="image"></th>
      <th align="left" height="23" width="30%" bgcolor="#FFFFFF">
      <p align="center"><span style="background-color: #99CCFF">
      <a onclick='{if(confirm("此操作将没有发布职位的企业删除，建议你执行此操作前先备份数据库，以免出错！")){return true;}return false;}' href="delcompanynone.asp"><font size="2">清除数据库中的<font color="#FF0000">垃圾企业会员</font></font></a><a href="delcompanynone.asp"></a></span></th>
    </form>
    </tr>
</table>
  </center>
</div>
<div align="center">
  <center>
<table border="1" cellPadding="3" cellSpacing="0" class="tableBorder" width="100%" style="border-collapse: collapse; border-top-width: 0" bordercolor="#111111">
    <tr>
 <form action="delpersondata.asp" method="post">
      <th align="left" height="23" width="30%" style="border-top-style: none; border-top-width: medium; border-right-style:solid; border-right-width:1" bgcolor="#FFFFFF">
      <span style="font-size: 9pt; font-weight:400">删除<font color="#FF0000">多少天</font>没有登陆的企业</span></th>
      <th align="left" height="23" width="30%" style="border-top-style: none; border-top-width: medium" bgcolor="#FFFFFF">
      <span style="font-size: 9pt">
      <input name="data" size="6" value="365" maxlength="10"><span style="font-weight: 400">天没有登陆</span></span></th>
      <th align="left" height="23" width="10%" style="border-top-style: none; border-top-width: medium" bgcolor="#FFFFFF">
      <input border="0" src="../img/x_1.gif" name="I1" type="image"></th>
      <th align="left" height="23" width="30%" style="border-top-style: none; border-top-width: medium" bgcolor="#FFFFFF">
      <span style="font-size: 9pt; font-weight:400">
      （只能为数字）</span></th>
    </form>
    </tr>
</table>

  </center>
</div>

<div align="center">
  <center>
<table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse; border-top-width: 0" bordercolor="#111111" width="100%" height="27">
    <form action="delpersondlcs.asp" method="POST">
    <tr>
      <td width="30%" height="27" style="border-top-style: none; border-top-width: medium">
      删除<font color="#FF0000">登陆次数</font>少于几次的用户</td>
      <td height="27" style="border-top-style: none; border-top-width: medium" width="30%">
      只<span style="font-size: 9pt">登陆了<input name="dlcs" size="6" value="5" maxlength="10">次</span></td>
      <td width="10%" height="27" style="border-top-style: none; border-top-width: medium">
      <input border="0" src="../img/x_1.gif" name="I1" type="image"></td>
      <td width="30%" height="27" style="border-top-style: none; border-top-width: medium">
      <span style="font-size: 9pt">
      （只能为<font color="#F06000">数字</font>）</span></td>
    </tr>
    </form>
  </table>

  </center>
</div>
<%
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,Province,contactPerson,vip from [company] "
else
sql="select id,username,comid,companyName,dlcs,dlsj,Province,contactPerson,vip from [company] where 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("Province")%></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 align="right"><font color="#666666">
        <a onclick="{if(confirm(&quot;此操作将删除用户{{{“<%=rs("companyname")%>”}}}！建议你执行此操作前先备份数据库，以免出错！&quot;)){return true;}return false;}" href="delperson.asp?username=<%=rs("username")%>">
        <img border="0" src="images/del.gif" alt="删除"></a> &nbsp;<a href="edituser_1.asp?username=<%=rs("comid")%>"><img border="0" src="images/edit.gif" alt="编辑"></a>&nbsp; </font> 
        <a href="adminqunfa.asp?username=<%=rs("username")%>&oo=company">
        <img border="0" src="images/email.gif" alt="发送邮件"></a>
        <a href="vip_admin.asp?id=<%=rs("id")%>"><img border="0" src="../images/vip.gif" alt="加入VIP会员"></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 + -