|
|
|
|
|
|
|
|
|
< %
duty1=request("jobs")
if duty1="" then
duty1=cint(request.querystring("jobs"))
'if(duty1<>"0" and InStr(duty1,",")>0) then
' duty1 = cint(request.querystring("position1"))
'else
' duty1 = cint(duty1)
'end if
end if
'response.write(duty1)
'response.end
select case duty1
case 9
xxDuty = " and duty in(9,22,23,24,25,26,27,28)"
case 1
xxDuty = " and duty in(1,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43)"
case 2
xxDuty = " and duty in(2,4,51,52,53,54,55,56,57,58,59)"
case 3
xxDuty = " and duty in(3,20,60,61,62,63,64,65,66,67,68,69,70,71,72)"
case 7
xxDuty = " and duty in(7,8,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92)"
case 5
xxDuty = " and duty in(5,118,93,94,95,96,97)"
case 11
xxDuty = " and duty in(11,98,99,100,101,102,103,104,105)"
case 15
xxDuty = " and duty in(15,106,107,108,109,110,111)"
case 12
xxDuty = " and duty in(12,10,112,113,114,116,117)"
case 6
xxDuty = " and duty in(6,119,120,121,122,123,124)"
case 16
xxDuty = " and duty in(16,115,125)"
case 13
xxDuty = " and duty in(13)"
case 17
xxDuty = " and duty in(17,44,45,46,47,48,49,50)"
end select
workplace1=request("workplace")
if workplace1="" then
workplace1=cint(request.querystring("workplace"))
end if
hopesalary1 = request("hopesalary")
if hopesalary1 ="" then
hopesalary1 =cint(request.querystring("hopesalary"))
end if
city1=request("city")
if city1 = "" then
city1=request.querystring("city")
end if
expire1=request("expire")
if expire1="" then
expire1=cint(request.querystring("expire"))
end if
rctype1 = request("rctype")
if rctype1 ="" then
rctype1 =cint(request.querystring("rctype"))
end if
worktime1=request("worktime")
if worktime1 = "" then
worktime1 = request.querystring("worktime")
end if
sex1=request("sex")
if sex1="" then
sex1=cint(request.querystring("sex"))
end if
education1=request("education")
if education1="" then
education1=cint(request.querystring("education"))
end if
truename1=request("truename")
searchsql=" "
if duty1<>0 and duty1<>14 and xxDuty="" then
searchsql=searchsql&" and duty="&duty1
else
searchsql=searchsql & xxDuty
end if
if (workplace1<>0 and workplace1<>32) then
searchsql=searchsql&" and workplace="&workplace1
end if
if (city1 <> "01" and city1 <> "0") then
rem searchsql=searchsql&" and city ="&city1
end if
if rctype1 <>"" then
if rctype1=1 then searchsql=searchsql&" and hopesalary<6 or worktime not in ('5锟斤拷8锟斤拷','8锟斤拷10锟斤拷','10锟斤拷锟斤拷锟斤拷')"
if rctype1=2 then searchsql=searchsql&" and hopesalary>=6 or worktime in ('5锟斤拷8锟斤拷','8锟斤拷10锟斤拷','10锟斤拷锟斤拷锟斤拷')"
end if
if hopesalary1 <>0 then
searchsql=searchsql&" and hopesalary="&hopesalary1
end if
if (expire1<>0 and expire1<>1) then
searchsql=searchsql&" and datediff(day,indate,getdate())<="&expire1
end if
if (education1<>0 and education1<>10) then
searchsql=searchsql&" and education="&education1
end if
if sex1<>0 then
searchsql=searchsql&" and sex="&sex1
end if
if truename1<>"" then
searchsql=searchsql&" and truename like '%" & truename1 & "%'"
end if
if worktime1 <> "" then
searchsql=searchsql&" and worktime = '" & worktime1 & "'"
end if
PageNum = 26
RowNum = PageNum
i=0
SubjectId = Request.QueryString ("SubjectId")
outStr = ""
sql = "SELECT distinct top 1000 pbid,max(id),max(truename),max(duty),max(education),max(workplace),max(indate),max(sex),max(worktime),max(hopesalary),max(email) from personalview where newflag<>0 "&searchsql&" and jlstatus=1 and status=1 and duty<127 group by pbid ORDER BY max(inDate) DESC"
'response.write(sql)
'response.end
set rs = server.CreateObject ("adodb.recordset")
rs.CursorType = 3
rs.Open sql,conn
dim dutyname,eduname,proname
set rs = PageOn(rs,PageNum)
if not rs.EOF then
while not rs.EOF and RowNum>0
Id = rs(1)
truename = rs(2)
duty = rs(3)
education = rs(4)
workplace = rs(5)
Indate = GetDateFormat(rs(6),2)
sex = rs(7)
worktime= rs(8)
hopesalary = rs(9)
mto= rs(10)
if hopesalary=0 then hopename="锟斤拷锟絟"
if hopesalary=1 then hopename="锟斤拷锟絟"
if hopesalary=2 then hopename="2锟絝锟斤拷锟斤拷"
if hopesalary=3 then hopename="2-5锟絝"
if hopesalary=4 then hopename="5-8锟絝"
if hopesalary=5 then hopename="8-15锟絝"
if hopesalary=6 then hopename="15-30锟絝"
if hopesalary=7 then hopename="30锟絝锟斤拷锟斤拷"
if sex=1 then sex="锟斤拷" else sex="女" end if
if duty=0 then dutyname="锟斤拷锟斤拷"
if duty=1 then dutyname="锟斤拷锟絙锟絆計"
if duty=2 then dutyname="锟斤拷锟絙锟斤拷锟絞"
if duty=3 then dutyname="锟斤拷锟絙锟斤拷锟絘"
if duty=4 then dutyname="CAD/CAM"
if duty=5 then dutyname="锟斤拷锟絈锟�"
if duty=6 then dutyname="锟斤拷锟节凤拷锟斤拷"
if duty=7 then dutyname="锟叫堬拷锟絀锟絅"
if duty=8 then dutyname="锟斤拷購锟斤拷T"
if duty=9 then dutyname="锟斤拷锟絀锟斤拷锟斤拷"
if duty=10 then dutyname="锟斤拷锟絙模锟斤拷"
if duty=11 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷"
if duty=12 then dutyname="锟斤拷锟斤拷模锟斤拷"
if duty=13 then dutyname="锟斤拷锟斤拷锟斤拷位"
if duty=14 then dutyname="锟斤拷锟斤拷锟斤拷位"
if duty=15 then dutyname="財锟秸曪拷計"
if duty=16 then dutyname="計锟斤拷C锟剿員"
if duty=17 then dutyname="锟斤拷锟斤拷锟絆計"
if duty=22 then dutyname="锟斤拷锟斤拷锟斤拷"
if duty=23 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷"
if duty=24 then dutyname="锟絀锟絓锟斤拷锟斤拷"
if duty=25 then dutyname="锟襟劃斤拷锟斤拷"
if duty=26 then dutyname="锟侥匡拷锟斤拷锟�"
if duty=27 then dutyname="锟斤拷I锟斤拷锟斤拷"
if duty=28 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷"
if duty=29 then dutyname="锟絆計锟斤拷锟絆"
if duty=30 then dutyname="锟斤拷席锟絆計锟斤拷"
if duty=31 then dutyname="锟絆計锟斤拷锟斤拷"
if duty=32 then dutyname="女锟絙锟絆計锟斤拷"
if duty=33 then dutyname="锟斤拷锟絙锟絆計锟斤拷"
if duty=34 then dutyname="童锟絙锟絆計锟斤拷"
if duty=35 then dutyname="锟斤拷锟斤拷/锟斤拷锟斤拷锟絆計锟斤拷"
if duty=36 then dutyname="泳锟絙锟絆計"
if duty=37 then dutyname="锟斤拷锟絜锟斤拷锟絆計锟斤拷"
if duty=38 then dutyname="锟揭居凤拷锟絆計锟斤拷"
if duty=39 then dutyname="牛锟叫凤拷锟絆計"
if duty=40 then dutyname="毛锟斤拷锟絆計锟斤拷"
if duty=41 then dutyname="皮锟斤拷/锟斤拷皮锟絆計锟斤拷"
if duty=42 then dutyname="锟結锟斤拷/锟介紗锟絆計锟斤拷"
if duty=43 then dutyname="锟絓锟接凤拷锟絆計"
if duty=44 then dutyname="锟斤拷锟斤拷O計锟斤拷"
if duty=45 then dutyname="锟斤拷锟斤拷锟絆計锟斤拷"
if duty=46 then dutyname="平锟斤拷锟絆計锟斤拷"
if duty=47 then dutyname="锟絎站锟絆計锟斤拷"
if duty=48 then dutyname="锟紻锟斤拷锟絆計锟斤拷"
if duty=49 then dutyname="锟斤拷锟狡凤拷O計锟斤拷"
if duty=50 then dutyname="锟街达拷锟絆計锟斤拷"
if duty=51 then dutyname="锟斤拷锟絞锟斤拷锟絆"
if duty=52 then dutyname="锟斤拷锟絞锟斤拷锟斤拷锟斤拷"
if duty=53 then dutyname="锟藉房锟斤拷锟斤拷"
if duty=54 then dutyname="锟狡版師"
if duty=55 then dutyname="锟接板師"
if duty=56 then dutyname="锟斤拷锟铰癸拷藝锟斤拷"
if duty=57 then dutyname="锟斤拷锟絞锟絚锟截涳拷锟斤拷锟�"
if duty=58 then dutyname="锟狡檔/锟脚碼锟斤拷锟斤拷"
if duty=59 then dutyname="锟斤拷锟斤拷锟脚帮拷T"
if duty=60 then dutyname="锟斤拷锟絘锟絊锟絃"
if duty=61 then dutyname="锟斤拷锟絘锟斤拷锟絆"
if duty=62 then dutyname="锟斤拷锟絘锟斤拷锟斤拷锟斤拷"
if duty=63 then dutyname="車锟絞锟斤拷锟斤拷"
if duty=64 then dutyname="锟斤拷锟絙锟斤拷锟斤拷锟斤拷"
if duty=65 then dutyname="品锟截斤拷锟斤拷"
if duty=66 then dutyname="锟矫达拷锟斤拷锟斤拷"
if duty=67 then dutyname="锟矫硷拷/電硷拷"
if duty=68 then dutyname="車位锟斤拷"
if duty=69 then dutyname="锟斤拷/小锟紺"
if duty=70 then dutyname="毛锟铰匡拷锟紺锟斤拷"
if duty=71 then dutyname="锟紺锟睫癸拷"
if duty=72 then dutyname="锟絴锟絲锟剿員"
if duty=73 then dutyname="锟叫堬拷锟絀锟絅锟斤拷锟絆"
if duty=74 then dutyname="锟絘品锟斤拷锟絆"
if duty=75 then dutyname="锟絀锟絅锟斤拷锟絆"
if duty=76 then dutyname="锟叫堬拷锟斤拷展锟斤拷锟斤拷"
if duty=77 then dutyname="锟絕锟斤拷锟斤拷"
if duty=78 then dutyname="锟絅锟桔达拷锟斤拷"
if duty=79 then dutyname="品锟狡斤拷锟斤拷"
if duty=80 then dutyname="锟斤拷锟剿诧拷锟斤拷锟斤拷"
if duty=81 then dutyname="锟襟劃斤拷锟斤拷"
if duty=82 then dutyname="锟斤拷鋪策勶拷"
if duty=83 then dutyname="锟叫堬拷锟斤拷锟斤拷"
if duty=84 then dutyname="锟斤拷锟絬锟斤拷锟斤拷L"
if duty=85 then dutyname="锟斤拷訓锟絭锟斤拷"
if duty=86 then dutyname="锟叫堬拷锟斤拷锟絋"
if duty=87 then dutyname="锟統計锟絋"
if duty=88 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷锟絋"
if duty=89 then dutyname="锟斤拷息锟剿員"
if duty=90 then dutyname="锟絀锟秸斤拷锟斤拷"
if duty=91 then dutyname="锟絀锟秸員"
if duty=92 then dutyname="锟斤拷锟轿員"
if duty=93 then dutyname="锟斤拷锟絈锟絀锟秸員"
if duty=94 then dutyname="锟斤拷锟絈锟斤拷锟斤拷"
if duty=95 then dutyname="锟斤拷锟紺锟絋"
if duty=96 then dutyname="锟斤拷锟紺锟斤拷锟斤拷"
if duty=97 then dutyname="锟斤拷锟絞"
if duty=98 then dutyname="锟斤拷锟斤拷锟結源锟斤拷锟斤拷锟斤拷"
if duty=99 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷"
if duty=100 then dutyname="锟斤拷訓锟絭锟斤拷"
if duty=101 then dutyname="锟斤拷锟斤拷锟侥員"
if duty=102 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷"
if duty=103 then dutyname="锟酵凤拷锟斤拷锟斤拷"
if duty=104 then dutyname="锟酵凤拷锟斤拷锟斤拷"
if duty=105 then dutyname="锟斤拷锟絇锟剿員"
if duty=106 then dutyname="財锟秸匡拷锟絆"
if duty=107 then dutyname="財锟秸斤拷锟斤拷/锟斤拷锟斤拷"
if duty=108 then dutyname="锟斤拷計锟斤拷锟斤拷"
if duty=109 then dutyname="锟斤拷計"
if duty=110 then dutyname="锟斤拷锟絳"
if duty=111 then dutyname="锟統計"
if duty=112 then dutyname="锟斤拷锟斤拷锟斤拷锟截曪拷"
if duty=113 then dutyname="锟截曪拷"
if duty=114 then dutyname="锟侥員"
if duty=116 then dutyname="锟侥員锟斤拷試锟斤拷模锟斤拷"
if duty=117 then dutyname="前锟絖锟侥員"
if duty=118 then dutyname="锟斤拷锟絈锟絀锟秸斤拷锟斤拷"
if duty=119 then dutyname="锟斤拷購锟斤拷锟斤拷"
if duty=120 then dutyname="锟絵锟斤拷锟斤拷锟斤拷藛T"
if duty=121 then dutyname="锟斤拷锟斤拷锟斤拷锟絋"
if duty=122 then dutyname="锟斤拷锟斤拷锟剿員"
if duty=123 then dutyname="锟絥锟斤拷锟斤拷锟斤拷T"
if duty=124 then dutyname="锟斤拷锟斤拷"
if duty=125 then dutyname="計锟斤拷C锟絊锟給锟剿員"
if duty=115 then dutyname="锟絎站锟絆計/锟斤拷锟斤拷虅锟�"
if education=0 then eduname="锟斤拷锟斤拷"
if education=1 then eduname="锟斤拷锟斤拷"
if education=2 then eduname="锟斤拷校"
if education=3 then eduname="锟斤拷锟斤拷"
if education=4 then eduname="锟叫岋拷"
if education=5 then eduname="锟斤拷"
if education=6 then eduname="锟斤拷锟斤拷"
if education=7 then eduname="锟絧锟絎士"
if education=8 then eduname="锟絋士"
if education=9 then eduname="锟斤拷士"
if education=10 then eduname="锟斤拷锟斤拷"
if workplace=0 then proname="锟斤拷锟斤拷"
if workplace=1 then proname="锟斤拷锟斤拷"
if workplace=2 then proname="锟斤拷锟斤拷"
if workplace=3 then proname="锟斤拷锟斤拷"
if workplace=4 then proname="锟斤拷锟紺"
if workplace=5 then proname="锟絍锟絴"
if workplace=6 then proname="锟絍锟斤拷"
if workplace=7 then proname="锟紽锟斤拷"
if workplace=8 then proname="锟斤拷锟斤拷"
if workplace=9 then proname="锟接憋拷"
if workplace=10 then proname="锟斤拷锟斤拷"
if workplace=11 then proname="锟斤拷锟斤拷锟斤拷"
if workplace=12 then proname="锟斤拷锟斤拷"
if workplace=13 then proname="锟斤拷锟斤拷"
if workplace=14 then proname="锟斤拷锟斤拷"
if workplace=15 then proname="锟斤拷锟終"
if workplace=16 then proname="锟斤拷锟斤拷"
if workplace=17 then proname="锟絴锟斤拷"
if workplace=18 then proname="锟斤拷锟缴癸拷"
if workplace=19 then proname="锟斤拷锟斤拷"
if workplace=20 then proname="锟洁海"
if workplace=21 then proname="山锟絴"
if workplace=22 then proname="山锟斤拷"
if workplace=23 then proname="锟斤拷锟�"
if workplace=24 then proname="锟较猴拷"
if workplace=25 then proname="锟侥达拷"
if workplace=26 then proname="锟斤拷锟�"
if workplace=27 then proname="锟铰斤拷"
if workplace=28 then proname="锟斤拷锟斤拷"
if workplace=29 then proname="锟斤拷锟斤拷"
if workplace=30 then proname="锟姐江"
if workplace=31 then proname="锟截慶"
if ((i mod 2)=0) then
outStr = outStr & "| " & truename & " | " & sex & " | " & dutyname & " | " & worktime & " | " & eduname & " | " & proname & " | "& indate &" | "
else
outStr = outStr & "| " & truename & " | " & sex & " | " & dutyname & " | " & worktime & " | " & eduname & " | " & proname & " | "& indate &" | "
end if
rs.MoveNext
RowNum = RowNum - 1
i = i + 1
wend
else
outStr = "
锟斤拷歉锟斤拷目前锟絔锟叫滿锟斤拷l锟斤拷锟斤拷記錄★拷
請锟斤拷锟脚岋拷锟斤拷锟斤拷锟絣锟斤拷锟斤拷锟斤拷試試锟斤拷
| "
end if
Response.Write (outStr)
Response.Write ("| ")
ViewPageOn rs,PageNum,15,"hr.asp?SubjectId="&SubjectId&"&rctype="&rctype1&"&jobs="&duty1&"&workplace="&workplace1&"&education="&education1&"&expire="&expire1&"&sex="&sex1&"&truename="&truename1&"&worktime="&worktime1&"&hopesalary="&hopesalary1
Response.Write (" | ")
rs.Close()
conn.close()
% >
|
|
|
|
|
