UI层

 //FunctionList.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace _20090331
{
    public partial class FunctionList : Form
    {
        public FunctionList()
        {
            InitializeComponent();
        }
        public FunctionList(string type)
        {
            InitializeComponent();
            switch (type)
            {
                case "student": button1.Visible = false; button2.Visible = false; button3.Visible = false; button4.Visible = false; break;
                case "teacher": button1.Visible = false; button3.Visible = false; button4.Visible = false; break;
                case "stuadmin": button3.Visible = false; break;
                case "sysadmin": break;
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            InsertStudentInfo ISI = new InsertStudentInfo();
            ISI.Show();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            InsertStudentScore ISS = new InsertStudentScore();
            ISS.Show();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            TransferClass TC = new TransferClass();
            TC.Show();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            UpdateStudent US = new UpdateStudent();
            US.Show();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            SelectScore SS = new SelectScore();
            SS.Show();
        }

        private void button6_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}
//InsertStudentInfo.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using StudentInfoSys.BLL;

namespace _20090331
{
    /// <summary>
    /// UI层（展示层）
    /// </summary>
    public partial class InsertStudentInfo : Form
    {
        public InsertStudentInfo()
        {
            InitializeComponent();
            this.BindMajority();
            this.cb_gender.SelectedIndex = 0;
           
        }
        /// <summary>
        /// 点击该按钮关闭当前窗口
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        /// <summary>
        /// 绑定专业到cb_majority上
        /// </summary>
        public void BindMajority()
        {
            DataTable dt = new DataTable();          
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindMajority();
            this.cb_majority.DataSource = dt;
            this.cb_majority.DisplayMember = "MajorName";
            this.cb_majority.ValueMember = "MajorID";
            #region 初始化默认班级
            if (this.cb_majority.Items.Count > 0)
            {
                this.BindClassByMjority(int.Parse(this.cb_majority.SelectedValue.ToString()));
            }
            #endregion
        }

        /// <summary>
        /// 根据专业绑定班级到cb_class上
        /// </summary>
        /// <param name="marId"></param>
        public void BindClassByMjority(int marId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindClassByMajority(marId);
            if (dt == null)
            { }
            else
            {
                this.cb_class.DataSource = dt;
                this.cb_class.DisplayMember = dt.Columns["ClassName"].ToString();
                this.cb_class.ValueMember = dt.Columns["ClassID"].ToString();
            }
         }
        /// <summary>
        /// 班级随专业变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_majority_SelectionChangeCommitted(object sender, EventArgs e)
        {
                this.BindClassByMjority(int.Parse(this.cb_majority.SelectedValue.ToString()));           
        }
       /// <summary>
       /// 录入学生信息
       /// </summary>
       /// <param name="sender"></param>
       /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            if (this.tb_studentid.Text == "")
            {
                MessageBox.Show("学生ID不能为空");
                return;
            }
            if (this.tb_studentname.Text == "")
            {
                MessageBox.Show("学生姓名不能为空");
                return;
            }
            else
            {
                string studentnum = this.tb_studentid.Text.ToString();
                string studentnam = this.tb_studentname.Text.ToString();
                int classid = int.Parse(this.cb_class.SelectedValue.ToString());
                string gender = this.cb_gender.SelectedItem.ToString();
                string zhanghao = this.tb_zhanghao.Text.ToString();
                string pwd = this.tb_pwd.Text.ToString();
                StudentInfoBLL SIB = new StudentInfoBLL();
                SIB.InsertStudentInfo(studentnum, studentnam, classid, gender,zhanghao,pwd);
                MessageBox.Show("数据录入成功");
            }
            //if (StudentInfoBLL.InsertStudentInfo(this.tb_studentid.Text.ToString(), this.tb_studentname.Text.ToString(), int.Parse(this.cb_class.SelectedValue.ToString()), this.cb_gender.SelectedItem.ToString()))
            //{
            //    MessageBox.Show("数据录入成功");
            //}
            //else
            //{
            //    MessageBox.Show("数据录入失败");
            //}
        }
    }
}
//InsertStudentScore.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using StudentInfoSys.BLL;

namespace _20090331
{
    public partial class InsertStudentScore : Form
    {
        public InsertStudentScore()
        {
            InitializeComponent();
            this.BindMajority();
        }

        /// <summary>
        /// 绑定专业到cb_majority上
        /// </summary>
        public void BindMajority()
        {
            DataTable dt = new DataTable();
            StudentInfoBLL class1 = new StudentInfoBLL();
            dt = class1.BindMajority();
            this.cb_majority.DataSource = dt;
            this.cb_majority.DisplayMember = "MajorName";
            this.cb_majority.ValueMember = "MajorID";
            #region 初始化默认班级和课程
            if (this.cb_majority.Items.Count > 0)
            {
                this.BindClassByMjority(int.Parse(this.cb_majority.SelectedValue.ToString()));
                this.BindCourseByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
            }
            #endregion
        }

        /// <summary>
        /// 根据专业绑定班级到cb_class上
        /// </summary>
        /// <param name="marId"></param>
        public void BindClassByMjority(int marId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindClassByMajority(marId);
            if (dt == null)
            { }
            else
            {
                this.cb_class.DataSource = dt;
                this.cb_class.DisplayMember = dt.Columns["ClassName"].ToString();
                this.cb_class.ValueMember = dt.Columns["ClassID"].ToString();
            }
            #region 初始化默认学生姓名
            if(this.cb_majority.Items.Count>0)
            this.BindStudentnameByClass(int.Parse(this.cb_class.SelectedValue.ToString()));
            #endregion
        }

        /// <summary>
        /// 根据专业绑定课程
        /// </summary>
        /// <param name="marId"></param>
        public void BindCourseByMajority(int marId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt=SIB.BindCourseByMajority(marId);
            this.cb_course.DataSource = dt;
            this.cb_course.DisplayMember = "CourseName";//dt.Columns["CourseName"].ToString();
            this.cb_course.ValueMember = "CourseID";//dt.Columns["CourseID"].ToString();
        }

        /// <summary>
        /// 根据班级绑定学生姓名
        /// </summary>
        /// <param name="classId"></param>
        public void BindStudentnameByClass(int classId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt=SIB.BindStudentnameByClass(classId);
            this.cb_name.DataSource = dt;
            this.cb_name.DisplayMember = "StudentName";//dt.Columns["StudentName"].ToString();
            this.cb_name.ValueMember = "StudentID"; //dt.Columns["StudentID"].ToString();
            #region 初始化学生学号
            this.tb_studentnum.Text = this.cb_name.SelectedValue.ToString();
            #endregion
        }
        /// <summary>
        /// 班级、课程随专业变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_majority_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.BindClassByMjority(int.Parse(this.cb_majority.SelectedValue.ToString()));
            this.BindCourseByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
        }
        /// <summary>
        /// 关闭按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 学生姓名随班级变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_class_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.BindStudentnameByClass(int.Parse(this.cb_class.SelectedValue.ToString()));
        }

        /// <summary>
        /// 录入学生成绩
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            if (this.tb_score.Text == "")
            {
                MessageBox.Show("学生成绩不能为空");
            }
            else
            {
                string Studentnum = this.tb_studentnum.Text.ToString();
                string Studentnam = this.cb_name.Text.ToString();
                string Courseid = this.cb_course.SelectedValue.ToString();
                string Coursename = this.cb_course.Text.ToString();
                int Score = int.Parse(this.tb_score.Text.ToString());
                StudentInfoBLL SIB = new StudentInfoBLL();
                SIB.InsertScore(Studentnum, Studentnam, Courseid, Coursename, Score);
                MessageBox.Show("成绩录入成功");
            }
        }
        /// <summary>
        /// 学生学号随学生姓名变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_name_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.tb_studentnum.Text = this.cb_name.SelectedValue.ToString();
        }

  }
}
//Logion.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using StudentInfoSys.BLL;

namespace _20090331
{
    public partial class Logion : Form
    {
        public Logion()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //FunctionList logion = new FunctionList();
            //logion.Show();
            //以学生权限登陆
            if (this.rb_student.Checked)
            {
                if (this.tb_zhanghao.Text == "")
                {
                    MessageBox.Show("请输入帐号");
                    return;
                }
                if (this.tb_pwd.Text == "")
                {
                    MessageBox.Show("请输入密码");
                    return;
                }
                LoginManage lm = new LoginManage(UserType.Student);
                //lm.GetLogin(UserType.Student);
                if (lm.Login(this.tb_zhanghao.Text, this.tb_pwd.Text))
                {
                    FunctionList login = new FunctionList("student");
                    login.Show();
                }
                else
                {
                    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                }
                //if (lm.Login())
                //{
                //    FunctionList login = new FunctionList();
                //    login.Show();
                //}
                //else
                //{
                //    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                //}
               
                //StudentInfoBLL SIB = new StudentInfoBLL();
                //if (SIB.StudentLogin(this.tb_zhanghao.Text, this.tb_pwd.Text))
                //{
                //    FunctionList logion = new FunctionList();
                //    logion.Show();
                //}
                //else
                //{
                //    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                //}
            }
            //以教师权限登陆
            if (this.rb_teacher.Checked)
            {
                if (this.tb_zhanghao.Text == "")
                {
                    MessageBox.Show("请输入帐号");
                    return;
                }
                if (this.tb_pwd.Text == "")
                {
                    MessageBox.Show("请输入密码");
                    return;
                }
                LoginManage lm = new LoginManage(UserType.Teacher);
                if (lm.Login(this.tb_zhanghao.Text, this.tb_pwd.Text))
                {
                    FunctionList login = new FunctionList("teacher");
                    login.Show();
                }
                else
                {
                    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                }
                //if (this.tb_zhanghao.Text == "")
                //{
                //    MessageBox.Show("请输入帐号");
                //    return;
                //}
                //if (this.tb_pwd.Text == "")
                //{
                //    MessageBox.Show("请输入密码");
                //    return;
                //}
                //StudentInfoBLL SIB = new StudentInfoBLL();
                //if (SIB.TeacherLogin(this.tb_zhanghao.Text, this.tb_pwd.Text))
                //{
                //    FunctionList login = new FunctionList();
                //    login.Show();
                //}
                //else
                //{
                //    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                //}
            }
            //学生管理员登陆
            if (this.rb_studentAdmin.Checked)
            {
                if (this.tb_zhanghao.Text == "")
                {
                    MessageBox.Show("请输入帐号");
                    return;
                }
                if (this.tb_pwd.Text == "")
                {
                    MessageBox.Show("请输入密码");
                    return;
                }
                StudentInfoBLL SIB = new StudentInfoBLL();
                if (SIB.StuAdminLogin(this.tb_zhanghao.Text, this.tb_pwd.Text))
                {
                    FunctionList login = new FunctionList("stuadmin");
                    login.Show();
                }
                else
                {
                    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                }
            }
            //系统管理员登陆
            if (this.rb_systemAdmin.Checked)
            {
                if (this.tb_zhanghao.Text == "")
                {
                    MessageBox.Show("请输入帐号");
                    this.tb_zhanghao.Focus();
                    return;
                }
                if (this.tb_pwd.Text == "")
                {
                    MessageBox.Show("请输入密码");
                    return;
                }
                StudentInfoBLL SIB = new StudentInfoBLL();
                if (SIB.SysAdminLogin(this.tb_zhanghao.Text, this.tb_pwd.Text))
                {
                    FunctionList login = new FunctionList("sysadmin");
                    login.Show();
                }
                else
                {
                    MessageBox.Show("请检查你选择的登陆权限，帐号、密码是否正确");
                }
            }

        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void Logion_Load(object sender, EventArgs e)
        {

        }
    }
}
//Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;

namespace _20090331
{
    static class Program
    {
        /// <summary>
        /// 应用程序的主入口点。
        /// </summary>
        [STAThread]
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new Logion());
            //Application.Run(new MaoPao());
            //TransferClass
        }
    }
}
//SelectScore.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using StudentInfoSys.BLL;

namespace _20090331
{
    public partial class SelectScore : Form
    {
        public SelectScore()
        {
            InitializeComponent();
            this.BindMajority();
        }
        /// <summary>
        /// 绑定专业
        /// </summary>
        public void BindMajority()
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindMajority();
            this.cb_majority.DataSource = dt;
            this.cb_majority.DisplayMember = "MajorName";
            this.cb_majority.ValueMember = "MajorID";
            #region 初始化默认班级and课程ID
            if (this.cb_majority.Items.Count > 0)
            {
                this.BindClassByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
                this.BindCourseIDByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
            }
            #endregion
        }
        /// <summary>
        /// 根据专业绑定班级
        /// </summary>
        /// <param name="marId">专业ID</param>
        public void BindClassByMajority(int marId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindClassByMajority(marId);
            if (dt == null)
            { }
            else
            {
                this.cb_class.DataSource = dt;
                this.cb_class.DisplayMember = dt.Columns["ClassName"].ToString();
                this.cb_class.ValueMember = dt.Columns["ClassID"].ToString();
            }
            #region 初始化学生学号
            this.BindStudentidByClass(int.Parse(this.cb_class.SelectedValue.ToString()));
            #endregion

        }
        /// <summary>
        /// 班级随专业变而变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_majority_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.BindClassByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
            this.BindCourseIDByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
        }
        /// <summary>
        /// 根据班级绑定学生学号
        /// </summary>
        /// <param name="classID"></param>
        public void BindStudentidByClass(int classID)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindStudentIDByClass(classID);
            this.cb_studentid.DataSource = dt;
            this.cb_studentid.DisplayMember = "StudentID";
            this.cb_studentid.ValueMember = "StudentName";
            #region 初始化学生姓名
            this.selectStudentName(this.cb_studentid.SelectedValue.ToString());
            #endregion
        }
        /// <summary>
        /// 学生学号随班级变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_class_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.BindStudentidByClass(int.Parse(this.cb_class.SelectedValue.ToString()));
        }

        public void selectStudentName(string studentid)
        {
            this.tb_studentname.Text = this.cb_studentid.SelectedValue.ToString();
        }
        /// <summary>
        /// 学生学号改变决定对应学生姓名
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_studentid_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.selectStudentName(this.cb_studentid.SelectedValue.ToString());
        }
        /// <summary>
        /// 根据专业绑定课程ID
        /// </summary>
        /// <param name="marID"></param>
        public void BindCourseIDByMajority(int marID)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindCourseIDByMajority(marID);
            this.cb_courseid.DataSource = dt;
            this.cb_courseid.DisplayMember = "CourseID";
            this.cb_courseid.ValueMember = "CourseName";
            #region 初始化课程名称
            this.tb_course.Text = this.cb_courseid.SelectedValue.ToString();
            #endregion
        }
        /// <summary>
        /// 课程ID决定课程名
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_courseid_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.tb_course.Text = this.cb_courseid.SelectedValue.ToString();
        }
        /// <summary>
        /// 查询学生成绩
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            string studentid = this.cb_studentid.Text.ToString();
            string courseid = this.cb_courseid.Text.ToString();
            StudentInfoBLL SIB = new StudentInfoBLL();
            DataTable dt = new DataTable();
            dt = SIB.SelectScoreOfStudent(studentid, courseid);
            if (dt != null)
            {
                this.cb_score.DataSource = dt;
                this.cb_score.DisplayMember = "Garden";
                this.cb_score.ValueMember = "Garden";
            }
            else
            {
                MessageBox.Show("还没有该学生的这项成绩");
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

     
    }
}
//TransferClass.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

using StudentInfoSys.BLL;

namespace _20090331
{
    public partial class TransferClass : Form
    {
        public TransferClass()
        {
            InitializeComponent();
            this.BindMajoritySou();
            this.BindMajorityDes();
        }

       /// <summary>
       /// 绑定源专业
       /// </summary>
        public void BindMajoritySou()
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
           dt= SIB.BindMajority();
           this.cb_souMajority.DataSource = dt;
           this.cb_souMajority.DisplayMember = "MajorName";//dt.Columns["MajorName"].ToString();
           this.cb_souMajority.ValueMember = "MajorID";//dt.Columns["MajorID"].ToString();
            #region 初始化源班
           BindClassByMajoritySou(int.Parse(this.cb_souMajority.SelectedValue.ToString()));
            #endregion
        }

        /// <summary>
        /// 根据专业绑定源班级
        /// </summary>
        /// <param name="soumarId">专业ID</param>
        public void BindClassByMajoritySou(int soumarId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindClassByMajority(soumarId);
            this.cb_souClass.DataSource = dt;
            this.cb_souClass.DisplayMember=dt.Columns["ClassName"].ToString();
            this.cb_souClass.ValueMember=dt.Columns["ClassID"].ToString();
            #region 初始化学生姓名
            BindStudentnameByClassSou(int.Parse(this.cb_souClass.SelectedValue.ToString()));
            #endregion
           
        }

        /// <summary>
        /// 根据班级绑定学生姓名
        /// </summary>
        /// <param name="classId"></param>
        public void BindStudentnameByClassSou(int classId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindStudentnameByClass(classId);
            this.cb_studentname.DataSource = dt;
            this.cb_studentname.DisplayMember=dt.Columns["StudentName"].ToString();
            this.cb_studentname.ValueMember=dt.Columns["StudentID"].ToString();
            #region  初始化学生学号
            this.tb_souStudentid.Text = this.cb_studentname.SelectedValue.ToString();
            #endregion
            }

        /// <summary>
        /// 源班级随源专业变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_souMajority_SelectionChangeCommitted(object sender, EventArgs e)
        {
            BindClassByMajoritySou(int.Parse(this.cb_souMajority.SelectedValue.ToString()));
        }

        /// <summary>
        /// 学生姓名随源专业变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_souClass_SelectionChangeCommitted(object sender, EventArgs e)
        {
            BindStudentnameByClassSou(int.Parse(this.cb_souClass.SelectedValue.ToString()));
            this.BindClassByMajorityDes(int.Parse(this.cb_desMajor.SelectedValue.ToString()), int.Parse(this.cb_souClass.SelectedValue.ToString()));
        }

        /// <summary>
        /// 学生学号随学生姓名变换而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_studentname_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.tb_souStudentid.Text = this.cb_studentname.SelectedValue.ToString();
        }

        /// <summary>
        /// 绑定转班的目的专业
        /// </summary>
        private void BindMajorityDes()
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            //dt=SIB.BindMajorityDes(int.Parse(this.cb_souMajority.SelectedValue.ToString()));
            dt = SIB.BindMajorityDes();
            this.cb_desMajor.DataSource = dt;
            this.cb_desMajor.DisplayMember=dt.Columns["MajorName"].ToString();
            this.cb_desMajor.ValueMember=dt.Columns["MajorID"].ToString();
            #region 初始化目的班级
            this.BindClassByMajorityDes(int.Parse(this.cb_desMajor.SelectedValue.ToString()), int.Parse(this.cb_souClass.SelectedValue.ToString()));
            //this.BindClassByMajorityDes(int.Parse(this.cb_desMajor.SelectedValue.ToString()));
            #endregion
        }

        /// <summary>
        /// 绑定转班的目的班级
        /// </summary>
        private void BindClassByMajorityDes(int marId,int classId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindClassByMajorityDes(marId,int.Parse(this.cb_souClass.SelectedValue.ToString()));
            this.cb_desClass.DataSource = dt;
            this.cb_desClass.DisplayMember = "ClassName";//dt.Columns["ClassName"].ToString();
            this.cb_desClass.ValueMember = "ClassID";//dt.Columns["ClassID"].ToString();
        }

        /// <summary>
        /// 目的班级随目的专业变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_desMajor_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.BindClassByMajorityDes(int.Parse(this.cb_desMajor.SelectedValue.ToString()),int.Parse(this.cb_souClass.SelectedValue.ToString()));
        }

        /// <summary>
        /// 关闭当前页面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        /// <summary>
        /// 点击此按钮确定学生转班
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            StudentInfoBLL bll=new StudentInfoBLL();
            bll.TransfClass(tb_souStudentid.Text.Trim(), this.tb_desStudentid.Text.Trim(), int.Parse(cb_desClass.SelectedValue.ToString()));
            MessageBox.Show("success");
        }

      
    }
}
//UpdateStudent.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using StudentInfoSys.BLL;
using System.Data.SqlClient;

namespace _20090331
{
    public partial class UpdateStudent : Form
    {
        public UpdateStudent()
        {
            InitializeComponent();
            this.BindMajority();
        }

        /// <summary>
        /// 绑定专业
        /// </summary>
        public void BindMajority()
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindMajority();
            this.cb_majority.DataSource = dt;
            this.cb_majority.DisplayMember = "MajorName";
            this.cb_majority.ValueMember = "MajorID";
            #region 初始化班级
            this.BindClassByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
            #endregion
        }

        /// <summary>
        /// 根据专业绑定班级
        /// </summary>
        /// <param name="marId"></param>
        public void BindClassByMajority(int marId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB = new StudentInfoBLL();
            dt = SIB.BindClassByMajority(marId);
            this.cb_class.DataSource = dt;
            this.cb_class.DisplayMember = "ClassName";
            this.cb_class.ValueMember = "ClassID";
        }

        /// <summary>
        /// 班级随专业变化而改变
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cb_majority_SelectionChangeCommitted(object sender, EventArgs e)
        {
            this.BindClassByMajority(int.Parse(this.cb_majority.SelectedValue.ToString()));
        }

        /// <summary>
        /// 绑定学生信息到DataGridView
        /// </summary>
        /// <param name="classId"></param>
        public void BindStudentInfoByClass(int classId)
        {
            DataTable dt = new DataTable();
            StudentInfoBLL SIB=new StudentInfoBLL();
            dt = SIB.BindStudentInfoByClass(classId);
            this.dgv_student.DataSource = dt;
        }

        /// <summary>
        /// 点击按钮绑定学生信息到dgv_student
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void bt_query_Click(object sender, EventArgs e)
        {
            this.BindStudentInfoByClass(int.Parse(this.cb_class.SelectedValue.ToString()));
        }

        /// <summary>
        /// 点击dgv_student中单元格时，其内容显示在相应文本框中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgv_student_MouseUp(object sender, MouseEventArgs e)
        {
            //this.tb_studentid.Text =this.dgv_student.CurrentCell.EditedFormattedValue.ToString();
            //this.tb_studentid.Text = this.dgv_student.CurrentRow.Cells[0].EditedFormattedValue.ToString();
            this.tb_studentname.Text = this.dgv_student.CurrentRow.Cells[1].EditedFormattedValue.ToString();
        }

        /// <summary>
        /// 点击按钮更新学生信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void bt_alter_Click(object sender, EventArgs e)
        {
            //int studentid = int.Parse(this.tb_studentid.Text);
            string studentname = this.tb_studentname.Text;
            StudentInfoBLL SIB = new StudentInfoBLL();
            try
            {
                SIB.UpdataStudentInfo(this.dgv_student.CurrentRow.Cells[0].EditedFormattedValue.ToString(), studentname);
                MessageBox.Show("更新成功");
            }
            catch
            {
                MessageBox.Show("更新失败");
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

    }

      
}