📄 empmain_marr_edit_process.asp

📁 欢迎大家分享本系统为bs架构的asp+access版本。<br>包含：员工信息

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/EmpMain.asp" -->
<!--#include file="EmpMain_CheckRight.asp"-->
<%
EmpID = request.form("EmpID")
MarrType = request.form("MarrType")
MateName = request.form("MateName")
MateComp = request.form("MateComp")
MateTel = request.form("MateTel")
%>
<%
 Set MM_editCmd = Server.CreateObject("ADODB.Command")
 MM_editCmd.ActiveConnection = MM_EmpMain_STRING
 %>
 <%
 if request.Form("ProcessType") = "insert" then
 MM_editQuery = "insert into marriage (EmpID,MarrType,MateName,MateComp,MateTel) values ('"&EmpID&"','"&MarrType&"','"&MateName&"','"&MateComp&"','"&MateTel&"')"
 else
 MM_editQuery = "update  marriage  set MarrType='"&MarrType&"',MateName='"&MateName&"',MateComp='"&MateComp&"',MateTel='"&MateTel&"' where EmpID = "&EmpID&"" 
 end if
%>
<%
 MM_editCmd.CommandText = MM_editQuery
 MM_editCmd.Execute
 call fnCreateLog("编辑婚姻状况")			 
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<script>
alert("修改资料成功!")
window.location="EmpMain_Marr_Edit.asp?ID=<%=EmpID%>"
</script>
</head>

<body>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -