📄 empmain_work_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("DMDep").count 
 DMStartDate = request.form("DMStartDate").item(i)
 if DMStartDate  = "" then DMStartDate = "NULL" else DMStartDate = "'"&request.form("DMStartDate").item(i)&"'"
 DMEndDate = request.form("DMEndDate").item(i)
 if DMEndDate  = "" then DMEndDate = "NULL" else DMEndDate = "'"&request.form("DMEndDate").item(i)&"'"
 DMDep= request.form("DMDep").item(i)
 DMTitle = request.form("DMTitle").item(i)
 %>
 <%
 MM_editQuery = "insert into WorkDynamic (EmpID,DMStartDate,DMEndDate,DMDep,DMTitle) values ('"&EmpID&"',"&DMStartDate&","&DMEndDate&",'"&DMDep&"','"&DMTitle&"')"
 MM_editCmd.CommandText = MM_editQuery
 MM_editCmd.Execute			 
%>
<%next%>
<%
 '====================取得更新后的最新值=======================
 MM_editQuery = "SELECT top 1 * FROM WorkDynamic where EmpID = "&EmpID&" order by DMStartDate desc"
 MM_editCmd.CommandText = MM_editQuery
 rs = MM_editCmd.Execute
 
 MM_editQuery = "update EmpGeneralInfo set EmpTitle = '"&rs("DMTitle")&"',EmpHireDep = '"&rs("DMDep")&"'  where ID = "&EmpID&"" 
 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_work_disp.asp?ID=<%=EmpID%>"
</script>
</head>

<body>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -