?? delbk.asp
字號:
<html>
<head>
<title>大類管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css.css" rel="stylesheet" type="text/css">
<link href="../css/main.css" rel="stylesheet" type="text/css">
<link href="../images/style.css" rel="stylesheet" type="text/css">
</head>
<!--#include file=conn.asp-->
<!--#include file=refuse.asp-->
<%
dim bclassname,sql1,sql2,errormessage,sql3,sql4,rs2,sql5
bclassname=request("name")
if bclassname<>"" then
sql1="delete * from bclass where name='"&bclassname&"'"
sql2="delete * from sclass where bclass='"&bclassname&"'"
sql3="delete * from product where bclass='"&bclassname&"'"
conn.Execute(sql1)
conn.Execute(sql2)
set rs2=server.createobject("adodb.recordset")
rs2.open "select * from product where bclass='"&bclassname&"'",conn,1,1
do while not rs2.eof
sql4="delete * from question where productid="&rs2("id")
sql5="delete * from lanmu where productid="&rs2("id")
conn.Execute(sql4)
conn.Execute(sql5)
loop
rs2.close
conn.Execute(sql3)
errormessage="成功刪除!"
else errormessage="歡迎來到大類產品管理界面!"
end if
%>
<body>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#6B8FC8">
<!--DWLayoutTable-->
<tr>
<td width="496" height="29" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="496" height="27" valign="middle" class="boxcontent">
<div align="center" ><font color="red" size="3"><%=errormessage%></font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="236" valign="top" bgcolor="#E8F1FF"><div align="center">
<form name="form1" id="form1" method="post" action="delbk.asp">
<table >
<!--DWLayoutTable-->
<tr class="content">
<td height="24" colspan="3" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td width="161" height="21"> </td>
<td width="101"> </td>
<td width="120"> </td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from bclass ",conn,1,1
%>
<tr>
<td class="content">請造擇要刪除的大類:</td>
<td><div align="center">
<select name="name" class="option" id="name">
<%
do while not rs.eof and not rs.bof
%>
<option value="<%=rs("name")%>"><%=rs("name")%></option>
<%
rs.movenext
loop
rs.close
conn.close
%>
</select>
</div></td>
<td><div align="center">
<input name="bt2" type="submit" id="bt2" value="刪除" />
</div></td>
</tr>
<tr>
<td height="63"> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td height="34" colspan="3" valign="top">請注意:一旦刪除,所有該大類的子類及相關產品的所有信息都有將全被刪除</td>
</tr>
<tr>
<td height="40"> </td>
<td colspan="2"> </td>
</tr>
</table>
</form>
</div>
</td>
</tr>
</table>
<br>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -