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_addclass 的摘要说明。
 18    /// </summary>
 19    public class ST_addclass : System.Web.UI.Page
 20    ...{
 21        protected System.Web.UI.WebControls.TextBox st_tbx_id;
 22        protected System.Web.UI.WebControls.CustomValidator st_cv_id;
 23        protected System.Web.UI.WebControls.RequiredFieldValidator st_rfv_id;
 24        protected System.Web.UI.WebControls.TextBox st_tbx_department;
 25        protected System.Web.UI.WebControls.DropDownList st_ddl_college;
 26        protected System.Web.UI.WebControls.Button st_btn_add;
 27        protected System.Web.UI.WebControls.Label st_lbl_note;
 28        protected System.Web.UI.WebControls.TextBox st_tbx_teacher;
 29        protected System.Web.UI.WebControls.TextBox st_tbx_name;
 30        SqlConnection st_conn;
 31        private void Page_Load(object sender, System.EventArgs e)
 32        ...{
 33            // 在此处放置用户代码以初始化页面
 34            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
 35            st_conn=new SqlConnection(st_connstr);
 36            st_conn.Open();
 37        }
 38
 39        Web Form Designer generated code#region Web Form Designer generated code
 40        override protected void OnInit(EventArgs e)
 41        ...{
 42            //
 43            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
 44            //
 45            InitializeComponent();
 46            base.OnInit(e);
 47        }
 48        
 49        /**//// <summary>
 50        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 51        /// 此方法的内容。
 52        /// </summary>
 53        private void InitializeComponent()
 54        ...{    
 55            this.st_btn_add.Click += new System.EventHandler(this.st_btn_add_Click);
 56            this.Load += new System.EventHandler(this.Page_Load);
 57
 58        }
 59        #endregion
 60
 61        
 62        private void st_cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
 63        ...{
 64            SqlCommand st_comm=new SqlCommand("select * from ST_class where ST_Class_id=@Class_id",st_conn);
 65            st_comm.Parameters.Add("@Class_id",SqlDbType.VarChar,50);
 66            st_comm.Parameters["@Class_id"].Value=st_tbx_id.Text;
 67            SqlDataReader st_dr=st_comm.ExecuteReader();
 68            if(st_dr.Read())
 69            ...{
 70                args.IsValid=false;
 71            }
 72            else
 73            ...{
 74                args.IsValid=true;
 75            }
 76            st_conn.Close();
 77        }
 78
 79        private void st_btn_add_Click(object sender, System.EventArgs e)
 80        ...{
 81            SqlCommand st_comm=new SqlCommand("insert_class_1",st_conn);
 82            st_comm.CommandType=CommandType.StoredProcedure;
 83            st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
 84            st_comm.Parameters["@Class_id"].Value=st_tbx_id.Text;
 85            st_comm.Parameters.Add(new SqlParameter("@Class_department",SqlDbType.VarChar,50));
 86            st_comm.Parameters["@Class_department"].Value=st_tbx_department.Text;
 87            st_comm.Parameters.Add(new SqlParameter("@Class_college",SqlDbType.VarChar,50));
 88            st_comm.Parameters["@Class_college"].Value=st_ddl_college.SelectedItem.Text;
 89            st_comm.Parameters.Add(new SqlParameter("@Class_teacherid",SqlDbType.VarChar,50));
 90            st_comm.Parameters["@Class_teacherid"].Value=st_tbx_teacher.Text;            
 91            st_comm.Parameters.Add(new SqlParameter("@Class_name",SqlDbType.VarChar,50));
 92            st_comm.Parameters["@Class_name"].Value=st_tbx_name.Text;
 93            try
 94            ...{
 95                st_comm.Connection.Close();
 96            }
 97            catch...{}
 98            st_comm.Connection.Open();
 99            try
100            ...{
101                st_comm.ExecuteNonQuery();
102                Response.Redirect("ST_classes.aspx");
103                
104            }
105            catch(SqlException)
106            ...{
107                st_lbl_note.Text="添加失败";
108                st_lbl_note.Style["color"]="red";
109            }
110            st_comm.Connection.Close();
111        }
112    }
113}
114