📄 empmain_userright_process.asp

📁 欢迎大家分享本系统为bs架构的asp+access版本。<br>包含：员工信息

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/EmpMain.asp" -->
<!--#include file="asp_lib/md5.asp" -->
<!--#include file="EmpMain_CheckRight.asp"-->
<%
UserID = request.form("UserID")
%>

<%
 Set MM_editCmd = Server.CreateObject("ADODB.Command")
 MM_editCmd.ActiveConnection = MM_EmpMain_STRING
 %>
 
 <%
 UserName = request.form("UserName")
 Password = md5(request.form("Password"))
 payList= request.form("payList")
 HolList = request.form("HolList")
 EmpList = request.form("EmpList")
 overview = request.form("overview")
 General = request.form("General")
 MarrInfo = request.form("MarrInfo")
 EduInfo = request.form("EduInfo")
 EvenWork = request.form("EvenWork")
 Family = request.form("Family")
 Work = request.form("Work")
 HpInfo = request.form("HpInfo")
 HolInfo = request.form("HolInfo")
 PayInfo = request.form("PayInfo")
 UserID = request.form("UserID")
 %>
 <%
 if trim(UserID) = "" then
 MM_editQuery = "insert into UserRight (UserName,password,payList,HolList,EmpList,overview,GeneralInfo,MarrInfo,EduInfo,EvenWork,Family,Work,HpInfo,HolInfo,PayInfo)" &_
                " values ('"&UserName&"','"&password&"','"&payList&"','"&HolList&"','"&EmpList&"','"&overview&"','"&General&"','"&MarrInfo&"','"&EduInfo&"','"&EvenWork&"','"&Family&"','"&Work&"','"&HpInfo&"','"&HolInfo&"','"&PayInfo&"')"
 else
 MM_editQuery = "Update UserRight set " &_
                     "payList = '"& payList  &"',"  &_
                     "HolList = '"& HolList  &"',"  &_
                     "EmpList = '"& EmpList  &"',"  &_
                     "overview= '"& overview &"',"  &_
					 "Generalinfo= '"& General &"',"  &_
					 "MarrInfo= '"& MarrInfo &"',"  &_
					 "EduInfo= '"& EduInfo &"',"  &_
					 "EvenWork= '"& EvenWork &"',"  &_
					 "Family= '"& Family &"',"  &_
					 "Work= '"& Work &"',"  &_
					 "HpInfo= '"& HpInfo &"',"  &_
					 "HolInfo= '"& HolInfo &"',"  &_
					 "PayInfo= '"& PayInfo &"'"  &_
					 "   where id=" & UserID &""
					 isEdit = "1"
 end if
 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_UserRight.asp<%if isEdit = "1" then %>?UserID=<%=UserId%><%end if%>" 
</script>
</head>

<body>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -