📄 per_deleteresume.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Public/Person_Cookies.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim Rs,Cmd,Tmp,Action
Dim Perid,UserName,UserType,RealName,JobContent
Action = Request.QueryString("action")
If Action = "del" Then Call Del_Submit() '跳转到保存函数
'//获取个人用户的登陆标记
If IsArray(Session("Person")) Then
Perid = Session("Person")(2)
UserName = Session("Person")(0)
Else
Session.Abandon()
Response.write "<script>alert('-登录后才能进行该操作!-');location.href='../Public/MemberLogin.asp';</script>"
End if
'//调用存储过程
Set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection = Conn
Cmd.CommandText = "Per_Account"
Cmd.CommandType = 4
Cmd.Parameters.Append Cmd.CreateParameter("@Perid",200,1,30)
Cmd.Parameters("@Perid") = Perid
Set Rs = Cmd.Execute
If Rs.Eof Then
CloseRs
Set Cmd = Nothing
CloseDB
Response.write "没有找到会员资料!"
Response.End()
End if
Tmp = Rs.GetRows() '//将数据填充到数组
'//0姓名,1会员类型
'//如:Tmp(0,0)表示 用户的姓名
Rs.Close
Set Cmd = Nothing
'//功能代码
UserType = Cls_Usertype(Tmp(1,0))
RealName = Tmp(0,0)
%>
<!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>
<script language="JavaScript" src="../js/Person_OutSendResume.js"></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>
<tr>
<td height="1" bgcolor="#eeeeee"></td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="175">
<!--#include file="../Public/Person_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">
<%= RealName %>[<%= UserType %>] </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<Form action="?action=del" method="post" name="theForm" onSubmit="return theForm_check()">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<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="2" cellspacing="1">
<tr bgcolor="f9f9f9">
<td height="25" align="left" bgcolor="f9f9f9">
我们建议您不要删除您的简历 ;简历删除后 ;将不会得到恢复 ;<br>
如果您已经找到工作 ;暂时不想让企业查询到您的简历
;您可以通过保密设置将简历设置成"<a href="SetMyResume.asp">不公开您的简历</a>"状态
;需要时 ;再公开您的简历 ; </td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="40" align="left">
<input type="submit" name="Submit" value=" 删除简历 " style="height:30px;">
</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 Del_Submit()
'//接收参数
Perid = Session("Person")(2)
'删除个人照片文件
SQL = "Select PhotoUrl,Video_File,Video_PhotoUrl From [pH_Person_Info] Where Perid='"&Trim(Perid)&"'"
Set Rs = Conn.Execute(SQL)
If Not Rs.Eof Then
PhotoUrl = Rs(0) '个人会员的图片
Video_File = Rs(1) '个人会员的视频简历压缩文件
Video_PhotoUrl = Rs(2) '视频简历的小图片
Set Fso = Server.CreateObject("Scripting.FileSystemObject")
'图片文件
If Fso.FileExists(Server.Mappath("../UpLoadFiles/PersonFile/"&PhotoUrl)) Then
Fso.DeleteFile(Server.Mappath("../UpLoadFiles/PersonFile/"&PhotoUrl))
End if
'视频简历压缩文件
If Fso.FileExists(Server.Mappath("../UpLoadFiles/VideoFile/"&Video_File)) Then
Fso.DeleteFile(Server.Mappath("../UpLoadFiles/VideoFile/"&Video_File))
End if
'视频简历的小图片
If Fso.FileExists(Server.Mappath("../UpLoadFiles/PersonVideoPhoto/"&Video_PhotoUrl)) Then
Fso.DeleteFile(Server.Mappath("../UpLoadFiles/PersonVideoPhoto/"&Video_PhotoUrl))
End if
Set Fso = Nothing
End if
Rs.Close
'删除个人帐号信息
SQL = "Delete From [pH_Person_Base] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除个人基本信息
SQL = "Delete From [pH_Person_Info] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除教育经历
SQL = "Delete From [pH_Person_Education] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除收藏夹
SQL = "Delete From [pH_Person_Favouriate] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除收件夹
SQL = "Delete From [pH_Person_InBox] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除发件夹
SQL = "Delete From [pH_Person_OutBox] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除回收站
SQL = "Delete From [pH_Person_RecycleBox] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除搜索器
SQL = "Delete From [pH_Person_Searcher] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除工作经历
SQL = "Delete From [pH_Person_Work] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除企业收件夹
SQL = "Delete From [pH_Company_InBox] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除企业发件夹
SQL = "Delete From [pH_Company_OutBox] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除企业英才库
SQL = "Delete From [pH_Company_PersonDB] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
'删除企业回收站
SQL = "Delete From [pH_Company_RecycleBox] Where Perid='"&Trim(Perid)&"'"
Conn.Execute(SQL)
Session.Abandon()
Response.write "<script>alert('简历删除成功!');location.href='../Index.asp';</script>"
End Sub
'//关闭数据库连接
CloseDB
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -