开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > 数据库编程 > 查看源码
job_search_result.asp
资源名称：eat.rar　[点击查看]
上传用户：jisenq
上传日期：2014-06-29
资源大小：7216k
文件大小：5k
源码类别：

数据库编程

开发平台：

ASP/ASPX

job_search_result.asp：源码内容
  1. <% Option Explicit %>
  2. <!--#include file="../../FS_Inc/Const.asp" -->
  3. <!--#include file="../../FS_InterFace/MF_Function.asp" -->
  4. <!--#include file="../../FS_Inc/Function.asp" -->
  5. <!--#include file="../../FS_Inc/Func_page.asp" -->
  6. <!--#include file="../lib/strlib.asp" -->
  7. <!--#include file="../lib/UserCheck.asp" -->
  8. <!--Copyright (c) 2006 Foosun Inc. Code by Einstein.liu-->
  9. <html xmlns="http://www.w3.org/1999/xhtml">
  10. <title>User Manage Center-网站内容管理系统</title>
  11. <meta name="keywords" content="风讯cms,cms,FoosunCMS,FoosunOA,FoosunVif,vif,风讯网站内容管理系统">
  12. <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
  13. <meta content="MSHTML 6.00.3790.2491" name="GENERATOR" />
  14. <link href="../images/skin/Css_<%=Request.Cookies("FoosunUserCookies")("UserLogin_Style_Num")%>/<%=Request.Cookies("FoosunUserCookies")("UserLogin_Style_Num")%>.css" rel="stylesheet" type="text/css">
  15. <head>
  16. <script language="javascript" src="../../FS_Inc/CheckJs.js"></script>
  17. <script language="javascript" src="../../FS_Inc/prototype.js"></script>
  18. <script language="javascript" src="../../FS_Inc/PublicJS.js"></script>
  19. </head>
  20. <body>
  21. <table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
  22.   <tr>
  23.     <td><!--#include file="../top.asp" -->
  24.     </td>
  25.   </tr>
  26. </table>
  27. <table width="98%" height="135" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
  28.   <tr class="back">
  29.     <td   colspan="2" class="xingmu" height="26"><!--#include file="../Top_navi.asp" -->
  30.     </td>
  31.   </tr>
  32.   <tr class="back">
  33.     <td width="18%" valign="top" class="hback"><div align="left">
  34.         <!--#include file="../menu.asp" -->
  35.       </div></td>
  36.     <td width="82%" valign="top" class="hback">
  37. <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
  38. <tr class="xingmu">
  39. <td colspan="7">职位搜索结果</td>
  40. </tr>
  41. <tr class="xingmu">
  42. <td>职位名称</td>
  43. <td align="center">公司名称</td>
  44. <td align="center">简历语言</td>
  45. <td align="center">工作地点</td>
  46. <td align="center">招聘人数</td>
  47. <td align="center">发布日期</td>
  48. <td align="center">结束日期</td>
  49. </tr>
  50. <%
  51. Dim Rs,job,workcity,publicdate,condition
  52. job=trim(request.Form("JobName"))
  53. workcity=trim(request.Form("workcity"))
  54. publicdate=trim(request.Form("hd_publicdate"))
  55. if job<>"" then
  56. condition=" And JobName like '"&job&"'"
  57. End if
  59. if workcity<>"" then
  60. condition=condition&" And workcity ='"&workcity&"'"
  61. End if
  63. if publicdate<>"" then
  64. Dim dateCondition
  65. dateCondition=DateValue(Now())-Cint(publicdate)
  66. if G_IS_SQL_DB=0 then
  67. condition=condition&" And publicdate>#"&dateCondition&"#"
  68. Else
  69. condition=condition&" And publicdate>'"&dateCondition&"'"
  70. End if
  71. End if
  72. if G_IS_SQL_DB=0 then
  73. Set Rs=Conn.execute("Select PID,UserNumber,JobName,JobDescription,ResumeLang,WorkCity,PublicDate,EndDate,NeedNum from FS_AP_Job_Public where 1=1 "&condition&" And (EndDate>#"&DateValue(Now())&"# or EndDate=#"&DateValue(Now())&"#)")
  74. else
  75. Set Rs=Conn.execute("Select PID,UserNumber,JobName,JobDescription,ResumeLang,WorkCity,PublicDate,EndDate,NeedNum from FS_AP_Job_Public where 1=1 "&condition&" And (EndDate>'"&DateValue(Now())&"' or EndDate='"&DateValue(Now())&"')")
  76. End if
  77. Dim meRs,corpName
  78. while not Rs.eof
  79. Response.Write("<tr height='25' onMouseOver=overColor(this) onMouseOut=outColor(this) onClick=""javascript:Element.toggle('descripe_"&Rs("PID")&"')"">"&vbcrlf)
  80. Response.Write("<td class='hback'>"&Rs("JobName")&"</td>"&vbcrlf)
  81. Set meRs=User_Conn.execute("Select C_Name,C_WebSite from FS_ME_CorpUser where UserNumber='"&Rs("UserNumber")&"'")
  82. if not meRs.eof then
  83. if MeRs("C_WebSite")<>"" then
  84. corpName="<a href="""&MeRs("C_WebSite")&""" target=""_blank"">"&meRs("C_Name")&"</a>"
  85. Else
  86. corpName=meRs("C_Name")
  87. End if
  88. Else
  89. corpName="无"
  90. End if
  91. Response.Write("<td class='hback' align='center'>"&corpName&"</td>"&vbcrlf)
  92. Response.Write("<td class='hback' align='center'>"&Rs("WorkCity")&"</td>"&vbcrlf)
  93. Response.Write("<td class='hback' align='center'>"&Rs("ResumeLang")&"</td>"&vbcrlf)
  94. Response.Write("<td class='hback' align='center'>"&Rs("NeedNum")&"</td>")
  95. Response.Write("<td class='hback' align='center'>"&Rs("PublicDate")&"</td>")
  96. Response.Write("<td class='hback' align='center'>"&Rs("EndDate")&"</td>")
  97. Response.Write("<tr id='descripe_"&Rs("PID")&"' style=""display:'none'"">"&vbcrlf)
  98. Response.Write("<td colspan='7' class='hback' >职位说明："&Rs("JobDescription")&"</td>"&vbcrlf)
  99. Response.Write("</tr>"&vbcrlf)
  100. Rs.movenext
  101. Wend
  102. %>
  103. </table>
  104. </td>
  105.   </tr>
  106.   <tr class="back">
  107.     <td height="20"  colspan="2" class="xingmu"><div align="left">
  108.         <!--#include file="../Copyright.asp" -->
  109.       </div></td>
  110.   </tr>
  111. </table>
  112. </body>
  113. </html>
  114. <%
  115. 'if not isnull(Conn) then Conn.close
  116. 'if not isnull(User_Conn) then User_Conn.close
  117. Set User_Conn=nothing
  118. Set Conn=nothing
  119. %>
  120. <script language="javascript">
  121. <!--
  122. -->
  123. </script>
  124. <!-- Powered by: FoosunCMS4.0系列,Company:Foosun Inc. -->