1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Data.SqlClient;
  6using System.Drawing;
  7using System.Web;
  8using System.Web.SessionState;
  9using System.Web.UI;
 10using System.Web.UI.WebControls;
 11using System.Web.UI.HtmlControls;
 12using System.Configuration;
 13
 14namespace STGROUP
 15...{
 16    /**//// <summary>
 17    /// ST_addteacher 的摘要说明。
 18    /// </summary>
 19    public class ST_addteacher : System.Web.UI.Page
 20    ...{
 21        protected System.Web.UI.WebControls.CustomValidator st_cv_id;
 22        protected System.Web.UI.WebControls.TextBox st_tbx_id;
 23        protected System.Web.UI.WebControls.TextBox st_tbx_name;
 24        protected System.Web.UI.WebControls.DropDownList st_ddl_college;
 25        protected System.Web.UI.WebControls.Label st_lbl_note;
 26        protected System.Web.UI.WebControls.Button st_btn_add;
 27        protected System.Web.UI.WebControls.RequiredFieldValidator st_rfv_id;
 28        SqlConnection st_conn;
 29        private void Page_Load(object sender, System.EventArgs e)
 30        ...{
 31            // 在此处放置用户代码以初始化页面
 32            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
 33            st_conn=new SqlConnection(st_connstr);
 34            st_conn.Open();
 35        }
 36
 37        Web Form Designer generated code#region Web Form Designer generated code
 38        override protected void OnInit(EventArgs e)
 39        ...{
 40            //
 41            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
 42            //
 43            InitializeComponent();
 44            base.OnInit(e);
 45        }
 46        
 47        /**//// <summary>
 48        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 49        /// 此方法的内容。
 50        /// </summary>
 51        private void InitializeComponent()
 52        ...{    
 53            this.st_cv_id.ServerValidate += new System.Web.UI.WebControls.ServerValidateEventHandler(this.st_cv_id_ServerValidate);
 54            this.st_btn_add.Click += new System.EventHandler(this.st_btn_add_Click);
 55            this.Load += new System.EventHandler(this.Page_Load);
 56
 57        }
 58        #endregion
 59
 60        private void st_cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
 61        ...{
 62                SqlCommand st_comm=new SqlCommand("select * from ST_teacher where ST_Teacher_id=@Teacher_id",st_conn);
 63            st_comm.Parameters.Add("@Teacher_id",SqlDbType.VarChar,50);
 64            st_comm.Parameters["@Teacher_id"].Value=st_tbx_id.Text;
 65            SqlDataReader dr=st_comm.ExecuteReader();
 66            if(dr.Read())
 67            ...{
 68                args.IsValid=false;
 69            }
 70            else
 71            ...{
 72                args.IsValid=true;
 73            }
 74            st_conn.Close();
 75        
 76        }
 77
 78        private void st_btn_add_Click(object sender, System.EventArgs e)
 79        ...{
 80            SqlCommand st_comm=new SqlCommand("insert_teacher_1",st_conn);
 81            st_comm.CommandType=CommandType.StoredProcedure;
 82            st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
 83            st_comm.Parameters["@Teacher_id"].Value=st_tbx_id.Text;
 84            st_comm.Parameters.Add(new SqlParameter("@Teacher_name",SqlDbType.VarChar,50));
 85            st_comm.Parameters["@Teacher_name"].Value=st_tbx_name.Text;            
 86            st_comm.Parameters.Add(new SqlParameter("@Teacher_college",SqlDbType.VarChar,50));
 87            st_comm.Parameters["@Teacher_college"].Value=st_ddl_college.SelectedItem.Text;
 88            st_comm.Connection.Open();
 89            try
 90            ...{
 91                st_comm.ExecuteNonQuery();
 92                Response.Redirect("ST_teacher.aspx");
 93                                
 94            }
 95            catch(SqlException)
 96            ...{
 97                st_lbl_note.Text="添加失败";
 98                st_lbl_note.Style["color"]="red";
 99            }
100            st_comm.Connection.Close();
101        }
102    }
103}
104