📄 workresume.asp
字号:
<%
dim EmpID,EmpName,OptID,flag,rid
EmpID=Request("Eid")
EmpName=Request("Ename")
OptID=Request("Oid")
rid=request.Form("txtSRID")
dim Conn,rsWorkResume,strSql,DbPath
set Conn=server.CreateObject("ADODB.CONNECTION")
DbPath = SERVER.MapPath("Database\HrManager.mdb")
Conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rsWorkResume=server.CreateObject("ADODB.RECORDSET")
flag=request.form("txtOpt")
if flag="" then
flag=0
else
flag=cint(flag)
end if
select case flag
case 1
dim jt,gt,sc,tm,tp,tn
jt=request.Form("txtJoinTime")
gt=request.Form("txtGradTime")
sc=request.Form("txtSchool")
tm=request.Form("txtMajor")
tp=request.Form("txtPosition")
tn=request.Form("txtNotes")
if jt<>"" then
strSql="select * from EmployeeWResumeTable where Employee_ID="&cint(EmpID)
rsWorkResume.Open strSql,Conn,3,2
' Response.Write rsBasicInfo.RecordCount request.form
rsWorkResume.addnew
rsWorkResume("Employee_ID")=EmpID
if jt<>"" then
rsWorkResume("Employee_BeginW")=jt
end if
if gt<>"" then
rsWorkResume("Employee_EndW")=gt
end if
if sc<>"" then
rsWorkResume("Employee_Unit")=sc
end if
if tm<>"" then
rsWorkResume("Employee_Depart")=tm
end if
if tp <>"" then
rsWorkResume("Employee_PositionW")=tp
end if
if tn<>"" then
rsWorkResume("Employee_NoteW")=tn
end if
rsWorkResume.Update
rsWorkResume.Close()
end if
case 2
jt=request.Form("txtJoinTime")
gt=request.Form("txtGradTime")
sc=request.Form("txtSchool")
tm=request.Form("txtMajor")
tp=request.Form("txtPosition")
tn=request.Form("txtNotes")
if jt<>"" then
'response.Write(rid)
strSql="select * from EmployeeWResumeTable where SResume_ID="&cint(rid)
rsWorkResume.Open strSql,Conn,3,2
' Response.Write rsBasicInfo.RecordCount request.form
rsWorkResume("Employee_ID")=EmpID
if jt<>"" then
rsWorkResume("Employee_BeginW")=jt
end if
if gt<>"" then
rsWorkResume("Employee_EndW")=gt
end if
if sc<>"" then
rsWorkResume("Employee_Unit")=sc
end if
if tm<>"" then
rsWorkResume("Employee_Depart")=tm
end if
if tp <>"" then
rsWorkResume("Employee_PositionW")=tp
end if
if tn<>"" then
rsWorkResume("Employee_NoteW")=tn
end if
rsWorkResume.Update
rsWorkResume.Close()
end if
case 3
strSql="select * from EmployeeWResumeTable where SResume_ID="&cint(rid)
rsWorkResume.Open strSql,Conn,3,2
rsWorkResume.Delete()
rsWorkResume.Update()
rsWorkResume.close()
case else
end select
set rsWorkResume=server.CreateObject("ADODB.RECORDSET")
strSql="select * from EmployeeWResumeTable where Employee_ID="&cint(EmpID)
rsWorkResume.Open strSql,Conn,3,1
' Response.Write rsWorkResume.RecordCount
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="headfiles/text.css" rel="stylesheet" type="text/css">
<title></title>
<SCRIPT language=JavaScript>
<!--
<!--
if (navigator.appName.indexOf("Internet Explorer") != -1)
document.onmousedown = noSourceExplorer;
function noSourceExplorer(){if (event.button == 2 | event.button == 3)
{
//alert("版权所有,严禁拷贝!");
}}
// -->
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
<!--
function NumChange(){
frmBasicInfo.sltEmpName.selectedIndex=frmBasicInfo.sltEmpNum.selectedIndex;
}
function NameChange(){
frmBasicInfo.sltEmpNum.selectedIndex=frmBasicInfo.sltEmpName.selectedIndex;
}
function OpenNew(Url){
window.navigate (Url+"?Eid="+frmWorkResume.txtEmpID.value);
}
//-->
</SCRIPT>
</head>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/new1.gif','images/del1.gif')">
<div align="center">
<form id="frmWorkResume" name="frmWorkResume" action="WorkResume.asp?eid=<%=EmpID%>" method="post">
<table width="600" height="360" background="images\bg.gif" class="title3" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("BasicInfo.asp");'>基本信息</a></td>
<td rowspan="11" align="center">
<table width=520 height="350" border="0" cellpadding="0" cellspacing="0">
<tr><td align="center" style="BORDER-RIGHT: 1px outset; BORDER-TOP: 1px outset; BORDER-LEFT: 1px outset; BORDER-BOTTOM: 1px outset">
<table width="510" height="340" border="1" cellpadding="0" cellspacing="0" bordercolor="#ECE9D8" bordercolorlight="#dddddd" bordercolordark="#dddddd" background="images/bg.gif" class="title2">
<tr><td height="25" colspan="3" align="center">职工号: <input type="text" id="txtEmpID" name="txtEmpID" style="width:150px" value="<%=EmpID%>" disabled></td><td colspan="5">姓名:
<input type="text" id="txtEmpName" name="txtEmpName" style="width:100px" disabled></td>
</tr>
<tr><td height="25" width="13%" align="center">进入时间</td>
<td width="13%" align="center">离职时间</td>
<td width="24%" align="center">单位名称</td>
<td width="13%" align="center">部门</td>
<td width="13%" align="center">职务</td>
<td width="14%" align="center">备注</td><td width="5%" align="center">改</td><td width="5%" align="center">删</td></tr>
<%'src='images\del2.gif'
dim i,j,k
k=0
i=1
while not rsWorkResume.BOF and not rsWorkResume.EOF
Response.Write chr(13)&chr(10)&"<tr><td height='25'><input type='text' style='width:100%' name=txtJoinTime value='"&rsWorkResume("Employee_BeginW")&"' disabled></td><td><input type='text' style='width:100%' name=txtGradTime value='"&rsWorkResume("Employee_EndW")&"' disabled></td><td><input type='text' style='width:100%' name=txtSchool value='"&rsWorkResume("Employee_Unit")&"' disabled></td><td><input type='text' style='width:100%' name=txtMajor value='"&rsWorkResume("Employee_Depart")&"' disabled></td><td><input type='text' style='width:100%' name=txtPosition value='"&rsWorkResume("Employee_PositionW")&"' disabled></td><td><input type='text' style='width:100%' name=txtNotes value='"&rsWorkResume("Employee_NoteW")&"' disabled></td><td><img src='images\modify2.gif' alt='修改' onMouseOut="&chr(34)&"this.className='normal'"&chr(34)&" onMouseOver="&chr(34)&"this.className='hand'"&chr(34)&" onclick='ResumeModify("&i&","&rsWorkResume("SResume_ID")&")'></td><td><img src='images\del2.gif' alt='修改' onMouseOut="&chr(34)&"this.className='normal'"&chr(34)&" onMouseOver="&chr(34)&"this.className='hand'"&chr(34)&" onclick='del("&rsWorkResume("SResume_ID")&")'></td></tr>"
rsWorkResume.MoveNext
i=i+1
wend
Response.Write chr(13)&chr(10)&"<tr><td height='25'><input type='text' style='width:100%' name=txtJoinTime disabled></td><td><input type='text' style='width:100%' name=txtGradTime disabled></td><td><input type='text' style='width:100%' name=txtSchool disabled></td><td><input type='text' style='width:100%' name=txtMajor disabled></td><td><input type='text' style='width:100%' name=txtPosition disabled></td><td><input type='text' style='width:100%' name=txtNotes disabled></td><td colspan='2' align='center'><img src='images\new2.gif' alt='添加' onMouseOut="&chr(34)&"this.className='normal'"&chr(34)&" onMouseOver="&chr(34)&"this.className='hand'"&chr(34)&" onclick='ResumeModify("&i&","&k&")'></td></tr>"
%>
<script language=javascript>
<!--
function ResumeModify(i,id){
var j;
for(j=0;j<=<%=i-1%>;j++){
frmWorkResume.txtJoinTime(j).disabled=true;
frmWorkResume.txtGradTime(j).disabled=true;
frmWorkResume.txtSchool(j).disabled=true;
frmWorkResume.txtMajor(j).disabled=true;
frmWorkResume.txtPosition(j).disabled=true;
frmWorkResume.txtNotes(j).disabled=true;
}
frmWorkResume.txtJoinTime(i-1).disabled=false;
frmWorkResume.txtGradTime(i-1).disabled=false;
frmWorkResume.txtSchool(i-1).disabled=false;
frmWorkResume.txtMajor(i-1).disabled=false;
frmWorkResume.txtPosition(i-1).disabled=false;
frmWorkResume.txtNotes(i-1).disabled=false;
if(i==<%=i%>){
frmWorkResume.txtJoinTime(i-1).value=frmWorkResume.txtGradTime(i-2).value;
}
if(id==0){
frmWorkResume.txtOpt.value=1;
}else {
frmWorkResume.txtSRID.value=id;
frmWorkResume.txtOpt.value=2;
}
}
function del(id){ var msg;
msg=confirm("确定要删除吗?");
if (msg==true){
frmWorkResume.txtOpt.value=3;
frmWorkResume.txtSRID.value=id;
frmWorkResume.submit();}
else{
return false;
}
}
function employeeSave(){
var msg;
msg=confirm("您将操作的信息进行保存!\n\n确实要保存吗?")
if(msg==false){
return false;
}
// alert (isNumeric(frmWorkInfo.txtComeTimeY.value));
frmWorkResume.submit();
}
//-->
</script>
<%
for j=i to 8
%>
<tr><td height="25"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<%
next
%>
<tr>
<td height="30" align="center" colspan="8"><a onclick="employeeSave();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/save1.gif',1);this.className='hand1'"><img src="images/save.gif" name="Image3" width="60" height="25" border="1"></a>
<input type="text" id="txtOpt" name="txtOpt" style="width:25px;visibility:hidden" value="<%=OptID%>"><!---->
<input type="text" id="txtSRID" name="txtSRID" style="width:25px;visibility:hidden" ><!---->
<a onclick="Initial();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image4','','images/undo1.gif',1);this.className='hand1'"><img src="images/undo.gif" name="Image4" width="60" height="25" border="1"></a></td>
</tr>
</table>
</td></tr>
</table>
</td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("WorkInfo.asp");'>工作信息</a></td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("StudyResume.asp");'>学习简历</a></td>
</tr>
<tr>
<td align='right' height='30' background='images\item1.gif'>工作简历</td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("FamilyMember.asp");'>家庭成员</a></td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("Relavation.asp");'>社会关系</a></td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("Training.asp");'>培训情况</a></td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("RewordPunish.asp");'>奖惩情况</a></td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onmouseover="this.className='red'" onmouseout="this.className='detail'" onClick='OpenNew("Research.asp");'>科研情况</a></td>
</tr>
<tr>
<td align='right' height='30' bgcolor='#62b0ff'> </td>
</tr>
<tr>
<td align='right' height='60' bgcolor='#62b0ff'> </td>
</tr>
</table>
</form>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -