PumpkinHouseWeb/Admin/LuckyManagement.aspx

   1 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="LuckyManagement.aspx.cs"\r
   2     Inherits="PumpkinHouse.Admin.LuckyManagement" MasterPageFile="~/Admin/Admin.Master" %>\r
   3 \r
   4 <asp:Content ContentPlaceHolderID="MainPageHolder" ID="mainPage" runat="server">\r
   5     <form id="form1" runat="server">\r
   6     <asp:GridView ID="GridView1" DataSourceID="SqlDataSource1" AutoGenerateColumns="false"\r
   7         AutoGenerateDeleteButton="true" AutoGenerateEditButton="false" runat="server" DataKeyNames="Username, Activity_Id" >\r
   8         <Columns>\r
   9             <asp:BoundField DataField="Username" HeaderText="用户名" SortExpression="Username" />\r
  10             <asp:BoundField DataField="Nick_Name" HeaderText="昵称" SortExpression="Nick_Name" />\r
  11             <asp:BoundField DataField="Date" HeaderText="中奖时间" SortExpression="Date" />\r
  12         </Columns>\r
  13     </asp:GridView>\r
  14     新用户昵称：<asp:TextBox ID="textNewUser" runat="server"></asp:TextBox>\r
  15     <asp:Button ID="btnAddLucky" Text="添加"  runat="server" \r
  16         onclick="btnAddLucky_Click"/>\r
  17     <br />\r
  18     <br />\r
  19     活动页当前名单更新日期：<asp:Label ID="lblCurrentDisplayDate" runat="server" Text=""></asp:Label>\r
  20     <br />\r
  21     <asp:Button ID="btnUpdateActivity" Text="名单已更新，刷新活动页中奖名单" runat="server" \r
  22         onclick="btnUpdateActivity_Click" />\r
  23     <br />\r
  24     <br />\r
  25     <asp:Label ID="lblResult" runat="server" />\r
  26     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"\r
  27         SelectCommand="SELECT [Username], [Nick_Name], [Date], [Activity_Id] FROM [View_Lucky] where Activity_Id = 1" \r
  28         DeleteCommand="Delete [DB_Lucky] where Username=@Username and Activity_Id =@Activity_Id" >\r
  29     </asp:SqlDataSource>\r
  30     </form>\r
  31 </asp:Content>\r