CmsWeb/html/getenvironment.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;


public partial class html_getenvironment_ : System.Web.UI.Page
{
    Cms.BLL.C_article bll = new Cms.BLL.C_article();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind();
        }
    }
    public void Bind()
    {
        int pagenow = 0;
        int pid = 0;
        if (Request.Params["page"] != null)
        {
            pagenow = Convert.ToInt32(Request.Params["page"]);
        }
        if (Request.Params["classid"] != null)
        {
            pid = Convert.ToInt32(Request.Params["classid"]);
        }
        DataSet ds = bll.GetList("parentId=" + pid);
        int count = ds.Tables[0].Rows.Count;
        //if (count % 4 == 1)
        //{
        int start = (pagenow - 1) * 8 + 1;
        int end = pagenow * 8;

        string tearname = new Cms.BLL.C_Column().GetModel(pid).name.ToString();
        DataSet ds_teacher = Cms.DBUtility.DbHelperSQL.Query("SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.orderNumber desc )AS Row, T.*  from view_channel_" + tearname + " T WHERE parentId=" + pid + "  ) TT WHERE TT.Row between " + start + " and " + end);
        //ds = bll.GetListByPage("parentId=" + pid, "updatetime desc", start, end);
        if (ds_teacher != null && ds_teacher.Tables[0].Rows.Count > 0)
        {
            RepeaterNewlist.DataSource = ds_teacher.Tables[0].DefaultView;
            RepeaterNewlist.DataBind();
        }
        //Response.Write(count%4);
        //}


    }
}