예제 #1
0
        public JobListForm()
        {
            InitializeComponent();

            //그리드속성
            JobGrid.AutoGenerateColumns                = false;
            JobGrid.AllowUserToAddRows                 = false;
            JobGrid.MultiSelect                        = true;
            JobGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            JobGrid.RowHeadersWidth                    = 15;
            JobGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            JobGrid.ColumnHeadersHeight                = 30;
            JobGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            JobGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            UtilityClass.AddNewColumnToDataGridView(JobGrid, "직업코드", "job_id", true, 80);
            UtilityClass.AddNewColumnToDataGridView(JobGrid, "국문명", "job_Kname", true, 200);
            UtilityClass.AddNewColumnToDataGridView(JobGrid, "영문명", "job_Ename", true, 250);

            LoadJabData();
        }
예제 #2
0
        public MajorListForm()
        {
            InitializeComponent();

            //그리드속성
            MajorGrid.AutoGenerateColumns                = false;
            MajorGrid.AllowUserToAddRows                 = false;
            MajorGrid.MultiSelect                        = true;
            MajorGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            MajorGrid.RowHeadersWidth                    = 15;
            MajorGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            MajorGrid.ColumnHeadersHeight                = 30;
            MajorGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            MajorGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            UtilityClass.AddNewColumnToDataGridView(MajorGrid, "대분류", "high_name", true, 100);
            UtilityClass.AddNewColumnToDataGridView(MajorGrid, "중분류", "mid_name", true, 100);
            UtilityClass.AddNewColumnToDataGridView(MajorGrid, "학과이름", "major_name", true, 200);

            LoadMajorData();
        }
예제 #3
0
        private void UniversityListForm_Load(object sender, EventArgs e)
        {
            cmbFind.SelectedIndex = 0;
            //그리드속성
            UniversityGrid.AutoGenerateColumns                = false;
            UniversityGrid.AllowUserToAddRows                 = false;
            UniversityGrid.MultiSelect                        = true;
            UniversityGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            UniversityGrid.RowHeadersWidth                    = 15;
            UniversityGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            UniversityGrid.ColumnHeadersHeight                = 30;
            UniversityGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            UniversityGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            UtilityClass.AddNewColumnToDataGridView(UniversityGrid, "이름", "univ_name", true, 120);
            UtilityClass.AddNewColumnToDataGridView(UniversityGrid, "주소", "univ_address", true, 300);
            UtilityClass.AddNewColumnToDataGridView(UniversityGrid, "전화번호", "univ_phone", true, 100);
            UtilityClass.AddNewColumnToDataGridView(UniversityGrid, "홈페이지", "homepage", true, 160);

            LoadUnivData();
        }
예제 #4
0
        public ConsultListForm()
        {
            InitializeComponent();

            //그리드속성
            ConsultGrid.AutoGenerateColumns                = false;
            ConsultGrid.AllowUserToAddRows                 = false;
            ConsultGrid.MultiSelect                        = true;
            ConsultGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            ConsultGrid.RowHeadersWidth                    = 15;
            ConsultGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            ConsultGrid.ColumnHeadersHeight                = 30;
            ConsultGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            ConsultGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "이름", "std_name", true, 80);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담날짜", "consult_date", true, 100);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담내용", "consult_details", true, 250);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "피드백", "others", true, 250);

            LoadConsultData();
        }
예제 #5
0
        private void AwardForm_Load(object sender, EventArgs e)
        {
            //대학, 학과 그리드뷰 속성
            UnivMajorGrid.AutoGenerateColumns = false;
            UnivMajorGrid.AllowUserToAddRows  = false;
            UnivMajorGrid.MultiSelect         = true;
            UnivMajorGrid.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            UnivMajorGrid.RowHeadersWidth     = 10;
            UnivMajorGrid.ColumnHeadersHeight = 30;
            UnivMajorGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            UnivMajorGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            UtilityClass.AddNewColumnToDataGridView(UnivMajorGrid, "대학이름", "univ_name", true, 150);
            UtilityClass.AddNewColumnToDataGridView(UnivMajorGrid, "학과이름", "major_name", true, 200);


            txtMajorSearch.ImeMode = ImeMode.Hangul;
            txtUnivSearch.ImeMode  = ImeMode.Hangul;

            bool bCheck = false;

            VisibleControl(bCheck);
        }
예제 #6
0
        private void SchoolRecord_Load(object sender, EventArgs e)
        {
            //그리드속성
            RecordGrid.AutoGenerateColumns = false;
            RecordGrid.AllowUserToAddRows  = false;
            RecordGrid.MultiSelect         = true;
            RecordGrid.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            RecordGrid.RowHeadersWidth     = 15;
            RecordGrid.ColumnHeadersHeight = 20;
            RecordGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 9.5F);
            RecordGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 8.5F);

            UtilityClass.AddNewColumnToDataGridView(RecordGrid, "학년", "grade", true, 60);
            UtilityClass.AddNewColumnToDataGridView(RecordGrid, "학기", "semester", true, 60);
            UtilityClass.AddNewColumnToDataGridView(RecordGrid, "국어", "sch_korean", true, 100);
            UtilityClass.AddNewColumnToDataGridView(RecordGrid, "영어", "sch_english", true, 100);
            UtilityClass.AddNewColumnToDataGridView(RecordGrid, "수학", "sch_math", true, 100);
            UtilityClass.AddNewColumnToDataGridView(RecordGrid, "성적코드", "sch_recordID", false, 20);


            LoadData();
            LoadChart();
        }
예제 #7
0
        private void LoadConsultList()
        {
            ConsultGrid.AutoGenerateColumns = false;
            ConsultGrid.AllowUserToAddRows  = false;
            ConsultGrid.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            ConsultGrid.RowHeadersWidth     = 15;
            ConsultGrid.ColumnHeadersHeight = 30;
            ConsultGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            ConsultGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            ConsultGrid.DefaultCellStyle.WrapMode          = DataGridViewTriState.True;
            ConsultGrid.AutoSizeRowsMode    = DataGridViewAutoSizeRowsMode.AllCells;
            ConsultGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;

            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담번호", "consult_id", false, 10);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담날짜", "consult_date", true, 100);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담내용", "consult_details", true, 150);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "조치사항", "others", true, 150);
            ConsultInfoService service = new ConsultInfoService();

            ConsultGrid.DataSource = service.GetStudentConsult(lblStudentID.Text);
            ConsultGrid.ClearSelection();
            service.Dispose();
        }
예제 #8
0
        private void MainForm_Load(object sender, EventArgs e)
        {
            //그리드속성
            StudentGrid.AutoGenerateColumns = false;
            StudentGrid.AllowUserToAddRows  = false;
            StudentGrid.MultiSelect         = true;
            StudentGrid.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            StudentGrid.RowHeadersWidth     = 15;
            StudentGrid.ColumnHeadersHeight = 30;
            StudentGrid.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            StudentGrid.ColumnHeadersDefaultCellStyle.Font      = new Font("Segoe UI", 11.5F);
            StudentGrid.RowsDefaultCellStyle.Font = new Font("Segoe UI", 9.5F);


            UtilityClass.AddNewColumnToDataGridView(StudentGrid, "학생ID", "std_id", true, 100);
            UtilityClass.AddNewColumnToDataGridView(StudentGrid, "이름", "std_name", true, 100);
            UtilityClass.AddNewColumnToDataGridView(StudentGrid, "핸드폰번호", "std_phone", true, 150);
            UtilityClass.AddNewColumnToDataGridView(StudentGrid, "이메일", "std_mail", true, 150);

            StudentGrid.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
            StudentGrid.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;
            StudentGrid.Columns[2].SortMode = DataGridViewColumnSortMode.NotSortable;
            StudentGrid.Columns[3].SortMode = DataGridViewColumnSortMode.NotSortable;

            LoadStudentGridData();
            LoadStudentInfoData();
            LoadStudentImage();
            LoadStudentDetailInfoData();

            cmbFind.SelectedIndex  = 0;
            cmbMain1.SelectedIndex = 1;
            cmbMain2.SelectedIndex = 1;
            cmbMain3.SelectedIndex = 1;
            cmbMain1.SelectedValue = 'N';
            cmbMain2.SelectedValue = 'N';
            cmbMain3.SelectedValue = 'N';
        }
예제 #9
0
        private void LoadAwardList()
        {
            AwardGrid.AutoGenerateColumns = false;
            AwardGrid.AllowUserToAddRows  = false;
            AwardGrid.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            AwardGrid.RowHeadersWidth     = 15;
            AwardGrid.ColumnHeadersHeight = 30;
            AwardGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            AwardGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);

            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "수상코드", "award_id", false, 30);
            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "대회코드", "competition_id", false, 30);
            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "대회이름", "comp_name", true, 150);
            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "대회설명", "comp_details", true, 180);
            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "수상내역", "award_details", true, 110);
            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "날짜", "comp_date", true, 90);
            UtilityClass.AddNewColumnToDataGridView(AwardGrid, "주최", "comp_host", true, 110);
            CompetitionInfoService dac = new CompetitionInfoService();
            DataTable dt = dac.GetAwardByStudent(lblStudentID.Text);

            AwardGrid.DataSource = dt;
            AwardGrid.ClearSelection();
            dac.Dispose();
        }
