addteacher.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 addteacher : System.Web.UI.Page
{
    SqlConnection connections;
    protected void Page_Load(object sender, EventArgs e)
    {
        if(Session["user_id"]== null)
        {
            Response.Redirect("default.aspx");
        }
        if((int)Session["user_lever"] != 1)
        {
            Response.Redirect("default.aspx");
        }
        this.Title = "添加新教师";
        string strconn = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        connections = new SqlConnection(strconn);
        connections.Open();
    }
    
    protected void lbtnAdd_Click(object sender, EventArgs e)
    {
        if (txtNo.Text == "" || txtName.Text == "")
        {
            Response.Write("<script language=javascript>alert('请填写所有数据！');</script>");
            return;
        }
        SqlCommand commnd = new SqlCommand("addtea", connections);
        commnd.CommandType = CommandType.StoredProcedure;
        commnd.Parameters.Add(new SqlParameter("@tid", SqlDbType.VarChar, 50));
        commnd.Parameters["@tid"].Value = txtNo.Text;
        commnd.Parameters.Add(new SqlParameter("@tname", SqlDbType.VarChar, 50));
        commnd.Parameters["@tname"].Value = txtName.Text;
        commnd.Parameters.Add(new SqlParameter("@tcol", SqlDbType.VarChar, 50));
        commnd.Parameters["@tcol"].Value = dropCollege.SelectedItem.Text;
        commnd.Connection.Open();
        try
        {
            commnd.ExecuteNonQuery();            
            Response.Write("<script language=javascript>alert('记录添加成功！');</script>");

        }
        catch (SqlException)
        {
            Response.Write("<script language=javascript>alert('记录添加失败，请检查输入数据！');</script>");
        }
        commnd.Connection.Close();
    }
    protected void lbtnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("admin_teacher.aspx");
    }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        SqlCommand commnd = new SqlCommand("select * from tabtea where Tid=@Tid", connections);
        commnd.Parameters.Add("@Tid", SqlDbType.VarChar, 50);
        commnd.Parameters["@Tid"].Value = txtNo.Text;
        SqlDataReader sdreader = commnd.ExecuteReader();
        if (sdreader.Read())
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        connections.Close();
    }
}