st_modifycourse.aspx.cs

来自「学生管理系统。C#开发。偏重与数据库的应用。」· CS 代码 · 共 126 行

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 ST_modifycourse : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //教师名称下拉列表框绑定
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
        //连接本地计算机的sms数据库
        SqlConnection st_conn0 = new SqlConnection(st_connstr);
        if (!IsPostBack)
        {
            st_conn0.Open();
            string st_sql = "select * from ST_teacher";
            SqlCommand st_comm0 = new SqlCommand(st_sql, st_conn0);
            SqlDataReader st_dr0 = st_comm0.ExecuteReader();
            while (st_dr0.Read())
            {
                st_ddl_teacher.Items.Add(new ListItem(st_dr0["ST_Teacher_name"].ToString(), st_dr0["ST_Teacher_id"].ToString()));
            }
            st_conn0.Close();
            //班级名称下拉列表框绑定
            st_conn0.Open();
            string st_sql2 = "select * from ST_class";
            SqlCommand st_comm2 = new SqlCommand(st_sql2, st_conn0);
            SqlDataReader st_dr2 = st_comm2.ExecuteReader();
            while (st_dr2.Read())
            {
                st_ddl_class.Items.Add(new ListItem(st_dr2["ST_Class_name"].ToString(), st_dr2["ST_Class_id"].ToString()));
            }
            st_conn0.Close();
            st_conn0.Open();
            string st_sql1 = "select * from ST_teacher_course where ST_Course_id=@Course_id";
            SqlCommand st_comm1 = new SqlCommand(st_sql1, st_conn0);
            st_comm1.Parameters.Add(new SqlParameter("@Course_id", SqlDbType.VarChar, 50));
            st_comm1.Parameters["@Course_id"].Value = Request.QueryString["ST_Course_id"].ToString();
            SqlDataReader st_dr1 = st_comm1.ExecuteReader();
            if (st_dr1.Read())
            {
                st_tbx_course.Text = st_dr1["ST_Course_id"].ToString();
                st_ddl_teacher.Items.FindByValue(st_dr1["ST_Teacher_id"].ToString()).Selected = true;
                st_ddl_class.Items.FindByValue(st_dr1["ST_Class_id"].ToString()).Selected = true;
                st_ddl_class.Items.FindByValue(st_dr1["ST_Class_id"].ToString()).Attributes.CssStyle["color"] = "red";
                st_tbx_year.Text = st_dr1["ST_Course_year"].ToString();
            }
            else
            {
                Response.Write("<LINK href=\"ST_COMMAN/style.css\" type=\"text/css\" rel=\"stylesheet\">此课程未分配教师！请<a href=\"ST_course.aspx\">返回</a>");
                Response.End();
            }
            st_conn0.Close();
        }
    }
    protected void st_btn_delete_Click(object sender, EventArgs e)
    {
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
			SqlConnection st_conn=new SqlConnection(st_connstr);
			st_conn.Open();
			//删除语句
			string st_sqlstr="delete from ST_teacher_course  where ST_Teacher_id=@Teacher_id and ST_Class_id=@Class_id and ST_Course_year=@Course_year and ST_Course_id=@Course_id";
			SqlCommand st_comm=new SqlCommand  (st_sqlstr,st_conn);
			
				st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
				st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
				st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
				st_comm.Parameters.Add(new SqlParameter("@Course_year",SqlDbType.VarChar,50));
				st_comm.Parameters["@Course_id"].Value=st_tbx_course.Text;
				st_comm.Parameters["@Teacher_id"].Value=st_ddl_teacher.SelectedItem.Value;
				st_comm.Parameters["@Class_id"].Value=st_ddl_class.SelectedItem.Value;
				st_comm.Parameters["@course_year"].Value=st_tbx_year.Text;
			try
			{	
				//删除语句
				st_comm.ExecuteNonQuery();
				st_lbl_note.Text="删除成功，请返回！";
				st_btn_ok.Enabled=false;
				st_btn_delete.Enabled=false;
			}
			catch
			{
				st_lbl_note.Text="删除有误,请查明对应关系，再做删除！";
				}
			st_conn.Close();		
		}		 
    
    protected void st_btn_ok_Click(object sender, EventArgs e)
    {
        //获得字符串连接字符串
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
        SqlConnection st_conn = new SqlConnection(st_connstr);
        st_conn.Open();
        //更新sql语句字符串
        string st_sqlstr = "update ST_teacher_course set ST_Teacher_id=@Teacher_id,ST_Class_id=@Class_id,ST_Course_year=@Course_year where ST_Course_id=@Course_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@Course_id", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Teacher_id", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Class_id", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Course_year", SqlDbType.VarChar, 50));
        st_comm.Parameters["@Course_id"].Value = Request.QueryString["ST_Course_id"].ToString();
        st_comm.Parameters["@Teacher_id"].Value = st_ddl_teacher.SelectedItem.Value;
        st_comm.Parameters["@Class_id"].Value = st_ddl_class.SelectedItem.Value;
        st_comm.Parameters["@course_year"].Value = st_tbx_year.Text;
        st_comm.ExecuteNonQuery();
        try
        {
            st_lbl_note.Text = "修改成功，请返回！";
        }
        catch
        {
            st_lbl_note.Text = "修改有误，请检查输入！";
        }
        st_conn.Close();
    }
}