private bool ValidateInput() { if (TxtCId.Text == "") //验证是否输入了班级代码 { MessageBox.Show("请输入班级号!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtCId.Focus(); return(false); } if (TxtCName.Text == "") //验证是否输入了班级名称 { MessageBox.Show("请输入班级名称!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtCName.Focus(); return(false); } if (TxtNum.Text == "") //验证是否输入了人数 { MessageBox.Show("请输入学生人数!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtNum.Focus(); return(false); } return(true); }
private void BtnCourseSave_Click(object sender, EventArgs e) { try { string ct = "SELECT Course FROM Course WHERE Course=@find"; cmd = new OleDbCommand(ct); cmd.Connection = con; cmd.Parameters.AddWithValue("@find", TxtCName.Text); cmd.Parameters["@find"].Value = TxtCName.Text; dr = cmd.ExecuteReader(); if (dr.Read()) { MessageBox.Show("CourseName Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); TxtCName.Text = ""; TxtCName.Focus(); if ((dr != null)) { dr.Close(); } return; } cmd = new OleDbCommand("INSERT INTO Course VALUES(@Course)", con); cmd.Parameters.AddWithValue("@Course", TxtCName.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Saved in Course"); TxtCName.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <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); } } }