<%@ codepage ="936" %>
   <% 
	data_path="../../" 
	numid="51"
	dir="../err.asp" 
  %>
<!--#include file="../head.asp"-->
<!--#include file="../checkrole.asp"-->
 <SCRIPT language=javascript1.2 src="../../js/iXs_Main.js"></SCRIPT>
 <script>
 function retval(value)
	{
	var val=confirm(value);
	if(val)
	{ 
 	return true ;
	}
	else
	{
	 return false;
	}
 	}
 </script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TABLE width=778 border=0 align="center" cellPadding=0 cellSpacing=0>
  <TBODY>
  <TR>
    <TD vAlign=top align=center>

      <TABLE width=100% border=0 align="center" cellPadding=0 cellSpacing=0>
        <TBODY>
        <TR>
          <TD     style="BACKGROUND-POSITION: right 50%; BACKGROUND-IMAGE: url(../images/bg1.gif); BACKGROUND-REPEAT: repeat-y; BACKGROUND-COLOR: #ffffff"     vAlign=top align=middle>
      <BR>
      <TABLE cellSpacing=0 cellPadding=0 width=100% border=0>
        <TBODY>
        <TR>
              <TD width="74%"><IMG height=32 src="../images/editinfo.gif" width=576 
            border=0></TD>
              <TD width="26%" background="../images/info_bg.gif">&nbsp;</TD>
        </TR></TBODY></TABLE>
<%
	 
	sql="select * from websen_MembersNews where MembersName='"&request.Cookies("Yxmember")&"' order by flag desc"
	 set rs=server.createobject("adodb.recordset") 
	rs.open sql,conn,1,1 
	if rs.eof or rs.bof then 
%>
		<table width="100%" border="0" cellpadding="0" cellspacing="0" class="content_border">
		<tr> 
		<td align="center">
    <br>
    <table width="95%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td width="65%" class="C"> <font color="#FF0000">您暂未发布有效的新闻信息！</font><font color="#FF0000">&nbsp;</font></td>
    <td width="35%" align="right"><font color="#FF0000"><a href="<%=HOPE_InstallDir%>member/modify/Audit.asp"><img src="../images/postnewoffer.gif" width="123" height="26" border="0" align="absmiddle"></a></font></td>
    </tr>
    </table>
    <br>
    <BR>		</td>
		</tr>
		</table>
 <%
	else 
	msg_per_page=10 '定义每页显示记录条数
	rs.pagesize=msg_per_page '定义分页记录集每页显示记录数
	
	if not (rs.eof and rs.bof) then
		totalrec=RS.RecordCount'总记录条数
		if rs.recordcount mod msg_per_page=0 then'计算总页数,recordcount:数据的总记录数
			n=rs.recordcount\msg_per_page'n:总页数
		else
			n=rs.recordcount\msg_per_page+1                        
		end if                                                                
		currentpage=request("page")'currentpage:当前页
		If currentpage <> "" then
			currentpage =  cint(currentpage)
			if currentpage < 1 then  
				currentpage = 1
			end if  
			if err.number <> 0 then '错误处理
				err.clear
				currentpage=1
			end if
		else
			currentpage=1
		End if                                                                
		if currentpage*msg_per_page > totalrec and not((currentpage-1)*msg_per_page < totalrec)then 
			currentPage=1
		end if
		rs.absolutepage=currentpage 
		rowcount=rs.pagesize 
	end if
%>


<TABLE border=0 cellPadding=3 cellSpacing=1 align="center">
  <TBODY>
    <TR> 
      <TD height=40>
<%
	sql1="select count(Membersid) from websen_MembersNews where MembersName="&request.Cookies("Yxmember")&""
	set totle=conn.execute(sql1)
	totle4=totle(0)
	
	sql2="select count(Membersid) from websen_MembersNews where MembersName="&request.Cookies("Yxmember")&""
	set totle2=conn.execute(sql2)
	totle5=totle2(0)
	response.write"<b>您总共发布了"
	response.write"<font color='#ff0000'> "&totle4&"</font> 条供求信息，"
	response.write"已审核<font color='#ff0000'> "&totle5&"</font> 条，"
	response.write"尚未通过审核<font color='#ff0000'> "&(totle4-totle5)&"</font> 条。"
	
	totle.close
	set totle=nothing
	totle2.close 
	set totle2=nothing
%></td>
      </TR>
</TBODY>
</TABLE>
          <TABLE width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#111111" bordercolorlight="#D7EBFF" bordercolordark="#D7EBFF" style="border-collapse: collapse">
            <TR height=25 bgcolor="#e8f4ff"> 
              <TD align="center"><font color="#CC3300"><b>状态</b></font></TD>
              <TD align="center" bgcolor="#e8f4ff"><font color="#CC3300"><b>标题</b></font></TD>
              <TD align="center"><font color="#CC3300"><b>发布时间</b></font></TD>
              <TD align="center"><font color="#CC3300"><b>类型</b></font></TD>
              <TD width="138" align="center"><font color="#CC3300"><b>操作</b></font></TD>
            </TR>
            <%do while not rs.eof and rowcount > 0%>
            <TR height="20" bgcolor="#ffffff"> 
              <TD width="36" align="center"> <% if rs("flag")=1 then %> <font color="#666666">已审</font> <%else%> <font color="#FF0000">待审</font> <%end if%></td>
              <TD width="358" align="center">
			 <!-- <a href="http://192.168.0.103/info/shownews.asp?newsid=<%=rs("mark")%>" target="_blank"><%=rs("title")%></a><img src="../../images/haveimg.gif" alt="此条信息为图片标题：&lt;br&gt;&lt;img src=<%=HOPE_InstallDir%>Vipcom/<%=request.Cookies("Yxmember")%>/<%=rs("picture")%> border=1 width=220 height=150&gt;" width="12" height="12" border="0">-->
			 <%
			    if rs("flag")=1 then 
				  
				response.Write "<a href=../../info/shownews.asp?newsid="&rs("mark")&" target=_blank>" &rs("Title")&"</a>"
				
				%>
				<img src="../../images/haveimg.gif" alt="此条信息为图片标题：&lt;br&gt;&lt;img src=<%=HOPE_InstallDir%>UploadFile/<%=rs("picture")%> border=1 width=220 height=150&gt;" width="12" height="12" border="0">
				<%
				 else
				response.Write  rs("Title") %>
				<img src="../../images/haveimg.gif" alt="此条信息为图片标题：&lt;br&gt;&lt;img src=<%=HOPE_InstallDir%>UploadFile/<%=rs("picture")%> border=1 width=220 height=150&gt;" width="12" height="12" border="0">
				<%
				end if 
			 %>
			  
			  
			  </td>
              <TD width="98" align="center"> <%=FormatDate(rs("dateandtime"),2)%></td>
              <TD width="96" align="center"><%set rs5=server.CreateObject("adodb.recordset")
sql5="select typeid,type from Websen_newstype where typeid="&rs("typeid")
rs5.open sql5,conn,1,1
 if not rs5.eof then
response.write  rs5("type")&"类"
else
	Response.write "无些分类"
end if%></td>
              <TD align="center"><%if rs("flag")=0 then%><a href="delete.asp?id=<%=rs("newsid")%>" onClick="return retval('你确定要删除吗？此操作不可恢复的！');"> 删  除</a><%else%><font color="#666666">禁止删除</font><%end if%> </td>
              </TR>
<%
rowcount=rowcount-1
rs.movenext
loop
%>
          </TABLE>
<TABLE width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#111111" bordercolorlight="#D7EBFF" bordercolordark="#D7EBFF" style="border-collapse: collapse">
<TR height=25 bgcolor="#e8f4ff"> <td align=center><%=listPages("AuditShow.asp?")%></td></tr></table>
<BR><BR>

<%end if%>
            <BR>
            <table width="100%" 
              border=0 align="center" cellpadding=0 cellspacing=0 class=bdr1>
              <tbody>
                <tr>
                  <td height=103><table class=bdr2 cellspacing=0 cellpadding=0 width="100%" 
                  border=0>
                      <tbody>
                        <tr>
                          <td class=lh13 height=91><span 
                        class=M>特别提醒：</span><br>
                              <br>
                            1、为保证信息的真实性，您发布的供求信息并不会立即在网上发布：<br>
                            <br>
                            2、发布信息后，为保证客户及时与您联系，请确保您的联系信息（特别是电话、电子邮箱地址）准确无误。<br>
                            <br>
                            3、请勿一天内重复提交相同内容的信息，否则将不被审核通过。<br>
                            <br></td>
                        </tr>
                      </tbody>
                  </table></td>
                </tr>
              </tbody>
            </table>
            <BR>
            <BR>
    
        <BR><BR></TD></TR></TBODY></TABLE>
</TABLE>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>