//成绩快速浏览：txt=>change事件
private void TxtScore_TextChanged(object sender, EventArgs e)
{
if (this.dgvScoreList.RowCount == 0)
{
return;
}
if (this.txtScore.Text.Trim().Length == 0)
{
return;
}
if (!DataValidate.IsInteger(this.txtScore.Text.Trim()))
{
this.txtScore.Text = "";
this.txtScore.SelectAll();
MessageBox.Show("成绩只能为整数！", "提示信息");
return;
}
this.cboClass.SelectedIndex = -1;
var item = this.txtScore.Text.Trim();
int score = Convert.ToInt32(item);
if (score > 100 || score < 0)
{
this.txtScore.Text = "";
this.txtScore.SelectAll();
MessageBox.Show("成绩只能在0-100之间！", "提示信息");
return;
}
this.da.Tables[0].DefaultView.RowFilter = "CSharp>" + this.txtScore.Text.Trim();
}
private void BtnQueryById_Click(object sender, EventArgs e)
{
if (this.txtStudentId.Text.Trim().Length == 0)
{
MessageBox.Show("请输入学员学号", "提示信息");
return;
}
if (!DataValidate.IsInteger(this.txtStudentId.Text.Trim()))
{
MessageBox.Show("学号必须为整数！", "提示信息");
this.txtStudentId.Focus();
this.txtStudentId.SelectAll();
return;
}
int studentId = Convert.ToInt32(this.txtStudentId.Text.Trim());
var studentInfo = studentService.GetStudebntByStudentId(studentId);
if (studentInfo == null)
{
MessageBox.Show("学员学号错误，暂无此学员！", "提示信息");
return;
}
if (frmStudentInfo == null)
{
frmStudentInfo = new FrmStudentInfo(studentInfo);
frmStudentInfo.ShowDialog();
}
else
{
frmStudentInfo.Activate();
frmStudentInfo.WindowState = FormWindowState.Normal;
}
}
private void txtScore_TextChanged(object sender, EventArgs e)
{
if (ds == null || this.txtScore.Text.Trim().Length == 0)
{
return;
}
if (!DataValidate.IsInteger(this.txtScore.Text.Trim()))
{
return;
}
else
{
this.ds.Tables[0].DefaultView.RowFilter = "CSharp >" + this.txtScore.Text.Trim();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
#region Data Not Empty Validate
if (this.txtFName.Text.Trim().Length == 0)
{
MessageBox.Show("Please entry the Student First Name");
this.txtFName.Focus();
return;
}
if (this.txtLName.Text.Trim().Length == 0)
{
MessageBox.Show("Please entry the Student Last Name");
this.txtLName.Focus();
return;
}
if (!this.rdoMale.Checked && !this.rdoFemale.Checked)
{
MessageBox.Show("Select the Student Gender");
return;
}
if (DateTime.Now.Year - Convert.ToDateTime(this.dateTimePicker1.Text).Year < 16)
{
MessageBox.Show("Student age cant beyond 16");
this.dateTimePicker1.Focus();
return;
}
if (this.cboClassName.SelectedIndex == -1)
{
MessageBox.Show("Please select the Class !");
return;
}
if (this.txtStudentId.Text.Trim().Length == 0)
{
MessageBox.Show("Student ID can't empty");
this.txtStudentId.Focus();
return;
}
if (this.txtPhoneNumber.Text.Trim().Length == 0)
{
MessageBox.Show("PhoneNumber can't empty");
this.txtPhoneNumber.Focus();
return;
}
#endregion
#region Data Format Validate
if (!DataValidate.IsIdentityStudentID(this.txtStudentId.Text.Trim()))
{
MessageBox.Show("StudentId Must have 10 figures");
this.txtStudentId.Focus();
return;
}
#endregion
//Judge the StudentIsExisted
if (this.objStudentService.IsStudentIDExitsed(this.txtStudentId.Text.Trim()))
{
MessageBox.Show("StudentId Existed ,Please entry different StudentId ");
this.txtStudentId.Focus();
return;
}
//encapsulation
Student objStudent = new Student()
{
FirstName = this.txtFName.Text.Trim(),
LastName = this.txtLName.Text.Trim(),
Gender = rdoMale.Checked ? "Male" : "Female",
Birthday = Convert.ToDateTime(this.dateTimePicker1.Text),
Age = DateTime.Now.Year - Convert.ToDateTime(this.dateTimePicker1.Text).Year,
ClassId = Convert.ToInt32(this.cboClassName.SelectedValue),
StudentIdNo = Convert.ToInt32(this.txtStudentId.Text.Trim()),
PhoneNumber = this.txtPhoneNumber.Text.Trim(),
Address = this.txtAddress.Text.Trim(),
StuImage = this.pbStu.Image == null ? "" : new SerializeObjectToString().SerializeObject(this.pbStu.Image)
};
try
{
int result = objStudentService.AddStudent(objStudent);
if (result == 1)
{
DialogResult dresult = MessageBox.Show("Add Successful ! keep going ?", "other Studnet ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dresult == DialogResult.OK)
{
//clean controls in groupbox
foreach (Control item in this.gbStudentInfo.Controls)
{
if (item is TextBox)
{
item.Text = "";
}
else if (item is RadioButton)
{
((RadioButton)item).Checked = false;
}
else if (item is ComboBox)
{
((ComboBox)item).SelectedIndex = -1;
}
}
this.pbStu.Image = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//提交修改
private void BtnModify_Click(object sender, EventArgs e)
{
#region 数据验证
if (this.txtStudentName.Text.Trim().Length == 0)
{
MessageBox.Show("学生姓名不能为空!", "提示信息");
return;
}
var age = DateTime.Now.Year - Convert.ToDateTime(this.dtpBirthday.Text).Year;
if (age < 18 || age > 35)
{
MessageBox.Show("年龄必须在18到35之间!", "提示信息");
return;
}
if (!DataValidate.IsIdentityCard(this.txtStudentIdNo.Text.Trim()))
{
MessageBox.Show("身份证号不符合要求!", "提示信息");
this.txtStudentIdNo.SelectAll();
this.txtStudentIdNo.Focus();
return;
}
//验证身份证号与出生日期是否一致
var birthday = Convert.ToDateTime(this.dtpBirthday.Text).ToString("yyyyMMdd");
if (!this.txtStudentIdNo.Text.Trim().Contains(birthday))
{
MessageBox.Show("身份证与出生日期不匹配!", "提示信息");
this.txtStudentIdNo.SelectAll();
this.txtStudentIdNo.Focus();
return;
}
var studentId = Convert.ToInt32(this.txtStudentId.Text.Trim());
if (studentService.IsIdNoExisted(this.txtStudentIdNo.Text.Trim(), studentId))
{
MessageBox.Show("身份证号已经被其他学员使用!", "修改提示");
this.txtStudentIdNo.SelectAll();
this.txtStudentIdNo.Focus();
return;
}
if (studentService.IsCradNoExisted(this.txtCardNo.Text.Trim(), studentId))
{
MessageBox.Show("考勤卡号已经被其他学员使用!", "修改提示");
this.txtCardNo.SelectAll();
this.txtCardNo.Focus();
return;
}
#endregion
Students student = new Students
{
StudentId = studentId,
StudentName = this.txtStudentName.Text.Trim(),
Gender = this.rdoMale.Checked?"男":"女",
Birthday = Convert.ToDateTime(this.dtpBirthday.Text),
StudentIdNo = this.txtStudentIdNo.Text.Trim(),
CardNo = this.txtCardNo.Text.Trim(),
StuImage = this.pbStu.Image != null?SerializeObjectToString.SerializeObject(this.pbStu.Image) : "",
Age = age,
PhoneNumber = this.txtPhoneNumber.Text.Trim(),
StudentAddress = this.txtAddress.Text.Trim(),
ClassId = Convert.ToInt32(this.cboClassName.SelectedValue),
};
try
{
var result = studentService.UpdateStudentInfo(student);
if (result == 1)
{
MessageBox.Show("学员信息修改成功!", "提示信息");
var item = FrmStudentManage.studentList.First(o => o.StudentId == studentId);
item.StudentName = this.txtStudentName.Text.Trim();
item.Gender = this.rdoMale.Checked ? "男" : "女";
item.StudentIdNo = this.txtStudentIdNo.Text;
item.Birthday = this.dtpBirthday.Value;
item.PhoneNumber = this.txtPhoneNumber.Text;
item.ClassName = this.cboClassName.Text;
//this.dgvStudentList.Refresh();
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示信息");
}
}
//添加学员
private void BtnAdd_Click(object sender, EventArgs e)
{
#region 数据验证
if (this.txtStudentName.Text.Trim().Length == 0)
{
MessageBox.Show("学生姓名不能为空!", "提示信息");
return;
}
if (this.rdoFemale.Checked == false && this.rdoMale.Checked == false)
{
MessageBox.Show("请选择性别!", "提示信息");
return;
}
if (this.cboClassName.SelectedIndex == -1)
{
MessageBox.Show("请选择班级!", "提示信息");
return;
}
var age = DateTime.Now.Year - Convert.ToDateTime(this.dtpBirthday.Text).Year;
if (age < 18 || age > 35)
{
MessageBox.Show("年龄必须在18到35之间!", "提示信息");
return;
}
if (!DataValidate.IsIdentityCard(this.txtStudentIdNo.Text.Trim()))
{
MessageBox.Show("身份证号不符合要求!", "提示信息");
this.txtStudentIdNo.SelectAll();
this.txtStudentIdNo.Focus();
return;
}
//验证身份证号与出生日期是否一致
var birthday = Convert.ToDateTime(this.dtpBirthday.Text).ToString("yyyyMMdd");
if (!this.txtStudentIdNo.Text.Trim().Contains(birthday))
{
MessageBox.Show("身份证与出生日期不匹配!", "提示信息");
this.txtStudentIdNo.SelectAll();
this.txtStudentIdNo.Focus();
return;
}
if (studentService.IsIdNoExisted(this.txtStudentIdNo.Text.Trim()))
{
MessageBox.Show("身份证号已经被其他学员使用!", "提示信息");
this.txtStudentIdNo.SelectAll();
this.txtStudentIdNo.Focus();
return;
}
if (studentService.IsCradNoExisted(this.txtCardNo.Text.Trim()))
{
MessageBox.Show("考勤卡号已经被其他学员使用!", "提示信息");
this.txtCardNo.SelectAll();
this.txtCardNo.Focus();
return;
}
#endregion
#region 对象封装
Students student = new Students
{
StudentName = this.txtStudentName.Text.Trim(),
Gender = this.rdoFemale.Checked ? "女" : "男",
Birthday = Convert.ToDateTime(this.dtpBirthday.Text),
StudentIdNo = this.txtStudentIdNo.Text.Trim(),
StuImage = this.pbStu.Image != null?SerializeObjectToString.SerializeObject(this.pbStu.Image) : "",
Age = age,
CardNo = this.txtCardNo.Text.Trim(),
PhoneNumber = this.txtPhoneNumber.Text.Trim(),
StudentAddress = this.txtAddress.Text.Trim(),
StudentId = Convert.ToInt32(this.cboClassName.SelectedValue),
ClassId = Convert.ToInt32(this.cboClassName.SelectedValue)
};
#endregion
#region 后台调用
try
{
var studenteId = studentService.AddNewStudent(student);
if (studenteId == 1)
{
student.ClassId = studenteId;
studentList.Add(student);
this.dgvStudentList.DataSource = null;
this.dgvStudentList.DataSource = studentList;
#region endregion询问是否继续添加
DialogResult result = MessageBox.Show("学员添加成功，是否继续添加?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//清空数据
foreach (Control item in this.gbstuinfo.Controls)
{
if (item is TextBox)
{
item.Text = string.Empty;
}
}
this.cboClassName.SelectedIndex = -1;
this.rdoFemale.Checked = false;
this.rdoMale.Checked = false;
this.pbStu.Image = null;
this.txtStudentName.Focus();
}
else
{
this.Close();
}
# endregion
}
}
catch (Exception ex)
{
MessageBox.Show("添加学员出现访问异常：" + ex.Message);
}
#endregion
}