private bool ValidateInput() { if (TxtTcId.Text == "") { MessageBox.Show("请输入教师号", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtTcId.Focus(); return(false); } if (TxtLoPwd.Text == "") { MessageBox.Show("请输入密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtLoPwd.Focus(); return(false); } if (TxtLoAgainPwd.Text == "") { MessageBox.Show("请输入密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtLoAgainPwd.Focus(); return(false); } if (!(TxtLoPwd.Text == TxtLoAgainPwd.Text)) { MessageBox.Show("两次输入密码不一致", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtLoAgainPwd.Focus(); return(false); } if (TxtTcName.Text == "") { MessageBox.Show("请输入姓名", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtTcName.Focus(); return(false); } if (CboDep.Text == "") { MessageBox.Show("请输入系部名", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboDep.Focus(); return(false); } if (CboName.Text == "") { MessageBox.Show("请输入所授课程", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboName.Focus(); return(false); } return(true); }
/// <summary> /// 专业管理部分 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnAdd_Click(object sender, EventArgs e) { if (TxtCId.Text == "") { MessageBox.Show("请输入专业号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtCId.Focus(); } else if (TxtCName.Text == "") { MessageBox.Show("请输入专业名称!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtCName.Focus(); } else if (CboDep.Text == "") { MessageBox.Show("请选择所在院系!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboDep.Focus(); } else { try { string sql1 = string.Format("select depID from tbdepartment where depname='{0}'", CboDep.Text); if (DBHelper.conn.State == ConnectionState.Open) { DBHelper.conn.Close(); DBHelper.conn.Open(); } else if (DBHelper.conn.State == ConnectionState.Closed) { DBHelper.conn.Open(); } SqlCommand command = new SqlCommand(sql1, DBHelper.conn); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Status.sql = (string)reader["depID"]; } DBHelper.conn.Close(); string sql = string.Format("insert into tbclass(classID,classname,depId) values('{0}','{1}','{2}')", TxtCId.Text, TxtCName.Text, Status.sql); DBHelper.conn.Open(); SqlCommand cmd = new SqlCommand(sql, DBHelper.conn); int result1 = cmd.ExecuteNonQuery(); if (result1 < 1) { MessageBox.Show("添加失败!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); DBHelper.conn.Close(); } else { MessageBox.Show("添加成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); DBHelper.conn.Close(); this.ViewInfo1(); } } catch (Exception ex) { MessageBox.Show("数据库操作出错:" + ex.Message, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }