room.asp

酒店管理系统

<!--#include file="../inc/conn.asp"-->
<!--#include file="checkpwd.asp"-->
<!--#include file="../inc/title.inc"-->
<style>
TD {
	FONT-SIZE: 9pt
; color: #000000
}
</style>
<table width="788" border="0" cellpadding="0" cellspacing="1">
  <!--DWLayoutTable-->
  <tr> 
    <td width="786" height="59">&nbsp;</td>
  </tr>
  <tr>
    <td height="422" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#3399FF">
        <!--DWLayoutTable-->
        <tr> 
          <td width="784" height="422" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
              <!--DWLayoutTable-->
              <tr> 
                <td height="23" colspan="2" align="center" valign="middle" bgcolor="#3333CC"><font color="#FFFFFF" face="楷体_GB2312"><strong>客房资料管理</strong></font></td>
              </tr>
              <tr> 
                <td width="620" height="17">&nbsp;</td>
                <td width="164">&nbsp;</td>
              </tr>
              <tr>
                <td height="16">&nbsp;</td>
                <td valign="top">
			<% if session("power")=1 then %>
				<a href="creatroom.asp">创建客房种类</a>
				<% else
				end if
				%>
				</td>
              </tr>
              <tr> 
                <td height="45" colspan="2" valign="top"> 
                  <%  set rs=server.CreateObject("adodb.recordset")
				  if request("action")="修改" then
				  sql="select * from room where id="&request("id")
				  rs.open sql,conn,1,1
		 %>
                  <form action="updateroom.asp" method="post" >
                    <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#3333CC">
                      <!--DWLayoutTable-->
                      <tr> 
                        <td height="20" colspan="4" valign="middle"  background="imgs/tile_sub.gif"><strong><font color="#FFFFFF">房间信息</font></strong></td>
                        <td width="210" valign="middle" align="center" background="imgs/tile_sub.gif"><font color="#FFFFFF">&nbsp;</font></td>
                      </tr>
                      <tr> 
                        <td width="181" height="20" align="center" valign="middle" bgcolor="#FFFFFF">房间分类：</td>
                        <td colspan="3" valign="top" bgcolor="#FFFFFF"><input name="roomlei" type="text" id="roomlei" value="<%=rs("roomnam")%>">
                          <input name="hiddenField" type="hidden" value="<%=rs("id")%>"></td>
                        <td rowspan="3" align="center" valign="middle" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell-->&nbsp;</td>
                      </tr>
                      <tr> 
                        <td height="20" align="center" valign="middle" bgcolor="#FFFFFF">房价：</td>
                        <td width="186" valign="top" bgcolor="#FFFFFF"><input name="roompice" type="text" id="roompice" value="<%=rs("pric")%>"></td>
                        <td width="35" valign="middle" align="center" bgcolor="#FFFFFF">总量</td>
                        <td width="166" valign="top" bgcolor="#FFFFFF"><input name="totnum" type="text" id="totnum" value="<%=rs("totnum")%>"></td>
                      </tr>
                      <tr> 
                        <td height="108" align="center" valign="middle" bgcolor="#FFFFFF">简介：</td>
                        <td colspan="3" valign="top" bgcolor="#FFFFFF"><textarea name="jianjie" cols="50" rows="6" id="jianjie"><%=rs("descrip")%></textarea></td>
                      </tr>
                      <tr bgcolor="#FFFFFF"> 
                        <td height="21" colspan="5" align="center" valign="middle"> 
                          <input type="submit" name="Submit" value="提交"> &nbsp; 
                          <input type="reset" name="Submit2" value="重置"> &nbsp;<a href="room.asp"> 
                          返回</a></td>
                      </tr>
                      <tr> 
                        <td height="2"></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                      </tr>
                    </table>
                  </form>
                  <% else %>
                  <!--这里开始-->
                  <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#6699FF" >
                    <!--DWLayoutTable-->
                    <tr> 
                      <td width="92" height="20" align="center" valign="middle" background="imgs/tile_sub.gif"><font color="#FFFFFF"><b>房间类型</b></font></td>
                      <td width="418" align="center" valign="middle" background="imgs/tile_sub.gif"><font color="#FFFFFF"><b>信息</b></font></td>
                      <td width="58" align="center" valign="middle" background="imgs/tile_sub.gif"><font color="#FFFFFF"><strong>价格</strong></font></td>
                      <td width="56" align="center" valign="middle" background="imgs/tile_sub.gif"><strong><font color="#FFFFFF">管理</font></strong></td>
                      <td width="56" align="center" valign="middle"background="imgs/tile_sub.gif"><font color="#FFFFFF"><strong>查看</strong></font></td>
                      <td width="47" valign="middle" align="center" bgcolor="#FFFFFF"background="imgs/tile_sub.gif"><strong><font color="#FFFFFF">创建</font></strong></td>
                    </tr>
                    <% rs.open "select * from room ",conn,1,1	
	             do while not rs.eof%>
                    <tr> 
                      <td height="23" align="center" valign="middle" bgcolor="#FFFFFF"><%=rs("roomnam")%></td>
                      <td align="center" valign="middle" bgcolor="#FFFFFF"><%=rs("descrip")%></td>
                      <td align="center" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("pric")%></font>元/天</td>
                      <td align="center" valign="middle" bgcolor="#FFFFFF"> 
                        <%  if session("power")=1 then %>
                        <a href="room.asp?action=修改&id=<%=rs("id")%>">修改</a> 
                        <%  else
					     end if
					   %>
                      </td>
                      <td align="center" valign="middle" bgcolor="#FFFFFF"> <a href="kefangxiangqing.asp?id=<%=rs("id")%>">详情</a> 
                      </td>
                      <td valign="middle" align="center" bgcolor="#FFFFFF"><font color="#000000"><strong> 
                        <%  if session("power")=1 then %>
                        <a href="chuanjinafj.asp?id=<%=rs("id")%>">房间</a> 
                        <%  else
					     end if
					   %>
                        </strong></font></td>
                    </tr>
                    <%	        
			rs.movenext
		    loop
			rs.close
			set rs=nothing
			%>
                  </table>
                  <!--这里开始-->
                  <% END IF %>
                </td>
              </tr>
              <tr> 
                <td height="26">&nbsp;</td>
                <td>&nbsp;</td>
              </tr>
              <tr> 
                <td height="220" valign="top"> </td>
                <td valign="top"></td>
              </tr>
              <tr> 
                <td height="51">&nbsp;</td>
                <td>&nbsp;</td>
              </tr>
              <tr> 
                <td height="30" colspan="2"  align="right" valign="top"bgcolor="#3333CC"><font color="#FFFFFF">2007-9</font></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="43">&nbsp;</td>
  </tr>
</table>