当前文件路径：XiaoFanWeb/admin/message.aspx

		            
  1<%...@ Page Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="message.aspx.cs" Inherits="admin_message" Title="Untitled Page" %>
  2<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
  3</asp:Content>
  4<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  5    <asp:Panel ID="pl_All" runat="server">
  6        <table width="700">
  7            <tr>
  8                <td>
  9                    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/dbs.mdb"
 10                        DeleteCommand="DELETE FROM [FZ_Message] WHERE [Id] = ?" InsertCommand="INSERT INTO [FZ_Message] ([Id], [Name], [Tel], [Mail], [Info], [Re_info], [Addtime], [Audit]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
 11                        SelectCommand="SELECT * FROM [FZ_Message] ORDER BY [Addtime] DESC" UpdateCommand="UPDATE [FZ_Message] SET [Name] = ?, [Tel] = ?, [Mail] = ?, [Info] = ?, [Re_info] = ?, [Addtime] = ?, [Audit] = ? WHERE [Id] = ?">
 12                        <DeleteParameters>
 13                            <asp:Parameter Name="Id" Type="Int32" />
 14                        </DeleteParameters>
 15                        <UpdateParameters>
 16                            <asp:Parameter Name="Name" Type="String" />
 17                            <asp:Parameter Name="Tel" Type="String" />
 18                            <asp:Parameter Name="Mail" Type="String" />
 19                            <asp:Parameter Name="Info" Type="String" />
 20                            <asp:Parameter Name="Re_info" Type="String" />
 21                            <asp:Parameter Name="Addtime" Type="DateTime" />
 22                            <asp:Parameter Name="Audit" Type="Int32" />
 23                            <asp:Parameter Name="Id" Type="Int32" />
 24                        </UpdateParameters>
 25                        <InsertParameters>
 26                            <asp:Parameter Name="Id" Type="Int32" />
 27                            <asp:Parameter Name="Name" Type="String" />
 28                            <asp:Parameter Name="Tel" Type="String" />
 29                            <asp:Parameter Name="Mail" Type="String" />
 30                            <asp:Parameter Name="Info" Type="String" />
 31                            <asp:Parameter Name="Re_info" Type="String" />
 32                            <asp:Parameter Name="Addtime" Type="DateTime" />
 33                            <asp:Parameter Name="Audit" Type="Int32" />
 34                        </InsertParameters>
 35                    </asp:AccessDataSource>
 36                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
 37                        DataKeyNames="Id" DataSourceID="AccessDataSource1" ForeColor="#333333" GridLines="None">
 38                        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
 39                        <Columns>
 40                            <asp:BoundField DataField="Id" HeaderText="编号" InsertVisible="False" ReadOnly="True"
 41                                SortExpression="Id" />
 42                            <asp:BoundField DataField="Name" HeaderText="留言者" SortExpression="Name" />
 43                            <asp:BoundField DataField="Tel" HeaderText="电话" SortExpression="Tel" />
 44                            <asp:BoundField DataField="Mail" HeaderText="邮箱" SortExpression="Mail" />
 45                            <asp:BoundField DataField="Info" HeaderText="内容" SortExpression="Info" Visible="False" />
 46                            <asp:BoundField DataField="Re_info" HeaderText="Re_info" SortExpression="Re_info"
 47                                Visible="False" />
 48                            <asp:BoundField DataField="Addtime" HeaderText="Addtime" SortExpression="Addtime" />
 49                            <asp:BoundField DataField="Audit" HeaderText="Audit" SortExpression="Audit" Visible="False" />
 50                            <asp:TemplateField HeaderText="回复留言" ShowHeader="False">
 51                                <ItemTemplate>
 52                                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
 53                                        OnClick="LinkButton1_Click" Text="回复留言"></asp:LinkButton>
 54                                </ItemTemplate>
 55                            </asp:TemplateField>
 56                        </Columns>
 57                        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
 58                        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
 59                        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
 60                        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
 61                        <AlternatingRowStyle BackColor="White" />
 62                    </asp:GridView>
 63                </td>
 64            </tr>
 65            <tr>
 66                <td align="center">
 67                    <asp:Panel ID="pl_updateAll" runat="server" Visible="False">
 68                        <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/dbs.mdb"
 69                            DeleteCommand="DELETE FROM [FZ_Message] WHERE [Id] = ?" InsertCommand="INSERT INTO [FZ_Message] ([Id], [Name], [Tel], [Mail], [Info], [Re_info], [Addtime], [Audit]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
 70                            SelectCommand="SELECT * FROM [FZ_Message] WHERE ([Id] = ?)" UpdateCommand="UPDATE [FZ_Message] SET [Name] = ?, [Tel] = ?, [Mail] = ?, [Info] = ?, [Re_info] = ?, [Addtime] = ?, [Audit] = ? WHERE [Id] = ?">
 71                            <DeleteParameters>
 72                                <asp:Parameter Name="Id" Type="Int32" />
 73                            </DeleteParameters>
 74                            <UpdateParameters>
 75                                <asp:Parameter Name="Name" Type="String" />
 76                                <asp:Parameter Name="Tel" Type="String" />
 77                                <asp:Parameter Name="Mail" Type="String" />
 78                                <asp:Parameter Name="Info" Type="String" />
 79                                <asp:Parameter Name="Re_info" Type="String" />
 80                                <asp:Parameter Name="Addtime" Type="DateTime" />
 81                                <asp:Parameter Name="Audit" Type="Int32" />
 82                                <asp:Parameter Name="Id" Type="Int32" />
 83                            </UpdateParameters>
 84                            <SelectParameters>
 85                                <asp:ControlParameter ControlID="GridView1" Name="Id" PropertyName="SelectedValue"
 86                                    Type="Int32" />
 87                            </SelectParameters>
 88                            <InsertParameters>
 89                                <asp:Parameter Name="Id" Type="Int32" />
 90                                <asp:Parameter Name="Name" Type="String" />
 91                                <asp:Parameter Name="Tel" Type="String" />
 92                                <asp:Parameter Name="Mail" Type="String" />
 93                                <asp:Parameter Name="Info" Type="String" />
 94                                <asp:Parameter Name="Re_info" Type="String" />
 95                                <asp:Parameter Name="Addtime" Type="DateTime" />
 96                                <asp:Parameter Name="Audit" Type="Int32" />
 97                            </InsertParameters>
 98                        </asp:AccessDataSource>
 99                        <table>
100                            <tr>
101                                <td align="left">
102                                    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="Id"
103                                        DataSourceID="AccessDataSource2" DefaultMode="Edit">
104                                        <Fields>
105                                            <asp:TemplateField HeaderText="编号" InsertVisible="False" SortExpression="Id">
106                                                <EditItemTemplate>
107                                                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Id") %>'></asp:Label>
108                                                </EditItemTemplate>
109                                                <ItemTemplate>
110                                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("Id") %>'></asp:Label>
111                                                </ItemTemplate>
112                                            </asp:TemplateField>
113                                            <asp:TemplateField HeaderText="留言者" SortExpression="Name">
114                                                <EditItemTemplate>
115                                                    <asp:TextBox ID="TextBox3" runat="server" Enabled="False" Text='<%# Bind("Name") %>'></asp:TextBox>
116                                                </EditItemTemplate>
117                                                <InsertItemTemplate>
118                                                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
119                                                </InsertItemTemplate>
120                                                <ItemTemplate>
121                                                    <asp:Label ID="Label4" runat="server" Text='<%# Bind("Name") %>'></asp:Label>
122                                                </ItemTemplate>
123                                            </asp:TemplateField>
124                                            <asp:TemplateField HeaderText="电话" SortExpression="Tel">
125                                                <EditItemTemplate>
126                                                    <asp:TextBox ID="TextBox4" runat="server" Enabled="False" Text='<%# Bind("Tel") %>'></asp:TextBox>
127                                                </EditItemTemplate>
128                                                <InsertItemTemplate>
129                                                    <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Tel") %>'></asp:TextBox>
130                                                </InsertItemTemplate>
131                                                <ItemTemplate>
132                                                    <asp:Label ID="Label5" runat="server" Text='<%# Bind("Tel") %>'></asp:Label>
133                                                </ItemTemplate>
134                                            </asp:TemplateField>
135                                            <asp:TemplateField HeaderText="邮箱" SortExpression="Mail">
136                                                <EditItemTemplate>
137                                                    <asp:TextBox ID="TextBox5" runat="server" Enabled="False" Text='<%# Bind("Mail") %>'></asp:TextBox>
138                                                </EditItemTemplate>
139                                                <InsertItemTemplate>
140                                                    <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("Mail") %>'></asp:TextBox>
141                                                </InsertItemTemplate>
142                                                <ItemTemplate>
143                                                    <asp:Label ID="Label6" runat="server" Text='<%# Bind("Mail") %>'></asp:Label>
144                                                </ItemTemplate>
145                                            </asp:TemplateField>
146                                            <asp:TemplateField HeaderText="留言" SortExpression="Info">
147                                                <EditItemTemplate>
148                                                    <asp:TextBox ID="TextBox2" runat="server" Enabled="False" Height="80px" Text='<%# Bind("Info") %>'
149                                                        TextMode="MultiLine" Width="300px"></asp:TextBox>
150                                                </EditItemTemplate>
151                                                <InsertItemTemplate>
152                                                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Info") %>'></asp:TextBox>
153                                                </InsertItemTemplate>
154                                                <ItemTemplate>
155                                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("Info") %>'></asp:Label>
156                                                </ItemTemplate>
157                                            </asp:TemplateField>
158                                            <asp:TemplateField HeaderText="回复留言" SortExpression="Re_info">
159                                                <EditItemTemplate>
160                                                    <asp:TextBox ID="TextBox1" runat="server" BorderStyle="Ridge" Height="80px" Text='<%# Bind("Re_info") %>'
161                                                        TextMode="MultiLine" Width="300px"></asp:TextBox>
162                                                </EditItemTemplate>
163                                                <InsertItemTemplate>
164                                                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Re_info") %>'></asp:TextBox>
165                                                </InsertItemTemplate>
166                                                <ItemStyle ForeColor="Red" />
167                                                <HeaderStyle ForeColor="Red" />
168                                                <ItemTemplate>
169                                                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("Re_info") %>'></asp:Label>
170                                                </ItemTemplate>
171                                            </asp:TemplateField>
172                                            <asp:TemplateField HeaderText="留言时间" SortExpression="Addtime">
173                                                <EditItemTemplate>
174                                                    <asp:TextBox ID="TextBox6" runat="server" Enabled="False" Text='<%# Bind("Addtime") %>'></asp:TextBox>
175                                                </EditItemTemplate>
176                                                <InsertItemTemplate>
177                                                    <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("Addtime") %>'></asp:TextBox>
178                                                </InsertItemTemplate>
179                                                <ItemTemplate>
180                                                    <asp:Label ID="Label7" runat="server" Text='<%# Bind("Addtime") %>'></asp:Label>
181                                                </ItemTemplate>
182                                            </asp:TemplateField>
183                                            <asp:BoundField DataField="Audit" HeaderText="Audit" SortExpression="Audit" Visible="False" />
184                                            <asp:CommandField ShowEditButton="True" UpdateText="回复留言">
185                                                <FooterStyle ForeColor="Red" />
186                                                <HeaderStyle ForeColor="Red" />
187                                                <ItemStyle ForeColor="Red" />
188                                                <ControlStyle ForeColor="Red" />
189                                            </asp:CommandField>
190                                        </Fields>
191                                    </asp:DetailsView>
192                                </td>
193                            </tr>
194                        </table>
195                    </asp:Panel>
196                </td>
197            </tr>
198            <tr>
199                <td>
200                </td>
201            </tr>
202        </table>
203    </asp:Panel>
204    <asp:Panel ID="pl_noRe" runat="server" Height="50px" Width="125px">
205    </asp:Panel>
206    <asp:Panel ID="pl_re" runat="server" Height="50px" Width="125px">
207    </asp:Panel>
208</asp:Content>
209
210