<%
Set Conn=Server.CreateObject("ADODB.Connection")
Str_Conn="Driver={SQL Server};database=365guke;server=192.168.1.11;uid=365guke_manager_001;pwd=361dulxy2008"
conn.open Str_Conn
Set Rs=Server.CreateObject("ADODB.RecordSet")
real_fsoname="Scripting.FileSystemObject_365guke"
sub closedb()
conn.close
set conn=nothing
end sub
sub closers()
rs.close
set rs=nothing
end sub
%>
<%
call xuanze()
flag1=1
flag=Trim(request.form("flag"))
call Safe_Request(flag,2,"")
sub xuanze()
xuexiban=trim(request.Form("xuexiban"))
call Safe_Request(xuexiban,2,"")
if xuexiban="进修" then
'response.Write "jinxiu"
elseif xuexiban="参观" then
'response.Write "canguan"
end if
end sub
if flag="savedata" then call savedata()
%>
<%
sub savedata()
Set rs=Server.CreateObject("ADODB.RecordSet")
shoujihaoma=trim(request("shoujihaoma"))
call Safe_Request(shoujihaoma,1,"")
email=trim(request("e-mail"))
call Safe_Request(email,2,"")
danweidizhi=trim(request("danweidizhi"))
call Safe_Request(danweidizhi,2,"")
xuexiban=trim(request("xuexiban"))
call Safe_Request(xuexiban,2,"")
zhuanye=trim(request("zhuanye"))
call Safe_Request(zhuanye,2,"")
kaishidate=Trim(request("kaishidate"))
call Safe_Request(kaishidate,2,"")
jieshudate=trim(request("jieshudate"))
call Safe_Request(jieshudate,2,"")
jinxiushengname=trim(request("jinxiushengname"))
call Safe_Request(jinxiushengname,2,"")
yuandanwei=trim(request("yuandanwei"))
call Safe_Request(yuandanwei,2,"")
youbian=trim(request("youbian"))
call Safe_Request(youbian,2,"")
tianbiaodate=trim(request("tianbiaodate"))
call Safe_Request(tianbiaodate,2,"")
name1=trim(request("name1"))
call Safe_Request(name1,2,"")
sex=trim(request("sex"))
call Safe_Request(sex,1,"")
age=trim(request("age"))
call Safe_Request(age,1,"")
jiguan=trim(request("jiguan"))
call Safe_Request(jiguan,2,"")
minzu=trim(request("minzu"))
call Safe_Request(minzu,2,"")
zhengzhimianmao=trim(request("zhengzhimianmao"))
call Safe_Request(zhengzhimianmao,2,"")
wenhua=trim(request("wenhua"))
call Safe_Request(wenhua,2,"")
jiatingtongxun=trim(request("jiatingtongxun"))
call Safe_Request(jiatingtongxun,2,"")
cengzhuanye=trim(request("cengzhuanye"))
call Safe_Request(cengzhuanye,2,"")
xiancongzhuanye=trim(request("xiancongzhuanye"))
call Safe_Request(xiancongzhuanye,2,"")
yewuzhicheng=trim(request("yewuzhicheng"))
call Safe_Request(yewuzhicheng,2,"")
jiankangqingkuang=trim(request("jiankangqingkuang"))
call Safe_Request(jiankangqingkuang,2,"")
danweidianhua=trim(request("danweidianhua"))
call Safe_Request(danweidianhua,2,"")
jiatingdianhua=trim(request("jiatingdianhua"))
call Safe_Request(jiatingdianhua,2,"")
jianlidate=trim(request("jianlidate"))
call Safe_Request(jianlidate,2,"")
daodate=trim(request("daodate"))
call Safe_Request(daodate,2,"")
renhezhiwu=trim(request("renhezhiwu"))
call Safe_Request(renhezhiwu,2,"")
guanxi=trim(request("guanxi"))
call Safe_Request(guanxi,2,"")
jianame=trim(request("jianame"))
call Safe_Request(jianame,2,"")
jiaage=trim(request("jiaage"))
call Safe_Request(jiaage,2,"")
jiazhengzhimianmao=trim(request("jiazhengzhimianmao"))
call Safe_Request(jiazhengzhimianmao,2,"")
danweizhiwu=trim(request("danweizhiwu"))
call Safe_Request(danweizhiwu,2,"")
benrenyaoqiu=trim(request("benrenyaoqiu"))
call Safe_Request(benrenyaoqiu,2,"")
lingdaoyijian=trim(request("lingdaoyijian"))
call Safe_Request(lingdaoyijian,2,"")
bumenyijian=trim(request("bumenyijian"))
call Safe_Request(bumenyijian,2,"")
danweiyijian=trim(request("danweiyijian"))
call Safe_Request(danweiyijian,2,"")
zhusu=trim(request("zhusu"))
call Safe_Request(zhusu,2,"")
jianlidate1="|"+replace(replace(replace(jianlidate,",","|")," ",""),"||","")+"|"
daodate1="|"+replace(replace(replace(daodate,",","|")," ",""),"||","")+"|"
renhezhiwu1="|"+replace(replace(replace(renhezhiwu,",","|")," ",""),"||","")+"|"
guanxi1="|"+replace(replace(replace(guanxi,",","|")," ",""),"||","")+"|"
jianame1="|"+replace(replace(replace(jianame,",","|")," ",""),"||","")+"|"
jiaage1="|"+replace(replace(replace(jiaage,",","|")," ",""),"||","")+"|"
jiazhengzhimianmao1="|"+replace(replace(replace(jiazhengzhimianmao,",","|")," ",""),"||","")+"|"
danweizhiwu1="|"+replace(replace(replace(danweizhiwu,",","|")," ",""),"||","")+"|"
if zhuanye="" then
response.write ""
response.End()
end if
if kaishidate="" then
response.write ""
response.End()
end if
if jieshudate="" then
response.write ""
response.End()
end if
if tianbiaodate="" then
response.write ""
response.End()
end if
if name1="" then
response.write ""
response.End()
end if
sql="select * from jinxiu"
rs.open sql,conn,1,3
rs.addnew
rs("shoujihaoma")=shoujihaoma
rs("e-mail")=email
rs("danweidizhi")=danweidizhi
rs("xuexiban")=xuexiban
rs("zhuanye")=zhuanye
rs("kaishidate")=kaishidate
rs("jieshudate")=jieshudate
rs("jinxiushengname")=jinxiushengname
rs("yuandanwei")=yuandanwei
rs("youbian")=youbian
rs("tianbiaodate")=tianbiaodate
rs("name1")=name1
rs("sex")=sex
rs("age")=age
rs("jiguan")=jiguan
rs("minzu")=minzu
rs("zhengzhimianmao")=zhengzhimianmao
rs("wenhua")=wenhua
rs("jiatingtongxun")=jiatingtongxun
rs("cengzhuanye")=cengzhuanye
rs("xiancongzhuanye")=xiancongzhuanye
rs("yewuzhicheng")=yewuzhicheng
rs("jiankangqingkuang")=jiankangqingkuang
rs("danweidianhua")=danweidianhua
rs("jiatingdianhua")=jiatingdianhua
rs("jianlidate")=jianlidate1
rs("daodate")=daodate1
rs("renhezhiwu")=renhezhiwu1
rs("guanxi")=guanxi1
rs("jianame")=jianame1
rs("jiaage")=jiaage1
rs("jiazhengzhimianmao")=jiazhengzhimianmao1
rs("danweizhiwu")=danweizhiwu1
rs("benrenyaoqiu")=benrenyaoqiu
rs("lingdaoyijian")=lingdaoyijian
rs("bumenyijian")=bumenyijian
rs("danweiyijian")=danweiyijian
rs("zhusu")=zhusu
rs.update
rs.close
'response.Write SQL
response.write ""
end sub
%>
