PumpkinHouseWeb/Admin/PictureManagement.aspx.cs

   1 using System;
   2 using System.Collections.Generic;
   3 using System.Linq;
   4 using System.Web;
   5 using System.Web.UI;
   6 using System.Web.UI.WebControls;
   7 using PumpkinHouseDatabase;
   8 using PumpkinHouse.Utils;
   9 using System.Data;
  10
  11 namespace PumpkinHouse.Admin
  12 {
  13     public partial class PictureManagement : System.Web.UI.Page
  14     {
  15
  16         protected void Page_Load(object sender, EventArgs e)
  17         {
  18             if (!IsPostBack)
  19             {
  20                 DateTime start = DateTime.Parse("2012/1/1");
  21                 DateTime today = DateTime.Now;
  22
  23                 CalendarStart.SelectedDate = start;
  24
  25                 CalendarEnd.SelectedDate = today;
  26
  27                 BindDataSource();
  28             }
  29         }
  30
  31         protected void BindDataSource()
  32         {
  33             //            SqlDataSource1.SelectCommand =
  34             //                    @"SELECT [Id], [Description], [Upload_Time], [Tags], u.[Username], [Image_Filename], [Image_File_Ext], [Nick_Name], [On_Top]
  35             //                    FROM [DB_Picture] d, [DB_User] u
  36             //                    where d.Username = u.Username ";
  37             //            SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.Text;
  38             //            SqlDataSource1.UpdateCommand = "Update DB_Picture set Description = @Description, Tags = @Tags, On_Top = @On_Top where Id = @Id";
  39
  40             //            if (!string.IsNullOrEmpty(textNickName.Text))
  41             //            {
  42             //                string name = textNickName.Text.Trim();
  43             //                SqlDataSource1.SelectCommand += " and u.Nick_Name = '" + name + "'";
  44             //            }
  45             //            if (!string.IsNullOrEmpty(textPictureId.Text))
  46             //            {
  47             //                long id = 0;
  48             //                bool success = long.TryParse(textPictureId.Text, out id);
  49             //                if (success)
  50             //                {
  51             //                    SqlDataSource1.SelectCommand += " and d.Id = " + id;
  52             //                }
  53             //            }
  54
  55             SqlDataSource1.FilterExpression = string.Format("(Nick_Name LIKE '{0}' AND Collect_Time >= '{1}' and Collect_Time <= '{2}') ",
  56     textNickName.Text, CalendarStart.SelectedDate.ToString("yyyy-MM-dd"), CalendarEnd.SelectedDate.AddDays(1).ToString("yyyy-MM-dd"));
  57
  58             if (!string.IsNullOrWhiteSpace(textPictureId.Text))
  59             {
  60                 SqlDataSource1.FilterExpression += "and Id = " + textPictureId.Text;
  61             }
  62
  63             GridView1.DataBind();
  64
  65         }
  66
  67
  68         protected void btnFilter_Click(object sender, EventArgs e)
  69         {
  70             if (string.IsNullOrEmpty(textNickName.Text))
  71             {
  72                 textNickName.Text = "%";
  73             }
  74             BindDataSource();
  75         }
  76
  77         protected void OnUpdating(object sender, GridViewUpdateEventArgs e)
  78         {
  79             using (DataUtils utils = new DataUtils())
  80             {
  81                 long id = (long)e.Keys[0];
  82                 DB_Collection2 pic = utils.FindCollection2(id);
  83                 if (pic != null)
  84                 {
  85                     pic.Tags = e.NewValues["Tags"] as string;
  86                     pic.Description = e.NewValues["Description"] as string;
  87                     if (e.NewValues["On_Top"].Equals("1") && (e.OldValues["On_Top"] == null || e.OldValues["On_Top"].Equals("0")))
  88                     {
  89                         pic.On_Top = 1;
  90                         pic.On_Top_Update_Time = DateTime.Now;
  91                     }
  92                     if (e.NewValues["On_Top"].Equals("0") && e.OldValues["On_Top"].Equals("1"))
  93                     {
  94                         pic.On_Top = 0;
  95                         pic.On_Top_Update_Time = null;
  96                     }
  97                     utils.Commit();
  98                 }
  99             }
 100             BindDataSource();
 101         }
 102
 103         protected void OnDelete(object sender, GridViewDeleteEventArgs e)
 104         {
 105             e.Cancel = true;
 106
 107             long id = (long)e.Keys[0];
 108             using (DataUtils utils = new DataUtils())
 109             {
 110                 DB_Collection2 col = utils.FindCollection2(id);
 111                 if (col != null)
 112                 {
 113                     Operation.DeleteCollection(utils, col);
 114                 }
 115             }
 116
 117             BindDataSource();
 118         }
 119
 120         protected void OnDateChanged(object sender, EventArgs e)
 121         {
 122             BindDataSource();
 123         }
 124
 125         protected void PageIndexChanged(object sender, EventArgs e)
 126         {
 127             BindDataSource();
 128         }
 129
 130         protected void Sorted(object sender, EventArgs e)
 131         {
 132             BindDataSource();
 133         }
 134
 135         protected void OnEditing(object sender, GridViewEditEventArgs e)
 136         {
 137             BindDataSource();
 138         }
 139
 140         protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
 141         {
 142             lblCount.Text = e.AffectedRows.ToString();
 143         }
 144
 145         protected void deleteSelected_Click(object sender, EventArgs e)
 146         {
 147             using (DataUtils utils = new DataUtils())
 148             {
 149                 for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
 150                 {
 151                     CheckBox CheckBox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox");
 152                     if (CheckBox.Checked)
 153                     {
 154                         long id = long.Parse(GridView1.Rows[i].Cells[2].Text);
 155                         DB_Collection2 col2 = utils.FindCollection2(id);
 156                         Operation.DeleteCollection(utils, col2);
 157                     }
 158                 }
 159             }
 160             BindDataSource();
 161
 162         }
 163
 164         protected void selectAll_CheckedChanged(object sender, EventArgs e)
 165         {
 166             for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
 167             {
 168                 CheckBox CheckBox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox");
 169                 if (this.selectAll.Checked == true)
 170                 {
 171                     CheckBox.Checked = true;
 172                 }
 173                 else
 174                 {
 175                     CheckBox.Checked = false;
 176                 }
 177             }
 178         }
 179     }
 180 }