⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_file.asp

📁 这是一个学生档案管理系统,欢迎大家下载使用哈!
💻 ASP
📖 第 1 页 / 共 3 页
字号:

 </div> 
 </FORM>
</div> 
<%







ElseIf action="edit" Then 
	Dim picurl
	picurl="default.gif"
	Sql_Lists="ClassNo,Name,His,Gender,National,"&_
		"birth,Political,Political_date,Entry,Entry_Date,"&_
		"Telephone,Birthplace,address,identityNo,Zip,"&_
		"Learning,talent,Incentives,Hobbies,demerits,"&_
		"Changes,Graduation_Date,Graduation_future,Remarks,pic,"&_
		"file_jk_l0,file_jk_l1,file_jk_l2,file_jk_l3,file_jk_l4,"&_
		"file_gx_l0,file_gx_l1,file_gx_l2,file_gx_l3,file_gx_l4"
	Sql_tables="File_info"
	Sql_Conditions=" ID = "&id
	sql=Sqlinfo(Sql_Lists,Sql_tables,Sql_Conditions,Sql_Sortings,Sql_Orders,Sql_Additional)
	file_edit = connopen(sql)
	If isArray(file_edit) Then
		If file_edit(24,0)<>"" Then picurl=file_edit(24,0)
		response.write "<h1>学生档案信息资料修改</h1>"
		Dim arr_file_i(9)
		For file_i=0 To 9
			arr_file_i(file_i)=Split(file_edit(file_i+25,0),",")
		Next
		%>
	<div id="tabs0"> 
	 <ul class="menu0" id="menu0"> 
		<li onclick="setTab(0,0)" class="hover">基本资料</li> 
		<li onclick="setTab(0,1)">阅历及关系</li> 
		<li onclick="setTab(0,2)">学习情况</li> 
		<li onclick="setTab(0,3)">学籍变动</li>
		<li onclick="setTab(0,4)">备 注</li>
	 </ul> 
	 <FORM METHOD=POST name="myform" ACTION="admin_File_save.asp" enctype="multipart/form-data">
		<div class="main" id="main0"> 
		<ul class="block"><li>
				<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
				<tr>
			<td width="15%" align="center">姓&nbsp;&nbsp;&nbsp;&nbsp;名</td>
			<td colspan="2" width="40%"><input type="text" name="Name" size="20" value="<%=file_edit(1,0)%>"></td>
			<td rowspan="5" width="25%"><img src="..\upload\<%=picurl%>" id="imageurl" name="imageurl" width="90" height="120"><BR>像片规格:90*120</td>
			<td rowspan="14" width="20%" align="center" valign="top" style="padding-top:10px;"> <%file_but%></td>
		</tr>
		<tr>
			<td align="center">曾&nbsp;用&nbsp;名</td>
			<td colspan="2"><input type="text" name="His" size="20" value="<%=file_edit(5,0)%>"></td>
		</tr>
		<tr>
			<td align="center">性&nbsp;&nbsp;&nbsp;&nbsp;别</td>
			<td colspan="2">
			<label><INPUT TYPE="radio" NAME="Gender" value="0" style="border: 0;" 
			<% If file_edit(3,0)="0" Then response.write " checked "%>
			>男 </label>   
			<label><INPUT TYPE="radio" NAME="Gender" value="1" style="border: 0;"
			<% If file_edit(3,0)="1" Then response.write " checked "%>
			>女 </label></td>
		</tr>
		<tr>
			<td align="center">出生日期</td>
			<td colspan="2"><input type="text" name="birth" size="20" value="<%=file_edit(5,0)%>" onclick="setday(this)"></td>
		</tr>
		<tr>
			<td align="center">免冠照片</td>
			<td colspan="2"><input type="file" name="file1" onChange="ChangeImagePro(this.value)"></td>
		</tr>
		<tr>
			<td align="center">学&nbsp;&nbsp;&nbsp;&nbsp;号</td>
			<td colspan="2"><input type="text" name="ClassNo" size="20" value="<%=file_edit(0,0)%>"></td>
			<td rowspan="3"> </td>
		</tr>
		<tr>
			<td align="center"><span lang="zh-cn">所在集体</span></td>
			<td colspan="2"><input type="text" name="T4" size="40"></td>
		</tr>
		<tr>
			<td align="center">身份证号</td>
			<td colspan="2"><input type="text" name="identityNo" size="40" value="<%=file_edit(13,0)%>"></td>
		</tr>
		<tr>
			<td align="center">入学学历</td>
			<td width="25%"><SELECT NAME="Entry"><%=sel_arr_Entry(file_edit(8,0))%></SELECT></td>
			<td width="15%">政治面貌</td>
			<td><SELECT NAME="Political"><%=sel_arr_Political(file_edit(6,0))%></SELECT></td>
		</tr>
		<tr>
			<td align="center">入学日期</td>
			<td><input type="text" name="Entry_Date" size="20" value="<%=file_edit(9,0)%>" onclick="setday(this)"></td>
			<td>加入组织日期</td>
			<td><input type="text" name="Political_date" size="20" value="<%=file_edit(7,0)%>" onclick="setday(this)"></td>
		</tr>
		<tr>
			<td align="center">民&nbsp;&nbsp;&nbsp;&nbsp;族</td>
			<td><SELECT NAME="National"><%=sel_arr_National(file_edit(4,0))%></SELECT></td>
			<td>籍&nbsp;&nbsp;&nbsp;&nbsp;贯</td>
			<td><input type="text" name="Birthplace" size="20" value="<%=file_edit(11,0)%>"></td>
		</tr>
		<tr>
			<td align="center">家庭住址</td>
			<td><input type="text" name="address" size="20" value="<%=file_edit(12,0)%>"></td>
			<td> </td>
			<td> </td>
		</tr>
		<tr>
			<td align="center">联系电话</td>
			<td><input type="text" name="Telephone" size="20" value="<%=file_edit(10,0)%>"></td>
			<td>邮&nbsp;&nbsp;&nbsp;&nbsp;编</td>
			<td><input type="text" name="Zip" size="20" value="<%=file_edit(14,0)%>"></td>
		</tr>
		<tr>
			<td> </td>
			<td> </td>
			<td> </td>
			<td> </td>
		</tr>
	</table>

		</li></ul> 
		<ul><li>
	<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
		<tr>
			<td width="80%">
			<h2>个人简况</h2>
				<table width="98%" cellspacing="1" cellpadding="0" class="info_tab">
				<tr align="center">
					<td width="30%" class="art_tit">何年何月到何年何月</td>
					<td width="30%" class="art_tit">所在学校或单位</td>
					<td width="20%" class="art_tit">任何职务</td>
					<td width="20%" class="art_tit">证明人</td>
				</tr>
				<%For file_jk_i=0 To 3%>
				<tr align="center">
				
				<td><input type="text" name="file_jk_l0" onKeyPress="if(event.keyCode==44)event.returnValue=false;" class="file_input_info"
								onMouseOver="this.style.background='#E1F4EE';" 
								onMouseOut="this.style.background='#FFFFFF'"
								onkeydown="if(event.keyCode==13)event.keyCode=9" style="width:45%;" onclick="setday(this)" value="<%=arr_file_i(0)(file_jk_i)%>">-
								<input type="text" name="file_jk_l1" class="file_input_info"
								onMouseOver="this.style.background='#E1F4EE';" 
								onMouseOut="this.style.background='#FFFFFF'" 
								onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
								onkeydown="if(event.keyCode==13)event.keyCode=9" style="width:45%;" onclick="setday(this)" value="<%=arr_file_i(1)(file_jk_i)%>"></td>
				<td><input type="text" name="file_jk_l2" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(2)(file_jk_i)%>"></td>
				<td><input type="text" name="file_jk_l3" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(3)(file_jk_i)%>"></td>
				<td><input type="text" name="file_jk_l4" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(4)(file_jk_i)%>"></td>
			</tr>
				<%next%>
				</table>
				<h2>社会关系</h2>
				<table width="98%" cellspacing="1" cellpadding="0" class="info_tab">
				<tr align="center">
					<td width="15%" class="art_tit">称呼</td>
					<td width="15%" class="art_tit">姓名</td>
					<td width="30%" class="art_tit">在何单位</td>
					<td width="20%" class="art_tit">现任何职</td>
					<td width="20%" class="art_tit">联系电话</td>
				</tr>
				<%For file_gx_i=0 To 3%>
				<tr align="center">
								<tr align="center">
				<td><input type="text" name="file_gx_l0" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(5)(file_gx_i)%>"></td>
				<td><input type="text" name="file_gx_l1" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(6)(file_gx_i)%>"></td>
				<td><input type="text" name="file_gx_l2" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(7)(file_gx_i)%>"></td>
				<td><input type="text" name="file_gx_l3" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(8)(file_gx_i)%>"></td>
				<td><input type="text" name="file_gx_l4" class="file_input_info"
							onMouseOver="this.style.background='#E1F4EE';" 
							onMouseOut="this.style.background='#FFFFFF'" 
							onKeyPress="if(event.keyCode==44)event.returnValue=false;" 
							onkeydown="if(event.keyCode==13)event.keyCode=9" value="<%=arr_file_i(9)(file_gx_i)%>"></td>
			</tr>
				<%next%>

				</table>
			</td>
			<td width="20%" align="center" valign="top" style="padding-top:10px;"> <%file_but%></td>
		</tr>
	</table>



		</li></ul> 
		<ul><li>
			<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
				<tr>
					<td width="80%">
					
						<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
						<tr>
							<td colspan="2"><h2>学习情况</h2><TEXTAREA NAME="Learning" class="file_TEXTAREA_info" style="height:80px;"><%If  Not IsNull(file_edit(15,0)) Then response.write Replace(file_edit(15,0),"${}$",Chr(13))%></TEXTAREA></td>
						</tr>
						<tr>
							<td width="50%"><h2>个人特长</h2><TEXTAREA NAME="talent" class="file_TEXTAREA_info"><%If  Not IsNull(file_edit(16,0)) Then response.write Replace(file_edit(16,0),"${}$",Chr(13))%></TEXTAREA></td>
							<td width="50%"><h2>奖惩记录</h2><TEXTAREA NAME="Incentives" class="file_TEXTAREA_info"><%If  Not IsNull(file_edit(17,0)) Then response.write Replace(file_edit(17,0),"${}$",Chr(13))%></TEXTAREA></td>
						</tr>
						<tr>
							<td><h2>爱好</h2><TEXTAREA NAME="Hobbies" class="file_TEXTAREA_info"><%If  Not IsNull(file_edit(18,0)) Then response.write Replace(file_edit(18,0),"${}$",Chr(13))%></TEXTAREA></td>
							<td><h2>处分记过</h2><TEXTAREA NAME="demerits" class="file_TEXTAREA_info"><%If  Not IsNull(file_edit(19,0)) Then response.write Replace(file_edit(19,0),"${}$",Chr(13))%></TEXTAREA></td>
						</tr>
						</table>
						
					</td>
					<td width="20%" align="center" valign="top" style="padding-top:10px;"> <%file_but%></td>
				</tr>
			</table>

		</li></ul> 
		<ul><li>
			<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
				<tr>
					<td width="80%">
					
						<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
						<tr>
							<td colspan="2"><h2>学籍异动情况</h2><TEXTAREA NAME="Changes" class="file_TEXTAREA_info" style="height:100px;"><%If  Not IsNull(file_edit(20,0)) Then response.write Replace(file_edit(20,0),"${}$",Chr(13))%></TEXTAREA></td>
						</tr>
						<tr>
							<td width="50%"><h2>毕(结)业或肄业日期</h2><TEXTAREA NAME="Graduation_Date" class="file_TEXTAREA_info" style="height:100px;"><%If  Not IsNull(file_edit(21,0)) Then response.write Replace(file_edit(21,0),"${}$",Chr(13))%></TEXTAREA></td>
							<td width="50%"><h2>毕(结)业或肄业去向</h2><TEXTAREA NAME="Graduation_future" class="file_TEXTAREA_info" style="height:100px;"><%If  Not IsNull(file_edit(22,0)) Then response.write Replace(file_edit(22,0),"${}$",Chr(13))%></TEXTAREA></td>
						</tr>
						</table>
						
					</td>
					<td width="20%" align="center" valign="top" style="padding-top:10px;"> <%file_but%></td>
				</tr>
			</table>

		</li></ul> 
		<ul><li>
		<table width="98%" cellspacing="0" cellpadding="0" class="info_tab">
				<tr>
					<td width="80%">
						<BR><TEXTAREA NAME="Remarks" class="file_TEXTAREA_info" style="height:300px;"><%If  Not IsNull(file_edit(23,0)) Then response.write Replace(file_edit(23,0),"${}$",Chr(13))%></TEXTAREA>
					</td>
					<td width="20%" align="center" valign="top" style="padding-top:10px;"> <%file_but%></td>
				</tr>
			</table>
		</li></ul> 

	 </div> 
	 </FORM>
	</div> 
	<%
	Else
		errormsg "参数错误"
	End If

ElseIf action="del" Then
if id="" then errormsg "参数错误!"
set dels=conn.execute("delete from Cert_info where id in ("&id&")")
set dels=Nothing 
rightmsg "admin_File.asp?action=list",""

End If



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

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -