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);
}
}
}
