📄 addauthorized1.asp

📁 应用程序利用ＡＳＰ做的一个可以实现登陆

💻 ASP

字号:

<!--#include file="conn.asp"-->
<!--#include file="../getlevel.asp"-->
<HTML>
   <HEAD>     
     <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.text {
	font-family: "宋体";
	font-size: 12px;
	color: #ffffff;
}
-->
</style>
</head>	  
<body bgcolor="#567D30">
  <% '取得表单数据
   rauthorized=request.form("authorized")
   rnownum=request.form("nownum")
   rsort=request.form("sort")
   
 %>
   
  <%
 
     set rs1 = server.createobject("adodb.recordset")
        sql2 = "select count(*) from mp_authorized where level1='"&level1&"' and level2='"&level2&"' and level3='"&level3&"' and level4='"&level4&"' and sort='干部'" 
	 'response.write(sql2)
	'response.end()
	rs1.open sql2,conn, 1,1
	 
	 if rs1(0)<>0 and rsort="干部" then
     response.write "<script language='javascript'>" 
	 response.write "alert('干部编制数已经录入!');" 
	 response.write "history.go(-1);"
	 response.write "</script>"
     response.end
	set rs1=nothing
     else
%>
  <%
 
     set rs2 = server.createobject("adodb.recordset")
        sql3 = "select count(*) from mp_authorized where level1='"&level1&"' and level2='"&level2&"' and level3='"&level3&"' and level4='"&level4&"' and sort='战士'" 
	  'response.write(sql3)
	  'response.end()
	rs2.open sql3,conn, 1,1
	
	if rs2(0)<>0  and rsort="战士" then
     response.write "<script language='javascript'>" 
	 response.write "alert('战士编制数已经录入!');" 
	 response.write "history.go(-1);"
	 response.write "</script>"
     response.end
     set rs2=nothing
     else
%>
 
 <%
    tableid=1
   person1="'"&rauthorized&_
     "','"&rnownum&_
	 "','"&rsort&_
	 "','"&level1&_ 
	 "','"&level2&_ 
	 "','"&level3&_ 
	 "','"&level4&_ 
	 "',"&tableid&_ 
	 ""
	 
	sql4="insert into mp_authorized(authorized,nownum,sort,level1,level2,level3,level4,tableid)values("&person1&")"
    conn.execute (sql4)
   conn.close
 %>
 
    <%
     response.write "<script language='javascript'>" 
	    response.write "alert('录入成功!');" 
			 response.write "history.go(-1);"
		        response.write "</script>"
     response.end
   conn.close
 end if
end if
%> 

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -