protected void btnCancel_Click(object sender, EventArgs e) { CourseManage cm = new CourseManage(); DataRow drr; int sum = 0; bool IsAdd = true; foreach (GridViewRow dr in gvCourse.Rows) { if (((CheckBox)dr.FindControl("cbChoose")).Checked == true) { sum += int.Parse(dr.Cells[6].Text); } if (((CheckBox)dr.FindControl("cbChoose")).Checked == true && dr.Cells[8].Text == " ") { IsAdd = cm.IsAddCourse(dr.Cells[5].Text, sum); if (IsAdd) { drr = cm.CourseChooseDt.NewRow(); drr["ID"] = 1; drr["ModuleID"] = long.Parse(dr.Cells[1].Text); drr["StudentID"] = long.Parse(ViewState["StudentID"].ToString()); cm.AddCourseChoose(drr); } } } bindDG(); }
/// <summary> /// 获取课程详细信息 /// </summary> /// <param name="courseId">课程ID</param> /// <param name="studentId">学员ID</param> /// <returns></returns> public CourseDetails GetDetails(long courseId, long studentId) { var course = new CourseManage(courseId); var details = course.ConvertToCourseDetails(studentId); return(details); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void gvCourse_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (e.CommandName == "CancelCourse") { GridViewRow drv = ((GridViewRow)(((Button)(e.CommandSource)).Parent.Parent)); CourseManage cm = new CourseManage(); DataRow dr = cm.CourseChooseDt.NewRow(); dr["ID"] = long.Parse(drv.Cells[9].Text); dr["Flag"] = 0; cm.DeleteStudentCourse(dr); bindDG(); } }
/// <summary> /// 编辑课程 /// </summary> /// <param name="courseId">课程ID</param> /// <param name="state">编辑过的资料</param> /// <returns></returns> public bool Modify(long courseId, long subjectId, string title, string image, string content, string remarks, string objective, int status) { CourseModifiedState state = new CourseModifiedState { Content = content, Image = image, Objective = objective, Remarks = remarks, Status = status, SubjectId = subjectId, Title = title }; CourseManage course = new CourseManage(courseId); return(course.ModifyTo(state)); }
/// <summary> /// 获取字段长度 /// </summary> //protected void Getfieldlongth() //{ // CourseManage cm = new CourseDll.Bll.CourseManage(); // string tableName = "Modules"; // DataTable dt = cm.GetFieldLongth(tableName); // if (dt.Rows.Count > 0) // { // modulenameL=int.Parse(dt.Rows[1]["长度"].ToString()); // xueshiL = int.Parse(dt.Rows[4]["长度"].ToString()); // startL = int.Parse(dt.Rows[5]["长度"].ToString()); // endL = int.Parse(dt.Rows[6]["长度"].ToString()); // totallong = modulenameL + xueshiL + startL + endL; // gvCourse.Columns[1].HeaderStyle.Width = (int)Math.Round((double)(modulenameL / totallong * 80)) + '%'; // gvCourse.Columns[2].HeaderStyle.Width = (int)Math.Round((double)(modulenameL / totallong * 80)) + '%'; // gvCourse.Columns[3].HeaderStyle.Width = (int)Math.Round((double)(modulenameL / totallong * 80)) + '%'; // gvCourse.Columns[4].HeaderStyle.Width = (int)Math.Round((double)(modulenameL / totallong * 80)) + '%'; // } //} #endregion #region 方法 /// <summary> /// 绑定 /// </summary> public void bindDG() { //判断当前用户是否选课 CourseManage cm = new CourseManage(); UserManage um = new UserManage(); long StudentID = um.GetOrAddUserIDByAccount(StudentNO); DataTable dt = cm.GetCourseManage(StudentID); ViewState["StudentID"] = StudentID; gvCourse.DataSource = dt; gvCourse.DataBind(); // int i = 0; int sum = 0; foreach (DataRow dr in dt.Rows) { if (dr["SCID"].ToString() != "") { i++; sum += int.Parse(dr["ClassHours"].ToString()); } } int studyHour = int.Parse(System.Configuration.ConfigurationManager.AppSettings["StudyHour"]); string des = ""; if (sum >= studyHour) { des = "您已经达到学时要求"; } else { des = "您还差" + (studyHour - sum) + "学时"; } Des.Text = "亲,您已经选择了" + i + "个模块的课程,共" + sum + "学时,本课程要求" + studyHour + "学时," + des; }
private void toolStripButton2_Click(object sender, EventArgs e) { CourseManage courseManage = new CourseManage(); courseManage.ShowDialog(); }
private void 课程管理ToolStripMenuItem_Click(object sender, EventArgs e) { CourseManage courseManage = new CourseManage(); courseManage.ShowDialog(); }
/// <summary> /// 设置课程为“禁用”状态 /// </summary> /// <param name="courseId"></param> /// <returns></returns> public bool SetDisable(long courseId) { CourseManage course = new CourseManage(courseId); return(course.SetDisable()); }
/// <summary> /// 获取课程指定状态的题目集合 /// </summary> /// <param name="courseId"></param> /// <param name="status">题目状态,为NULL时表示不限制</param> /// <returns></returns> public List <QuestionSimpleInfo> GetQuestions(long courseId, int?status = null) { var course = new CourseManage(courseId); return(course.GetQuestions(status)); }
/// <summary> /// 获取课程信息 /// </summary> /// <param name="courseId"></param> /// <returns></returns> public Course GetCourse(long courseId) { var course = new CourseManage(courseId); return(course.Course); }
/// <summary> /// 删除课程 /// </summary> /// <param name="courseId"></param> /// <returns></returns> public bool Delete(long courseId) { CourseManage course = new CourseManage(courseId); return(course.Delete()); }