📄 sendmessagelist.asp
字号:
<!--#include file="../head.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TABLE cellSpacing=0 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD vAlign=top align=middle width=150>
<SCRIPT LANGUAGE='JavaScript' SRC='../images/left.js' TYPE='text/javascript'></script>
<TABLE cellSpacing=0 cellPadding=0 width=150 border=0>
<TBODY>
<TR>
<TD vAlign=top align=middle width=150
background=../images/leftmanu_bg.gif>
<TABLE cellSpacing=0 cellPadding=0 width=150 border=0>
<TBODY>
<TR>
<TD width=150
background=../images/leftmanu_topbg.gif><IMG height=30
src="../images/leftmanu_top.gif"
width=150></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=150 border=0>
<TBODY>
<TR>
<TD class=leftmenu1
onclick="location.href='../index.asp'"><IMG
height=18 src="../images/leftmanu_home.gif" width=16
align=absMiddle> 商务助手首页</TD></TR><TR>
<TD class=leftmenu1
onclick=javascript:menu_display(table1,img1);><IMG id=img1
height=16 src="../images/fold_2.gif" width=16
align=absMiddle> 发布商业信息</TD></TR>
<TBODY id=table1><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../tradeinfo/add_info.asp">发布供求信息</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../tradeinfo/edit.asp">管理供求信息</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../productshow/add_product.asp">发布产品信息</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../productshow/edit.asp">管理产品信息</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../corporation/company_edit.asp">公司介绍</A> </TD>
</TR></TBODY>
<TBODY>
<TR>
<TD class=leftmenu1 onclick=menu_display(table2,img2)><IMG
id=img2 height=16 src="../images/fold_2.gif" width=16
align=absMiddle> 查看商业往来</TD></TR>
<TBODY id=table2><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="receivemessagelist.asp">我收到的留言</A> </TD>
</TR>
<TR>
<TD class=leftmenu3 height=29><IMG src="../images/minus.gif">
<A
class=linkstyle3
href="sendmessagelist.asp"><STRONG>我发出的留言</STRONG></a> <IMG src="../images/now.gif"></TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="sendnewmessage.asp">发新留言</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../myemail/index.asp">我订阅的信息</A></TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../myfriend/index.asp">我的商业伙伴</A> </TD>
</TR></TBODY>
<TR>
<TD class=leftmenu1 onclick=menu_display(table3,img3)><IMG
id=img3 height=16 src="../images/fold_1.gif" width=14
align=absMiddle> 我的会员资料</TD>
</TR>
<TBODY id=table3 style="DISPLAY: none"><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../modify/modify_info.asp">修改注册信息</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../modify/modify_pass.asp">修改密码</A> </TD>
</TR><!-- 正常情况下 -->
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../modify/modify_mine.asp">修改个人简介</A> </TD>
</TR></TBODY>
<TR>
<TD class=leftmenu1 onclick=menu_display(table4,img4)><IMG
id=img4 height=16 src="../images/fold_1.gif" width=14
align=absMiddle> 我的自助网站</TD>
</TR>
<TBODY id=table4 style="DISPLAY: none">
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../corporation/webmod.asp">网站模板选择</A></TD>
</TR>
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../corporation/cimg_add.asp?id=<%=session("id")%>">上传营业执照</A> </TD>
</TR>
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../feedback/contact_edit.asp?id=<%=session("id")%>">客户反馈管理</A></TD>
</TR>
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../work/work.asp">发布招聘信息</A></TD>
</TR>
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../work/edit.asp">管理招聘信息</A></TD>
</TR>
<TR>
<TD class=leftmenu2><IMG src="../images/plus.gif"> <A
class=linkstyle2
href="../../companyweb.asp"
target=_blank>浏览我的网站</A></TD>
</TR></TBODY>
<TBODY>
<TR>
<TD class=leftmenu1
onclick="javascript:window.open('../../help/index.asp')"><IMG
id=img5 src="../images/leftmenu_help.gif"
align=absMiddle> 帮助</TD></TR></TBODY></TABLE>
<IMG height=6
src="../images/leftmanu_bottom.gif" width=150><BR><BR>
<!--#include file="../guestsubmit.asp"-->
<BR><BR></TD></TR>
</TABLE><BR><BR><BR></TD>
<TD
style="BACKGROUND-POSITION: right 50%; BACKGROUND-IMAGE: url(../images/bg1.gif); BACKGROUND-REPEAT: repeat-y; BACKGROUND-COLOR: #ffffff"
vAlign=top align=middle width=628>
<TABLE cellSpacing=0 cellPadding=0 width=628 border=0>
<TBODY>
<TR>
<TD width=459><IMG height=30
src="../images/leftmanu_top1.gif" width=459></TD>
<TD vAlign=top width=141
background=../images/top_nav_bg2.gif></TD>
<TD width=28><IMG height=30 src="../images/top_nav_5.gif"
width=28></TD></TR></TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=0 width=578 border=0>
<TBODY>
<TR>
<TD><IMG height=32 src="../images/myoutbox.gif" width=578
border=0></TD>
</TR></TBODY></TABLE>
<%
sendcid=session("id")
set rs=server.createobject("adodb.recordset")
'sql="select * from getprice1 where sendcid="&sendcid&" order by ID desc"
sql="select getprice1.*,corporation.qymc from getprice1,corporation where getprice1.sendcid="&sendcid&" and corporation.id=getprice1.mycid order by getprice1.id desc"
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.write "<p align='center'>对不起，没有您要查询的信息</p>"
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'absolutepage：设置指针指向某页开头
rowcount=rs.pagesize'pagesize：设置每一页的数据记录数
end if
if not isempty(request("selAnnounce")) then
idlist=request("selAnnounce")
if instr(idlist,",")>0 then
idArr=split(idlist)
for i = 0 to ubound(idarr)
id=cint(idarr(i))
call deleteannounce(id)
next
response.Redirect"sendmessagelist.asp?page="¤tpage&""
else
call deleteannounce(cint(idlist))
response.Redirect"sendmessagelist.asp?page="¤tpage&""
end if
end if
%>
<Form name="form1" method="POST" action="">
<TABLE width="578" border="1" cellpadding="4" cellspacing="0" bordercolor="#111111" bordercolorlight="#D7EBFF" bordercolordark="#D7EBFF" style="border-collapse: collapse">
<TBODY>
<TR height=25 bgcolor="#e8f4ff">
<TD align="center"><font color="#Ff6600"><b>状态</b></font></TD>
<TD align="center"><font color="#Ff6600"><b>标题</b></font></TD>
<TD align="center"><font color="#Ff6600"><b>发给</b></font></TD>
<TD align="center"><font color="#FF6600"><b>时间</b></font></TD>
<TD width="40" align="center"><input type='submit' value='删除'></TD>
</TR>
<%do while not rs.eof and rowcount > 0%>
<TR height="20" bgcolor="#ffffff">
<TD width="63" align="center">
<%
if rs("sendFlag")=true then %>
<font color="#666666">对方已读</font>
<%else%>
<font color="#FF0000">对方未读</font>
<%end if%>
</td>
<TD width="210" align="center"><a title="<%=rs("title")%>" href="readmessage1.asp?id=<%=rs("id")%>"><%=rs("title")%></a> </td>
<TD width="171" align="center"><%=rs("qymc")%></td>
<TD width="64" align="center"><%=rs("datetime")%></td>
<TD width="40" align="center"><input type='checkbox' name='selAnnounce' value='<%=cstr(rs("ID"))%>'></td>
</TR>
<%
rowcount=rowcount-1
rs.movenext
loop
%>
</TABLE>
<TABLE width="578" border="1" cellpadding="4" cellspacing="0" bordercolor="#111111" bordercolorlight="#D7EBFF" bordercolordark="#D7EBFF" style="border-collapse: collapse">
<TR height=25 bgcolor="#e8f4ff"> <td><%call listPages()%></td></tr></table>
<BR><BR>
</form>
<%end if%>
</TABLE>
<%
sub deleteannounce(id)
'dim rs,sql
sql="delete from [getprice1] where sendcid="&sendcid&" and id="&id&""
conn.execute sql
if err.Number<>0 then
err.clear
response.write "删 除 失 败 !<br>"
end if
End sub
sub listPages()
if not (rs.eof and rs.bof) then
gopage=currentpage
totalpage=n
blockPage=Int((gopage-1)/10)*10+1
if blockPage = 1 Then
Response.Write "<span disabled>【←前10页</span> "
Else
Response.Write("<span disabled>【</span><a href=sendmessagelist.asp?page="&blockPage-10&">←前10页</a> ")
End If
i=1
Do Until i > 10 or blockPage > n
If blockPage=int(gopage) Then
Response.Write("<font color=#FF0000>[<b>"&blockPage&"</b>]</font>")
Else
Response.Write("<a href=sendmessagelist.asp?page="&blockPage&">["&blockPage&"]</a>")
End If
blockPage=blockPage+1
i = i + 1
Loop
if blockPage > totalpage Then
Response.Write " <span disabled>后10页→】"
Else
Response.Write(" <a href=sendmessagelist.asp?page="&blockPage&">后10页→</a><span disabled>】")
End If
Response.Write(" 共"&n&"页 每页"&msg_per_page&"条记录 共"&totalrec&"条记录")
end if
end sub
%>
<IMG
height=10 src="../images/bottom.gif" width=778><BR>
<!--#include file="../end.asp"-->
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -