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;


//由于專業(yè)設(shè)置功能較簡(jiǎn)單，所以沒(méi)有用到業(yè)務(wù)層，直接調(diào)用的數(shù)據(jù)層
using?StudentApartment.DataAccesslayer;
using?StudentApartment.DataAccessHelper;
public?partial?class?fieldSet?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session[“adminUserName“]?==?null）
????????{
????????????Response.Redirect（“l(fā)ogin.aspx“）;
????????}
????}
????protected?void?check_ALL_CheckedChanged（object?sender?EventArgs?e）
????{
????????for?（int?i?=?0;?i?????????{
????????????GridViewRow?gr?=?this.GridView1.Rows[i];
????????????CheckBox?chk?=?（CheckBox）gr.Cells[0].FindControl（“checkBox“）;
????????????chk.Checked?=?this.check_ALL.Checked;?//跟隨全選按扭的狀態(tài)變化;
????????}
????}
???
????protected?void?Btn_Add_Click（object?sender?EventArgs?e）
????{
????????string?collegeName?=?this.CollegeName.SelectedValue;
????????string?specialFieldName?=?this.specialFieldName.Text;
????????if?（specialFieldName?==?““）
????????{
????????????Response.Write?（“ript>alert（‘專業(yè)輸入不能為空!‘）;ript>“）;
????????????return;
????????}
????????string?queryString?=?“select?*?from?specialFieldInfo?where?specialFieldName=“?+?SqlString.GetQuotedString（specialFieldName）;
????????Database?db?=?new?Database（）;
????????if?（db.GetRecord（queryString））
????????{
????????????Response.Write（“ript>alert（‘該專業(yè)已經(jīng)存在！‘）;ript>“）;
????????????return;
????????}

????????string?insertString?=?“insert?into?specialFieldInfo（specialFieldNamecollegeName）?values?（“;
????????insertString?+=?SqlString.GetQuotedString（specialFieldName）?+?““;
????????insertString?+=?SqlString.GetQuotedString（collegeName）?+?“）“;
????????if?（db.InsertOrUpdate（insertString）<0）
????????????Response.Write（“ript>alert（‘添加專業(yè)失敗！‘）;ript>“）;
????????Response.Write（“ript>alert（‘添加專業(yè)成功！‘）;location.href=‘fieldSet.aspx‘;ript>“）;

????}
????protected?void?GridView1_RowDataBound（object?sender?GridViewRowEventArgs?e）
????{
????????if?（e.Row.RowType?==?DataControlRowType.DataRow）
????????{
????????????//當(dāng)鼠標(biāo)選擇某行時(shí)變顏色
????????????e.Row.Attributes.Add（“onmouseover“?“c=this.style.backgroundColor;this.style.backgroundColor=‘#00ffee‘;“）;
????????????e.Row.Attributes.Add（“onmouseout“?“this.style.backgroundColor=c;“）;
????????}
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????foreach?（GridViewRow?gr?in?GridView1.Rows）
????????{
????????????CheckBox?chk?=?（CheckBox）gr.Cells[0].FindControl（“checkBox“）;
????????????if?（chk.Checked）?//如果要?jiǎng)h除該學(xué)生
????????????{
????????????????string?specialFieldName?=?gr.Cells[1].Text;
????????????????string?queryString?=?“select?*?from?studentInfo?where?studentSpec=“?+?SqlString.GetQuotedString（specialFieldName）;