<!--#include file="../SQLconn.asp"-->
<%

'检查权限
       tname=request.cookies("tname") 
       Set MyOAASPObj= Server.CreateObject("YFSchoolOApro.YFSchoolDll")
           if MyOAASPObj.QuanXian(tname,"学籍管理")=0 then 
		    response.redirect  "../NoPower.asp"
           end if 
		   set MyOAASPObj=nothing

'检查权限结束
%>

<%
id=Request( "id")
years=request.cookies("nowxueqi")
grade = Request.Form("selgrade")
sclass = Request.Form("selclass")
tongyibianhao = Request.Form("tongyibianhao")
sNumber = Request.Form("Number")
Uname = Request.Form("Uname")
strsex = Request.Form("sex")
strjiazhang = Request.Form("jiazhangxingming")
strjiatingdizhi = Request.Form("jiatingdizhi")
strbirthday = Request.Form("bdate")
strhujiszd = Request.Form("hjszd")
strhujitype = Request.Form("hjtype")
strhujixingzhi = Request.Form("huxingzhi")
strxslaiyuan = Request.Form("slaiyuan")
strxsquxiang = Request.Form("xsquxiang")
strmemo = Request.Form("memoa")

stroldschool = Request.Form("oldschool")
strmingzu = Request.Form("mingz")
strzhengzhi = Request.Form("zhengzh")
strjiudufangshi = Request.Form("stype")
strjiankang = Request.Form("jiank")
strjifen = Request.Form("jifen")
strhukou = Request.Form("hk")
strmailNo = Request.Form("mail")
strphoneNo = Request.Form("phone")
strtechang = Request.Form("tc")
ruxueyear = Request.Form("ruxueyear")
shengfenzhenghao = Request.Form("shengfenzhenghao")
jiazhangguanxi = Request.Form("jiazhangguanxi")
jiazhangdanwei = Request.Form("jiazhangdanwei")
zhengzhidate = Request.Form("zhengzhidate")
shifouhuaqiao = Request.Form("shifouhuaqiao")

password = Request.Form("password")
quanxian = Request.Form("quanxian")


strsql="update  students  set tongyibianhao='"&tongyibianhao& "',number='"&sNumber& "',Uname='"&Uname& "',sex='"&strsex& "',jiazhangxingming='"&strjiazhang& "',jiatingdizhi='"&strjiatingdizhi& "',birthday='"&strbirthday& "',hujiszd='"&strhujiszd& "',hujitype='"&strhujitype& "',hujixingzhi='"&strhujixingzhi& "',xslaiyuan='"&strxslaiyuan& "',xsquxiang='"&strxsquxiang& "',memo='"&strmemo& "',oldschool='"&stroldschool& "',minzu='"&strmingzu& "',zhengzhi='"&strzhengzhi& "',jiudufangshi='"&strjiudufangshi& "' ,jiankang='"&strjiankang& "',jifen='"&strjifen& "',hukou='"&strhukou& "',mailNo='"&strmailNo& "',phoneNo='"&strphoneNo& "',techang='"&strtechang& "',入学年份='"&ruxueyear& "',身份证号码='"&shengfenzhenghao& "',加入政治面貌日期='"&zhengzhidate& "',是否华侨='"&shifouhuaqiao& "',和家长关系='"&jiazhangguanxi& "',家长工作单位='"&jiazhangdanwei& "',password='"&password& "',权限='"&quanxian& "' where ID='"&id& "'"
conn.execute(strsql)
       response.redirect   "student.asp?years="&years&"&selgrade="&grade&"&selclass="&sclass
                
%>

