leavewordmanage.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 System.Data.SqlClient;


public partial class Admin_留言回复管理_LeavewordManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindLeavewordData();
        }
    }
    private void BindLeavewordData()
    {   ///获取数据
        SqlConnection conn = CN.CreateConn();
        SqlDataAdapter sa = new SqlDataAdapter("select * from Leavewords order by leavewordID DESC", conn);
        conn.Open();
        DataSet ds = new DataSet();
        sa.Fill(ds, "Leavewords");
        ///绑定数据
        LeavewordView.DataSource = ds;
        LeavewordView.DataBind();

        if (ds.Tables[0].Rows.Count == 0)
        {
            btnFirst.Visible = false;
            btnPrev.Visible = false;
            btnNext.Visible = false;
            btnLast.Visible = false;

            LblCurrentIndex.Visible = false;
            LblPageCount.Visible = false;
            LblRecordCount.Visible = false;
        }
        else if (LeavewordView.PageCount == 1)
        {
            btnFirst.Visible = false;
            btnPrev.Visible = false;
            btnNext.Visible = false;
            btnLast.Visible = false;
        }
        else if (LeavewordView.PageIndex == 0)
        {
            btnFirst.Visible = false;
            btnPrev.Visible = false;
            btnNext.Visible = true;
            btnLast.Visible = true;
        }
        else if (LeavewordView.PageIndex == LeavewordView.PageCount - 1)
        {
            btnLast.Visible = false;
            btnNext.Visible = false;
            btnFirst.Visible = true;
            btnPrev.Visible = true;
        }
        else
        {
            btnLast.Visible = true;
            btnNext.Visible = true;
            btnFirst.Visible = true;
            btnPrev.Visible = true;
        }
        
    }
    public void PagerButtonClick(object sender, EventArgs e)
    {
        string args = ((LinkButton)sender).CommandArgument.ToString();
        switch (args)
        {
            case "first":
                if (LeavewordView.PageIndex > 1)
                {
                    LeavewordView.PageIndex = 0;
                }
                break;
            case "next":
                if (LeavewordView.PageIndex < LeavewordView.PageCount - 1)
                {
                    LeavewordView.PageIndex += 1;
                }
                break;
            case "prev":
                if (LeavewordView.PageIndex > 0)
                {
                    LeavewordView.PageIndex -= 1;
                }
                break;

            case "last":
                LeavewordView.PageIndex = LeavewordView.PageCount - 1;
                break;
            default:
                LeavewordView.PageIndex = System.Convert.ToInt32(args);
                break;
        }
        BindLeavewordData();
    }
    protected void LeavewordView_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "delete")
        {
            try
            {   ///删除数据
                ILeaveword word = new Leaveword();
                word.DeleteLeaveword(Int32.Parse(e.CommandArgument.ToString()));

                ///重新绑定控件的数据
                BindLeavewordData();
                Response.Write("<script>alert('" + "删除数据成功，请妥善保管好你的数据！" + "');</script>");
            }
            catch
            { 
            }
        }
    }
    protected void LeavewordView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        ///
    }
    protected void LeavewordView_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        ImageButton deleteBtn = (ImageButton)e.Row.FindControl("DeleteBtn");
        if (deleteBtn != null)
        {
            deleteBtn.Attributes.Add("onclick", "return confirm('你确定要删除所选择的数据项吗？');");
        }
    }
}