www.gusucode.com > 528人才招聘网整站源代码-蓝色经典 精简版 2.0源码程序 > add_job_db.asp

    <!--#include file="info.asp"-->
<!--#include file="conn.asp"-->
<%
if Request.Cookies("id")="" or Request.Cookies("ac")="" or Request.Cookies("user")<>"2" then
response.write "<script language=JavaScript>" & chr(13) & "alert('您还未登陆或登录超时,请重新登录后操作!!');" & "history.back()" & "</script>" 
Response.End
end if
if request("job")="0" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请选择职位类型!');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("jtzw"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('具体位置不能为空!');" & "history.back()" & "</script>" 
Response.End
end if
if request("hka")="0" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请选择工作地区!');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("city"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('所在城市不能为空!');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("zptext"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('岗位职责描述不能为空!');" & "history.back()" & "</script>" 
Response.End
end if
if len(request("zptext"))>300 then
response.write "<script language=JavaScript>" & chr(13) & "alert('岗位职责描述不能超过300字!');" & "history.back()" & "</script>" 
Response.End
end if
sql="select id from job where enid="&clng(Request.Cookies("id"))
rs.open sql,conn,1,1
if Request.Cookies("vip")="false" then
if rs.recordcount>=en_max2 then
rs.close
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('普通用户免费招聘发布空间为"&en_max2&"个,若您需要更多的发布职位空间,请升级成VIP用户,一次性付费200元,终身拥有20个职位空间(以后不用续费),付费方式请见返回后页面左下方的“付款方式”!');" & "history.back()" & "</script>" 
Response.End
end if
else
if rs.recordcount>=20 then
rs.close
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('抱歉,您发布职位空间已满!请另外购买空间,200元/20个(终身享有,以后不用续费)。');" & "history.back()" & "</script>" 
Response.End
end if
end if
rs.close
sql="insert into job(enid,job,jtzw,hka,city,zpnum,nianlings,zyes,hkas,edus,hkbs,languages,pthuas,sexs,jobtypes,marrys,computers,shisus,moneys,youxiaos,zptext) values("&Request.Cookies("id")&",'"&request("job")&"','"&request("jtzw")&"','"&request("hka")&"','"&request("city")&"','"&request("zpnum")&"','"&request("nianlings")&"','"&request("zyes")&"','"&request("hkas")&"','"&request("edus")&"','"&request("hkbs")&"','"&request("languages")&"','"&request("pthuas")&"','"&request("sexs")&"','"&request("jobtypes")&"','"&request("marrys")&"','"&request("computers")&"','"&request("shisus")&"','"&request("moneys")&"','"&request("youxiaos")&"','"&request("zptext")&"')"
rs.open sql,conn,1,1
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('发布成功,即将返回!');"&"window.location.href = 'enjob.asp'"&" </script>"

%>