Ejemplo n.º 1
0
    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;
        }
    }
Ejemplo n.º 2
0
    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;
        }
    }