📄 editsubs.asp.bak
字号:
<!--#include file="adminconn.inc" -->
<%
if request("action")="delsubs" then
delsubs=request("delsubs")
conn.execute "delete * from subs where subs='"&delsubs&"'"
response.write"<SCRIPT language=JavaScript>alert('你已删除了此商品！');"
response.write"javascript:history.go(-2)</SCRIPT>"
rseponse.end
end if
%>
<%
if request("action")="editsubs" then
editsubs=request("editsubs")
subs=request("subs")
subsname=request("subsname")
price=request("price")
subsnumber=request("subsnumber")
bigarea=request("bigarea")
area=request("area")
photo=request("photo")
other=replace(request("other"),">",">")
other=replace(other,"<","<")
conn.execute "update subs set subs='"&subs&"',subsname='"&subsname&"',price='"&price&"',subsnumber='"&subsnumber&"',bigarea='"&bigarea&"',area='"&area&"',other='"&other&"',photo='"&photo&"' where subs='"&editsubs&"'"
response.write"<SCRIPT language=JavaScript>alert('你已更改了此商品的信息！');"
response.write"javascript:history.go(-2)</SCRIPT>"
end if
%>
<html>
<head>
<title>腾科B2C购物系统-商品管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../inc/guhongying.css" type="text/css">
</head>
<body bgcolor="6699CC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#000000" vspace="0" hspace="0">
<tr>
<td bgcolor="#316395" height="27"><font color="#FFFFFF">.:: 您可以在这里删除或者修改商品资料</font></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="50"> </td>
</tr>
</table>
<%
sql="select * from subs where subs='"&request("searchsubs")&"'"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.write"<SCRIPT language=JavaScript>alert('对不起，没有此商品！');"
response.write"javascript:history.go(-1)</SCRIPT>"
end if
%>
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#000000" width="60%" align="center">
<form name="form1" method="post" action="editsubs.asp">
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>商品代码 [课程号]:</font></td>
<td bgcolor="#336699" height="30" width="69%"><input type="text" name="subs" value="<%=rs("subs")%>" size="25" class="bk">
</td>
</tr>
<tr>
<td bgcolor="#7C96B8" align="left" height="30" width="31%"><font color=ffffff>商品全称:</font></td>
<td bgcolor="#7C96B8" align="left" height="30" width="69%">
<input type="text" name="subsname" value="<%=rs("subsname")%>" size="40" class="bk">
</td>
</tr>
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>价 格:</font></td>
<td bgcolor="#336699" height="30" width="69%">
<input type="text" name="price" value="<%=rs("price")%>" size="25" class="bk">
</td>
</tr>
<tr bgcolor="#7C96B8">
<td height="30" width="31%"><font color=ffffff>题目数量:</font></td>
<td height="30" width="69%">
<input type="text" name="subsnumber" value="<%=rs("subsnumber")%>" size="25" class="bk">
</td>
</tr>
<tr>
<td bgcolor="#336699" height="30" width="31%"><font color=ffffff>所属主分类:</font></td>
<td bgcolor="#336699" height="30" width="69%">
<input type="text" name="bigarea" value="<%=rs("bigarea")%>" size="25" class="bk"></td>
</tr>
<tr bgcolor="#7C96B8">
<td height="30" width="31%"><font color=ffffff>所属分类别:</font></td>
<td height="30" width="69%">
<%if rs("ispacket")<>"1" then%>
<input type="text" name="area" value="<%=rs("area")%>" size="25" class="bk"></td>
<%
else
response.write "<font color=ffffff>此商品为套装商品</font>"
end if
%>
</tr>
<tr bgcolor="#7C96B8">
<td height="30" width="31%"><font color=ffffff><br>其<br>他<br>信<br>息<br><br></font></td>
<td height="30" width="69%">
<textarea name="other" rows="6" cols="30"><%response.write rs("other")%></textarea>
</td>
</tr>
<tr bgcolor="#7C96B8">
<td height="55" width="31%"><font color=ffffff>此商品图片图片资料:</font></td>
<td height="55" width="69%">
<input type="text" name="photo" value="<%=rs("photo")%>" size="25" class="bk">
<font color="#FFFFFF"><br>
[所有图样均在PHOTO目录，填写图片全名即可]</font></td>
</tr>
<tr bgcolor="#336699">
<td height="30" width="31%"><font color="#FFFFFF">请选择您的操作:</font></td>
<td align="left" height="50" width="69%">
<div align="center">
<input type="submit" name="Submit" value="修改此商品资料" class="Tips_bo">
<input type="hidden" name="action" value="editsubs">
<input type="hidden" name="editsubs" value="<%=request("searchsubs")%>">
</div>
</td>
</tr></form>
<tr bgcolor="#7C96B8">
<td align="left" height="80" bgcolor="#7C96B8">
<div align="left"><font color="#FFFFFF"><b>删除商品<br>
为不可逆操作,小心执行 </b> </font></div>
</td>
<td height="80">
<form name="delsubs" method="post" action="editsubs.asp">
<div align="center">
<input type="submit" name="Submit" value="删除此商品" class="Tips_bo">
<input type="hidden" name="action" value="delsubs">
<input type="hidden" name="delsubs" value="<%=request("searchsubs")%>">
</div>
</form>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -