📄 empmain_hol_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("HDTo").count 
 HDType= request.form("HDType").item(i)
 HDFrom = request.form("HDFrom").item(i)
if HDFrom  = "" then HDFrom = "NULL" else HDFrom = "'"&request.form("HDFrom").item(i)&"'"
 HDTo = request.form("HDTo").item(i)
 if HDTo  = "" then HDTo = "NULL" else HDTo = "'"&request.form("HDTo").item(i)&"'"
 HDDayCount= request.form("HDDayCount").item(i)
 if HDDayCount  = "" then HDDayCount = "0" 
 HDYearHolLeave = request.form("HDYearHolLeave").item(i)
 if HDYearHolLeave  = "" then HDYearHolLeave = "0" 
 HDNoPayCount = request.form("HDNoPayCount").item(i)
if HDNoPayCount  = "" then HDNoPayCount = "0" 
 %>
 <%
 MM_editQuery = "insert into holiday (EmpID,HDType,HDFrom,HDTo,HDDayCount,HDYearHolLeave,HDNoPayCount) values ('"& EmpID &"','"& HDType &"',"& HDFrom &","& HDTo &",'"& HDDayCount &"','"& HDYearHolLeave &"','"& HDNoPayCount &"')"
 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_hol_disp.asp?ID=<%=EmpID%>"
</script>
</head>

<body>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -