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

📄 admin_file.asp

📁 做的一个毕业设计(学生档案管理系统)
💻 ASP
📖 第 1 页 / 共 3 页
字号:
<!--#include file="../conn.asp"-->
<!--#include file="../inc/inc.asp"-->
<!--#include file="inc/inc.asp"-->
<!--#include file="common/admin_File_inc.asp"-->
<%
HTMLother= script("admin_File_js","")
HTMLother= HTMLother & script("cert_date","../js")
res w3chead(HTMLother),1
Login_Judge
powerid=112
nowtit="学生档案"
Dim 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
Dim file_gx_i,file_jk_i,file_edit,file_i
action=che(request("action"))
id=che(request("id"))

If action="list" Then
	Ispower powerid & "1"
	Name = che(request("Name"))
	His = che(request("His"))
	Gender = che(request("Gender"))
	National = che(request("National"))
	ClassNo = che(request("ClassNo"))
	identityNo = che(request("identityNo"))
	Political = che(request("Political"))
	If name<>"" Then Sql_Condition=" and Name like '%"&Name&"%'"
	If His<>"" Then Sql_Condition=Sql_Condition&" and His like '%"&His&"%'"
	If Gender<>"" And IsNumeric(Gender) Then 
		If Int(Gender)>-1 And Int(Gender)<2 Then Sql_Condition=Sql_Condition&" and Gender="&Gender
	Else
		Gender=-1
	End If
	
	If National<>"" And IsNumeric(National) Then 
		If Int(National)>-1 And Int(National)<57 Then Sql_Condition=Sql_Condition&" and National="&National
	Else
		National=-1
	End If 
	If ClassNo<>"" Then Sql_Condition=Sql_Condition&" and ClassNo like '%"&ClassNo&"%'"
	If identityNo<>"" Then Sql_Condition=Sql_Condition&" and identityNo like '%"&identityNo&"%'"
	If Political<>"" And IsNumeric(Political) Then 
		If Int(Political)>-1 And Int(Political)<4 Then Sql_Condition=Sql_Condition&" and Political="&Political
	Else
		Political=-1
	End If
	restit nowtit,infotit(0)
	nowmenu
	%>


	<H6>切换查看: <a href="?action=list">全部</a> </H6>
<h5>
<ul><FORM METHOD=get ACTION="">
	<li>真实姓名: <INPUT TYPE="text" NAME="Name" value="<%=Name%>" class="put">
	<li>曾&nbsp;用&nbsp;名: <INPUT TYPE="text" NAME="His" value="<%=His%>" class="put">
	<li>学&nbsp;&nbsp;&nbsp;&nbsp;号: <INPUT TYPE="text" NAME="ClassNo" value="<%=ClassNo%>" class="put">
	<li>身份证号: <INPUT TYPE="text" NAME="identityNo" value="<%=identityNo%>" class="put">
	<li>性&nbsp;&nbsp;&nbsp;&nbsp;别: 
				<SELECT NAME="Gender">
					<OPTION VALUE="-1" <%If Gender=-1 Then response.write " selected "%>>请选择...</OPTION>
					<OPTION VALUE="0" <%If Gender=0 Then response.write " selected "%>>男</OPTION>
					<OPTION VALUE="1" <%If Gender=1 Then response.write " selected "%>>女</OPTION>
				</SELECT>
	<li>民&nbsp;&nbsp;&nbsp;&nbsp;族: 
				<SELECT NAME="National">
				<OPTION VALUE="-1" <%If National=-1 Then response.write " selected "%>>请选择...</OPTION>
				<%=sel_arr_National(National)%>
				</SELECT>
	<li>籍&nbsp;&nbsp;&nbsp;&nbsp;贯: 
				<SELECT NAME="Political">
				<OPTION VALUE="-1" <%If Political=-1 Then response.write " selected "%>>请选择...</OPTION>
				<%=sel_arr_Political(Political)%>
				</SELECT> <SPAN></SPAN>
	
	<li class="lefts">&nbsp;<INPUT TYPE="submit" value=" 点击查询 ">
</ul><INPUT TYPE="hidden" NAME="action" value="list"></FORM>
</h5>


	<table width="100%" cellspacing="0" cellpadding="0" class="info_tab2">
	<tr align="center"> 
		<th width="5%" style="text-align:center;text-indent: 4px;">选</th>
		<th width="15%">姓名</th>
		<th width="6%">性别</th>
		<th width="12%">民族</th>
		<th width="12%">籍贯</th>
		<th width="10%">政治面貌</th>
		<th width="15%">联系电话</th>
		
		<th width="5%">操作</th>
		<th> </th>
	</tr>
	
	<%
	const MaxPerPage=10
	sql="select id,Name,Gender,National,Political,Telephone,Birthplace from File_info "&_
		"where Name<>'' "&Sql_Condition&" order by id desc"
	strFileName="?action="&action&"&types="&types&"&keyword="&keyword
	colnum="9"
	formaction="?action=del"
	sqllist sql,colnum,strFileName,formaction 
	If outcom=True Then
	showContent
	showdelpages
	End If
%>
</TABLE>
<%
ElseIf action="add" Then
	Ispower powerid & "2"
	restit nowtit,infotit(1)
	nowmenu
	%>
<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> 
	<div class="main" id="main0"> 
<FORM METHOD=POST name="myform" ACTION="admin_File_save.asp" enctype="multipart/form-data">
<input type="hidden" name="action" value="stu">
<input type="hidden" name="id" value="0">
  <ul class="block"><li>
			<table width="98%" cellspacing="0" cellpadding="0" class="filetab">
			<tr>
		<td width="15%" align="center">姓&nbsp;&nbsp;&nbsp;&nbsp;名</td>
		<td colspan="2" width="40%"><input type="text" name="Name" size="20"></td>
		<td rowspan="5" width="25%"><img src="..\upload\default.gif" 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(action)%></td>
	</tr>
	<tr>
		<td align="center">曾&nbsp;用&nbsp;名</td>
		<td colspan="2"><input type="text" name="His" size="20"></td>
	</tr>
	<tr>
		<td align="center">性&nbsp;&nbsp;&nbsp;&nbsp;别</td>
		<td colspan="2"><label><INPUT TYPE="radio" NAME="Gender" value="1" style="border: 0;" checked>男 </label>   <label><INPUT TYPE="radio" NAME="Gender" value="2" style="border: 0;">女 </label></td>
	</tr>
	<tr>
		<td align="center">出生日期</td>
		<td colspan="2"><input type="text" name="birth" size="20" value="<%=year(date())%>-01-01" 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"></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"></td>
	</tr>
	<tr>
		<td align="center">入学学历</td>
		<td width="25%"><SELECT NAME="Entry"><%=sel_arr_Entry(0)%></SELECT></td>
		<td width="15%" align="center">政治面貌</td>
		<td><SELECT NAME="Political"><%=sel_arr_Political(0)%></SELECT></td>
	</tr>
	<tr>
		<td align="center">入学日期</td>
		<td><input type="text" name="Entry_Date" size="20" value="<%=year(date())%>-01-01" onclick="setday(this)"></td>
		<td align="center">加入组织日期</td>
		<td><input type="text" name="Political_date" size="20" value="<%=year(date())%>-01-01" onclick="setday(this)"></td>
	</tr>
	<tr>
		<td align="center">民&nbsp;&nbsp;&nbsp;&nbsp;族</td>
		<td><SELECT NAME="National"><%=sel_arr_National(0)%></SELECT></td>
		<td align="center">籍&nbsp;&nbsp;&nbsp;&nbsp;贯</td>
		<td><input type="text" name="Birthplace" size="20"></td>
	</tr>
	<tr>
		<td align="center">家庭住址</td>
		<td><input type="text" name="address" size="20"></td>
		<td> </td>
		<td> </td>
	</tr>
	<tr>
		<td align="center">联系电话</td>
		<td><input type="text" name="Telephone" size="20"></td>
		<td align="center">邮&nbsp;&nbsp;&nbsp;&nbsp;编</td>
		<td><input type="text" name="Zip" size="20"></td>
	</tr>

</table>

	</li></ul> 
  <ul><li>
		<table width="98%" cellspacing="0" cellpadding="0">
			<tr>
				<td width="80%">
				<h2>个人简况</h2>
					<table width="98%" cellspacing="1" cellpadding="0" class="info_tab" style="border-left: 1px solid #cccccc;">
					<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=1 To 4%>
					<tr align="center">
						<td><input type="text" name="file_jk_l0" class="file_input_info"
										onMouseOver="this.style.background='#E1F4EE';" 
										onMouseOut="this.style.background='#F9F9F9'"
										onkeydown="if(event.keyCode==13)event.keyCode=9" style="width:45%;" onclick="setday(this)">-
										<input type="text" name="file_jk_l1" class="file_input_info"
										onMouseOver="this.style.background='#E1F4EE';" 
										onMouseOut="this.style.background='#F9F9F9'"
										onkeydown="if(event.keyCode==13)event.keyCode=9" style="width:45%;" onclick="setday(this)"></td>
						<td><input type="text" name="file_jk_l2" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
						<td><input type="text" name="file_jk_l3" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
						<td><input type="text" name="file_jk_l4" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
					</tr>
					<%next%>
					</table>
					<h2>社会关系</h2>
					<table width="98%" cellspacing="1" cellpadding="0" class="info_tab" style="border-left: 1px solid #cccccc;">
					<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=1 To 4%>
					<tr align="center">
						<td><input type="text" name="file_gx_l0" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
						<td><input type="text" name="file_gx_l1" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
						<td><input type="text" name="file_gx_l2" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
						<td><input type="text" name="file_gx_l3" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
						<td><input type="text" name="file_gx_l4" class="file_input_info"
									onMouseOver="this.style.background='#E1F4EE';" 
									onMouseOut="this.style.background='#F9F9F9'"
									onkeydown="if(event.keyCode==13)event.keyCode=9"></td>
					</tr>
					<%next%>

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



	</li></ul> 
	<ul><li>
		<table width="98%" cellspacing="0" cellpadding="0">
			<tr>

⌨️ 快捷键说明

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