public int stu_choose_course_insert(choose_course choo1)
{
conn.Open();
comm = new SqlCommand("stu_choose_course_insert", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@course_id", choo1.Course_id);
comm.Parameters.AddWithValue("@student_id", choo1.Stu_id);
comm.Parameters.AddWithValue("@stu_name", choo1.stu_name);
comm.Parameters.AddWithValue("@course_name", choo1.Course_name);
comm.Parameters.AddWithValue("@student_grade", choo1.Student_grade);
comm.Parameters.AddWithValue("@course_year", choo1.course_year);
int result = comm.ExecuteNonQuery();
conn.Close();
return(result);
}
private void button6_Click(object sender, EventArgs e)
{
try
{
int flag = 0;
int item = dataGridView1.CurrentRow.Index;
string str1 = dataGridView1.Rows[item].Cells[0].Value.ToString();
string str2 = dataGridView1.Rows[item].Cells[1].Value.ToString();
string str3 = dataGridView1.Rows[item].Cells[2].Value.ToString();
choose_course choo1 = new choose_course();
choo1.Course_id = str1;
choo1.Stu_id = bb;
choo1.stu_name = ss;
choo1.Course_name = str2;
choo1.Student_grade = "-1";
choo1.course_year = str3;
DAL dal = new DAL();
DataSet ds1 = new DataSet();
ds1 = dal.stu_choose_getbystu_id(bb);
for (int i = 0; i < ds1.Tables["ct"].Rows.Count; i++)
{
if (ds1.Tables["ct"].Rows[i][0].ToString() == str2)
{
MessageBox.Show("此课程已在您需要学习的课程中，请添加其他课程");
flag = 1;
break;
}
}
if (flag == 0)
{
if (dal.stu_choose_course_insert(choo1) > 0)
{
MessageBox.Show("此课程已成功添加到您要学习的课程中，请进入课程信息查看");
}
else
{
MessageBox.Show("添加课程失败，请重新选中添加");
}
}
}
catch (Exception ee)
{ MessageBox.Show(ee.Message); }
}
