?? manage_prodel.asp
字號(hào):
<!--#include file="conn.asp"-->
<%call time_out()%>
<%
if instr(session("proview"),"s1")=0 then
response.Write "<script language=javascript>alert('您無(wú)權(quán)操作!');window.location.href='index.asp';</script>"
response.end
end if%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>無(wú)標(biāo)題文檔</title>
</head>
<body>
<%pro_name=trim(request("pro_name"))
action=trim(request("action"))
pid=trim(request("pid"))
'恢復(fù)
if action="resume" then
conn.execute("update product set isdel=0 where pid="&pid)
response.redirect("manage_prodel.asp")
end if
'徹底刪除
if action="del" then
'判斷是否可以刪除
'sql1="select pid from [order] where pid="&pid
'set rs=server.createobject("adodb.recordset")
'rs.open sql1,conn,1,1
'if not rs.eof then
'response.Write "<script language=javascript>alert('訂單中有該商品信息，不可刪除!');window.location.href='manage_prodel.asp';</script>"
'response.end
'end if
'rs.close
'set rs=nothing
conn.execute("delete from product where pid="&pid)
response.redirect("manage_prodel.asp")
end if
%>
<form name="form1" method="post" action="manage_prodel.asp?action=search">
<table width="100%" border="1" align="center" bordercolordark="#FFFFFF" bordercolorlight="#F0F0F0">
<tr>
<td width="30%"> </td>
<td>商品名稱(chēng)：
<input type="text" name="pro_name"> <input type="submit" name="Submit" value="查詢(xún)"> </td>
<td width="30%"> </td>
</tr>
</table></form>
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#6699CC" bordercolordark="#FFFFFF">
<tr align="center" bgcolor="6699cc">
<td width="30%" height="25">商品名稱(chēng)</td>
<td>庫(kù)存數(shù)量</td>
<td>市場(chǎng)價(jià)</td>
<td>會(huì)員價(jià)</td>
<td>VIP價(jià)</td>
<td>恢復(fù)</td>
<td>徹底刪除</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
if action="search" then
sql="select * from product where 1=1"
if pro_name<>"" then
sql=sql & " and pro_name like '%"&pro_name&"%'"
end if
sql = sql & " and isdel=1 order by adddate DESC"
else
sql="select * from product where isdel=1 order by adddate DESC"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then%>
<tr><td colspan="8" height="25">暫無(wú)記錄</td></tr>
<%
else
rs.pagesize=18
page = cint(request("page"))
if page = "" then page = 1
if not(isnumeric(page)) then page=1
if page<1 then page=1
if page >= rs.pagecount then page = rs.pagecount
rs.absolutepage = page
for j=1 to rs.PageSize
%>
<tr align="center">
<td height="25"><%if len(trim(rs("pro_name")))>20 then%><%=left(trim(rs("pro_name")),20)%>..<%else%><%=trim(rs("pro_name"))%><%end if%></td>
<td><%=rs("kucun")%></td>
<td><%=rs("market_price")%></td>
<td><%=rs("pt_price")%></td>
<td><%=rs("vip_price")%></td>
<td><a href="manage_prodel.asp?action=resume&pid=<%=rs("pid")%>" onClick="return confirm('確定恢復(fù)？')">恢復(fù)</a></td>
<td><a href="manage_prodel.asp?action=del&pid=<%=rs("pid")%>" onClick="return confirm('確定從數(shù)據(jù)庫(kù)中清除此商品？')">清空</a></td>
</tr>
<%rs.movenext
if rs.eof then exit for
next
%>
<tr>
<td height="25" colspan="8" align="center">
<p align="center">共有記錄<%=rs.recordcount%>條
<%=page%>/<%=rs.pagecount%> <A href="<%request.servervariables("document_name")%>?page=<%=page-1%>&action=<%=action%>&pro_name=<%=pro_name%>">上一頁(yè)</A> <A href="<%request.servervariables("document_name")%>?page=<%=page+1%>&action=<%=action%>&pro_name=<%=pro_name%>">下一頁(yè)</A> 轉(zhuǎn)到第 <SELECT onChange="window.location='?action=<%=action%>&pro_name=<%=pro_name%>&page='+this.value" name=gopage>
<%for x=1 to rs.pagecount%>
<OPTION <%if x=page then%>selected<%end if%> value=<%=x%>><%=x%></OPTION>
<%next%>
</SELECT> 頁(yè)
</td>
</tr>
<%
end if
rs.close
set rs=nothing
%>
</table>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -