📄 big_sort.asp
字号:
<!--#include file="cookies.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>爱斯特淋浴设备有限公司管理后台</title>
<link href="../file/css.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../js/validator.js"></script>
</head>
<body>
<% set rs=server.CreateObject("adodb.recordset")
sql="select * from product_sort order by sx asc"
rs.open sql,conn,1,1
%>
<table cellpadding="2" cellspacing="1" border="0" width="96%" class="tableBorder" align=center>
<tr bgcolor="#f0f0f0">
<th height="25" colspan="5"><strong>产品大类管理</strong></th>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td width="200" height="25" bgcolor="#FFFFFF" class="BodyTitle">类别名称</td>
<td width="150" bgcolor="#FFFFFF" class="BodyTitle">排列</td>
<td width="100" bgcolor="#FFFFFF" class="BodyTitle">修改</td>
<td width="100" bgcolor="#FFFFFF" class="BodyTitle">删除</td>
</tr>
<!--#include file="../page1.asp"-->
<% for i=1 to x %>
<form name="form1" method="post" action="?action=save" onSubmit="return Validator.Validate(this,2)">
<tr bgcolor="#FFFFFF">
<td width="200" height="25" align="center" bgcolor="#FFFFFF" class="TableRow2"><input name="delid" type="hidden" id="delid" value="<%= rs("id") %>"> <input name="sort" type="text" class="form2" id="sort" value="<%=rs("sort")%>" dataType="Require" msg="请填写产品类别名称！">
<font color="#FF0000">*</font></td>
<td width="150" align="center" bgcolor="#FFFFFF" class="TableRow2"><input name="sx" type="text" class="form2" id="sx" value="<%=rs("sx")%>" size="15" dataType="Number" msg="请填写产品类别排列序号(必须为数字)！">
<font color="#FF0000">*</font></td>
<td width="100" align="center" bgcolor="#FFFFFF" class="TableRow2"><input type="submit" name="Submit" value=" 修 改 "></td>
<td width="100" align="center" bgcolor="#FFFFFF" class="TableRow2"><a href="?id=<%=rs("id")%>&action=delete" onClick="return confirm('您确定要删除吗？\n这样会删除所有相关的小类及产品信息');">删除</a></td>
</tr></form>
<%rs.movenext
next %>
<tr align="center" bgcolor="#F0F0F0">
<td height="25" colspan="5" bgcolor="#FFFFFF" class="TableRow2"> <!--#include file="../page2.asp"--></td>
</tr>
</table>
<br>
<table cellpadding="2" cellspacing="1" border="0" width="96%" class="tableBorder" align=center>
<tr bgcolor="#f0f0f0">
<th height="25" colspan="5" class="BodyTitle"><strong>添加产品大类</strong></th>
</tr>
<form name="form1" method="post" action="?action=add" onSubmit="return Validator.Validate(this,2)">
<tr bgcolor="#FFFFFF">
<td height="25" align="center" class="TableRow2">类别名称</td>
<td align="center" class="TableRow2">排序</td>
<td align="center" class="TableRow2">确定操作</td>
<td align="center" class="TableRow2"> </td>
<td align="center" class="TableRow2"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="200" height="25" align="center" bgcolor="#FFFFFF" class="TableRow2"> <input name="sort" type="text" class="form2" id="sort" dataType="Require" msg="请填写产品类别名称！">
<font color="#FF0000">*</font></td><td width="150" align="center" bgcolor="#FFFFFF" class="TableRow2"><input name="sx" type="text" class="form2" id="sx" size="15" dataType="Number" msg="请填写产品类别排列序号(必须为数字)！">
<font color="#FF0000">*</font></td>
<td width="100" align="center" bgcolor="#FFFFFF" class="TableRow2"><input type="submit" name="Submit" value=" 添 加 "></td>
<td width="100" align="center" bgcolor="#FFFFFF" class="TableRow2"> </td>
<td align="center" bgcolor="#FFFFFF" class="TableRow2"> </td>
</tr>
</form>
</table></td>
</tr>
</table>
</body>
</html>
<% if request.querystring("action")="save" then
set rs=server.createobject("adodb.recordset")
sql="select * from product_sort where id="&cint(request.form("delid"))
rs.open sql,conn,1,3
rs("sort")=trim(request.form("sort"))
rs("sx")=trim(request.form("sx"))
rs.update
response.Write "<script language=javascript>alert('修改类别成功！');window.location.href='big_sort.asp';</script>"
rs.close
set rs=nothing
elseif request.querystring("action")="delete"then
deltxt="delete from product_sort where id="&request("id")
deltxt0="delete from product_small_sort where big_sortid="&request("id")
deltxt1="delete from product_info where big_sortid="&request("id")
conn.execute deltxt
conn.execute deltxt0
conn.execute deltxt1
response.Write "<script language=javascript>alert('类别删除成功！');window.location.href='big_sort.asp';</script>"
conn.close
set conn=nothing
end if
%>
<% if request.querystring("action")="add" then
if trim(request.form("sort"))="" then
response.Write "<script language=javascript>alert('请填写类别名称！');window.location.href='big_sort.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_sort"
rs.open sql,conn,1,3
rs.addnew
rs("sort")=trim(request.form("sort"))
rs("sx")=trim(request.form("sx"))
rs.update
response.Write "<script language=javascript>alert('添加类别成功！');window.location.href='big_sort.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -