admin_article.aspx.cs

新闻网站

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using BLL.System;
using Common.Entities;
using Common;
using System.Data.SqlClient;

public partial class Admin_Admin_Article : System.Web.UI.Page
{
  
    protected void Page_Load(object sender, EventArgs e)
    {
        if(Session["userName"] == null)
        {
            Response.Redirect("Admin_Error.aspx");
        }
        if (!IsPostBack)
        {
            BindGrideView();
        }
    }
    //绑定新闻视图
    protected void BindGrideView()
    {
        AspNetPager1.RecordCount = int.Parse(SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Article_GetCount", null).ToString());
        ArticleSystem articleSystem = new ArticleSystem();
        GridView1.DataSource = articleSystem.GetAll(AspNetPager1.CurrentPageIndex,AspNetPager1.PageSize);
        GridView1.DataBind();
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            if (((CheckBox)row.FindControl("chk")).Checked)
            {
                int id = int.Parse(((Label)row.FindControl("id")).Text);
                this.ArticleDelete(id);
            }
        }
    }
    //删除新闻
    protected void ArticleDelete(int id)
    {
        ArticleSystem articleSystem = new ArticleSystem();
        articleSystem.Delete(id);
        BindGrideView();
    }
    //页改变
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        BindGrideView();
    }
}