admin_course.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 strsql;
    public void Bindgrid()
    {
        strsql = "select * from tabcour";
        SqlDataAdapter sqlda = new SqlDataAdapter(strsql, connections);
        DataSet datas = new DataSet();
        sqlda.Fill(datas);
        DataGrid1.DataSource = datas;
        DataGrid1.DataBind();
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user_id"] == null ||(int)Session["user_lever"] != 1)
        {
            Response.Redirect("default.aspx");
        }
        
        
        this.Title = "课程管理";
        lbtnCourse.Enabled = false;
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        connections = new SqlConnection(strconn);
        if (!IsPostBack)
        {
            Bindgrid();
        }
    }

    public void DataGrid_delete(object sender, DataGridCommandEventArgs e)
    {
        int lastPageIndex = DataGrid1.CurrentPageIndex;
        string strsql = "delete from tabcour where Crid = @crid";
        string strsql2 = "delete from tabstu_cour where Crid = @crid";
        string strsql3 = "delete from tabtea_cour where Crid = @crid";
        SqlCommand commnd = new SqlCommand(strsql, connections);
        SqlCommand commnd2 = new SqlCommand(strsql2, connections);
        SqlCommand commnd3 = new SqlCommand(strsql3, connections);
        commnd.Parameters.Add(new SqlParameter("@crid", SqlDbType.VarChar, 50));
        commnd.Parameters["@crid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        commnd.Connection.Open();
        commnd2.Parameters.Add(new SqlParameter("@crid", SqlDbType.VarChar, 50));
        commnd2.Parameters["@crid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        commnd3.Parameters.Add(new SqlParameter("@crid", SqlDbType.VarChar, 50));
        commnd3.Parameters["@crid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        try
        {


            if (DataGrid1.PageCount - DataGrid1.CurrentPageIndex == 1 && DataGrid1.Items.Count == 1)
            {
                if (DataGrid1.PageCount > 1)
                    lastPageIndex = lastPageIndex - 1;
                else
                    lastPageIndex = 0;
            }
            DataGrid1.CurrentPageIndex = lastPageIndex;
            commnd3.ExecuteNonQuery();
            commnd2.ExecuteNonQuery();
            commnd.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('数据删除成功！');</script>");

        }
        catch (SqlException ex)
        {
            Response.Write("<script language=javascript>alert('数据删除失败！');</script>");
            Response.Write(ex.Message);
        }
        commnd.Connection.Close();
        Bindgrid();
    }

    public void DataGrid_update(object sender, DataGridCommandEventArgs e)
    {
        string sqlstrings = "update tabcour set Crname=@Crname,Crper=@Crper,Crcre=@Crcre,Crkind=@Crkind where Crid=@Crid";
        SqlCommand commnd = new SqlCommand(sqlstrings, connections);
        commnd.Parameters.Add(new SqlParameter("@Crname", SqlDbType.VarChar, 50));
        commnd.Parameters.Add(new SqlParameter("@Crper", SqlDbType.Int, 4));
        commnd.Parameters.Add(new SqlParameter("@Crcre", SqlDbType.Int, 4));
        commnd.Parameters.Add(new SqlParameter("@Crkind", SqlDbType.VarChar, 50));
        commnd.Parameters.Add(new SqlParameter("@Crid", SqlDbType.VarChar, 50));
        string colvalue = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
        commnd.Parameters["@Crname"].Value = colvalue;
        colvalue = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
        commnd.Parameters["@Crper"].Value = colvalue;
        colvalue = ((TextBox)e.Item.Cells[6].Controls[0]).Text;
        commnd.Parameters["@Crcre"].Value = colvalue;
        colvalue = ((TextBox)e.Item.Cells[7].Controls[0]).Text;
        commnd.Parameters["@Crkind"].Value = colvalue;
        commnd.Parameters["@Crid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        commnd.Connection.Open();
        try
        {
            commnd.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('数据修改成功！');</script>");
            DataGrid1.EditItemIndex = -1;
        }
        catch (SqlException)
        {
            Response.Write("<script language=javascript>alert('数据修改失败！');</script>");
        }
        commnd.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 btnSearch_Click(object sender, EventArgs e)
    {
        string sqlstring;
            DataGrid1.CurrentPageIndex = 0;
        if (dropType.Text == "课程编号")
        {
             sqlstring = "select * from tabcour where Crid='" + txtKeyword.Text + "'";
        }
        else
        { 
            sqlstring = "select * from tabcour where Crname='" + txtKeyword.Text + "'";
        }
        SqlDataAdapter sqlda = new SqlDataAdapter(sqlstring, connections);
        DataSet datas = new DataSet();
        sqlda.Fill(datas);
        DataGrid1.DataSource = datas;
        DataGrid1.CurrentPageIndex = 0;
        DataGrid1.DataBind();
        if (DataGrid1.Items.Count == 0)
        {
            Response.Write("<script language=javascript>alert('查无此课程，请检查输入！');</script>");
            return;
        }
        

    }
    protected void lbtnDisplayAll_Click(object sender, EventArgs e)
    {
        Bindgrid();
    }
    protected void lbtnAdd_Click(object sender, EventArgs e)
    {
        Response.Redirect("addcourse.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)
    {

    }
    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");
    }
}