📄 public_class.asp
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=true
Response.Expires=0
if Session("userqx")="1" or Session("userqx")="9" then
else
Response.Redirect "../warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
pageno=Request.QueryString("pageno")
classcode=Request.QueryString("classcode")
keyno=Request.QueryString("keyno")
htmltitle=Request.QueryString("title")
tablename=Request.QueryString("tablename")
set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")
if keyno<>"" then
sqltext="select keyno from product where classcode='"+keyno+"'"
rs.Open sqltext,cn,1,1
if not rs.EOF then
Response.Write "<font color=red>该类别已有产品数据，不能删除！</font>"
else
sqltext="delete from "+tablename+" where classcode='"+keyno+"'"
cn.Execute sqltext
end if
rs.Close
end if
if classcode="" then
sqltext="select classcode,classname from "+tablename+" where parentcode='0' order by sortnum"
rs2.Open sqltext,cn,1,1
if not rs2.EOF then
classcode=trim(rs2(0))
classname=trim(rs2(1))
else
Response.Write("请先添加大类！")
Response.End
end if
rs2.Close
else
sqltext="select classname from "+tablename+" where classcode='"+classcode+"'"
rs2.Open sqltext,cn,1,1
classname=trim(rs2(0))
rs2.Close
end if
wheretxt=" and aa.parentcode='"+classcode+"'"
htmlname="public_class.asp?title="+htmltitle+"&tablename="+tablename+"&classcode="+classcode
addhtml="public_class_edit.asp?title="+htmltitle+"&tablename="+tablename+"&classcode="+classcode+"&pageno="+pageno
%>
<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}
.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>
<%
sqltext="select aa.classcode,aa.classname as name,aa.sortnum,aa.picflag,bb.classname as classname from "+tablename+" aa,"+tablename+" bb "
sqltext=sqltext+"where aa.parentcode=bb.classcode "+wheretxt+" order by aa.classcode"
'Response.Write sqltext
rs.Open sqltext,cn,1,1
listcs=30
rs.PageSize=listcs
if pageno="" then
pageno=1
else
pageno=cint(pageno)
end if
if rs.PageCount>0 then rs.AbsolutePage=pageno
%>
<td class=t1 align="left" >
<font color="navy" style="font-size:14px"><b><%=htmltitle%></b></font>
<a href="<%=htmlname%>&pageno=<%=pageno%>">[刷新列表]</a>
<a href="<%=addhtml%>">[增加记录]</a>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
<tr bgcolor="336699" style="color:#ffffff" align="center">
<td class=bt2 width=35>删除</td><td class=bt2>所属大类</td><td class=bt2>序号</td>
<td class=bt2>类别名称</td><td class=bt2></td>
</td></tr>
<%
i=0
do while not rs.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="35" align="center" onclick="Javascript:delclass('<%=rs("classcode")%>','<%=trim(rs("name"))%>')"><img src="delete.gif"></td>
<td width="150" align="center"><%=trim(rs("classname"))%></td>
<td width="60" align="center"><%=rs("sortnum")%></td>
<td align=left><a href="<%=addhtml%>&keyno=<%=rs("classcode")%>"><%=trim(rs("name"))%></td>
<td></td>
</tr>
<%
i=i+1
rs.MoveNext
loop
%>
</table>
<table width="100%">
<tr><td bgcolor="ffffff" align=right>
<%if rs.PageCount>1 then%>
[第<b><font color=ff6600><%=pageno%></font></b>页共<b><font color=ff6600><%=rs.PageCount%></font></b>页<b><font color=ff6600><%=rs.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<rs.PageCount then%>
<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">下页</a>
<a class=r href="<%=htmlname%>&pageno=<%=rs.PageCount%>">末页</a>
<%end if%>
<%end if%>
</td></tr>
</table>
</td></tr>
</table>
</body>
</html>
<script language="Javascript">
function delclass(code,topic)
{
if (confirm('您确认要删除“'+topic+'”吗？')==true)
{
window.location.href="<%=htmlname%>&keyno="+code+"&pageno=<%=pageno%>"
return false;
}
}
function editimage(keyno)
{
var str
str="../admin/upload.asp?" ;
str=str+"keyno="+keyno+"&tablename=product_class&keyword=classcode&strflag=1"
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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -