📄 com_master_preview.asp
字号:
<!--#include file="../../Include/Class_Conn.asp" -->
<!--#include file="../../Include/Class_Main.asp" -->
<%
Dim Comid,Username,Cmd,Rs,SQL
Dim SetDate,Properity,Industry,Currency_Str,Workers,Locus,LogoUrl,LogoKeep,Company_Memo
Dim ContactPerson,Phone,CompanyFax,Email,WebHome,Address,ZipCode
'//判断用户是否是管理员
If Session("Web_Suppername") = "" Then
Response.write "<script>alert('-当前用户没有权限进行该操作！-');window.close();</script>"
Response.End()
End if
'//获取会员登陆的标记
'Username = Session("Company")(0)
Comid = Replace_Text(Request.QueryString("param"))
'//调用存储过程
Set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection = Conn
Cmd.CommandText = "Com_Preview"
Cmd.CommandType = 4
Cmd.Parameters.Append Cmd.CreateParameter("@Comid",200,1,30)
Cmd.Parameters("@Comid") = Comid
Set Rs = Cmd.Execute
If Rs.Eof Then
CloseRs
Set Cmd = Nothing
CloseDB
Response.write "没有找到会员资料！"
Response.End()
End if
Tmp = Rs.GetRows() '//将数据填充到数组
'//0企业名称,1营业执照,2行业,3企业性质,4成立年份,5月,6日,7员工人数,8注册资金,9资金类型,10企业简介,11联系人,12电话,13电话保密,14传真,15邮件,16邮件保密,17企业所在省,18城市,19地址,20邮政编码,21企业网址,22LOGO,23图片屏蔽,24最后更新时间,25VIP标记,26VIP开始时间,27截止时间,28显示次数,29有无视频,30开通时间,31截止时间,32视频状态,33视频文件
'//如 Tmp(0,0) 表示企业名称
'//关闭数据库对象
Rs.Close
Set Cmd = Nothing
SetDate = Tmp(4,0)&"年"&Tmp(5,0)&"月"&Tmp(6,0)&"日"
Properity = Cls_Properity(Tmp(3,0)) '//获得企业性质
Industry = Cls_Industry(Tmp(2,0)) '//获得行业
Currency_Str = Tmp(8,0)&"万/元 "&Cls_Currency(Tmp(9,0)) '//注册资金和类型
Workers = Cls_Workers(Tmp(7,0)) '//获得员工数
Locus = Tmp(17,0)&Tmp(18,0)
LogoUrl = Tmp(22,0)
LogoKeep = Tmp(23,0)
Company_Memo = Tmp(10,0)
ContactPerson = Tmp(11,0)
Phone = Tmp(12,0)
CompanyFax = Tmp(14,0)
Email = Tmp(15,0)
WebHome = Tmp(21,0)
Address = Tmp(19,0)
ZipCode = Tmp(20,0)
Nc_Video = Tmp(29,0)
Video_Date = Tmp(30,0)
Video_EndDate = Tmp(31,0)
Video_Flag = Tmp(32,0)
Video_File = Tmp(33,0)
If WebHome = "http://" Then WebHome = ""
%>
<!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><%= Tmp(0,0) %>-企业资料预览-<%= Cls_WebName %></title>
</head>
<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<!--#include file="../../Include/Info/Header.asp" -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<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 width="592" 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"><%= Tmp(0,0) %></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/company_left.gif" width="22" height="22"></td>
<td width="78" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_wbg.gif"><strong>企业简介</strong></td>
<td width="28" rowspan="2"><img src="../../Images/Company/company_middle.gif" width="28" height="22"></td>
<td width="80" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_ybg.gif"><a href="Com_Master_PreviewJob.asp?comid=<%= Comid %>">职位</a></td>
<td width="24" rowspan="2"><img src="../../Images/Company/company_right.gif" width="24" height="22"></td>
<td width="214"> </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_Master_JobView.asp?Param="&Jobid&"&Comid="&Comid&""">"&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="6"></td>
</tr>
</table>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr bgcolor="f5f5f5">
<td width="70" height="25"><img src="../../Images/icon3.gif" width="12" height="16">
企业信息</td>
<td> </td>
<td width="150"> <img src="../../Images/icon3.gif" width="12" height="16">
企业图标</td>
</tr>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="70" height="25" align="right">企业名称：</td>
<td height="25"><%= Tmp(0,0) %></td>
</tr>
<tr>
<td width="70" height="25" align="right" bgcolor="f9f9f9">成立日期：</td>
<td height="25" bgcolor="f9f9f9"><%= SetDate %></td>
</tr>
<tr>
<td width="70" height="25" align="right">企业性质：</td>
<td height="25"><%= Properity %></td>
</tr>
<tr>
<td width="70" height="25" align="right" bgcolor="f9f9f9">所属行业：</td>
<td height="25" bgcolor="f9f9f9"><%= Industry %></td>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -