Example #1
0
        private void btnDelectePunishment_Click(object sender, EventArgs e)
        {
            int success = 0;
            int error   = 0;

            //判断是否选中行
            if (dgvPunishments.SelectedRows.Count > 0)
            {
                //循环
                foreach (DataGridViewRow row in dgvPunishments.SelectedRows)
                {
                    string punishmentid = row.Cells[0].Value.ToString();
                    int    i            = StudentsInfoBLL.DeletePunishment(punishmentid);
                    if (i > 0)
                    {
                        success++;
                    }
                    else
                    {
                        error++;
                    }
                }
                int sum = success + error;
                MessageBox.Show("共操作了" + sum + "行;成功" + success + "行,失败" + error + "行!");

                BinderPunishment();
            }
        }
Example #2
0
        void BinderStudentInfo()
        {
            try
            {
                DataTable student = StudentsInfoBLL.GetStudentInfoByID(StudentID);
                if (student == null)
                {
                    MessageBox.Show("没数据!");
                    return;
                }


                DataRow row = student.Rows[0];

                string    classid  = row["Student_Class"].ToString();
                DataTable students = StudentsInfoBLL.GetStudentsInfoByClassID(classid);

                DataRow stu = students.Rows[0];

                this.labelName.Text      = row["Student_Name"].ToString();
                this.labelIDCardNum.Text = row["StudentCard"].ToString();
                this.labelBirthday.Text  = row["StudentBirthDay"].ToString();
                this.labelEnterYear.Text = row["StudentEnterYear"].ToString();
                this.labelNative.Text    = row["StudentOrigin"].ToString();
                this.labelHomeTel.Text   = row["FamilyTel"].ToString();
                this.labelHomeAdd.Text   = row["StudentAddress"].ToString();
                this.labelFlatTel.Text   = row["DormTel"].ToString();
                this.labelMobile.Text    = row["Mobile"].ToString();
                this.labelEmail.Text     = row["Email"].ToString();

                this.labStuType.Text      = stu["SpeYears_Name"].ToString();
                this.labelClass.Text      = stu["Classes_Name"].ToString();
                this.labelSpeciality.Text = stu["Speciality_Name"].ToString();
                this.labelCollege.Text    = stu["College_Name"].ToString();



                if (row["Student_Sex"].ToString() == "男")
                {
                    this.labelSex.Text = "男";
                }
                else
                {
                    this.labelSex.Text = "女";
                }
                if (!string.IsNullOrEmpty(row["StudentNum"].ToString()))
                {
                    labelStuID.Text = row["StudentNum"].ToString();
                }
                else
                {
                    labelStuID.Text = "";
                }
            }

            catch (Exception)
            {
                throw;
            }
        }
Example #3
0
 private void toolStripButton4_Click(object sender, EventArgs e)
 {
     //获取学生ID
     if (lvStudentsInfo.SelectedItems.Count > 0)
     {
         int success = 0;
         int error   = 0;
         foreach (ListViewItem item in lvStudentsInfo.SelectedItems)
         {
             string studentid = item.Name;
             //写删除方法
             int i = StudentsInfoBLL.DeleteStudent(studentid);
             if (i > 0)
             {
                 success++;
             }
             else
             {
                 error++;
             }
         }
         //统计共执行多少行
         int sum = success + error;
         MessageBox.Show("共操作了" + sum + "行;成功" + success + "行,失败" + error + "行!");
         //清空listview选中行
         lvStudentsInfo.Items.Clear();
     }
     else
     {
         MessageBox.Show("请选择一行或多行!");
     }
 }
Example #4
0
        void BinderPunishmentAwardType()
        {
            DataTable punishmentawardtype = StudentsInfoBLL.GetPunishmentAwardType();

            cmbPunishmentType.DataSource    = punishmentawardtype;
            cmbPunishmentType.DisplayMember = "PunishmentAwardTypes_Name";
            cmbPunishmentType.ValueMember   = "PunishmentAwardTypes_ID";
        }
Example #5
0
        void BinderAwardType()
        {
            DataTable AwardType = StudentsInfoBLL.GetAwardType();

            cmbAwardType.DataSource    = AwardType;
            cmbAwardType.DisplayMember = "PunishmentAwardTypes_Name";
            cmbAwardType.ValueMember   = "PunishmentAwardTypes_ID";
        }
Example #6
0
        void BinderChangeType()
        {
            DataTable changetype = StudentsInfoBLL.GetChangeType();

            cmbChangeType.DataSource    = changetype;
            cmbChangeType.DisplayMember = "ChangeTypes_Name";
            cmbChangeType.ValueMember   = "ChangeTypes_ID";
        }
Example #7
0
        private void BinderStudents(string classid)
        {
            islock = true;
            DataTable students = StudentsInfoBLL.GetStudentByClassid(classid);


            cmbBoxName.DataSource    = students;
            cmbBoxName.DisplayMember = "Student_Name";
            cmbBoxName.ValueMember   = "Student_ID";


            islock = false;
        }
Example #8
0
        private void btnAddPunishment_Click(object sender, EventArgs e)
        {
            try
            {
                //获取id最小值
                object obj = StudentsInfoBLL.GetMinPunishment();
                int    ii  = Convert.ToInt32(obj);

                int id = -1;
                //表记录为空
                if (obj == null)
                {
                    id = -1;
                }
                //只有奖励,没有处分
                if (Convert.ToInt32(obj) > -1)
                {
                    id = -1;
                }
                else
                {
                    id = ii - 1;
                }



                int Recode_ID = id;

                string Type_ID = cmbPunishmentType.SelectedValue.ToString();
                string Content = cmbPunishmentType.Text;
                string Reason  = txtPunishmentReason.Text;
                string Date    = dateTimePunishment.Value.ToString();

                int r = StudentsInfoBLL.InsertPunishment(id, Type_ID, StudentID, Content, Reason, Date);

                if (r > 0)
                {
                    MessageBox.Show("成功!");
                    BinderPunishment();
                }
                else
                {
                    MessageBox.Show("失败!");
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Example #9
0
        private void btnAddAward_Click(object sender, EventArgs e)
        {
            try
            {
                //获取id最大值
                object obj = StudentsInfoBLL.GetMaxAward();
                int    id  = 1;
                //最大值为空,数据表没记录
                if (obj == null)
                {
                    id = 1;
                }
                //只有处分,没有奖励
                if (Convert.ToInt32(obj) < 1)
                {
                    id = 1;
                }
                else
                {
                    id = Convert.ToInt32(obj) + 1;
                }



                int Recode_ID = id;

                string Type_ID = cmbAwardType.SelectedValue.ToString();
                string Content = txtAwardContent.Text;
                string Reason  = txtAwardReason.Text;
                string Date    = dateTimeAward.Value.ToString();

                int r = StudentsInfoBLL.InsertAwards(id, Type_ID, StudentID, Content, Reason, Date);

                if (r > 0)
                {
                    MessageBox.Show("成功!");
                    BinderAward();
                }
                else
                {
                    MessageBox.Show("失败!");
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Example #10
0
        private void btnAddChange_Click(object sender, EventArgs e)
        {
            string typeid       = cmbChangeType.SelectedValue.ToString();
            string changedate   = dateTimeChange.Value.ToString();
            string studentid    = StudentID;
            string changeReason = txtChangeReason.Text;
            int    i            = StudentsInfoBLL.InsertChange(typeid, changeReason, studentid, changedate);

            if (i > 0)
            {
                MessageBox.Show("成功!");
                BinderChange();
            }
            else
            {
                MessageBox.Show("失败!");
            }
        }
Example #11
0
        private void cmbBoxName_SelectedIndexChanged_1(object sender, EventArgs e)
        {
            if (islock)
            {
                return;
            }
            //当选择学生后显示该学生的编号
            string studentid = "0";

            if (cmbBoxName.SelectedValue != null)
            {
                studentid = cmbBoxName.SelectedValue.ToString();

                //根据学生id获取学生信息
                DataTable student = StudentsInfoBLL.GetStudentInfoByID(studentid);
                if (student.Rows.Count > 0)
                {
                    labelStuID.Text = student.Rows[0]["StudentNum"].ToString();
                }
                else
                {
                    labelStuID.Text = "0";
                }
            }
            else
            {
                labelStuID.Text = "0";
            }
            islock = false;

            //如果该学生已经录入成绩则显示成绩
            DataTable scoredt = ScoreBLL.GetScoreByStudentid(studentid);

            for (int i = 0; i < scoredt.Rows.Count; i++)
            {
                Subject sj = (Subject)gbSubjects.Controls[i];
                sj.txtScore.Text = scoredt.Rows[i]["ExamScore"].ToString();
                //btnSubmit.Enabled = false;
            }
        }
Example #12
0
        /// <summary>
        /// 提交数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void btnSubmit_Click(object sender, EventArgs e)
        {
            if (!checkIsTextNULL())
            {
                return;
            }



            Students s = new Students();

            s.Student_Name = this.TxtBoxName.Text;
            s.Student_Sex  = this.rdoBtnMale.Checked ? "男" : "女";

            s.StudentClass     = cmbBoxClass.SelectedValue.ToString();
            s.StudentNum       = cmbBoxClass.SelectedValue.ToString() + txtBoxStuID.Text;
            s.StudentEnterYear = dtpEnterYear.Value;
            s.StudentOrigin    = txtBoxNative.Text;
            s.StudentBirthDay  = dateTimePickerBirth.Value;
            s.StudentCard      = txtBoxIDCardNum.Text;
            s.StudentAddress   = txtBoxHomeAdd.Text;
            s.FamilyTel        = txtBoxHomeTel.Text;
            s.DormTel          = txtBoxflatTel.Text;
            s.Mobile           = txtBoxEmail.Text;
            s.Email            = txtBoxMobile.Text;

            bool b = StudentsInfoBLL.InsertStudentsInfo(s);

            if (b)
            {
                MessageBox.Show("成功");
                this.Close();
            }
            else
            {
                MessageBox.Show("失败");
            }
        }
Example #13
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (!checkIsTextNULL())
            {
                return;
            }

            Students s = new Students();

            s.StudentID    = Convert.ToInt32(StudentID);
            s.Student_Name = this.txtBoxName.Text;
            s.Student_Sex  = this.rdoBtnMale.Checked ? "男" : "女";

            s.StudentClass     = cmbBoxClass.SelectedValue.ToString();
            s.StudentNum       = cmbBoxClass.SelectedValue.ToString() + txtBoxNum.Text;
            s.StudentEnterYear = dateTimePickerDate.Value;
            s.StudentOrigin    = txtBoxNative.Text;
            s.StudentBirthDay  = dateTimePickerBirth.Value;
            s.StudentCard      = txtBoxIDCardNum.Text;
            s.StudentAddress   = txtBoxHomeAdd.Text;
            s.FamilyTel        = txtBoxHomeTel.Text;
            s.DormTel          = txtBoxflatTel.Text;
            s.Mobile           = txtBoxEmail.Text;
            s.Email            = txtBoxMobile.Text;

            int i = StudentsInfoBLL.UpdateStudentInfo(s);

            if (i > 0)
            {
                MessageBox.Show("成功!");
                this.Close();
            }
            else
            {
                MessageBox.Show("失败!");
            }
        }
Example #14
0
        private void tvColleges_AfterSelect(object sender, TreeViewEventArgs e)
        {
            try
            {
                if (e == null)
                {
                    return;
                }
                if (e.Node.Tag.ToString() == "Classes")//表示选中班级
                {
                    DataTable dt = StudentsInfoBLL.GetStudentsInfoByClassID(e.Node.Name);
                    lvStudentsInfo.Items.Clear();

                    foreach (DataRow stu in dt.Rows)
                    {
                        ListViewItem lvi = new ListViewItem();
                        lvi.Text = stu["Student_Name"].ToString();

                        lvi.Name = stu["Student_ID"].ToString();

                        lvi.SubItems.Add(stu["StudentNum"].ToString());
                        lvi.SubItems.Add(stu["Student_Sex"].ToString());
                        lvi.SubItems.Add(stu["College_Name"].ToString());
                        lvi.SubItems.Add(stu["Speciality_Name"].ToString());
                        lvi.SubItems.Add(stu["StudentEnterYear"].ToString());
                        lvi.SubItems.Add(stu["SpeYears_Name"].ToString());
                        lvi.SubItems.Add(stu["StudentOrigin"].ToString());

                        lvStudentsInfo.Items.Add(lvi);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Example #15
0
 /// <summary>
 /// 学制
 /// </summary>
 /// <param name="SpecialityID"></param>
 private void BinderSpeYears(string SpecialityID)
 {
     labStuID.Text = StudentsInfoBLL.GetSpeYearName(SpecialityID);
 }
Example #16
0
 private void BinderSpeYears(string SpecialityID)
 {
     LableBoxStuType.Text = StudentsInfoBLL.GetSpeYearName(SpecialityID);
 }
Example #17
0
        void BinderPunishment()
        {
            DataTable punishment = StudentsInfoBLL.GetPunishment(StudentID);

            dgvPunishments.DataSource = punishment;
        }
Example #18
0
        void BinderAward()
        {
            DataTable award = StudentsInfoBLL.GetAward(StudentID);

            dgvAwards.DataSource = award;
        }
Example #19
0
        void BinderChange()
        {
            DataTable change = StudentsInfoBLL.GetChange(StudentID);

            dgvChanges.DataSource = change;
        }
Example #20
0
        void BinderStudentInfo()
        {
            try
            {
                DataTable student = StudentsInfoBLL.GetStudentInfoByID(StudentID);
                if (student == null)
                {
                    MessageBox.Show("没数据!");
                    return;
                }
                DataRow row = student.Rows[0];

                this.txtBoxName.Text = row["Student_Name"].ToString();
                this.txtBoxNum.Text  = row["StudentNum"].ToString();

                this.txtBoxIDCardNum.Text = row["StudentCard"].ToString();
                this.txtBoxNative.Text    = row["StudentOrigin"].ToString();
                this.txtBoxHomeTel.Text   = row["FamilyTel"].ToString();
                this.txtBoxHomeAdd.Text   = row["StudentAddress"].ToString();
                this.txtBoxflatTel.Text   = row["DormTel"].ToString();
                this.txtBoxMobile.Text    = row["Mobile"].ToString();
                this.txtBoxEmail.Text     = row["Email"].ToString();

                /*DataTable dt=StudentsInfoBLL.
                 * BinderColleges();
                 * BinderSpeciality(CollegeID);
                 * BinderClasses(SpecialityID);
                 * string classID=row["StudentClass"].ToString();
                 * if(cmbBoxCollege.Items.Count>0)
                 * {
                 *  cmbBoxCollege.SelectedValue=college
                 * }*/
                if (row["Student_Sex"].ToString() == "男")
                {
                    rdoBtnMale.Checked = true;
                }
                else
                {
                    rdoBtnFemale.Checked = true;
                }

                if (!string.IsNullOrEmpty(row["StudentBirthDay"].ToString()))
                {
                    this.dateTimePickerBirth.Value = (DateTime)row["StudentBirthDay"];
                }
                else
                {
                    this.dateTimePickerBirth.Value = DateTime.Now;
                }
                //学号
                if (!string.IsNullOrEmpty(row["StudentNum"].ToString()))
                {
                    string num = row["StudentNum"].ToString();
                    txtBoxNum.Text = num.Substring(num.Length - 4);
                }
                else
                {
                    txtBoxNum.Text = "";
                }
                if (!string.IsNullOrEmpty(row["StudentEnterYear"].ToString()))
                {
                    this.dateTimePickerDate.Value = (DateTime)row["StudentEnterYear"];
                }
                else
                {
                    this.dateTimePickerDate.Value = DateTime.Now;
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }