28,390
社区成员
发帖
与我相关
我的任务
分享
<%
Response.Buffer = True
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "No-Cache"
%>
<!--#include virtual="/language_pack/language_pack.asp"-->
<!--#include virtual="/API/db_connection.asp"-->
<!--#include virtual="/includes/function_post_get_value.inc.asp"-->
<%
id = Q_Request("id")'根据收到ID的有无来判断是更新还是添加
WorkStartYear=Q_Request("WorkStartYear")
WorkStartMonth=Q_Request("WorkStartMonth")
WorkEndYear=Q_Request("WorkEndYear")
WorkEndMonth=Q_Request("WorkEndMonth")
WorkCompany = Q_Request("WorkCompany")
WorkCompanyNature= Q_Request("WorkCompanyNature")
WorkCompanySize= Q_Request("WorkCompanySize")
Industry_value= Q_Request("Industry_value")
Category_value= Q_Request("Category_value")
WorkDepartment= Q_Request("WorkDepartment")
WorkDescription= Q_Request("WorkDescription")
WorkJobAbroad= Q_Request("WorkJobAbroad")
items = Split(Industry_value, "#")
hangyeid = ""
job = ""
For i = 0 To UBound(items)
If items(i)<>"" Then
fields = Split(items(i), ":")
If UBound(fields)>=1 Then
if hangyeid="" then
hangyeid=fields(0)
else
hangyeid = hangyeid&","&fields(0)
end if
if job="" then
job=fields(1)
else
job = job&","&fields(1)
end if
End If
End If
Next
''''''''''获取职位ID 和 职位名称''''''''''''''''''''''''
items = Split(Category_value, "#")
zhiweiid = ""
jobb =""
For i = 0 To UBound(items)
If items(i)<>"" Then
fields = Split(items(i), ":")
If UBound(fields)>=1 Then
if zhiweiid="" then
zhiweiid=fields(0)
else
zhiweiid = zhiweiid&","&fields(0)
end if
if jobb="" then
jobb=fields(1)
else
jobb = jobb&","&fields(1)
end if
End If
End If
Next
if id="" then
'WorkCompany="增加"
Set Rs = Server.Createobject("ADODB.recordset")
'执行存储过程 查询个人标识号 和总表简历ID
sql = "exec pro_InsertPer_Resume_WorkExp '"&session("PersonResumeNum")&"','"&session("a")&"','"&WorkStartYear&"','"&WorkStartMonth&"','"&WorkEndYear&"','"&WorkEndMonth&"','"&WorkCompany&"','"&hangyeid&"','"&job&"','"&WorkCompanySize&"','"&WorkCompanyNature&"','"&WorkDepartment&"','"&zhiweiid&"','"&jobb&"','"&WorkDescription&"','"&WorkJobAbroad&"'"
Rs.open sql,Conn,1,3
set rs=nothing
WorkStartYear=Cstr(Q_Request("WorkStartYear"))