adminarticle3_body.asp

来自「功能简介: 1) 首页投票调查系统 2）FLASH导航清新直观（带FLA源文件」· ASP 代码 · 共 187 行

<%sub adminarticle3_body()

sql="select a_s.s_id, a_s.cat_id ,a_s.s_name ,a_cat.cat_name,a_cat.cat_id as kk from a_s,a_cat where a_s.cat_id=a_cat.cat_id order by s_id DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
%>
<link rel="stylesheet" href="site_css.css" type="text/css">

<!--#include file="admintop.asp"-->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="3" bgcolor="#FFFFFF"></td>
  </tr>
</table>

<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td colspan="3" height="8" bgcolor="#FFFFFF"></td>
  </tr>
  <tr> 
    <td width="205" bgcolor="#FFFFFF" valign="top">
      <%call adminmenu()%>
    </td>
    <td width="1" background="images/dotlinev.gif"></td>
    <td width="554" bgcolor="#FFFFFF" valign="top" align="center"> 
      <table width="98%" border="0" cellspacing="1" cellpadding="8" bgcolor="#C4C4C4">
        <tr align="center" bgcolor="#E8E8E8"> 
          <td width="20%" class="chinese" background="images/pic000/c007.jpg"><a href="admin_article.asp">文章分类管理</a></td>
          <td class="chinese" width="20%" background="images/pic000/c007.jpg"><a href="admin_article2.asp">文章管理</a></td>
          <td class="chinese" width="20%" background="images/pic000/c007.jpg"><a href="admin_manartclass.asp?action=newartcat">新增二级分类</a></td>
          <td class="chinese" width="20%" background="images/pic000/c007.jpg"><a href="admin_manartclass.asp?">二级分类管理</a></td>
		  <td class="chinese" width="20%" background="images/pic000/c007.jpg"><a href="New_article.asp?action=newart">新增文章</a></td>
        </tr>
      </table>
      <table width="98%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="6"></td>
        </tr>
      </table>
      <table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
        <tr> 
          <td class="diaryhead" colspan="3" background="images/pic000/c005.jpg">
          <font color="#333333">二级分类管理</font></td>
        </tr>
        <tr align="center" bgcolor="#E8E8E8"> 
          <td width="10%" class="chinese" bgcolor="#F5F5F5">编号</td>
          <td width="70%" class="chinese" bgcolor="#F5F5F5">分类名称</td>
          <td width="20%" class="chinese" bgcolor="#F5F5F5">操作</td>
        </tr>
        <%do while not rs.eof%>
        <tr> 
          <td bgcolor="#FFFFFF" align="center" class="chinese"><%=rs("s_id")%>　</td>
          <td bgcolor="#FFFFFF" class="chinese"><a href="../xiaolei.asp?id=<%=rs("s_id")%>" target="_blank"><%=rs("s_name")%></a>--属于<%= rs("cat_name") %> </td>
          <td bgcolor="#FFFFFF" align="center" class="chinese"><a href="admin_manartclass.asp?id=<%=rs("s_id")%>&action=editartcat">edit</a> 
            <a href="admin_manartclass.asp?id=<%=rs("s_id")%>&action=delartcat">del</a> 
            <a href="../xiaolei.asp?id=<%=rs("s_id")%>" target="_blank">view</a></td>
        </tr>
        <%rs.movenext
loop
if rs.bof and rs.eof then%>
        <tr align="center"> 
          <td bgcolor="#FFFFFF" class="chinese" colspan="3">当前没有文章分类！</td>
        </tr>
        <%end if%>
      </table>
      <br>
	  <%if request.QueryString("action")="newartcat" then%>
      <table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
        <form name="form1" method="post" action="admin_manartclass.asp">
		<tr> 
            <td class="diaryhead" background="images/pic000/c005.jpg">
            <font color="#333333">新的文章分类</font></td>
        </tr>
        <tr> 
          <td bgcolor="#FFFFFF" class="chinese">分类名称-
              <input type="text" name="cat_name" size="40" class="textarea">
			  <% sql="select * from a_cat "
					set rs=server.createobject("adodb.recordset")
					rs.open sql,conn,1,3 
					
					
					%>
			  &nbsp;&nbsp;&nbsp;&nbsp;所属类-<select  name="class_name" class="textarea">
			  <% do while not rs.eof %>
			  <option value="<%=rs("cat_id") %>"><% =rs("cat_name") %></option>
			  <% rs.movenext
			  	loop
				%>
			  </select>
          </td>
        </tr>
        <tr> 
            <td bgcolor="#F5F5F5" align="center" height="30">
              <input type="submit" name="Submit" value="确定新增" >
              <input type="reset" name="reset" value="清空重写" >
              [<a href="admin_article.asp">返回</a>] </td>
        </tr>
		<input type="hidden" name="action" value="newartcat">
		<input type="hidden" name="MM_insert" value="true">
		</form>
      </table>
	  <%end if
	  if request.QueryString("action")="editartcat" then
	  if request.querystring("id")="" then
  errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
  call diserror()
  response.end
else
  if not isinteger(request.querystring("id")) then
    errmsg=errmsg+"<br>"+"<li>非法的新闻ID参数！"
	call diserror()
	response.end
  end if
end if
sql="select * from a_s where s_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
	  %>
      <table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
        <form name="form1" method="post" action="admin_manartclass.asp">
          <tr> 
            <td class="diaryhead" background="images/pic000/c005.jpg">
            <font color="#333333">修改二级分类</font></td>
          </tr>
          <tr> 
            <td bgcolor="#FFFFFF" class="chinese">分类名称- 
              <input name="cat_name" type="text" class="textarea" id="cat_name" size="40" value="<%=rs("s_name")%>"> 
            </td>
          </tr>
          <tr> 
            <td bgcolor="#F5F5F5" align="center" height="30"> <input name="Submit" type="submit"  id="Submit" value="确定修改"> 
              <input name="reset" type="reset"  id="reset" value="清空重写">
              [<a href="admin_article.asp">返回</a>] </td>
          </tr>
		  <input type="hidden" name="id" value="<%=rs("cat_id")%>">
		  <input type="hidden" name="action" value="editartcat">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
	  <%end if
	  	  if request.QueryString("action")="delartcat" then
	  if request.querystring("id")="" then
  errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
  call diserror()
  response.end
else
  if not isinteger(request.querystring("id")) then
    errmsg=errmsg+"<br>"+"<li>非法的新闻ID参数！"
	call diserror()
	response.end
  end if
end if
sql="select * from a_s where s_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
	  %>
      <table width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
        <form name="form1" method="post" action="admin_manartclass.asp">
          <tr> 
            <td class="diaryhead" background="images/pic000/c005.jpg">
            <font color="#333333">删除二级分类</font></td>
          </tr>
          <tr> 
            <td bgcolor="#FFFFFF" class="chinese">分类名称- <%=rs("s_name")%>
            </td>
          </tr>
          <tr> 
            <td bgcolor="#F5F5F5" align="center" height="30"> <input name="Submit" type="submit"  id="Submit" value="确定删除">
              [<a href="admin_manartclass.asp">返回</a>] </td>
          </tr>
          <input type="hidden" name="id" value="<%=rs("s_id")%>">
          <input type="hidden" name="action" value="delartcat">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
	  <%end if%>
      <br>
    </td>
  </tr>
  <tr> 
    <td colspan="3" height="1" background="images/dotlineh.gif"></td>
  </tr>
</table>
<%
rs.close
set rs=nothing
end sub%>