📄 empmain_userright_process.asp

📁 好用的管理,代码程序好用的管理,代码程序

💻 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")
 shenf=request.form("shenf")
 userright=request.form("user_right")
 yes="true"
 UserID = request.form("UserID")
 %>
 <%
 if trim(UserID) = "" then
 MM_editQuery = "insert into T_User (F_UserName,F_UserPass,F_ClientInformation,F_TrackRecord,F_AddStaff,F_ConsignorRecord,F_IsPass,F_Region,F_Authority)" &_
                " values ('"&UserName&"','"&password&"','"&payList&"','"&HolList&"','"&EmpList&"','"&overview&"',"&yes&",'"&shenf&"',"&userright&")"
 else
 if trim(request.form("Password"))="" then
 MM_editQuery = "Update T_User set " &_
                      "F_UserName= '"&UserName  &"',"  &_
                     "F_ClientInformation= '"& payList  &"',"  &_
                     "F_TrackRecord= '"& HolList  &"',"  &_
                     "F_AddStaff= '"& EmpList  &"',"  &_
					 "F_ConsignorRecord= '"& overview  &"',"  &_
					 "F_IsPass= "&yes&","  &_                   
					 "F_Region= '"& shenf &"',"  &_
					  "F_Authority= '"& userright &"'"  &_
					 "   where F_Id=" & UserID &""
					 isEdit = "1"
					 else
					 
					  MM_editQuery = "Update T_User set " &_
                     "F_UserName= '"&UserName  &"',"  &_
					 "F_ClientInformation= '"& payList  &"',"  &_
                     "F_TrackRecord= '"& HolList  &"',"  &_
                     "F_AddStaff= '"& EmpList  &"',"  &_
					 "F_ConsignorRecord= '"& overview  &"',"  &_
					  "F_UserPass= '"& password  &"',"  &_
					 "F_IsPass= "&yes&","  &_                   
					 "F_Region= '"& shenf &"',"  &_
					  "F_Authority= '"& userright &"'"  &_
					 "   where F_Id=" & UserID &""
					 isEdit = "1"
		end if
 end if
 MM_editCmd.CommandText = MM_editQuery
 MM_editCmd.Execute
			 
%>

<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 + -