|
|
|
|
|
|
|
|
|
< %
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="導購店員"
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="計算機人員"
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="企業管理"
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="陳列設計師"
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="服飾品設計師"
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="紙樣排版員"
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="專賣店店長"
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="倉庫管理人員"
if duty=121 then dutyname="物流專員"
if duty=122 then dutyname="后勤人員"
if duty=123 then dutyname="檔案管理員"
if duty=124 then dutyname="保安"
if duty=125 then dutyname="計算機維護人員"
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 = "
抱歉，目前沒有滿足條件的記錄。
請您放寬搜索條件，再試試！
| "
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()
% >
|
|
|
|
|
