pro_del.asp

来自「房地产管理系统 vb写的,很不错!!!!!!!!!!!」· ASP 代码 · 共 270 行

ASP
270
字号
 
<!--#include file="../inc/conn.asp"--><%'┌─  风云ASP在线  ────────────────────────┐'│                                                                 │'│  作者:赵振波.	http://www.fyasp.com	    				    │'│                                                                 │'│   Q Q:176189168  										   	    │'│                                                                 │'│ Email:fy96@163.com                                             │'│                                                                 │'│ 程序定做,系统开发,网站制作,提供高质量的网络产品、技术和服务!│'│                                                                 │'│                                                                 │'└───────────────────  http://www.fyasp.com ──┘%>
<% 
     if instr(session("manager"),"manager")=0 then
     response.redirect "manage.asp"
     response.end
end if
%>
<html>
<!-- DW6 -->
<head>
<title>后台管理系统</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../ht.css" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>

<body bgcolor="#666666" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- ImageReady Slices (index.psd) -->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td><img src="../images/ht_01.gif" width=778 height=62 usemap="#Map" border="0"></td>
  </tr>
</table>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" background="../images/htbj.gif">
  <tr> 
    <td valign="top" align="left" width="145" height="395">
      <!--#include file="List.asp" -->
    </td>
    <td height="395" align="center" valign="top"> <br> <table width="621" border="0" cellspacing="0" cellpadding="0" height="98">
        <tr> 
          <td align="center" valign="top"> <table width="606" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="18"><img src="../images/httable_01.gif" width=606 height=17></td>
              </tr>
              <tr> 
                <td background="../images/httable_02.gif" height="34" align="center" valign="top"> 
                  <table width="600" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td> <hr noshade size="1"> </td>
                    </tr>
                  </table>
                  <script language="javascript">
<!--

function openwin(url)
 {
   window.open(url,"_blank","height=320,width=500,resizable=no,scrollbars=yes,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80");
 }
//-->
</script> &nbsp; <font color="#FFCC00">网上商城查看、修改、删除 </font></td>
              </tr>
              <tr> 
                <td background="../images/httable_02.gif" height="268" align="center" valign="top"><form name="form1" method="post" action="pro_del_ok.asp">
                    <table border="0" width="100%" cellspacing="1" cellpadding="0">
                      <tr bgcolor="#666666" class="p12"> 
                        <td width="4%" align="center">&nbsp;</td>
                        <td width="8%" height="22" align="center"><font color="#FFFFFF">类别</font></td>
                        <td width="50%" align="center"><font color="#FFFFFF">产品名称</font></td>
                        <td width="24%" align="center">发布用户</td>
                        <td width="14%" align="center"><font color="#FFFFFF">查看、修改</font></td>
                      </tr>
                      <%
					  opendataconn
              dim curpage
              if request.querystring("curpage")="" then
                 curpage=1
              else
                 curpage=request.querystring("curpage")
              end if
              const numperpage=15
              prtype=trim(request("prtype"))
              set rs=server.createobject("adodb.recordset")
              sql="select * from shopdetail "
			  if prtype<>""  then
			  sql=sql & " where prtype='"&prtype&"'"
			  end if

			  sql=sql & " order by dateandtime desc "
              rs.open sql,conn,1,1
            if not rs.eof then
            rs.pagesize=numperpage
            dim totalpages
            totalpages=rs.pagecount
            rs.absolutepage=curpage
            end if        
           dim count
           count=0
           do while not rs.eof and count<numperpage
              %>
                      <tr bgcolor="#868686" class="p12"> 
                        <td width="4%" align="center"> <input name="id" type="checkbox" class="mul" id="id4" value="<%=trim(rs("id"))%>"> 
                        </td>
                        <td width="8%" height="23" align="center"><%=rs("prtype")%></td>
                        <td width="50%" align="center"><%if trim(rs("ok"))="1" then response.write "<font color='#FFCC00'>★</font>" end if%> <%=rs("prname")%></td>
                        <td width="24%" align="center"><%=left(rs("userid"),12)%></td>
                        <td width="14%" align="center"><a href="pro_modi.asp?id=<%=rs("id")%>" target="_self">[修改]</a></td>
                      </tr>
                      <%
              rs.movenext       
                count=count+1
                loop
               rs.close
               set rs=nothing
              %>
                      <tr class="news"> 
                        <td height="50" colspan="5" align="center"><input type="submit" name="Submit4" value="删除所选信息"></td>
                      </tr>
                      <tr class="news"> 
                        <td height="50" colspan="5" align="center"> <span class="p12"> 
                          <% if cint(curpage)<>1 then %>
                          <a href="pro_del.asp?curpage=1&prtype=<%=prtype%>">首页&nbsp;</a> 
                          <% else %>
                          首页&nbsp; 
                          <% end if %>
                          <% if cint(curpage)>1 then %>
                          <a href="pro_del.asp?curpage=<%=curpage-1%>&prtype=<%=prtype%>">上一页&nbsp;</a> 
                          <% else %>
                          &nbsp;上一页 
                          <% end if %>
                          <% if cint(curpage)<>cint(totalpages) then %>
                          <a href="pro_del.asp?curpage=<%=curpage+1%>&prtype=<%=prtype%>">&nbsp;下一页 
                          <% else %>
                          &nbsp;下一页 
                          <% end if %>
                          <% if cint(curpage)<>cint(totalpages) then %>
                          </a><a href="pro_del.asp?curpage=<%=totalpages%>&prtype=<%=prtype%>">&nbsp;末页 
                          <% else %>
                          &nbsp;末页 
                          <% end if %>
                          </a>   第<font color="#FFCC00"><%=curpage%></font>页/共<%=totalpages%>页   
                          <select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
                            <option value="#" selected>请选择</option>
                            <option> 
                            <%
									  k=1
									  do while k<=totalpages
									  %>
                            </option>
                            <option> 
                            <%
									  k=1
									  do while k<=totalpages
									  %>
                            </option>
                            <option> 
                            <%
									  k=1
									  do while k<=totalpages
									  %>
                            </option>
                            <option value="pro_del.asp?curpage=<%=k%>&prtype=<%=prtype%>">第<%=k%>页</option>
                            <option> 
                            <%
									  k=k+1
									  loop
									  %>
                            </option>
                            <option> 
                            <%
									  k=k+1
									  loop
									  %>
                            </option>
                            <option> 
                            <%
									  k=k+1
									  loop
									  %>
                            </option>
                          </select>
                           </span>&nbsp;&nbsp;&nbsp;&nbsp; <div align="center"> 
                            <table width="437" border="0" cellspacing="0" cellpadding="0">
                              <tr> 
                                <td>&nbsp; </td>
                              </tr>
                            </table>
                          </div></td>
                      </tr>
                    </table>
                    <table width="331" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td height="21"> <div align="center">产品类别查询: 
                            <select name="menu2" onChange="MM_jumpMenu('parent',this,0)">
                              <option value="#" selected>按产品类别查询</option>
                              <option value="pro_del.asp?prtype=">全部产品类别</option>
                              <option>unnamed1</option>
                              <option value="pro_del.asp?prtype=<%=trim(ps("prtype"))%>"><%=trim(ps("prtype"))%></option>
                              <option> 
                              <%
							ps.movenext
							loop 
							ps.close
							set ps=nothing

							%>
                              </option>
                              <option> 
                              <%
							ps.movenext
							loop 
							ps.close
							set ps=nothing

							%>
                              </option>
                              <option> 
                              <%
							ps.movenext
							loop 
							ps.close
							set ps=nothing

							%>
                              </option>
                            </select>
                          </div></td>
                      </tr>
                    </table>
                  </form></td>
              </tr>
              <tr> 
                <td><img src="../images/httable_04.gif" width=606 height=19></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
</table>
<table width="778" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><img src="../images/ht_04.gif" width="778" height="4"></td>
  </tr>
</table>
<!-- End ImageReady Slices -->
<map name="Map">
  <area shape="rect" coords="630,36,775,56" href="http://www.fyasp.com" target="_blank">
</map>
</body>
</html>

⌨️ 快捷键说明

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