mclass.asp
上传用户:syzzy1975
上传日期:2022-07-17
资源大小:670k
文件大小:4k
源码类别:

Jsp/Servlet

开发平台:

Java

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
  2. <%
  3. %><!--#include file="inc/config.asp"-->
  4. <!--#include file="inc/conn.asp"--> 
  5. <!--#include file="inc/chk.asp"--> 
  6. <%
  7. if session("rank")>1 then
  8. call Msgbox("对不起,您的权限不够!","Back","None")
  9. response.End
  10. end if
  11. %>
  12. <%
  13. if NOT isempty(request("MoveSubmit")) then
  14. dim sortsid,categoryid
  15. sortsid=int(request("sortsid"))
  16. categoryid=int(request("categoryid"))
  17. set rs=server.CreateObject("adodb.recordset")
  18. rs.open "select sortsid,categoryid from sorts where sortsid="&sortsid ,conn,1,3
  19. rs("categoryid")=categoryid
  20. rs.Update
  21. rs.Close
  22. set rs=nothing
  23. call MsgBox("转移成功!","None","None")
  24. end if
  25. %>
  26. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  27. <html>
  28. <head>
  29. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  30. <title>406网络书店</title>
  31. <link href="../style.css" rel="stylesheet" type="text/css">
  32. </head>
  33. <body>
  34. <!--#include file="head.htm"-->
  35. <table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
  36.   <tr>
  37.     <td width="219" align="left" valign="top"><br>
  38.       <!--#include file="menu.htm"-->
  39.         <br></td><td width="561" align="left" valign="top">
  40.       <br>      <table border="0" cellpadding="0" cellspacing="0">
  41.         <tr>
  42.           <td><img src="../images/w.gif" width="18" height="18"></td>
  43.           <td style="color:#415373">商品类别转移</td>
  44.         </tr>
  45.       </table>      <br>      <br>      <form name="form1" method="post" action="">
  46.         <table width="56%" border="0" align="center" cellpadding="1" cellspacing="1">
  47.         
  48.           <tr>
  49.             <td width="56%" align="right">请选择您要转移的小类:</td>
  50.             <td width="44%">
  51.               <select name="sortsid" size="1" class="smallinput" >
  52.                 <%set rs=server.CreateObject("adodb.recordset")
  53.                 rs.Open "select sortsid,sorts from sorts order by sortsid",conn,1,1
  54.                 if rs.EOF and rs.BOF then
  55.                 response.Write "<option value=0>还没有分类</option>"
  56.                 else
  57.                 do while not rs.EOF
  58.                 %>
  59.                 <option value="<%=int(rs("sortsid"))%>"><%=trim(rs("sorts"))%></option>
  60.                 <%rs.MoveNext
  61.                 loop
  62.                 rs.Close
  63.                 set rs=nothing
  64.                 end if%>
  65.               </select>
  66.             </td>
  67.           </tr>
  68.           <tr>
  69.             <td align="right">请选择所属大类:</td>
  70.             <td>
  71.               <select name="categoryid" size="1" class="smallinput" >
  72.                 <%set rs=server.CreateObject("adodb.recordset")
  73.                 rs.Open "select categoryid,category from category order by categoryorder",conn,1,1
  74.                 if rs.eof and rs.bof then
  75.                 response.Write "<option value=0>还没有分类</option>"
  76.                 else
  77.                 do while not rs.eof
  78.                 %>
  79.                 <option value="<%=int(rs("categoryid"))%>"><%=trim(rs("category"))%></option>
  80.                 <%rs.movenext
  81.                 loop
  82.                 rs.close
  83.                 set rs=nothing
  84.                 end if%>
  85.               </select></td>
  86.           </tr>
  87.           <tr align="center">
  88.             <td height="30" colspan="2"><input name="MoveSubmit" type="submit" id="MoveSubmit" value="确定转移"></td>
  89.           </tr>
  90.         </table>
  91.       </form>      <br>      <table border="0" cellpadding="0" cellspacing="0">
  92.         <tr>
  93.           <td><img src="../images/w.gif" width="18" height="18"></td>
  94.           <td style="color:#415373">操作注意事项及说明</td>
  95.         </tr>
  96.       </table>      <table width="80%" border="0" align="center" cellpadding="5" cellspacing="0">
  97.         <tr>
  98.           <td height="16"><font color="#FF0000">·转移小类的同时也转移小类下所有的商品。<br>
  99.       ·转移后需要修改小分类的排序。</font></td>
  100.         </tr>
  101.       </table>      <br>
  102.       </td>
  103.   </tr>
  104. </table>
  105. <!--#include file="foot.htm"-->
  106. </body>
  107. </html>