📄 messagelist.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MessageList.aspx.cs" Inherits="MessageList" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
<link href="css/css.css" rel="stylesheet" type="text/css" />
<link href="css/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Panel ID="Panel1" runat="server" align="center" Height="328px" Width="629px">
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="SqlDataSource1" Width="544px" BorderColor="Gray" OnRowDataBound="GridView1_RowDataBound">
<Columns>
<asp:BoundField DataField="From_User" HeaderText="发件人" SortExpression="From_User" />
<asp:TemplateField HeaderText="标题" SortExpression="Title">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Title").ToString().Length>7?Eval("Title").ToString().Substring(0,5)+"...":Eval("Title").ToString() %>' ToolTip='<%#Eval("Title")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="短信内容" >
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Content") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<a href="#" onclick="window.open('<%# "MessageDetails.aspx?ID="+Eval("ID") %>','_blank','left=210,top=120,width=373,height=200')">查看内容 </a>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="附件">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("Enclosure").ToString().Length>1?Eval("Enclosure", "Enclosure/{0}"):null %>' ImageUrl='<%# Eval("Enclosure").ToString().Length>1? "Images/fujian.gif":"Images/fujian2.gif"%>' Text="无附件" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="SendTime" HeaderText="发送时间" SortExpression="SendTime" />
<asp:BoundField DataField="IfRead" HeaderText="是否阅读" SortExpression="IfRead" />
<asp:TemplateField HeaderText="回复" >
<ItemTemplate>
<asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl='<%# "MessageSend.aspx?To_User="+Eval("From_User")%>' Text="回复" />
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" ShowHeader="True" DeleteImageUrl="~/Images/1.gif" />
</Columns>
<PagerSettings FirstPageText="第一页" LastPageText="最后一页" Mode="NextPreviousFirstLast"
NextPageText="下一页" PreviousPageText="上一页" />
<RowStyle HorizontalAlign="Center" VerticalAlign="Middle" />
<PagerStyle HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#C0FFFF" Height="10px" />
<HeaderStyle Font-Size="12px" HorizontalAlign="Center" VerticalAlign="Middle" BackColor="#C0FFFF" />
<AlternatingRowStyle HorizontalAlign="Center" VerticalAlign="Middle" />
<FooterStyle BackColor="#C0FFFF" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:conString %>"
SelectCommand="SELECT * FROM [Message] WHERE ([To_User] = @To_User) ORDER BY [SendTime]" DeleteCommand="DELETE FROM [Message] WHERE [ID] = @ID" InsertCommand="INSERT INTO [Message] ([From_User], [To_User], [Title], [Content], [Enclosure], [SendTime], [IfRead]) VALUES (@From_User, @To_User, @Title, @Content, @Enclosure, @SendTime, @IfRead)" UpdateCommand="UPDATE [Message] SET [From_User] = @From_User, [To_User] = @To_User, [Title] = @Title, [Content] = @Content, [Enclosure] = @Enclosure, [SendTime] = @SendTime, [IfRead] = @IfRead WHERE [ID] = @ID">
<SelectParameters>
<asp:SessionParameter Name="To_User" SessionField="Name" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="From_User" Type="String" />
<asp:Parameter Name="To_User" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Content" Type="String" />
<asp:Parameter Name="Enclosure" Type="String" />
<asp:Parameter Name="SendTime" Type="DateTime" />
<asp:Parameter Name="IfRead" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="From_User" Type="String" />
<asp:Parameter Name="To_User" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Content" Type="String" />
<asp:Parameter Name="Enclosure" Type="String" />
<asp:Parameter Name="SendTime" Type="DateTime" />
<asp:Parameter Name="IfRead" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</asp:Panel>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -