|
|
|
|
|
|
|
|
|
< %
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="锟斤拷锟絙锟絆(sh锟斤拷)計(j锟斤拷)"
if duty=2 then dutyname="锟斤拷锟絙锟斤拷锟絞(sh锟斤拷)"
if duty=3 then dutyname="锟斤拷锟絙锟斤拷锟絘(ch锟斤拷n)"
if duty=4 then dutyname="CAD/CAM"
if duty=5 then dutyname="锟斤拷锟絈(m锟斤拷o)锟�"
if duty=6 then dutyname="锟斤拷锟节凤拷锟斤拷(w锟斤拷)"
if duty=7 then dutyname="锟叫堬拷锟絀锟絅"
if duty=8 then dutyname="锟斤拷(d锟斤拷o)購锟斤拷T"
if duty=9 then dutyname="锟斤拷(j锟斤拷ng)锟絀锟斤拷锟斤拷"
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="財(c锟斤拷i)锟斤拷(w锟斤拷)锟斤拷(hu锟斤拷)計(j锟斤拷)"
if duty=16 then dutyname="計(j锟斤拷)锟斤拷C(j锟斤拷)锟剿員"
if duty=17 then dutyname="锟斤拷锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)"
if duty=22 then dutyname="锟斤拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=23 then dutyname="锟斤拷锟斤拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=24 then dutyname="锟絀锟絓(y锟斤拷n)锟斤拷(j锟斤拷ng)锟斤拷"
if duty=25 then dutyname="锟襟劃斤拷(j锟斤拷ng)锟斤拷"
if duty=26 then dutyname="锟�(xi锟斤拷ng)目锟斤拷(j锟斤拷ng)锟斤拷"
if duty=27 then dutyname="锟斤拷I(y锟斤拷)锟斤拷锟斤拷"
if duty=28 then dutyname="锟斤拷(j锟斤拷ng)锟斤拷锟斤拷锟斤拷"
if duty=29 then dutyname="锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷锟絆(ji锟斤拷n)"
if duty=30 then dutyname="锟斤拷席锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=31 then dutyname="锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷锟斤拷"
if duty=32 then dutyname="女锟絙锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=33 then dutyname="锟斤拷锟絙锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=34 then dutyname="童锟絙锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=35 then dutyname="锟斤拷(n锟斤拷i)锟斤拷/锟斤拷锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=36 then dutyname="泳锟絙锟絆(sh锟斤拷)計(j锟斤拷)"
if duty=37 then dutyname="锟斤拷锟絜锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=38 then dutyname="锟揭居凤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=39 then dutyname="牛锟叫凤拷锟絆(sh锟斤拷)計(j锟斤拷)"
if duty=40 then dutyname="毛锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=41 then dutyname="皮锟斤拷/锟斤拷皮锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=42 then dutyname="锟結锟斤拷/锟介紗锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=43 then dutyname="锟絓(y锟斤拷n)锟斤拷(d锟斤拷ng)锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)"
if duty=44 then dutyname="锟斤拷锟斤拷O(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=45 then dutyname="锟斤拷锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=46 then dutyname="平锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=47 then dutyname="锟絎(w锟斤拷ng)站锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=48 then dutyname="锟紻锟斤拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=49 then dutyname="锟斤拷锟狡凤拷O(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=50 then dutyname="锟街达拷锟絆(sh锟斤拷)計(j锟斤拷)锟斤拷"
if duty=51 then dutyname="锟斤拷锟絞(sh锟斤拷)锟斤拷锟絆(ji锟斤拷n)"
if duty=52 then dutyname="锟斤拷锟絞(sh锟斤拷)锟斤拷锟斤拷锟斤拷"
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="锟斤拷锟絞(sh锟斤拷)锟絚锟�(y锟斤拷n)貨锟斤拷锟斤拷"
if duty=58 then dutyname="锟狡檔/锟脚碼锟斤拷锟斤拷"
if duty=59 then dutyname="锟斤拷锟斤拷锟脚帮拷T"
if duty=60 then dutyname="锟斤拷锟絘(ch锟斤拷n)锟絊锟絃"
if duty=61 then dutyname="锟斤拷锟絘(ch锟斤拷n)锟斤拷锟絆(ji锟斤拷n)"
if duty=62 then dutyname="锟斤拷锟絘(ch锟斤拷n)锟斤拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=63 then dutyname="車锟絞锟斤拷锟斤拷"
if duty=64 then dutyname="锟斤拷锟絙锟斤拷锟斤拷锟斤拷"
if duty=65 then dutyname="品锟截斤拷(j锟斤拷ng)锟斤拷"
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="毛锟铰匡拷锟紺(j锟斤拷)锟斤拷"
if duty=71 then dutyname="锟紺(j锟斤拷)锟睫癸拷"
if duty=72 then dutyname="锟絴(zh锟斤拷)锟絲锟剿員"
if duty=73 then dutyname="锟叫堬拷锟絀锟絅锟斤拷锟絆(ji锟斤拷n)"
if duty=74 then dutyname="锟絘(ch锟斤拷n)品锟斤拷锟絆(ji锟斤拷n)"
if duty=75 then dutyname="锟絀锟絅锟斤拷锟絆(ji锟斤拷n)"
if duty=76 then dutyname="锟叫堬拷锟斤拷展锟斤拷(j锟斤拷ng)锟斤拷"
if duty=77 then dutyname="锟絕(q锟斤拷)锟斤拷(j锟斤拷ng)锟斤拷"
if duty=78 then dutyname="锟絅锟桔达拷锟斤拷"
if duty=79 then dutyname="品锟狡斤拷(j锟斤拷ng)锟斤拷"
if duty=80 then dutyname="锟斤拷锟剿诧拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=81 then dutyname="锟襟劃斤拷(j锟斤拷ng)锟斤拷"
if duty=82 then dutyname="锟斤拷鋪策勶拷"
if duty=83 then dutyname="锟叫堬拷锟斤拷锟斤拷(d锟斤拷o)"
if duty=84 then dutyname="锟斤拷锟絬锟斤拷锟斤拷L"
if duty=85 then dutyname="锟斤拷訓(x锟斤拷n)锟絭锟斤拷"
if duty=86 then dutyname="锟叫堬拷锟斤拷锟絋"
if duty=87 then dutyname="锟統(t锟斤拷ng)計(j锟斤拷)锟絋"
if duty=88 then dutyname="锟斤拷(sh锟斤拷)锟斤拷(j锟斤拷)锟斤拷锟斤拷锟絋"
if duty=89 then dutyname="锟斤拷息锟剿員"
if duty=90 then dutyname="锟絀(y锟斤拷)锟斤拷(w锟斤拷)锟斤拷(j锟斤拷ng)锟斤拷"
if duty=91 then dutyname="锟絀(y锟斤拷)锟斤拷(w锟斤拷)锟絋"
if duty=92 then dutyname="锟斤拷锟轿員"
if duty=93 then dutyname="锟斤拷锟絈(m锟斤拷o)锟絀(y锟斤拷)锟斤拷(w锟斤拷)锟絋"
if duty=94 then dutyname="锟斤拷锟絈(m锟斤拷o)锟斤拷锟斤拷"
if duty=95 then dutyname="锟斤拷锟紺锟絋"
if duty=96 then dutyname="锟斤拷锟紺锟斤拷锟斤拷(w锟斤拷)"
if duty=97 then dutyname="锟斤拷锟絞"
if duty=98 then dutyname="锟斤拷锟斤拷锟結源锟斤拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=99 then dutyname="锟斤拷锟斤拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=100 then dutyname="锟斤拷訓(x锟斤拷n)锟絭锟斤拷"
if duty=101 then dutyname="锟斤拷锟斤拷锟侥員"
if duty=102 then dutyname="锟斤拷锟斤拷锟斤拷锟斤拷"
if duty=103 then dutyname="锟酵凤拷锟斤拷(j锟斤拷ng)锟斤拷"
if duty=104 then dutyname="锟酵凤拷锟斤拷锟斤拷"
if duty=105 then dutyname="锟斤拷锟絇(gu锟斤拷n)锟剿員"
if duty=106 then dutyname="財(c锟斤拷i)锟斤拷(w锟斤拷)锟斤拷锟絆(ji锟斤拷n)"
if duty=107 then dutyname="財(c锟斤拷i)锟斤拷(w锟斤拷)锟斤拷(j锟斤拷ng)锟斤拷/锟斤拷锟斤拷"
if duty=108 then dutyname="锟斤拷計(j锟斤拷)锟斤拷(j锟斤拷ng)锟斤拷"
if duty=109 then dutyname="锟斤拷(hu锟斤拷)計(j锟斤拷)"
if duty=110 then dutyname="锟斤拷锟絳"
if duty=111 then dutyname="锟統(t锟斤拷ng)計(j锟斤拷)"
if duty=112 then dutyname="锟斤拷锟斤拷(j锟斤拷ng)锟斤拷锟截曪拷"
if duty=113 then dutyname="锟截曪拷"
if duty=114 then dutyname="锟侥員"
if duty=116 then dutyname="锟侥員锟斤拷試锟斤拷模锟斤拷"
if duty=117 then dutyname="前锟絖(t锟斤拷i)锟侥員"
if duty=118 then dutyname="锟斤拷锟絈(m锟斤拷o)锟絀(y锟斤拷)锟斤拷(w锟斤拷)锟斤拷(j锟斤拷ng)锟斤拷"
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="計(j锟斤拷)锟斤拷C(j锟斤拷)锟絊锟給(h锟斤拷)锟剿員"
if duty=115 then dutyname="锟絎(w锟斤拷ng)站锟絆(sh锟斤拷)計(j锟斤拷)/锟斤拷锟斤拷虅锟�(w锟斤拷)"
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="锟絧锟絎(xu锟斤拷)士"
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="锟斤拷(n锟斤拷i)锟缴癸拷"
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锟斤拷锟斤拷記錄★拷
請(q锟斤拷ng)锟斤拷锟脚岋拷锟斤拷锟斤拷锟絣锟斤拷锟斤拷锟斤拷試試锟斤拷
| "
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()
% >
|
|
|
|
|
