xy_add_save.asp

培训学员管理系统

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp" -->
<!--#include file="admin_qx.asp" -->
<% issjcz %>
<%
nian=trim(request("nian"))
qi=trim(request("qi"))
xuehao=trim(request("xuehao"))
xingming=trim(request("xingming"))
xingbie=trim(request("xingbie"))

' chushengnianyue=trim(request("chushengnianyue"))'-----------
nianling=trim(request("nianling"))
shenfenzhenghao=trim(request("shenfenzhenghao"))
zhaopian=trim(request("zhaopian"))
minzu=trim(request("minzu"))
zhengzhimianmao=trim(request("zhengzhimianmao"))
jiguan=trim(request("jiguan"))
zhuzhi=trim(request("zhuzhi"))
wenhuachengdu=trim(request("wenhuachengdu"))
peixunzhuanye=trim(request("peixunzhuanye"))
'peixunshijian=trim(request("peixunshijian"))
shoufeibiaozhun=trim(request("shoufeibiaozhun"))
buzhujine=trim(request("buzhujine"))
kaohe=trim(request("kaohe"))
zhengshubianhao=trim(request("zhengshubianhao"))
jiuyequxiang=trim(request("jiuyequxiang"))
lianxidianhua=trim(request("lianxidianhua"))
peixunkemu=trim(request("peixunkemu"))
jizhongpeixunshijian=trim(request("jizhongpeixunshijian"))
cjxxkslilunke=trim(request("cjxxkslilunke"))
cjxxksshijianke=trim(request("cjxxksshijianke"))
cjxxkszixueke=trim(request("cjxxkszixueke"))
kskhcjkaoshi=trim(request("kskhcjkaoshi"))
kskhcjkaohe=trim(request("kskhcjkaohe"))
peixunkemu1=trim(request("peixunkemu1"))
jizhongpeixunshijian1=trim(request("jizhongpeixunshijian1"))
cjxxkslilunke1=trim(request("cjxxkslilunke1"))
cjxxksshijianke1=trim(request("cjxxksshijianke1"))
cjxxkszixueke1=trim(request("cjxxkszixueke1"))
kskhcjkaoshi1=trim(request("kskhcjkaoshi1"))
kskhcjkaohe1=trim(request("kskhcjkaohe1"))
peixunkemu2=trim(request("peixunkemu2"))
jizhongpeixunshijian2=trim(request("jizhongpeixunshijian2"))
cjxxkslilunke2=trim(request("cjxxkslilunke2"))
cjxxksshijianke2=trim(request("cjxxksshijianke2"))
cjxxkszixueke2=trim(request("cjxxkszixueke2"))
kskhcjkaoshi2=trim(request("kskhcjkaoshi2"))
kskhcjkaohe2=trim(request("kskhcjkaohe2"))
peixunkemu3=trim(request("peixunkemu3"))
jizhongpeixunshijian3=trim(request("jizhongpeixunshijian3"))
cjxxkslilunke3=trim(request("cjxxkslilunke3"))
cjxxksshijianke3=trim(request("cjxxksshijianke3"))
cjxxkszixueke3=trim(request("cjxxkszixueke3"))
kskhcjkaoshi3=trim(request("kskhcjkaoshi3"))
kskhcjkaohe3=trim(request("kskhcjkaohe3"))
peixunkemu4=trim(request("peixunkemu4"))
jizhongpeixunshijian4=trim(request("jizhongpeixunshijian4"))
cjxxkslilunke4=trim(request("cjxxkslilunke4"))
cjxxksshijianke4=trim(request("cjxxksshijianke4"))
cjxxkszixueke4=trim(request("cjxxkszixueke4"))
kskhcjkaoshi4=trim(request("kskhcjkaoshi4"))
kskhcjkaohe4=trim(request("kskhcjkaohe4"))
peixunkemu5=trim(request("peixunkemu5"))
jizhongpeixunshijian5=trim(request("jizhongpeixunshijian5"))
cjxxkslilunke5=trim(request("cjxxkslilunke5"))
cjxxksshijianke5=trim(request("cjxxksshijianke5"))
cjxxkszixueke5=trim(request("cjxxkszixueke5"))
kskhcjkaoshi5=trim(request("kskhcjkaoshi5"))
kskhcjkaohe5=trim(request("kskhcjkaohe5"))
peixunkemu6=trim(request("peixunkemu6"))
jizhongpeixunshijian6=trim(request("jizhongpeixunshijian6"))
cjxxkslilunke6=trim(request("cjxxkslilunke6"))
cjxxksshijianke6=trim(request("cjxxksshijianke6"))
cjxxkszixueke6=trim(request("cjxxkszixueke6"))
kskhcjkaoshi6=trim(request("kskhcjkaoshi6"))
kskhcjkaohe6=trim(request("kskhcjkaohe6"))
shifouqudezhengshu=trim(request("shifouqudezhengshu"))
jiaoxuechengbandanweipingyi=trim(request("jiaoxuechengbandanweipingyi"))
jiaoxuechengbandanweifuzeren=trim(request("jiaoxuechengbandanweifuzeren"))
'jiaoxuechengbandanweiqianzinianyueri=trim(request("jiaoxuechengbandanweiqianzinianyueri"))
shiyangguangbanyijian=trim(request("shiyangguangbanyijian"))
shiyangguangbanfuzeren=trim(request("shiyangguangbanfuzeren"))
'shiyangguangbanfuzerenqianzinianyueri=trim(request("shiyangguangbanfuzerenqianzinianyueri"))
xueqiancongyezhuangkuang=trim(request("xueqiancongyezhuangkuang"))
xuehoucongyezhuangkuang=trim(request("xuehoucongyezhuangkuang"))
beizhu=trim(request("beizhu"))
'组合出生chushengnianyue
byear=request("byear")
bmonth=request("bmonth")
'bday=request("bday")
'培训时间-----
peixunyear=request("peixunyear")
peixunmonth=request("peixunmonth")
peixunday=request("peixunday")
'承办单位负责人签字年月日jiaoxuechengbandanweiqianzinianyueri-----
chengbandanweiyear=request("chengbandanweiyear")
chengbandanweimonth=request("chengbandanweimonth")
chengbandanweiday=request("chengbandanweiday")
'主管部门办负责人签字年月日　shiyangguangbanfuzerenqianzinianyueri----
shiyangguangbanyear=request("shiyangguangbanyear")
shiyangguangbanmonth=request("shiyangguangbanmonth")
shiyangguangbanday=request("shiyangguangbanday")

if bmonth<>"" and byear="" then
response.Write "<script language=javascript>{window.alert('报错：您输入了出生的月份，那么请输入出生年份！');window.history.go(-1);}</script>"
response.End
end if
if bmonth="" and byear<>"" then
response.Write "<script language=javascript>{window.alert('报错：您输入了出生的年份，那么请输入出生月份！');window.history.go(-1);}</script>"
response.End
end if
if bmonth<>"" and byear<>"" then
chushengnianyue=byear&"-"&bmonth
end if
if bmonth="" and byear="" then
chushengnianyue=""
end if
'------------
if peixunyear<>""then 
if peixunmonth=""then
response.Write "<script language=javascript>{window.alert('报错：“培训日期”不完整，请至少再选择“培训日期的月份”！');window.history.go(-1);}</script>"
response.End
end if
end if
if peixunmonth<>""then 
if peixunyear=""then
response.Write "<script language=javascript>{window.alert('报错：“培训日期”不完整，请至少再选择“培训日期的年份”！');window.history.go(-1);}</script>"
response.End
end if
end if
if peixunyear<>"" and peixunmonth<>"" then
peixunshijian=peixunyear&"-"&peixunmonth&"-"&peixunday
else
peixunshijian=""
end if 

'------------承办单位时间chengbandanwei
if chengbandanweiyear<>""then 
if chengbandanweimonth=""then
response.Write "<script language=javascript>{window.alert('报错：“承办单位负责人签字年月日”不完整，请至少再选择“培训日期的月份”！');window.history.go(-1);}</script>"
response.End
end if
end if
if chengbandanweimonth<>""then 
if chengbandanweiyear=""then
response.Write "<script language=javascript>{window.alert('报错：“承办单位负责人签字年月日”不完整，请至少再选择“培训日期的年份”！');window.history.go(-1);}</script>"
response.End
end if
end if
if chengbandanweiyear<>"" and chengbandanweimonth<>"" then
jiaoxuechengbandanweiqianzinianyueri=chengbandanweiyear&"-"&chengbandanweimonth&"-"&chengbandanweiday
else
jiaoxuechengbandanweiqianzinianyueri=""
end if 
'------------签字时间
if shiyangguangbanyear<>""then 
if shiyangguangbanmonth=""then
response.Write "<script language=javascript>{window.alert('报错：“主管部门负责人签字年月日”不完整，请至少再选择“培训日期的月份”！');window.history.go(-1);}</script>"
response.End
end if
end if
if shiyangguangbanmonth<>""then 
if shiyangguangbanyear=""then
response.Write "<script language=javascript>{window.alert('报错：“主管部门负责人签字年月日”不完整，请至少再选择“培训日期的年份”！');window.history.go(-1);}</script>"
response.End
end if
end if
if shiyangguangbanyear<>"" and shiyangguangbanmonth<>"" then
shiyangguangbanfuzerenqianzinianyueri=shiyangguangbanyear&"-"&shiyangguangbanmonth&"-"&shiyangguangbanday
else
shiyangguangbanfuzerenqianzinianyueri=""
end if 

sql="select * from jlzd321"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,2
rs.addnew
rs("nian")=nian
rs("qi")=qi
rs("xuehao")=xuehao
rs("xingming")=xingming
rs("xingbie")=xingbie
rs("chushengnianyue")=chushengnianyue
rs("nianling")=nianling
rs("shenfenzhenghao")=shenfenzhenghao
rs("zhaopian")=zhaopian
rs("minzu")=minzu
rs("zhengzhimianmao")=zhengzhimianmao
rs("jiguan")=jiguan
rs("zhuzhi")=zhuzhi
rs("wenhuachengdu")=wenhuachengdu
rs("peixunzhuanye")=peixunzhuanye
rs("peixunshijian")=peixunshijian
rs("shoufeibiaozhun")=shoufeibiaozhun
rs("buzhujine")=buzhujine
rs("kaohe")=kaohe
rs("zhengshubianhao")=zhengshubianhao
rs("jiuyequxiang")=jiuyequxiang
rs("lianxidianhua")=lianxidianhua
rs("peixunkemu1")=peixunkemu1
rs("jizhongpeixunshijian1")=jizhongpeixunshijian1
rs("cjxxkslilunke1")=cjxxkslilunke1
rs("cjxxksshijianke1")=cjxxksshijianke1
rs("cjxxkszixueke1")=cjxxkszixueke1
rs("kskhcjkaoshi1")=kskhcjkaoshi1
rs("kskhcjkaohe1")=kskhcjkaohe1
rs("peixunkemu2")=peixunkemu2
rs("jizhongpeixunshijian2")=jizhongpeixunshijian2
rs("cjxxkslilunke2")=cjxxkslilunke2
rs("cjxxksshijianke2")=cjxxksshijianke2
rs("cjxxkszixueke2")=cjxxkszixueke2
rs("kskhcjkaoshi2")=kskhcjkaoshi2
rs("kskhcjkaohe2")=kskhcjkaohe2
rs("peixunkemu3")=peixunkemu3
rs("jizhongpeixunshijian3")=jizhongpeixunshijian3
rs("cjxxkslilunke3")=cjxxkslilunke3
rs("cjxxksshijianke3")=cjxxksshijianke3
rs("cjxxkszixueke3")=cjxxkszixueke3
rs("kskhcjkaoshi3")=kskhcjkaoshi3
rs("kskhcjkaohe3")=kskhcjkaohe3
rs("peixunkemu4")=peixunkemu4
rs("jizhongpeixunshijian4")=jizhongpeixunshijian4
rs("cjxxkslilunke4")=cjxxkslilunke4
rs("cjxxksshijianke4")=cjxxksshijianke4
rs("cjxxkszixueke4")=cjxxkszixueke4
rs("kskhcjkaoshi4")=kskhcjkaoshi4
rs("kskhcjkaohe4")=kskhcjkaohe4
rs("peixunkemu5")=peixunkemu5
rs("jizhongpeixunshijian5")=jizhongpeixunshijian5
rs("cjxxkslilunke5")=cjxxkslilunke5
rs("cjxxksshijianke5")=cjxxksshijianke5
rs("cjxxkszixueke5")=cjxxkszixueke5
rs("kskhcjkaoshi5")=kskhcjkaoshi5
rs("kskhcjkaohe5")=kskhcjkaohe5
rs("peixunkemu6")=peixunkemu6
rs("jizhongpeixunshijian6")=jizhongpeixunshijian6
rs("cjxxkslilunke6")=cjxxkslilunke6
rs("cjxxksshijianke6")=cjxxksshijianke6
rs("cjxxkszixueke6")=cjxxkszixueke6
rs("kskhcjkaoshi6")=kskhcjkaoshi6
rs("kskhcjkaohe6")=kskhcjkaohe6
rs("shifouqudezhengshu")=shifouqudezhengshu
rs("jiaoxuechengbandanweipingyi")=jiaoxuechengbandanweipingyi
rs("jiaoxuechengbandanweifuzeren")=jiaoxuechengbandanweifuzeren
rs("jiaoxuechengbandanweiqianzinianyueri")=jiaoxuechengbandanweiqianzinianyueri
rs("shiyangguangbanyijian")=shiyangguangbanyijian
rs("shiyangguangbanfuzeren")=shiyangguangbanfuzeren
rs("shiyangguangbanfuzerenqianzinianyueri")=shiyangguangbanfuzerenqianzinianyueri
rs("xueqiancongyezhuangkuang")=xueqiancongyezhuangkuang
rs("xuehoucongyezhuangkuang")=xuehoucongyezhuangkuang
rs("beizhu")=Replace(beizhu,chr(13),"<br>")	
rs.update
response.Write "<script language=javascript>{window.alert('学员记录添加成功!请点击“确定”继续添加　　　');window.location.href='xy_add.asp';}</script>"
setrs(rs)
%>