<!--#include file="../Include/Conn.asp" -->
<!--#include file="../Include/Char.asp" -->
<!--#include file="../Include/const.asp" -->
<!--#include file="../Include/function.asp" -->
<HTML><HEAD><TITLE>职位搜索</TITLE>
<META http-equiv=Content-type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>

<link href="../Include/style1.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 marginheight="0" 
marginwidth="0">
<!--#include file="../Include/Top.asp" -->
<TABLE width="770" border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="FCAF17">
  <TBODY>
  <TR>
    <TD width="768"  bgColor=#ffffff>
      <TABLE width="100%" height=30 border=0 cellPadding=4 cellSpacing=0 bgcolor="FCAF17">
        <TBODY>
        <TR>
              <TD width="46%" class=nav>当前位置: <A 
            href="../index.asp">首页 </A>-&gt; 职位搜索</TD>
              <TD width="54%" > 
                <!--#include file="IncNewsSearch.asp" -->
              </TD>
      </TR></TBODY></TABLE></TD></TR>
</TBODY></TABLE>
<TABLE width="770" border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="#FFFFFF">
  <TBODY>
    <TR vAlign=top>
      <!-- left -->
      <TD width="169" bgcolor="FCAF17" >
        <!--#include file="Left.asp" -->
      </TD>
     
      
      <TD width="588"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td align="left" valign="top"><img src="../image/job_03.gif" width="100%" height="14"></td>
          </tr>
        </table>
        <TABLE cellSpacing=0 cellPadding=0 width="98%" align=center 
