outproduct.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:11k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <!--#include file="conn.asp"-->
  2. <%
  3. dim cls
  4. if session("admin")="" then
  5. Response.Redirect("admin.asp")
  6. else
  7. if session("flag")<>"0" then
  8. cls = Instr(session("flag"), "manprofig")
  9. if cls <= 0 then
  10. %>
  11. <script language="javascript">
  12. if (confirm("您的操作权限不够,系统拒绝你的访问,请点确定返回,或者点取消退出重新登录"))
  13.   location.href="login.asp";
  14. else
  15.   location.href="index.asp";
  16. </script>
  17. <%
  18. end if
  19. end if
  20. end if
  21. %>
  22. <html>
  23. <head>
  24. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  25. <link href="../images/css.css" rel="stylesheet" type="text/css">
  26. </head>
  27. <body>
  28. <%
  29. dim selectm,selectkey,selectbookid
  30. selectkey=trim(request(trim("selectkey")))
  31. selectm=trim(request("selectm"))
  32. if selectkey="" then
  33. selectkey=request.QueryString("selectkey")
  34. end if
  35. if selectkey="请输入关键字" then
  36. selectkey=""
  37. end if
  38. if selectm="" then
  39. selectm=request.QueryString("selectm")
  40. end if
  41. %>
  42. <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  43. <tr> 
  44. <form name="form1" method="post" action="delproduct.asp">
  45. <td height="100"> 
  46. <%
  47. Const MaxPerPage=20
  48.     dim totalPut   
  49.     dim CurrentPage
  50.     dim TotalPages
  51.     dim j
  52.     dim sql
  53.                  
  54.      if Not isempty(request("page")) then
  55.        currentPage=Cint(request("page"))
  56.     else
  57.        currentPage=1
  58.     end if 
  59. set rs=server.CreateObject("adodb.recordset")
  60. select case selectm
  61. case ""
  62.             rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic from products where kucun<=5  order by adddate desc",conn,1,1
  63.     case "0"
  64. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products order by adddate desc",conn,1,1
  65.     case "bookid"
  66. if selectkey="" then
  67. selectkey=0
  68. end if
  69. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where bookid="&selectkey&" order by adddate desc",conn,1,1
  70. case "bookname"
  71. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where bookname like '%"&selectkey&"%' order by adddate desc",conn,1,1
  72. case "bookcontent"
  73. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where bookcontent like '%"&selectkey&"%' order by adddate desc",conn,1,1
  74. case "news"
  75. if selectkey<>"" then
  76. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where newsbook=1 and bookname like '%"&selectkey&"%' order by adddate desc",conn,1,1
  77. else
  78. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where newsbook=1 order by adddate desc",conn,1,1
  79. end if
  80. case "tuijian"
  81. if selectkey<>"" then
  82. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where bestbook=1 and bookname like '%"&selectkey&"%' order by adddate desc",conn,1,1
  83. else
  84. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where bestbook=1 order by adddate desc",conn,1,1
  85. end if
  86. case "tejia"
  87. if selectkey<>"" then
  88. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic  from products where tejiabook=1 and bookname like '%"&selectkey&"%' order by adddate desc",conn,1,1
  89. else
  90. rs.open "select bookid,bookname,adddate,kucun,zhuangtai,bookpic from products where tejiabook=1 order by adddate desc",conn,1,1
  91. end if
  92.    end select
  93.     if err.number<>0 then
  94. response.write "目前暂无缺货商品"
  95. end if
  96.    if rs.eof And rs.bof then
  97.         Response.Write "<p align='center' class='contents'> 目前暂无缺货商品!</p>"
  98.     else
  99.    totalPut=rs.recordcount
  100.        if currentpage<1 then
  101.            currentpage=1
  102.        end if
  103.        if (currentpage-1)*MaxPerPage>totalput then
  104.     if (totalPut mod MaxPerPage)=0 then
  105.       currentpage= totalPut  MaxPerPage
  106.     else
  107.        currentpage= totalPut  MaxPerPage + 1
  108.     end if
  109.        end if
  110.         if currentPage=1 then
  111.              showContent
  112.              showpage totalput,MaxPerPage,"outproduct.asp"
  113.         else
  114.            if (currentPage-1)*MaxPerPage<totalPut then
  115.              rs.move  (currentPage-1)*MaxPerPage
  116.              dim bookmark
  117.              bookmark=rs.bookmark
  118.              showContent
  119.               showpage totalput,MaxPerPage,"outproduct.asp"
  120.          else
  121.          currentPage=1
  122.             showContent
  123.             showpage totalput,MaxPerPage,"outproduct.asp"
  124.        end if
  125.     end if
  126.         end if
  127.     sub showContent
  128.         dim i
  129.     i=0%>
  130.         <table class="tableBorder" width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
  131.           <tr> 
  132.             <td colspan="7" align="center" background="../images/admin_bg_1.gif"><b><font color="#ffffff">商品缺货提醒</font></b></td>
  133.           </tr>
  134.           <tr > 
  135.             <td width="12%" align="center" bgcolor="fbc2c2">序号</td>
  136.             <td width="12%" align="center" bgcolor="fbc2c2">图片</td>
  137.             <td width="30%" align="center" bgcolor="fbc2c2">商品名称</td>
  138.             <td width="11%" align="center" bgcolor="fbc2c2">商品状态</td>
  139.             <td width="8%" align="center" bgcolor="fbc2c2">库存数量</td>
  140.             <td width="16%" align="center" bgcolor="fbc2c2">最后修改时间</td>
  141.             <td width="11%" align="center" bgcolor="fbc2c2">选 择</td>
  142.           </tr>
  143.           <%do while not rs.eof%>
  144.           <tr > 
  145.             <td align="center"><%=rs("bookid")%></td>
  146.             <td align="center"> 
  147.               <%if rs("bookpic")="" then 
  148. response.write "<div align=center><a href=../products.asp?id="&rs("bookid")&" target=_blank><img src=../images/emptybook.gif width=60 height=60 border=0></a></div>"
  149. else%>
  150.               <a href=../products.asp?id=<%=rs("bookid")%> target=_blank><img src="../<%=trim(rs("bookpic"))%>" width=60 height=60 border=0 align=absmiddle></a> 
  151.               <%end if%>
  152.             </td>
  153.             <td width="30%" STYLE='PADDING-LEFT: 10px'> <a href=editproduct.asp?id=<%=rs("bookid")%>> 
  154.               <% if len(trim(rs("bookname")))>20 then
  155. response.write left(trim(rs("bookname")),18)&".."
  156. else
  157. response.write trim(rs("bookname"))
  158. end if%>
  159.               </a> 
  160.               
  161.               <%if  rs("kucun")<=5 and rs("kucun")>0  then %>
  162.               <font color=red> 即将缺货</font> 
  163.   <%else%>
  164.   <font color=red> 已经缺货</font> 
  165.               <%end if%>
  166.             </td>
  167.             <td width="11%" align="center" STYLE='PADDING-LEFT: 10px'> 
  168.               <% if rs("zhuangtai")=0 then %>
  169.               <a href="keep.asp?action=xj&id=<%=rs("bookid")%>" title="点击可使此商品下架">上架中</a> 
  170.               <%else  %>
  171.               <a href="keep.asp?action=sj&id=<%=rs("bookid")%>" title="点击可使此商品上架"><font color="#FF0000">下架中</font></a> 
  172.               <%end if%>
  173.             </td>
  174.             <td align="center"><%=rs("kucun")%></td>
  175.             <td align="center"><%=rs("adddate")%></td>
  176.             <td align="center"> <input name="selAnnounce" type="checkbox" id="selAnnounce" value="<%=cstr(rs("bookid"))%>"> 
  177.             </td>
  178.           </tr>
  179.           <tr > 
  180.             <td height="1" align="center"></td>
  181.             <td height="1" colspan="5" align="center" bgcolor="#CCCCCC"></td>
  182.             <td height="1" align="center"></td>
  183.           </tr>
  184.           <%i=i+1
  185. if i>=MaxPerPage then Exit Do
  186. rs.movenext
  187. loop
  188. rs.close
  189. set rs=nothing%>
  190.           <tr > 
  191.             <td height="30" colspan="7" align="right">全选 
  192.               <input type="checkbox" name="checkbox" value="Check All" onClick="mm()"> 
  193.               <input type="submit" name="Submit" value="删 除" onClick="return test();"> 
  194.               &nbsp;</td>
  195.           </tr>
  196.         </table>
  197. <%  
  198. End Sub   
  199. Function showpage(totalnumber,maxperpage,filename)  
  200.    Dim n
  201. If totalnumber Mod maxperpage=0 Then  
  202. n= totalnumber  maxperpage  
  203. Else
  204. n= totalnumber  maxperpage+1  
  205. End If
  206. Response.Write "<form method=Post action="&filename&"?selectm="&selectm&"&selectkey="&selectkey&" >"  
  207. Response.Write "<p align='center' class='contents'> "  
  208. If CurrentPage<2 Then  
  209. Response.Write "<font class='contents'>首页 上一页</font> "  
  210. Else  
  211. Response.Write "<a href="&filename&"?page=1&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>首页</a> "  
  212. Response.Write "<a href="&filename&"?page="&CurrentPage-1&"&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>上一页</a> "  
  213. End If
  214. If n-currentpage<1 Then  
  215. Response.Write "<font class='contents'>下一页 尾页</font>"  
  216. Else  
  217. Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&"&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>"  
  218. Response.Write "下一页</a> <a href="&filename&"?page="&n&"&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>尾页</a>"  
  219. End If  
  220. Response.Write "<font class='contents'> 页次:</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> "  
  221. Response.Write "<font class='contents'> 共有"&totalnumber&"种商品 " 
  222. Response.Write "<font class='contents'>转到:</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="&currentpage&">"  
  223. Response.Write "&nbsp;<input type='submit'  class='contents' value='GO' name='cndok' ></form>"  
  224. End Function  
  225. %>
  226. <table width="12" height="7" border="0" cellpadding="0" cellspacing="0">
  227. <tr> 
  228. <td height=7></td>
  229. </tr>
  230. </table>
  231. </td>
  232. </form>
  233. </tr>
  234. </table>
  235. <table class="tableBorder" width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
  236. <tr>
  237.     <td align="center" background="../images/admin_bg_1.gif"><b><font color="#ffffff">缺货说明</font></b></td>
  238. </tr>
  239. <tr > 
  240. <form name="form2" method="post" action="outproduct.asp">
  241.       <td height="50"> 商品库存数为0时即为“已经缺货”;商品库存数少于5件但大于0为“即将缺货”。</td>
  242. </form>
  243. </tr>
  244. </table>
  245. <br>
  246. <!--#include file="foot.asp"-->
  247. </body>
  248. </html>
  249. <script>
  250. function test()
  251. {
  252.   if(!confirm('确认删除吗?')) return false;
  253. }
  254. </script>
  255. <script language=javascript>
  256. function mm()
  257. {
  258.    var a = document.getElementsByTagName("input");
  259.    if(a[0].checked==true){
  260.    for (var i=0; i<a.length; i++)
  261.       if (a[i].type == "checkbox") a[i].checked = false;
  262.    }
  263.    else
  264.    {
  265.    for (var i=0; i<a.length; i++)
  266.       if (a[i].type == "checkbox") a[i].checked = true;
  267.    }
  268. }
  269. </script>