messagebox("!",""+xh+"补考成绩不及格")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj1",cj)
dw_master2.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"zp",a_qmcj[i])
end if//ee3
else //2
if isnull(cxcj2) then//4
if cj>=60 then//5
dw_master3.setitem(1,"cxcj2",cj)//将重修成绩写入学生成绩表文件
dw_master3.accepttext()
messagebox("!",""+xh+"第二次补考成绩60以上")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj2",cj)
dw_master1.setitem(i,"zp",60)
dw_master2.setitem(i,"bjgyy","0")
dw_master1.setitem(i,"bjgyy","0")
else//5
dw_master3.setitem(1,"cxcj2",cj)//将重修成绩写入学生成绩表文件
dw_master3.accepttext()
messagebox("!",""+xh+"第二次补考成绩不及格")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj2",cj)
dw_master2.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"zp",a_qmcj[i])
end if//ee5
else //4
return
end if//bb2
dw_master1.setitem(i,"jd",0)
if update(dw_master3)>0 then//4
commit;//数据提交
end if//2
end if//dd
else//bb没有不及格记录
return
end if//bb
end if
// else//aa
// if bjgyy="4" then //vv
// dw_master3.retrieve(xh,s_kcdm,s_xn,s_xq)
//if ksxzm="1" then
///////////////////////////////////////
// messagebox("不是补考","不是补考")
if a_bjgyy[i]="4" then //aa
messagebox("缓考","缓考")
dw_master3.retrieve(xh,s_kcdm,s_xn,s_xq)
messagebox("1","1")
// dw_master2.retrieve(xh,s_kcdm,s_xn,s_xq)
if dw_master3.rowcount()<=0 then//cc不及格课程与重修课程不一致
s_kcdm1=mid(dw_master1.getitemstring(i,"bz"),5,7)//查询原不及格课程
dw_master3.retrieve(xh,s_kcdm1,s_xn,s_xq)
end if//cc
messagebox("3","3")
if dw_master3.rowcount()>0 then//bb 1
messagebox("2","2")
//cj=dw_master3.getitemnumber(1,"cj")
cxcj1=dw_master3.getitemnumber(1,"cxcj1")
cxcj2=dw_master3.getitemnumber(1,"cxcj2")
if isnull(cxcj1)then//正常考试//11
if cj>=60 then//aa
dw_master3.setitem(1,"cj",cj)//将重修成绩写入学生成绩表文件
dw_master3.setitem(1,"kcjd",round(cj/10 - 5,1))
messagebox("!",""+xh+"第一次缓考成绩及格")
dw_master2.setitem(i,"kcjd",round(cj/10 - 5,1))
dw_master2.setitem(i,"cj",cj)
dw_master1.setitem(i,"zp",cj)
dw_master2.setitem(i,"bjgyy","0")
dw_master1.setitem(i,"bjgyy","0")
else
dw_master3.setitem(1,"cj",cj)//将重修成绩写入学生成绩表文件
messagebox("!",""+xh+"第一次缓考成绩不及格")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cj",cj)
dw_master2.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"zp",a_qmcj[i])
end if//ee
else//11
if isnull(cxcj2) then//dd第一次重修缓考
if cj>=60 then //ee
dw_master3.setitem(1,"cxcj1",cj)//将重修成绩写入学生成绩表文件
messagebox("!",""+xh+"第二次缓考成绩及格")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj1",cj)
dw_master1.setitem(i,"zp",cj)
dw_master2.setitem(i,"bjgyy","0")
dw_master1.setitem(i,"bjgyy","0")
else
dw_master3.setitem(1,"cxcj2",cj)//将重修成绩写入学生成绩表文件
messagebox("!",""+xh+"第二次缓考不及格")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj1",cj)
dw_master2.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"zp",a_qmcj[i])
end if//ee
else//dd
if cj>=60 then //ee
dw_master3.setitem(1,"cxcj1",cj)//将重修成绩写入学生成绩表文件
messagebox("!","第三次")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj2",cj)
dw_master1.setitem(i,"zp",cj)
dw_master2.setitem(i,"bjgyy","0")
dw_master1.setitem(i,"bjgyy","0")
else
dw_master3.setitem(1,"cxcj2",cj)//将重修成绩写入学生成绩表文件//第二次重修
messagebox("!","33333333333333")
dw_master2.setitem(i,"kcjd",0)
dw_master2.setitem(i,"cxcj1",cj)
dw_master2.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"bjgyy","1")
dw_master1.setitem(i,"zp",a_qmcj[i])
end if//ee
end if
//end if
end if
dw_master1.setitem(i,"jd",0)
if update(dw_master3)>0 then
commit;//数据提交
end if
else//bb没有不及格记录
messagebox("46465465","54654654")
return
end if//dd