private void cbb_Term_SelectedIndexChanged(object sender, EventArgs e) { BLL.TERM_INFO termBll = new BLL.TERM_INFO(); Model.TERM_INFO termMdl = new Model.TERM_INFO(); termMdl = termBll.GetModel(this.cbb_Term.Properties.Items[this.cbb_Term.SelectedIndex].ToString()); init_workflow(termMdl.TERMNO); }
/// <summary> /// 读取数据 /// </summary> private void readData() { if (this._termno > 0) { BLL.TERM_INFO termBll = new BLL.TERM_INFO(); Model.TERM_INFO termMdl = new Model.TERM_INFO(); termMdl = termBll.GetModel(_termno); if (termMdl == null) //新增学期功能时 { blankData(); } else //修改学期功能时 { this.te_termname.Text = termMdl.TERMNAME; this.dt_begintime.Text = termMdl.BEGINTIME.ToString(); this.dt_endtime.Text = termMdl.ENDTIME.ToString(); if (termMdl.FLAG == 0) { this.cbb_flag.Text = "非当前学期"; } else { this.cbb_flag.Text = "当前学期"; } } } }
/// <summary> /// 保存方法 /// </summary> /// <returns></returns> private bool saveData() { try { BLL.TERM_INFO termBll = new BLL.TERM_INFO(); Model.TERM_INFO termMdl = new Model.TERM_INFO(); if (this.te_termname.Text == "") { MessageBox.Show("学期名称不能为空!", "提示信息"); return(false); } if (dt_begintime.Value >= dt_endtime.Value) { MessageBox.Show("起始时间不能大于截止日期!", "提示信息"); return(false); } if (cbb_flag.Text == "") { MessageBox.Show("学期标志不能为空!", "提示信息"); return(false); } if (this._enumStatus == StatusClass.AddNew) //新增学期 { termMdl.TERMNAME = te_termname.Text; termMdl.BEGINTIME = Student.DBUtility.ToolHelper.ConvertToDateTime(dt_begintime.Value); termMdl.ENDTIME = Student.DBUtility.ToolHelper.ConvertToDateTime(dt_endtime.Value); if (cbb_flag.Text == "当前学期") { termMdl.FLAG = 1; } else { termMdl.FLAG = 0; } termBll.Add(termMdl); return(true); } else if (this._enumStatus == StatusClass.Edit) //修改信息 { termMdl.TERMNO = this._termno; termMdl.TERMNAME = te_termname.Text; termMdl.BEGINTIME = Student.DBUtility.ToolHelper.ConvertToDateTime(dt_begintime.Value); termMdl.ENDTIME = Student.DBUtility.ToolHelper.ConvertToDateTime(dt_endtime.Value); termBll.Update(termMdl); return(true); } return(true); } catch (Exception exception) { MessageBox.Show("保存失败!", exception.Message); return(false); } }
/// <summary> /// 增加数据方法 /// </summary> private void Add() { int termno, teacherno, workflowno; if (this.cbb_teacher.SelectedIndex == -1) { MessageBox.Show("请选择指导教师!", "提示信息"); return; } BLL.STUDENT_INFO studentBll = new BLL.STUDENT_INFO(); BLL.TERM_INFO termBll = new BLL.TERM_INFO(); Model.TERM_INFO termMdl = new Model.TERM_INFO(); BLL.WORKFLOW workflowBll = new BLL.WORKFLOW(); Model.WORKFLOW workflowMdl = new Model.WORKFLOW(); BLL.TEACHER_INFO teacherBll = new BLL.TEACHER_INFO(); Model.TEACHER_INFO teacherMdl = new Model.TEACHER_INFO(); BLL.TEA_STU teastuBll = new BLL.TEA_STU(); Model.TEA_STU teastuMdl = new Model.TEA_STU(); termMdl = termBll.GetModel(this.cbb_term.Properties.Items[this.cbb_term.SelectedIndex].ToString()); termno = termMdl.TERMNO; workflowMdl = workflowBll.GetModel(this.cbb_workflow.Properties.Items[this.cbb_workflow.SelectedIndex].ToString()); workflowno = workflowMdl.WORKFLOWNO; teacherMdl = teacherBll.GetModel(this.cbb_teacher.Properties.Items[this.cbb_teacher.SelectedIndex].ToString()); teacherno = teacherMdl.TEACHERNO; teastuMdl.TEACHERNO = teacherno; teastuMdl.TERMNO = termno; teastuMdl.WORKFLOWNO = workflowno; //获取所选学生学号列表 this.lstCheckedStudentNo.Clear(); if (this.tl_student.Nodes.Count > 0) { foreach (TreeListNode root in tl_student.Nodes) { GetCheckedStudentNo(root); } } //将所选学生插入该教师所指导学生列表中 string idStr = string.Empty; foreach (string stuno in lstCheckedStudentNo) { teastuMdl.STUNO = stuno; teastuBll.Add(teastuMdl); } //显示更新数据 readData(2); }
/// <summary> /// 初始化学期列表 /// </summary> private void init_term() { Student.BLL.TERM_INFO termBll = new BLL.TERM_INFO(); DataSet ds = termBll.GetAllList(); this.cbb_Term.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; cbb_Term.Properties.Items.Clear(); cbb_Term.EditValue = null; cbb_Term.Properties.NullText = "--请选择--"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string termName = ds.Tables[0].Rows[i]["TERMNAME"].ToString(); this.cbb_Term.Properties.Items.Add(termName); } }
/// <summary> /// 读取数据 /// </summary> private void readData(int flag) { int termno, teacherno, workflowno; BLL.STUDENT_INFO studentBll = new BLL.STUDENT_INFO(); BLL.TERM_INFO termBll = new BLL.TERM_INFO(); Model.TERM_INFO termMdl = new Model.TERM_INFO(); BLL.WORKFLOW workflowBll = new BLL.WORKFLOW(); Model.WORKFLOW workflowMdl = new Model.WORKFLOW(); BLL.TEACHER_INFO teacherBll = new BLL.TEACHER_INFO(); Model.TEACHER_INFO teacherMdl = new Model.TEACHER_INFO(); termMdl = termBll.GetModel(this.cbb_term.Properties.Items[this.cbb_term.SelectedIndex].ToString()); termno = termMdl.TERMNO; workflowMdl = workflowBll.GetModel(this.cbb_workflow.Properties.Items[this.cbb_workflow.SelectedIndex].ToString()); workflowno = workflowMdl.WORKFLOWNO; //初始化学生列表 this.tl_student.DataSource = studentBll.GetStudentNodeList(termno, workflowno).Tables[0]; this.tl_student.KeyFieldName = "nodeid"; this.tl_student.ParentFieldName = "parentid"; this.tl_student.Columns["nodename"].Caption = "学生列表"; //初始化教师指导学生列表 string condition = ""; condition += " and D.TERMNO = '" + termno.ToString() + "' "; condition += " and E.WORKFLOWNO = '" + workflowno.ToString() + "' "; if (flag == 2) { teacherMdl = teacherBll.GetModel(this.cbb_teacher.Properties.Items[this.cbb_teacher.SelectedIndex].ToString()); teacherno = teacherMdl.TEACHERNO; condition += " and C.TEACHERNO = '" + teacherno.ToString() + "' "; } BLL.TEA_STU teastuBll = new BLL.TEA_STU(); this.gridControl1.DataSource = teastuBll.GetList(condition).Tables[0]; this.gridView1.BestFitColumns(); DBUtility.ToolHelper.DrawRowIndicator(gridView1, 50); DBUtility.ToolHelper.SetLineColorofGridView(this.gridView1); }