assigncourse.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 assigncourse : 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");
        }
        this.Title = "课程分配";
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections0 = new SqlConnection(strconn);
        if (!IsPostBack)
        {//教师名称下拉列表框绑定
            connections0.Open();
            string mysql = "select * from tabtea";
            SqlCommand commnd0 = new SqlCommand(mysql, connections0);
            SqlDataReader sdreader0 = commnd0.ExecuteReader();
            while (sdreader0.Read())
            {
                dropTeacherName.Items.Add(new ListItem(sdreader0["Tname"].ToString(), sdreader0["Tid"].ToString()));
            }
            connections0.Close();
            //课程名称下拉列表框绑定
            connections0.Open();
            string mysql1 = "select * from tabcour";
            SqlCommand commnd1 = new SqlCommand(mysql1, connections0);
            SqlDataReader sdreader1 = commnd1.ExecuteReader();
            while (sdreader1.Read())
            {
                dropCourseName.Items.Add(new ListItem(sdreader1["Crname"].ToString(), sdreader1["Crid"].ToString()));
            }
            connections0.Close();

            SqlConnection connections;
            string strsql;
            //string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
            connections = new SqlConnection(strconn);
            strsql = "select * from tabtea_cour";
            SqlDataAdapter da = new SqlDataAdapter(strsql, connections);
            DataSet ds = new DataSet();
            da.Fill(ds);
            DataGrid1.DataSource = ds;
            DataGrid1.DataBind();
        }
    }
    protected void lbtnOK_Click(object sender, EventArgs e)
    {
        if (txtNo.Text == "" || txtYear.Text == "")
        {
            Response.Write("<script language=javascript>alert('请输入完整数据！');</script>");
            return;
        }
        if (dropTeacherName.Text == "" || dropCourseName.Text == "")
        {
            Response.Write("<script language=javascript>alert('请首先维护教师信息或课程信息！');</script>");
            return;
        }
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections = new SqlConnection(strconn);
        connections.Open();        

        string sqlstring = "insert into tabtea_cour(TCid,Tid,Crid,Cryear) values(@TCid,@Tid,@Crid,@Cryear)";
        SqlCommand commnd = new SqlCommand(sqlstring, connections);

        commnd.Parameters.Add(new SqlParameter("@TCid", SqlDbType.Int, 4));
        commnd.Parameters["@TCid"].Value = txtNo.Text;

        commnd.Parameters.Add(new SqlParameter("@Tid", SqlDbType.VarChar, 50));
        commnd.Parameters["@Tid"].Value = dropTeacherName.SelectedItem.Value;

        commnd.Parameters.Add(new SqlParameter("@Crid", SqlDbType.VarChar, 50));
        commnd.Parameters["@Crid"].Value = dropCourseName.SelectedItem.Value;

        commnd.Parameters.Add(new SqlParameter("@Cryear", SqlDbType.VarChar, 50));
        commnd.Parameters["@Cryear"].Value = txtYear.Text;
        try
        {
            commnd.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('添加成功！');</script>");

        }
        catch (SqlException ex)
        {
            Response.Write("<script language=javascript>alert('添加失败！');</script>");
            Response.Write(ex.Message);
        }
        connections.Close();        
        string strsql = "select * from tabtea_cour";
        SqlDataAdapter da = new SqlDataAdapter(strsql, connections);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataGrid1.DataSource = ds;
        DataGrid1.DataBind();
    }
    

    public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections = new SqlConnection(strconn);        
        string strsql = "select * from tabtea_cour";
        SqlDataAdapter da = new SqlDataAdapter(strsql, connections);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataGrid1.DataSource = ds;
        DataGrid1.DataBind();
    }
    protected void lbtnBack_Click(object sender, EventArgs e)
    {        
        Response.Redirect("admin_course.aspx");
    }
}