public void PageBind() { PageBase pb = new PageBase(); pb.TblName = "Tunnel_file"; pb.FldName = "f_id"; pb.ProcedureName = "pagination"; pb.PageSize = pageSize; if (cuttentPage == 0) { cuttentPage = pb.PageIndex; } pb.PageIndex = cuttentPage; if (ul.LoginID > 1 && ul.JiaoSe(ul.LoginID) != "系统管理员") { pb.StrWhere = " f_user = " + ul.LoginID; } int count = 0; pb.DoCount = 1; rbll.GetList(pb, ref count); //获取总条数 pb.DoCount = 0; if (delState == true && pageSize == count) { cuttentPage = cuttentPage - 1; pb.PageIndex = cuttentPage; } List <Tunnel.Model.Tunnel_file> modelList = new List <Tunnel.Model.Tunnel_file>(); modelList = rbll.GetList(pb, ref count);//获取分页结果 //数据绑定 Repeater1.DataSource = modelList; Repeater1.DataBind(); //数据分页 MTCPager1.PageSize = pageSize; MTCPager1.RecordCount = count; MTCPager1.PageIndex = cuttentPage; if (count <= pb.PageSize) { MTCPager1.Visible = false; } else { MTCPager1.Visible = true; } }
public void PageBind() { PageBase pb = new PageBase(); pb.TblName = "Tunnel_file"; pb.FldName = "f_id"; pb.ProcedureName = "pagination"; pb.PageSize = pageSize; if (cuttentPage == 0) { cuttentPage = pb.PageIndex; } pb.PageIndex = cuttentPage; Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin(); pb.StrWhere = "( f_sort = 1) or (Charindex(',',f_juser," + ul.LoginID + ") > 0 )"; int count = 0; List <Tunnel.Model.Tunnel_file> modelList = new List <Tunnel.Model.Tunnel_file>(); modelList = rbll.GetList(pb, ref count);//获取分页结果 pb.DoCount = 1; rbll.GetList(pb, ref count); //获取总条数 //数据绑定 Repeater1.DataSource = modelList; Repeater1.DataBind(); //数据分页 MTCPager1.PageSize = pageSize; MTCPager1.RecordCount = count; MTCPager1.PageIndex = cuttentPage; if (count <= pb.PageSize) { MTCPager1.Visible = false; } else { MTCPager1.Visible = true; } }