companyform.aspx

一个关于宾馆酒店管理系统的源代码

<%--文件名:CompanyForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="CompanyForm.aspx.cs" Inherits="System_CompanyForm" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table>
        <tr>
            <td colspan="1" style="font-size: 0.8em; width: 64px; font-family: 宋体;" rowspan="3">
            </td>
            <td colspan="3" style="font-size: 0.8em; font-family: 宋体; height: 21px; width: 412px;">
                <asp:Label ID="Label1" runat="server" Text="请输入酒店名称："></asp:Label>
                <asp:TextBox ID="TextBox1" runat="server" Width="161px">有限公司</asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="查询酒店信息" Width="122px" /></td>
            <td colspan="1" style="font-size: 0.8em; width: 50px; font-family: 宋体;" rowspan="2">
            </td>
        </tr>
        <tr>
            <td colspan="3" style="width: 412px">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
                    DeleteCommand="DELETE FROM [酒店信息] WHERE [酒店名称] = @酒店名称" InsertCommand="INSERT INTO [酒店信息] ([酒店名称], [法人代表], [酒店地址], [邮政编码], [服务电话], [电子邮件], [酒店网站], [首页图像], [标志图标], [系统名称], [优先级]) VALUES (@酒店名称, @法人代表, @酒店地址, @邮政编码, @服务电话, @电子邮件, @酒店网站, @首页图像, @标志图标, @系统名称, @优先级)"
                    ProviderName="<%$ ConnectionStrings:MyHotelDBConnectionString.ProviderName %>"
                    SelectCommand="SELECT [酒店名称], [法人代表], [酒店地址], [邮政编码], [服务电话], [电子邮件], [酒店网站], [首页图像], [标志图标], [系统名称], [优先级] FROM [酒店信息] WHERE ([酒店名称] LIKE '%' + @酒店名称 + '%')"
                    UpdateCommand="UPDATE [酒店信息] SET [法人代表] = @法人代表, [酒店地址] = @酒店地址, [邮政编码] = @邮政编码, [服务电话] = @服务电话, [电子邮件] = @电子邮件, [酒店网站] = @酒店网站, [首页图像] = @首页图像, [标志图标] = @标志图标, [系统名称] = @系统名称, [优先级] = @优先级 WHERE [酒店名称] = @酒店名称">
                    <DeleteParameters>
                        <asp:Parameter Name="酒店名称" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="法人代表" Type="String" />
                        <asp:Parameter Name="酒店地址" Type="String" />
                        <asp:Parameter Name="邮政编码" Type="String" />
                        <asp:Parameter Name="服务电话" Type="String" />
                        <asp:Parameter Name="电子邮件" Type="String" />
                        <asp:Parameter Name="酒店网站" Type="String" />
                        <asp:Parameter Name="首页图像" Type="String" />
                        <asp:Parameter Name="标志图标" Type="String" />
                        <asp:Parameter Name="系统名称" Type="String" />
                        <asp:Parameter Name="优先级" Type="Int32" />
                        <asp:Parameter Name="酒店名称" Type="String" />
                    </UpdateParameters>
                    <SelectParameters>
                        <asp:ControlParameter ControlID="TextBox1" DefaultValue="扬子江" Name="酒店名称" PropertyName="Text"
                            Type="String" />
                    </SelectParameters>
                    <InsertParameters>
                        <asp:Parameter Name="酒店名称" Type="String" />
                        <asp:Parameter Name="法人代表" Type="String" />
                        <asp:Parameter Name="酒店地址" Type="String" />
                        <asp:Parameter Name="邮政编码" Type="String" />
                        <asp:Parameter Name="服务电话" Type="String" />
                        <asp:Parameter Name="电子邮件" Type="String" />
                        <asp:Parameter Name="酒店网站" Type="String" />
                        <asp:Parameter Name="首页图像" Type="String" />
                        <asp:Parameter Name="标志图标" Type="String" />
                        <asp:Parameter Name="系统名称" Type="String" />
                        <asp:Parameter Name="优先级" Type="Int32" />
                    </InsertParameters>
                </asp:SqlDataSource>
                <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
                    BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
                    CellPadding="3" DataKeyNames="酒店名称" DataSourceID="SqlDataSource1" Font-Names="宋体"
                    Font-Size="Small" GridLines="Vertical" Height="20px" Width="409px">
                    <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                    <EditRowStyle BackColor="Gainsboro" Font-Bold="False" Font-Names="宋体" Font-Size="Small"
                        ForeColor="Black" />
                    <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                    <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" BorderStyle="Outset" />
                    <Fields>
                        <asp:BoundField DataField="酒店名称" HeaderText="酒店名称" ReadOnly="True" SortExpression="酒店名称" />
                        <asp:BoundField DataField="法人代表" HeaderText="法人代表" SortExpression="法人代表" />
                        <asp:BoundField DataField="酒店地址" HeaderText="酒店地址" SortExpression="酒店地址" />
                        <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
                        <asp:BoundField DataField="服务电话" HeaderText="服务电话" SortExpression="服务电话" />
                        <asp:BoundField DataField="电子邮件" HeaderText="电子邮件" SortExpression="电子邮件" />
                        <asp:BoundField DataField="酒店网站" HeaderText="酒店网站" SortExpression="酒店网站" />
                        <asp:BoundField DataField="首页图像" HeaderText="首页图像" SortExpression="首页图像" />
                        <asp:BoundField DataField="标志图标" HeaderText="标志图标" SortExpression="标志图标" />
                        <asp:BoundField DataField="系统名称" HeaderText="系统名称" SortExpression="系统名称" />
                        <asp:BoundField DataField="优先级" HeaderText="优先级" SortExpression="优先级" />
                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
                    </Fields>
                    <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="Gainsboro" />
                    <InsertRowStyle BackColor="Gainsboro" />
                </asp:DetailsView>
            </td>
        </tr>
        <tr>
         <td colspan="3" style="width: 412px; height: 17px;">
          <asp:FileUpload ID="FileUpload1" runat="server" Width="275px" />&nbsp;<asp:Button ID="btnUpload" runat="server" Text="上传图像文件" Width="127px" OnClick="btnUpload_Click" />             
           </td>
        </tr>
    </table>
</asp:Content>