📄 class_add.asp
字号:
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
Makking = Trim(Request.QueryString("Makking"))
RootID = Request.QueryString("RootID")
PartID = Request.QueryString("PartID")
NumberID= Trim(Request.QueryString("NumberID"))
select case Makking
case "del"
ID = Trim(Request.QueryString("ID"))
conn.execute("delete from class where NumberID like '"& ID &"%'")
Save_title="·删除成功"
call Save_ok()
'==================================
case "Add"
if Request.Form("NumberID")="" or Trim(Request.Form("Class"))= "" then
Save_title="·对不起，请填写完整的参数"
call Save_err()
end if
'=============================
ID = Trim(Request.QueryString("ID"))
if ID="" then
sql="select * from Class"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.addnew
rs("NumberID") = Request.Form("NumberID")
rs("Class") = Trim(Request.Form("Class"))
rs("Classorder") = Request.Form("Classorder")
rs("ProductCount")= 0
if NumberID<>0 AND NumberID<>"" then
sql="select * from Class where NumberID='"& NumberID &"'"
set rs_PartID=server.createobject("adodb.recordset")
rs_PartID.open sql,conn,1,1
if not(rs_PartID.eof and rs_PartID.bof) then
rs("LagID") = rs_PartID("LagID")+1
if rs_PartID("RootID") = "0" then
rs("RootID") = RootID
else
rs("RootID") = rs_PartID("RootID")
end if
rs("PartID") = NumberID
end if
rs_PartID.close
else
rs("RootID") = 0
rs("LagID") = 0
rs("PartID") = 0
end if
rs.update
rs.close
set rs=nothing
Save_title="·添加成功"
call Save_ok()
ELSE
sql="select * from Class where ID="& ID
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs("Class") = Trim(Request.Form("Class"))
rs("Classorder") = Request.Form("Classorder")
rs.update
rs.close
set rs=nothing
Save_title="·修改成功"
call Save_ok()
END IF
case ""
ID= Trim(Request.QueryString("ID"))
IF ID<>"" THEN
sql="select * from Class where ID="& ID
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if not(rs.eof and rs.bof) then
NumberIDstr = rs("NumberID")
Classstr = rs("Class")
J = rs("Classorder")
END IF
ELSE
if NumberID="" then
NumberID=0
end if
DIM J,JJ
sql="select * from Class where PartID= '"& NumberID &"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
J=rs.RecordCount+1
if len(J)=1 THEN
JJ="00"&J&""
END IF
if len(J)=2 THEN
JJ="0"&J&""
END IF
if len(J)=3 THEN
JJ=J
END IF
NumberIDstr = ""&Trim(Request.QueryString("NumberID"))&""&JJ&""
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>亿博尔</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%" border="0" cellpadding="3" cellspacing="0">
<tr bgcolor="eeeeee">
<td width="5%" align="center"><img src="Images/1.gif" width="13" height="12"></td>
<td width="85%"><span class="style2">管理中心 >>> 添加分类
<%
if Request.QueryString("NumberID")<>"" then
sql="select * from Class where NumberID='"& Request.QueryString("NumberID")&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if not(rs.bof and rs.eof) then
response.write " >>> <a href=Class_Manage.asp?RootID="&NumberID&"&PartID="&PartID&"&NumberID="&NumberID&">"&rs("class")&"</a>"
end if
rs.close
end if
%>
</span></td>
<td width="10%" align="right"><%
sql="select * from Class where NumberID='"& PartID &"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if not(rs.bof and rs.eof) then
response.write "<a href=Class_Manage.asp?RootID="&rs("RootID")&"&PartID="&rs("PartID")&"&NumberID="&rs("NumberID")&"><img src=""Images/back1.gif"" border=""0""></a>"
end if
rs.close
%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" height="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="ffffff">
<form method='POST' name="F1" action='Class_add.asp?Makking=Add&ID=<%=ID%>&NumberID=<%=NumberID%>&RootID=<%=RootID%>&PartID=<%=PartID%>'>
<p> </p>
<table width=45% border=0 align='center' cellpadding=3
cellspacing=1 bordercolordark=#ffffff bgcolor="#Eeeeee" class='size09'>
<tr bgcolor="ffffff">
<td width='20%' height="25" align="right" bgcolor="#E3E3E3">ID：</td>
<td height="25">
<input name="NumberID" type="text" class="box1" id="NumberID" value="<%=NumberIDstr%>" size="30" readonly="true"></td>
</tr>
<tr bgcolor="ffffff">
<td width='20%' height="25" align="right" bgcolor="#E3E3E3">名称：</td>
<td height="25">
<input type='text' class='box1' name='Class' size='30' value='<%=Classstr%>'></td>
</tr>
<tr bgcolor="ffffff">
<td width='20%' height="25" align="right" bgcolor="#E3E3E3">排序：</td>
<td height="25"><input name="Classorder" type="text" class="box1" id="Classorder" value="<%=J%>" size="10" onKeyPress = "return regInput(this, /^[0-9]*$/, String.fromCharCode(event.keyCode))"></td>
</tr>
</table>
<p>
<input name="B1" type="image" src="Images/refer.gif" width="36" height="21" border="0" >
<a href="javascript:history.go(-1)"><img src="Images/back.gif" width="36" height="21" border="0"></a></p>
</form></td>
</tr>
</table> </td>
</tr>
</table>
<%end select
Conn.Close
Set Conn = Nothing
%>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="6"></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -