protected void btnDeleteRow_Click(object sender, EventArgs e)
{
try
{
Button button = (Button)sender;
int tcID = Convert.ToInt32(button.CommandArgument);
课表TableAdapter ta = new 课表TableAdapter();
int n = Convert.ToInt32(ta.ScalarStudentByTCID(tcID));
if (n > 0)
{
Response.Write("<script language=javascript>alert('已有学生选择该授课信息，暂无法删除！')" + "</script>");
}
else
{
课表TableAdapter ta1 = new 课表TableAdapter();
Response.Write("<script language=javascript>alert('确定删除该授课信息吗？')" + "</script>");
ta1.DeleteTC(tcID);
Response.Write("<script language=javascript>alert('删除成功！')" + "</script>");
gvTeacherCourse.DataBind();
}
}
catch (Exception)
{
Response.Write("<script language=javascript>alert('删除失败！')" + "</script>");
}
}
protected void btnSelect_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
Button button = (Button)sender;
int cID = 0;
String tID = Request.QueryString["教工号"];
String yearCode = ddlYear.SelectedValue;
String termCode = ddlTerm.SelectedValue;
cID = Convert.ToInt32(button.CommandArgument);
if (ddlYear.SelectedIndex != 0 && ddlTerm.SelectedIndex != 0)
{
v_上课表信息TableAdapter tav = new v_上课表信息TableAdapter();
int n = Convert.ToInt32(tav.ScalarTCBytidcid(cID, tID, yearCode, termCode));
if (n == 0)
{
课表TableAdapter ta = new 课表TableAdapter();
ta.InsertTeacherCourse(cID, tID, yearCode, termCode);
Response.Write("<script language=javascript>alert('添加成功')" + "</script>");
//agvTC.DataBind();
gvTeacherCourse.DataBind();
}
else
{
Response.Write("<script language=javascript>alert('添加失败，该学年学期已为该老师分配过该课程')" + "</script>");
}
}
else
{
if (ddlYear.SelectedIndex == 0 || ddlTerm.SelectedIndex == 0)
{
lblValidate.Text = "*请选择学年学期";
}
}
}
catch (System.Data.SqlClient.SqlException sqle)
{
lblMessage.Text = sqle.Message.ToString();
}
catch (Exception)
{
Response.Write("<script language=javascript>alert('选课失败！')" + "</script>");
}
}
protected void btnDelCourse_Click(object sender, EventArgs e)
{
Button button = (Button)sender;
GridViewRow gvr = (GridViewRow)button.Parent.Parent;
int courseid = Convert.ToInt32(gvDelCourse.DataKeys[gvr.RowIndex]["授课号"].ToString());
课表TableAdapter xk = new 课表TableAdapter();
int tmp = xk.deleteCourse(Convert.ToString(Session["username"]), courseid);
if (tmp > 0)
{
Response.Write("<script>alert('退课成功!')</script>");
gvDelCourse.DataBind();
gvCourseInfo.DataBind();
return;
}
else
{
Response.Write("<script>alert('退课失败，请重新选择课程!')</script>");
return;
}
}
