JCK.Web/declaration/open/open_entrust.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace JCK.Web.declaration.open
{
    public partial class open_entrust : Web.UI.ManagePage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                rptBind();
            }
        }

        #region 数据绑定=================================
        private void rptBind()
        {
            DAL.Online_Enterprise bll = new DAL.Online_Enterprise();
            Model.Online_User on_u = GetUserInfo();
            Model.Info info = GetInfo();
            string where = " zt='1' ";
            if (info.isadmin == "0")
                where += "and SUBSTRING(bh,1,2)='BG' and bh in (select BG_BH from proxyapply where QY_BH='" + on_u.BH+ "' and status='同意')";

            DataTable dt = bll.GetList(where).Tables[0];


            pager_rpt.PageSize = 10;
            PagedDataSource pds = new PagedDataSource();
            pager_rpt.RecordCount = dt.Rows.Count;

            pds.DataSource = dt.DefaultView;
            pds.CurrentPageIndex = pager_rpt.CurrentPageIndex - 1;
            pds.PageSize = pager_rpt.PageSize;
            pds.AllowPaging = true;

            rptList.DataSource = pds;
            rptList.DataBind();
        }
        #endregion

        //分页
        protected void pager_rpt_PageChanged(object sender, EventArgs e)
        {
            rptBind();
        }
    }
}