pg.ascx.cs

基于asp.net的网上选课系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;

public partial class pg : System.Web.UI.UserControl
{
    protected string connString;
    public string cmdstr;
    protected int pageNum = -1; //总页数
    protected int recNum = -1;//总记录数
    protected int pageRecNum = -1;//一页中的记录条数
    protected int curPageNO = -1;//当前页的页码
    public  DataList DataList1;

    public DataList datalist1
    {
        get
        {
            return DataList1;
        }
        set
        {
            DataList1 = value;
        }
    }

    public string CmdStr
    {
        get
        {
            return cmdstr;
        }
        set
        {
            cmdstr = value;
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        connString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=selectCourses;Data Source=.";
        if (!Page.IsPostBack)
        {
            //-----------recNum
            AdminSQL admin = new AdminSQL();
            admin.Open();
            DataSet ds = new DataSet();
            ds = admin.GetDataSet(cmdstr, "temp");
            recNum = ds.Tables["temp"].Rows.Count;
            admin.Close();
            //------------------pageRecNum,pageNum

            pageRecNum = Convert.ToInt32(lblPageRowNum.Text);
            if (Convert.ToInt32(recNum % pageRecNum) == 0)
            {
                pageNum = Convert.ToInt32(recNum / pageRecNum);
            }
            else
            {
                pageNum = Convert.ToInt32(recNum / pageRecNum) + 1;
            }
            //----------------- ddlJumpToPageNum
            ddlJumpToPageNum.Items.Clear();
            for (int i = 1; i <= pageNum; i++)
            {
                ddlJumpToPageNum.Items.Add(i.ToString());
            }
            lblPageNum.Text = pageNum.ToString();
            ViewState["PageRowNum"] = pageRecNum;
            ViewState["RecNum"] = recNum;
            ViewState["PageNum"] = pageNum;

            //-----------------curPageNO
            curPageNO = 1;
            ViewState["CurPageNO"] = curPageNO;
        }
        pageRecNum = Convert.ToInt32(ViewState["PageRowNum"]);
        recNum = Convert.ToInt32(ViewState["RecNum"]);
        curPageNO = Convert.ToInt32(ViewState["CurPageNO"]);
        pageNum = Convert.ToInt32(ViewState["PageNum"]);
        //------------pageNum
        if (pageRecNum == -1 || recNum == -1)
        {
            Response.Write("<script>javascript:alert('发生错误！');</script>");
            Response.End();
        }
        if (curPageNO <= 1)
        {
            curPageNO = 1;
            btnFirst.Enabled = false;
            btnPreview.Enabled = false;
        }

        lblRecNum.Text = recNum.ToString();
        lblCurPageNO.Text = curPageNO.ToString();

        //-----------------
        if (!Page.IsPostBack)
        {
            BindData();
        }

    }


    public void BindData()
    {
        //----------
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = connString;
        conn.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(cmdstr, conn);
        DataSet ds = new DataSet();
        //取ds中从(curPageNO - 1) * pageRecNum开始的pageRecNum条记录
        da.Fill(ds, (curPageNO - 1) * pageRecNum, pageRecNum, "temp");
        //----------
        DataList1.DataSource = ds.Tables["temp"];
        DataList1.DataBind();
        ds.Clear();
        conn.Close();
        lblCurPageNO.Text = curPageNO.ToString();
    }

    #region 移动页面
    private void MoveFirst()
    {
        curPageNO = 1;
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------
        btnFirst.Enabled = false;
        btnPreview.Enabled = false;
        btnNext.Enabled = true;
        btnLast.Enabled = true;
    }
    private void MovePrevious()
    {
        curPageNO = curPageNO - 1;
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------
        if (curPageNO == 1)
        {
            btnFirst.Enabled = false;
            btnPreview.Enabled = false;
        }
        btnNext.Enabled = true;
        btnLast.Enabled = true;
    }
    private void MoveNext()
    {
        curPageNO = curPageNO + 1;
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------
        btnFirst.Enabled = true;
        btnPreview.Enabled = true;
        if (curPageNO == pageNum)
        {
            btnNext.Enabled = false;
            btnLast.Enabled = false;
        }
    }
    private void MoveLast()
    {
        curPageNO = pageNum;
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------
        btnFirst.Enabled = true;
        btnPreview.Enabled = true;
        btnNext.Enabled = false;
        btnLast.Enabled = false;
    }
    #endregion



    public void ddlJumpToPageNum_SelectedIndexChanged(object sender, System.EventArgs e)
    {
        curPageNO = Convert.ToInt32(ddlJumpToPageNum.SelectedValue);
        BindData();
    }
    public void recordchanged()
    {
        AdminSQL admin = new AdminSQL();
        admin.Open();
        DataSet ds = new DataSet();
        ds = admin.GetDataSet(cmdstr, "temp");

        recNum = ds.Tables["temp"].Rows.Count;
        lblRecNum.Text = recNum.ToString();
        //------------------pageRecNum,pageNum
        if (Convert.ToInt32(recNum % pageRecNum) == 0)
        {
            pageNum = Convert.ToInt32(recNum / pageRecNum);
        }
        else
        {
            pageNum = Convert.ToInt32(recNum / pageRecNum) + 1;
        }
        ddlJumpToPageNum.Items.Clear();
        for (int i = 1; i <= pageNum; i++)
        {
            ddlJumpToPageNum.Items.Add(i.ToString());
        }
        lblPageNum.Text = pageNum.ToString();
        lblCurPageNO.Text = pageNum.ToString();
        ViewState["PageRowNum"] = pageRecNum;
        ViewState["RecNum"] = recNum;
        ViewState["PageNum"] = pageNum;
        //-----------------curPageNO
        curPageNO = Convert.ToInt32(ViewState["CurPageNO"]);
        if (curPageNO > pageNum)
        {
            curPageNO = pageNum;
        }
        if (curPageNO <= 1)
        {
            curPageNO = 1;
        }
        ddlJumpToPageNum.SelectedValue = "1";
        ViewState["CurPageNO"] = curPageNO;
        //-----------------
        if (curPageNO == 1)
        {
            btnFirst.Enabled = false;
            btnPreview.Enabled = false;
        }
        if (curPageNO == pageNum)
        {
            btnNext.Enabled = false;
            btnLast.Enabled = false;
        }
        DataList1.EditItemIndex = -1;
        BindData();
    }
    public void btnFirst_Click(object sender, System.EventArgs e)
    {
        MoveFirst();
    }

    public void btnPreview_Click(object sender, System.EventArgs e)
    {
        MovePrevious();
    }

    public  void btnNext_Click(object sender, System.EventArgs e)
    {
        MoveNext();
    }

    public void btnLast_Click(object sender, System.EventArgs e)
    {
        MoveLast();
    }
}