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_addcourse 的摘要说明。
 18    /// </summary>
 19    public class ST_addcourse : 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_name;
 25        protected System.Web.UI.WebControls.TextBox st_tbx_period;
 26        protected System.Web.UI.WebControls.TextBox st_tbx_credit;
 27        protected System.Web.UI.WebControls.TextBox st_tbx_else;
 28        protected System.Web.UI.WebControls.DropDownList st_ddl_kind;
 29        protected System.Web.UI.WebControls.Label st_lbl_note;
 30        protected System.Web.UI.WebControls.Button st_btn_reset;
 31        protected System.Web.UI.WebControls.Button st_btn_ok;
 32        protected System.Web.UI.WebControls.Label st_lbl_remind;
 33    
 34       SqlConnection st_conn;
 35        private void Page_Load(object sender, System.EventArgs e)
 36        ...{
 37            // 在此处放置用户代码以初始化页面
 38            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
 39            st_conn=new SqlConnection(st_connstr);
 40            st_conn.Open();
 41        }
 42
 43        Web Form Designer generated code#region Web Form Designer generated code
 44        override protected void OnInit(EventArgs e)
 45        ...{
 46            //
 47            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
 48            //
 49            InitializeComponent();
 50            base.OnInit(e);
 51        }
 52        
 53        /**//// <summary>
 54        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 55        /// 此方法的内容。
 56        /// </summary>
 57        private void InitializeComponent()
 58        ...{    
 59            this.st_cv_id.ServerValidate += new System.Web.UI.WebControls.ServerValidateEventHandler(this.st_cv_id_ServerValidate);
 60            this.st_btn_ok.Click += new System.EventHandler(this.st_btn_ok_Click);
 61            this.st_btn_reset.Click += new System.EventHandler(this.st_btn_reset_Click);
 62            this.Load += new System.EventHandler(this.Page_Load);
 63
 64        }
 65        #endregion
 66
 67        private void st_cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
 68        ...{
 69            
 70            SqlCommand st_comm=new SqlCommand("select * from ST_course where ST_Course_id=@Course_id",st_conn);
 71            st_comm.Parameters.Add("@Course_id",SqlDbType.VarChar,50);
 72            st_comm.Parameters["@Course_id"].Value=st_tbx_id.Text;
 73            SqlDataReader st_dr=st_comm.ExecuteReader();
 74            if(st_dr.Read())
 75            ...{
 76                args.IsValid=false;
 77            }
 78            else
 79            ...{
 80                args.IsValid=true;
 81            }
 82            st_conn.Close();
 83        }
 84
 85        private void st_btn_ok_Click(object sender, System.EventArgs e)
 86        ...{
 87            //创建sql命令
 88            SqlCommand st_comm=new SqlCommand("insert_course_1",st_conn);
 89            //调用存储过程
 90            st_comm.CommandType=CommandType.StoredProcedure;
 91            try
 92            ...{
 93                st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
 94                st_comm.Parameters["@Course_id"].Value=st_tbx_id.Text;
 95                st_comm.Parameters.Add(new SqlParameter("@Course_name",SqlDbType.VarChar,50));
 96                st_comm.Parameters["@Course_name"].Value=st_tbx_name.Text;
 97                st_comm.Parameters.Add(new SqlParameter("@Course_period",SqlDbType.Int,4));
 98                st_comm.Parameters["@Course_period"].Value=st_tbx_period.Text;
 99                st_comm.Parameters.Add(new SqlParameter("@Course_credit",SqlDbType.Int,4));
100                st_comm.Parameters["@Course_credit"].Value=st_tbx_credit.Text;                
101                st_comm.Parameters.Add(new SqlParameter("@Course_kind",SqlDbType.Int,4));
102                st_comm.Parameters["@Course_kind"].Value=st_ddl_kind.SelectedItem.Value;
103                st_comm.Parameters.Add(new SqlParameter("@Course_describe",SqlDbType.VarChar,50));
104                st_comm.Parameters["@Course_describe"].Value=st_tbx_else.Text;
105                st_comm.Connection.Open();
106                st_comm.ExecuteNonQuery();
107                Response.Redirect("ST_course.aspx");
108                
109            }
110            catch
111            ...{
112                st_lbl_remind.Text="添加失败,请检查输入数据！";
113                st_lbl_remind.Style["color"]="red";
114            }
115            st_comm.Connection.Close();
116        }
117
118        private void st_btn_reset_Click(object sender, System.EventArgs e)
119        ...{
120            Response.Redirect("ST_addcourse.aspx");
121        }
122
123
124    }
125}
126