border=0>
        <TBODY>
              <TR>
                <TD height=15><TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
                    <TBODY>
                      <TR>
                        
                    <TD align=left valign="bottom"><FONT color=#ff6600><B>信息查询</B></FONT></TD>
                      </TR>
                      <TR>
                        <TD height=4></TD>
                      </TR>
                      <TR>
                        <TD bgColor=#A47002 height=1></TD>
                      </TR>
                    </TBODY>
                </TABLE></TD>
              <TR>
                
            <TD valign="top"> <table width="100%" height="46" border="0" cellpadding="0" cellspacing="0">
                <TR>
                        
                  <TD valign="top" class=p6> 
                    <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
                    <TBODY>
                      <TR bgColor=FCAF17> 
                        <TD width=9% align="center" vAlign=top noWrap><font color="#FFFFFF"><strong>编号</strong></font></TD>
                        <TD width="16%" align="center" vAlign=top><font color="#FFFFFF"><strong>职位</strong></font></TD>
                        <TD width="8%" align="center" vAlign=top><font color="#FFFFFF"><strong>性别</strong></font></TD>
                            <TD width="8%" align="center" vAlign=top><font color="#FFFFFF"><strong>人数</strong></font></TD>
                        <TD width="16%" align="center" vAlign=top><font color="#FFFFFF"><strong>招聘部门</strong></font></TD>
                        <TD width="14%" align="center" vAlign=top><font color="#FFFFFF"><strong>工作性质</strong></font></TD>
                        <TD width="17%" align="center" vAlign=top><font color="#FFFFFF"><strong>学历</strong><br>
                          </font></TD>
                            <TD width="12%" align="center" vAlign=top><font color="#FFFFFF"><strong>查看</strong></font></TD>
                      </TR>
                      <TR bgColor=#A47002> 
                          <TD height="6" colspan="8" noWrap></TD>
                      </TR>
                  </table>
				  <TABLE width="100%" 
                  border=0 align=center cellPadding=0 cellSpacing=1 bgcolor="#FFFFFF">
                      <TBODY>
                        <TR> 
                          <TD height=1></TD>
                        </TR>
                        <%
    dim m_RecordCount,m_PageNo,m_Page
    m_RecordCount=0 : m_PageNo=0 : m_Page=0
	m_PageSize = 27 '每页显示数录数
    m_PageNo = Trim(Request.querystring("PageNo"))
	Set rs = Server.createobject("Adodb.RecordSet")

    m_Keywords = checkStr(Trim(Request("Keywords")))
	if m_keywords="关键字搜索..." then m_keywords=""
    m_SpecialityID = checkStr(Trim(Request("SpecialityID")))
    m_Sex = checkStr(Trim(Request("Sex")))
    xl_appeal=checkstr(Trim(Request("xl_appeal")))


	m_Parameter = "Keywords="&m_Keywords&"&SpecialityID="&m_SpecialityID&"&Sex="&m_Sex&"&xl_appeal="&xl_appeal
    m_SQL = "SELECT * FROM T_zhaopin WHERE (X_Auditing=1)"
	
    'If (m_SpecialityID <> "-1") and (m_SpecialityID <> "") then
	 ' m_SQL = m_SQL + " and X_job="&m_SpecialityID
	'End if
	
	If (m_Sex <> "-1") and (m_Sex <> "") then
	  m_SQL = m_SQL + " and X_sex='"&m_Sex&"'"
	End if
	
	if (xl_appeal<>"-1") and (xl_appeal<>"") then
	  m_SQL=m_SQL+"  and X_xl_appeal='"&xl_appeal&"'"
    End if	  


	m_SQL = m_SQL +" and (X_job like  '%" & m_Keywords & "%'"
	m_SQL= m_SQL +" and X_job like '%"&m_SpecialityID&"%'"
	m_SQL = m_SQL +" or X_department like  '%" & m_Keywords & "%')"
	

	m_SQL = m_SQL +" ORDER BY X_date DESC"
	'RESPONSE.WRITE M_SQL
	rs.open m_SQL,conn,1,1
	if rs.Eof then
	   response.write "<br><p align='center'><font color=000000><B>对不起，找不到您要查的信息！</B></font></p><br>"
    else
      m_RecordCount = rs.RecordCount
      rs.PageSize = m_PageSize
      m_Page = rs.PageCount
      if m_PageNo = ""  then m_PageNo =1
      if cint(m_PageNo) < 1 or cint(m_PageNo) > m_Page then m_PageNo = 1
      rs.AbsolutePage = m_PageNo
      rc = m_PageSize
      re = 1
	  m_Count = 0'另加
      Do while not rs.eof and rc>0
	  m_Count = m_Count +1'另加
	  if m_Count mod 2 then m_BgColor = "ffffff" else m_BgColor = "efefef" '另加
        '---------------------------------
		'调用显示内容
        ShowContent()
        '---------------------------------

	  rs.MoveNext
      re = re+1
      rc = rc-1
    Loop
	rs.Close
 End if	
 Sub ShowContent()
 %>
                        <TR align=center bgColor=#fafafa> 
                            <TD width=9% vAlign=top noWrap><%=m_Count%></TD>
                            <TD width="16%" vAlign=top><%=rs("X_job")%></TD>  <TD width="8%" vAlign=top><%=rs("X_Sex")%></TD>
                            <TD width="8%" vAlign=top><%=rs("X_Count")%> </TD>
                            <TD width="16%" vAlign=top><%=rs("X_department")%></TD>
                            <TD width="14%" vAlign=top><%=rs("X_kind")%></TD>
                            <TD width="17%" vAlign=top><%=rs("X_xl_appeal")%></TD>  
                            <TD width="12%" vAlign=top><a href='Company_job.asp?id=<%=rs("id")%>' target="_blank">查看</a></TD>
                        </TR>
                        <% 
end sub
Call ShowPage(m_Parameter)'调用示分页过程%%>
                      </TBODY>
                    </TABLE> 
					
                  </TD>
                  </TR>
                    
                  </TABLE>
          </TBODY>
        </TABLE>
		
      </TD>
    </TR>
  </TBODY>
</TABLE>
<!--#include file="../Include/Bottom.asp" -->
</BODY></HTML>
