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 LoadCMockhart() { chartMock.Series.Clear(); chartMock.Series.Add(new Series("Series1")); chartMock.Series.Add(new Series("Series2")); chartMock.Series.Add(new Series("Series3")); chartMock.Series.Add(new Series("Series4")); chartMock.Series.Add(new Series("Series5")); chartMock.Series.Add(new Series("Series6")); SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); DataSet ds = dac.GetMockChart(lblStudentID.Text); DataView dv = new DataView(ds.Tables[0]); //DataTable 객체를 DataSource에 지정하고 //x,y축 컬럼을 xValueMember와 YValueMember에 지정 chartMock.Series[0].Points.DataBind(dv, "grade", "korean", "Tooltip=korean"); chartMock.Series[1].Points.DataBind(dv, "grade", "english", "Tooltip=english"); chartMock.Series[2].Points.DataBind(dv, "grade", "math", "Tooltip=math"); chartMock.Series[3].Points.DataBind(dv, "grade", "side_choice1", "Tooltip=side_choice1"); chartMock.Series[4].Points.DataBind(dv, "grade", "side_choice2", "Tooltip=side_choice2"); chartMock.Series[5].Points.DataBind(dv, "grade", "more_foreign", "Tooltip=more_foreign"); chartMock.Series[0].LegendText = "국어"; chartMock.Series[1].LegendText = "영어"; chartMock.Series[2].LegendText = "수학"; chartMock.Series[3].LegendText = "사회/과학1"; chartMock.Series[4].LegendText = "사회/과학2"; chartMock.Series[5].LegendText = "제2외국어"; }
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 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 LoadChart() { chartSchool.Series.Clear(); chartSchool.Series.Add(new Series("Series1")); chartSchool.Series.Add(new Series("Series2")); chartSchool.Series.Add(new Series("Series3")); SchoolRecordInfoDAC dac = new SchoolRecordInfoDAC(); DataSet ds = dac.GetSchoolChart(lblStudentID.Text); DataView dv = new DataView(ds.Tables[0]); //DataTable 객체를 DataSource에 지정하고 //x,y축 컬럼을 xValueMember와 YValueMember에 지정 chartSchool.Series[0].Points.DataBind(dv, "grade", "korean", "Tooltip=korean"); chartSchool.Series[1].Points.DataBind(dv, "grade", "english", "Tooltip=english"); chartSchool.Series[2].Points.DataBind(dv, "grade", "math", "Tooltip=math"); chartSchool.Series[0].LegendText = "국어"; chartSchool.Series[1].LegendText = "영어"; chartSchool.Series[2].LegendText = "수학"; }
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(); } }