📄 com_job.asp
字号:
<!--#include file="../../Include/Class_Conn.asp" -->
<!--#include file="../../Include/Class_Main.asp" -->
<%
Dim Param
Dim Comid,Username,Cmd,Rs,SQL,i,JobId,JobName
Dim CompanyName,DeptName,Deal,Numbers,BeginDate,EndDate,Edus,Flag,Works,Min_Age,Max_Age,Age_Str,Sex,Locus
Param_Str = Split(Request.QueryString,".")
Str = Split(Param_Str(0),"-")
'//获取会员登陆的标记
Comid = Replace_Text(Str(1))
'//获取提交的参数
JobId = Replace_Text(Str(3))
'//查找企业信息
SQL = "Select CompanyName,Nc_Vip_Flag,Nc_Vip_Date,Nc_Vip_EndDate From [pH_Company_Base] Where Comid='"&Comid&"'"
Set Rs = Conn.Execute(SQL)
If Rs.Eof Then
CloseRs
CloseDB
Response.write "没有找到会员资料！"
Response.End()
End if
CompanyName = Rs(0)
Vip_Flag = Rs(1)
Vip_Date = Rs(2)
Vip_EndDate = Rs(3)
Rs.Close
'//调用存储过程
Set Cmd = Server.Createobject("ADODB.Command")
Cmd.ActiveConnection = Conn
Cmd.CommandText = "Com_JobView"
Cmd.CommandType = 4
Cmd.Parameters.Append Cmd.CreateParameter("@Comid",200,1,30)
Cmd.Parameters("@Comid") = Comid
Cmd.Parameters.Append Cmd.CreateParameter("@Jobid",3,1,4)
Cmd.Parameters("@Jobid") = Jobid
Set Rs = Cmd.Execute
If Not Rs.Eof Then
Flag = 1
i = 0
Tmp = Rs.GetRows() '//将数据填充到数组
End if
'0职位ID,1职位类型,2职位类别,3名称,4待遇,5人数,6工作省,7市,8具体要求,9面试地址,10学历,11性别,12工作年限,13更新时间,14显示次数,15应聘次数,16状态,17要求省,18市,19最小年龄,20最大年龄,21部门ID,22截止日期,23联系人,24电话,25传真,26电话屏蔽,27邮件,28邮件屏蔽,29地址,30邮政编码
Set Cmd = Nothing
If Flag = 1 Then
Ncid = Tmp(0,i)
JobName = Tmp(3,i)
'更新职位的浏览次数
Conn.Execute("Update [pH_Job_Base] Set ViewClicks=ViewClicks+1 Where Jobid="&Cstr(Ncid))
Else
JobName = "没有相关职位"
End if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../../Css/Style.css" type=text/css rel=stylesheet>
<title><%= CompanyName %>-企业职位-<%= Cls_WebName %></title>
</head>
<SCRIPT language=JavaScript>
function showalert(id)
{
if (id=="fav")
{
<% If IsArray(Session("Person")) Then %>
theForm.target='rslt';
theForm.action="../../Person/Per_Option.asp?param=fav";
openwin();
theForm.submit();
<% Else %>
alert("登录后才能进行该操作！");
<% End if %>
}
if (id=="video")
{
<% If IsArray(Session("Person")) Then %>
theForm.target='rslt';
theForm.action="../../Person/Per_Option.asp?param=video";
openwin();
theForm.submit();
<% Else %>
alert("登录后才能进行该操作！");
<% End if %>
}
if (id=="send")
{
<% If IsArray(Session("Person")) Then %>
theForm.target='rslt';
theForm.action="../../Person/Per_SendApplication.asp";
openwin();
theForm.submit();
<% Else %>
alert("登录后才能进行该操作！");
<% End if %>
}
if (id=="best")
{
theForm.target='rslt';
theForm.action="../../Person/Per_Friend.asp";
openwin();
theForm.submit();
}
}
function openwin()
{
disp=window.open("","rslt","width=500,height=320,resizable=yes");
disp.focus();
}
</script>
<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<!--#include file="../../Include/Header.asp" -->
</td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="164" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../../Images/Company/toplogo.gif" width="164" height="34"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
SQL = "Select Top 10 * From [pH_Web_Ad] Where WebName=10 And ad_Width=148 And ad_Height=60 And DateDiff(d,BeginDate,GetDate())>=0 And DateDiff(d,EndDate,GetDate())<=0 And Websub='"&Cls_Websub&"' Order By ad_Sort Asc"
Set Rs_s = Conn.Execute(SQL)
While Not Rs_s.Eof
If Rs_s("AdClass") = 1 Then
%>
<tr>
<td height="68" align="center"> <a href="<%= "http://"&Rs_s("AdUrl") %>" target="_blank"><img src="../../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>" width="<%= Rs_s("ad_Width") %>" height="<%= Rs_s("ad_Height") %>" border="0"></a>
</td>
</tr>
<% Else %>
<tr>
<td height="68" align="center"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="<%= Rs_s("ad_Width") %>" height="<%= Rs_s("ad_Height") %>">
<param name="movie" value="../../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>">
<param name=quality value=high>
<embed src="../../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="435" height="75"></embed>
</object> </td>
</tr>
<%
End if
Rs_s.Movenext
Wend
Rs_s.Close
%>
</table></td>
<td width="1" bgcolor="#eeeeee"></td>
<td width="3"></td>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="28%" align="left"><img src="../../Images/Company/welcome.gif" width="149" height="43"></td>
<td style="font-size:15px;color:#3333CC;font-weight:bold"><%= CompanyName %></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="147" height="21"> </td>
<td width="21" rowspan="2"><img src="../../Images/Company/yleft.gif" width="21" height="22"></td>
<td width="78" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_ybg.gif"><a href="Com_View.asp?Param-<%= Comid %>.html">企业简介</a></td>
<td width="28" rowspan="2"><img src="../../Images/Company/company_middle2.gif" width="32" height="22"></td>
<td width="80" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_ybg.gif"><a href="Com_ViewJob.asp?Param-<%= Comid %>.html">职位</a></td>
<td width="28" rowspan="2"><img src="../../Images/Company/middle.gif" width="28" height="22"></td>
<td width="130" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_wbg.gif"><b><%= Left(JobName,10) %></b></td>
<td width="24" rowspan="2"><img src="../../Images/Company/person_wright.gif" width="24" height="22"></td>
<td height="21"> </td>
</tr>
<tr>
<td height=1 bgcolor=#ddddda></td>
<td height=1 bgcolor=#ddddda></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1" bgcolor="#ddddda"></td>
<td width="145" align="center" valign="top" bgcolor="#FBFBFB">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
<tr>
<td>正在...</td>
</tr>
<%
SQL = "Select Jobid,JobName From [pH_Job_Base] Where Comid='"&Comid&"' And JobFlag = 1 And End_Date>=getdate() Order By LastUpdate_Time Desc,JobId Desc"
Set Rs = Conn.Execute(SQL)
If Not Rs.Eof Then
While Not Rs.Eof
Jobid = Rs(0)
JobName = Rs(1)
Response.write "<tr><td height=25><li><a href=""Com_Job.asp?Comid-"&Comid&"-Param-"&Jobid&".html"">"&JobName&"</a></td></tr>"
Rs.Movenext
Wend
End if
Rs.Close
%>
<tr>
<td height="10"></td>
</tr>
</table></td>
<td align="center" valign="top"> <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<Form action="" method="post" name="theForm">
<%
If Flag = 1 Then
Set Re = Conn.Execute("Select DeptName From [pH_Company_Dept] Where Ncid="&Cstr(Tmp(21,i))) '//查找部门表
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -