1<%...@ Page Language="C#"  Debug="true"MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SelectRoomInfo.aspx.cs" Inherits="SelectRoom" Title="无标题页" %>
  2
  3<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
  4    <style type="text/css">...
  5        .style21
  6        {...}{
  7            width: 100%;
  8        }
  9        .style28
 10    {...}{
 11        width: 96px;
 12    }
 13    .style31
 14    {...}{
 15            width: 110px;
 16        }
 17        .style34
 18        {...}{
 19            width: 87px;
 20        }
 21        .style35
 22        {...}{
 23            width: 88px;
 24        }
 25        .style36
 26    {...}{
 27        width: 100px;
 28    }
 29    </style>
 30</asp:Content>
 31<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 32    <asp:UpdatePanel ID="UpdatePanel2" runat="server">
 33        <ContentTemplate>
 34            <asp:MultiView ID="MultiView3" runat="server" ActiveViewIndex="0">
 35                <asp:View ID="View5" runat="server">
 36                    <table align="center" class="style21">
 37                        <tr>
 38                            <td align="right" class="style34">
 39                                房间类型：</td>
 40                            <td align="left" class="style28">
 41                                <asp:DropDownList ID="ddl" runat="server" DataSourceID="SqlDataSource2" 
 42                                    DataTextField="TypeName" DataValueField="TypeName">
 43                                </asp:DropDownList>
 44                            </td>
 45                            <td align="right" class="style35">
 46                                房间编号：</td>
 47                            <td align="left" class="style36">
 48                                <asp:TextBox ID="txtnumber" runat="server" Width="81px"></asp:TextBox>
 49                                &nbsp;</td>
 50                            <td class="style31">
 51                                <asp:LinkButton ID="LinkButton13" runat="server" ForeColor="Blue" 
 52                                    onclick="LinkButton13_Click">查询数据</asp:LinkButton>
 53                            </td>
 54                            <td class="style31">
 55                                &nbsp;&nbsp;&nbsp;&nbsp;<asp:LinkButton ID="LinkButton14" runat="server" ForeColor="Blue" 
 56                                    onclick="LinkButton14_Click">显示所有</asp:LinkButton>
 57                                &nbsp;</td>
 58                        </tr>
 59                        <tr>
 60                            <td align="right" class="style34">
 61                                &nbsp;</td>
 62                            <td align="left" class="style28">
 63                                &nbsp;</td>
 64                            <td align="right" class="style35">
 65                                &nbsp;</td>
 66                            <td align="left" class="style36">
 67                                &nbsp;</td>
 68                            <td class="style31">
 69                                &nbsp;</td>
 70                            <td>
 71                                &nbsp;</td>
 72                        </tr>
 73                        <tr>
 74                            <td colspan="6">
 75                                <asp:MultiView ID="MultiView4" runat="server">
 76                                    <br />
 77                                    <asp:View ID="View7" runat="server">
 78                                        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
 79                                            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="RoomID" 
 80                                            ForeColor="#333333" GridLines="None" 
 81                                            onpageindexchanging="GridView1_PageIndexChanging1" 
 82                                            onrowdatabound="GridView1_RowDataBound" onrowdeleting="GridView1_RowDeleting" 
 83                                            onselectedindexchanged="GridView1_SelectedIndexChanged1" PageSize="5" 
 84                                            SelectedIndex="0" Width="573px">
 85                                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
 86                                            <RowStyle BackColor="#EFF3FB" />
 87                                            <Columns>
 88                                                <asp:BoundField DataField="RoomID" HeaderText="编号" Visible="False" />
 89                                                <asp:BoundField DataField="Number" HeaderText="房间编号" SortExpression="Number" />
 90                                                <asp:BoundField DataField="TypeName" HeaderText="房间类型" 
 91                                                    SortExpression="TypeName" />
 92                                                <asp:BoundField DataField="BedNumber" HeaderText="床位数" 
 93                                                    SortExpression="BedNumber" />
 94                                                <asp:BoundField DataField="State" HeaderText="客房状态" SortExpression="State" />
 95                                                <asp:BoundField DataField="GuestNumber" HeaderText="入住人数" 
 96                                                    SortExpression="GuestNumber" />
 97                                                <asp:BoundField DataField="Description" HeaderText="客房描述" 
 98                                                    SortExpression="Description" />
 99                                                <asp:TemplateField>
100                                                    <ItemTemplate>
101                                                        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Select" 
102                                                            ForeColor="Blue" Text="编辑"></asp:LinkButton>
103                                                    </ItemTemplate>
104                                                </asp:TemplateField>
105                                                <asp:TemplateField>
106                                                    <ItemTemplate>
107                                                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="Delete" 
108                                                            ForeColor="Blue" onclientclick="return confirm('是否删除？');">删除</asp:LinkButton>
109                                                    </ItemTemplate>
110                                                </asp:TemplateField>
111                                                <asp:TemplateField>
112                                                    <ItemTemplate>
113                                                        <asp:LinkButton ID="LinkButton11" runat="server" CommandName="select" 
114                                                            ForeColor="Blue">详细</asp:LinkButton>
115                                                    </ItemTemplate>
116                                                </asp:TemplateField>
117                                            </Columns>
118                                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
119                                            <EmptyDataTemplate>
120                                                <asp:Label ID="Label1" runat="server" Text="没有查询到数据！"></asp:Label>
121                                                &nbsp;&nbsp;&nbsp;
122                                            </EmptyDataTemplate>
123                                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
124                                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
125                                            <EditRowStyle BackColor="#2461BF" />
126                                            <AlternatingRowStyle BackColor="White" />
127                                        </asp:GridView>
128                                    </asp:View>
129                                    <br />
130                                    <asp:View ID="View8" runat="server">
131                                        <asp:GridView ID="GridView2" runat="server" AllowPaging="True" 
132                                            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="RoomID" 
133                                            ForeColor="#333333" GridLines="None" 
134                                            onpageindexchanging="GridView2_PageIndexChanging" 
135                                            onrowdatabound="GridView2_RowDataBound" onrowdeleting="GridView2_RowDeleting" 
136                                            onselectedindexchanged="GridView2_SelectedIndexChanged" PageSize="5" 
137                                            SelectedIndex="0" Width="573px">
138                                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
139                                            <RowStyle BackColor="#EFF3FB" />
140                                            <Columns>
141                                                <asp:BoundField DataField="RoomID" HeaderText="编号" Visible="False" />
142                                                <asp:BoundField DataField="Number" HeaderText="房间编号" SortExpression="Number" />
143                                                <asp:BoundField DataField="TypeName" HeaderText="房间类型" 
144                                                    SortExpression="TypeName" />
145                                                <asp:BoundField DataField="BedNumber" HeaderText="床位数" 
146                                                    SortExpression="BedNumber" />
147                                                <asp:BoundField DataField="State" HeaderText="客房状态" SortExpression="State" />
148                                                <asp:BoundField DataField="GuestNumber" HeaderText="入住人数" 
149                                                    SortExpression="GuestNumber" />
150                                                <asp:BoundField DataField="Description" HeaderText="客房描述" 
151                                                    SortExpression="Description" />
152                                                <asp:TemplateField>
153                                                    <ItemTemplate>
154                                                        <asp:LinkButton ID="LinkButton3" runat="server" CommandName="Select" 
155                                                            ForeColor="Blue" Text="编辑"></asp:LinkButton>
156                                                    </ItemTemplate>
157                                                </asp:TemplateField>
158                                                <asp:TemplateField>
159                                                    <ItemTemplate>
160                                                        <asp:LinkButton ID="LinkButton4" runat="server" CommandName="Delete" 
161                                                            ForeColor="Blue" onclientclick="return confirm('是否删除？');">删除</asp:LinkButton>
162                                                    </ItemTemplate>
163                                                </asp:TemplateField>
164                                                <asp:TemplateField>
165                                                    <ItemTemplate>
166                                                        <asp:LinkButton ID="LinkButton12" runat="server" CommandName="select" 
167                                                            ForeColor="Blue">详细</asp:LinkButton>
168                                                    </ItemTemplate>
169                                                </asp:TemplateField>
170                                            </Columns>
171                                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
172                                            <EmptyDataTemplate>
173                                                <asp:Label ID="Label2" runat="server" Text="没有查询到数据！"></asp:Label>
174                                            </EmptyDataTemplate>
175                                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
176                                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
177                                            <EditRowStyle BackColor="#2461BF" />
178                                            <AlternatingRowStyle BackColor="White" />
179                                        </asp:GridView>
180                                    </asp:View>
181                                </asp:MultiView>
182                            </td>
183                        </tr>
184                    </table>
185                </asp:View>
186            </asp:MultiView>
187            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
188        ConnectionString="Data Source=.\Sql2005;Initial Catalog=Hotel;User ID=sa;pwd=sa" 
189        SelectCommand="SELECT [TypeName] FROM [RoomType]"></asp:SqlDataSource>
190        </ContentTemplate>
191</asp:UpdatePanel>
192    </asp:Content>
193
194