private void button22_Click(object sender, EventArgs e)
{
sqlConnect cc = new sqlConnect();
string sql = "select b.开课编号hjh, a.学生编号hjh from 学生hjh a,开课hjh b where a.班级编号hjh = b.班级编号hjh";
DataSet ds = cc.GetDataSet(sql);
int synNum = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
string sql2 = "select * from 选修hjh where 开课编号hjh = '" + dr[0].ToString() + "' " +
" and 学生编号hjh = '" + dr[1].ToString() + "'";
DataSet ds2 = cc.GetDataSet(sql2);
if (ds2.Tables[0].Rows.Count == 0)
{
synNum++;
if (synNum == 1)
{
DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn();
col1.Name = "开课编号hjh";
col1.HeaderText = "开课编号hjh";
col2.Name = "学生编号hjh";
col2.HeaderText = "学生编号hjh";
dataGridView1.Columns.Clear();
dataGridView1.DataSource = null;
dataGridView1.Columns.Add(col1);
dataGridView1.Columns.Add(col2);
}
sql += " insert into 选修hjh(开课编号hjh,学生编号hjh) values( '" + dr[0].ToString() + "','" + dr[1].ToString() + "' );";
string[] row = { dr[0].ToString(), dr[1].ToString() };
dataGridView1.Rows.Add(row);
}
ds2.Dispose();
}
try
{
if (synNum != 0)
{
cc.ExecuteNonQuery(sql);
MessageBox.Show("共同步" + synNum.ToString() + "条记录！");
}
else
{
MessageBox.Show("无可同步课程！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
}
}
private void glyInfo_Load(object sender, EventArgs e)
{
sqlConnect cc = new sqlConnect();
string sql = "";
if (this.tp == "系统管理员")
{
sql = "select * from " + this.tp + "hjh" + " where 用户名hjh = '" + this.num + "'";
}
else
{
sql = "select * from " + this.tp + "hjh" + " where " + this.tp + "编号hjh = '" + this.num + "'";
}
DataSet dataset = cc.GetDataSet(sql);
DataRow dr = dataset.Tables[0].Rows[0];
if (this.tp == "系统管理员")
{
label6.Text = dr["用户名hjh"].ToString().Trim();
}
else
{
label6.Text = dr[this.tp + "编号hjh"].ToString().Trim();
}
textBox2.Text = dr["登录密码hjh"].ToString().Trim();
cc.closeConnect();
dataset.Dispose();
}
private void StudentMain_Load(object sender, EventArgs e)
{
label7.Text = this.num;
this.Text += "(学生:" + this.num + ")";
string sql = "select * from 学生视图hjh where 学生编号hjh = '" + this.num + "'";
sqlConnect cc = new sqlConnect();
try
{
DataSet ds = cc.GetDataSet(sql);
label8.Text = ds.Tables[0].Rows[0]["姓名hjh"].ToString().Trim();
label9.Text = ds.Tables[0].Rows[0]["专业名称hjh"].ToString().Trim() + "0" + ds.Tables[0].Rows[0]["班级序号hjh"].ToString().Trim();
string sql2 = "select * from 学院hjh";
SqlDataAdapter da = new SqlDataAdapter(sql2, cc.conn);
DataSet ds2 = new DataSet();
da.Fill(ds2, "学院hjh");
comboBox4.DisplayMember = "学院hjh.学院名称hjh";
comboBox4.DataSource = ds2;
comboBox4.ValueMember = "学院hjh.学院编号hjh";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}finally
{
cc.closeConnect();
}
}
private void ProfDevelopPlan_Load(object sender, EventArgs e)
{
label4.Text = this.num;
string sql = " select a.姓名hjh,c.专业名称hjh,b.班级序号hjh,a.已修学分hjh,a.平均绩点hjh,c.毕业最少学分hjh " +
" from 学生hjh a, 班级hjh b,专业hjh c " +
" where a.学生编号hjh = '" + this.num + "' and a.班级编号hjh = b.班级编号hjh " +
" and b.专业编号hjh = c.专业编号hjh ";
string sql2 = " select h.课程名称hjh,h.学分hjh,h.学时hjh,h.考核方式hjh,e.开课学期hjh,h.课程介绍hjh,g.成绩hjh,g.教学评定hjh " +
" from 学生hjh b,班级hjh c,开设hjh e,课程hjh h,选修hjh g,开课hjh k " +
" where b.学生编号hjh = '" + this.num + "' " +
" and b.班级编号hjh = c.班级编号hjh " +
" and c.专业编号hjh = e.专业编号hjh " +
" and e.课程编号hjh = h.课程编号hjh " +
" and g.学生编号hjh = b.学生编号hjh " +
" and k.班级编号hjh = c.班级编号hjh " +
" and k.课程编号hjh = h.课程编号hjh " +
" and k.开课编号hjh = g.开课编号hjh " +
" order by e.开课学期hjh ";
sqlConnect cc = new sqlConnect();
try
{
DataSet ds = cc.GetDataSet(sql);
label6.Text = ds.Tables[0].Rows[0]["姓名hjh"].ToString().Trim();
label5.Text = ds.Tables[0].Rows[0]["专业名称hjh"].ToString().Trim() + "0" + ds.Tables[0].Rows[0]["班级序号hjh"].ToString().Trim();
label23.Text = ds.Tables[0].Rows[0]["已修学分hjh"].ToString().Trim();
label24.Text = ds.Tables[0].Rows[0]["平均绩点hjh"].ToString().Trim();
label7.Text = "(毕业最少学分: " + ds.Tables[0].Rows[0]["毕业最少学分hjh"].ToString().Trim() + ")";
this.Text = ds.Tables[0].Rows[0]["专业名称hjh"].ToString().Trim() + "专业(学生:" + this.num + ")";
cc.BindDataGridView(dataGridView1, sql2);
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].ReadOnly = true;
dataGridView1.Columns[4].ReadOnly = true;
dataGridView1.Columns[5].ReadOnly = true;
dataGridView1.Columns[6].ReadOnly = true;
dataGridView1.Columns[7].ReadOnly = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("学号不能为空！");
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("姓名不能为空！");
return;
}
sqlConnect cc = new sqlConnect();
string sql = "select * from 学生hjh where 学生编号hjh = '" + textBox1.Text + "'";
DataSet ds = cc.GetDataSet(sql);
if (ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("对不起，学号已经存在！");
return;
}
if (textBox7.Text != "")
{
string sql2 = "select * from 班级hjh where 班级编号hjh = '" + textBox4.Text + "'";
ds = cc.GetDataSet(sql2);
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("对不起，班级编号不存在！");
return;
}
}
string[] row = { textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text,
textBox5.Text, textBox6.Text, textBox7.Text };
dr.Rows.Add(row);
Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox5.Text == "")
{
MessageBox.Show("开课编号不能为空！");
return;
}
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("信息不足，不可添加！");
return;
}
string sql = "select * from 开课hjh where 开课编号hjh = '" + textBox5.Text + "'";
sqlConnect cc = new sqlConnect();
DataSet ds = cc.GetDataSet(sql);
if (ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("已经存在该开课编号！");
return;
}
ds.Clear();
string sql2 = "select * from 开课hjh where 班级编号hjh = '" + textBox2.Text + "' " +
" and 课程编号hjh = '" + textBox1.Text + "'";
ds = cc.GetDataSet(sql2);
if (ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("发现该班级已经开设此课程！不能重复添加！");
return;
}
string[] row = { textBox5.Text, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text };
dataGridView1.Rows.Add(row);
}
private void StudentInfo_Load(object sender, EventArgs e)
{
sqlConnect cc = new sqlConnect();
this.Text += "(学生:" + this.num + ")";
/*
*
* select a.教师编号hjh,a.姓名hjh,a.性别hjh,a.出生年月hjh,a.联系电话hjh,
* a.学历hjh,a.职称hjh,b.学院名称hjh,a.电子邮箱hjh
* from 教师hjh a,学院hjh b
* where 教师编号hjh = '' and a.学院编号hjh = b.学院编号hjh
*
*
* */
string sql = "select 学生编号hjh,姓名hjh,性别hjh,出生年月hjh,联系电话hjh,专业名称hjh,班级序号hjh,学院名称hjh,生源地hjh" +
" from 学生视图hjh" +
" where 学生编号hjh = '" + this.num + "'";
DataSet ds = cc.GetDataSet(sql);
DataRow dr = ds.Tables[0].Rows[0];
label10.Text = dr.ItemArray[0].ToString().Trim();
label11.Text = dr.ItemArray[1].ToString().Trim();
if (dr.ItemArray[2].ToString().Trim() == "男")
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
textBox1.Text = dr.ItemArray[3].ToString().Trim();
textBox2.Text = dr.ItemArray[4].ToString().Trim();
label12.Text = dr.ItemArray[5].ToString().Trim() + "0" + dr.ItemArray[6].ToString().Trim();
label14.Text = dr.ItemArray[7].ToString().Trim();
textBox3.Text = dr.ItemArray[8].ToString().Trim();
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("请输入开课编号！");
return;
}
sqlConnect cc = new sqlConnect();
string sql2 = "select * from 开课hjh where 开课编号hjh = '" + textBox1.Text
+ "' and 教师编号hjh = '" + this.num + "'";
DataSet ds = cc.GetDataSet(sql2);
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("对不起，该课程不存在或不是您的课！");
return;
}
string sql = "select b.开课编号hjh,c.学生编号hjh,c.姓名hjh,b.成绩hjh " +
" from 选修hjh b,学生hjh c" +
" where b.开课编号hjh = '" + textBox1.Text + "'and b.学生编号hjh = c.学生编号hjh ";
try
{
cc.BindDataGridView(dataGridView1, sql);
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
}
}
private void StudentGradeResult_Load(object sender, EventArgs e)
{
label18.Text = this.jidian.ToString();
label19.Text = this.unpassed.ToString();
label20.Text = this.excellent.ToString();
string sql =
"select b.学生编号hjh,sum((g.成绩hjh-50)*h.学分hjh)/(SUM(h.学分hjh)*10) '绩点hjh'" +
" from 学生hjh b,班级hjh c,开设hjh e,开课hjh f,选修hjh g,课程hjh h,教师hjh i " +
" where " +
" b.班级编号hjh = c.班级编号hjh and c.专业编号hjh = e.专业编号hjh ";
if (this.type == "学期")
{
sql += " and e.开课学期hjh = '" + kk + "' ";
}
else if (this.type == "学年")
{
sql += " and e.开课学期hjh like '" + kk + "%' ";
}
sql += " and e.课程编号hjh = f.课程编号hjh and b.班级编号hjh = f.班级编号hjh " +
" and g.开课编号hjh = f.开课编号hjh and g.学生编号hjh = b.学生编号hjh " +
" and f.课程编号hjh = h.课程编号hjh and f.教师编号hjh = i.教师编号hjh " +
" and b.班级编号hjh = ( " +
" select b.班级编号hjh " +
" from 学生hjh a,班级hjh b " +
" where a.学生编号hjh = '" + this.num + "' and a.班级编号hjh = b.班级编号hjh ) " +
" group by b.学生编号hjh,g.成绩hjh " +
" having (g.成绩hjh >=60 and sum((g.成绩hjh-50)*h.学分hjh)/(SUM(h.学分hjh)*10) >" + this.jidian + ") ";
string sql2 =
"select b.学生编号hjh,sum((g.成绩hjh-50)*h.学分hjh)/(SUM(h.学分hjh)*10) '绩点hjh'" +
" from 学生hjh b,班级hjh c,开设hjh e,开课hjh f,选修hjh g,课程hjh h,教师hjh i " +
" where " +
" b.班级编号hjh = c.班级编号hjh and c.专业编号hjh = e.专业编号hjh ";
if (this.type == "学期")
{
sql2 += " and e.开课学期hjh = '" + kk + "' ";
}
else if (this.type == "学年")
{
sql2 += " and e.开课学期hjh like '" + kk + "%' ";
}
sql2 += " and e.课程编号hjh = f.课程编号hjh and b.班级编号hjh = f.班级编号hjh " +
" and g.开课编号hjh = f.开课编号hjh and g.学生编号hjh = b.学生编号hjh " +
" and f.课程编号hjh = h.课程编号hjh and f.教师编号hjh = i.教师编号hjh " +
" and c.专业编号hjh = ( " +
" select b.专业编号hjh " +
" from 学生hjh a,班级hjh b " +
" where a.学生编号hjh = '" + this.num + "' and a.班级编号hjh = b.班级编号hjh ) " +
" group by b.学生编号hjh,g.成绩hjh " +
" having (g.成绩hjh >=60 and sum((g.成绩hjh-50)*h.学分hjh)/(SUM(h.学分hjh)*10) >" + this.jidian + ") ";
sqlConnect cc = new sqlConnect();
try
{
DataSet ds = cc.GetDataSet(sql);
DataSet ds2 = cc.GetDataSet(sql2);
MessageBox.Show(ds.Tables[0].Rows.Count.ToString());
label21.Text = (ds.Tables[0].Rows.Count + 1).ToString();
label22.Text = (ds2.Tables[0].Rows.Count + 1).ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
}
}
private void button1_Click(object sender, EventArgs e)
{
sqlConnect cc = new sqlConnect();
string sql = "update 学生hjh set ";
int flag = 0;
if (comboBox1.Text != dgvr.Cells[3].Value.ToString().Trim() ||
textBox5.Text != dgvr.Cells[4].Value.ToString().Trim() ||
textBox6.Text != dgvr.Cells[5].Value.ToString().Trim()
)
{
string sql2 = "select 班级编号hjh from 学院hjh a, 专业hjh b ,班级hjh c where " +
" a.学院名称hjh = '" + comboBox1.Text + "' and " +
" b.专业名称hjh = '" + textBox5.Text + "' and " +
" c.班级序号hjh = " + textBox6.Text + " and " +
" a.学院编号hjh = b.学院编号hjh and " +
" b.专业编号hjh = c.专业编号hjh";
try
{
DataSet ds = cc.GetDataSet(sql2);
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("找到该学生的班级编号，学院、专业、或班级信息有误！");
return;
}
string str = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();
ds.Dispose();
sql += "班级编号hjh = '" + str + "' ";
flag = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally { }
}
if (textBox2.Text != dgvr.Cells[1].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "姓名hjh = '" + textBox2.Text + "'";
flag = 1;
}
if (textBox3.Text != dgvr.Cells[2].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "性别hjh = '" + textBox3.Text + "'";
flag = 1;
}
if (textBox7.Text != dgvr.Cells[6].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "出生年月hjh = '" + textBox7.Text + "'";
flag = 1;
}
if (textBox8.Text != dgvr.Cells[7].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "联系电话hjh = '" + textBox8.Text + "'";
flag = 1;
}
if (textBox9.Text != dgvr.Cells[8].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "已修学分hjh = " + textBox9.Text;
flag = 1;
}
if (textBox10.Text != dgvr.Cells[9].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "平均绩点hjh = " + textBox10.Text;
flag = 1;
}
if (textBox11.Text != dgvr.Cells[10].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "生源地hjh = '" + textBox11.Text + "'";
flag = 1;
}
if (textBox12.Text != dgvr.Cells[11].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "权限级别hjh = " + textBox12.Text;
flag = 1;
}
sql += " where 学生编号hjh = '" + label13.Text + "'";
try
{
if (flag == 1)
{
cc.ExecuteNonQuery(sql);
MessageBox.Show("修改成功！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("课程号不能为空！");
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("课程名称不能为空！");
return;
}
sqlConnect cc = new sqlConnect();
string sql = "select * from 课程hjh where 课程编号hjh = '" + textBox1.Text + "'";
DataSet ds = cc.GetDataSet(sql);
if (ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("对不起，课程号已经存在！");
return;
}
ds.Dispose();
if (comboBox1.Text == " ------选择------")
{
MessageBox.Show("请选择开课学院！");
return;
}
if (comboBox2.Text == " ----选择----")
{
comboBox2.Text = "";
}
if (comboBox3.Text == " ----选择----")
{
comboBox3.Text = "";
}
string sql2 = "select * from 学院hjh where 学院名称hjh = '" + comboBox1.Text + "'";
ds = cc.GetDataSet(sql2);
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("未能到该学院名称的学院编号，学院信息有误！");
return;
}
comboBox1.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();
ds.Dispose();
string str = "";
if (radioButton1.Checked)
{
str = radioButton1.Text;
}
else
{
str = radioButton2.Text;
}
string[] row = { textBox1.Text, textBox2.Text, comboBox1.Text, str,
comboBox2.Text, comboBox3.Text, textBox4.Text };
dr.Rows.Add(row);
Close();
}
private void button1_Click(object sender, EventArgs e)
{
string tp = comboBox1.Text;
string num = textBox1.Text;
string pwd = textBox2.Text;
if (tp != "教师" && tp != "学生" && tp != "系统管理员")
{
MessageBox.Show("请选择登录身份！");
return;
}
if (num == "")
{
MessageBox.Show("用户名不能为空！");
return;
}
if (pwd == "")
{
MessageBox.Show("请输入密码！");
return;
}
string strSQL = "";
if (tp == "系统管理员")
{
strSQL += "select * from 系统管理员hjh where '" + num + "' = 用户名hjh and 登录密码hjh = '" + pwd + "'";
}
else
{
strSQL += "select * from " + tp + "hjh where '" + num + "' = " + tp + "编号hjh and 登录密码hjh = '" + pwd + "'";
}
sqlConnect cc = new sqlConnect();
DataSet dataset = new DataSet();
try
{
dataset = cc.GetDataSet(strSQL);
if (dataset.Tables[0].Rows.Count == 0)
{
MessageBox.Show("密码错误，请重新登录！");
return;
}
DataRow dr = dataset.Tables[0].Rows[0];
if (dr["权限级别hjh"].ToString() == "1")
{
StudentMain frm = new StudentMain(tp, num);
frm.Show();
}
else if (dr["权限级别hjh"].ToString() == "2")
{
TeacherMain frm2 = new TeacherMain(tp, num);
frm2.Show();
}
else if (dr["权限级别hjh"].ToString() == "5")
{
SystemManage frm3 = new SystemManage(tp, num);
frm3.Show();
}
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
dataset.Dispose();
}
}
private void button1_Click(object sender, EventArgs e)
{
sqlConnect cc = new sqlConnect();
string sql = "update 教师hjh set ";
int flag = 0;
if (comboBox1.Text != dgvr.Cells[3].Value.ToString().Trim())
{
string sql2 = "select * from 学院hjh where 学院名称hjh = '" + comboBox1.Text + "'";
DataSet ds = cc.GetDataSet(sql2);
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("未能到该学院名称的学院编号，学院信息有误！");
return;
}
string str = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();
ds.Dispose();
sql += "学院编号hjh = '" + str + "' ";
flag = 1;
}
if (textBox2.Text != dgvr.Cells[1].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "姓名hjh = '" + textBox2.Text + "'";
flag = 1;
}
if (textBox3.Text != dgvr.Cells[2].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "性别hjh = '" + textBox3.Text + "'";
flag = 1;
}
if (textBox5.Text != dgvr.Cells[4].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "出生年月hjh = '" + textBox5.Text + "'";
flag = 1;
}
if (textBox6.Text != dgvr.Cells[5].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "学历hjh = '" + textBox6.Text + "'";
flag = 1;
}
if (textBox7.Text != dgvr.Cells[6].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "职称hjh = '" + textBox7.Text + "'";
flag = 1;
}
if (textBox8.Text != dgvr.Cells[7].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "电子邮箱hjh = '" + textBox8.Text + "'";
flag = 1;
}
if (textBox9.Text != dgvr.Cells[8].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "联系电话hjh = '" + textBox9.Text + "'";
flag = 1;
}
if (textBox10.Text != dgvr.Cells[9].Value.ToString().Trim())
{
if (flag == 1)
{
sql += ",";
}
sql += "权限级别hjh = " + textBox10.Text;
flag = 1;
}
sql += " where 教师编号hjh = '" + label11.Text + "'";
try
{
if (flag == 1)
{
cc.ExecuteNonQuery(sql);
MessageBox.Show("修改成功！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
this.Close();
}
}
private void button21_Click(object sender, EventArgs e)
{
sqlConnect cc = new sqlConnect();
if (comboBox10.SelectedValue == null || comboBox10.DisplayMember == null)
{
MessageBox.Show("请选择一个班级！");
return;
}
string sql = "select 开课编号hjh from 开课hjh where 班级编号hjh = '" + comboBox10.SelectedValue.ToString().Trim() + "'";
DataSet ds = cc.GetDataSet(sql);
sql = "select 学生编号hjh from 学生hjh where 班级编号hjh = '" + comboBox10.SelectedValue.ToString().Trim() + "'";
DataSet ds2 = cc.GetDataSet(sql);
int synNum = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (DataRow dr2 in ds2.Tables[0].Rows)
{
string sql2 = "select * from 选修hjh where 开课编号hjh = '" + dr[0].ToString() + "' and " +
"学生编号hjh = '" + dr2[0].ToString() + "'";
DataSet ds3 = cc.GetDataSet(sql2);
if (ds3.Tables[0].Rows.Count == 0)
{
synNum++;
if (synNum == 1)
{
DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn();
col1.Name = "开课编号hjh";
col1.HeaderText = "开课编号hjh";
col2.Name = "学生编号hjh";
col2.HeaderText = "学生编号hjh";
dataGridView1.Columns.Clear();
dataGridView1.DataSource = null;
dataGridView1.Columns.Add(col1);
dataGridView1.Columns.Add(col2);
}
sql += " insert into 选修hjh(开课编号hjh,学生编号hjh) values( '" + dr[0].ToString() + "','" + dr2[0].ToString() + "' );";
string[] row = { dr[0].ToString(), dr2[0].ToString() };
dataGridView1.Rows.Add(row);
}
ds3.Dispose();
}
}
try
{
if (synNum != 0)
{
cc.ExecuteNonQuery(sql);
MessageBox.Show("共同步" + synNum.ToString() + "条记录！");
}
else
{
MessageBox.Show("无需再次同步，该班级同学选修情况已经全部与班级开课同步！");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
cc.closeConnect();
}
}
