usercom.asp

本学期要实讯

<% option explicit %>
<!--#include file="odbc_connection.asp"-->
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style1 {
	font-size: 12px;
	font-weight: bold;
	color: #333333;
}
.style4 {font-size: 12px; color: #6600FF; }
.style8 {color: #666666; font-size: 12px; }
.style9 { font-size: 12px; color: #FF3300}
-->
</style>
<link href="css/css2.css" rel="stylesheet" type="text/css">
<br>
<span class="style4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;以 下 是 公 司 录 用 你 的 信 息</span><br>
<br><table width="535" height="171" border="0" cellpadding="2" cellspacing="0">
  <tr>
    <td width="531" align="center" valign="top">
<%dim user
user=session("user")
dim rsb,sqlb
sqlb="select userid from message where userid='"&user&"'and commessage<>'无'" 
set rsb=db.execute(sqlb)
if rsb.bof and rsb.eof then %>
<table width="356" height="38" border="0" align="left" cellpadding="0" cellspacing="0">
      <tr>
        <td width="356" height="38" align="right"><span class="style8">对不起，暂时没有符合你条件的信息！</span></td>
      </tr>
</table>
<%else%>

<% 
dim rsa,sqla
sqla="select * from userinfo where user='"&user&"'" 
set rsa=db.execute(sqla)
dim userid
userid=rsa("name")
%>
<% dim rs,sql
  sql="select * from message where userid='"&user&"' and commessage<>'无'order by user_date DESC"
  set rs=db.execute(sql)
  %>
<table width="469" height="95" border="1" cellpadding="2" cellspacing="0" bordercolor="#6699FF" style="border-collapse:collapse ">
      <%do while not rs.eof %>
      <tr align="center">
        <td height="30" align="left" bgcolor="#CCCCCC"><table width="446" height="18" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td width="61" height="18" valign="bottom"><span class="style4">公司名称：</span></td>

              <td width="261" class="a1"><span class="style8"><a href="usercom1.asp?comid=<%=rs("id")%>&user=<%=rs("comid")%>"><%=rs("comname")%></a></span>
	<% if rs("usermessage")<>"无" then%>
	<span class="style8">已回复&nbsp;<%=rs("user_date")%></span>
	<%else%>
	<span class="style9">未回复</span>
	<%end if%>
			  </td>
              <td width="7"></td>
              <td width="117"><span class="style4">发布时间 <span class="style8"><%=rs("com_date")%></span></span></td>
            </tr>
        </table></td>
      </tr>
      <tr align="center">
        <td height="34" align="left"><span class="style8"><%=rs("commessage")%></span></td>
      </tr>
      <%rs.movenext
  loop%>
    </table>
<%end if%>
	</td>
  </tr>
</table>