Repeater分页、全选、批量删除(2)

现在我们后台程序

 #region Repeater分页绑定
        /// <summary>
        /// Repeater 绑定数据
        /// </summary>
        /// <param name="dt">数据源</param>
        /// <param name="dtl">Repeater表名</param>
        /// <param name="all_page">显示所有页数Label</param>
        /// <param name="all_count">显示所有项数Label</param>
        /// <param name="now_page">当前页数Label</param>
        /// <param name="first_page">首页</param>
        /// <param name="bacd_page">上一页</param>
        /// <param name="next_page">下一页</param>
        /// <param name="last_page">尾页</param>
        /// <returns></returns>
        public static void PageBind(DataTable dt, Repeater RP_name, Label all_page, Label all_count, Label now_page, ImageButton first_page, ImageButton bacd_page, ImageButton next_page, ImageButton last_page)
        {
            PagedDataSource pdg = new PagedDataSource();
            pdg.DataSource = dt.DefaultView;//获取数据源
            pdg.AllowPaging = true;//启用分页
            pdg.PageSize = 10;//一页显示项数
            all_count.Text = pdg.DataSourceCount.ToString();//总项数
            all_page.Text = pdg.PageCount.ToString();//总页数
            int i = int.Parse(now_page.Text);//当前页
            pdg.CurrentPageIndex = i - 1;//索引页

            first_page.Enabled = true;
            bacd_page.Enabled = true;
            next_page.Enabled = true;
            last_page.Enabled = true;

            //判断是否是第一页
            if (i == 1)
            {
                first_page.Enabled = false;
                bacd_page.Enabled = false;
            }
            //判断是否为最后一页
            if (i == int.Parse(pdg.PageCount.ToString()))
            {
                next_page.Enabled = false;
                last_page.Enabled = false;
            }
            RP_name.DataSource = pdg;
            RP_name.DataBind();

        }
        #endregion

 

 

  /// <summary>
    /// 获取所有数据列表
    /// </summary>
    public void Newslist()
    {
        NewsPagestr(bllnews.GetAllList());
    }
    /// <summary>
    /// 在这里进行分来
    /// </summary>
    /// <param name="strds"></param>
    public void NewsPagestr(DataSet strds)
    {
        DataTable ds = strds.Tables[0];
        if (ds.Rows.Count > 0)
        {
            rp_newslist.Visible = true;
            trmagess.Visible = false;
            trpage.Visible = true;
            BHELPER.CRCommon.PageBind(ds, rp_newslist, LB_Zpage1, LB_Zpage, LB_Dqpage, Img_first, Img_back, Img_next, Img_last);
            this.LB_pagea.Text = this.rp_newslist.Items.Count.ToString();
            this.TB_page.Text = LB_Dqpage.Text;
        }
        else
        {
            rp_newslist.Visible = false;
            trmagess.Visible = true;
            trpage.Visible = false;
            Lb_magess.Text = "抱歉，当前没有找到您需要的信息！\n您可以在此<a href='newsadd.aspx'>新增信息</a>";
        }
    }
    /// <summary>
    /// 首页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Img_first_Click(object sender, ImageClickEventArgs e)
    {
        LB_Dqpage.Text = "1";
        TB_page.Text = LB_Dqpage.Text;
        Newslist();
    }
    /// <summary>
    /// 上一页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Img_back_Click(object sender, ImageClickEventArgs e)
    {
        this.LB_Dqpage.Text = (Convert.ToInt32(LB_Dqpage.Text) - 1).ToString();
        Newslist();
    }
    /// <summary>
    /// 下一页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Img_next_Click(object sender, ImageClickEventArgs e)
    {
        this.LB_Dqpage.Text = (Convert.ToInt32(LB_Dqpage.Text) + 1).ToString();
        Newslist();
    }
    /// <summary>
    /// 尾页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Img_last_Click(object sender, ImageClickEventArgs e)
    {
        LB_Dqpage.Text = LB_Zpage1.Text;
        Newslist();
    }
    /// <summary>
    /// 跳转
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Img_go_Click(object sender, ImageClickEventArgs e)
    {
        if (TB_page.Text == "" || Convert.ToInt32(TB_page.Text) > Convert.ToInt32(TB_page.Text) || Convert.ToInt32(TB_page.Text) < 1)
        {
            rp_newslist.Visible = false;
            trmagess.Visible = true;
            trpage.Visible = false;
            Lb_magess.Text = "抱歉，当前没有找到您需要的信息！您可以在此 <a href='newsadd.aspx'>新增信息</a>";
        }
        else
        {
            LB_Dqpage.Text = TB_page.Text;
            Newslist();
        }
    }

 /// <summary>
    /// 全选
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Ck_nonqx_CheckedChanged(object sender, EventArgs e)
    {
        if (((CheckBox)sender).Checked)
        {
            foreach (RepeaterItem rp in rp_newslist.Items)
            {
                CheckBox Ck = (CheckBox)rp.FindControl("ck_qx");
                Ck.Checked = true;
            }
        }
        else
        {
            foreach (RepeaterItem rp in rp_newslist.Items)
            {
                CheckBox ck = (CheckBox)rp.FindControl("ck_qx");
                ck.Checked = false;
            }
        }
    }
    /// <summary>
    /// 批量删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lb_del_Click(object sender, EventArgs e)
    {
        string delId = "";
        for (int i = 0; i < rp_newslist.Items.Count; i++)
        {
            CheckBox ck = (CheckBox)rp_newslist.Items[i].FindControl("ck_qx");
            Literal ltl = (Literal)rp_newslist.Items[i].FindControl("Lit_id");
            if (ck != null)
            {
                if (ck.Checked)
                {
                    delId += ltl.Text + ",";
                }
            }
        }
        delId = (delId + ")").Replace(",)", "");
        try
        {
            bllnews.DeletePl(delId);
            Newslist();
        }
        catch
        {
            BHELPER.CRCommon.Show(this.Page, "很抱歉！数据操作失败，请确认后再操作！");
        }
    }

批量删除的数据类方法

  /// <summary>
        /// 批量删除
        /// </summary>
        public void DeletePl(string newsid)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("delete tb_News where newsid in ("+newsid+")");
            DbHelperSQL.ExecuteSql(strsql.ToString());
        }
 

转载于:https://www.cnblogs.com/blogs108/archive/2011/09/04/page.html