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; } }