b_doapply1.asp

房地产信息管理平台

            <tr class="bgcolor2"> 
              <td></td>
              <td></td>
              <td><a href="../meeting/m_add.asp"><font color="#FFFFFF">&gt; 添加会议室</font></a></td>
            </tr>
            <tr class="bgcolor2"> 
              <td></td>
              <td></td>
              <td><a href="../office/o_pathlist.asp"><font color="#FFFFFF">&gt; 
                申请流程设定</font></a></td>
            </tr>
            <tr class="bgcolor2"> 
              <td></td>
              <td></td>
              <td align="left"><a href="../meeting/m_manage.asp"><font color="#FFFFFF">&gt; 
                管理会议室</font></a></td>
            </tr>
          <tr class="bgcolor4"> 
            <td colspan="3" height="80"></td>
          </tr>
        </table>
      </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" height="100%" bordercolorlight="#CCCCCC">
                        <tr valign="top"> 
                          <td> 
                            <table width="504" border="0" cellspacing="0" cellpadding="0" align="center" height="5">
                              <tr> 
                                <td height="5"></td>
                              </tr>
                            </table>
                            <map name="Map3"><area shape="rect" coords="315, 17, 365, 31" href="b_index.asp"><area shape="rect" coords="371,17,424,32" href="b_add1.asp"><area shape="rect" coords="427,16,480,33" href="b_doapply1.asp"></map> 
                            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="unnamed1">
                              <tr align="center"> 
                                <td> 
                                  <table border="1" cellspacing="0" cellpadding="0" bordercolordark="#ffffff"  width="100%" class="L2" align="center"  bordercolorlight="#CCCCCC">
                                    <tr> 
                                      <td> 
                                        <div align="center">编号</div>
                                      </td>
                                      <td width="34%"> 
                                        <div align="center">书名</div>
                                      </td>
                                      <td width="20%"> 
                                        <div align="center">出版社</div>
                                      </td>
                                      <td> 
                                        <div align="center">借者</div>
                                      </td>
                                      <td> 
                                        <div align="center">申请批准</div>
                                      </td>
                                      <td width="6%"> 
                                        <div align="center">还书</div>
                                      </td>
                                      <td width="6%"> 
                                        <div align="center">修改</div>
                                      </td>
                                      <td width="6%"> 
                                        <div align="center">删除</div>
                                      </td>
                                    </tr>
                                    <% if not rs.eof then                                             
rs.absoluteposition=(page-1)*rs.pagesize+1            
maxpage=rs.pagecount
for i=1 to rs.pagesize                                                     
if rs.eof then exit for                                                     
 %> <% if (i mod 2)=0 then%> 
                                    <tr ><%end if%> 
                                      <td width="8%" > 
                                        <div align="left"><%if rs("number")<>"" then%><%=rs("number")%><%else%>&nbsp;<%end if%></div>
                                      </td>
                                      <td width="34%"> 
                                        <div align="left" title="书名：<%=wrtsb(rs("name"))%>"><%=writek(rs("name"))%>&nbsp;</div>
                                      </td>
                                      <td width="20%"> 
                                        <div align="left"><%if rs("book_concern")<>"" then%><%=rs("book_concern")%><%else%>&nbsp;<%end if%></div>
                                      </td>
                                      <td width="9%" > 
                                        <div align="center"> <%sql4="select * from book_borrow where id='"&rs("id")&"' and sign=1"
    set rs4=server.createobject("ADODB.Recordset")
   rs4.Open sql4,source,3,3%> <%if not rs4.eof then%><%=rs4("borrow_man")%><%else%>&nbsp;<%end if%></div>
                                      </td>
                                      <td width="10%" > 
                                        <div align="center"> <%sql3="select * from book_borrow where id='"&rs("id")&"' and sign=0"
    set rs3=server.createobject("ADODB.Recordset")
   rs3.Open sql3,source,3,3%> <%if not rs3.eof then%> <a href="b_doapply.asp?id=<%=rs("id")%>" title="申请者<%=rs3("borrow_man")%>,请批准！！！！">已有申请</a> 
                                          <%else%> &nbsp; <%end if%></div>
                                      </td>
                                      <td width="6%"> 
                                        <div align="center"> <%if rs("borrow")<>0 then%> 
                                          <a href="b_return.asp?id=<%=rs("id")%>">还书</a> 
                                          <%else%> &nbsp; <%end if%></div>
                                      </td>
                                      <td width="6%"> 
                                        <div align="center"> <a href="b_modify.asp?id=<%=rs("id")%>">修改</a></div>
                                      </td>
                                      <td width="6%"> <% if sort>2 then %> 
                                        <div align="center"><font color="#000000"><a href="b_del.asp?id=<%=rs("id")%>"><img src="images/delete.gif" width="13" height="13" border="0" alt="删除此书（请在书籍被归还后再删除）"></a></font></div>
                                        <% else %>&nbsp;<% end if %> </td>
                                    </tr>
                                    <%rs.movenext                                                      
          next
rs.close
end if
%> 
                                  </table>
                                  <form name="form2" action="b_doapply1.asp">
                                    <table width="100%" class="L2">
                                      <tr> 
                                        <td> 
                                          <div align="center"><%if page>1 then%> 
                                            <a href="b_doapply1.asp?page=<%=page-1%>">上一页</a><% else %>上一页<% end if %></div>
                                        </td>
                                        <td><font color="#FF0000">页码[<%=page%>/<%=maxpage%>] 
                                          </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="hidden" name="yy1" value="<%=request("yy1")%>">
                                          </p>
                                        </td>
                                        <td><%if page<maxpage then%> 
                                          <div align="center"><a href="b_doapply1.asp?page=<%=page+1%>">下一页</a><% else %>下一页<% end if %></div>
                                        </td>
                                      </tr>
                                    </table>
                                  </form>
                                </td>
                              </tr>
                            </table>
                            <form name="form1" action="b_doapply1.asp">
                              <div align="right"> 
                                <input type="text" name="search" onFocus=this.select() onMouseOver=this.focus() class="input4">
                                <input type="image" border="0" name="search1" src="../../images/i_button_11.gif" width="37" height="18">
                              </div>
                            </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>