admin_choose.aspx.cs

教务管理系统

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.SqlClient;

public partial class admin : System.Web.UI.Page
{

    SqlConnection connections;
  
    public void Bindgrid()
    {
        DataGrid1.CurrentPageIndex = 0;
        string sqlstring = "select tabstu_cour.scid,tabstu.Sid,tabstu.Sname,tabstu.Sclaid from tabstu_cour,tabstu,tabtea_cour where tabstu_cour.Crid='" + dropCourseName.SelectedItem.Value + "' and tabstu_cour.Cryear=tabtea_cour.Cryear and tabstu_cour.Cryear='" + txtYear.Text + "'and tabtea_cour.Tid='" + dropTeacher.SelectedItem.Value + "'and tabstu_cour.Crid=tabtea_cour.Crid and tabstu.Sid=tabstu_cour.Sid";
        SqlDataAdapter sqlda = new SqlDataAdapter(sqlstring, connections);
        DataSet datas = new DataSet();
        sqlda.Fill(datas);
        DataGrid1.DataSource = datas;
        DataGrid1.DataBind();
        lblMsg.Text = "<b>选此课程的学生总人数为：" + DataGrid1.Items.Count +"</b>";                   
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user_id"] == null || (int)Session["user_lever"] != 1)
        {
            Response.Redirect("default.aspx");
        }
        this.Title = "选课管理";
        lbtnChoose.Enabled = false;
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections0 = new SqlConnection(strconn);
        if (!IsPostBack)
        {
             //填充教师名称下拉列表框
            connections0.Open();
            string mysql0 = "select * from tabtea";
            SqlCommand commnd0 = new SqlCommand(mysql0, connections0);
            SqlDataReader sdreader0 = commnd0.ExecuteReader();
            
            while (sdreader0.Read())
            {
                dropTeacher.Items.Add(new ListItem(sdreader0["Tname"].ToString(), sdreader0["Tid"].ToString()));
            }

            connections0.Close();

            //填充课程名称下拉列表框
            connections0.Open();            
            string mysql1 = "select * from tabcour";
            SqlCommand commnd1 = new SqlCommand(mysql1, connections0);
            SqlDataReader sdreader1 = commnd1.ExecuteReader();
            
            while (sdreader1.Read())
            {
                dropCourseName.Items.Add(new ListItem(sdreader1["Crname"].ToString(), sdreader1["Crid"].ToString()));
            }
            connections0.Close();
        }       
        connections = new SqlConnection(strconn);
    }



    public void DataGrid_delete(object sender, DataGridCommandEventArgs e)
    {
        int lastPageIndex = DataGrid1.CurrentPageIndex;

        string strsql = "delete from tabstu_cour where SCID = @scid";
        SqlCommand commnd = new SqlCommand(strsql, connections);
        commnd.Parameters.Add(new SqlParameter("@SCID", SqlDbType.BigInt, 8));
        commnd.Parameters["@scid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        commnd.Connection.Open();
        try
        {
            if (DataGrid1.PageCount - DataGrid1.CurrentPageIndex == 1 && DataGrid1.Items.Count == 1)
            {
                if (DataGrid1.PageCount > 1)
                    lastPageIndex = lastPageIndex - 1;
                else
                    lastPageIndex = 0;
            }
            DataGrid1.CurrentPageIndex = lastPageIndex;
            commnd.ExecuteNonQuery();
            lblMsg.Text = "<b>删除成功</b>";
            
            
            
        }
        catch (SqlException)
        {
            lblMsg.Text = "<b>删除失败</b>";
            
        }
        commnd.Connection.Close();
        Bindgrid();
    }

    

    public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        Bindgrid();
    }
    
    protected void lbtnQuit_Click(object sender, EventArgs e)
    {
        Session.Clear();
        Response.Redirect("default.aspx");
    }

    protected void lbtnSearch_Click(object sender, EventArgs e)
    {
        Bindgrid();
    }

    
   
    protected void lbtnTeacher_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_teacher.aspx");
    }
    protected void lbtnCourse_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_course.aspx");
    }
    protected void lbtnClass_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_class.aspx");
    }
    protected void lbtnChoose_Click(object sender, EventArgs e)
    {

    }

    protected void lbtnResult_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_grade.aspx");
    }
    protected void lbtnStudent_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_stu.aspx");
    }
}