private void LoadPossibleMockUniv() { //그리드속성 SchoolUnivCutGrid.AutoGenerateColumns = false; SchoolUnivCutGrid.AllowUserToAddRows = false; SchoolUnivCutGrid.MultiSelect = true; SchoolUnivCutGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect; SchoolUnivCutGrid.RowHeadersWidth = 15; SchoolUnivCutGrid.ColumnHeadersHeight = 20; SchoolUnivCutGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 9.5F); SchoolUnivCutGrid.RowsDefaultCellStyle.Font = new Font("Segoe UI", 9.5F); UtilityClass.AddNewColumnToDataGridView(SchoolUnivCutGrid, "대학", "univ_name", true, 130); UtilityClass.AddNewColumnToDataGridView(SchoolUnivCutGrid, "학과", "major_name", true, 143); UtilityClass.AddNewColumnToDataGridView(SchoolUnivCutGrid, "등급컷", "cut", true, 80); SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC(); if (mockrowIndex == 0 && mockcellIndex == 0) { return; } DataSet ds = DAC.GetPossibleUnivCutLine(Convert.ToInt32(MockGrid.Rows[mockrowIndex].Cells[mockcellIndex].Value)); SchoolUnivCutGrid.DataSource = ds.Tables[0]; SchoolUnivCutGrid.ClearSelection(); DAC.Dispose(); }
private void LoadMockRecord() { //그리드속성 MockGrid.AutoGenerateColumns = false; MockGrid.AllowUserToAddRows = false; MockGrid.MultiSelect = true; MockGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect; MockGrid.RowHeadersWidth = 15; MockGrid.ColumnHeadersHeight = 20; MockGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 9.5F); MockGrid.RowsDefaultCellStyle.Font = new Font("Segoe UI", 9.5F); UtilityClass.AddNewColumnToDataGridView(MockGrid, "학년", "grade", true, 60); UtilityClass.AddNewColumnToDataGridView(MockGrid, "국어", "korean", true, 60); UtilityClass.AddNewColumnToDataGridView(MockGrid, "영어", "english", true, 60); UtilityClass.AddNewColumnToDataGridView(MockGrid, "수학", "math", true, 60); UtilityClass.AddNewColumnToDataGridView(MockGrid, "사회/과학1", "side_choice1", true, 100); UtilityClass.AddNewColumnToDataGridView(MockGrid, "사회/과학2", "side_choice2", true, 100); UtilityClass.AddNewColumnToDataGridView(MockGrid, "제2외국어", "more_foreign", true, 90); UtilityClass.AddNewColumnToDataGridView(MockGrid, "평균", "total_avg", true, 60); UtilityClass.AddNewColumnToDataGridView(MockGrid, "등급컷", "cut", true, 70); SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC(); DataSet ds = DAC.GetMockRecordAvg(lblStudentID.Text); MockGrid.DataSource = ds.Tables[0]; MockGrid.ClearSelection(); DAC.Dispose(); }
private void LoadData() { SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); DataSet ds = dac.GetAllMock(lblStudentID.Text); MockGrid.DataSource = ds.Tables[0]; dac.Dispose(); }
private void LoadUnivCutLine() { SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); DataSet ds = dac.GetUnivCutLine(lblUniversityName.Text.Trim(), lblMajorName.Text.Trim()); UnivCutGrid.DataSource = ds.Tables[0]; UnivCutGrid.ClearSelection(); dac.Dispose(); }
private void LoadRecordAvgData() { SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); DataSet ds = dac.GetMockRecordAvg(lblStudentID.Text); RecordGrid.DataSource = ds.Tables[0]; RecordGrid.ClearSelection(); dac.Dispose(); }
private void LoadSchoolData() //내신 { SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); DataSet ds = dac.GetAllSchool(lblStudentID.Text); SchoolRecordGrid.DataSource = ds.Tables[0]; dac.Dispose(); }
private void BtnDeleteRecord_Click(object sender, EventArgs e) { try { if (MaterialMessageBox.Show("삭제하시겠습니까?", "삭제확인", MessageBoxButtons.YesNo) == DialogResult.Yes) { SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); dac.DeleteSchool(RecordGrid[5, RecordGrid.CurrentRow.Index].Value.ToString()); dac.Dispose(); LoadData(); LoadChart(); } } catch (Exception err) { MessageBox.Show(err.Message); } }
private void BtnCreateRecord_Click(object sender, EventArgs e) { MockRecordInsUpForm frm = new MockRecordInsUpForm(lblStudentID.Text, lblStudentName.Text); try { if (frm.ShowDialog() == DialogResult.OK) { SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC(); DAC.InsertMock(frm.MockRecordInfo); DAC.Dispose(); MaterialMessageBox.Show("신규등록이 완료되었습니다.", "확인", MessageBoxButtons.OK); LoadData(); LoadChart(); } } catch (Exception err) { MetroFramework.MetroMessageBox.Show(this, err.Message, "경고"); } }
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(); } }