📄 empmain_family_addnew_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")
%>

<%
 Set MM_editCmd = Server.CreateObject("ADODB.Command")
 MM_editCmd.ActiveConnection = MM_EmpMain_STRING
 %>
 <%
 for i = 2 to request.Form("HMMenName").count 
 HMRelation = request.form("HMRelation").item(i)
 HMMenName = request.form("HMMenName").item(i)
 HMMenBirthday= request.form("HMMenBirthday").item(i)
 if HMMenBirthday  = "" then HMMenBirthday = "NULL" else HMMenBirthday = "'"&request.form("HMMenBirthday").item(i)&"'"
 HMMenComp = request.form("HMMenComp").item(i)
 HMAddress = request.form("HMAddress").item(i)
 HMTel = request.form("HMTel").item(i)
 %>
 <%
 MM_editQuery = "insert into homeInfo (EmpID,HMRelation,HMMemName,HMMemBirthday,HMMemComp,HMAddress,HMTel) values ('"&EmpID&"','"&HMRelation&"','"&HMMenName&"',"&HMMenBirthday&",'"&HMMenComp&"','"&HMAddress&"','"&HMTel&"')"
 MM_editCmd.CommandText = MM_editQuery
 MM_editCmd.Execute			 
%>
<%next%>
<% call fnCreateLog("添加家庭成员")%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<script>
alert("新增资料成功!")
window.location="EmpMain_family_disp.asp?ID=<%=EmpID%>"
</script>
</head>

<body>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -