📄 com_video.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<!--#include file="../Public/Company_Cookies.asp" -->
<%
Dim Comid,Username,Tmp
Dim Cmd,Rs,Action,LogoUrl,LogoKeep
Action = Request.QueryString("action")
If Action = "submit" Then Call Submit() '//跳转到保存数据的函数
'//获取会员登陆的标记
Username = Session("Company")(0)
Comid = Session("Company")(2)
'//调用存储过程
Set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection = Conn
Cmd.CommandText = "Com_Video"
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视频文件
'//如 Tmp(0,0) 表示企业名称
'//关闭数据库连接
CloseRs
Set Cmd = Nothing
CloseDB
'//功能代码
Nc_Video = Tmp(1,0)
Video_Flag = Tmp(2,0)
Video_Date = Tmp(3,0)
Video_EndDate = Tmp(4,0)
Video_File = Tmp(5,0)
'视频简历的属性
Video_FlagStr = ""
Select Case Video_Flag
Case 0:Video_FlagStr = "公开中"
Case 1:Video_FlagStr = "<font color=#666666>对会员公开</font>"
Case 2:Video_FlagStr = "<font color=#ff0000>屏蔽中</font>"
End Select
%>
<!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><%= Cls_WebName %> -- 企业会员管理中心 -- 企业视频</title>
</head>
<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>
<tr>
<td height="1" bgcolor="#eeeeee"></td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="175" valign="top">
<!--#include file="../Public/Company_Left.asp" -->
</td>
<td width="5"> </td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><img src="../Images/icon.gif" width="11" height="11" align="absmiddle">
<%= Tmp(0,0) %> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<form action="?action=submit" name="theForm" method="post">
<tr>
<td bgcolor="#FFFFFF"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f5f5f5"><b><font color="#000000"> 企业视频</font></b></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25" align="left">
<%
If Nc_Video = False Then
%>
<table width="99%" border="0" cellpadding="0" cellspacing="0" class="text01">
<tr>
<td align="left">暂时没有视频信息，如果您想拍摄企业视频请<a href="Com_AccountVip.asp" target="_blank"><font color="#FF0000">点击这里升级会员</font></a>或者和客服人员联系
</td>
</tr>
</table>
<% Elseif Nc_Video = True And DateDiff("d",Video_Date,Date()) >= 0 And DateDiff("d",Video_EndDate,Date()) <= 0 Then %>
<TABLE borderColor=#e8e8e8 width=300
align=center border=10>
<TBODY>
<TR>
<TD bgColor=#999999> <OBJECT height=280 width=320 align=middle
classid=CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6
VIEWASTEXT>
<PARAM NAME="URL" VALUE="../Uploadfiles/CompanyVideo/<%= Video_File %>">
<PARAM NAME="rate" VALUE="1">
<PARAM NAME="balance" VALUE="0">
<PARAM NAME="currentPosition" VALUE="0">
<PARAM NAME="defaultFrame" VALUE="1">
<PARAM NAME="playCount" VALUE="1">
<PARAM NAME="autoStart" VALUE="1">
<PARAM NAME="currentMarker" VALUE="0">
<PARAM NAME="invokeURLs" VALUE="-1">
<PARAM NAME="baseURL" VALUE="">
<PARAM NAME="volume" VALUE="50">
<PARAM NAME="mute" VALUE="0">
<PARAM NAME="uiMode" VALUE="full">
<PARAM NAME="stretchToFit" VALUE="0">
<PARAM NAME="windowlessVideo" VALUE="0">
<PARAM NAME="enabled" VALUE="-1">
<PARAM NAME="enableContextMenu" VALUE="-1">
<PARAM NAME="fullScreen" VALUE="0">
<PARAM NAME="SAMIStyle" VALUE="">
<PARAM NAME="SAMILang" VALUE="">
<PARAM NAME="SAMIFilename" VALUE="">
<PARAM NAME="captioningID" VALUE="">
</OBJECT></TD>
</TR>
</TBODY>
</TABLE>
<% Else %>
<table width="99%" border="0" cellpadding="0" cellspacing="0" class="text01">
<tr>
<td> 对不起！您的企业视频已经到期，请您联系客服人员以便重新开通 </td>
</tr>
</table>
<% End if %>
</td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f5f5f5"><b><font color="#000000"> 视频路径</font></b></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="18%" height="25" align="right">访问路径：</td>
<td align="left">
<% If Nc_Video = True Then %>
<input name="textfield" type="text" size="40" value="<%= Cls_WebUrl&"Company/Com_VideoView.asp?Comid="&Comid %>">
<% Else %>
<input name="textfield2" type="text" size="40" >
<% End if %>
</td>
</tr>
<tr>
<td height="25" align="right">使用说明：</td>
<td align="left">您可以把以上您企业视频的URL地址发送到个人会员的邮箱 ;<br>
个人会员即可直接观看您的视频简历，不占用企业邮箱任何多余空间 ; </td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f5f5f5"><b><font color="#000000"> 视频设置</font></b></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<% If Nc_Video = True Then %>
<tr>
<td width="18%" height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT
color=#ff6600>*</FONT></STRONG> 视频属性：</td>
<td width="82%" height="25" bgcolor="f9f9f9">当前属性为<u><%= Video_FlagStr %></u>;</td>
</tr>
<tr>
<td height="25" align="right"> </td>
<td height="25"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"> <input type="radio" name="flag" value="0" <% If Video_Flag = 0 Then Response.write "Checked" %>>
完全公开 ;</td>
</tr>
<tr>
<td height="25"> <input type="radio" name="flag" value="1" <% If Video_Flag = 1 Then Response.write "Checked" %>>
只对企业会员公开 ;</td>
</tr>
<tr>
<td height="25"> <input type="radio" name="flag" value="2" <% If Video_Flag = 2 Then Response.write "Checked" %>>
完全屏蔽 ;</td>
</tr>
<tr>
<td height="25"><input type="submit" name="Submit" value=" 保 存 设 置 " ></td>
</tr>
</table></td>
</tr>
<% Else %>
<tr align="left">
<td height="25" colspan="2"> 暂时没有视频信息，如果您想拍摄企业视频请<a href="Com_AccountVip.asp" target="_blank"><font color="#FF0000">点击这里升级会员</font></a>或者和客服人员联系
; </td>
</tr>
<% End if %>
</table></td>
</tr>
</form>
</table></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" bgcolor="#eeeeee"></td>
</tr>
</table>
<!--#include file="../Include/Footer.asp" -->
</td>
</tr>
</table>
</body>
</html>
<%
Sub Submit()
Call Check_url() '防止外部站点提交数据
'//提交数据
Comid = Session("Company")(2)
Flag = Replace_Text(Request.Form("flag"))
SQL = "Update [pH_Company_Base] Set Video_Flag="&Flag&" Where Comid='"&Comid&"'"
Conn.Execute(SQL)
'//更改最后修改时间
SQL = "Update [pH_Company_Base] Set LastUpdate_Time='"&Now()&"' Where Comid='"&Comid&"'"
Conn.Execute(SQL)
CloseDB
Response.redirect "Com_Video.asp"
End Sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -