usermanage.asp

本源代码为大学生购物网的源代码,欢迎大家的下载,学习与交流

<!--#include file="usertop.asp"-->

<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr> 
 <!--#include file="left.asp"-->
          <TD vAlign=top width=2 bgColor=#FFcc66></td>
  <td bgcolor="#FFFFFF" valign="top">

<%
Select case Request("method")
	Case 1
		Call Delarticle()
	Case 2
		Call DelAll()
	Case 3
		Call ResumeArticle()
	Case 4 
		Call ResumeAll()
End Select


	'-----修改每页显示个数 Start--------
	const MaxPerPage=10
	'-----修改每页显示个数 End  --------
   	dim totalPut
   	dim CurrentPage
	if not isempty(request("page")) then
      		currentPage=cint(request("page"))
   	else
      		currentPage=1
   	end if
%>
<div align="center">
<table width="95%" border="0" cellspacing="1" cellpadding="3" bgcolor="#FFCC66">
  <tr> 
    <td colspan="7" align="center" height="30" bgcolor="#FFFFFF"><b>二 手 管 理</b> </td>
  </tr>
  <tr align="center"> 
    <td height="25" bgcolor="#FFFFFF">ID</td>
    <td bgcolor="#FFFFFF">操作</td>
    <td bgcolor="#FFFFFF">所属类别</td>
    <td bgcolor="#FFFFFF">标题</td>

    <td bgcolor="#FFFFFF">发布时间</td>
  </tr>
  <tr>
    <td height="25" colspan="6" bgcolor="#FFFFFF"> <%
	u_id = session("user_id")
	set rs=server.createobject("adodb.recordset")
	Sql = "Select * from 2s_list  where u_id="&u_id&" order by Intime desc"
	rs.open sql,conn,1,1
 	if rs.eof and rs.bof then
		Response.Write "<center><font color=red>还没有二手信息。</font></center>"
	else
		totalPut=rs.recordcount
      		if currentpage<1 then
          		currentpage=1
      		end if
      		if (currentpage-1)*MaxPerPage>totalput then
	   		if (totalPut mod MaxPerPage)=0 then
	     			currentpage= totalPut \ MaxPerPage
	  		else
	      			currentpage= totalPut \ MaxPerPage + 1
	   		end if
      		end if
       		if currentPage=1 then
           		showpage totalput,MaxPerPage,"user.asp"
            		showContent
            		showpage totalput,MaxPerPage,"user.asp"
       		else
          		if (currentPage-1)*MaxPerPage<totalPut then
            			rs.move  (currentPage-1)*MaxPerPage
            			dim bookmark
            			bookmark=rs.bookmark
           			showpage totalput,MaxPerPage,"user.asp"
            			showContent
             			showpage totalput,MaxPerPage,"user.asp"
        		else
	        		currentPage=1
           			showpage totalput,MaxPerPage,"user.asp"
           			showContent
           			showpage totalput,MaxPerPage,"user.asp"
	      		end if
	   		end if
		rs.close
		set rs = nothing	
   	end if 
	sub showContent
	dim i 
	   	i=0
	%> 
    </td>
  </tr>
  <form action="" name="form1" method="post">
    <%do while not rs.eof%>
    <tr> 
      <td height="25" align="center" bgcolor="#FFFFFF"><%=rs(0)%></td>
      <td height="25" align="center" bgcolor="#FFFFFF"><input type="checkbox" name="newsid" value="<%=rs(0)%>"></td>
      <td height="25" align="center" bgcolor="#FFFFFF"><%=Qcdn.Classlistrs(rs("classid"))%></td>
      <td height="25" bgcolor="#FFFFFF"><a href="useredit.asp?Unid=<%=rs(0)%>"><%=Qcdn.HTMLcode(rs("title"))%></a> </td>

      <td height="25" align="center" bgcolor="#FFFFFF"><%=rs("Intime")%></td>
    </tr>
    <%
  i=i+1
	      if i>=MaxPerPage then exit do
  rs.movenext
  loop
  %>
    <tr> 
      <td height="25" colspan="6" bgcolor="#FFFFFF">管理操作：全部选择 
        <input type="checkbox" name="chkall" onClick="javascript:CheckAll(this.form)"> 
        <input onClick="{if(confirm('将彻底被删除\n\n你确认吗?')){this.document.form1.submit();return true;}return false;};document.form1.method.value='1'" type=submit value=删除 name=action class=input2>
        &nbsp; 
        <input type="hidden" name="method" value="1"></td>
    </tr>
  </form>
  <tr> 
    <td height="25" colspan="6" bgcolor="#FFFFFF"> <%
   end sub 

	function showpage(totalnumber,maxperpage,filename)
  	dim n

  	if totalnumber mod maxperpage=0 then
     		n= totalnumber \ maxperpage
  	else
     		n= totalnumber \ maxperpage+1
  	end if
  	response.write "<table cellspacing=1 width='100%' border=0 colspan='4' ><form method=Post action="""&filename&"""><tr><td align=right> "
  	if CurrentPage<2 then
    		response.write "共<b><font color=red>"&totalnumber&"</font></b>篇&nbsp;首页 上一页&nbsp;"
  	else
    		response.write "共<b><font color=red>"&totalnumber&"</font></b>篇&nbsp;<a href="&filename&"?page=1>首页</a>&nbsp;"
    		response.write "<a href="&filename&"?page="&CurrentPage-1&">上一页</a>&nbsp;"
  	end if

  	if n-currentpage<1 then
    		response.write "下一页 尾页"
  	else
    		response.write "<a href="&filename&"?page="&(CurrentPage+1)&">"
    		response.write "下一页</a> <a href="&filename&"?page="&n&">尾页</a>"
  	end if
   	response.write "&nbsp;页次：<strong><font color=red>"&CurrentPage&"</font>/"&n&"</strong>页 "
    	response.write "&nbsp;<b>"&maxperpage&"</b>条信息/页 "
%>
      转到： 
      <select name='page' size='1' style="font-size: 9pt" onChange='javascript:submit()'>
        <%for i = 1 to n%>
        <option value='<%=i%>' <%if CurrentPage=cint(i) then%> selected <%end if%>>第<%=i%>页</option>
        <%next%>
      </select> <%   
	response.write "</td></tr></FORM></table>"
end function

Sub Delarticle()
	if Request("newsid") = "" then
		Errmsg = "<li>请勾选你要删除的。"
		call Qcdn.Err_List(errmsg,1)
		Response.end
	end if
	newsid = Request("newsid")
	sql = "Delete from 2s_list where s_id in ("& newsid &")"
	conn.execute(sql)
	Response.Write("<script>alert(""删除成功"");location.href=""user.asp"";</script>")
	Response.End()
End Sub


%> </td>
  </tr>
</table></td>
  </tr>
</table>

<!--#include file="copy.asp"-->