admin_stu.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 tabstu";
        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)
        {
            Response.Redirect("default.aspx");
        }
        this.Title = "学生管理";
        lbtnStudent.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 tabstu where Sid=@userid";
        string strsql2 = "delete from users where user_id=@userid";
        SqlCommand commnd = new SqlCommand(strsql, connections);
        SqlCommand commnd2 = new SqlCommand(strsql2, connections);
        commnd.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar, 50));
        commnd.Parameters["@userid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
        commnd.Connection.Open();
        commnd2.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar, 50));
        commnd2.Parameters["@userid"].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;
            commnd.ExecuteNonQuery();
            commnd2.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 strsql = "update tabstu set Sname=@Sname,Ssex=@Ssex,Snati=@Snati,Sbir=@Sbir,Stime=@Stime,Sclaid=@Sclaid,Saddr=@Saddr,Selse=@Selse where Sid=@Sid";
        SqlCommand commnd = new SqlCommand(strsql, connections);
        try
        {
            commnd.Parameters.Add(new SqlParameter("@sname", SqlDbType.VarChar, 50));
            commnd.Parameters.Add(new SqlParameter("@ssex", SqlDbType.Char, 10));
            commnd.Parameters.Add(new SqlParameter("@snati", SqlDbType.Char, 10));
            commnd.Parameters.Add(new SqlParameter("@sbir", SqlDbType.VarChar, 50));
            commnd.Parameters.Add(new SqlParameter("@stime", SqlDbType.VarChar, 50));
            commnd.Parameters.Add(new SqlParameter("@sclaid", SqlDbType.VarChar, 50));
            commnd.Parameters.Add(new SqlParameter("@saddr", SqlDbType.VarChar, 50));
            commnd.Parameters.Add(new SqlParameter("@selse", SqlDbType.VarChar, 50));
            commnd.Parameters.Add(new SqlParameter("@sid", SqlDbType.VarChar, 50));
            string colvalue = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
            commnd.Parameters["@sname"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
            commnd.Parameters["@ssex"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
            commnd.Parameters["@snati"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[6].Controls[0]).Text;
            commnd.Parameters["@sbir"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[7].Controls[0]).Text;
            commnd.Parameters["@stime"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[8].Controls[0]).Text;
            commnd.Parameters["@sclaid"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[9].Controls[0]).Text;
            commnd.Parameters["@saddr"].Value = colvalue;
            colvalue = ((TextBox)e.Item.Cells[10].Controls[0]).Text;
            commnd.Parameters["@selse"].Value = colvalue;
            commnd.Parameters["@sid"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
            commnd.Connection.Open();
            commnd.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('数据修改成功！');</script>");
            DataGrid1.EditItemIndex = -1;
        }
        catch
        {
            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 tabstu where Sid='" + txtKeyword.Text + "'";
        }
        else
        { 
            sqlstring = "select * from tabstu where Sname='" + 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("addstu.aspx");
    }
    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 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 lbtnStudent_Click(object sender, EventArgs e)
    {

    }
    protected void lbtnUser_Click(object sender, EventArgs e)
    {
        if (Session["user_id"].ToString() != "admin")
        {
            Response.Write("<script language=javascript>alert('你没有执行此操作的权限！');</script>");
            return;
        }
        Response.Redirect("admin_user.aspx");
    }
}