📄 xy_update.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% issjcz %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改学员的档案</title>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
.style5 {color: #000000}
.STYLE6 {color: #FF0000; font-size: 18px; }
body,td,th {
font-size: 13px;
}
.STYLE7 {color: #FF0066}
body {
background-color: #DBE9FB;
}
-->
</style>
</head>
<body>
<form action="xy_update.asp" method="post" name="form2" target="_self" id="form2">
<span class="STYLE2">
<label></label>
<div align="center"><span class="STYLE3"><br>
填需要修改的学员的学号:</span>
<input name="xuehao" type="text" id="xuehao" value="<%=xuehao%>" size="15" />
<input type="submit" name="Submit2" value="查找该学号的学员" style="width:120;background-color: #FFCC66; color: #000000; border: 1 solid #000000" >
</div>
</span>
</form>
<%
requestid=trim(request("id"))
xuehao=trim(request("xuehao"))
if xuehao<>"" then
sql="select * from jlzd321 where xuehao='"&xuehao&"'"
end if
if requestid<>"" then
sql="select * from jlzd321 where id="&requestid&""
end if
if xuehao="" and requestid="" then
response.end
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,2
if rs.eof then
response.write "<script language=JavaScript>{window.alert('记录不存在或已被删除，请按“确定”返回后“刷新”页面!');window.history.go(-1);}</script>"
response.end
end if
%>
<form id="form1" name="form1" method="post" action="xy_update_save.asp">
<p align="center" class="STYLE6">修改学员：<%=rs("xingming")%> 的档案</p>
<table width="100%" border="1" align="center" cellpadding="2" cellspacing="1" bordercolor="#F3F3F3" style="border-collapse: collapse">
<tr>
<td colspan="4"><span class="STYLE7"> 举办年份：</span><span class="time style5">
<select name="nian" size="1" class="put" id="nian">
<option value="<%=rs("nian")%>" selected ><%=rs("nian")%>年</option>
<%for i=year(date) to 2004 step -1%>
<option value="<%=i%>"><%=i%>年</option>
<%next%>
</select>
<span class="STYLE7"> 第
<select name="qi" size="1" class="put" id="select">
<option value="<%=rs("qi")%>" selected >第<%=rs("qi")%>期</option>
<%for i=1 to 50%>
<option value="<%=i%>">第<%=i%>期</option>
<%next%>
</select>
期 (*必填 *) </span></span></td>
<td colspan="2" rowspan="7"> <p align="center">
<%if rs("zhaopian")<>"" then%>
<a href="<%=rs("zhaopian")%>" target="_blank">
<%end if%>
</a><a href="<%=rs("zhaopian")%>" target="_blank"><img src="<%if rs("zhaopian")="" then%>images/tupian.gif<%end if%><%if rs("zhaopian")<>"" then%><%=rs("zhaopian")%><%end if%>" alt="无相片，请上传" name="img" width="120" height="135" border="0" id="img" /></a><a href="<%=rs("zhaopian")%>" target="_blank">
<%if rs("zhaopian")<>"" then%>
</a>
<%end if%>
<input name="zhaopian" type="hidden" id="zhaopian" />
<br>
<input type="button" name="Submit232" value="相片更新" onClick="javascript:window.open('upload123.asp','窗口名称', 'height=300,width=500,status=no,toolbar=no,menubar=no,location=no,scrollbars=no');" style="width:60;background-color: #FFCC66; color: #000000; border: 1 solid #000000" class=button>
</p></td>
</tr>
<tr>
<td width="162" ><div align="right"><span class="STYLE1">学号:</span></div></td>
<td width="174"><label>
<input name="xuehao" type="text" id="xuehao" value="<%=rs("xuehao")%>" />
</label></td>
<td width="101"><div align="right"><span class="STYLE1">姓名</span></div></td>
<td width="238"><label>
<input name="xingming" type="text" id="xingming" value="<%=rs("xingming")%>" />
</label></td>
</tr>
<tr>
<td><div align="right">性别:</div></td>
<td><label><span class="style5">
<select name="xingbie" id="xingbie">
<option value="<%=rs("xingbie")%>" selected ><%=rs("xingbie")%></option>
<option value="男" >男</option>
<option value="女">女</option>
</select>
</span></label></td>
<td><div align="right">身份证号:</div></td>
<td><input name="shenfenzhenghao" type="text" id="shenfenzhenghao" value="<%=rs("shenfenzhenghao")%>"/></td>
</tr>
<tr>
<td><div align="right">出生年月:</div></td>
<td><span class="time style5">
<%
if isdate(rs("chushengnianyue"))then
byear=year(rs("chushengnianyue"))
bmonth=month(rs("chushengnianyue"))
'bday=day(rs("chushengnianyue"))
end if
%>
<select name="byear" size="1" class="put" id="select14">
<option value="<%=byear%>" selected><%=byear%></option>
<%for i=year(date) to 1930 step -1%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
年
<select name="bmonth" size="1" class="put" id="select15">
<option value="<%=bmonth%>" selected><%=bmonth%></option>
<%for i=1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月</span></td>
<td><div align="right">年龄:</div></td>
<td><%
if isdate(rs("chushengnianyue"))then
byear=year(rs("chushengnianyue"))
bmonth=month(rs("chushengnianyue"))
'bday=day(rs("chushengnianyue"))
nianling=year(date)-byear
end if
%><input name="nianling" type="text" id="nianling" value="<%=nianling%>"/></td>
</tr>
<tr>
<td><div align="right">民族:</div></td>
<td><select name="minzu" id="minzu">
<option value="<%=rs("minzu")%>" selected ><%=rs("minzu")%></option>
<option value="汉族">汉族</option>
<option value="彝族">彝族</option>
<option value="回族">回族</option>
<option value="壮族">壮族</option>
<option value="藏族">藏族</option>
<option value="蒙古族">蒙古族</option>
<option value="维吾尔族">维吾尔族</option>
<option value="苗族">苗族</option>
<option value="布依族">布依族</option>
<option value="朝鲜族">朝鲜族</option>
<option value="满族">满族</option>
<option value="侗族">侗族</option>
<option value="瑶族">瑶族</option>
<option value="白族">白族</option>
<option value="土家族">土家族</option>
<option value="哈尼族">哈尼族</option>
<option value="哈萨克族">哈萨克族</option>
<option value="傣族">傣族</option>
<option value="黎族">黎族</option>
<option value="傈僳族">傈僳族</option>
<option value="佤族">佤族</option>
<option value="畲族">畲族</option>
<option value="高山族">高山族</option>
<option value="拉祜族">拉祜族</option>
<option value="水族">水族</option>
<option value="东乡族">东乡族</option>
<option value="纳西族">纳西族</option>
<option value="景颇族">景颇族</option>
<option value="柯尔克孜族">柯尔克孜族</option>
<option value="土族">土族</option>
<option value="达斡尔族">达斡尔族</option>
<option value="仫佬族">仫佬族</option>
<option value="羌族">羌族</option>
<option value="布朗族">布朗族</option>
<option value="撒拉族">撒拉族</option>
<option value="毛南族">毛南族</option>
<option value="仫佬族">仫佬族</option>
<option value="锡伯族">锡伯族</option>
<option value="阿昌族">阿昌族</option>
<option value="普米族">普米族</option>
<option value="塔吉克族">塔吉克族</option>
<option value="怒族">怒族</option>
<option value="乌孜别克族">乌孜别克族</option>
<option value="俄罗斯族">俄罗斯族</option>
<option value="鄂温克族">鄂温克族</option>
<option value="德昂族">德昂族</option>
<option value="保安族">保安族</option>
<option value="裕固族">裕固族</option>
<option value="京族">京族</option>
<option value="塔塔尔族">塔塔尔族</option>
<option value="独龙族">独龙族</option>
<option value="鄂伦春族">鄂伦春族</option>
<option value="赫哲族">赫哲族</option>
<option value="门巴族">门巴族</option>
<option value="珞巴族">珞巴族</option>
<option value="基诺族">基诺族</option>
<option value="其他">其他</option>
<option value="外国血统中国籍人士">外国血统中国籍人士</option>
</select></td>
<td><div align="right">政治面貌:</div></td>
<td><span class="style5">
<select name="zhengzhimianmao" id="zhengzhimianmao">
<option value="<%=rs("zhengzhimianmao")%>" selected ><%=rs("zhengzhimianmao")%></option>
<option value="团员">团员</option>
<option value="中共党员">中共党员</option>
<option value="民盟">民盟</option>
<option value="民进">民进</option>
<option value="民革">民革</option>
<option value="无">无</option>
</select>
</span></td>
</tr>
<tr>
<td><div align="right">籍贯:</div></td>
<td><input name="jiguan" type="text" id="jiguan" value="<%=rs("jiguan")%>"/></td>
<td><div align="right">文化程度:</div></td>
<td><span class="style5">
<select name="wenhuachengdu" id="wenhuachengdu">
<option value="<%=rs("wenhuachengdu")%>" selected ><%=rs("wenhuachengdu")%></option>
<option value="小学">小学</option>
<option value="初中">初中</option>
<option value="高中">高中</option>
<option value="中等专业">中专</option>
<option value="专科">专科</option>
<option value="本科">本科</option>
</select>
</span></td>
</tr>
<tr>
<td><div align="right">住址:</div></td>
<td colspan="3"><input name="zhuzhi" type="text" id="zhuzhi" value="<%=rs("zhuzhi")%>" size="35"/>
县（市、区）乡（镇）村组</td>
</tr>
<tr>
<td><div align="right">培训专业:</div></td>
<td><select name="peixunzhuanye" id="peixunzhuanye">
<option value="<%=rs("peixunzhuanye")%>" selected><%=rs("peixunzhuanye")%></option>
<%
sqlzdzy="select * from zd_peixunzhuanye order by peixunzhuanye asc"
set rszdzy=server.CreateObject("adodb.recordset")
rszdzy.open sqlzdzy,conn,1,2
do while not rszdzy.eof
%>
<option value="<%=rszdzy("peixunzhuanye")%>"><%=rszdzy("peixunzhuanye")%></option>
<%rszdzy.movenext
loop%>
</select></td>
<td><div align="right">培训时间:</div></td>
<td><span class="time style5">
<%
if isdate(rs("peixunshijian"))then
peixunyear=year(rs("peixunshijian"))
peixunmonth=month(rs("peixunshijian"))
peixunday=day(rs("peixunshijian"))
end if
%>
<select name="peixunyear" size="1" class="put" id="peixunyear">
<option value="<%=peixunyear%>" selected><%=peixunyear%></option>
<%for i=year(date) to 2004 step -1%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
年
<select name="peixunmonth" size="1" class="put" id="select2">
<option value="<%=peixunmonth%>" selected><%=peixunmonth%></option>
<%for i=1 to 12%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
月
<select name="peixunday" size="1" class="put" id="select16">
<option value="<%=peixunday%>" selected><%=peixunday%></option>
<%for i=1 to 31%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
日</span></td>
<td width="99"><div align="right">收费标准:</div></td>
<td width="140"><input name="shoufeibiaozhun" type="text" id="shoufeibiaozhun" value="<%=rs("shoufeibiaozhun")%>" size="15"/></td>
</tr>
<tr>
<td><div align="right">补助金额:</div></td>
<td><input name="buzhujine" type="text" id="buzhujine" value="<%=rs("buzhujine")%>"/></td>
<td><div align="right">考核:</div></td>
<td><span class="style5">
<select name="kaohe" id="kaohe">
<option value="<%=rs("kaohe")%>" selected ><%=rs("kaohe")%></option>
<option value="合格">合格</option>
<option value="不合格">不合格</option>
</select>
</span></td>
<td><div align="right">证书编号:</div></td>
<td><input name="zhengshubianhao" type="text" id="zhengshubianhao" value="<%=rs("zhengshubianhao")%>" size="15"/></td>
</tr>
<tr>
<td><div align="right">就业去向:</div></td>
<td><input name="jiuyequxiang" type="text" id="jiuyequxiang" value="<%=rs("jiuyequxiang")%>"/></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -