protected void Button1_Click(object sender, EventArgs e)
{
lbl_fankui.Text = "";
string banjiid = ddl_banji.SelectedValue;
string kechengid = ddl_kecheng.SelectedValue;
string tusername = ddl_teacher.SelectedValue;
string kechengname = ddl_kecheng.SelectedItem.Text;
string banjiname = ddl_banji.SelectedItem.Text;
string txingming = ddl_teacher.SelectedItem.Text;
string teacherusername = RenkeInfo.GetTeacherusername(kechengid, banjiid);
if (teacherusername != string.Empty)
{
lbl_fankui.Text = "该课程已由" + TeacherInfo.TeacherXingMing(teacherusername) + "担任,添加任课信息失败！";
}
else
{
string sqltxt = "insert into tb_teacherrenke(teacherusername,banjiid,kechengid,begintime) values(@tusername,@banjiid,@kechengid,@begintime)";
SqlParameter[] pa = new SqlParameter[4];
pa[0] = new SqlParameter("@tusername", tusername);
pa[1] = new SqlParameter("@banjiid", banjiid);
pa[2] = new SqlParameter("@kechengid", kechengid);
pa[3] = new SqlParameter("@begintime", DateTime.Now.ToString());
if (SqlHelper.ExecuteNonQuery(SqlDal.conn, CommandType.Text, sqltxt, pa) > 0)
{
lbl_fankui.Text = banjiname + "的课程:" + kechengname + "由教师：" + txingming + "担任，添加成功！";
}
else
{
lbl_fankui.Text = banjiname + "的课程:" + kechengname + "由教师：" + txingming + "担任，添加失败！";
}
}
}
public static int GetTeacherRenke_min_kechengid(string teacherusername)//得到教师任课的最小课程id
{
DataTable dt = RenkeInfo.GetTeacherRenKeKecheng(teacherusername);
if (dt.Rows.Count > 0)
{
return(Convert.ToInt32(dt.Rows[0][1]));
}
else
{
return(-1);
}
}
protected void grv_v2renke_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
lbl_fankui.Text = "";
string renkeid = e.Keys[0].ToString();
if (RenkeInfo.IsTeacherHaveCeshi(renkeid))
{
lbl_fankui.Text = "教师已经为该班布置了测试项目，删除失败！";
e.Cancel = true;
}
if (RenkeInfo.IsTeacherHaveZuoye(renkeid))
{
lbl_fankui.Text = "教师已经为该班布置了作业，删除失败！";
e.Cancel = true;
}
}
