ÇóÖú£º£¿£¿£¿£¿£¿

¨€¨€¨€¨€

ÇëÎÊÏÂÃæÁ½ÐкìÉ«ÏÔʾµÄ´úÂëÓдíÎóÂð£¿


<!--#include file="config/conn.asp"-->
<%
area=request("area")
hangye=request("hangye")
zhineng=request("zhineng")
presstime=request("presstime")
corpname=request("corpname")
leibie=request("leibie")
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from Job_Cleag inner join Job_Cleag_pressjob on Cleag_id=Job_id where job_flag=1"
if corpname<>" " then
if leibie="¹«Ë¾" then
sql=sql&"and Cleag_corpname like '%"&corpname&"%' "
else
if zhineng= " " then
sql=sql&" and Job_jobname like '%"&zhineng&"%' "
end if
end if
end if
if area<>" " then sql=sql&" and job_workplace='"&area&"' "
'if hangye<>" " then sql=sql&"and Job_jobdo='"&hangye&"' "
if zhineng<> " " then sql=sql&" and Job_jobdo='"&zhineng&"' "
if presstime<>" " then sql=sql& "and DateDiff('d',DateValue(Job_pressdate),DateValue(now()))='"&cint(presstime)&"' "
response.write sql
rs.open sql,conn,1,1 //´Ë¶ÎÏÔʾ´íÎó
if rs.bof and rs.eof then
response.write "<script>alert('Êý¾Ý¿âÖÐÔÝÎÞÄúÒªµÄÊý¾Ý!');{window.location='index.asp'};</script>"
else
for i=1 to rs.recordcount
response.write "<br>"&(rs("Job_jobname"))
rs.movenext
next
end if
rs.close
set rs=nothing