<!--#include file="conn.asp"-->
<!--#include file="../inc/setup.asp"-->
<!--#include file="check.asp"-->
<!--#include file="../inc/sql.asp"-->
<%
	end if
	useflag=4
%>
<!--#include file="flag.asp"-->
<%

	action=Trim(Request.QueryString("action"))
	if action="sh" then
		id=Trim(Request.QueryString("id"))
		conn.Execute ("update jianzhi set shenhe=1 where id="&id&"")
		response.write"<SCRIPT language=JavaScript>alert('兼职信息审核成功，现在为您返回！');"
		response.write"this.location.href='jianzhi_xpublish.asp';</SCRIPT>"
		response.end
	end if
	
	if action="nosh" then
		id=Trim(Request.QueryString("id"))
		conn.Execute ("update jianzhi set shenhe=0 where id="&id&"")
		response.write"<SCRIPT language=JavaScript>alert('兼职信息取消审核成功，现在为您返回！');"
		response.write"this.location.href='jianzhi_xpublish.asp';</SCRIPT>"
		response.end
	end if
	
	if action="del" then
		id=Trim(Request.QueryString("id"))
		conn.Execute ("delete from jianzhi where id="&id&"")
		response.write"<SCRIPT language=JavaScript>alert('兼职信息删除成功，现在为您返回！');"
		response.write"this.location.href='jianzhi_xpublish.asp';</SCRIPT>"
		response.end
	end if

%>
<script src='Include/Common.js'></script>
<link href='Include/Admin_Style.CSS' rel='stylesheet' type='text/css'>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="sortbutton">
<tr>    
<td width="27%" height="23" align="center" valign="middle">免费兼职信息管理
<td width="73%" align="center" valign="middle"><table width="100%" border="0">
<form name="form2" method="get">
<input name="action" type="hidden" value="search" />
        <tr>
          <td width="19%">
		  <Input maxLength=30 name="uname" value="职位名称" onMouseOver="if(this.value=='职位名称'){this.value=''}" title="职位名称">
		  </td>
          <td width="63%"><input class="button" type="submit" value="提交条件"></td>
        </tr>
</form>
</table>
</tr>
</table>
<table width="100%" style="MARGIN-TOP: 3px" border="0" align="center" cellspacing="1" cellpadding="1"  class="Border">
<tr height="25" align="center" class='title'>
	<td width='6%' nowrap>选择</td>
	<td width="10%" nowrap>类型</td>
	<td width="10%" nowrap>联系人</td>
	<td width="15%" nowrap>主题</td>
	<td width="11%" nowrap>联系电话</td>
	<td width="14%" nowrap>工作地点</td>
	<td width="11%" nowrap>有效期</td>
	<td width="11%" nowrap>审核状态</td>
	<td width="12%" nowrap>修改</td>
</tr>
<form name="selform" method="post" action="?action=del">
<%

	searchtype=""
	
	if Trim(Request.QueryString("action"))="search" then
	
		uname=Trim(Request.QueryString("uname"))
	
		searchtype="where title like '%"&uname&"%'"
	
	end if

	dim i,intPage,page,pre,last,filepath'定义变量
	set rs_user = server.CreateObject("adodb.recordset")'创建对象
	sql="select * from jianzhi "&searchtype&" order by id desc"'定义SQL语句
	rs_user.PageSize = 13 '这里设定每页显示的记录数
	rs_user.CursorLocation = 3
	rs_user.Open sql,conn,0,2,1 '这里执行你查询SQL并获得结果记录集
	pre = true
	last = true
	page = trim(Request.QueryString("page"))'变量是跳转页面时的值

	if len(page) = 0 then
		intpage = 1
		pre = false
	else
		if cint(page) =< 1 then
			intpage = 1
			pre = false
		else
			if cint(page) >= rs_user.PageCount then
				intpage = rs_user.PageCount
				last = false
			else
				intpage = cint(page)
			end if
		end if
	end if
	
	if not rs_user.eof then
		rs_user.AbsolutePage = intpage
	end if
	
	if rs_user.eof then
		response.Write "<tr><td colspan=9><div align=center><font size=3 color=red><b>没有该兼职信息，请查询后再重试</b></font></div></td></tr>"
		response.End
	else
	
		for i=1 to rs_user.PageSize
		if rs_user.EOF or rs_user.BOF then exit for
