Example #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            //根据输入插入
            if (Regex.IsMatch(txtCourseName.Text, @"^.{5,}$") == false)
            {
                return;
            }
            T_CourseDAL  dal = new T_CourseDAL();
            SqlParameter par = new SqlParameter("@courseName", SqlDbType.VarChar)
            {
                Value = txtCourseName.Text
            };

            try
            {
                var res = (int)dal.ExecuteScalar("InsertedCourse", CommandType.StoredProcedure, par);
                if (res == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败");
            }
        }
Example #2
0
        /// <summary>
        /// 加载指定班级下的T_Course
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ComClass_SelectedIndexChanged(object sender, EventArgs e)
        {
            T_CourseDAL dal    = new T_CourseDAL();
            T_Class     @class = comClass.SelectedItem as T_Class;

            if (@class == null)
            {
                ucBtnExt2_BtnClick(null, null);
            }
            comCourse.DataSource = dal.ExecuteT_ClassSetUpCourseTeach(@class.ClassID);
        }
Example #3
0
        private List <T_InsertedFactionModel> LoadComCourseName(string stuid)
        {
            string       t_sql = "select ClassID from T_StudentBasicInformation where T_StudentBasicInformation.StuID = @stuid";
            SqlParameter pars  = new SqlParameter("@stuid", SqlDbType.Int)
            {
                Value = stu.StuID
            };
            T_CourseDAL dal     = new T_CourseDAL();
            int         classID = (int)dal.ExecuteScalar(t_sql, CommandType.Text, pars);

            return(dal.ExecuteT_ClassSetUpCourseTeach(classID));
        }
Example #4
0
        //删除客课程信息(即删除班级开课信息)
        private void OpenDeleteCourseDataInformation(object sender, EventArgs e)
        {
            //获取选择的dataGridView
            var rows = dataGridView1.SelectedRows;

            if (rows.Count == 0)
            {
                FrmDialog.ShowDialog(this, "请选择一行");
                return;
            }
            var row        = rows[0];
            var courseName = row.DataBoundItem as T_Course;

            if (courseName == null)
            {
                return;
            }
            string t_sql = "DeleClassSetUpCourse";

            SqlParameter[] par = new SqlParameter[] {
                new SqlParameter("@classid", SqlDbType.Int)
                {
                    Value = courseName.classID
                },
                new SqlParameter("@courseID", SqlDbType.Int)
                {
                    Value = courseName.CourseID
                }
            };
            T_CourseDAL dal = new T_CourseDAL();

            try
            {
                var res = (int)dal.ExecuteScalar(t_sql, CommandType.StoredProcedure, par);
                if (res == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败");
            }
            InitialCurIndexToLoades(modelID, curIndex);
        }
Example #5
0
        private void ucBtnExt1_BtnClick(object sender, EventArgs e)
        {
            if (Regex.IsMatch(txtFaction.Text, @"^^\d{1,3}\.*5{0,1}$") == false)
            {
                return;
            }
            else if (courseTeach == null)
            {
                return;
            }
            T_CourseDAL dal = new T_CourseDAL();

            SqlParameter[] pars = new SqlParameter[] {
                new SqlParameter("@courseID", SqlDbType.Int)
                {
                    Value = courseTeach.CourseID
                },
                new SqlParameter("@teachID", SqlDbType.Int)
                {
                    Value = courseTeach.TeacherID
                },
                new SqlParameter("@faction", SqlDbType.Float)
                {
                    Value = txtFaction.Text
                },
                new SqlParameter("@stuID", SqlDbType.Int)
                {
                    Value = stu.StuID
                }
            };
            try
            {
                var res = (int)dal.ExecuteScalar("InserintoCourseFaction", CommandType.StoredProcedure, pars);
                if (res == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败!请检查是否重复插入");
            }
        }
        private void ComCollege_SelectedIndexChanged(object sender, EventArgs e)
        {
            var college = comCollege.SelectedItem as T_College;
            var @class  = comCollege.SelectedItem as T_Class;
            var course  = comCollege.SelectedItem as T_Course;
            var teach   = comCollege.SelectedItem as T_Teach;

            if (college == null || @class == null || course == null || teach == null)
            {
                return;
            }
            string      t_sql = "InsertedClassSetUpCourse";
            T_CourseDAL dal   = new T_CourseDAL();

            SqlParameter[] pars = new SqlParameter[] {
                new SqlParameter()
                {
                    Value = @class.ClassID
                },
                new SqlParameter()
                {
                    Value = course.CourseID
                },
                new SqlParameter()
                {
                    Value = teach.TeachID
                }
            };
            try
            {
                var res = (int)dal.ExecuteScalar(t_sql, CommandType.StoredProcedure, pars);
                if (res == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败!请确保录入数据正确且不重复");
            }
        }
        private void ucBtnExt1_BtnClick(object sender, EventArgs e)
        {
            //保存
            if (teach == null)
            {
                return;
            }
            T_CourseDAL dal = new T_CourseDAL();

            SqlParameter[] pars = new SqlParameter[] {
                new SqlParameter("@classid", SqlDbType.Int)
                {
                    Value = course.classID
                },
                new SqlParameter("@courseid", SqlDbType.Int)
                {
                    Value = course.CourseID
                },
                new SqlParameter("@teachid", SqlDbType.Int)
                {
                    Value = teach.TeachID
                }
            };
            try {
                var res = (int)dal.ExecuteScalar("ModifyClassSetUpCourse", CommandType.StoredProcedure, pars);
                if (res == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                    course.teachID   = teach.TeachID;
                    course.TeachName = teach.TeachName;
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败!");
            }
        }
Example #8
0
        //初始加载所有课程信息(此课程信息即本学校所开设的课程)
        private void LoadInitDataGridView()
        {
            T_CourseDAL         dal  = new T_CourseDAL();
            int                 temp = curIndex;
            List <T_CourseName> res  = null;

            try
            {
                curIndex = 1;
                res      = dal.ExecuteListCourseName(curIndex, dataLength);
            }
            catch
            {
                curIndex = temp;
            }
            if (res == null)
            {
                return;
            }
            dataGridView1.DataSource          = res;
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
        }
Example #9
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            bool res = Regex.IsMatch(txtCourseName.Text, @"^.{5,}$");

            if (res == false)
            {
                return;
            }
            T_CourseDAL dal   = new T_CourseDAL();
            string      t_sql = "ModifyCourseName";

            SqlParameter[] pars = new SqlParameter[] {
                new SqlParameter("@courseID", SqlDbType.Int)
                {
                    Value = txtCourseID.Text
                },
                new SqlParameter("@courseName", SqlDbType.VarChar)
                {
                    Value = txtCourseName.Text
                }
            };
            try
            {
                int modifyRes = (int)dal.ExecuteScalar(t_sql, CommandType.StoredProcedure, pars);
                if (modifyRes == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                    course.CourseName = txtCourseName.Text;
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败");
            }
        }
Example #10
0
        /// <summary>
        /// 根据ModelID选项来设查询
        /// </summary>
        /// <returns></returns>
        private object Loades()
        {
            object      res = null;
            T_CourseDAL dal = new T_CourseDAL();

            switch (modelID)
            {
            case -1: { res = dal.ExecuteListCourseName(curIndex, dataLength); }; break;

            case 0: { res = dal.ExecuteListCourseName(curIndex, dataLength, values[0]); }; break;

            case 1:
            {
                res = dal.ExecuteT_Course(curIndex, dataLength, string.Empty, string.Empty, string.Empty);
            }; break;

            case 2: {
                res = dal.ExecuteT_Course(curIndex, dataLength, values[0], values[1], values[2]);
            }; break;

            case 3: {
                res = dal.ExecuteT_CourseFaction(curIndex, dataLength, string.Empty, string.Empty, string.Empty, string.Empty);
            }; break;

            case 4: {
                res = dal.ExecuteT_CourseFaction(curIndex, dataLength, values[0], values[1], values[2], values[3]);
            }; break;

            case 5:
            {
                res = dal.ExecuteClassStudentsCompulsoryCourseFaction(curIndex, dataLength, values[0], values[1]);
            }; break;

            default:; break;
            }
            return(res);
        }
Example #11
0
        private void ucBtnExt1_BtnClick(object sender, EventArgs e)
        {
            if (Regex.IsMatch(txtFaction.Text, @"^^\d{1,3}\.*5{0,1}$") == false)
            {
                return;
            }
            T_CourseDAL dal = new T_CourseDAL();

            SqlParameter[] pars = new SqlParameter[] {
                new SqlParameter("@faction", SqlDbType.Int)
                {
                    Value = txtFaction.Text
                },
                new SqlParameter("@id", SqlDbType.Int)
                {
                    Value = faction.ID
                }
            };
            try
            {
                var res = (int)dal.ExecuteScalar("UpdateStudentFaction", CommandType.StoredProcedure, pars);
                if (res == 1)
                {
                    FrmDialog.ShowDialog(this, "保存成功");
                    faction.Faction = float.Parse(txtFaction.Text);
                }
                else
                {
                    throw new Exception();
                }
            }
            catch
            {
                FrmDialog.ShowDialog(this, "保存失败!请检查是否重复插入");
            }
        }