⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 bigclass.asp

📁 社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功
💻 ASP
字号:
<!--#include file="Conn.ASP"--><!--#include file=../include/config.asp --><!--#include file="char.inc"--><!--#include file="chkuser.asp" -->

<%
IF request.cookies("KEY")="" THEN
response.redirect "index_face.asp"
response.end
else
usernamecookie=CheckStr(request.cookies("UserName"))
passwdcookie=replace(trim(Request.cookies("passwd")),"'","''")
KEYcookie=replace(trim(request.cookies("KEY")),"'","''")
if usernamecookie="" or passwdcookie="" then
response.redirect "login.asp"
response.end
else
'判断用户的合法性
  set rs=server.createobject("adodb.recordset")
  sql="select * from admin where username='"&usernamecookie&"'"
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
             response.redirect "login.asp"
            response.end
         end if
  IF passwdcookie<>rs("passwd") THEN
          response.redirect "login.asp"
           response.end
      END IF
   '下面判断用户级别实际在有用户级别是都应该判断
   if KEYcookie<>rs("OSKEY") then
      response.redirect "index_face.asp"
      response.end
    end if
           rs.close
           set rs=nothing
END IF
END IF
IF request.cookies("KEY")="smallmaster" THEN
response.redirect "smallclass.asp"
response.end
else
usernamecookie=CheckStr(request.cookies("UserName"))
passwdcookie=replace(trim(Request.cookies("passwd")),"'","''")
KEYcookie=replace(trim(request.cookies("KEY")),"'","''")
if usernamecookie="" or passwdcookie="" then
response.redirect "login.asp"
response.end
else
'判断用户的合法性
  set rs=server.createobject("adodb.recordset")
  sql="select * from admin where username='"&usernamecookie&"'"
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
             response.redirect "login.asp"
            response.end
         end if
  IF passwdcookie<>rs("passwd") THEN
          response.redirect "login.asp"
           response.end
      END IF
   '下面判断用户级别实际在有用户级别是都应该判断
   if KEYcookie<>rs("OSKEY") then
      response.redirect "index_face.asp"
      response.end
    end if
           rs.close
           set rs=nothing
END IF
END IF
%>
<%if request.cookies("key")<>"bigmaster" then
dim typeid,typename
typeid=request("typeid")

if typeid="" then
Response.Write "<script>alert('未指定参数');history.back()</script>"
response.end
else
if not IsNumeric(typeid) then
 response.write "<script>alert('非法参数');history.back()</script>"
 response.end
else
end if
end if

Set rs = Server.CreateObject("ADODB.Recordset")
sql ="SELECT  * From type where typeid="&typeid
RS.open sql,Conn,3,3
typename=rs("typename")
master=rs("typemaster")
if master<>"" then
tmaster=split(master,"|")
 for i=0 to ubound(tmaster)
	if request.cookies("username")=trim(tmaster(i)) then
	typemaster=true
	exit for
	else
	typemaster=false
	end if
 next
end if
rs.close
set rs=nothing
end if
if typemaster=true or request.cookies("key")="super" or request.cookies("key")="check" or request.cookies("key")="bigmaster" or request.cookies("key")="selfreg" then
%>

<html>
<head>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=copyright%><%=version%>&nbsp;<%=ver%> - 大类管理</title>
<script>
function IsDigit()
{
  return ((event.keyCode >= 48) && (event.keyCode <= 57));
}
</script>
</head>
<LINK href=site.css rel=stylesheet>
</head>
<body topmargin="0"><!--#include file=top.asp--><br>
<center>
  <table border="1" width="750" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="<%=border%>" bgcolor=<%=m_top%>>
    <%
Set rs6 = Server.CreateObject("ADODB.Recordset")
if request.cookies("key")<>"bigmaster" then
sql6 ="SELECT  * From BigClass where typeid="&typeid&" order by BigClassorder"
else
sql6 ="SELECT  * From BigClass order by BigClassorder"
end if
RS6.open sql6,Conn,3,3
%>
         <form method="post" action="BigClassset.asp?action=update">
<%if request.cookies("key")<>"bigmaster" then%>
<tr height=25>
   <td colspan="8"><a href=typemanage.asp>全部总栏</a>
   </td></tr>
   <tr height=25><td colspan="8">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src=images/menu1.gif><b><a href=bigclass.asp?typeid=<%=typeid%>><font color=red><%=typename%></font></a></b>&nbsp;&nbsp;&nbsp;&nbsp;其他总栏:
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql ="SELECT  * From type where typeid<>"&typeid&" order by typeorder"
RS.open sql,Conn,3,3
do while not rs.EOF
master1=rs("typemaster")
if master1<>"" then
tmaster1=split(master1,"|")
 for i=0 to ubound(tmaster1)
	if request.cookies("username")=trim(tmaster1(i)) then
	typemaster1=true
	exit for
	else
	typemaster1=false
	end if
 next
end if

if (typemaster1=true and request.cookies("key")="typemaster") or request.cookies("key")="super" or request.cookies("key")="check" or request.cookies("key")="selfreg" then
%><a href=bigclass.asp?typeid=<%=rs("typeid")%>><%=rs("typename")%></a>
<%end if
rs.movenext
loop
rs.close
set rs=nothing%>
</td></tr>
<%end if%>
   <tr align=center height=25><td></td>
  <td>大类名称</td>
  <td>大类注释</td>
  <td>大类显示</td>
  <td>属于总栏</td>
  <td>大类排序<br>(必填项,数字)</td>
  <td>大类管理员<br>(可以多个,用|分隔)</td>
  <td>删除</td></tr>
              <%	
do while not rs6.eof
dim bigclassmaster,bigmaster,master
master=rs6("bigclassmaster")
if master<>"" then
bigmaster=split(master,"|")
 for i=0 to ubound(bigmaster)
	if request.cookies("username")=trim(bigmaster(i)) then
	bigclassmaster=true
	exit for
	else
	bigclassmaster=false
	end if
 next
end if
%>

<%
                  set rstype=createobject("adodb.recordset")
                  
sql="select * from type order by typeorder"
                
                  rstype.Open sql,conn,1,3
                  if bigclassmaster=true or request.cookies("key")="super" or request.cookies("key")="check" or (typemaster=true and request.cookies("key")="typemaster") or request.cookies("key")="selfreg" then
     %>
     <tr height=25><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src=images/menu1.gif>
  <a href="smallclass.asp?bigclassid=<%=rs6("BigClassID")%>" title="<%if rs6("bigClasszs")<>"" then%><%=rs6("bigClasszs")%><%else%>无<%end if%>"><%=rs6("BigClassName")%></a></td>
  <td align=center><input type="hidden" name="bigclassid" value="<%=rs6("bigclassid")%>">
<input class=text type="text" name="bigclassname" size="10" value="<%=rs6("bigclassname")%>" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>></td>
  <td align=center><input class=text type="text" name="bigclasszs" size="10" value="<%=rs6("bigclasszs")%>" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>></td>
  <td align=center><select size="1" name="bigclassview" style="font-family: 宋体; font-size: 9pt" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>>
              <option <%if rs6("bigclassview")="1" then%> selected <%end if%>value="1">显示</option>
			      <option <%if rs6("bigclassview")="0" then%> selected <%end if%>value="0">不显示</option>                             
              </select></td>
  <td align=center>
<select name="typeid" style="font-family: 宋体; font-size: 9pt" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>>
                  <%if request.cookies("key")<>"bigmaster" then
do while not rstype.EOF
                  master2=rstype("typemaster")
if master2<>"" then
tmaster2=split(master2,"|")
 for i=0 to ubound(tmaster2)
	if request.cookies("username")=trim(tmaster2(i)) then
	typemaster2=true
	exit for
	else
	typemaster2=false
	end if
 next
