📄 familymember.asp
字号:
<%
dim EmpID,EmpName,OptID,flag,rid
EmpID=Request("Eid")
EmpName=Request("Ename")
OptID=Request("Oid")
rid=request.Form("txtSRID")
dim Conn,rsFamilyMember,strSql,DbPath
set Conn=server.CreateObject("ADODB.CONNECTION")
DbPath = SERVER.MapPath("Database\HrManager.mdb")
Conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rsFamilyMember=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")
tn=request.Form("txtNotes")
if jt<>"" then
strSql="select * from EmployeeHomeMemberTable where Employee_ID="&cint(EmpID)
rsFamilyMember.Open strSql,Conn,3,2
' Response.Write rsBasicInfo.RecordCount request.form
rsFamilyMember.addnew
rsFamilyMember("Employee_ID")=EmpID
if jt<>"" then
rsFamilyMember("HomeMember_Name")=jt
end if
if gt<>"" then
rsFamilyMember("HomeMember_Relation")=gt
end if
if sc<>"" then
rsFamilyMember("HomeMember_Unit")=sc
end if
if tm<>"" then
rsFamilyMember("HomeMember_Tel")=tm
end if
if tn<>"" then
rsFamilyMember("HomeMember_Note")=tn
end if
rsFamilyMember.Update
rsFamilyMember.Close()
end if
case 2
jt=request.Form("txtJoinTime")
gt=request.Form("txtGradTime")
sc=request.Form("txtSchool")
tm=request.Form("txtMajor")
tn=request.Form("txtNotes")
if jt<>"" then
strSql="select * from EmployeeHomeMemberTable where SResume_ID="&cint(rid)
rsFamilyMember.Open strSql,Conn,3,2
' Response.Write rsBasicInfo.RecordCount request.form
rsFamilyMember("Employee_ID")=EmpID
if jt<>"" then
rsFamilyMember("HomeMember_Name")=jt
end if
if gt<>"" then
rsFamilyMember("HomeMember_Relation")=gt
end if
if sc<>"" then
rsFamilyMember("HomeMember_Unit")=sc
end if
if tm<>"" then
rsFamilyMember("HomeMember_Tel")=tm
end if
if tn<>"" then
rsFamilyMember("HomeMember_Note")=tn
end if
rsFamilyMember.Update
rsFamilyMember.Close()
end if
case 3
strSql="select * from EmployeeHomeMemberTable where SResume_ID="&cint(rid)
rsFamilyMember.Open strSql,Conn,3,2
rsFamilyMember.Delete()
rsFamilyMember.Update()
rsFamilyMember.close()
case else
end select
set rsFamilyMember=server.CreateObject("ADODB.RECORDSET")
strSql="select * from EmployeeHomeMemberTableView where Employee_ID="&cint(EmpID)
rsFamilyMember.Open strSql,Conn,3,1
' Response.Write rsFamilyMember.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="+frmFamilyMember.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="frmFamilyMember" name="frmFamilyMember" action="FamilyMember.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="503" 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="4">姓名:
<input type="text" id="txtEmpName" name="txtEmpName" style="width:100px" disabled></td>
</tr>
<tr>
<td height="20" width="14%" align="center">姓名</td>
<td width="15%" align="center">关系</td>
<td width="24%" align="center">工作单位</td>
<td width="14%" align="center">通讯电话</td>
<td width="13%" align="center">备注</td>
<td width="7%" align="center">改</td><td width="7%" align="center">删</td></tr>
<%'src='images\del2.gif'
dim i,j,k
k=0
i=1
while not rsFamilyMember.BOF and not rsFamilyMember.EOF
Response.Write chr(13)&chr(10)&"<tr><td height='25'><input type='text' style='width:100%' name=txtJoinTime value='"&rsFamilyMember("HomeMember_Name")&"' disabled></td><td><input type='text' style='width:100%' name=txtGradTime value='"&rsFamilyMember("HomeMember_Relation")&"' disabled></td><td><input type='text' style='width:100%' name=txtSchool value='"&rsFamilyMember("HomeMember_Unit")&"' disabled></td><td><input type='text' style='width:100%' name=txtMajor value='"&rsFamilyMember("HomeMember_Tel")&"' disabled></td><td><input type='text' style='width:100%' name=txtNotes value='"&rsFamilyMember("HomeMember_Note")&"' 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&","&rsFamilyMember("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("&rsFamilyMember("SResume_ID")&")'></td></tr>"
rsFamilyMember.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=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++){
frmFamilyMember.txtJoinTime(j).disabled=true;
frmFamilyMember.txtGradTime(j).disabled=true;
frmFamilyMember.txtSchool(j).disabled=true;
frmFamilyMember.txtMajor(j).disabled=true;
frmFamilyMember.txtNotes(j).disabled=true;
}
frmFamilyMember.txtJoinTime(i-1).disabled=false;
frmFamilyMember.txtGradTime(i-1).disabled=false;
frmFamilyMember.txtSchool(i-1).disabled=false;
frmFamilyMember.txtMajor(i-1).disabled=false;
frmFamilyMember.txtNotes(i-1).disabled=false;
if(id==0){
frmFamilyMember.txtOpt.value=1;
}else {
frmFamilyMember.txtSRID.value=id;
frmFamilyMember.txtOpt.value=2;
}
}
function del(id){ var msg;
msg=confirm("确定要删除吗?");
if (msg==true){
frmFamilyMember.txtOpt.value=3;
frmFamilyMember.txtSRID.value=id;
frmFamilyMember.submit();}
else{
return false;
}
}
function employeeSave(){
var msg;
msg=confirm("您将操作的信息进行保存!\n\n确实要保存吗?")
if(msg==false){
return false;
}
// alert (isNumeric(frmWorkInfo.txtComeTimeY.value));
frmFamilyMember.submit();
}
//-->
</script>
<%
for j=i to 8
%>
<tr><td height="25"></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<%
next
%>
<tr>
<td height="30" align="center" colspan="7"><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' bgcolor='#62b0ff' background='images\item2.gif'><a class='detail' onMouseOver="this.className='red'" onMouseOut="this.className='detail'" onClick='OpenNew("WorkResume.asp");'>工作简历</a>
</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("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>
<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>
</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 + -