housing.aspx

酒店管理 主要实现了基础设施管理（客房管理、客房类型管理）、业务管理（入住、退房、数据库切换） 本系统简单明了,适合初学者学习,采用三层加抽象工厂实现

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="Housing.aspx.cs" Inherits="Housing" Title="入住" %>

<%@ Register Src="WebUserControl.ascx" TagName="WebUserControl" TagPrefix="uc1" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cph_Content" runat="Server">
    <asp:ScriptManager id="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div style="width: 100px; height: 100px">
        <cc1:CollapsiblePanelExtender ID="CollapsiblePanelExtender1" runat="server"
            CollapseControlID="PanelExpand" Collapsed="True" CollapsedImage="~/Images/页面效果图/expand.jpg"
            CollapsedText="(显示搜索框....)" ExpandControlID="PanelExpand" ExpandedImage="~/Images/页面效果图/collapse.jpg"
            ExpandedText="(隐藏搜索框....)" ImageControlID="img_Collapse" TargetControlID="Panel_Search" TextLabelID="lbl_Title" SuppressPostBack="True">
        </cc1:CollapsiblePanelExtender>
        <asp:Panel ID="Panel_Search" runat="server" Height="0px" CssClass="collapsePanel">
            <br />
            <fieldset style="border-right: gray 1px solid; border-top: gray 1px solid; border-left: gray 1px solid;
                width: 400px; background-color: #ffffff">
                <legend>
                    <img alt="查找" height="46" src="Images/页面效果图/search.gif" style="vertical-align: middle"
                        title="Search" width="46" />『查找房间信息』</legend>请输入房间号:
                <asp:TextBox ID="txt_Numbers" runat="server" BackColor="WhiteSmoke" Font-Bold="True"
                    ForeColor="Blue"></asp:TextBox>
                &nbsp;
                <asp:ImageButton ID="imgBtn_Search" runat="server" ImageAlign="AbsBottom" ImageUrl="~/Images/页面效果图/gif-0225.gif"
                    OnClick="imgBtn_Search_Click1" /><br />
                <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" CompletionInterval="1400"
                    CompletionSetCount="6" DelimiterCharacters="" EnableCaching="False" MinimumPrefixLength="1"
                    ServiceMethod="GetData" ServicePath="../HotelManagerWeb/WebService.asmx" TargetControlID="txt_Numbers">
                </cc1:AutoCompleteExtender>
                <br />
            </fieldset>
        </asp:Panel>
        &nbsp;&nbsp;<asp:Panel ID="PanelExpand" runat="server" BorderColor="Gray"
            BorderWidth="1px" Height="26px" HorizontalAlign="Left"
            Width="698px" BackImageUrl="~/Images/页面效果图/bg-menu-main.png" CssClass="collapsePanelHeader">
            &nbsp;<asp:Label ID="Label5" runat="server" CssClass="image" Text="房间信息" Width="58px"></asp:Label>
            <asp:Label ID="lbl_Title" runat="server" Font-Italic="False"
                ForeColor="White" Width="592px" CssClass="image">(显示搜索框....)</asp:Label>
            <asp:Image ID="img_Collapse"
                    runat="server" CssClass="image" ImageAlign="AbsMiddle" /></asp:Panel>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
            CellPadding="4" DataSourceID="ObjectDataSource1" ForeColor="#333333" PageSize="12"
            Width="700px" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" OnDataBound="GridView1_DataBound" >
            <FooterStyle BackColor="#2461BF" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:TemplateField Visible="False">
                    <EditItemTemplate>
                        <asp:Label ID="lbl_RoomID" runat="server" Text='<%# Bind("RoomId") %>'></asp:Label>&nbsp;
                    </EditItemTemplate>
                    <ItemTemplate>
                        &nbsp;
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="房间号">
                    <EditItemTemplate>
                        <asp:Label ID="lbl_Number" runat="server" Text='<%#Eval("Number") %>'></asp:Label>&nbsp;
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("Number") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="房间类型">
                    <EditItemTemplate>
                        <asp:Label ID="lbl_TypeID" runat="server" Text='<%#Eval("TypeID")%>'></asp:Label>&nbsp;
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("TypeID") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="床位数">
                    <EditItemTemplate>
                        <asp:Label ID="lbl_BedNumber" runat="server" Text='<%#Eval("BedNumber")%>'></asp:Label>&nbsp;
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label4" runat="server" Text='<%# Bind("BedNumber") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="客人数">
                    <EditItemTemplate>
                        <asp:TextBox ID="txt_GuessNumber" runat="server" Text='<%# Bind("GuessNumber") %>'
                            ToolTip="入住人数" ValidationGroup="guess" Width="30px"></asp:TextBox>
                        &nbsp; &nbsp; &nbsp;
                        <asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="txt_GuessNumber"
                            Display="None" ErrorMessage='<font style="font-size:11px;color:blue;">入住人数应在<br/>1～100之间!!</font>' MaximumValue="100" MinimumValue="1"
                            Type="Integer" ValidationGroup="guess"></asp:RangeValidator>
                        <cc1:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" TargetControlID="RangeValidator1" CloseImageUrl="~/Images/页面效果图/gif-0081.gif">
                        </cc1:ValidatorCalloutExtender>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("GuessNumber") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="状态">
                    <EditItemTemplate>
                        &nbsp;<asp:Label ID="lbl_State" runat="server" Text='<%#Eval("State")%>'></asp:Label>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lbl_State" runat="server" Text='<%# Bind("State") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="描述">
                    <EditItemTemplate>
                        <asp:Label ID="lbl_Description" runat="server" Text='<%# GetSubStr(Eval("Description"))%> '></asp:Label>&nbsp;
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# GetSubStr(Eval("Description")) %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="住房" ShowHeader="False">
                    <EditItemTemplate>
                        <asp:Button ID="btn_Housing" runat="server" CssClass="input"
                             Text="入住" ToolTip="入住该房" ValidationGroup="guess"
                            Width="50px" OnClick="btn_Housing_Click" />
                    </EditItemTemplate>
                    <ControlStyle CssClass="input" />
                    <ItemTemplate>
                        <asp:Button ID="btn_readyHousing" runat="server" CausesValidation="False" CommandName="Edit"
                            CssClass="input" Text="住房" ToolTip="住房" Width="50px" />&nbsp;
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="取消" ShowHeader="False">
                    <ItemTemplate>
                        &nbsp;<asp:Button ID="btn_Cancel" runat="server" CausesValidation="false" CommandName="Cancel"
                            CssClass="input" Text="取消" ToolTip="取消更改" Width="50px" />&nbsp;
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <RowStyle BackColor="#EFF3FB" Font-Size="12px" />
            <EditRowStyle BackColor="#FFC0FF" Font-Bold="True" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle ForeColor="#2461BF" HorizontalAlign="Center" BackColor="White" />
            <HeaderStyle BackColor="White" Font-Bold="True" ForeColor="#507CD1" CssClass="footerCss" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetRoomBySafeSql"
            TypeName="BLL.RoomOperatorBLL">
            <SelectParameters>
                <asp:Parameter DefaultValue="select RoomId,Number,BedNumber,SubString(Description,0,40) as Description,State,GuessNumber,TypeID from Room where State = '空闲' and GuessNumber = 0 order by Number"
                    Name="sql" Type="String" />
            </SelectParameters>
        </asp:ObjectDataSource>
        &nbsp;
    </div>
</asp:Content>