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    /// course 的摘要说明。
 18    /// </summary>
 19    public class ST_course : System.Web.UI.Page
 20    ...{
 21        SqlConnection st_conn;
 22        protected System.Web.UI.WebControls.DataGrid st_dtg_course;
 23        protected System.Web.UI.WebControls.TextBox st_tbx_name;
 24        protected System.Web.UI.WebControls.TextBox st_tbx_id;
 25        protected System.Web.UI.WebControls.Button st_btn_search;
 26        protected System.Web.UI.WebControls.Label st_lbl_note;
 27        protected System.Web.UI.WebControls.Button st_btn_exit;
 28        string st_sqlstr;
 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            if(!IsPostBack) 
 35                ST_BindGrid();
 36        }
 37
 38        Web Form Designer generated code#region Web Form Designer generated code
 39        override protected void OnInit(EventArgs e)
 40        ...{
 41            //
 42            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
 43            //
 44            InitializeComponent();
 45            base.OnInit(e);
 46        }
 47        
 48        /**//// <summary>
 49        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 50        /// 此方法的内容。
 51        /// </summary>
 52        private void InitializeComponent()
 53        ...{    
 54            this.st_btn_search.Click += new System.EventHandler(this.st_btn_search_Click);
 55            this.st_btn_exit.Click += new System.EventHandler(this.st_btn_exit_Click);
 56            this.Load += new System.EventHandler(this.Page_Load);
 57
 58        }
 59        #endregion
 60        public void DataGrid_Page(object sender,DataGridPageChangedEventArgs e)
 61        ...{
 62            st_dtg_course.CurrentPageIndex=e.NewPageIndex;
 63            ST_BindGrid();
 64        }
 65        public void DataGrid_edit(object sender,DataGridCommandEventArgs e)
 66        ...{
 67            
 68            st_dtg_course.EditItemIndex=(int)e.Item.ItemIndex;
 69            ST_BindGrid();
 70            
 71        }
 72        public void DataGrid_cancel(object sender,DataGridCommandEventArgs e)
 73        ...{
 74            
 75            st_dtg_course.EditItemIndex=-1;
 76            ST_BindGrid();
 77            
 78        }
 79        public void DataGrid_delete(object sender,DataGridCommandEventArgs e)
 80        ...{
 81            
 82            string st_sqlstr="delete from ST_course where ST_Course_id=@course_id";
 83            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
 84            st_comm.Parameters.Add(new SqlParameter("@course_id",SqlDbType.VarChar,50));
 85            st_comm.Parameters["@course_id"].Value=st_dtg_course.DataKeys[(int)e.Item.ItemIndex];
 86            st_comm.Connection.Open();
 87            try
 88            ...{
 89                st_comm.ExecuteNonQuery();
 90                st_lbl_note.Text="删除成功";
 91                
 92            }
 93            catch(SqlException)
 94            ...{
 95                st_lbl_note.Text="删除失败";
 96                st_lbl_note.Style["color"]="red";
 97            }
 98            st_comm.Connection.Close();            
 99            ST_BindGrid();
100        }
101        public void DataGrid_update(object sender,DataGridCommandEventArgs e)
102        ...{
103            string st_sqlstr="update ST_course set ST_Course_name=@Course_name,ST_Course_period=@Course_period,ST_Course_credit=@Course_credit,ST_Course_kind=@Course_kind where ST_Course_id=@Course_id";
104            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
105            st_comm.Parameters.Add(new SqlParameter("@Course_name",SqlDbType.VarChar,50));
106            st_comm.Parameters.Add(new SqlParameter("@Course_period",SqlDbType.Int,4));
107            st_comm.Parameters.Add(new SqlParameter("@Course_credit",SqlDbType.Int,4));
108            st_comm.Parameters.Add(new SqlParameter("@Course_kind",SqlDbType.Int,4));
109            st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
110            string st_colvalue=((TextBox)e.Item.Cells[1].Controls[0]).Text;
111            st_comm.Parameters["@Course_name"].Value=st_colvalue;
112            st_colvalue=((TextBox)e.Item.Cells[2].Controls[0]).Text;
113            st_comm.Parameters["@Course_period"].Value=st_colvalue;
114            st_colvalue=((TextBox)e.Item.Cells[3].Controls[0]).Text;
115            st_comm.Parameters["@Course_credit"].Value=st_colvalue;
116            st_colvalue=((DropDownList)e.Item.FindControl("st_ddl_coursekind")).SelectedIndex.ToString();
117            st_comm.Parameters["@Course_kind"].Value=st_colvalue;
118            st_comm.Parameters["@Course_id"].Value=st_dtg_course.DataKeys[(int)e.Item.ItemIndex];
119            st_comm.Connection.Open();
120            try
121            ...{
122                st_comm.ExecuteNonQuery();
123                st_lbl_note.Text="编辑成功";
124                st_dtg_course.EditItemIndex=-1;
125            }
126            catch(SqlException)
127            ...{
128                st_lbl_note.Text="编辑失败";
129                st_lbl_note.Style["color"]="red";
130            }
131            st_comm.Connection.Close();        
132            ST_BindGrid();
133            
134        }
135        public void ST_BindGrid()
136        ...{
137            st_sqlstr="select * from ST_course";
138            SqlDataAdapter st_da=new SqlDataAdapter(st_sqlstr,st_conn);
139            DataSet st_ds=new DataSet();
140            st_da.Fill(st_ds);
141            st_dtg_course.DataSource=st_ds;
142            st_dtg_course.DataBind();
143        }
144
145        private void st_btn_exit_Click(object sender, System.EventArgs e)
146        ...{
147            Response.Redirect("default.aspx");
148        }
149
150        
151        private void st_btn_search_Click(object sender, System.EventArgs e)
152        ...{
153            st_sqlstr="select * from ST_course  where ST_Course_id='"+st_tbx_id.Text+"'or ST_Course_name='"+st_tbx_name.Text+"'";
154            SqlDataAdapter st_da=new SqlDataAdapter(st_sqlstr,st_conn);
155            DataSet st_ds=new DataSet();
156            st_da.Fill(st_ds);
157            st_dtg_course.DataSource=st_ds;
158            st_dtg_course.DataBind();
159        }
160    }
161}
162