end if
if (typemaster2=true and request.cookies("key")="typemaster") or request.cookies("key")="super" or request.cookies("key")="check" or request.cookies("key")="selfreg" then
                  %>
                  <option value="<%=rstype("typeid")%>" <%if rs6("typeid")=cint(rstype("typeid")) then%>selected<%end if%>
                   ><%=rstype("typename")%></option>
                  <%end if
                  rstype.MoveNext
                  loop
else
Set rs = Server.CreateObject("ADODB.Recordset")
sql ="SELECT  * From type where typeid="&rs6("typeid")
RS.open sql,Conn,3,3%>
<option value="<%=rs6("typeid")%>">
<%=rs("typename")%></option>
<%
rs.close
set rs=nothing
end if%>

                  </select></td>
  <td align=center><input class=text type="text" name="bigclassorder" size="10" value="<%=rs6("bigclassorder")%>" ONKEYPRESS="event.returnValue=IsDigit();" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>></td>
  <td align=center><input class=text type="text" name="bigclassmaster" size="10" value="<%=rs6("bigclassmaster")%>" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>></td>
  <td align=center><%if request.cookies("key")="super" or request.cookies("key")="typemaster" then%><a href="bigclasskill.asp?bigclassid=<%=rs6("bigclassid")%>">删除</a><%end if%></td></tr>
   <%end if
RS6.MoveNext
Loop
set rstype=nothing
rs6.close
set rs6=nothing
%>
<tr> 
      <td colspan="8" height=25 align="center" width="100%" bgcolor="#FFFFFF"><input type="submit" name="Submit2" value="保存" style="font-family: 宋体; font-size: 9pt" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster") then%>disabled<%end if%>>&nbsp;<input type="button" value="添加文章" style="font-family: 宋体; font-size: 9pt" onclick="javascript:window.open('newsaddd1.asp','_self','')" <%if not(request.cookies("key")="super" or request.cookies("key")="typemaster" or request.cookies("key")="check" or request.cookies("key")="selfreg") then%>disabled<%end if%>></td>
    </tr></form>
<%if request.cookies("key")="super" or request.cookies("key")="typemaster" then%>
<form method="post" action="BigClassset.asp?action=add">
    <tr height=25><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src=images/menu1.gif>添加大类
  </td>
  <td align=center><input class=text type="text" name="bigclassname" size="10"></td>
  <td align=center><input class=text type="text" name="bigclasszs" size="10"></td>
  <td align=center><select size="1" name="bigclassview" style="font-family: 宋体; font-size: 9pt">
              <option selected value="1">显示</option>
			      <option value="0">不显示</option>                             
              </select></td>
  <td align=center><% 
                  set rstype=createobject("adodb.recordset")
                  sql="select * from type order by typeorder"
                  rstype.Open sql,conn,1,3
                  %>
<select name="typeid" style="font-family: 宋体; font-size: 9pt">
                  <%do while not rstype.EOF
                  master3=rstype("typemaster")
if master3<>"" then
tmaster3=split(master3,"|")
 for i=0 to ubound(tmaster3)
	if request.cookies("username")=trim(tmaster3(i)) then
	typemaster3=true
	exit for
	else
	typemaster3=false
	end if
 next
end if
if request.cookies("key")="super" or (typemaster3=true and request.cookies("key")="typemaster") then%>
                  <option <%if typeid=trim(rstype("typeid")) then%>selected<%end if%> value="<%=rstype("typeid")%>"><%=rstype("typename")%></option>
                  <%end if
                  rstype.MoveNext
                  loop
                  set rstype=nothing
                  %>
                  </select>
</td>
  <td align=center><input class=text type="text" name="bigclassorder" size="10" ONKEYPRESS="event.returnValue=IsDigit();"></td>
  <td align=center><input class=text type="text" name="bigclassmaster" size="10"></td>
  <td align=center><input type="submit" name="Submit2" value="添加" style="font-family: 宋体; font-size: 9pt"></td>
  </tr>
   </form><%end if%>
      </table>
</center>
</body>
</html>
<%
else
response.write "<script>alert('对不起,你无权操作!');history.go(-1);</Script>"
Response.End 
end if%>
<%conn.close
set conn=nothing%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -