📄 waijimodify.asp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
<%
Sub SchoolDisp()
dim conn, sql,Res
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../dbf/school.mdb")
sql="select * from school"
set Res=server.createobject("adodb.recordset")
Res.open sql,conn,1,3
response.write " <option value=" & session("MySchool") & "> " & SchoolName(session("MySchool"))& " </option>"
while not Res.EOF
response.write "<option value=" & Res("sId") & ">" & Res("sName") & "</option>"
Res.movenext
wend
Res.close
conn.close
End Sub
%>
<body bgColor=#ffffff leftMargin=0 background="" topMargin=0>
<table cellSpacing=0 cellPadding=0 width="98%" align=center border=0>
<%
dim eId
eId=Request("id")
dim conn,connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../dbf/teacher.mdb")
conn.Open connstr
dim sql,Res
sql="select * from employee1 where (eId='"&eId&"')"
set Res=server.createobject("adodb.recordset")
Res.open sql,conn,1,1
%>
<script Language="JavaScript">
function DoSubmit(){
if(document.main.eId.value=="")
{
alert("请输入教工ID")
document.main.eId.focus()
}
else if(document.main.eName.value=="")
{
alert("请输入教工姓名")
document.main.eName.focus()
}
else
document.main.submit()
}
</script>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
function window_onafterprint() {
}
//-->
</SCRIPT>
<!-- #include virtual="/admin/include/title.html"-->
<table cellSpacing=1 cellPadding=1 width="98%" align=center border=0>
<tr>
<td vAlign=top align=middle width="20%">
</form>
<table borderColor=dodgerblue width="70%" align=center border=2
>
<TBODY>
<TR>
<td></TD></TR></TD>
<TR>
<td vAlign=top align=left>
<form action=waijisavenewstea2.asp method=POST id=form1 name=main style="BACKGROUND-COLOR: white">
<table cellSpacing=1 cellPadding=1 width="95%" border=0>
<tr>
<td>
<table cellSpacing=1 cellPadding=1 width="85%" align=center
border=0>
<tr>
<td><strong>员工详细资料<font color=blue
>:
</FONT></strong></TD></TR></TABLE></TD></TR>
<tr>
<td>
<table cellSpacing=1 cellPadding=1 width="85%" align=center
border=1>
<TR>
<td width="165"><FONT face=宋体
designtimesp="12680" mstheme><font size=2
><font color=sandybrown
>*</FONT>教工ID：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12684" mstheme>
<input id=text1
style="WIDTH: 145; HEIGHT: 22" size=18 name=eId value="<%=Res("eId")%>"
><font size=2
></FONT></FONT></TD></TR>
<tr>
<td width="165"><FONT face=宋体
designtimesp="12671" mstheme><font size=2
><font color=sandybrown
>*</FONT>姓名：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12675" mstheme>
<input id=text1
style="WIDTH: 145; HEIGHT: 22" size=18 name=eName value="<%=Res("eName")%>"
><font size=2
></FONT></FONT></TD></TR>
<tr>
<td width="165"><FONT face=宋体
designtimesp="12671" mstheme><font size=2
><font color=sandybrown
></FONT>英文名：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12675" mstheme>
<input id=text1
style="WIDTH: 145; HEIGHT: 22" size=18 name=eEnglishname value="<%=Res("ecName")%>"
><font size=2
></FONT></FONT></TD></TR>
<tr>
<td width="30%"><FONT face=宋体
designtimesp="12690" mstheme><font size=2
><font color=sandybrown
></FONT>性别：</FONT></FONT></TD>
<td width="68%"><%if Res("eGender") then %><input type="radio" value="1" checked name="eGender">男
<input type="radio" name="eGender" value="0">女<%else%>
<input type="radio" value="1" name="eGender">男
<input type="radio" checked name="eGender" value="0">女<% end if%></TD></TR>
<tr>
<td width="233"><font face="宋体" size="2">出生</font><font size=2 face="宋体" designtimesp="12817" mstheme
>日期：</FONT></TD>
<td><FONT face=宋体
designtimesp="12820" mstheme><input id=text1 style="WIDTH: 140; HEIGHT: 22" size=18 name=eBorn value="<%=Res("eBorn")%>"><font size=2 color="#FF0000"
>日期格式(0000-00-00)</FONT></FONT></TD></TR>
<tr>
<td width="165"><FONT face=宋体
designtimesp="12727" mstheme><font size=2
>出生地：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12730" mstheme><input style="WIDTH: 140px"
name=eAddBorn value=<%=Res("eAddBorn")%>><font size=2
></FONT></FONT></TD></TR>
<tr>
<td width="165"><FONT face=宋体
designtimesp="12762" mstheme><font size=2
><font color=sandybrown
></FONT>学历：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12766" mstheme>
<select id=select1
style="WIDTH: 140; height:19" name=eEducate size="1">
<OPTION value="<%=Res("eEducate")%>" designtimesp="19388"
><%if Res("eEducate")=2 then%>初中
<%elseif Res("eEducate")=3 then%>高中
<%elseif Res("eEducate")=4 then%>技校/中专
<%elseif Res("eEducate")=5 then%>大专
<%elseif Res("eEducate")=6 then%>本科
<%elseif Res("eEducate")=7 then%>硕士
<%elseif Res("eEducate")=8 then%>博士
<%end if%>
<OPTION value=2 designtimesp="19388"
>初中
<option value=3 designtimesp="19388"
>高中
<OPTION value=4
designtimesp="19390"
>技校/中专</OPTION>
<OPTION value=5
designtimesp="19391"
>大专</OPTION>
<OPTION value=6
designtimesp="19392"
>本科</OPTION>
<OPTION value=7
designtimesp="19393"
>硕士</OPTION>
<OPTION value=8
designtimesp="19394"
>博士</OPTION></SELECT><font size=2
></FONT></FONT></TD></TR>
<tr>
<td width="165"><FONT face=宋体
designtimesp="12809" mstheme><font size=2
>专业：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12812" mstheme><input style="WIDTH: 140px"
name=eSpec value="<%=Res("eSpec")%>"><font size=2
></FONT></FONT></TD></TR>
<tr>
<td width="165"><FONT face=宋体
designtimesp="12779" mstheme><font size=2
><font color=sandybrown
></FONT>婚姻状态：</FONT></FONT></TD>
<td><FONT face=宋体
designtimesp="12783" mstheme>
<select id=select1
style="WIDTH: 140px" name=eMarriage size="1"
>
<OPTION value="<%=Res("eMarriage")%>"
designtimesp="19405" >
<%if Res("eMarriage")=0 then%>单身
<%elseif Res("eMarriage")=1 then%>已婚
<%elseif Res("eMarriage")=2 then%>离异
<%elseif Res("eMarriage")=3 then%>丧偶
<%end if%>
<OPTION value=0
designtimesp="19405" >单身
<option value=1 designtimesp="19407"
>已婚
<OPTION
value=2 designtimesp="19406"
>离异
<OPTION value=3
designtimesp="19408" >丧偶
</SELECT><font
size=2>
</FONT></FONT></TD></TR>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -