leaving.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="Leaving.aspx.cs" Inherits="Leaving" Title="退房" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<%@ Register Src="WebUserControl.ascx" TagName="WebUserControl" TagPrefix="uc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cph_Content" runat="Server">
    <uc1:WebUserControl ID="WebUserControl1" runat="server" />
    <br />
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
<asp:GridView id="GridView1" runat="server" Width="700px" ForeColor="#333333" DataSourceID="ObjectDataSource1" AllowPaging="True" AutoGenerateColumns="False" CellPadding="4" OnDataBound="GridView1_DataBound" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" PageSize="12">
<FooterStyle BackColor="#2461BF" ForeColor="White" Font-Bold="True"></FooterStyle>
<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='<%# Eval("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" CloseImageUrl="~/Images/页面效果图/gif-0081.gif"
                                TargetControlID="RangeValidator1">
                            </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_EdState" runat="server" Text='<%#Eval("State")%>'></asp:Label>
                        
</EditItemTemplate>
<ItemTemplate>
                            <asp:Label ID="lbl_State" runat="server" Text='<%# Eval("State") %>'></asp:Label>
                        
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="描述"><EditItemTemplate>
                            <asp:Label ID="lbl_Description" runat="server" Text='<%#Eval("Description")%> '></asp:Label>&nbsp;
                        
</EditItemTemplate>

<ItemStyle Width="300px"></ItemStyle>
<ItemTemplate>
                            <asp:Label ID="Label6" runat="server" Text='<%#GetSubStr(Eval("Description")) %>'></asp:Label>
                        
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="退房" ShowHeader="False"><ItemTemplate>
<asp:Button id="btn_Leaving" runat="server" Width="50px" Text='退房' CssClass="input" __designer:wfdid="w6" CausesValidation="false" CommandName="" OnClientClick='<%#GetUrl(Eval("RoomId"))%>'></asp:Button> 
</ItemTemplate>
</asp:TemplateField>
</Columns>

<RowStyle BackColor="#EFF3FB" Font-Size="12px"></RowStyle>

<EditRowStyle BackColor="#FFC0FF" Font-Bold="True"></EditRowStyle>

<SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"></SelectedRowStyle>

<PagerStyle BackColor="White" ForeColor="#2461BF" HorizontalAlign="Center"></PagerStyle>

<HeaderStyle BackColor="White" ForeColor="#507CD1" CssClass="footerCss" Font-Bold="True"></HeaderStyle>

<AlternatingRowStyle BackColor="White"></AlternatingRowStyle>
</asp:GridView> <asp:ObjectDataSource id="ObjectDataSource1" runat="server" SelectMethod="GetRoomBySafeSql" TypeName="BLL.RoomOperatorBLL" __designer:wfdid="w1"><SelectParameters>
<asp:Parameter Type="String" DefaultValue="select RoomId,Number,BedNumber,SubString(Description,0,40) as Description,State,GuessNumber,TypeID from Room where State = '入住' order by Number" Name="sql"></asp:Parameter>
</SelectParameters>
</asp:ObjectDataSource> <asp:Timer id="Timer1" runat="server" __designer:wfdid="w1" OnTick="Timer1_Tick" Interval="2000"></asp:Timer> 
</ContentTemplate>
    </asp:UpdatePanel>
</asp:Content>