admin_grade.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;
    string sqlstring;
    public void Bindgrid()
    {
        sqlstring = "select tabstu_cour.SCID,tabstu_cour.Sid,tabstu.Sname,tabstu.Sclaid,tabstu_cour.Crid,tabcour.Crname,tabtea.Tname,tabstu_cour.Score from tabcour,tabstu,tabtea,tabstu_cour,tabtea_cour where tabstu_cour.Crid='" + dropCrid.Text + "' and tabstu_cour.Cryear='" + txtYear.Text + "' and tabstu_cour.Crid=tabcour.Crid and tabstu_cour.Sid=tabstu.Sid and tabstu_cour.Crid=tabtea_cour.Crid and tabtea_cour.Tid=tabtea.Tid ";
        SqlCommand cmd = new SqlCommand(sqlstring, connections);
        connections.Open();
        SqlDataReader sqldr = cmd.ExecuteReader();
        //sqldr.Read();

        if (sqldr.Read())
        {
            lblCname.Visible = true;
            lblTname.Visible = true;
            lblCname.Text = "课程名称： " + sqldr["Crname"].ToString();
            lblTname.Text = "任课教师： " + sqldr["Tname"].ToString();
            connections.Close();

            connections.Open();
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlstring, connections);
            DataSet datas = new DataSet();
            sqlda.Fill(datas);
            DataGrid1.DataSource = datas;
            DataGrid1.DataBind();
        }
        else
        {
            lblMsg.Text = "<b>未找到匹配记录！</b>";
            sqldr.Close();
            //connections.Open();
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlstring, connections);
            DataSet datas = new DataSet();
            sqlda.Fill(datas);
            DataGrid1.DataSource = datas;
            DataGrid1.DataBind();
        }

        connections.Close();
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user_id"] == null || (int)Session["user_lever"]!=1 )
        {
            Response.Redirect("default.aspx");
        }
        this.Title = "成绩管理";
        lblCname.Visible = false;
        lblTname.Visible = false;
        lbtnResult.Enabled = false;
        txtYear.Text = "2006-2007";
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections0 = new SqlConnection(strconn);
        if (!IsPostBack)
        {
            //填充课程编号下拉列表框
            connections0.Open();
            string mysql0 = "select * from tabcour";
            SqlCommand commnd0 = new SqlCommand(mysql0, connections0);
            SqlDataReader sdreader0 = commnd0.ExecuteReader();

            while (sdreader0.Read())
            {
                dropCrid.Items.Add(sdreader0["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 cmd = new SqlCommand(strsql, connections);
        cmd.Parameters.Add(new SqlParameter("@SCid", SqlDbType.Char, 10));
        cmd.Parameters["@SCid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        cmd.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;

            cmd.ExecuteNonQuery();
            lblMsg.Text = "<b>删除成功</b>";

        }
        catch (SqlException)
        {
            lblMsg.Text = "<b>删除失败</b>";            
        }
        cmd.Connection.Close();
        Bindgrid();
    }

    public void DataGrid_update(object sender, DataGridCommandEventArgs e)
    {
        string strsql = "update tabstu_cour set Score=@Score where Sid=@Sid and Crid=@Crid and SCID=@SCid";
        SqlCommand cmd = new SqlCommand(strsql, connections);
        cmd.Parameters.Add(new SqlParameter("@Score", SqlDbType.Int, 4));
        cmd.Parameters.Add(new SqlParameter("@Crid", SqlDbType.VarChar, 50));
        cmd.Parameters.Add(new SqlParameter("@Sid", SqlDbType.VarChar, 50));
        cmd.Parameters.Add(new SqlParameter("@SCid", SqlDbType.Char, 10));
        string colvalue = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
        
        cmd.Parameters["@Score"].Value = colvalue;
        cmd.Parameters["@Sid"].Value = e.Item.Cells[1].Text;
        cmd.Parameters["@Crid"].Value = dropCrid.Text;
        cmd.Parameters["@SCid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        cmd.Connection.Open();
        try
        {
            cmd.ExecuteNonQuery();
            lblMsg.Text = "<b>编辑成功</b>";            
            DataGrid1.EditItemIndex = -1;
        }
        catch (SqlException)
        {
            lblMsg.Text = "<b>编辑失败</b>";            
        }
        cmd.Connection.Close();
        Bindgrid();
    }

    public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        Bindgrid();
    }
    public void DataGrid_cancel(object sender, DataGridCommandEventArgs e)
    {

        DataGrid1.EditItemIndex = -1;
        Bindgrid();

    }
    public void DataGrid_edit(object sender, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = (int)e.Item.ItemIndex;
        Bindgrid();
    }

   
    protected void lbtnQuit_Click(object sender, EventArgs e)
    {
        Session.Clear();
        Response.Redirect("default.aspx");
    }



    
    
    protected void lbtnTeacher_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_teacher.aspx");
    }
    
    protected void lbtnAssign_Click(object sender, EventArgs e)
    {
        Response.Redirect("assigncourse.aspx");
    }
    
    protected void lbtnClass_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_class.aspx");
    }
    
    protected void lbtnStudent_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_stu.aspx");
    }
    
    protected void lbtnCourse_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_course.aspx");
    }
    
    protected void lbtnSelect_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_choose.aspx");
    }
    
    protected void lbtnResult_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_grade.aspx");
    }
    protected void btnOK_Click(object sender, EventArgs e)
    {
        Bindgrid();

    }
}