%>
<tr height="25" align=center class='tdbg' onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'">
	<td><input type="checkbox" name="id" value="<%= rs_user("id") %>"></td>
	<td><% if rs_user("ttype")=1 then Response.Write("做兼职") else Response.Write("请兼职")%></td>
	<td><%= rs_user("lxname")%></td>
	<td><A HREF="../view_jianzhi.asp?id=<%= rs_user("id") %>" target="_blank"><font color="#FF0000"><%=left(rs_user("title"),10)%><% If len(rs_user("title"))>10 Then Response.Write("...")%></font></a></td>
	<td><%= rs_user("tel") %></td>
	<td><%=left(rs_user("address"),10)%><% If len(rs_user("address"))>10 Then Response.Write("...") %></td>
	<td><%=rs_user("lasttime")%></td>
	<td><% if rs_user("shenhe")=0 then Response.Write("<a href='?action=sh&id="&rs_user("id")&"'><font color='red'>未审核</font></a>") else Response.Write("<a href='?action=nosh&id="&rs_user("id")&"'>已审核</a>")%></td>
	<td><A HREF="#" onClick="window.open('jianzhi_xxpublish.asp?id=<%= rs_user("id") %>','修改详细信息','height=495, width=522, top=0, left=0, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no, status=no')"><font color="#FF0000">修改</font></a> || <a href="?action=del&id=<%= rs_user("id") %>" onclick='{if(confirm("删除后将无法恢复，您真的要删除么？")){return true;}return false;}'>删除</a></td>
</tr>
<%
		rs_user.movenext
		next
	End If
%>
<tr>
<td colspan=9>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="2" borderColorLight=#808080 borderColorDark=#ffffff>
<tr>
<%if rs_user.pagecount > 0 then%>
<td width="13%" align="left">当前页<%=intpage%>/<%=rs_user.PageCount%></td>
<%else%>
<td width="41%" align="left">当前页0/0</td><%end if%>
<td width="46%" align="right"> <a href="?page=1&action=<%= Trim(Request.QueryString("action")) %>&Keyword=<%= Trim(Request.QueryString("Keyword")) %>">首页</a>|
<%if pre then%>
<a href="?page=<%=intpage -1%>&action=<%= Trim(Request.QueryString("action")) %>&Keyword=<%= Trim(Request.QueryString("Keyword")) %>">上页</a>| <%end if%>
<%if last then%>
<a href="?page=<%=intpage +1%>&action=<%= Trim(Request.QueryString("action")) %>&Keyword=<%= Trim(Request.QueryString("Keyword")) %>">下页</a> |<%end if%>
<a href="?page=<%=rs_user.PageCount%>&action=<%= Trim(Request.QueryString("action")) %>&Keyword=<%= Trim(Request.QueryString("Keyword")) %>">尾页</a>|转到第
<select name="sel_page" onchange=javascript:location.href=this.options[this.selectedIndex].value>
<%
	for i = 1 to rs_user.PageCount
	if i = intpage then
%>
<option value="?page=<%=i%>&action=<%= Trim(Request.QueryString("action")) %>&Keyword=<%= Trim(Request.QueryString("Keyword")) %>" selected><%=i%></option>
<%else%> 
<option value="?page=<%=i%>&action=<%= Trim(Request.QueryString("action")) %>&Keyword=<%= Trim(Request.QueryString("Keyword")) %>"><%=i%></option>
<%
	end if
	next
	rs_user.close
	set rs_user=nothing
%>
</select>页</font></td>
</tr>
</table></td>
</tr>
<tr>
	<td  class='tdbg' onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" height='25' colspan=9>
	&nbsp;&nbsp;<input id="chkAll" onClick="CheckAll(this.form)" type="checkbox" value="checkbox"  name="chkAll">全选
	<input class=Button type="submit" name="Submit2" value=" 删 除 " onclick="{if(confirm('您确定要删除此兼职信息吗?')){this.document.selform.submit();return true;}return false;}">
	<input class=Button type="button" name="Submit3" value="清空所有兼职信息" onclick="{if(confirm('您确定要清空所有兼职信息吗?')){location.href='?action=delall';return true;}return false;}"></td>
</tr>
</form>
<tr>
	<td  class='tdbg' onMouseOver="this.className='tdbgmouseover'" onMouseOut="this.className='tdbg'" colspan=9 align=right>	</td>
</tr>
</table>