aspnetpager分页UI调用存储过程函数

我这里带了参数,原因是这个函数会被带有不同条件参数的方法调用

 int Count;
    public void Newslistpage(string strwhere)
    {
       
        DataTable ds = new DataTable();
        int _currentpageindex = 1;
        if (!string.IsNullOrEmpty(Request["Page"]))
            _currentpageindex = int.Parse(Request["Page"]);

        if (strwhere=="")
        {
            ds = WebHelp.DALHelper.GetmuchList("tb_News", "tb_NewsClass", " * ", "Newsid", "Nclassid", "Nclassid", AspNetPager1.PageSize, _currentpageindex, "Newsid desc", " subjectid=1 ", "*", out Count).Tables[0];
        }
        else if (WebHelp.CRCommon.isNumber(Request.QueryString["nclassid"]) == false)
        {
            lmges.Visible = true;
        }
        else
        {
            ds = WebHelp.DALHelper.GetmuchList("tb_News", "tb_NewsClass", " * ", "Newsid", "Nclassid", "Nclassid", AspNetPager1.PageSize, _currentpageindex, "Newsid desc", " subjectid=1 and " + strwhere + " ", "*", out Count).Tables[0];
        }
        AspNetPager1.RecordCount = Count;
        AspNetPager1.CustomInfoHTML = "共" + AspNetPager1.RecordCount.ToString() + "条,";
        AspNetPager1.CustomInfoHTML += "" + AspNetPager1.PageCount.ToString() + "页,";
        AspNetPager1.CustomInfoHTML += "第" + _currentpageindex + "页";
        if (ds.Rows.Count > 0)
        {
            this.Rp_newslist.DataSource = ds;
            this.Rp_newslist.DataBind();
        }
        else
        {
            lmges.Visible = true;
        }
    }

posted @ 2011-11-03 03:18  108ぜIT農夫  阅读(202)  评论(0编辑  收藏  举报