private void btnAdd_Click(object sender, EventArgs e)
{
int i = 0;
if (tbTeachCourseNo.Text.Trim().Equals(""))
{
MessageBox.Show("开课号不能为空", "提示");
tbTeachCourseNo.Focus();
return;
}
if (tbAmount.Text.Trim().Equals(""))
{
MessageBox.Show("学分不能为空", "提示");
tbAmount.Focus();
return;
}
if (tbTeacher.Text.Trim().Equals(""))
{
MessageBox.Show("学分不能为空", "提示");
tbTeacher.Focus();
return;
}
OpenCourse oc = new OpenCourse(tbTeachCourseNo.Text, cbCourseName.Text, tbTeacher.Text, int.Parse(tbAmount.Text), int.Parse(cbStartWeek.Text), int.Parse(cbEndWeek.Text));
CourseManageAction cma = new CourseManageAction();
cma.setOpenCourse(oc);
if (isUpdate == false)
{
i = cma.addOpenCourse();
if (i > 0)
{
MessageBox.Show(string.Format("增加了{0}条记录", i));
foreach (Control ctrl in groupBox2.Controls)
{
if (!(ctrl is Label))
{
ctrl.Text = "";
}
}
}
else
{
MessageBox.Show("添加不成功");
}
}
else
{
i = cma.updateOpenCourse();
if (i > 0)
{
MessageBox.Show(string.Format("更新了{0}条记录", i));
this.Close();
}
else
{
MessageBox.Show("更新不成功");
}
}
this.Close();
}
//添加一条课程记录到teachcourse表
public static int addOpenCourse(OpenCourse oc)
{
string wn = QueryWorkerNo(oc.teacher);
string cn = QuerycourseNo(oc.courseName);
string sql = " insert into teachcourse(teachcourseNo,courseNo,workerNo,amount,startWeek,endWeek) "
+ "values('" + oc.teachCourseNo + "','" + cn + "','" + wn + "','" + oc.amount + "','" + oc.startWeek + "','" + oc.endWeek + "')";
return(execNonQuery(sql));
}
private void button3_Click(object sender, EventArgs e)
{
if (lvLessons.SelectedItems.Count == 0)
{
return;
}
OpenCourse oc = CourseManageAction.QueryOpenCourseInfo(lvLessons.SelectedItems[0].SubItems[0].Text);
studentInClass SIC = new studentInClass(oc);
SIC.MdiParent = this.MdiParent;
SIC.Show();
}
private void btoRevise_Click(object sender, EventArgs e)
{
if (lvLessons.SelectedItems.Count == 0)
{
return;
}
OpenCourse oc = CourseManageAction.QueryOpenCourseInfo(lvLessons.SelectedItems[0].SubItems[0].Text);
CourseManager.OpenCourseForm ocf = new OpenCourseForm(oc);
ocf.MdiParent = this.MdiParent;
ocf.Show();
}
public studentInClass(OpenCourse oc, string role = "教务员")
{
InitializeComponent();
label5.Text = oc.teachCourseNo;
label6.Text = oc.courseName;
label7.Text = oc.teacher;
label8.Text = CourseManageAction.NumberInClass(oc.teachCourseNo).ToString() + "/" + CourseManageAction.getAmount(oc.teachCourseNo).ToString();
CourseManageAction.loadStudentInClass(lvSIC, oc.teachCourseNo);
if (role == "教师")
{
button1.Visible = false;
}
}
//更新一条记录到teachcourse表
public static int updateOpenCourse(OpenCourse oc)
{
string wn = QueryWorkerNo(oc.teacher);
string cn = QuerycourseNo(oc.courseName);
string sql = "update teachcourse set "
+ "amount='" + oc.amount
+ "',courseNo='" + cn
+ "',startWeek='" + oc.startWeek
+ "',endWeek='" + oc.endWeek
+ "',workerNo='" + wn + "'"
+ " where teachCourseNo='" + oc.teachCourseNo + "'";
return(execNonQuery(sql));
}
public OpenCourseForm(OpenCourse oc)
{
InitializeComponent();
this.Text = "修改开课";
tbTeachCourseNo.Enabled = false;
tbTeachCourseNo.Text = oc.teachCourseNo;
cbCourseName.Text = oc.courseName;
tbTeacher.Text = oc.teacher;
tbAmount.Text = oc.amount.ToString();
cbStartWeek.Text = oc.startWeek.ToString();
cbEndWeek.Text = oc.endWeek.ToString();
isUpdate = true;
btnAdd.Text = "保存修改";;
tbCourseNo.Text = CourseManageAction.QuerycourseNo(oc.courseName);
}
//根据开课号查询开课信息
public static OpenCourse QueryOpenCourseInfo(string tcNo)
{
string sql = "select teachCourseNo,courseName,workerName,amount,startWeek,endWeek from (teachcourse tc"
+ " inner join teacher t on tc.workerNo=t.workerNo)"
+ " inner join course c on c.courseNo=tc.courseNo"
+ " where teachCourseNo='" + tcNo + "'";
ArrayList ll = execQuery(sql); //调用父类方法
if (ll.Count == 0)
{
return(null);
}
object[] o = (object[])ll[0];
OpenCourse oc = new OpenCourse(o[0].ToString(), o[1].ToString(), o[2].ToString(), int.Parse(o[3].ToString()), int.Parse(o[4].ToString()), int.Parse(o[5].ToString()));
return(oc);
}
public void setOpenCourse(OpenCourse oc)
{
this.oc = oc;
}
