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();
}
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();
}
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();
}
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();
}
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);
}
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();
}
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();
}
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';
}
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();
}
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();
}
}
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;
}