📄 empmain_pay_save_process.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/EmpMain.asp" -->
<!--#include file="EmpMain_CheckRight.asp"-->
<%call fnCheckRight("paylist","2")%>
<%
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_EmpMain_STRING
MM_editQuery = "delete from gzTongji where format$([createDate],'mmmm yyyy') = format$(now(),'mmmm yyyy') "
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
%>
<%
for i = 1 to request.Form("EmpID").count
EmpID = request.form("EmpID").item(i)
EmpName = request.form("EmpName").item(i)
if trim(EmpName) = "" then empname = " "
jiben = request.form("jiben").item(i)
jiangjin= request.form("jiangjin").item(i)
koushui = request.form("koushui").item(i)
sanjin = request.form("sanjin").item(i)
gongjijin = request.form("gongjijin").item(i)
kouxin= request.form("kouxin").item(i)
qita = request.form("qita").item(i)
totalCount = request.form("totalCount").item(i)
%>
<%
MM_editQuery = "insert into gzTongji (EmpID,EmpName,jiben,jiangjin,koushui,sanjin,gongjijin,kouxin,qita,totalCount) values " &_
"('"&EmpID&"','"&EmpName&"','"&jiben&"','"&jiangjin&"','"&koushui&"','"&sanjin&"','"&gongjijin&"','"&kouxin&"','"&qita&"','"&totalCount&"')"
'response.Write(MM_editQuery)
'response.end
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_pay_list.asp"
</script>
</head>
<body>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -