m_list.asp

房地产信息管理平台

      </td>
        <td width="1%" bgcolor="#FFFFFF"></td>     
        <td width="79%" bgcolor="#FFFFFF" valign="top"> 
          <table width="100%" cellspacing cellpadding>     
          <tr>     
            <td width="100%" height="10"></td>     
          </tr>     
          <tr>     
            <td width="100%">     
              <table width="100%" cellspacing cellpadding>     
                <tr>     
                    <td width="100%" height="25" style="background-image: url('../../images/<%=session("color")%>/resource.gif'); background-repeat: no-repeat">&nbsp;&nbsp;&nbsp;&nbsp; 
                      <font color="#000080">&nbsp;&nbsp;企业资源</font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                      &nbsp;查看会议室</td>       
                </tr>       
                <tr>  
                  <td width="100%" height="10"></td>       
                </tr>  
                <tr>  
                    <td width="100%" height="10"> 
                      <table width="100%" border="0" cellspacing="0" cellpadding="0" class="unnamed1">
                        <tr align="center"> 
                          <td> 
                            <table width="100%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolordark="#FFFFFF" bordercolorlight="#CCCCCC">
                              <tr> 
                                <td height="23" width="23%" class="L2"> 
                                  <div align="center"><b>会议室名</b></div>
                                </td>
                                <td height="23" width="40%" class="L2"> 
                                  <div align="center"><b>简要描述</b></div>
                                </td>
                                <td height="23" width="10%" class="L2"> 
                                  <div align="center"><b>状态</b></div>
                                </td>
                                <td height="23" width="10%" class="L2"> 
                                  <div align="center"><b>预定情况</b></div>
                                </td>
                                <td height="23" width="6%" class="L2"> 
                                  <div align="center"><b>预定</b></div>
                                </td>
                                <%if sort>=2 then%> 
                                <td height="23" width="6%" class="L2"> 
                                  <div align="center"><b>删除</b></div>
                                </td>
                                <%end if%> </tr>
                              <% if not rs1.eof then                                             
rs1.absoluteposition=(page-1)*rs1.pagesize+1            
for i=1 to rs1.pagesize                                                     
if rs1.eof then exit for                                                     
 %> 
                              <tr> 
                                <td width="23%" height="23" class="L2"> <%if rs1("name")<>"" then%> 
                                  <%=rs1("name")%> <%else%> &nbsp; <%end if%> 
                                </td>
                                <td width="40%" height="23" class="L2"><font title="<%=rs1("describe")%>"> 
                                  <%if rs1("describe")<>"" then%> <%=left(rs1("describe"),10)%>.. 
                                  <%else%> &nbsp; <%end if%> </font></td>
                                <td width="10%" height="23" class="L2"> <%set rs3=server.createobject("ADODB.Recordset")
rs3.Open "Select * from meeting_use where name='"&rs1("name")&"' and sign=1",source,3,3%> 
                                  <%k=0
do  while not rs3.eof 
b=datediff("h",now(),rs3("last_date"))
c=datediff("h",now(),rs3("first_date"))
if b>=0  and c<=0 then%>使用中<%k=1%> <%end if%> <%rs3.movenext
loop%> <%rs3.close%> <%if k=1 then%> &nbsp; <%else%> 空闲 <%end if%> </td>
                                <td width="10%" height="23" class="L2"><a href="m_orderlist.asp?name=<%=rs1("name")%>">查看</a></td>
                                <td width="6%" height="23" class="L2"><a href="m_order.asp?id=<%=rs1("id")%>">预定</a></td>
                                <%if sort>=2 then%> 
                                <td width="6%" height="23" class="L2"><a href="m_del.asp?id=<%=rs1("id")%>"><img src="images/delete.gif" width="13" height="13" border="0"></a></td>
                                <%end if%> </tr>
                              <%rs1.movenext                                                      
    next%> <%if rs1.recordcount<10 then   
  m=10-rs1.recordcount%> <%for i=1 to m%> 
                              <tr > 
                                <td width="23%" height="23" class="L2" > 
                                  <div align="left">&nbsp;</div>
                                </td>
                                <td width="40%" height="23" class="L2"> 
                                  <div align="left">&nbsp;</div>
                                </td>
                                <td width="10%" height="23" class="L2"> 
                                  <div align="left">&nbsp;</div>
                                </td>
                                <td width="10%" height="23" class="L2" > 
                                  <div align="center">&nbsp;</div>
                                </td>
                                <td width="6%" height="23" class="L2" > 
                                  <div align="center">&nbsp;</div>
                                </td>
                                <%if sort>=2 then%> 
                                <td width="6%" height="23" class="L2" > 
                                  <div align="center">&nbsp;</div>
                                </td>
                                <%end if%> </tr>
                              <%next   
end if%> <% else%> <%  for i=1 to 10%> 
                              <tr > 
                                <td width="23%" height="23"> 
                                  <div align="left">&nbsp;</div>
                                </td>
                                <td width="40%" height="23"> 
                                  <div align="left">&nbsp;</div>
                                </td>
                                <td width="10%" height="23"> 
                                  <div align="left">&nbsp;</div>
                                </td>
                                <td width="10%" height="23"> 
                                  <div align="center">&nbsp;</div>
                                </td>
                                <td width="6%" height="23"> 
                                  <div align="center">&nbsp;</div>
                                </td>
                                <%if sort>=2 then%> 
                                <td width="6%" height="23" > 
                                  <div align="center">&nbsp;</div>
                                </td>
                                <%end if%> </tr>
                              <%next   
end if%> 
                            </table>
                            <form name="form2" action="m_list.asp">
                              <table width="100%" class="L2">
                                <tr> 
                                  <td> 
                                    <div align="center"><%if page>1 then%> 
                                      <div align="center"><a href="m_list.asp?page=<%=page-1%>&amp;number=<%=number1%>&amp;yy1=<%=request("yy1")%>&amp;mm1=<%=request("mm1")%>&amp;dd1=<%=request("dd1")%>&amp;yy2=<%=request("yy2")%>&amp;mm2=<%=request("mm2")%>&amp;dd2=<%=request("dd2")%>&amp;sort=<%=request("sort")%>&amp;important=<%=request("important")%>&amp;belong=<%=request("belong")%>&amp;title=<%=request("title")%>&amp;expose=<%=request("expose")%>"><font color="#000000"><%end if%><img src="images/left_arrow.gif" width="6" height="10" border="0">上一页</font><%if page>1 then%></a> 
                                      </div>
                                      <%end if%></div>
                                  </td>
                                  <td><font color="#FF0000">页码[<%=page%>/<%=rs1.pagecount%>] 
                                    </font></td>
                                  <td> 
                                    <p>转到 
                                      <input type="text" name="page" size="3" class="input1" value="1" maxlength="3" onFocus=this.select() onMouseOver=this.focus()>
                                      页 
                                      <input type="image" border="0" name="Submit" src="../../images/i_button_15.gif" width="25" height="18">
                                      <input type="hidden" name="yy1" value="<%=request("yy1")%>">
                                    </p>
                                  </td>
                                  <td><%if page<rs1.pagecount then%> 
                                    <div align="center"><a href="m_list.asp?page=<%=page+1%>&amp;number=<%=number1%>&amp;yy1=<%=request("yy1")%>&amp;mm1=<%=request("mm1")%>&amp;dd1=<%=request("dd1")%>&amp;yy2=<%=request("yy2")%>&amp;mm2=<%=request("mm2")%>&amp;dd2=<%=request("dd2")%>&amp;sort=<%=request("sort")%>&amp;important=<%=request("important")%>&amp;belong=<%=request("belong")%>&amp;title=<%=request("title")%>&amp;expose=<%=request("expose")%>"><%end if%><font color="#000000">下一页<img src="images/right_arrow.gif" width="6" height="10" border="0"></font></a></div>
                                  </td>
                                </tr>
                              </table>
                            </form>
                          </td>
                        </tr>
                      </table>
                    </td>       
                </tr>  
              </table>        
            </td>        
          </tr>        

        </table>       
      </td>       
    </tr>   
  </table>   
  </center>   
</div>   
<div align="center">   
<!-- #include File=../../include/last2.asp -->
</div>        
        
</body>        
        
</html>