?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;

public partial class Manage_manage_soundSpeak : System.Web.UI.Page
{
    dataOperate mydo = new dataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        seeSpeak();
    }
    protected void seeSpeak()
    {
        int curpage = Convert.ToInt32(this.labPage.Text);
        PagedDataSource ps = new PagedDataSource();                 
            string selectSql = "select * from tb_Speak  where [TutorialID]=" + Request.QueryString["SoundID"] + " and [TutorialType]='Sound' ORDER BY SpeakID DESC ";
            string table = "tb_Speak";
            ps.DataSource = mydo.rows(selectSql, table).DefaultView;
            //啟用分頁
            ps.AllowPaging = true;            
            ps.PageSize = 10;
            //設置當前頁的索引
            ps.CurrentPageIndex = curpage - 1;
            this.lnkbtnFront.Enabled = true;
            this.lnkbtnNext.Enabled = true;
            this.lnkbtnLast.Enabled = true;
            this.lnkbtnFirst.Enabled = true;
            if (curpage == 1) //等于第一頁
            {
                this.lnkbtnFirst.Enabled = false;//不顯示第一頁按鈕
                this.lnkbtnFront.Enabled = false;//不顯示上一頁按鈕
            }
            if (curpage == ps.PageCount) //等于最后一頁
            {
                this.lnkbtnNext.Enabled = false;//不顯示下一頁
                this.lnkbtnLast.Enabled = false;//不顯示最后一頁
            }
            this.labBackPage.Text = Convert.ToString(ps.PageCount);
            this.DataList1.DataSource = ps;
            //設置數(shù)據(jù)源的關鍵字段
            this.DataList1.DataKeyField = "SpeakID";
            DataList1.DataSource = ps;
            DataList1.DataBind();  
        
    }

    protected void lnkbtnFirst_Click(object sender, EventArgs e)
    {
        labPage.Text = "1";//設置當前頁為１
        this.seeSpeak();//調用自定義方法重新綁定數(shù)據(jù)
    }
    protected void lnkbtnFront_Click(object sender, EventArgs e)
    {
        //設置當前頁減１
        labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
        this.seeSpeak();//調用自定義方法重新綁定數(shù)據(jù)
    }
    protected void lnkbtnNext_Click(object sender, EventArgs e)
    {
        //設置當前頁加１
        labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
        this.seeSpeak();//調用自定義方法重新綁定數(shù)據(jù)
    }
    protected void lnkbtnLast_Click(object sender, EventArgs e)
    {
        //設置當前頁為最后一頁
        labPage.Text = labBackPage.Text;
        this.seeSpeak();//調用自定義方法重新綁定數(shù)據(jù)
    }



    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
        string sql = "delete from tb_Speak where SpeakID=" + id;
        if (mydo.adlData(sql))
        {
            Page.RegisterStartupScript("true", "<script>alert('刪除成功！')</script>");
        }
        else
        {
            Page.RegisterStartupScript("false", "<script>alert('刪除失敗！')</script>");
        }
        this.seeSpeak();
    }
}