comself.asp

本学期要实讯

<!--#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;
	color: #6600FF;
}
.style2 {
	font-size: 12px;
	color: #666666;
}
.style4 {font-size: 12px; color: #666666; font-weight: bold; }
.style7 {font-size: 12px; color: #009900; }
.style8 {color: #FF3300}
-->
</style></head>
<%user=session("user")%>
<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 rsa,sqla
sqla="select comid from message where comid='"&user&"'and commessage<>'无'" 
set rsa=db.execute(sqla)
if rsa.bof and rsa.eof then %>
<table width="380" height="38" border="0" align="left" cellpadding="0" cellspacing="0">
      <tr>
        <td width="380" height="38" align="right"><span class="style1">对不起，没有符合你条件的信息！</span></td>
      </tr>
</table>
<%else%>
	<%dim rs,sql
sql="select * from message where comid='"&user&"'and commessage<>'无'order by com_date DESC "
set rs=db.execute(sql)
%>

    <table width="476" height="71" border="1" cellpadding="4" cellspacing="0" bordercolor="#6699FF" style="border-collapse:collapse ">
        <%do while not rs.eof %>
        <tr bgcolor="#CCCCCC">
          <td width="95" height="30" class="style1">录用者姓名：</td>
          <td width="199" height="30" class="style2"><%=rs("username")%> 
		  <%if rs("usermessage")<>"无" then %>
		  <span class="style8">[已回复]</span> 
		  <%end if%></td>
          <td width="150" height="30" class="style1">录用时间： <%=rs("com_date")%></td>
        </tr>
        <tr>
          <td height="34"><span class="style7">你录用信息：</span></td>
          <td colspan="2" class="style7"><%=rs("commessage")%></td>
        </tr><%rs.movenext
  loop%>
    </table>    <%end if%>
	</td>
  </tr>
</table>