예제 #10
0
        private void BtnSearch_Click(object sender, EventArgs e)
        {
            if (radiobtnSchool.Checked == true) //내신성적
            {
                if (cmbGrade.SelectedItem is null)
                {
                    MaterialMessageBox.Show("학년을 선택해주세요.", "경고", MessageBoxButtons.OK);
                    return;
                }

                if (cmbSemester.SelectedItem is null)
                {
                    MaterialMessageBox.Show("학기 선택해주세요.", "경고", MessageBoxButtons.OK);
                    return;
                }

                //성적 데이터그리드뷰
                RecordGrid.Columns.Clear();
                RecordGrid.ClearSelection();
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "이름", "std_name", true, 80);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "국어", "sch_korean", true, 100);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "영어", "sch_english", true, 100);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "수학", "sch_math", true, 100);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "평균", "avg", true, 100);
                RecordGrid.Columns[4].DefaultCellStyle.BackColor = Color.Yellow; //평균 컬럼은 노란색으로

                SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC();
                DataSet             ds  = DAC.GetSchoolRecordByScore(cmbGrade.SelectedItem.ToString(), cmbSemester.SelectedItem.ToString());
                RecordGrid.DataSource = ds.Tables[0];

                DAC.Dispose();
            }
            else if (radiobtnMock.Checked == true) //모의고사성적
            {
                if (cmbGrade.SelectedItem is null)
                {
                    MaterialMessageBox.Show("학년을 선택해주세요.", "경고", MessageBoxButtons.OK);
                    return;
                }

                if (cmbSemester.SelectedItem is null)
                {
                    MaterialMessageBox.Show("월을 선택해주세요.", "경고", MessageBoxButtons.OK);
                    return;
                }
                RecordGrid.Columns.Clear();
                RecordGrid.ClearSelection();
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "이름", "std_name", true, 70);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "국어", "sch_korean", true, 60);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "영어", "sch_english", true, 60);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "수학", "sch_math", true, 60);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "사회/과학1", "side_choice1", true, 85);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "사회/과학2", "side_choice2", true, 85);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "제2외국어", "more_foreign", true, 80);
                UtilityClass.AddNewColumnToDataGridView(RecordGrid, "평균", "avg", true, 80);
                RecordGrid.Columns[7].DefaultCellStyle.BackColor = Color.Yellow;


                SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC();
                DataSet             ds  = DAC.GetMockRecordByScore(cmbGrade.SelectedItem.ToString(), cmbSemester.SelectedItem.ToString());
                RecordGrid.DataSource = ds.Tables[0];

                DAC.Dispose();
            }
        }
예제 #11
0
        private void RecordByStudentForm_Load(object sender, EventArgs e)
        {
            //학생목록
            StudentGrid.AutoGenerateColumns                = false;
            StudentGrid.AllowUserToAddRows                 = false;
            StudentGrid.MultiSelect                        = true;
            StudentGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            StudentGrid.RowHeadersWidth                    = 15;
            StudentGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            StudentGrid.ColumnHeadersHeight                = 30;
            StudentGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            StudentGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);

            UtilityClass.AddNewColumnToDataGridView(StudentGrid, "학생ID", "std_id", true, 90);
            UtilityClass.AddNewColumnToDataGridView(StudentGrid, "이름", "std_name", true, 80);
            StudentGrid.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
            StudentGrid.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;


            //내신성적
            SchoolRecordGrid.AutoGenerateColumns                = false;
            SchoolRecordGrid.AllowUserToAddRows                 = false;
            SchoolRecordGrid.MultiSelect                        = true;
            SchoolRecordGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            SchoolRecordGrid.RowHeadersWidth                    = 15;
            SchoolRecordGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            SchoolRecordGrid.ColumnHeadersHeight                = 30;
            SchoolRecordGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 10.5F);
            StudentGrid.RowsDefaultCellStyle.Font               = new Font("Segoe UI", 10.5F);

            UtilityClass.AddNewColumnToDataGridView(SchoolRecordGrid, "학년", "grade", true, 60);
            UtilityClass.AddNewColumnToDataGridView(SchoolRecordGrid, "학기", "semester", true, 60);
            UtilityClass.AddNewColumnToDataGridView(SchoolRecordGrid, "국어", "sch_korean", true, 100);
            UtilityClass.AddNewColumnToDataGridView(SchoolRecordGrid, "영어", "sch_english", true, 100);
            UtilityClass.AddNewColumnToDataGridView(SchoolRecordGrid, "수학", "sch_math", true, 100);
            UtilityClass.AddNewColumnToDataGridView(SchoolRecordGrid, "성적코드", "sch_recordID", false, 60);

            //모의고사 성적
            MockRecordGrid.AutoGenerateColumns                = false;
            MockRecordGrid.AllowUserToAddRows                 = false;
            MockRecordGrid.MultiSelect                        = true;
            MockRecordGrid.SelectionMode                      = DataGridViewSelectionMode.FullRowSelect;
            MockRecordGrid.RowHeadersWidth                    = 15;
            MockRecordGrid.ColumnHeadersHeightSizeMode        = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            MockRecordGrid.ColumnHeadersHeight                = 30;
            MockRecordGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 10.5F);
            StudentGrid.RowsDefaultCellStyle.Font             = new Font("Segoe UI", 10.5F);

            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "학년", "grade", true, 60);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "월", "semester", true, 40);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "국어", "korean", true, 60);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "영어", "english", true, 60);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "수학", "math", true, 60);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "사회/과학1", "side_choice1", true, 90);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "사회/과학2", "side_choice2", true, 90);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "제2외국어", "more_foreign", true, 80);
            UtilityClass.AddNewColumnToDataGridView(MockRecordGrid, "모의고사코드", "mock_recordID", false, 30);


            LoadStudentGridData(); //학생정보 로드

            cmbFind.SelectedIndex = 0;
        }