<!--#include file="../conn/conn2.asp" -->
<!--#include file="../conn/function.asp" -->
<!--#include file="member_check.asp" -->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>会员中心</title>
<style type="text/css">

			html {
				overflow:auto;
			}
			body {
			margin:0px;
				
				font-size:12px;
				line-height:180%;
				font-family:"微软雅黑";
				background:url(images/login_bgx.gif);
				
			}
a {text-decoration:none;color:#666;}
a:hover {color:#0099ff;}
a:focus {outline-style:none;}
			.input {border-top:1px solid #ABADB3;border-left:1px solid #ABADB3;border-right:1px solid #ddd;border-bottom:1px solid #ddd;height:24px;width:300px;padding:0 5px;}
.container{width:1100px; height:600px; position:absolute; top:50%; left:50%; margin-left:-550px; margin-top:-300px; background:#FFFFFF;box-shadow:0px 0px 20px #999999;}
.creat{height:150px; border:#CCC solid 3px; text-align:center; line-height:60px; color:#CCC; padding:30px 0 0 0; margin-top:20px;}

table{ border-collapse:collapse;}
table tr td{ border-bottom:1px solid #dedede; line-height:150%; padding:10px;}
</style>
</head>
<body>
<%
action=request.QueryString("action")
N_id=request.QueryString("N_id")

if action="del" then
conn.Execute ("delete from SL_news where N_id="&N_id)
call box("删除成功!","member_news.asp","success")
end if
%>
<div class="container">
<!--#include file="left.asp" -->
<div style="position: relative; padding:20px 20px 20px 220px;">
<div style="height:580px;overflow:auto">
<h2>我的投稿</h2>
<hr>
<table width="100%" bgcolor="#eeeeee">
<tr bgcolor="#F7F7F7"><td>文章标题</td><td>投稿时间</td><td>文章分类</td><td>审核</td><td>编辑</td><td>删除</td></tr>
<%
sql="select * from SL_news,SL_nsort where N_sort=S_id and N_author like '"&M_login&"' order by N_id desc"
set rs=Server.CreateObject("ADODB.RecordSet")
		rs.open sql,conn,1,1
		if not rs.eof then
		Do while Not rs.eof
		if rs("N_sh")=0 then
		sh_info="<font color='#009900'>已通过</font>"
		end if
		if rs("N_sh")=1 then
		sh_info="<font color='#ff0000'>未通过</font>"
		end if
		if rs("N_sh")=2 then
		sh_info="<font color='#ff9900'>未审核</font>"
		end if
		
		response.Write "<tr onmouseout='this.style.backgroundColor=""""' onmouseover='this.style.backgroundColor=""#F7F7F7""' bgcolor='#ffffff'><td>"&rs("N_title")&"</td><td>"&rs("N_date")&"</td><td>"&rs("S_title")&"</td><td>"&sh_info&"</td><td><a href='member_newsinfo.asp?N_id="&rs("N_id")&"'><img src='img/iconedit.gif'>编辑</td><td><a href='member_news.asp?action=del&N_id="&rs("N_id")&"'><img src='img/icondel.gif'>删除</td></a></tr>"
		rs.movenext
		loop
end if
rs.close
set rs=nothing
%>
</table>
<div class='creat'><a href='member_newsinfo.asp'><span style='font-size:100px;'>＋</span><br><span style='font-size:15px;'>我要投稿</span></a></div>

</div>
</div>
</div>
</body>
</html>