communityform.aspx

来自「小区物业管理系统源代码,密码:123456,」· ASPX 代码 · 共 89 行

<%--文件名:CommunityForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="CommunityForm.aspx.cs" Inherits="System_CommunityForm" Title="当前位置：系统管理->小区信息设置" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table>
        <tr>
            <td colspan="1" rowspan="3" style="font-size: 0.8em; width: 76px; font-family: 宋体">
            </td>
            <td colspan="3" style="font-size: 0.8em; width: 412px; font-family: 宋体; height: 21px">
                <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" rowspan="2" style="font-size: 0.8em; width: 50px; font-family: 宋体">
            </td>
        </tr>
        <tr>
            <td colspan="3" style="width: 412px; height: 202px">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyCommunityDBConnectionString %>"
                    DeleteCommand="DELETE FROM [小区信息] WHERE [小区名称] = @小区名称" InsertCommand="INSERT INTO [小区信息] ([小区名称], [总负责人], [小区地址], [邮政编码], [服务电话], [电子信箱], [小区网站], [首页图像], [标志图标], [系统名称], [优先级]) VALUES (@小区名称, @总负责人, @小区地址, @邮政编码, @服务电话, @电子信箱, @小区网站, @首页图像, @标志图标, @系统名称, @优先级)"
                    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" 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="50px" Width="408px">
                    <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                    <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                    <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                    <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" />
                </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" OnClick="btnUpload_Click" Text="上传图像文件" Width="127px" />
            </td>
        </tr>
    </table>
</asp:Content>