⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 goodsedit.asp

📁 网上商场购物系统是一种具有交互功能的商业信息系统
💻 ASP
字号:
<!--#include File="../conndb.asp"-->
<!--#include file="isAdmin.asp"-->
<%
Set rs = Server.CreateObject("ADODB.RECORDSET")
%>
<html>
<head>
<title>编辑商品信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=../style.css rel=STYLESHEET type=text/css>

<script language="javascript">
// 检查输入数据有效性
function CheckFields()
{
}
function newswin(url) {
  var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=300,top=300";
  oth = oth+",width=500,height=100" ;
  var newswin=window.open(url,"newswin",oth);
  return false;
}

</script>
</head>
<body>
<%
  Dim id,iname
  id = Request.QueryString("id")
  sql = "Select * From Goods Where id="&Cint(id)
  Set rsGoods = Conn.Execute(sql)
  If rsGoods.Eof Then
     Response.Write "没有此商品信息"
     Response.End
  Else    
%>
<form method="POST" action="GoodsSave.asp?action=edit&id=<%=id%>" name="form1">
     <table border="0" width="100%" cellspacing="1">
          <tr> 
            <td width="70%">商品类别 
              <select size="1" name="typeid">
                <%
                sql = "Select * From GoodsType"
                rs.Open sql,Conn,3,3
                If rs.Eof Then
                %>
                <option value="">没有类别信息</option>
                <%Else
                    Do While Not rs.Eof
                      If rs("id")=rsGoods("typeid") Then                    
                %>
                <option value="<%=rs("id")%>" selected><%=rs("type")%></option>
                <%    Else%>
                <option value="<%=rs("id")%>"><%=rs("type")%></option>
                <%    End If
                      rs.MoveNext
                    Loop
                End If
                rs.Close%>
              </select>
            </td>
            <td width="30%" rowspan="7" align=left>
<%
  iname = rsGoods("ImageFile")
  If iname = "" Or ISNULL(iname) Then
    url = "EditUpload.asp?id="&id          
%>
    <a href=# onclick=newswin('<%=url%>') alt="设置照片"><font color=blue>无照片</font></a>
<%   
  Else      
    url = "EditUpload.asp?id="&id
    url_delt = "GoodsImageDelt.asp?id="&id
%> 
    <img src="images\<%=rsGoods("ImageFile")%>" width="120" border=0><br><br>         
    <a href=# onclick=newswin('<%=url%>')>设置照片</a>&nbsp; &nbsp;        
    <a href=# onclick=newswin('<%=url_delt%>')>删除照片</a>
<%   
  End If
%></td>       
				</tr>
          <tr> 
            <td>商品名称 
              <input type="text" name="name" size="20" value="<%=rsGoods("Name")%>">
            </td>
          </tr>
          <tr> 
            <td>商品编号 
              <input type="text" name="number" size="20" value="<%=rsGoods("Sn_Number")%>">
            </td>
          </tr>
          <tr> 
            <td>生产公司 <input type="text" name="producer" size="20" value="<%=rsGoods("Producer")%>">
            </td>
          </tr>
          <tr> 
            <td>包装型号 
              <input type="text" name="package" size="20" value="<%=rsGoods("Package")%>">
            </td>
          </tr>
          <tr> 
            <td>销售价格 
              <input type="text" name="saleprice" size="20" value="<%=rsGoods("SalePrice")%>"></td>
          </tr>
          <tr> 
            <td>进货价格 
              <input type="text" name="storeprice" size="20" value="<%=rsGoods("StorePrice")%>">
            </td>
          </tr>
          <tr> 
            <td colspan="2">商品简介</td>
          </tr>
          <tr> 
            <td colspan="2"> 
              <textarea rows="6" name="content" cols="56" class=input><%=rsGoods("Content")%></textarea>
            </td>
          </tr>
          <tr> 
            <td width="100%" align=center><input type="submit" value=" 提 交 " name="B1">&nbsp;&nbsp;&nbsp;&nbsp;
        <input type="reset" value=" 重 写 " name="B2"></td>
          </tr>
        </table>
      </form>
<%End If%>      
</body>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -