//根据学号查询 private void btnQueryById_Click(object sender, EventArgs e) { if (this.txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入学号!", "提示信息"); this.txtStudentId.Focus(); return; } //进一步验证学号必须是数字(请使用正则表达式...) if (!Common.DataValidate.IsInteger(this.txtStudentId.Text.ToString())) { MessageBox.Show("输入的学号必须为数字!", "提示信息"); this.txtStudentId.Focus(); return; } //执行查询 StudentExt objStudent = objStuService.GetStudentById(this.txtStudentId.Text.Trim()); if (objStudent == null) { MessageBox.Show("学员信息不存在!", "提示信息"); this.txtStudentId.Focus(); } else { //在学员详细信息窗体显示 FrmStudentInfo objFrmStuInfo = new FrmStudentInfo(objStudent); objFrmStuInfo.Show(); } }
//根据学号查询 private void btnQueryById_Click(object sender, EventArgs e) { //数据验证 if (this.txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入查询学号!", "提示信息"); this.txtStudentId.Focus(); return; } if (!Common.DataValidate.IsInteger(this.txtStudentId.Text.Trim())) { MessageBox.Show("学号必须是整数!", "提示信息"); this.txtStudentId.SelectAll(); this.txtStudentId.Focus(); return; } Student objStudent = objStuService.GetStudentById(this.txtStudentId.Text.Trim()); if (objStudent == null) { MessageBox.Show("学员信息不存在!", "查询提示"); this.txtStudentId.Focus(); } else { //显示学员详细信息 FrmStudentInfo objFrm = new FrmStudentInfo(objStudent); objFrm.Show(); } }
//双击查看学员详情 private void dgvStudentList_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (this.dgvStudentList.CurrentRow != null) { string studentId = this.dgvStudentList.CurrentRow.Cells["StudentId"].Value.ToString(); Student objStudent = objStuService.GetStudentById(studentId); FrmStudentInfo objFrm = new FrmStudentInfo(objStudent); objFrm.Show(); } }
//双击选中的学员对象并显示详细信息 private void dgvStudentList_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { StudentService studentService = new StudentService(); int stuId = int.Parse(this.dgvStudentList.CurrentRow.Cells[0].Value.ToString()); Student student = null; student = studentService.GetStudentById(stuId); FrmStudentInfo info = new FrmStudentInfo(student); info.Show(); }
//根据学号查询 private void btnQueryById_Click(object sender, EventArgs e) { if (txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入要查询的学号!", "查询提示:"); return; } StudentExt objStudent = objStudnetService.GetStudentByStuID(txtStudentId.Text.Trim()); FrmStudentInfo studentInfo = new FrmStudentInfo(objStudent); studentInfo.Show(); }
//Ë«»÷Ñ¡ÖеÄѧԱ¶ÔÏó²¢ÏÔʾÏêϸÐÅÏ¢ private void dgvStudentList_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (this.dgvStudentList.CurrentRow == null) { return; } string studentId = this.dgvStudentList.CurrentRow.Cells["StudentId"].Value.ToString(); try { Student objStudent = objStudentService.GetStudentByStudentId(studentId); FrmStudentInfo frmStudentInfo = new FrmStudentInfo(objStudent); frmStudentInfo.Show(); } catch (Exception ex) { MessageBox.Show("数据库操作错误,错误信息:" + ex.Message, "提示信息"); } }
/// <summary> /// 根据学号精确查找学员 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnQueryById_Click(object sender, EventArgs e) { if (this.txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入您要查询的学号!", "提示信息"); return; } var studentId = Convert.ToInt32(this.txtStudentId.Text.Trim()); StudentExt result = studentService.QueryStudentByStudengtId(studentId); if (result == null) { MessageBox.Show($"没有学号为{studentId}的学生,请输入正确的学号!", "提示信息"); return; } else { FrmStudentInfo frmStudentInfo = new FrmStudentInfo(result); frmStudentInfo.Show(); } }
//search by student Id private void btnQueryById_Click(object sender, EventArgs e) { if (this.txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("The Student Id can not be null!", "Warning"); this.txtStudentId.Focus(); return; } Student objStu = objStuService.GetStudentById(this.txtStudentId.Text.Trim()); if (objStu == null) { MessageBox.Show("The student is not exist!", "Warning"); } else { FrmStudentInfo frmStuInfo = new FrmStudentInfo(objStu); frmStuInfo.Show(); } }
private void btnQueryById_Click(object sender, EventArgs e) { if (this.txtStudentId.Text.Length == 0) { MessageBox.Show("Please entry the StudentID"); this.txtStudentId.Focus(); return; } StudentExt objStudentExt = objStudentService.GetStudentByStudentId(Convert.ToInt32(this.txtStudentId.Text.Trim())); if (objStudentExt == null) { MessageBox.Show("This studentd not exist !"); this.txtStudentId.Focus(); return; } else { FrmStudentInfo objFrmStudentInfo = new FrmStudentInfo(objStudentExt); objFrmStudentInfo.Show(); } }
//根据学号查询 private void btnQueryById_Click(object sender, EventArgs e) { if (this.txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入要查询的学号", "查询提示"); this.txtStudentId.Focus(); return; } //根据学号查询学员对象 StudentExt objStudent = objStudentSerive.GetStudentByStuId(this.txtStudentId.Text.Trim()); if (objStudent == null) { MessageBox.Show("您输入的学号不正确,未找到该学员信息", "查询提示"); this.txtStudentId.Focus(); this.txtStudentId.SelectAll(); } else { //创建学员信息显示窗体 FrmStudentInfo objStudentForm = new FrmStudentInfo(objStudent); objStudentForm.Show(); } }
//根据学号查询 private void btnQueryById_Click(object sender, EventArgs e) { #region 数据验证 //学号是否为空 if (this.txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入学号!", "提示信息"); this.txtStudentId.Focus(); return; } //学号是否为整数 if (!Common.DataValidate.IsInteger(this.txtStudentId.Text.Trim())) { MessageBox.Show("学号必须是正整数!", "提示信息"); this.txtStudentId.SelectAll(); this.txtStudentId.Focus(); return; } //学号是否存在-查找数据是否存在学号 Student objStudent = objStuService.GetStudentsById(this.txtStudentId.Text.Trim()); //判断是否为空 if (objStudent == null) { MessageBox.Show("学员信息不存在!", "提示信息"); this.txtStudentId.Focus(); return; } #endregion #region 数据交互 FrmStudentInfo frmStudentInfo = new FrmStudentInfo(objStudent); frmStudentInfo.Show(); #endregion }
//¸ù¾ÝѧºÅ²éѯ private void btnQueryById_Click(object sender, EventArgs e) { if (txtStudentId.Text.Trim().Length == 0) { MessageBox.Show("请输入学号", "提示信息"); return; } if (!Common.DataValidate.IsInteger(txtStudentId.Text.Trim())) { MessageBox.Show("请输入数字学号", "提示信息"); txtStudentId.SelectAll(); txtStudentId.Focus(); return; } try { Student objStudent = objStudentService.GetStudentByStudentId(txtStudentId.Text.Trim()); stuList = new List <Student>(); if (objStudent == null) { MessageBox.Show("学员信息不存在", "查询提示"); this.txtStudentId.Focus(); this.txtStudentId.SelectAll(); return; } else { FrmStudentInfo frmStudentInfo = new FrmStudentInfo(objStudent); frmStudentInfo.Show(); } } catch (Exception ex) { MessageBox.Show("数据库操作错误,错误信息:" + ex.Message, "提示信息"); } }