📄 modifying.asp
字号:
<!--#include file="session.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改商品</title>
<link href="css.css" rel="stylesheet" type="text/css">
<%
function html(constring)
constring=replace(constring,"",CHR(13))
constring=replace(constring,"<br>",CHR(10))
constring=replace(constring,"</p><p>",CHR(10)&CHR(10))
html=constring
end function
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from smallclass order by scid asc"
rs.open sql,conn,1,1
%>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("scname"))%>","<%= trim(rs("bcid"))%>","<%= trim(rs("scid"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.formadd.scid.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.formadd.scid.options[document.formadd.scid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script>
</head>
<body>
<div align="center">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="mainmiddle">
<tr>
<td width="29" height="32"> <div align="left">
<p class="maindaohang"> </p>
</div></td>
<td width="709"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<b><font color="#000000"><b> <span class="bigNavi">修改商品</span> </b></font></b></td>
<td width="8" class="mainrights"></td>
</tr>
</table>
<%
dim bcid,scid,sp_name,marprice,memprice,choice1,choice2,choice3,choice4,choice5,choice6,spsm,spms,sp_pic,tj,tejia
sql="select * from goods where id="&request("id")
rs.open sql,conn,1,1
bcid=rs("bclassid")
scid=rs("sclassid")
sp_name=rs("sp_name")
jifen=rs("jifen")
dh=rs("duihuan")
marprice=rs("marprice")
memprice=rs("memprice")
vipprice=rs("vipprice")
spsm=rs("spsm")
spms=rs("spms")
spic=rs("spic")
sp_pic=rs("sp_pic")
tj=rs("tj")
tejia=rs("tejia")
haoid=rs("id")
filename1=rs("filename")
rs.close
%>
<form method="POST" name="formadd" action="modifysave.asp?id=<%=haoid%>">
<input type="hidden" name="filename2" value="<%=filename1%>">
<table width="95%" height="148" border="0" align="center" cellpadding="3" cellspacing="1" class="tabbgcolor">
<tr class="tabbgcolorli">
<td height="20"><div align="center">选择分类:</div></td>
<td height="20" colspan="3"><table border="0" cellspacing="1" width="100%">
<td width="85%"> 大类
<select name="bcid" onChange="changelocation(document.formadd.bcid.options[document.formadd.bcid.selectedIndex].value)" size="1">
<%
dim conclass,choosed
sql1="select * from bigclass"
rs.open sql1,conn,1,1
if rs.eof and rs.bof then
response.write"暂时还没有商品大类"
else
do while not rs.eof
if cstr(bcid)=cstr(rs("bcid")) then
choosed="selected"
conclass=rs("bcid")
else
choosed=""
end if
response.write "<option " & choosed & " value='"+CStr(rs("bcid"))+"'>"+rs("bcname")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
end if
rs.close
%>
</select> 相关小类 <select name="scid" size="1">
<%
sql2="select * from smallclass where bcid="&conclass
rs.open sql2,conn,1,1
if rs.eof and rs.bof then
response.write"暂时还没有相应小类"
else
do while not rs.eof
if cstr(scid)=cstr(rs("scid")) then
choosed="selected"
else
choosed=""
end if
response.write "<option " & choosed & " value='"+CStr(rs("scid"))+"'>"+rs("scname")+"</option>"+chr(13)+chr(10)
rs.movenext
loop
end if
rs.close
%>
</select></td>
</tr>
</table>
<div align="center"></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="17%" height="20"> <div align="center">商品名称</div></td>
<td height="20" colspan="3">
<input type="text" name="sp_name" value="<%=sp_name%>" size="20" class="border">
<div align="center"></div></td>
</tr>
<tr class="tabbgcolorli">
<td width="17%" height="20"> <div align="center">市场价</div></td>
<td width="31%" height="20">
<input type="text" name="marprice" value="<%=marprice%>" size="12 " class="border">
元</td>
<td width="18%"> <div align="center">本站价</div></td>
<td width="34%">
<input type="text" name="memprice" value="<%=memprice%>" size="12 " class="border">
元</td>
</tr>
<tr class="tabbgcolorli">
<td width="17%" height="20"> <div align="center">VIP价</div></td>
<td width="31%" height="20">
<input type="text" name="vipprice" value="<%=vipprice%>" size="12" class="border">
元</td>
<td width="18%"> <div align="center">商品积分</div></td>
<td width="34%">
<input type="text" name="jifen" value="<%=jifen%>" size="12" class="border">
分</td>
</tr>
<tr class="tabbgcolorli">
<td height="20"> <div align="center">商品说明</div></td>
<td height="20" colspan="3">
<textarea rows="3" name="sp_intr" cols="50" class="border"><%=html(spsm)%></textarea>
全方位支持html语言
<div align="center"></div></td>
</tr>
<tr class="tabbgcolorli">
<td height="20"> <div align="center">商品描述</div></td>
<td height="20" colspan="3">
<textarea rows="10" name="sp_desc" cols="50" class="border"><%=html(spms)%></textarea>
全方位支持html语言
<div align="center"></div></td>
</tr>
<tr class="tabbgcolorli">
<td height="20"> <div align="center">商品小图片</div></td>
<td height="20" colspan="3"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="49%"><div align="center">
<input name="spic" value="<%=spic%>" type="text" size="30" class="border">
</div></td>
<td width="51%"></td>
</tr>
</table></td>
</tr>
<tr class="tabbgcolorli">
<td height="20"> <div align="center">商品大图片</div></td>
<td height="20" colspan="3"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="49%"><div align="center">
<input name="pic" value="<%=sp_pic%>" type="text" size="30" class="border">
</div></td>
<td width="51%"></td>
</tr>
</table></td>
</tr>
<tr class="tabbgcolorli">
<td height="20"> <div align="center">是否推荐</div></td>
<td height="20">
<% if tj=true then %>
是
<input type="radio" name="tj" value="true" checked>
否
<input type="radio" name="tj" value="false">
<%else%>
是
<input type="radio" name="tj" value="true">
否
<input type="radio" name="tj" value="false" checked>
<%end if%>
</td>
<td> <div align="center">是否特价</div></td>
<td>
<% if tejia=true then %>
是
<input name="tejia" type="radio" value="true" checked>
否
<input type="radio" name="tejia" value="false">
<%else%>
是
<input name="tejia" type="radio" value="true"> 否
<input type="radio" name="tejia" value="false" checked>
<%end if%>
</td>
</tr>
<tr class="tabbgcolorli">
<td height="20" colspan="4"> <div align="center"></div>
<div align="center">
<input type="submit" value="现在提交" name="tijiao" class="border">
<input type="reset" value="全部重写" name="chongxie" class="border">
</div></td>
</tr>
</table>
</form>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -