public int AddTeacherClass(Model.Teacher_Class.Teacher_Class objTClass, int iTeaId, out string strErr) //增加教师、班级、课程信息
{
strErr = "";
int iReturn = 0;
SqlCommand sqlcom = new SqlCommand();
teaId = iTeaId;
string strSql = " insert into Class_Teacher (classid,teaid,type) values(" + objTClass.ClassId + "," + teaId + ",1) ";
sqlcom.CommandText = strSql;
sqlcom.Connection = sqlCon;
try
{
sqlCon.Open();
sqlcom.ExecuteNonQuery();
iReturn = 1;
}
catch (Exception ex)
{
strErr = ex.ToString();
iReturn = 0;
}
finally
{
sqlCon.Close();
sqlcom.Dispose();
}
return(iReturn);
}
private void button1_Click(object sender, EventArgs e)
{
string strErr = "";
Model.Teacher_Course.Teacher_Course objTeCo = new Model.Teacher_Course.Teacher_Course();
Model.Teacher_Class.Teacher_Class objTeCl = new Model.Teacher_Class.Teacher_Class();
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Teacher_Course_Class.T_C_C objTCC = new Manage.Teacher_Course_Class.T_C_C(strConnection);
objTeCl.ClassId = int.Parse(cmbClassName.SelectedValue.ToString());
objTeCo.CourseId = int.Parse(cmbCourseName.SelectedValue.ToString());
if (OldClass != cmbClassName.SelectedValue.ToString() && OldCourse != cmbCourseName.SelectedValue.ToString())
{
MessageBox.Show("只能在班级和课程中修改一个");
}
else if (OldClass == cmbClassName.SelectedValue.ToString() && OldCourse == cmbCourseName.SelectedValue.ToString())
{
MessageBox.Show("班级和课程没有改变，没有修改");
this.Visible = false;
}
else
{
int iR = objTCC.JudgeClassCourse(objTeCo.CourseId, objTeCl.ClassId);
if (iR == 0)
{
MessageBox.Show("此班级的这门课程已经安排教师，请安排给其他的班级");
}
else
{
if (OldClass == cmbClassName.SelectedValue.ToString() && OldCourse != cmbCourseName.SelectedValue.ToString())
{
int iRent = objTCC.ModifyTCC1(strTeaNo, OldClassId, OldCourseId, objTeCl, objTeCo, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("修改成功");
this.Visible = false;
}
}
else if (OldCourse == cmbCourseName.SelectedValue.ToString() && OldClass != cmbClassName.SelectedValue.ToString())
{
int iRent = objTCC.ModifyTCC(strTeaNo, OldClassId, OldCourseId, objTeCl, objTeCo, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("修改成功");
this.Visible = false;
}
}
}
}
}
//修改教师所教课程，string TeaNo定义接收教师编号的变量,int OldClassid定义接收旧的班级ID的变量,int OldCourseid定义接收旧的课程ID的变量,
//Model.Teacher_Course.Teacher_Course objTCo, Model.Teacher_Class.Teacher_Class objTCl, Model.teacher.teacher objTea是模型类，
//out string strErr定义捕获错误的变量，返回值 为1则添加成功，模型类存储教师可和教师课程班级以及课程班级的相关信息，为0则返回错误提示，将错误赋给strErr。
public int ModifyTCC1(string TeaNo, int OldClassid, int OldCourseid, Model.Teacher_Class.Teacher_Class objTCl, Model.Teacher_Course.Teacher_Course objTCo, out string strErr) //只修改教师所教课程，不修改教师所教班级
{
int iRent = 0;
strErr = "";
SqlCommand sqlCom = new SqlCommand();
string strSql = "update teacher_course set courseid= " + objTCo.CourseId + " where tea_coid=(select tea_coid from teacher_course where teaid in (select teaid from teacher where teano= '" + TeaNo + "'and type=1) ";
strSql += " and courseid =" + OldCourseid + " and type =1) ";
strSql += "update class_course set courseid =" + objTCo.CourseId + " where cl_coid=( select cl_coid from class_course where classid =" + OldClassid + "and courseid =" + OldCourseid + " and type=1 ) and type=1 ";
sqlCom.CommandText = strSql;
try
{
sqlCon.Open();
sqlCom.Connection = sqlCon;
sqlCom.ExecuteNonQuery();
iRent = 1;
}
catch (Exception exErr)
{
strErr = exErr.ToString();
iRent = 0;
}
finally
{
sqlCon.Close();
sqlCom.Dispose();
}
return(iRent);
}
private void btnAddTeaEdu_Click(object sender, EventArgs e)
{
if (cmbClassName.Text == "" || cmbCourseName.Text == "" || txtTeaNo.Text == "")
{
MessageBox.Show("教师、班级和课程不能为空，请先选择");
}
else
{
string strErr = "";
DataTable objDataTable = new DataTable();
Manage.Teacher_Course_Class.T_C_C objT_C_C = new Manage.Teacher_Course_Class.T_C_C(strConnection);
Model.Teacher_Class.Teacher_Class objT_Class = new Model.Teacher_Class.Teacher_Class();
Model.Teacher_Course.Teacher_Course objT_Course = new Model.Teacher_Course.Teacher_Course();
objT_Class.ClassId = int.Parse(cmbClassName.SelectedValue.ToString());
objT_Course.CourseId = int.Parse(cmbCourseName.SelectedValue.ToString());
string strTeaNo1 = txtTeaNo.Text;
teaId = objT_C_C.GetTeaId(strTeaNo1);
int iRen = objT_C_C.JudgeTeaClassCourse(teaId, objT_Course.CourseId, objT_Class.ClassId); //判断增加的这条记录是否存在
if (iRen == 0)
{
MessageBox.Show("此记录已经存在");
}
else
{
int iR = objT_C_C.JudgeClassCourse(objT_Course.CourseId, objT_Class.ClassId); //判断此班级的这门课程是否已经安排教师
if (iR == 0)
{
MessageBox.Show("此班级的这门课程已经安排教师，请安排给其他班级");
}
else
{
int iRent = objT_C_C.AddTeacherC_C(objT_Course, objT_Class, teaId, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("添加成功");
BindDataGridView();
}
}
}
}
}
private void btnDel_Click(object sender, EventArgs e)
{
int i = dataGridView.SelectedRows.Count;
if (i == 0)
{
MessageBox.Show("请先选中你要删除的一行");
}
else
{
//if (DialogResult.Yes == MessageBox.Show("真的要删除吗？", "确认退出", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
//{
for (int j = 0; j < dataGridView.SelectedRows.Count; j++)
{
Manage.Teacher_Course_Class.T_C_C objT_C_C = new Manage.Teacher_Course_Class.T_C_C(strConnection);
Model.Teacher_Class.Teacher_Class objT_Class = new Model.Teacher_Class.Teacher_Class();
Model.Teacher_Course.Teacher_Course objT_Course = new Model.Teacher_Course.Teacher_Course();
objT_Class.ClassId = int.Parse(cmbClassName.SelectedValue.ToString());
objT_Course.CourseId = int.Parse(cmbCourseName.SelectedValue.ToString());
string strTeaNo1 = dataGridView.SelectedCells[0].Value.ToString();
teaId = objT_C_C.GetTeaId(strTeaNo1);
string strTeacherNo = dataGridView.SelectedRows[j].Cells["教师编号"].Value.ToString();
string strClassNo = dataGridView.SelectedRows[j].Cells["班级编号"].Value.ToString();
string strCourseNo = dataGridView.SelectedRows[j].Cells["课程编号"].Value.ToString();
string strErr = "";
int j1 = objT_C_C.JudgeClassCourse(strCourseNo, strClassNo, out strErr);
int j2 = objT_C_C.JudgeTeaClass(strTeacherNo, strClassNo, out strErr);
int j3 = objT_C_C.JudgeTeaCourse(strTeacherNo, strCourseNo, out strErr);
int iRent = objT_C_C.DelTCC(strTeacherNo, strClassNo, strCourseNo, out strErr);
if (j1 > 1)
{
for (int sum1 = 0; sum1 < j1 - 1; sum1++)
{
int iRent1 = objT_C_C.AddClassCourse(objT_Course, objT_Class, teaId, out strErr);
if (iRent1 == 0)
{
MessageBox.Show(strErr);
return;
}
}
}
if (j2 > 1)
{
for (int sum2 = 0; sum2 < j2 - 1; sum2++)
{
int iRent2 = objT_C_C.AddTeacherClass(objT_Class, teaId, out strErr);
if (iRent2 == 0)
{
MessageBox.Show(strErr);
return;
}
}
}
if (j3 > 1)
{
for (int sum3 = 0; sum3 < j3 - 1; sum3++)
{
int iRent3 = objT_C_C.AddTeacherCourse(objT_Course, teaId, out strErr);
if (iRent3 == 0)
{
MessageBox.Show(strErr);
return;
}
}
}
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
BindDataGridView();
}
MessageBox.Show("删除成功");
}
//}
}
