📄 empmain_pay_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")
 Set rs = Server.CreateObject("ADODB.RecordSet")
 MM_editCmd.ActiveConnection = MM_EmpMain_STRING
 %>
 <%
 for i = 2 to request.Form("RaisesDate").count 
 RaisesDate = request.form("RaisesDate").item(i)
 if RaisesDate  = "" then RaisesDate = "NULL" else RaisesDate = "'"&request.form("RaisesDate").item(i)&"'"
 RaisesRreson = request.form("RaisesRreson").item(i)
 RaisesFrom= request.form("RaisesFrom").item(i)
 RaisesTo = request.form("RaisesTo").item(i)
 RaisesDegree = request.form("RaisesDegree").item(i)
 %>
 <%
 MM_editQuery = "insert into RaisesHistory (EmpID,RaisesDate,RaisesRreson,RaisesFrom,RaisesTo,RaisesDegree) values ('"&EmpID&"',"&RaisesDate&",'"&RaisesRreson&"','"&RaisesFrom&"','"&RaisesTo&"','"&RaisesDegree&"')"
 MM_editCmd.CommandText = MM_editQuery
 MM_editCmd.Execute			 
%>
<%next%>
<%
 '====================取得更新后的最新值=======================
 MM_editQuery = "SELECT top 1 * FROM RaisesHistory where EmpID = "&EmpID&" order by RaisesDate desc"
 MM_editCmd.CommandText = MM_editQuery
 rs = MM_editCmd.Execute
 
 MM_editQuery = "update payset set jiben = '"&rs("RaisesTo")&"',degree = '"&rs("RaisesDegree")&"'  where EmpID = "&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_pay_disp.asp?ID=<%=EmpID%>"
</script>
</head>

<body>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -