course_edit.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 correctcourse : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if ((Session["user_id"] == null || (int)Session["user_lever"] != 1))
        {
            Response.Redirect("default.aspx");
        }
        //教师名称下拉列表框绑定
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections0 = new SqlConnection(strconn);
        txtNo.ReadOnly = true;
        if (!IsPostBack)
        {
            connections0.Open();
            string sqlstrings0 = "select * from tabtea";
            SqlCommand commnd0 = new SqlCommand(sqlstrings0, connections0);
            SqlDataReader dr0 = commnd0.ExecuteReader();
            while (dr0.Read())
            {
                dropTeacher.Items.Add(new ListItem(dr0["Tname"].ToString(), dr0["Tid"].ToString()));
            }
            connections0.Close();
            connections0.Open();
            string sqlstrings1 = "select * from tabtea_cour where Crid=@Crid";
            SqlCommand commnd1 = new SqlCommand(sqlstrings1, connections0);
            commnd1.Parameters.Add(new SqlParameter("@Crid", SqlDbType.VarChar, 50));
            commnd1.Parameters["@Crid"].Value = Request.QueryString["Crid"].ToString();
            SqlDataReader dr1 = commnd1.ExecuteReader();
            if (dr1.Read())
            {
                txtNo.Text = dr1["Crid"].ToString();
                dropTeacher.Items.FindByValue(dr1["Tid"].ToString()).Selected = true;
                txtYear.Text = dr1["Cryear"].ToString();
            }
            else
            {
                Response.Write("此课程未分配教师！请返回");
                Response.End();
            }
            connections0.Close();
        }
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_course.aspx");
    }
    protected void btnEdit_Click(object sender, EventArgs e)
    {
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections = new SqlConnection(strconn);
        connections.Open();
        string sqlstrings = "update tabtea_cour set Tid=@Tid,Cryear=@Cryear where Crid=@Crid";
        SqlCommand commnd = new SqlCommand(sqlstrings, connections);
        commnd.Parameters.Add(new SqlParameter("@Crid", SqlDbType.VarChar, 50));
        commnd.Parameters.Add(new SqlParameter("@Tid", SqlDbType.VarChar, 50));
        commnd.Parameters.Add(new SqlParameter("@Cryear", SqlDbType.VarChar, 50));
        commnd.Parameters["@Crid"].Value = Request.QueryString["Crid"].ToString();
        commnd.Parameters["@Tid"].Value = dropTeacher.SelectedItem.Value;
        commnd.Parameters["@Cryear"].Value = txtYear.Text;
        commnd.ExecuteNonQuery();
        try
        {
            Response.Write("<script language=javascript>alert('数据修改成功！');</script>");
        }
        catch
        {
            Response.Write("<script language=javascript>alert('数据修改失败，请检查输入！');</script>"); 
        }
        connections.Close();
    }
    protected void btnDel_Click(object sender, EventArgs e)
    {
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections = new SqlConnection(strconn);
        connections.Open();
        string sqlstrings = "delete from tabtea_cour  where Tid=@Tid  and Cryear=@Cryear and Crid=@Crid";
        SqlCommand commnd = new SqlCommand(sqlstrings, connections);

        commnd.Parameters.Add(new SqlParameter("@Crid", SqlDbType.VarChar, 50));
        commnd.Parameters.Add(new SqlParameter("@Tid", SqlDbType.VarChar, 50));

        commnd.Parameters.Add(new SqlParameter("@Cryear", SqlDbType.VarChar, 50));
        commnd.Parameters["@Crid"].Value = txtNo.Text;
        commnd.Parameters["@Tid"].Value = dropTeacher.SelectedItem.Value;

        commnd.Parameters["@Cryear"].Value = txtYear.Text;
        try
        {
            commnd.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('删除成功！');</script>");
            btnEdit.Enabled = false;
            btnDel.Enabled = false;
        }
        catch (SqlException ex)
        {
            Response.Write("<script language=javascript>alert('删除失败！');</script>");
            Response.Write(ex.Message);
        }
        connections.Close();		
    }
}