📄 admin.asp
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=false
Response.Expires=0
%>
<!-- #include file="../links.asp" -->
<!-- #include file="./s.asp" -->
<!-- #include file="../dsn.asp" -->
<%
if session("adminusername")="" then
session("xhy")=1
Response.Redirect linkwarn
end if
showok=Request.QueryString ("showok")
id=Request.QueryString("id")
pid=Request.QueryString("pid")
ppid=Request.QueryString("ppid")
pageno=Request.QueryString("pageno")
mode=Request.QueryString ("mode")
htmlname=linkadmin&"?ppid="&ppid&"&pid="&pid
if id="" then
id=0
else
id=cint(id)
end if
if pid="" then
pid=0
else
pid=cint(pid)
end if
if ppid="" then
ppid=0
else
ppid=int(ppid)
end if
if pid=17 or pid=20 or pid=21 or pid=22 or pid=1 or pid=24 then
addhtml=linkadmin&"?ppid="&ppid&"&pid="&pid&"&showok=1"
else
addhtml=linkadminedit&"?ppid="&ppid&"&pid="&pid
end if
'picadmin=linkadmin2&"?ppid="&ppid&"&pid="&pid
'yzhtml=linkadmin&"?pid="&pid&"&ppid="&ppid
xyhtml=linkxy&"?pid="&pid&"&ppid="&ppid
plflag=Request.QueryString ("plflag")
pl1=Request.QueryString ("pl")
if pl1="" or pl1=1 then pl1=1
if pl1=1 then
pl1=9
else
pl1=1
end if
if plflag="" then plflag="pl"
'backhtml=linkadmin&"?ppid="&ppid&"&pid="&pid
if pid=9 or pid=11 or pid=12 then Response.Redirect xyhtml
if pid=10 then Response.Redirect "hackip.asp?ppid="&ppid&"&pid="&pid
if pid=6 or pid=7 or pid=8 then Response.Redirect "user_list.asp?ppid="&ppid&"&pid="&pid
if pid=13 or pid=14 or pid=15 then Response.Redirect "pic_list.asp?ppid="&ppid&"&pid="&pid
if pid=18 then Response.Redirect "user_grade.asp?ppid="&ppid&"&pid="&pid
if pid=19 then Response.Redirect "bbs_class.asp?ppid="&ppid&"&pid="&pid
set cn=Server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs0=server.CreateObject("ADODB.Recordset")
set rs=server.CreateObject("ADODB.Recordset")
set rs1=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")
if ppid<>0 then
sqltext="select title from bbs_p_scool where id="&ppid
rs1.Open sqltext,cn,1,1
if not rs1.EOF then
bbs_p_scoolname=rs1("title")
end if
rs1.Close
end if
if pid<>0 then
sqltext="select title from bbs_p_classes where id="&pid
rs1.Open sqltext,cn,1,1
if not rs1.EOF then
bbs_p_classesname=rs1("title")
end if
rs1.Close
end if
htmltitle="基本数据管理"
txtname="名称"
if pid=19 then
tabname="bbs_class"
else
tabname="bbs_p_danwei"
end if
if id<>0 then
sqltext="select * from "+tabname+" where id="&id
rs.Open sqltext,cn,1,1
if not rs.EOF then
titletxt=trim(rs("title"))
pl=rs("pl")
enable=rs("enable")
creatdate=rs("creatdate")
httpadd=trim(rs("httpadd"))
picflag=rs("picflag")
picname=trim(rs("picname"))
fileflag=rs("fileflag")
yhj=trim(rs("yhj"))
thj=trim(rs("thj"))
tel=trim(rs("tel"))
name2=trim(rs("name2"))
content=trim(rs("body"))
end if
rs.Close
else
enable=1
end if
function idadd(oldtabname) '得到该表最大ID号
sqltext="select * from tab_id where tab_name='"+trim(oldtabname)+"'"
rs0.Open sqltext,cn,1,2
if not rs0.EOF then
rs0("tab_id")=rs0("tab_id")+1
else
rs0.AddNew
rs0("tab_name")=oldtabname
rs0("tab_id")=1
end if
rs0.Update
idadd=rs0("tab_id")
rs0.Close
end function
function pladd(oldtabname,oldpid) '得到该表最大排列号
sqltext="select * from "+oldtabname+" where pid="&oldpid&" order by pl desc"
rs0.Open sqltext,cn,1,1
if not rs0.EOF then
pladd=rs0("pl")+1
else
pladd=1
end if
rs0.Close
end function
if Request.ServerVariables("REQUEST_METHOD")="POST" and mode<>"888" then
if not isempty(request("sel")) then
idlist=request("sel")
if instr(idlist,",")>0 then
dim idarr
idArr=split(idlist)
for i = 0 to ubound(idarr)
delid=clng(idarr(i))
call setupdate(delid,mode)
next
else
delid=clng(idlist)
call setupdate(delid,mode)
end if
end if
delid=0
Response.Redirect htmlname
end if
sub setupdate(id,mm)
if mm="999" then
sqltext3="delete from "+tabname+" where id="&id
cn.Execute sqltext3
elseif mm="777" then
sqltext3="update "+tabname+" set enable=1 where id="&id
cn.Execute sqltext3
elseif mm="666" then
sqltext3="update "+tabname+" set enable=0 where id="&id
cn.Execute sqltext3
end if
end sub
if Request.ServerVariables("REQUEST_METHOD")="POST" and mode="888" then
pl=trim(Request.Form("pl"))
titletxt=trim(Request.Form("title"))
if pl="" or not isnumeric(pl) then
pl=pladd(tabname,pid)
else
pl=cint(pl)
end if
if pl="" or not isnumeric(pl) then pl=1
sqltext3="select * from "+tabname+" where title='"+titletxt+"' and pid="&pid&" and ppid="&ppid&" and id<>"&id
rs2.Open sqltext3,cn,1,1
if not rs2.EOF then
err=1
errtxt="错误：条目“"&titletxt&"”已存在，请换名重试！"
titletxt=""
end if
if err<>1 and id=0 then
sqltext2="select * from "+tabname
rs1.Open sqltext2,cn,1,2
rs1.AddNew
rs1("id")=idadd(tabname)
rs1.Update
id=rs1("id")
rs1.Close
end if
if err<>1 and id<>0 then
sqltext2="select * from "+tabname+" where id="&id
rs1.Open sqltext2,cn,1,2
if Request.Form ("showflag")="1" then
rs1("enable")=1
else
rs1("enable")=0
end if
rs1("pl")=pl
rs1("pid")=pid
rs1("ppid")=ppid
rs1("title")=titletxt
rs1("creatdate")=now()
rs1("body")=trim(Request.Form ("content"))
name2=trim(Request.Form ("name2"))
rs1("name2")=name2
rs1.Update
id=rs1("id")
rs1.Close
end if
if err<>1 then Response.Redirect htmlname
end if
%>
<html>
<head>
<title><%=htmltitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000000; font-family: 宋体}
td {font-size: 12px; color: #000000; font-family: 宋体;line-height:130%}
.t1 {font:12px 宋体;color=000000}
.t2 {font:12px 宋体;color:ffffff}
.t3 {font:12px 宋体;color:336699}
.t4 {font:12px 宋体;color:ff0000}
.t5 {font:12px 宋体;color:ff6600}
.bt1 {font:14px 宋体;color=000000}
.bt2 {font:12px 宋体;color:ffffff}
.bt3 {font:14px 宋体;color:336699}
.bt4 {font:14px 宋体;color:ff0000}
.bt5 {font:14px 宋体;color:0000ff}
.bt10 {font:14px 宋体;color:0000ff}
.td1 {font-size:12px;background-color:#3388bb;color:#ffffff}
.td2 {font-size:12px;background-color:#ffffff;color:#000000;}
A:link {color: #000077}
A:visited {color: #000077}
A:hover {color: #ff0000}
A.r1:link {text-decoration:none;color:#304556;}
A.r1:visited {text-decoration:none;color:#304556;}
A.r1:hover {text-decoration:underline;color:ff6600;}
A.r2:link {text-decoration:none;color:#ffffff;}
A.r2:visited {text-decoration:none;color:#ffffff;}
A.r2:hover {text-decoration:underline;color:cccc00;}
-->
</style>
</head>
<body topmargin=5>
<table width="100%" align=center>
<tr>
<td valign="top" align="left" width="100%">
<table width="100%" height="20" border="0">
<tr>
<td style="font-size:12px;"></td>
<td><font class="t5">当前位置： <%Response.Write (bbs_p_scoolname)%>→ <%Response.Write (bbs_p_classesname)%>(列表)</font>
</td>
<td align="right">
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%" valign=top>
<tr><td height=280 valign=top>
<table width="100%" height="20" border="0">
<form action="<%=htmlname%>" method=post name="listform">
<tr>
<%
if pl1=1 then
sqltext1="select * from "+tabname+" where pid="&pid&" and ppid="&ppid&" order by "+plflag
else
sqltext1="select * from "+tabname+" where pid="&pid&" and ppid="&ppid&" order by "+plflag+" desc"
end if
'Response.Write sqltext1
rs1.Open sqltext1,cn,1,1
if ppid=9 or ppid=15 then
listcs=8
else
listcs=20
end if
rs1.PageSize=listcs
if pageno="" then
pageno=1
else
pageno=cint(pageno)
end if
if rs1.PageCount>0 then rs1.AbsolutePage=pageno%>
<td class=t1 align="left" width=340>
<a href="Javascript:window.location.reload()">[刷新列表]</a>
<a href="<%=addhtml%>&id=0">[增加]</a>
<a href="javascript:delrows()">[删除]</a>
<a href="javascript:shows()">[有效]</a>
<a href="javascript:noshows()">[无效]</a>
<%if ppid=2 or ppid=5 or ppid=19 then%>
<a href="javascript:tj()">[推荐]</a>
<a href="javascript:notj()">[不推荐]</a>
<%end if%>
</td>
<td align="right">
<%if rs1.PageCount>1 then%>
[第<b><font color=ff6600><%=pageno%></font></b>页, 共<b><font color=ff6600><%=rs1.PageCount%></font></b>页<b><font color=ff6600><%=rs1.RecordCount%></font></b>条记录
<%if pageno>1 then%>
<a class=r href="<%=htmlname%>&pageno=1">首页</a>
<a class=r href="<%=htmlname%>&pageno=<%=pageno-1%>">上页</a>
<%end if
if pageno<rs1.PageCount then%>
<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">下页</a>
<a class=r href="<%=htmlname%>&pageno=<%=rs1.PageCount%>">末页</a>
<%end if%>
<%end if
%>
</td></tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
<tr bgcolor="666699" style="color:#ffffff" align="center">
<td class=bt2> </td>
<td class=bt2 width=50><a href="<%=htmlname%>&plflag=pl&pl=<%=pl1%>"><font color="#ffffff">序号</a></td>
<td class=bt2><a href="<%=htmlname%>&plflag=enable&pl=<%=pl1%>"><font color="#ffffff">是否有效</a></td>
<td class=bt2><a href="<%=htmlname%>&plflag=title&pl=<%=pl1%>"><font color="#ffffff"><%=txtname%></a></td>
<%if pid=20 then%>
<td class=bt2 align=center>颜色</td>
<%end if%>
</tr>
<%
i=0
do while not rs1.EOF and i<listcs
if (i mod 2)=1 then
Response.Write("<tr bgcolor=fefefe>")
else
Response.Write("<tr bgcolor=efefef>")
end if
%>
<td width="20" align="center"><input type="checkbox" name="sel" value="<%=(rs1("id"))%>"></td>
<td width="50" align="center"><%=rs1("pl")%></td>
<td width="70" align="center">
<%if rs1("enable")=1 then
Response.Write "有效"
else
Response.Write "<font color=red>无效</font>"
end if%>
</td>
<td align=left><a href="<%=addhtml%>&id=<%=rs1("id")%>"><%=rs1("title")%></a></td>
<%if pid=20 then%>
<td class=bt2 align=center width=100>
<table width="60" border="0" cellspacing="0" cellpadding="0">
<tr><td bgcolor="<%=trim(rs1("name2"))%>"> </td></tr>
</table>
</td>
<%end if%>
</tr>
<%rs1.MoveNext
i=i+1
loop%>
</form>
</table>
</td></tr></table>
<%if showok="1" then%>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr bgcolor="666699" style="color:#ffffff" align="center">
<td>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
<tr bgcolor="ffffff" style="color:#ffffff" align="center">
<td height=20 align=left><font color=red><b><%=errtxt%></b></font></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
<form action="<%=htmlname%>&id=<%=id%>&mode=888&showok=1" method=post name=editform onsubmit="return checkform(editform)">
<tr><td width=70 align=right>序号：</td><td><input type="text" value="<%=pl%>" name="pl" maxlength=15 size=5>
是否有效：<input type="checkbox" value="1" name="showflag" <%if enable=1 then Response.Write "checked"%>>
更新时间：<%=creatdate%>
</td></tr>
<tr><td align=right>名称：</td><td><input type="text" value="<%=titletxt%>" name="title" maxlength=35 size=30><font color=red>*</font></td></tr>
<%if pid=20 then%>
<tr><td align=right>颜色：</td><td><input type="text" value="<%=name2%>" name="name2" maxlength=35 size=10><font color=red>*例如：#550055</font></td></tr>
<%end if%>
<%if pid=1 or pid=24 then%>
<tr><td align=right>内容：</td><td><textarea rows=10 cols=60 name=content style="font-family:宋体" ><%=content%></textarea></td></tr>
<%end if%>
<tr><td> </td><td><input type="submit" value="确定提交" name=s1> <input type="button" value="取消返回" name=re1 onClick="window.location.href='<%=htmlname%>'"></td></tr>
</form>
</table>
<%end if%>
</td></tr>
</table>
</body>
</html>
<script language="Javascript">
function checkform(form)
{
var flag;
if(form("title").value==""){alert("<%=txtname%>不能为空！");form.title.focus();return false}else{flag=true}
<%if pid=20 then%>
if(form("name2").value==""){alert("颜色不能为空！");form.anme2.focus();return false}else{flag=true}
<%end if%>
return flag;
}
function delrows()
{
if (confirm('您确认要删除你所选中的项目吗？')==true)
{
document.listform.action="<%=htmlname%>&mode=999";
document.listform.submit();
}
}
function shows()
{
listform.action="<%=htmlname%>&mode=777";
document.listform.submit();
}
function noshows()
{
document.listform.action="<%=htmlname%>&mode=666";
document.listform.submit();
}
function tj()
{
listform.action="<%=htmlname%>&mode=555";
document.listform.submit();
}
function notj()
{
document.listform.action="<%=htmlname%>&mode=444";
document.listform.submit();
}
function editfile(keyno,pic,tablename)
{
var str
str="../admin/file_upload.asp?" ;
str=str+"keyno="+keyno+"&pic="+pic+"&tablename="+tablename
window.open(str,"mywin","toolbar=no,location=no,directories=no,status=no,resizable=no,menubar=no,scrollbars=yes,width=550,height=400,left=120,top=70")
}
</script>
<%
function checkstring(str)
if str<>"" then
a=instr(str,"http://")
if a<>1 then
checkstring="http://"&str
else
checkstring=str
end if
end if
end function
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -